The interactive demo for @alexgarciaxyz's new sqlite-vss extension - adding vector similarity search to SQLite - really has to be seen to be believed:

observablehq.com/@asg017/intro

He has fast semantic search running against 200,000 news headlines and summaries and the results are fantastic: stories about Halloween returned for "scary orange holiday" for example