Well there's Daitch-Mokotoff Soundex which adds better support for Hebrew. http://www.avotaynu.com/soundex.html
----- Original Message ----- From: "Haggerty, Mike" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 8:33 AM Subject: RE: SQL Name Sounds Like Matching > Matthew; > > Yeah, I'd like to give them the standard with no customization, period. > Something tells me that's not going to happen. > > Youre message is very helpful. I hadn't thought about using Verity for this, > but typo support would be great. > > My only issue with Soundex is with foreign names, and I can expect over a > million of them from over 50 countries. Is there a way (meaning, has anyone > already worked this out somehow) of compensating for international > variations in pronounciation? Do you know of a cyrillic version of soundex? > Something that does Greek, Russian, Hebrew? > > > Thanks, > M > > -----Original Message----- > From: Matthew Walker [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 27, 2003 3:20 PM > To: CF-Talk > Subject: Re: SQL Name Sounds Like Matching > > > You say "on the cheap." Well that means they get whatever's standard with no > customisation, right? That's what soundex is. It may not be great, but it's > certainly easy. Demanding clients with a tight budget really need to be > dealt with firmly. They're business killers. > > The thing is that phonetic tokenisation algorithms are language based, i.e. > soundex is designed to work for English. However, it would be by far the > easiest to implement. There's a udf here: http://cflib.org/udf.cfm?ID=39 . > There are a few variations on Soundex which could be investigated. There's > also metaphone which is a bit more complex to implement. I would store the > soundex code for each name in the database, with an index on this column, > and then use the soundex code of the input data as the search key. In this > way it will be just as quick as a regular search and you can do it whether > or not the dbms supports Soundex. Combined with regular searching perhaps > with typo support from verity, and that would have to be way more than a > budget client could expect. > > Matthew Walker > Electric Sheep Web > http://www.electricsheep.co.nz/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
