Removing All But Highest Occurrence Of Version Numbers In Long List?

I have a list full of different IDs with different version numbers (This format: AKH123.1).

I'm trying to clean the list - removing all duplicate IDs but leaving only the largest version number.

I managed to remove the last digit using LEN/VLOOKUP and removing duplicates, but leaving only the largest version number is too tricky for me. I've thought about trying something with LARGE but can't wrap my mind around it.

My thought process went like this: I want to find all occurrences of "AKH123" and return the largest one.

The list contains about 8000 entries and this would save en enormous amount of work.

Here is a tiny portion of the list:

AKH450.1
AKH451.1
AKH451.3
AKH451.4
AKH451.5
AKH451.6
AKH451.7
AKH451.8
AKH452.1
AKH453.3
AKH454.1
AKH455.1
AKH455.2