You can use this pattern at the end of any sequence match to remove length as a condition.

This expression is then retained by the Pattern class before it is passed on to the Matcher class to check for matches in the context of a character sequence.

The SELECT statement returns all name elements of the products with the term "creamer" and the term "pattern" in any sequence in the respective "name" element.