How does that work in countries where it is common (like in the Netherlands)? I imagine software handles it by pattern matching as when sorting artists as “Beat

How does that work in countries where it is common (like in the Netherlands)? I imagine software handles it by pattern matching as when sorting artists as “Beatles, The”? To just match some known “de”, “van” or “van der”! Anywhere I know van der Whatever would just be sorted on “v” but that only works because almost no one has such a last name.