Is this the same as SQL's SOUNDEX() type of phonetic matching?
Robert Hinojosa
Senior WebDeveloper
[EMAIL PROTECTED]
www.hencie.com
972-671-0011 ext.284
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 1:23 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL query suggestions
Huh?????
I'm not exactly sure how this works, though it sounds really
fascinating. I'd love to see you delve into this a bit further, or
point us to some resources. Probably should make this a new thread.
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
Johnny Thompson wrote:
>
> A more precise algorithm perhaps would be the following:
>
> create a phonetic representation of a the string in memory
> T,D = 1
> N = 2
> M = 3
> R = 4
> L = 5...etc..(if anyone needs a complete explanation of phonetic string
> matching, let me know - I've used this method a bunch in VB)..
>
> by ignoring vowels, you have a numeric value which represents the string
> in question... You can follow the same method as described (match first
> few numbers, then recursively search more based on returned record count),
> or you can weight by probability (how many of the numbers are represented
> comparitively speaking).
>
> ..just another idea.
>
> --- [EMAIL PROTECTED] wrote:
> >
> >
> > Thanks for all the ideas. There were a number of good ideas submitted
> > and I
> > appreciate it. I must not have explained my quandry
> > carefully enough because a couple of replies indicated that. The
> > Departments
> > table only has two fields, DeptID and DeptName.
> > When an administrative user enters a new employee, one of the fields is
> > a
> > dropdown box that the admin can select a department from.
> > There is a button by that field to "Add Department" in case they don't
> > find what
> > they are looking for. The page I am working on can also be reached from
> > the
> > main menu's Add Department option. What I want to do is avoid adding
> > Department
> > names that are really close to others that have already been entered.
> > When a
> > the user tries to enter a Department name that is similar to one that is
> > extant,
> > I want to catch that in the action page and show them the Department
> > names that
> > are similar. They will be able to either abort their insertion if there
> > is
> > already something close enough, or submit it if they still want to.
> >
> > What I ended up doing was suggested by Phil Meadows, a co-worker, who
> > read my
> > post and came over to my desk to share his idea. I do a query to match
> > the first
> > 5 characters of the complete string entered by the user. If that
> > returns more
> > than 5 records, I run another query based on the first 10 characters.
> > That
> > seems to accomplish what I want as well as anything.
> >
> > If anyone wants to see the code I would be happy to send it to them
> > off-line.
> >
> > Thanks again,
> >
> > Loyd Campbell
> >
> >
> >
> >
> >
> > "David L. Penton" <[EMAIL PROTECTED]> on 01/11/2001 10:12:32 AM
> >
> > Please respond to [EMAIL PROTECTED]
> >
> > To: [EMAIL PROTECTED]
> > cc: (bcc: Loyd W Campbell/TX/ONE)
> > Subject: RE: SQL query suggestions
> >
> >
> > >
> >
> > First, do you have a primary key of DeptName (and a separate unique
> > index of
> > DeptId) to prevent duplicates?
> >
> > Second, make a Listbox that has all of the names and let them pick from
> > one
> > of those names or supply their own. If they supply their own, then
> > check
> > the DB to ensure it doesn't exist then insert it, or if it does exist
> > display a message that says it already exists.
> >
> >
> > David L. Penton, MCP
> > Consultant
> > "Mathematics is music for the mind, and Music is Mathematics for the
> > Soul. - J.S. Bach"
> > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> >
> > "If you want an ISP with a great email server
> > and great network access,
> > DON'T use AT&T @HOME"
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of [EMAIL PROTECTED]
> > Sent: Thursday, January 11, 2001 9:49 AM
> >
> > Hi gang,
> >
> > I don't think there is a way to do this, but wanted to give you SQL
> > gurus a
> > shot
> > at it.
> >
> > I have a table that has department names in it (DeptName) with an
> > autogenerated
> > DeptID. When a user wants to enter a new department name, I want to
> > show
> > him or
> > her a list of similar department names to make sure we don't get
> > duplicates
> > entered.
> >
> > Example: User wants to enter West Coast and Midwest Marketing. One
> > entry
> > already in the table is West Coast & Midwest Marketing.
> >
> > If I use SELECT DeptName
> > FROM tblDepartments
> > WHERE DeptName LIKE '%NewDeptName%'
> >
> > It won't find it. I know that on this example I could parse through the
> > variable and look for &s and then use an OR clause, but this is only one
> > case.
> > There could be cases like these:
> >
> > Existing Name Proposed New Name
> >
> ----------------------------------------------------------------------------
> > -
> > Marketing/Support Marketing - Support
> > Midwest Admin Midwest Administration
> > Large Corporate Marketing Large Corp Marketing
> >
> > etc. etc.
> >
> > Anyone suggest a "relatively" easy way to look for similar names in the
> > table?
> >
> > Thanks,
> >
> > Loyd Campbell
> >
> > Website Manager
> > Bank One International Group
> > 1700 Pacific Ave., 21st Floor
> > Mail Code TX1-2805
> > Dallas, TX 75201
> > [EMAIL PROTECTED]
> > 214-290-2811 (office)
> > 972-567-9082 (cell)
> >
> >
> >
> -------------------------------------------------------------------------
> > This email server is running an evaluation copy of the MailShield anti-
> > spam software. Please contact your email administrator if you have any
> > questions about this message. MailShield product info:
> > www.mailshield.com
> >
> > -----------------------------------------------
> > To post, send email to [EMAIL PROTECTED]
> > To subscribe / unsubscribe: http://www.dfwcfug.org
> >
> >
> >
> >
> >
>
> =====
> ------------------------------
> Johnny Thompson
> Allaire Certified Consultant
>
> "My mind is a raging torrent, flooded with rivulets of thought cascading into a waterfall of creative alternatives."
> - Hedley Lamar
> ------------------------------
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
