datasette-jellyfish

Datasette插件，增加自定义SQL函数以实现模糊字符串匹配，基于James Turk和Michael Stephens的Jellyfish Python库。

交互式演示

• soundex, metaphone, nysiis, match_rating_codex比较.
• 距离函数比较

示例

SELECT soundex("hello");
    -- Outputs H400
SELECT metaphone("hello");
    -- Outputs HL
SELECT nysiis("hello");
    -- Outputs HAL
SELECT match_rating_codex("hello");
    -- Outputs HLL
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

有关每个函数的解释，请参阅Jellyfish文档。