Skip to main content

Datasette plugin adding SQL functions for Double Metaphone fuzzy text matching

Project description


PyPI License

Datasette plugin that adds custom SQL functions for fuzzy string matching, built on top of the Double Metaphone Python library.

As SQLite custom functions must return a string, we have separate calls for the two results, or one that returns a JSON array of the two results.


SELECT double_metaphone_main("richard");
    -- Outputs 'RXRT'
SELECT double_metaphone_alt("richard");
    -- Outputs 'RKRT'
SELECT double_metaphone_json("richard");
    -- Outputs '["RXRT", "RKRT"]'

Project details

Release history Release notifications | RSS feed

This version


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Built Distribution

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page