SQLite: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) No edit summary |
Jkuehlthau (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
=Levenshtein= | =Levenshtein= | ||
The SQLite connector has the Levenshtein function! A couple of examples: | The SQLite connector has the [https://en.wikipedia.org/wiki/Levenshtein_distance Levenshtein] function! A couple of examples: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
SELECT LEVENSHTEIN( 'Microsoft', 'Technology Advisors, Inc.' ) | SELECT LEVENSHTEIN( 'Microsoft', 'Technology Advisors, Inc.' ) |
Revision as of 02:45, 31 December 2015
Levenshtein
The SQLite connector has the Levenshtein function! A couple of examples:
SELECT LEVENSHTEIN( 'Microsoft', 'Technology Advisors, Inc.' )
Result: 21
SELECT LEVENSHTEIN( 'Technology Advisors Inc', 'Technology Advisors, Inc.' )
Result: 2
SELECT LEVENSHTEIN( 'Bob', 'Tom' )
Result: 2