VI_Common_SqlSearch_PrefixLike ("Use this property to select whether the SqlSearch function will return matches where the search string is found at any index in the data string.") is set to "true" by default and only adds a * to the end of the word.
If VI_Common_SqlSearch_PrefixLike is set to false, placeholders are not used at the end of the word and the search term must be entered in full.
This is a product defect (32680).
This will be fixed in a future release of the product. If you require this immediately corrected, please contact Support for a hotfix referencing the defect ID 32680.