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.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page