>My execution plan displays a parallelism syntax when I use the LIKE clause. If I do not, this does not apply. Is there a way to avoid the parallelism when using the LIKE clause or this is just normal as is?

Set MAXDOP=1 option for the query in question