Optical substructures: A multi-scale analysis of 48 galaxy clusters