SQLWordForms provides a fuzzy search method,
alternative to Synonyms and
SQLWordForms allows to specify an SQL
query which will be executed to generate word forms or synonyms
from the database. The query must return exactly one column with
individual word forms or synonyms in separate rows.
The query is sent to the database specified in
the DBAddr command.
If the case of multiple DBAddr commands,
only the first DBAddr
is used for word forms generating.
The SQL query is executed for every word typed by the user,
$1 variable replaced to the word.
When using cluster,
the SQLWordForms command
must be specified in the cluster node XML templates - not in the
front-end HTML template.