How to add levenshtein function in mysql?

Question

I got the code for Levenshtein distance for MySQL from http://kristiannissen.wordpress.com/2010/07/08/mysql-levenshtein/^{(archive.org link)}, but how to add that function in MySQL? I am using XAMPP and I need it for search in PHP.

Answer 1

I have connected to my MySQL server and simply executed this statement in MySQL Workbench, and it simply worked - I now have new function levenshtein().

For example, this works as expected:

SELECT levenshtein('abcde', 'abced')

2