To assist you in your never-ending quest for perfection, Bill (a journey upon which I am, of course, a fellow traveller), you may like to consider the Soundex( ) function found in xBASE languages, MySQL, and possibly others as well (for all I know).
In xBASE (dBASE, Foxpro et al
) a string comparison using Soundex( ) takes the form:-
? SOUNDEX("Dinamap") = SOUNDEX("DynaMap")
Here are some results:-
? SOUNDEX("Dinamap") = SOUNDEX("Dynomap") gives TRUE
? SOUNDEX("Dinamap") = SOUNDEX("Dino-Map") gives TRUE
? SOUNDEX("Dinamap") = SOUNDEX("Diner-map") gives TRUE
? SOUNDEX("Dinamap") = SOUNDEX("DynaRod") gives FALSE
Here is the blurb:-
SOUNDEX( ) returns a four-character string. By comparing the results SOUNDEX( ) returns for two character expressions, you can determine if the two expressions are phonetically similar, indicating that they sound alike. This can be useful when searching for duplicate records in a database table. SOUNDEX( ) isn't case sensitive and generally disregards vowels.
So, there you are!
If this is the sort of thing that "floats your boat" (as they say), you may also want to look up the DIFFERENCE( ) function as well. DIFFERENCE( ) returns a digit in the range 0 to 4 depending upon the "closeness" (in phonetic terms) of the two strings being compared.