Are you sure that the almost identical clauses mean the same thing in the legal world? Do you trust yourself or a piece of software to 'write' clauses that might have to stand up in court? If so, do your legal people know it?
You can do fuzzy matching of text fields in SQL, but I have only dabbled in it. -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 01, 2007 3:25 PM To: CF-Talk 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
