By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| number |
|---|
| 1 |
| 12 |
| 1234567 |
| 1456 |
| 456 |
| C4534567 |
| 15613 |
| number |
|---|
| C0000001 |
| C0000012 |
| C1234567 |
| C0001456 |
| C0000456 |
| C4534567 |
| C0015613 |
| number | CorrectedNumber | BestCorrection |
|---|---|---|
| 1 | C0000001 | C0000001 |
| 12 | C0000012 | C0000012 |
| 1234567 | C1234567 | C1234567 |
| 1456 | C0001456 | C0001456 |
| 456 | C0000456 | C0000456 |
| C4534567 | C4534567 | C4534567 |
| 15613 | C0015613 | C0015613 |