which one is good to use in terms of searching a word in specific attribute?
TL;DR
Query contain is better for searching specific words within an attribute, as it looks for an exact match. Query search is more suitable for broader search functionality, as it looks for any occurrence of the word in the attribute.