Alternative Soundex for SQL 6.0

Alternative Soundex for SQL 6.0

Post by Andy Dingl » Thu, 24 Aug 1995 04:00:00



I'm using SQL Server 6.0 with a name & address database of around 1.5
million rows. I need to do the usual telephone query type stuff; given
a vague & mis-spelt name & address, place a small list of potential
matches into a list box, then select the best fit.

I'd be interested to share information with anyone else involved in
this sort of problem.

Particular questions are:  how I can use Soundex, with my own
optimised variant of Soundex ? (Standard Soundex doesn't do Welsh
llanguagio very well !) Whats the best way to graft in a C++ function?

How can I best develop a "score" for "quality of match" that takes
into account all the fields in the search (which depends on what we've
been supplied with), and can weight them differently between fields ?

Thanks

--

If all it takes is an infinite number of monkeys with typewriters,
how come AOL haven't written any Shakespeare yet ?

 
 
 

1. pgsql/contrib/soundex (soundex.c soundex.sql.in)


Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/contrib/soundex
     from hub.org:/home/projects/pgsql/tmp/cvs-serv51753/contrib/soundex

Modified Files:
        soundex.c soundex.sql.in

-----------------------------  Log Message  -----------------------------

Revise handling of oldstyle/newstyle functions per recent discussions
in pghackers list.  Support for oldstyle internal functions is gone
(no longer needed, since conversion is complete) and pg_language entry
'internal' now implies newstyle call convention.  pg_language entry
'newC' is gone; both old and newstyle dynamically loaded C functions
are now called language 'C'.  A newstyle function must be identified
by an associated info routine.  See src/backend/utils/fmgr/README.

2. isrecover command

3. pgsql/contrib/soundex (soundex.c)

4. Access to DAO properties through OLE automation.

5. select soundex(string1), soundex(string2)

6. Sybase 11 for AXP/Open VMS

7. sa lost all rights from SQL 6.0 to SQL 6.0

8. How can I make my Paradox Database becomes a Client/Server database for a Windows Network?

9. old newbie and sql edit window in VFP 6.0 or SQL editor for VFP 6.0

10. How to debug stored procedures in SQL 7.0 using Visual Interdev 6.0 or Visual Basic 6.0

11. SOUNDEX - plans for SQL function?

12. SOUNDEX in SQL-Select with like?