Here is my version of the Levenshtein method: http://www.codersrevolution.com/index.cfm/2008/7/29/ColdFusion-Levenshtein-Distance-String-comparison-and-highlighting
I optimized it for doing paragraphs and highlighting the differences with HTML. If you just want a simple SQL version, you can find one here: http://siderite.blogspot.com/2007/04/super-fast-and-accurate-string-distance.html ~Brad -------- Original Message -------- Subject: Re: SOT: "better" DIFFERENCE From: Tom Chiverton <[email protected]> Date: Tue, August 25, 2009 9:36 am To: cf-talk <[email protected]> On Tuesday 25 Aug 2009, John M Bliss 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. You want something like Llevenshtein distance maybe ? It was easy enough to find an SQL impl. of this when I needed it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
