Because then you have to enter pairs manually. He's looking for something that's automated.
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 5:58 PM To: CF-Talk Subject: Re: Peg = Margaret name matching code Why not just create two database tables, one with id(int) and formalname(varchar), the second with formalnameid(int) and nickname(varchar) and populate starting with names from the URL you mentioned, then bounce your names against that? Pete On 9/3/06, Mike Chabot <[EMAIL PROTECTED]> wrote: > Does anyone know of code that can match formal names, such as > "Michael" with their less formal equivalents, such as "Mike." I was > starting to code this but stopped after realizing that there were > thousands of these nicknames. I am mainly interested in names, but > matching addresses abbreviation, such as "Blvd" = "Boulevard" might be > helpful as well. > > <http://www.usgenweb.org/research/nicknames.shtml> > > Someone recommended Blue Fusion CS (which sounds like an Adobe > product, but it isn't), but that software is quite expensive. I would > hope there is something free out there which covers the basics. > > CFMX 7 Ent / Win2003 / IIS6 / MS SQL Server 2005 > > Thank you, > Mike Chabot > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4