In addition to Davin answer, you can also search for Confluence pages having an specific word by running a select query in the BODYCONTENT table like the example below:
select c.title from content c join bodycontent b on b.contentid = c.contentid where b.body like '%<word_to_search>%';
Just replace the <word_to_search> from the query above and run.
I you want to search for a specific phrase then surround it by quotes in the search field. Also, check our the Search syntax page. It has some good info for how to effectively search Confluence.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG