Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Typo fix and a new anchor in the spellfix documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ab675a0b08020d6d13f4d61ced492b1a |
| User & Date: | drh 2016-03-29 17:54:19 |
Context
|
2016-03-29
| ||
| 17:55 | Version 3.12.0 check-in: 8785825a81 user: drh tags: trunk, release, version-3.12.0 | |
| 17:54 | Typo fix and a new anchor in the spellfix documentation. check-in: ab675a0b08 user: drh tags: trunk | |
| 17:30 | Break out the SHA1 hashes into a separate subheading on the change log. check-in: c5565753d6 user: drh tags: trunk | |
Changes
Changes to pages/spellfix1.in.
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
...
320
321
322
323
324
325
326
327
328
329
330
331
332
333
|
have a list of words in a table named "big_vocabulary". Then do this: <blockquote><pre> INSERT INTO demo(word) SELECT word FROM big_vocabulary; </pre></blockquote> <p>If you intend to use this virtual table in cooperation with an [FTS4] table (for spelling correctly of search terms) then you might extract the vocabulary using an [fts4aux] table: <blockquote><pre> INSERT INTO demo(word) SELECT term FROM search_aux WHERE col='*'; </pre></blockquote> <p>You can also provide the virtual table with a "rank" for each word. ................................................................................ BACA, yielding "Pascagoula" as the best match. <p>Only terms of the vocabulary with a matching langid are searched. Hence, the same table can contain entries from multiple languages and only the requested language will be used. The default langid is 0. <h2>Configurable Edit Distance</h2> <p>The built-in Wagner edit-distance function with fixed weights can be replaced by the [editdist3()] edit-distance function with application-defined weights and support for unicode, by specifying the "edit_cost_table=<i>TABLENAME</i>" parameter to the spellfix1 module when the virtual table is created. |
|
>
|
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
...
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
|
have a list of words in a table named "big_vocabulary". Then do this: <blockquote><pre> INSERT INTO demo(word) SELECT word FROM big_vocabulary; </pre></blockquote> <p>If you intend to use this virtual table in cooperation with an [FTS4] table (for spelling correction of search terms) then you might extract the vocabulary using an [fts4aux] table: <blockquote><pre> INSERT INTO demo(word) SELECT term FROM search_aux WHERE col='*'; </pre></blockquote> <p>You can also provide the virtual table with a "rank" for each word. ................................................................................ BACA, yielding "Pascagoula" as the best match. <p>Only terms of the vocabulary with a matching langid are searched. Hence, the same table can contain entries from multiple languages and only the requested language will be used. The default langid is 0. <tcl>hd_fragment configeditdist {configurable edit distances}</tcl> <h2>Configurable Edit Distance</h2> <p>The built-in Wagner edit-distance function with fixed weights can be replaced by the [editdist3()] edit-distance function with application-defined weights and support for unicode, by specifying the "edit_cost_table=<i>TABLENAME</i>" parameter to the spellfix1 module when the virtual table is created. |