Match anywhere in word by default: How is it supposed to work?

[kinook]

With double quotes, it's supposed to search on *star schema*, and without double quotes, it searches *star* *schema*, but I don't think FTS really supports it. You may need to use non-FTS mode (Tools | Compact & Repair). Either way, it's a non-indexed search so it can be slow, and I wouldn't advise using it.