public marks

PUBLIC MARKS with tags mysql & c

December 2006

JoshDrew.com

by parmentierf
Last month, I needed to use the metaphone and edit (Levenshtein) distance algorithms for a fuzzy search of a MySQL table. Of course, neither is available as a built-in MySQL function. So, I had to install them as UDFs. The MySQL source distribution includes a metaphone UDF function in udf_example.cc. However, I couldn't find a Levenshtein UDF anywhere, so I wrote one, by converting a C implementation by Lorenzo Seidenari. I suspect that other people could benefit from this code, and you can download it from joshdrew.com. I compared the function's output to that of the PHP levensthein() function for a couple million word pairs; the results agreed completely - that's good enough for me. (this code comes with no warranty whatsoever, but I really hope you find it useful)

September 2006

November 2005

May 2005

PUBLIC TAGS related to tag mysql

Algorithm +   architecture +   database +   db +   hierarchical +   howto +   modeling +   optimization +   patterns +   performance +   php +   plugin +   postgresql +   programming +   reference +   sql +   symfony +   tree +   tutorial +   webdevelopment +  

Active users

parmentierf
last mark : 21/12/2006 08:10

hoabui
last mark : 09/09/2006 02:49

cblackburn
last mark : 30/11/2005 23:11

perebcn
last mark : 11/05/2005 10:39