databases are very literal. Every keyword that is entered into a search
appear exactly as typed. Of course, sometimes words have different
and there are different forms of the word, such as singular and plural
and different suffixes. If you choose the wrong tense of a verb or the
spelling of a keyword, you could miss relevant records.
One way to ensure retrieving all variations of a word is to use truncation or wildcards. Most databases have symbols that can be used to truncate or add wildcards to keyword searches. The symbol used by the databases may vary, therefore you will need to check the Help screens to determine which symbols are used. Common truncation/wildcard symbols are: *, ?, #, $, + and !.
Here's an example of truncation using the asterisk ( * ).
Here's an example of a wildcard using the asterisk.