ultranormalize_name function should strip trailing digits

[samuelcolvin]

What's the problem this feature will solve?

Users are able to create packages with extremely similar names by just appending a number, e.g. pydantic2.

Describe the solution you'd like

I'd like the ultranormalize_name function

warehouse/warehouse/migrations/versions/d18d443f89f0_ultranormalize_name_function.py

Lines 29 to 42 in 69f19a1

	CREATE FUNCTION ultranormalize_name(text) RETURNS text AS $$
	SELECT lower(
	regexp_replace(
	regexp_replace(
	regexp_replace($1, '(\.|_|-)', '', 'ig'),
	'(l|L|i|I)', '1', 'ig'
	),
	'(o|O)', '0', 'ig'
	)
	)
	$$
	LANGUAGE SQL
	IMMUTABLE
	RETURNS NULL ON NULL INPUT;

to be extended to strip trailing digits when comparing names, so something like regexp_replace($1, '0+$', '').

Additional context

[samuelcolvin]

@di any thoughts on this? It seems important to me.