Documentation Source Text

Check-in [ab675a0b08]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Typo fix and a new anchor in the spellfix documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: ab675a0b08020d6d13f4d61ced492b1a73c1c4fe
User & Date: drh 2016-03-29 17:54:19.555
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
Unified Diff Ignore Whitespace Patch
Changes to pages/spellfix1.in.
︙︙
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

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.








|








32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

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.
︙︙
320
321
322
323
324
325
326

327
328
329
330
331
332
333

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.








>








320
321
322
323
324
325
326
327
328
329
330
331
332
333
334

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.
︙︙