SQLite: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
No edit summary
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