The end result should be the number of times the word appeared in the column. Please note that this is not same as the rowcount in which the word appears.
So lets say there is a column called 'Sentance' and it contains many rows... couple of which are :
ROW 1> Howdy how are you? Nice to meet you.
ROW 2> Hey there howz it going? Good seeing you. Met your friend earlier.
If the query searched just these two rows for word 'you' the result should be 3. (Note that it shouldn't be 4 even though 'your' contains the substring 'you').