I ran it on a 67GB sqlite database with approximately 15 million rows in one table and 300 million in another and on an SSD it spit out a result in less than a

I ran it on a 67GB sqlite database with approximately 15 million rows in one table and 300 million in another and on an SSD it spit out a result in less than a second. On a mech drive its 5-10 seconds, but that's a factor of 10 faster than if I did a traditional WHERE clause with LIKE/GLOB. The drawback is that it increases the size of the database, almost exponentially depending on the number of columns you include in the FTS. But its fun to tinker with!