Wildcard clues

The WILDCARD_CLUE query parameter enables you to use an * at the beginning or end of your clue words, and instructs the search engine to treat the * as a wildcard character that will match any string of characters.

For example, the clue edit* in the following query finds documents containing any word that starts with the string edit, such as editor, editing, edits, edition, and so on. 
SELECT id, description, FROM videos
   WHERE etx_contains(description,
   Row('edit*', 'WILDCARD_CLUE & SEARCH_TYPE=WORD');

For more information, see Tuning parameters.