What character is used for stemming searches in dtSearch?

In dtSearch, the character used for stemming searches is the tilde (~). Stemming is a linguistic process that reduces words to their base or root form. By using the tilde before a word in a search query, you indicate that you want dtSearch to include variations of that word, such as plurals or different verb forms.

For example, if you search for "~run", dtSearch will return results that include "running", "ran", and "runs". This capability enhances search results by broadening the scope of what is being searched, making it more effective for users looking for variations of a term without having to input every possible form.

Other characters listed do not serve the same purpose in dtSearch. The exclamation mark is typically used for negation in search queries, while the asterisk is utilized as a wildcard to represent any character or character sequence. The hash symbol may have different uses in various contexts but is not related to stemming in dtSearch.