Similar Strings

Hey all,

I'm trying to provide a feature to clean up duplicate data in a database
I inherited. To do this, I'd like to have a Levenshtein String Distance
UDF available, so that I can pick out duplicate names. The trouble is,
the only UDFs I can find on the 'net are in source form - I'm on Windows
(And targeting a Win32 MySql server), and have no C compiler available.
Does anyone know of a binary version of these functions? The one
available from this page looks interesting:

http://empyrean.lib.ndsu.nodak.edu/~nem/mysql/udf/

Cheers,
Nicholas Sherlock

--
http://www.sherlocksoftware.org

Nicholas Sherlock wrote:
> I'm on Windows (And targeting a Win32 MySql server), and have no C compiler available.

There are free C compilers available for Windows. See for example:

http://www.cygwin.com/
http://www.borland.com/downloads/download_cbuilder.html ("Compiler"
package is free)
http://msdn.microsoft.com/vstudio/express/

Regards,
Bill K.

Bill Karwin wrote:
> Nicholas Sherlock wrote:
>> I'm on Windows (And targeting a Win32 MySql server), and have no C
>> compiler available.
>
> There are free C compilers available for Windows. See for example:
>
> http://www.cygwin.com/
> http://www.borland.com/downloads/download_cbuilder.html ("Compiler"
> package is free)
> http://msdn.microsoft.com/vstudio/express/

Thanks, I'm slowly downloading Cygwin. In the meantime, I think I'll try
to make a UDF in Delphi.

Cheers,
Nicholas Sherlock

--
http://www.sherlocksoftware.org

Nicholas Sherlock wrote:
> Thanks, I'm slowly downloading Cygwin. In the meantime, I think I'll try
> to make a UDF in Delphi.

In case anyone is interested, I finished making the UDF, you can get it
(with Delphi source), here:

http://www.sherlocksoftware.org/page.php?id=58

Cheers,
Nicholas Sherlock