SQLite: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) (Created page with "The SQLite connector has the Levenshtein function! A couple of examples: <source lang="mysql"> SELECT LEVENSHTEIN( 'Microsoft', 'Technology Advisors, Inc.' ) </source> Result...") |
Jkuehlthau (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
=Levenshtein= | |||
The SQLite connector has the Levenshtein function! A couple of examples: | The SQLite connector has the Levenshtein function! A couple of examples: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
| Line 6: | Line 7: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
SELECT LEVENSHTEIN( 'Technology Advisors Inc', 'Technology Advisors, Inc.' ) | SELECT LEVENSHTEIN( 'Technology Advisors Inc', 'Technology Advisors, Inc.' ) | ||
</source | </source> | ||
Result: 2 | Result: 2 | ||
<source lang="mysql"> | <source lang="mysql"> | ||
Revision as of 02:44, 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