Hola Gente!
My app uses sqlite and spellfix extension,
I have the following code (do not paste everything to simplify) where I create a table that contains original and translated text:
sqlite3.ExecuteDirect('create table dictionary (original text, translated text)');
insert some texts:
sqlite3.ExecuteDirect('insert into dictionary(original, translated) values ("similarity", "semejanza"), ("search", "busqueda"), ("is", "es"), ("awesome", "asombrosa"), ("awesomes", "asombrosas");');
and query like:
'select original, translated from dictionary where editdist3(original, "awesoem") < 600'
my questions:
* I only get "awesome" result and not "awesomes", why?
* Can I get what distance value the search had for each result?
Thanks!