mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-13 12:28:30 +00:00
56 lines
1.4 KiB
Plaintext
56 lines
1.4 KiB
Plaintext
|
|
CREATE TABLE costs(iLang, cFrom, cTo, Cost);
|
|
INSERT INTO costs VALUES(0, '', '?', 100);
|
|
INSERT INTO costs VALUES(0, '?', '', 100);
|
|
INSERT INTO costs VALUES(0, '?', '?', 150);
|
|
CREATE TABLE vocab(w TEXT UNIQUE);
|
|
INSERT OR IGNORE INTO vocab SELECT term FROM t1aux;
|
|
CREATE VIRTUAL TABLE t2 USING approximate_match(
|
|
vocabulary_table=t1aux,
|
|
vocabulary_word=term,
|
|
edit_distances=costs
|
|
);
|
|
CREATE VIRTUAL TABLE t3 USING approximate_match(
|
|
vocabulary_table=vocab,
|
|
vocabulary_word=w,
|
|
edit_distances=costs
|
|
);
|
|
CREATE VIRTUAL TABLE t4 USING approximate_match(
|
|
vocabulary_table=vtemp,
|
|
vocabulary_word=w,
|
|
edit_distances=costs
|
|
);
|
|
|
|
|
|
SELECT word, distance FROM t2
|
|
WHERE word MATCH 'josxph' AND distance<300;
|
|
|
|
|
|
SELECT word, distance FROM t3
|
|
WHERE word MATCH 'josxph' AND distance<300;
|
|
|
|
|
|
CREATE TEMP TABLE vtemp(w TEXT UNIQUE);
|
|
INSERT OR IGNORE INTO vtemp SELECT term FROM t1aux;
|
|
|
|
|
|
SELECT word, distance FROM t4
|
|
WHERE word MATCH 'josxph' AND distance<300;
|
|
|
|
|
|
SELECT word, distance FROM t2
|
|
WHERE word MATCH 'joxxph' AND distance<=300;
|
|
|
|
|
|
SELECT word, distance FROM t3
|
|
WHERE word MATCH 'joxxph' AND distance<=300;
|
|
|
|
|
|
SELECT word, distance FROM t2
|
|
WHERE word MATCH 'joxxph' AND distance<300;
|
|
|
|
|
|
SELECT word, distance FROM t3
|
|
WHERE word MATCH 'joxxph' AND distance<300;
|
|
|