My thanks to both Grant and Michael for these comments and the advice.
I agree completely with the points made regarding the importance of a good structured database, unfortunately this doesn't help when you are looking after a database you did not design.
I will try working with soundex and will report back anything that looks remotely like success.