SQLite

From Starfish ETL
Revision as of 02:43, 31 December 2015 by 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.' )
</source
Result: 2
<source lang="mysql">
SELECT LEVENSHTEIN( 'Bob', 'Tom' )

Result: 2