Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen

PMeinshausen/Levenshtein.sql

Created September 29, 2014 03:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save PMeinshausen/30d64a74094090079f87 to your computer and use it in GitHub Desktop.
Save PMeinshausen/30d64a74094090079f87 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Levenshtein.sql
--Syntax (version 1.1)
--Use a SELECT statement to call the Levenshtein distance function:
SELECT *
FROM ldist
(
ON table_name
SOURCE (column1 [, column2,...])
TARGET(column1)
[THRESHOLD(value)]
[OUTPUT_COLUMN_NAME(column_name)]
[TARGET_COLUMN_NAME(column_name)]
[SOURCE_COLUMN_NAME(column_name)]
[ACCUMULATE(column1 [, column2,...])
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment