I am looking for a good way, either VBA or SQL that I can use to find similar values in a Name field. For example, if I give the entry 'John Smith', I would like to find not only all entries with the string John Smith, but also Jon Smith and John Smyth. By the same token, I would like to return complete name subsets that exist. Thus someone only listed as John would be returned by the search, and 'The United States of America' would return records named 'The United States" etc.

Other than going in ans doing searches brute-force style by replacing characters with wild-cards, I can't see how to do this. Can anyone give me any ideas?