Change materials of connecting objects

I have a scene full of hexagon tiles and a player moving above them. I want to make all tiles that are within a certain distance from the player/current tile.

I tried the different raycasts like the CastSphere etc. But couldnt get it to work.