writing a query to retrieve the data based on many texts

Question

I have a sort button and I have a  texbox.I have written a query which sorts a particular text given in a textbox.Suppose I have written Team in a textbox  and click the sort button then all the line of text will be displayed which contains "Team".But supposing if I want to search the line containing 2 or 3 or 4 or any number of text..What should be the query...?Lets say,I have written team,Manager,Leader and press sort button,then all the line should be displayed containing the team or manager or leader.The text in a texbox can be of any words serperated by ,
what is the query to retrieve the data based on many texts?
I am using c# for this