Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
Project description
datasette-jellyfish
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size datasette_jellyfish-0.3-py3-none-any.whl (6.8 kB) | File type Wheel | Python version py3 | Upload date | Hashes View |
Close
Hashes for datasette_jellyfish-0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c9b8a769b71c8dc6505187ff54fe3159ec513553f3b8e40f838032c78540c0a8 |
|
MD5 | f434e295511aab4c859d5896acd56375 |
|
BLAKE2-256 | ef6e3c63e43ca3352bcc861774e3c8991a5978f4afc4f3a1405de6cde5d2bf50 |