pypi_packages: datasette-jellyfish
This data as json
| name | summary | classifiers | description | author | author_email | description_content_type | home_page | keywords | license | maintainer | maintainer_email | package_url | platform | project_url | project_urls | release_url | requires_dist | requires_python | version | yanked | yanked_reason |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| datasette-jellyfish | Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish | [] | # datasette-jellyfish [](https://pypi.org/project/datasette-jellyfish/) [](https://github.com/simonw/datasette-jellyfish/releases) [](https://github.com/simonw/datasette-jellyfish/actions?query=workflow%3ATest) [](https://github.com/simonw/datasette-jellyfish/blob/main/LICENSE) Datasette plugin that adds custom SQL functions for fuzzy string matching, built on top of the [Jellyfish](https://github.com/jamesturk/jellyfish) Python library by James Turk and Michael Stephens. Interactive demos: * [soundex, metaphone, nysiis, match_rating_codex comparison](https://latest-with-plugins.datasette.io/fixtures?sql=SELECT%0D%0A++++soundex%28%3As%29%2C+%0D%0A++++metaphone%28%3As%29%2C+%0D%0A++++nysiis%28%3As%29%2C+%0D%0A++++match_rating_codex%28%3As%29&s=demo). * [distance functions comparison](https://latest-with-plugins.datasette.io/fixtures?sql=SELECT%0D%0A++++levenshtein_distance%28%3As1%2C+%3As2%29%2C%0D%0A++++damerau_levenshtein_distance%28%3As1%2C+%3As2%29%2C%0D%0A++++hamming_distance%28%3As1%2C+%3As2%29%2C%0D%0A++++jaro_similarity%28%3As1%2C+%3As2%29%2C%0D%0A++++jaro_winkler_similarity%28%3As1%2C+%3As2%29%2C%0D%0A++++match_rating_comparison%28%3As1%2C+%3As2%29%3B&s1=barrack+obama&s2=barrack+h+obama) 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_similarity("hello", "hello world"); -- Outputs 0.8181818181818182 SELECT jaro_winkler_similarity("hello", "hello world"); -- Outputs 0.890909090909091 SELECT match_rating_comparison("hello", "helloo"); -- Outputs 1 See [the Jellyfish documentation](https://jellyfish.readthedocs.io/en/latest/) for an explanation of each of these functions. | Simon Willison | text/markdown | https://datasette.io/plugins/datasette-jellyfish | Apache License, Version 2.0 | https://pypi.org/project/datasette-jellyfish/ | https://pypi.org/project/datasette-jellyfish/ | {"CI": "https://github.com/simonw/datasette-jellyfish/actions", "Changelog": "https://github.com/simonw/datasette-jellyfish/releases", "Homepage": "https://datasette.io/plugins/datasette-jellyfish", "Issues": "https://github.com/simonw/datasette-jellyfish/issues"} | https://pypi.org/project/datasette-jellyfish/1.0.1/ | ["datasette", "jellyfish (>=0.8.2)", "pytest ; extra == 'test'"] | 1.0.1 | 0 |