Messy data is one of the biggest headaches you can have to deal with in a database. There are no simple, fool proof solutions. Not only do you have the issues you have described, but there also will be cases where the names may match but be the names of different individuals.
Best approach, that I can think of would be to use the "contains text" search portal method illustrated in this demo file:https://www.dropbox.com/s/0pm1gdqcfi2ndpv/EnhancedValueSelection.fp7
You can type in some text such as ORL
and get a list of possible matches such as City or Orlando, Orlando, Orly... from which you can click to choose a specific match.
If you are using FileMaker 12 or newer, use Open from FileMaker's File menu to open this file and convert a copy to the newer .fmp12 file format.
Thank you, Phil. I will study the sample to accommodate it to my needs. You are a life saver, I really appreciate the time you take to respond.