Oh, sweet! Thanks! On Tue, Aug 25, 2009 at 9:31 AM, Paul Vernon < [email protected]> wrote:
> > > 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:325679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
