Scanning every post for a word works for a hundred posts and dies at a hundred million. A search engine does the heavy work ahead of time, building an index, so that a query becomes a handful of lookups.