SQLite

From Starfish ETL
Revision as of 02:44, 31 December 2015 by Jkuehlthau (talk | contribs)
Jump to navigation Jump to search

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