is there any official or "de-facto" official implementation of Levenshtein distance on MariaDB 10.2 or 10.3?
I found this https://github.com/juanmirocks/Levenshtein-MySQL-UDF, but I want to be sure that there are no alternatives.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityis there any official or "de-facto" official implementation of Levenshtein distance on MariaDB 10.2 or 10.3?
I found this https://github.com/juanmirocks/Levenshtein-MySQL-UDF, but I want to be sure that there are no alternatives.
There is no single officially approved or universally accepted implementation as of writing this (May 2019). However, as suggested by Rick James in a comment,
Search for
mysql Levenshtein
; there are several implementations out there. I don't know if they are all the same. A UDF implementation is likely to be faster than a Stored Procedure.