SELECT
  SCHEMA_NAME(schema_id) AS esquema,
  t.name AS tabla,
  c.name AS columna
FROM sys.tables AS t
  INNER JOIN sys.columns c ON t.object_id = c.object_id
WHERE c.name LIKE '%palabra%'
ORDER BY esquema, tabla