History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substations"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 531 | 2026-02-12 13:12:06 | substations | 1 | 49908 | 2 | 1.016 | 49122.0 |
| 530 | 2026-02-10 07:32:09 | substations | 4 | 148819 | 287 | 50.676 | 2936.7 |
| 529 | 2026-02-10 07:31:59 | substations | 4 | 148819 | 287 | 44.273 | 3361.4 |
| 528 | 2026-02-10 07:31:35 | substations | 4 | 148819 | 287 | 33.533 | 4438.0 |
| 527 | 2026-02-08 23:20:40 | substations | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 526 | 2026-02-08 10:20:59 | substations | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 525 | 2026-02-03 01:46:30 | substations | 4 | 148819 | 287 | 48.533 | 3066.3 |
| 524 | 2026-02-03 01:46:52 | substations | 4 | 148819 | 287 | 24.800 | 6000.8 |
| 523 | 2026-02-03 01:25:18 | substations | 4 | 148819 | 287 | 46.536 | 3197.9 |
| 522 | 2026-02-03 01:24:22 | substations | 4 | 148819 | 287 | 24.030 | 6193.1 |
| 521 | 2026-02-03 01:23:36 | substations | 4 | 148819 | 287 | 44.140 | 3371.5 |
| 520 | 2026-02-03 01:22:56 | substations | 4 | 148819 | 287 | 24.316 | 6120.2 |
| 519 | 2026-01-26 04:46:33 | substations | 1 | 49908 | 2 | 0.830 | 60130.1 |
| 518 | 2026-01-25 00:55:11 | substations | 4 | 148819 | 287 | 41.830 | 3557.7 |
| 517 | 2026-01-24 12:46:35 | substations | 4 | 148819 | 287 | 43.110 | 3452.1 |
| 516 | 2026-01-24 12:46:19 | substations | 4 | 148819 | 287 | 28.906 | 5148.4 |
| 515 | 2026-01-24 12:45:53 | substations | 4 | 148819 | 287 | 47.706 | 3119.5 |
| 514 | 2026-01-24 12:45:33 | substations | 4 | 148819 | 287 | 35.266 | 4219.9 |
| 513 | 2026-01-22 06:40:31 | substations | 4 | 148819 | 287 | 36.563 | 4070.2 |
| 512 | 2026-01-22 06:40:11 | substations | 4 | 148819 | 287 | 50.020 | 2975.2 |
| 511 | 2026-01-22 06:39:48 | substations | 4 | 148819 | 287 | 40.126 | 3708.8 |
| 510 | 2026-01-22 06:39:32 | substations | 4 | 148819 | 287 | 47.426 | 3137.9 |
| 509 | 2026-01-21 11:57:58 | substations | 1 | 49908 | 2 | 0.783 | 63739.5 |
| 508 | 2026-01-19 05:27:24 | substations | 1 | 49908 | 2 | 0.826 | 60421.3 |
| 507 | 2026-01-19 05:25:41 | substations | 1 | 49908 | 2 | 1.013 | 49267.5 |
| 506 | 2026-01-15 05:15:58 | substations | 4 | 148819 | 287 | 16.796 | 8860.4 |
| 505 | 2026-01-09 22:00:59 | substations | 2 | 86808 | 7 | 2.186 | 39710.9 |
| 504 | 2026-01-09 20:34:52 | substations | 2 | 86808 | 7 | 2.470 | 35144.9 |
| 503 | 2026-01-09 02:04:20 | substations | 3 | 121633 | 56 | 7.250 | 16777.0 |
| 502 | 2026-01-08 21:26:41 | substations | 3 | 121633 | 56 | 4.500 | 27029.6 |
| 501 | 2026-01-07 01:01:51 | substations | 2 | 86808 | 7 | 2.390 | 36321.3 |
| 500 | 2026-01-06 08:31:26 | substations | 3 | 121633 | 56 | 5.126 | 23728.6 |
| 499 | 2026-01-03 11:10:39 | substations | 4 | 148819 | 287 | 49.990 | 2977.0 |
| 498 | 2026-01-03 11:10:13 | substations | 4 | 148819 | 287 | 39.440 | 3773.3 |
| 497 | 2026-01-02 11:50:01 | substations | 2 | 86808 | 7 | 2.140 | 40564.5 |
| 496 | 2026-01-02 05:21:33 | substations | 3 | 121633 | 56 | 14.593 | 8335.0 |
| 495 | 2026-01-01 00:22:58 | substations | 3 | 121633 | 56 | 4.923 | 24707.1 |
| 494 | 2025-12-30 14:42:26 | substations | 3 | 121633 | 56 | 5.110 | 23802.9 |
| 493 | 2025-12-30 13:15:41 | substations | 4 | 148819 | 287 | 10.000 | 14881.9 |
| 492 | 2025-12-30 12:17:44 | substations | 1 | 49908 | 2 | 0.890 | 56076.4 |
| 491 | 2025-12-30 05:42:25 | substations | 4 | 148819 | 287 | 9.326 | 15957.4 |
| 490 | 2025-12-29 21:01:35 | substations | 2 | 86808 | 7 | 2.410 | 36019.9 |
| 489 | 2025-12-29 14:52:55 | substations | 4 | 148819 | 287 | 8.203 | 18142.0 |
| 488 | 2025-12-28 01:06:50 | substations | 4 | 148819 | 287 | 8.453 | 17605.5 |
| 487 | 2025-12-26 15:24:54 | substations | 1 | 49908 | 2 | 0.810 | 61614.8 |
| 486 | 2025-12-26 15:24:08 | substations | 1 | 49908 | 2 | 0.983 | 50771.1 |
| 485 | 2025-12-24 08:25:26 | substations | 1 | 49908 | 2 | 0.810 | 61614.8 |
| 484 | 2025-11-30 02:19:23 | substations | 1 | 49908 | 2 | 0.843 | 59202.8 |
| 483 | 2025-11-29 03:42:01 | substations | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 482 | 2025-11-28 01:11:47 | substations | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 481 | 2025-11-25 05:39:34 | substations | 1 | 49908 | 2 | 0.950 | 52534.7 |
| 480 | 2025-11-24 23:55:29 | substations | 1 | 49908 | 2 | 0.953 | 52369.4 |
| 479 | 2025-11-23 14:45:32 | substations | 1 | 49908 | 2 | 0.856 | 58303.7 |
| 478 | 2025-11-23 03:03:41 | substations | 1 | 49908 | 2 | 1.050 | 47531.4 |
| 477 | 2025-11-17 09:45:49 | substations | 1 | 49908 | 2 | 0.923 | 54071.5 |
| 476 | 2025-11-16 02:24:05 | substations | 4 | 148819 | 287 | 25.860 | 5754.8 |
| 475 | 2025-11-08 05:34:05 | substations | 4 | 148819 | 287 | 10.813 | 13763.0 |
| 474 | 2025-11-01 01:20:31 | substations | 4 | 148819 | 287 | 9.733 | 15290.1 |
| 473 | 2025-10-30 12:02:06 | substations | 4 | 148819 | 287 | 8.593 | 17318.6 |
| 472 | 2025-10-30 03:30:31 | substations | 1 | 49908 | 2 | 0.766 | 65154.0 |
| 471 | 2025-10-29 04:22:15 | substations | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 470 | 2025-10-28 02:32:19 | substations | 1 | 49908 | 2 | 0.923 | 54071.5 |
| 469 | 2025-10-25 00:42:11 | substations | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 468 | 2025-10-23 16:00:27 | substations | 1 | 49908 | 2 | 2.703 | 18463.9 |
| 467 | 2025-10-23 08:58:18 | substations | 1 | 49908 | 2 | 3.983 | 12530.3 |
| 466 | 2025-10-19 08:03:02 | substations | 1 | 49908 | 2 | 1.766 | 28260.5 |
| 465 | 2025-10-17 10:06:36 | substations | 1 | 49908 | 2 | 0.890 | 56076.4 |
| 464 | 2025-10-15 17:21:47 | substations | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 463 | 2025-10-11 21:27:23 | substations | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 462 | 2025-09-29 03:24:58 | substations | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 461 | 2025-09-28 05:00:04 | substations | 1 | 49908 | 2 | 2.123 | 23508.2 |
| 460 | 2025-09-27 02:25:07 | substations | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 459 | 2025-09-21 06:54:06 | substations | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 458 | 2025-09-20 00:50:19 | substations | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 457 | 2025-09-19 04:09:26 | substations | 1 | 49908 | 2 | 1.220 | 40908.2 |
| 456 | 2025-09-09 10:13:29 | substations | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 455 | 2025-09-05 22:07:43 | substations | 1 | 49908 | 2 | 0.966 | 51664.6 |
| 454 | 2025-08-29 03:48:41 | substations | 1 | 49908 | 2 | 0.780 | 63984.6 |
| 453 | 2025-08-28 04:31:55 | substations | 1 | 49908 | 2 | 0.763 | 65410.2 |
| 452 | 2025-08-27 02:22:55 | substations | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 451 | 2025-08-26 18:36:01 | substations | 2 | 86808 | 7 | 2.126 | 40831.6 |
| 450 | 2025-08-19 04:27:47 | substations | 1 | 49908 | 2 | 1.560 | 31992.3 |
| 449 | 2025-08-15 07:24:13 | substations | 1 | 49908 | 2 | 3.703 | 13477.7 |
| 448 | 2025-08-09 10:31:14 | substations | 1 | 49908 | 2 | 3.330 | 14987.4 |
| 447 | 2025-08-04 17:45:02 | substations | 1 | 49908 | 2 | 1.986 | 25129.9 |
| 446 | 2025-07-28 06:19:52 | substations | 1 | 49908 | 2 | 2.046 | 24393.0 |
| 445 | 2025-07-24 05:55:33 | substations | 1 | 49908 | 2 | 3.703 | 13477.7 |
| 444 | 2025-07-15 19:09:32 | substations | 4 | 148819 | 287 | 9.453 | 15743.0 |
| 443 | 2025-07-14 08:36:06 | substations | 3 | 121633 | 56 | 15.470 | 7862.5 |
| 442 | 2025-07-11 19:48:48 | substations | 4 | 148819 | 287 | 43.976 | 3384.1 |
| 441 | 2025-07-11 16:13:47 | substations | 4 | 148819 | 287 | 44.926 | 3312.5 |
| 440 | 2025-07-11 10:59:26 | substations | 1 | 49908 | 2 | 7.546 | 6613.8 |
| 439 | 2025-07-11 08:09:29 | substations | 2 | 86808 | 7 | 11.733 | 7398.6 |
| 438 | 2025-07-10 19:21:57 | substations | 4 | 148819 | 287 | 52.620 | 2828.2 |
| 437 | 2025-07-10 17:44:20 | substations | 3 | 121633 | 56 | 13.263 | 9170.9 |
| 436 | 2025-07-10 11:44:40 | substations | 2 | 86808 | 7 | 11.406 | 7610.7 |
| 435 | 2025-07-10 10:22:15 | substations | 4 | 148819 | 287 | 18.626 | 7989.9 |
| 434 | 2025-07-09 05:00:38 | substations | 1 | 49908 | 2 | 0.890 | 56076.4 |
| 433 | 2025-07-07 10:05:38 | substations | 1 | 49908 | 2 | 4.186 | 11922.6 |
| 432 | 2025-07-04 16:50:50 | substations | 1 | 49908 | 2 | 4.343 | 11491.6 |