When we search with term %text%, then it applies contains search on fields. If it is text*, then prefix search.