Search Matching Prefix Of Every Word In Field In Sqlite

I need to write SELECT statement selecting rows, where prefix of any word from some field matches given pattern. I'm using sqlite, but it's kind of general question. I came up wit

Solution 1:

One option is to use the The Full Text Modules; http://www.sqlite.org/fts3.html

SELECT * FROM table WHERE field MATCH 'phrase*';