Fuzzy matches

[Morley Chalmers]

I need to prevent users from assuming the company record they want to create isn't already in the database. An exact match of proposed company name to company name won't cut it.

Am I correct the way to do this kind of check is a calc field that tests for common mis-spellings and other common user errors and use that for a match? Or is there a better technique?

Much appreciated.

[comment]

These might help (or not):

http://fmforums.com/forum/showtopic.php?tid/192563/

http://fmforums.com/forum/showtopic.php?tid/198252/

http://fmforums.com/forum/showtopic.php?tid/147438/