Landscape different tiling based on distance

Hi everyone,
I just need to give a bit more realism to one of the material in my Landscape. Basically I would like to tile it based on distance. I’ve just spent hours on Youtube and googling as well. Just found a chaotic tutorial.
Do you have any resource or example please?

many thanks