Find the Maximum Number from a Alphanumeric string in SQL Server

declare @test table(address_type varchar(20))

insert into @test(address_type)
SELECT 'delivery1'
UNION ALL
SELECT 'delivery2'
UNION ALL
SELECT 'delivery10'
UNION ALL
SELECT 'delivery4'
UNION ALL
SELECT 'delivery6'

select address_type, max(substring(address_type, 9, len(address_type)))
from @test