> Does anyone know of a tool (SQL or CFML) similar to SQL's DIFFERENCE ( > http://msdn.microsoft.com/en-us/library/ms188753.aspx) but with > significantly higher fidelity. > > When strings get up around 15 characters, DIFFERENCE will return 4 > (closest > possible match) for exact matches and also for some "matches" where > it's > difficult for me to even see the similarities. I need something > that'll > return, say, 100 for exact matches, 50 for "half matches," etc.
I actually use a combination of SQL DIFFERENCE and a Levenshtein distance between the original strings rather than just SQL DIFFERENCE which works on the Soundex of the original strings. It does mean you have to code it in CF rather than in rely on the DB entirely but for me the results are worth it. http://www.cflib.org/index.cfm?event=page.udfbyid&udfid=1067 Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
