Finding LIKE records

[Suzette]

I am trying to figure out a way (which I am hoping isn't impossible) to use
a SQL statement to find records that are "similar" to a value.

Example

John R Smith

I want to find the records with the following information in the name field:
John Smith
John S Smith
J Smith
John Smith MD.

This cannot be broken into separate fields (ie: First Last MI). I am
working with an import function where my user is getting a table of records
in Word Perfect format. Each entire address is in a "cell" with line breaks
for Name, Address, Address, Address. My code puts the information into an
Access table. The issue is we are attempting to make sure that a record
isn't duplicated. Alas, it get's trickier. For instance. John R Smith
used to reside at 123 Anywhere ST. The new import has him as John Smith at
432 Home Ave. I want to stop the import for user input if this issue
arises. So far, I can get it to stop if it's the same... John R Smith and
John R Smith but haven't quite figured out how to get it to do it if it's
anything else. I also need to list ALL of the partial matches.

Thanks

Suzette