sqlite + spellfix

[Espectr0]

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:

Code: Pascal  [Select][+][-]

1. sqlite3.ExecuteDirect('create table dictionary (original text, translated text)');
2.  

insert some texts:

Code: Pascal  [Select][+][-]

1. sqlite3.ExecuteDirect('insert into dictionary(original, translated) values ("similarity", "semejanza"), ("search", "busqueda"), ("is", "es"), ("awesome", "asombrosa"), ("awesomes", "asombrosas");');
2.  

and query like:

Code: Pascal  [Select][+][-]

1. 'select original, translated from dictionary where editdist3(original, "awesoem") < 600'
2.  

my questions:

* I only get "awesome" result and not "awesomes", why?
* Can I get what distance value the search had for each result?


Thanks!

[Leledumbo]

* I only get "awesome" result and not "awesomes", why?

Educated guess, this:

Code: SQL  [Select][+][-]

1. editdist3(original, "awesoem") < 600

is not fulfilled for what particular word.

* Can I get what distance value the search had for each result?

Basic SQL:

Code: SQL  [Select][+][-]

1. SELECT original, editdist3(original, "awesoem") FROM dictionary