public marks

PUBLIC MARKS with tag levenshtein

January 2007

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)

October 2006

June 2006

PUBLIC TAGS related to tag levenshtein

applet +   c +   chaînes de caractères +   comparaison +   importé +   mathématique +   mysql +   php +   search +   string matching +  

Active users

solveig_vidal
last mark : 15/01/2007 14:21

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

Country
last mark : 03/10/2006 23:34

jmfontaine
last mark : 03/10/2006 17:49