SQLite text query to fetch rows containing words from given sentence only?

I have a column containing text strings, and I want to fetch all rows which contain words (in respective order) from given sentence, for example:

if given sentence:

the red apple on the table in the middle of the field

if column contains following rows:

1. the red


2. red apple of the field


3. green apple


4. red apple on the chair


5. table


6. field of red apple

I want my query to return row number 1, 2 and 5 only.