If you will create a smart search index, then you can use the search in the pages app - use the search icon above the content tree and select your index or use SQL search. (but, the default SQL search should do the same trick). Otherwise, the content of editable text web parts is stored in CMS_Document table, DocumentContent column.