If I understood your question correctly, you've misunderstood the like keyword. It searches a portion of a string from a larger string. For example for sentence:
The school is over
finding
%school%
would match, but if the text is
School
then searching for
%The school%
won't match since it doesn't appear in the text