Use the indexing and search capabilities of ColdFusion ORM.
When you develop an application that uses ColdFusion ORM, the search feature facilitates full text search. You can load all the persistent entities that match your search criteria based on a query text.
For details, see ColdFusion ORM search