Acute shortages of larger social housing suitable for families mean it would now take more than 100 years to clear waiting lists in some places, according to analysis of official figures..