Linq to SQL Performance using contains

I'm overloading a vb.net search procedure which queries a SQL database. One of the older methods i'm using as a comparison uses a Stored Procedure to perform the search and return the query. My new method uses linq.I'm overloading a vb.net search procedure which