>>an algorithm called Soundex Yeah, but soundex is not a panacea either. All what matters with soundex is the first syllable; after that, about anything will match. It might detect Martine and Matinez as being the same, but Martin, Martinovitch and Martinelli as well. So anyway, some human control is mandatory.
What I've done in a similar case, is a tool that lists all names in alphabetical order, the user may select a name and "merge" it with another one. The tool then eliminates the second and replace any references to it in the database with a reference to the first. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
