database - Cost of SQLite virtual tables and what's the correct use of them?

Question

I need to use the fuzzy matching of word using the Spellfix1 SQLite extension. Currently I have a table where one of its columns is the words to match. New words may be added or some of them may be deleted.

My doubt is how to handle the Spellfix1 table. If I do

INSERT INTO spellfixtable(word) SELECT mycol FROM mytable;

would that duplicate the data? (I'm working with limited disk space)

How should I keep the spellfixtable table up to date (maybe with triggers)?

Should I just make it temporary and create a new one every time I want to match a word?

question from:https://stackoverflow.com/questions/65907246/cost-of-sqlite-virtual-tables-and-whats-the-correct-use-of-them

Answer 1

Waitting for answers