How to find exact string from a sentence
You could do something like this:

When considering that a word like water can only be surrounded by spaces, comma's and square brackets.

SELECT * FROM b WHERE list LIKE '%[water,%'
OR list LIKE '%, water,%'
OR list LIKE '%, water]%';


And you could technically remove some of the wildcards:

SELECT * FROM b WHERE list LIKE '[water,%'
OR list LIKE '%, water,%'
OR list LIKE '%, water]';


SQLliteOnline example #1

SQLliteOnline example #2

Both returning:




  NOTE: I'm looking for an answer that uses ignore cases, for instance
  if I want to find water I want to get wAtER and WatER, and so...


Like operator should be case sensitive.


  Note that SQLite LIKE operator is case-insensitive. It means "A" LIKE
  "a" is true. However, for Unicode characters that are not in the ASCII
  range, SQLite LIKE operator is case sensitive e.g., "Ä" LIKE "ä" is
  false.


Source

If it wasn't, COLLATE NOCASE could be used
More on that here