I got the SQL Server versions difference() and soundex() working in just a few tries. I am working on the oracle kind using contains() with a ! modifier in front of the value your searching against. Oracle 8i The Complete Reference (Oracle Press) has a nice section on all different kinds of advance searches. Turns out you can even do thesauri searches, to look for similar meanings. Crazy huh?
Tim -----Original Message----- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:39 PM To: CF-Community Subject: SQL Sounds Like Matching I have a feeling I am going to be working on this one for a while... One of my more demanding clients is asking for a name matching solution on the cheap. What it needs to do is find where a name 'sounds like' another name, even if it is in another language (including Middle Eastern and Oriental names). In addition, I need to be able to eliminate false positives wherever possible, in order to come up with the most consise list of matches. I really don't know where to start. SQL Server and Oracle both offer soundex support, which I suppose could be used to generate some values for comparisons. But I am not sure how this would work when different languages come into play. Does anyone have / know of any books / resources / advice on how to do this? M ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
