Specific text search in SQL?
Figured it out. Because the line given isn't the same as written, the following query worked: 

select workid, charid, wordcount from paragraph
where plaintext like '%rose%'
and plaintext like '%other%'
and plaintext like '%name%'
and plaintext like '%smell%'
and plaintext like '%sweet%';