Skip to content
Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.circleci
datasette_jellyfish
tests
.gitignore
LICENSE
README.md
setup.py

README.md

datasette-jellyfish

PyPI License

Datasette plugin that adds custom SQL functions for fuzzy string matching, built on top of the Jellyfish Python library by James Turk and Michael Stephens.

Interactive demos:

Examples:

SELECT soundex("hello");
    -- Outputs H400
SELECT metaphone("hello");
    -- Outputs HL
SELECT nysiis("hello");
    -- Outputs HAL
SELECT match_rating_codex("hello");
    -- Outputs HLL
SELECT porter_stem("running");
    -- Outputs run
SELECT levenshtein_distance("hello", "hello world");
    -- Outputs 6
SELECT damerau_levenshtein_distance("hello", "hello world");
    -- Outputs 6
SELECT hamming_distance("hello", "hello world");
    -- Outputs 6
SELECT jaro_distance("hello", "hello world");
    -- Outputs 0.8181818181818182
SELECT jaro_winkler("hello", "hello world");
    -- Outputs 0.890909090909091
SELECT match_rating_comparison("hello", "helloo");
    -- Outputs 1

See the Jellyfish documentation for an explanation of each of these functions.

You can’t perform that action at this time.