Thank you so much .

Have one another question in mind .. what if I want to search more than one one word in a single document but in same...

I am pretty satisfied with the NGrams8k solutions you gave . The results are accurate and since I only have to deal with one candidate at a time the processing...

Yeah no doubt the below solution you gave is the fastest of all .. but after testing it on few resumes it doesn't seem to give exact count ..May be...

You are absolutely right... but the idea here is just to tag the candidate with skills like JAVA(6), C++(5) .. where 6, 5 is the number of keyword occurrence.

Thank you all for your help. But as I was working on the queries I realized I have three columns in my table namely Text, Word and PDF Resumes .....

Thank you . I will look into the same.

I am using SQL server 2014 .. Apologies for posting in wrong section.

I don't understand the use of 'value' ... what does that stands for ?

with cte as (select replace(replace(value,'.',''),',','')...

Thank you so much !! Appreciate your help. Yeah got it right I want to find words with '%BOOK% ' . The table does have approx 20,000 rows.