Cool, thank you. Meanwhile i was trying to solve using my old attempt, got it also ..finally )
declare @Phrases TABLE
(
phrase varchar(100)
)
DECLARE @Searchs TABLE
(
word varchar(100)
)
declare @NumberWords tinyint
insert into @Searchs (word) select item from dbo.DelimitedSplit8K('they angry', ' ')
Select @NumberWords = COUNT(*) from @Searchs
insert into @Phrases values ('First time you''ve seen a giant, Jon Snow?')
insert into @Phrases values ('Well, don''t stare too long. They''re shy.')
insert into @Phrases values ('When they stop being shy, they get angry.')
insert into @Phrases values ('And when they''re angry,')
insert into @Phrases values ('I''ve seen them pound a man straight into the ground')
insert into @Phrases values ('like a hammer on a nail.')
select * from (select phrase, @NumberWords as NW,COUNT(phrase) as NP from @Phrases
inner join @Searchs on phrase like '%' + word + '%'
group by phrase) as Tmp
where Tmp.NW=Tmp.NP