Identifying local characteristic lengths governing sound wave properties in solid foams