SoundexSimple ( text )
Create Soundex code
Average rating: 4.1 (39 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
With genealogy there are a couple systems to quickly compare two names. Here is the algorithm for the SimpleSoundex. This is the more common one.
Apr 4, 2012
I tested this function, and it works well. I note that the output seems to be limited to a string of 4 characters - 1 Letter plus 3 digits. But a code of that length does not distinguish between certain names, eg:
Manfred = M516, and
Manfredjen = M516 and
Manfredjensendon = M516.
Is this a limitation of the algorithm or this particular implementation?
Apr 5, 2012
|Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English. The three names mentioned are sounding somewhat the same, thus generate the same soundex. Try googling the word for more background.|
Apr 7, 2012
|Thanks for the tip. I suppose I could have googled that myself & figured it out. The wikipedia ARTIcle also mentioned the Metaphone algorithm. It seems more suitable to my needs. There is an FMP custom function implementing it, also available on this website.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.