I need to match each row of table A to its closest available match in table B, but I can't use a B row more than once. Like marrying each A to a B.

I'm NOT trying to do a global optimization to get the best possible set of matches, just to get a reasonable set.