TRUNCATION
Truncate a word in order to search for different forms of the same word. Many database use the asterisk * as the truncation symbol.
Example:
Truncate the word architect* and you will search for architect, architects, architecture, etc.
Add the truncation symbol to the word paint* to search for paint, painter, painters, painting etc.