History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"troopers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 591 | 2025-12-06 17:39:17 | troopers | 1 | 82945 | 3 | 1.656 | 50087.6 |
| 590 | 2025-11-29 15:26:33 | troopers | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 589 | 2025-11-24 22:09:43 | troopers | 1 | 82945 | 3 | 1.733 | 47862.1 |
| 588 | 2025-11-22 13:58:36 | troopers | 1 | 82945 | 3 | 1.840 | 45078.8 |
| 587 | 2025-11-15 15:11:53 | troopers | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 586 | 2025-11-14 22:37:20 | troopers | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 585 | 2025-11-08 08:19:18 | troopers | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 584 | 2025-11-07 14:17:28 | troopers | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 583 | 2025-11-04 00:44:13 | troopers | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 582 | 2025-10-28 20:58:29 | troopers | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 581 | 2025-10-24 13:05:41 | troopers | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 580 | 2025-10-23 14:37:57 | troopers | 1 | 82945 | 3 | 7.186 | 11542.6 |
| 579 | 2025-10-23 09:38:32 | troopers | 3 | 146162 | 342 | 22.970 | 6363.2 |
| 578 | 2025-10-23 09:38:02 | troopers | 3 | 146162 | 342 | 50.566 | 2890.5 |
| 577 | 2025-10-23 09:37:20 | troopers | 3 | 146162 | 342 | 42.050 | 3475.9 |
| 576 | 2025-10-23 09:36:37 | troopers | 3 | 146162 | 342 | 44.956 | 3251.2 |
| 575 | 2025-10-16 09:34:29 | troopers | 3 | 146162 | 342 | 6.703 | 21805.5 |
| 574 | 2025-10-12 07:50:37 | troopers | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 573 | 2025-10-12 00:53:08 | troopers | 3 | 146162 | 342 | 6.560 | 22280.8 |
| 572 | 2025-10-06 20:19:21 | troopers | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 571 | 2025-09-29 07:38:28 | troopers | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 570 | 2025-09-26 06:27:46 | troopers | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 569 | 2025-09-25 19:38:43 | troopers | 1 | 82945 | 3 | 3.753 | 22101.0 |
| 568 | 2025-09-21 05:14:23 | troopers | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 567 | 2025-09-14 18:27:46 | troopers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 566 | 2025-09-08 20:16:58 | troopers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 565 | 2025-08-27 08:47:30 | troopers | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 564 | 2025-08-24 22:35:57 | troopers | 1 | 82945 | 3 | 6.813 | 12174.5 |
| 563 | 2025-08-23 20:40:11 | troopers | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 562 | 2025-08-18 07:46:33 | troopers | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 561 | 2025-08-16 11:25:15 | troopers | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 560 | 2025-08-12 17:57:07 | troopers | 2 | 121059 | 49 | 9.343 | 12957.2 |
| 559 | 2025-08-11 01:41:03 | troopers | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 558 | 2025-08-10 08:33:14 | troopers | 1 | 82945 | 3 | 6.420 | 12919.8 |
| 557 | 2025-08-10 05:25:59 | troopers | 3 | 146162 | 342 | 26.733 | 5467.5 |
| 556 | 2025-08-08 13:01:57 | troopers | 3 | 146162 | 342 | 11.530 | 12676.7 |
| 555 | 2025-08-05 18:43:31 | troopers | 1 | 82945 | 3 | 2.436 | 34049.7 |
| 554 | 2025-08-02 00:30:31 | troopers | 2 | 121059 | 49 | 8.063 | 15014.1 |
| 553 | 2025-07-27 23:05:33 | troopers | 3 | 146162 | 342 | 21.720 | 6729.4 |
| 552 | 2025-07-27 18:21:00 | troopers | 3 | 146162 | 342 | 21.250 | 6878.2 |
| 551 | 2025-07-25 10:39:13 | troopers | 3 | 146162 | 342 | 29.610 | 4936.2 |
| 550 | 2025-07-24 14:36:43 | troopers | 3 | 146162 | 342 | 21.770 | 6713.9 |
| 549 | 2025-07-24 04:53:01 | troopers | 3 | 146162 | 342 | 39.063 | 3741.7 |
| 548 | 2025-07-23 14:52:51 | troopers | 1 | 82945 | 3 | 10.796 | 7682.9 |
| 547 | 2025-07-23 14:43:59 | troopers | 3 | 146162 | 342 | 35.656 | 4099.2 |
| 546 | 2025-07-23 13:38:46 | troopers | 3 | 146162 | 342 | 24.813 | 5890.5 |
| 545 | 2025-07-22 17:15:45 | troopers | 1 | 82945 | 3 | 5.013 | 16546.0 |
| 544 | 2025-07-22 13:39:24 | troopers | 1 | 82945 | 3 | 5.123 | 16190.7 |
| 543 | 2025-07-19 19:35:42 | troopers | 3 | 146162 | 342 | 7.766 | 18820.8 |
| 542 | 2025-07-14 18:03:32 | troopers | 1 | 82945 | 3 | 5.406 | 15343.1 |
| 541 | 2025-07-14 14:16:06 | troopers | 1 | 82945 | 3 | 3.800 | 21827.6 |
| 540 | 2025-07-10 20:23:43 | troopers | 1 | 82945 | 3 | 5.873 | 14123.1 |
| 539 | 2025-07-07 22:14:29 | troopers | 1 | 82945 | 3 | 3.686 | 22502.7 |
| 538 | 2025-07-04 08:01:04 | troopers | 1 | 82945 | 3 | 6.780 | 12233.8 |
| 537 | 2025-06-29 18:17:47 | troopers | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 536 | 2025-06-24 15:59:54 | troopers | 3 | 146162 | 342 | 25.440 | 5745.4 |
| 535 | 2025-06-24 10:24:22 | troopers | 1 | 82945 | 3 | 4.720 | 17573.1 |
| 534 | 2025-06-22 02:30:46 | troopers | 3 | 146162 | 342 | 38.016 | 3844.7 |
| 533 | 2025-06-20 12:57:01 | troopers | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 532 | 2025-06-17 14:48:42 | troopers | 3 | 146162 | 342 | 33.923 | 4308.6 |
| 531 | 2025-06-15 02:34:36 | troopers | 1 | 82945 | 3 | 2.923 | 28376.7 |
| 530 | 2025-06-14 01:41:12 | troopers | 3 | 146162 | 342 | 28.126 | 5196.7 |
| 529 | 2025-06-12 19:32:51 | troopers | 2 | 121059 | 49 | 8.873 | 13643.5 |
| 528 | 2025-06-11 13:04:03 | troopers | 1 | 82945 | 3 | 5.046 | 16437.8 |
| 527 | 2025-06-11 02:42:46 | troopers | 3 | 146162 | 342 | 34.063 | 4290.9 |
| 526 | 2025-06-10 13:29:46 | troopers | 3 | 146162 | 342 | 40.126 | 3642.6 |
| 525 | 2025-06-10 10:50:06 | troopers | 3 | 146162 | 342 | 21.893 | 6676.2 |
| 524 | 2025-06-10 09:59:04 | troopers | 3 | 146162 | 342 | 33.690 | 4338.4 |
| 523 | 2025-06-08 22:20:04 | troopers | 3 | 146162 | 342 | 8.096 | 18053.6 |
| 522 | 2025-06-08 14:12:33 | troopers | 1 | 82945 | 3 | 3.703 | 22399.4 |
| 521 | 2025-06-04 07:07:32 | troopers | 1 | 82945 | 3 | 5.093 | 16286.1 |
| 520 | 2025-06-04 06:07:17 | troopers | 1 | 82945 | 3 | 4.080 | 20329.7 |
| 519 | 2025-06-03 05:57:09 | troopers | 1 | 82945 | 3 | 7.893 | 10508.7 |
| 518 | 2025-06-02 12:35:11 | troopers | 1 | 82945 | 3 | 5.110 | 16231.9 |
| 517 | 2025-06-01 07:41:02 | troopers | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 516 | 2025-05-31 05:41:06 | troopers | 1 | 82945 | 3 | 7.626 | 10876.6 |
| 515 | 2025-05-30 14:36:48 | troopers | 1 | 82945 | 3 | 5.436 | 15258.5 |
| 514 | 2025-05-26 23:46:52 | troopers | 1 | 82945 | 3 | 7.076 | 11722.0 |
| 513 | 2025-05-26 23:18:09 | troopers | 3 | 146162 | 342 | 51.470 | 2839.8 |
| 512 | 2025-05-22 10:12:19 | troopers | 1 | 82945 | 3 | 4.076 | 20349.6 |
| 511 | 2025-05-17 05:35:53 | troopers | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 510 | 2025-05-15 06:34:33 | troopers | 3 | 146162 | 342 | 9.610 | 15209.4 |
| 509 | 2025-05-09 11:45:53 | troopers | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 508 | 2025-05-08 13:19:46 | troopers | 3 | 146162 | 342 | 39.970 | 3656.8 |
| 507 | 2025-05-08 11:19:25 | troopers | 2 | 121059 | 49 | 17.063 | 7094.8 |
| 506 | 2025-05-07 04:05:09 | troopers | 2 | 121059 | 49 | 3.673 | 32959.2 |
| 505 | 2025-05-07 02:04:26 | troopers | 3 | 146162 | 342 | 10.030 | 14572.5 |
| 504 | 2025-05-06 19:42:43 | troopers | 2 | 121059 | 49 | 3.876 | 31233.0 |
| 503 | 2025-05-05 02:06:31 | troopers | 3 | 146162 | 342 | 24.190 | 6042.2 |
| 502 | 2025-05-05 00:49:41 | troopers | 3 | 146162 | 342 | 7.596 | 19242.0 |
| 501 | 2025-05-04 11:46:32 | troopers | 2 | 121059 | 49 | 11.720 | 10329.3 |
| 500 | 2025-05-04 09:53:38 | troopers | 3 | 146162 | 342 | 31.156 | 4691.3 |
| 499 | 2025-05-03 23:56:21 | troopers | 1 | 82945 | 3 | 9.843 | 8426.8 |
| 498 | 2025-05-03 05:45:01 | troopers | 1 | 82945 | 3 | 8.216 | 10095.5 |
| 497 | 2025-05-02 22:32:42 | troopers | 3 | 146162 | 342 | 56.253 | 2598.3 |
| 496 | 2025-05-02 07:11:37 | troopers | 1 | 82945 | 3 | 8.203 | 10111.5 |
| 495 | 2025-05-01 00:42:25 | troopers | 2 | 121059 | 49 | 27.626 | 4382.1 |
| 494 | 2025-04-30 05:21:57 | troopers | 1 | 82945 | 3 | 7.780 | 10661.3 |
| 493 | 2025-04-22 08:41:14 | troopers | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 492 | 2025-04-19 11:09:46 | troopers | 3 | 146162 | 342 | 6.986 | 20922.1 |