Lines Matching refs:f2
245 CREATE VIRTUAL TABLE temp.f2 USING fuzzer(f2_rules);
1485 SELECT n, distance FROM f2, streetname
1486 WHERE f2.word MATCH 'wersley'
1487 AND f2.distance<=150
1488 AND f2.word=streetname.n
1493 SELECT n, distance FROM f2, streetname
1494 WHERE f2.word MATCH 'testledown'
1495 AND f2.distance<=150
1496 AND f2.word=streetname.n
1501 SELECT DISTINCT streetname.n FROM f2, streetname
1502 WHERE f2.word MATCH 'tayle'
1503 AND f2.distance<=200
1504 AND streetname.n>=f2.word AND streetname.n<=(f2.word || x'F7BFBFBF')
1510 FROM f2 JOIN streetname
1511 ON (streetname.n>=f2.word AND streetname.n<=(f2.word || 'zzzzzz'))
1512 WHERE f2.word MATCH 'duck'
1513 AND f2.distance<150
1514 AND f2.ruleset=3
1521 FROM f2 JOIN streetname
1522 ON (streetname.n>=f2.word AND streetname.n<=(f2.word || 'zzzzzz'))
1523 WHERE f2.word MATCH 'duck'
1524 AND f2.distance<150
1525 AND f2.ruleset=2