Metadata-Version: 2.1
Name: datasette-jellyfish
Version: 1.0
Summary: Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish
Home-page: https://datasette.io/plugins/datasette-jellyfish
Author: Simon Willison
License: Apache License, Version 2.0
Project-URL: Issues, https://github.com/simonw/datasette-jellyfish/issues
Project-URL: CI, https://github.com/simonw/datasette-jellyfish/actions
Project-URL: Changelog, https://github.com/simonw/datasette-jellyfish/releases
Description: # datasette-jellyfish
        
        [![PyPI](https://img.shields.io/pypi/v/datasette-jellyfish.svg)](https://pypi.org/project/datasette-jellyfish/)
        [![Changelog](https://img.shields.io/github/v/release/simonw/datasette-jellyfish?include_prereleases&label=changelog)](https://github.com/simonw/datasette-jellyfish/releases)
        [![Tests](https://github.com/simonw/datasette-jellyfish/workflows/Test/badge.svg)](https://github.com/simonw/datasette-jellyfish/actions?query=workflow%3ATest)
        [![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](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_distance%28%3As1%2C+%3As2%29%2C%0D%0A++++jaro_winkler%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_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](https://jellyfish.readthedocs.io/en/latest/) for an explanation of each of these functions.
Platform: UNKNOWN
Description-Content-Type: text/markdown
Provides-Extra: test
