sqlite + spellfix
lazarus / 16-Databases

----------------------------------------------------------------------
Espectr0 · 2022-05-22 16:23

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][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
sqlite3.ExecuteDirect('create table dictionary (original text,
translated text)'); 
insert some texts:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
sqlite3.ExecuteDirect('insert into dictionary(original, translated)
values ("similarity", "semejanza"), ("search", "busqueda"), ("is",
"es"), ("awesome", "asombrosa"), ("awesomes", "asombrosas");'); 
and query like:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i '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!

----------------------------------------------------------------------
Leledumbo · 2022-06-03 02:56

Quote from: Espectr0 on May 22, 2022, 06:23:33 pm* I only get
"awesome" result and not "awesomes", why?
Educated guess, this:
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
editdist3(original, "awesoem") < 600is not fulfilled for what
particular word.
Quote from: Espectr0 on May 22, 2022, 06:23:33 pm* Can I get what
distance value the search had for each result?
Basic SQL:
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT
original, editdist3(original, "awesoem") FROM dictionary