Get Repeated words or phases

Can you explain with examples? it will be more helpful for the experts here to give the precise answer.

Moreover, what I have got from the question is you want to give the count of the repeated words from a table to other.
So,

insert into <destinationTable> (word,Repeated)
select word, count(*) as count
from sourceTable
group by word
having count(*) > 1

Also, if you are working in SQL 2008, you should consider using nvarchar(max) instead of ntext.  nvarchar(max) will allow the same long strings as ntext, but is much more functional than ntext.

yes, I am using nvarchar(max).
in CompanyDecision there is phrases,
I need to collect famous phrases or piece of text and how many its repeated along the DB.

for example:
Row#1 Well, she has long, black hair and blue eyes with funny smile at Morning .
Row#2 He's funny, cute and really rich.
Row#3 He reminds me with funy smile of that guy with long, black hair on the Morning Show.

The result :
has long, black hair   :   2
funy smile  : 2
funny : 3

This is best handled with something like .NET.  T-SQL is not the right tool for this.

There seem to be other variables that you haven't mentioned.  How would you handle words like "the", "an", "a" for instance?  Do you want to count those too?

In your example for has long, black hair having a count of 2, it really should be


Is the above what you were after?

I need to count all words but not "an" or "a" or "the"

I am ok with your result.

This will be best taken care by content search tool like ISYS and SOLR