History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reroute"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 535 | 2025-06-13 14:40:29 | reroute | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 534 | 2025-06-04 09:18:10 | reroute | 1 | 69583 | 3 | 3.420 | 20345.9 |
| 533 | 2025-06-01 15:23:52 | reroute | 1 | 69583 | 3 | 2.483 | 28023.8 |
| 532 | 2025-05-30 20:54:36 | reroute | 1 | 69583 | 3 | 5.533 | 12576.0 |
| 531 | 2025-05-28 08:53:58 | reroute | 1 | 69583 | 3 | 3.516 | 19790.4 |
| 530 | 2025-05-26 21:13:57 | reroute | 3 | 134027 | 311 | 39.500 | 3393.1 |
| 529 | 2025-05-26 12:13:27 | reroute | 2 | 107671 | 20 | 17.110 | 6292.9 |
| 528 | 2025-05-25 14:54:27 | reroute | 3 | 134027 | 311 | 7.626 | 17575.0 |
| 527 | 2025-05-23 08:09:30 | reroute | 3 | 134027 | 311 | 32.906 | 4073.0 |
| 526 | 2025-05-23 02:50:47 | reroute | 3 | 134027 | 311 | 38.610 | 3471.3 |
| 525 | 2025-05-22 18:06:45 | reroute | 1 | 69583 | 3 | 6.233 | 11163.6 |
| 524 | 2025-05-22 09:04:09 | reroute | 1 | 69583 | 3 | 3.156 | 22047.8 |
| 523 | 2025-05-22 05:00:43 | reroute | 3 | 134027 | 311 | 49.673 | 2698.2 |
| 522 | 2025-05-22 04:35:49 | reroute | 3 | 134027 | 311 | 37.143 | 3608.4 |
| 521 | 2025-05-21 07:13:30 | reroute | 3 | 134027 | 311 | 13.970 | 9593.9 |
| 520 | 2025-05-12 15:00:22 | reroute | 1 | 69583 | 3 | 6.250 | 11133.3 |
| 519 | 2025-05-05 04:33:22 | reroute | 3 | 134027 | 311 | 23.736 | 5646.6 |
| 518 | 2025-05-04 01:22:41 | reroute | 1 | 69583 | 3 | 7.923 | 8782.4 |
| 517 | 2025-05-03 05:08:21 | reroute | 1 | 69583 | 3 | 3.093 | 22496.9 |
| 516 | 2025-05-02 09:44:06 | reroute | 1 | 69583 | 3 | 4.280 | 16257.7 |
| 515 | 2025-05-02 04:15:59 | reroute | 2 | 107671 | 20 | 11.623 | 9263.6 |
| 514 | 2025-04-30 20:06:36 | reroute | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 513 | 2025-04-28 07:34:07 | reroute | 1 | 69583 | 3 | 4.873 | 14279.3 |
| 512 | 2025-04-21 16:35:44 | reroute | 1 | 69583 | 3 | 6.236 | 11158.3 |
| 511 | 2025-04-16 03:25:49 | reroute | 2 | 107671 | 20 | 14.046 | 7665.6 |
| 510 | 2025-04-16 03:07:17 | reroute | 3 | 134027 | 311 | 28.156 | 4760.2 |
| 509 | 2025-04-15 04:24:35 | reroute | 3 | 134027 | 311 | 30.753 | 4358.2 |
| 508 | 2025-04-15 00:42:30 | reroute | 2 | 107671 | 20 | 17.936 | 6003.1 |
| 507 | 2025-04-14 05:35:15 | reroute | 3 | 134027 | 311 | 26.613 | 5036.1 |
| 506 | 2025-04-12 14:35:19 | reroute | 2 | 107671 | 20 | 10.060 | 10702.9 |
| 505 | 2025-04-11 21:06:06 | reroute | 3 | 134027 | 311 | 37.063 | 3616.2 |
| 504 | 2025-04-02 00:33:02 | reroute | 1 | 69583 | 3 | 5.736 | 12130.9 |
| 503 | 2025-03-30 21:14:22 | reroute | 1 | 69583 | 3 | 6.016 | 11566.3 |
| 502 | 2025-03-20 18:27:55 | reroute | 1 | 69583 | 3 | 6.766 | 10284.2 |
| 501 | 2025-03-20 08:07:10 | reroute | 1 | 69583 | 3 | 6.720 | 10354.6 |
| 500 | 2025-03-04 22:26:26 | reroute | 1 | 69583 | 3 | 6.030 | 11539.5 |
| 499 | 2025-03-02 10:25:34 | reroute | 1 | 69583 | 3 | 6.186 | 11248.5 |
| 498 | 2025-02-28 02:25:00 | reroute | 1 | 69583 | 3 | 5.796 | 12005.3 |
| 497 | 2025-02-26 00:08:39 | reroute | 1 | 69583 | 3 | 6.546 | 10629.9 |
| 496 | 2025-02-22 05:08:53 | reroute | 1 | 69583 | 3 | 3.313 | 21003.0 |
| 495 | 2025-02-18 12:32:50 | reroute | 1 | 69583 | 3 | 5.173 | 13451.2 |
| 494 | 2025-02-14 19:19:23 | reroute | 2 | 107671 | 20 | 26.170 | 4114.3 |
| 493 | 2025-02-12 23:15:19 | reroute | 2 | 107671 | 20 | 11.673 | 9223.9 |
| 492 | 2025-02-03 15:44:46 | reroute | 1 | 69583 | 3 | 4.970 | 14000.6 |
| 491 | 2025-01-26 01:16:22 | reroute | 1 | 69583 | 3 | 3.123 | 22280.8 |
| 490 | 2025-01-25 13:58:17 | reroute | 1 | 69583 | 3 | 6.406 | 10862.2 |
| 489 | 2025-01-23 22:26:31 | reroute | 1 | 69583 | 3 | 7.906 | 8801.3 |
| 488 | 2024-12-28 05:12:28 | reroute | 1 | 69583 | 3 | 9.063 | 7677.7 |
| 487 | 2024-12-26 12:03:45 | reroute | 1 | 69583 | 3 | 4.670 | 14900.0 |
| 486 | 2024-12-26 09:43:51 | reroute | 1 | 69583 | 3 | 7.343 | 9476.1 |
| 485 | 2024-11-26 09:09:13 | reroute | 1 | 69583 | 3 | 3.046 | 22844.1 |
| 484 | 2024-11-24 16:42:40 | reroute | 1 | 69583 | 3 | 2.716 | 25619.7 |
| 483 | 2024-10-23 15:47:21 | reroute | 1 | 69583 | 3 | 5.830 | 11935.3 |
| 482 | 2024-10-13 11:26:57 | reroute | 1 | 69583 | 3 | 1.720 | 40455.2 |
| 481 | 2024-10-08 01:09:32 | reroute | 1 | 69583 | 3 | 5.360 | 12981.9 |
| 480 | 2024-10-07 02:38:20 | reroute | 1 | 69583 | 3 | 6.280 | 11080.1 |
| 479 | 2024-09-29 09:57:23 | reroute | 3 | 134027 | 311 | 47.143 | 2843.0 |
| 478 | 2024-09-29 02:57:16 | reroute | 3 | 134027 | 311 | 59.180 | 2264.7 |
| 477 | 2024-09-26 09:05:08 | reroute | 2 | 107671 | 20 | 3.890 | 27678.9 |
| 476 | 2024-09-25 12:02:54 | reroute | 2 | 107671 | 20 | 36.580 | 2943.4 |
| 475 | 2024-09-25 12:02:43 | reroute | 3 | 134027 | 311 | 37.080 | 3614.5 |
| 474 | 2024-09-12 00:23:47 | reroute | 1 | 69583 | 3 | 7.953 | 8749.3 |
| 473 | 2024-09-09 03:15:35 | reroute | 1 | 69583 | 3 | 10.420 | 6677.8 |
| 472 | 2024-08-31 14:23:55 | reroute | 1 | 69583 | 3 | 5.203 | 13373.6 |
| 471 | 2024-08-28 06:23:19 | reroute | 1 | 69583 | 3 | 10.923 | 6370.3 |
| 470 | 2024-08-18 00:57:05 | reroute | 1 | 69583 | 3 | 10.360 | 6716.5 |
| 469 | 2024-08-12 08:50:37 | reroute | 1 | 69583 | 3 | 13.906 | 5003.8 |
| 468 | 2024-08-09 16:30:42 | reroute | 1 | 69583 | 3 | 2.283 | 30478.8 |
| 467 | 2024-08-01 09:02:16 | reroute | 1 | 69583 | 3 | 3.373 | 20629.4 |
| 466 | 2024-07-20 17:18:08 | reroute | 1 | 69583 | 3 | 3.186 | 21840.2 |
| 465 | 2024-07-17 08:33:02 | reroute | 1 | 69583 | 3 | 4.250 | 16372.5 |
| 464 | 2024-06-23 05:11:39 | reroute | 2 | 107671 | 20 | 14.156 | 7606.0 |
| 463 | 2024-06-23 05:11:05 | reroute | 1 | 69583 | 3 | 5.530 | 12582.8 |
| 462 | 2024-06-21 03:55:35 | reroute | 1 | 69583 | 3 | 7.016 | 9917.8 |
| 461 | 2024-06-20 12:48:45 | reroute | 1 | 69583 | 3 | 3.970 | 17527.2 |
| 460 | 2024-06-14 11:37:51 | reroute | 3 | 134027 | 311 | 27.313 | 4907.1 |
| 459 | 2024-06-14 03:21:52 | reroute | 3 | 134027 | 311 | 14.296 | 9375.1 |
| 458 | 2024-06-10 09:42:09 | reroute | 1 | 69583 | 3 | 4.330 | 16070.0 |
| 457 | 2024-06-08 05:27:00 | reroute | 3 | 134027 | 311 | 11.423 | 11733.1 |
| 456 | 2024-06-07 05:12:46 | reroute | 3 | 134027 | 311 | 12.190 | 10994.8 |
| 455 | 2024-06-07 00:12:07 | reroute | 3 | 134027 | 311 | 14.173 | 9456.5 |
| 454 | 2024-06-06 21:54:13 | reroute | 3 | 134027 | 311 | 15.360 | 8725.7 |
| 453 | 2024-06-05 01:50:18 | reroute | 1 | 69583 | 3 | 2.110 | 32977.7 |
| 452 | 2024-05-22 00:43:02 | reroute | 1 | 69583 | 3 | 1.826 | 38106.8 |
| 451 | 2024-05-10 22:50:46 | reroute | 1 | 69583 | 3 | 2.576 | 27012.0 |
| 450 | 2024-05-07 15:30:47 | reroute | 2 | 107671 | 20 | 13.863 | 7766.8 |
| 449 | 2024-05-07 09:07:07 | reroute | 3 | 134027 | 311 | 7.360 | 18210.2 |
| 448 | 2024-05-06 21:09:09 | reroute | 2 | 107671 | 20 | 6.033 | 17847.0 |
| 447 | 2024-05-06 19:04:33 | reroute | 3 | 134027 | 311 | 13.000 | 10309.8 |
| 446 | 2024-05-06 08:59:29 | reroute | 3 | 134027 | 311 | 10.406 | 12879.8 |
| 445 | 2024-05-06 02:36:24 | reroute | 2 | 107671 | 20 | 7.513 | 14331.3 |
| 444 | 2024-05-06 02:36:20 | reroute | 3 | 134027 | 311 | 10.110 | 13256.9 |
| 443 | 2024-05-06 02:35:44 | reroute | 1 | 69583 | 3 | 4.203 | 16555.6 |
| 442 | 2024-05-06 02:34:23 | reroute | 3 | 134027 | 311 | 8.233 | 16279.2 |
| 441 | 2024-05-06 02:34:15 | reroute | 2 | 107671 | 20 | 6.420 | 16771.2 |
| 440 | 2024-05-05 05:57:29 | reroute | 2 | 107671 | 20 | 4.826 | 22310.6 |
| 439 | 2024-04-30 23:48:33 | reroute | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 438 | 2024-03-03 04:42:59 | reroute | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 437 | 2024-02-07 06:28:50 | reroute | 2 | 107671 | 20 | 3.466 | 31064.9 |
| 436 | 2024-02-07 06:28:30 | reroute | 3 | 134027 | 311 | 7.953 | 16852.4 |