SQL Update conservating actual data

I have a Column named 'Complete name' I need to update people with any last name 'Smiht' to 'Smith' without losing the name and the second last name.

For example, now I have:

John Smiht G.

Sarah Connor Smiht

John Ford Connor

James Smiht Ford

And the result of update has to be the same data but with Smiht being replaced to Smith:

John Smith G.

Sarah Connor Smith

John Ford Connor

James Smith Ford

Thanks!