How can I retrieve a list of surveys/assessments containing a particular question text by providing the said question text?

Yes, By entering the question text in the filters menu within any of the survey/assessment tabs, you can easily retrieve a list of surveys/assessments that include the specified question.