Code or formula to compare text strings to find those that are similar but not exact

I have a large list of names and addresses to compare and match. Name in M, W and Z and Address in R and Y. The following formula works great, however it kicks out as a No Match things like John Smith, MD vs John Smith and 415 Anywhere St. vs 415 Anywhere Street. Also I discovered that columns M and R are more truncated, and sometimes cut off the last few letters.

Please Login or Register  to view this content.

I would like to be able to differentiate the no match from those that are similar, where the only real difference is things like abbreviations or titles. Is there a way to add to the above formula so that it would give a response of Similar Name or Similar Address if the strings were close, (such as in the examples given above)?

Or if it could be done, (but not within the above formula), would it be possible to compare all the ones that returned No Match to see which were similar?

Is there a formula or VB code that could do this? Any help would be greatly appreciated.