Well you can use a data compare tool such as RedDate Compare or ApexSQL Diff.
Or even a matching algorithm product. Also may help to understand how these clauses are constructied - is it normalised etc. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Brad Wood To: CF-Talk Sent: Tue May 01 21:24:54 2007 Subject: text comparison algorithm Part of our database includes legal clauses that our title companies use on commitments and policies and such. As we convert new companies over to our new system we are constantly asked to import hundreds of new clauses into the database. The problem is, most of the clauses are ALMOST identical to existing clauses and can be weeded out. Usually there are just slight verbiage differences. The only way for me to do that now is to print them all out, place them side by side and visually find the similarities. Is there an easy way to programmatically match each new clause (just a text field) to the existing ones and get back an instant list of close matches. It would be great to even have a percentage of closeness or something. I know code like this can be written because of programs like Araxis Merge. Ideas? This would save me hours of work, but I'm not sure where to start. ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
