SQL server, what is the performance and difference from these selects?

See more:

SQL

SQL-Server

SQL-Server-2012

Hello,

I was looking into a way to find in a given database if there were any table if a column that matched a specific name. After researching and talking to colleagues these two possible solution have arisen:

SELECT
	table_name
	,column_name 
FROM
	information_schema.columns
WHERE
	column_name like '%word%'

And

SELECT
	t.name AS TableName
	,c.name AS ColName
FROM 
	sys.columns c
JOIN 
	sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%word%'

Is there a performance difference between them? when? Any suggestions on how to improve it?

thx