Stemming extends a search to grammatical variations on a word. For example, a search for fish would also find fishing. A search for applied would also find applying, applies, and apply.
To add stemming to your request add a tilde (~) at the end of words that you want stemmed in a search. Example: apply~
Phonic searching looks for a word that sounds like the word you are searching for and begins with the same letter. For example, a phonic search for Smith will also find Smithe and Smythe.
To add Phonic Search to your request add a number sign (#) in front of the word in your search request. Examples: #smith, #johnson
Fuzzy searching will find a word even if it is misspelled. For example, a fuzzy search for apple will find appple. Fuzzy searching can be useful when you are searching text that may contain typographical errors, or for text that has been scanned using optical character recognition (OCR).
To add Fuzzy Searching to your request add the % character. The number of % characters added determines the number of differences dtSearch will ignore when searching for a word. The position of the % characters determines how many letters at the start of the word have to match exactly.
ba%nana – The word must begin with ba and have at most one difference between it and banana.
b%%anana – The word must begin with b and have at most two differences between it and banana.