tomatolog
commented
4 months ago what kind of dictionary you suggesting? Could you provide reproducible case - config, data to populate with the forum index and data to populate with the standard dictionary of Russian and query to both indexes with the result sets there it is clear why idx_right should be used but not the idx_forum.
Do you mean that you create and full another index with right content when use this form of CALL SUGGEST(word, 'idx_right,idx_forum') and if the 1st search in the idx_right term levinstein distance is closer to N (some new param) then not to search in the idx_forum ?
As if search into both idx_right and idx_forum what is the condition why to use idx_right but not idx_forum if levinstein distance is closer for term from idx_forum ?
FuriusBaco
Proposal:
Please consider checking words through SUGGEST first using the standard dictionary of Russian or any other language and first suggesting substitutions from there, and only then looking for them in the index. Optional, of course.
Yes, for academic texts where there are no errors, the current implementation is quite suitable. But for the forum, it doesn't always work well. For example, the word “pamagite” is replaced by “pomagite”, “pamagiti”, “pamagitya”, “poamagite”, etc.
This will also be good for the words in the query that are not on the site, but there may still be useful information in the query.
Checklist:
To be completed by the assignee. Check off tasks that have been completed or are not applicable.