History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 644 | 2025-12-02 15:23:15 | substates | 1 | 81242 | 4 | 1.420 | 57212.7 |
| 643 | 2025-12-02 14:12:24 | substates | 3 | 148641 | 107 | 8.063 | 18434.9 |
| 642 | 2025-11-30 21:11:18 | substates | 1 | 81242 | 4 | 5.500 | 14771.3 |
| 641 | 2025-11-30 03:02:36 | substates | 1 | 81242 | 4 | 1.533 | 52995.4 |
| 640 | 2025-11-29 18:06:38 | substates | 1 | 81242 | 4 | 1.390 | 58447.5 |
| 639 | 2025-11-28 02:50:57 | substates | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 638 | 2025-11-25 01:13:26 | substates | 3 | 148641 | 107 | 15.233 | 9757.8 |
| 637 | 2025-11-24 13:53:02 | substates | 1 | 81242 | 4 | 1.440 | 56418.1 |
| 636 | 2025-11-23 16:53:53 | substates | 1 | 81242 | 4 | 2.813 | 28880.9 |
| 635 | 2025-11-21 04:04:10 | substates | 1 | 81242 | 4 | 1.470 | 55266.7 |
| 634 | 2025-11-21 00:01:17 | substates | 1 | 81242 | 4 | 1.546 | 52549.8 |
| 633 | 2025-11-15 03:12:47 | substates | 1 | 81242 | 4 | 1.563 | 51978.2 |
| 632 | 2025-11-10 02:41:07 | substates | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 631 | 2025-11-08 02:16:14 | substates | 1 | 81242 | 4 | 1.516 | 53589.7 |
| 630 | 2025-10-31 14:52:12 | substates | 1 | 81242 | 4 | 1.450 | 56029.0 |
| 629 | 2025-10-30 20:32:57 | substates | 1 | 81242 | 4 | 1.436 | 56575.2 |
| 628 | 2025-10-30 03:55:55 | substates | 1 | 81242 | 4 | 1.610 | 50460.9 |
| 627 | 2025-10-29 18:57:14 | substates | 1 | 81242 | 4 | 2.813 | 28880.9 |
| 626 | 2025-10-28 04:19:10 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 625 | 2025-10-25 00:50:29 | substates | 1 | 81242 | 4 | 1.486 | 54671.6 |
| 624 | 2025-10-24 16:09:43 | substates | 2 | 121436 | 15 | 3.233 | 37561.4 |
| 623 | 2025-10-24 14:03:45 | substates | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 622 | 2025-10-24 12:00:06 | substates | 2 | 121436 | 15 | 3.170 | 38307.9 |
| 621 | 2025-10-24 09:44:19 | substates | 2 | 121436 | 15 | 5.156 | 23552.4 |
| 620 | 2025-10-24 09:43:53 | substates | 2 | 121436 | 15 | 3.346 | 36292.9 |
| 619 | 2025-10-24 02:32:21 | substates | 3 | 148641 | 107 | 6.750 | 22020.9 |
| 618 | 2025-10-23 19:33:27 | substates | 3 | 148641 | 107 | 28.406 | 5232.7 |
| 617 | 2025-10-22 23:37:58 | substates | 3 | 148641 | 107 | 36.220 | 4103.8 |
| 616 | 2025-10-22 19:17:15 | substates | 3 | 148641 | 107 | 34.033 | 4367.6 |
| 615 | 2025-10-21 17:16:57 | substates | 2 | 121436 | 15 | 15.313 | 7930.3 |
| 614 | 2025-10-21 11:27:52 | substates | 1 | 81242 | 4 | 4.266 | 19044.1 |
| 613 | 2025-10-18 16:26:06 | substates | 1 | 81242 | 4 | 1.530 | 53099.3 |
| 612 | 2025-10-17 13:08:37 | substates | 2 | 121436 | 15 | 3.690 | 32909.5 |
| 611 | 2025-10-16 00:01:10 | substates | 3 | 148641 | 107 | 6.266 | 23721.8 |
| 610 | 2025-10-13 08:21:43 | substates | 1 | 81242 | 4 | 1.470 | 55266.7 |
| 609 | 2025-10-12 18:41:11 | substates | 1 | 81242 | 4 | 1.576 | 51549.5 |
| 608 | 2025-10-09 03:49:43 | substates | 1 | 81242 | 4 | 1.423 | 57092.1 |
| 607 | 2025-10-08 03:05:09 | substates | 1 | 81242 | 4 | 1.263 | 64324.6 |
| 606 | 2025-10-04 04:02:32 | substates | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 605 | 2025-09-30 16:27:02 | substates | 1 | 81242 | 4 | 1.560 | 52078.2 |
| 604 | 2025-09-29 03:48:40 | substates | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 603 | 2025-09-28 18:59:10 | substates | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 602 | 2025-09-28 07:58:45 | substates | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 601 | 2025-09-27 04:20:43 | substates | 1 | 81242 | 4 | 1.283 | 63321.9 |
| 600 | 2025-09-23 14:04:41 | substates | 1 | 81242 | 4 | 1.420 | 57212.7 |
| 599 | 2025-09-20 19:41:49 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 598 | 2025-09-20 17:04:15 | substates | 1 | 81242 | 4 | 1.546 | 52549.8 |
| 597 | 2025-09-20 05:02:59 | substates | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 596 | 2025-09-15 08:31:41 | substates | 1 | 81242 | 4 | 1.470 | 55266.7 |
| 595 | 2025-09-14 10:06:00 | substates | 1 | 81242 | 4 | 1.313 | 61875.1 |
| 594 | 2025-09-08 22:11:10 | substates | 1 | 81242 | 4 | 1.283 | 63321.9 |
| 593 | 2025-09-08 03:53:27 | substates | 1 | 81242 | 4 | 1.423 | 57092.1 |
| 592 | 2025-09-03 02:56:25 | substates | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 591 | 2025-09-02 12:24:43 | substates | 1 | 81242 | 4 | 1.423 | 57092.1 |
| 590 | 2025-08-29 04:08:54 | substates | 1 | 81242 | 4 | 1.280 | 63470.3 |
| 589 | 2025-08-28 19:00:10 | substates | 1 | 81242 | 4 | 1.450 | 56029.0 |
| 588 | 2025-08-28 12:01:13 | substates | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 587 | 2025-08-27 03:32:31 | substates | 1 | 81242 | 4 | 1.360 | 59736.8 |
| 586 | 2025-08-25 14:32:06 | substates | 1 | 81242 | 4 | 5.000 | 16248.4 |
| 585 | 2025-08-21 05:03:22 | substates | 1 | 81242 | 4 | 5.906 | 13755.8 |
| 584 | 2025-08-15 08:36:58 | substates | 1 | 81242 | 4 | 3.470 | 23412.7 |
| 583 | 2025-08-14 01:01:27 | substates | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 582 | 2025-08-07 12:01:05 | substates | 2 | 121436 | 15 | 7.626 | 15923.9 |
| 581 | 2025-08-01 06:39:34 | substates | 1 | 81242 | 4 | 5.050 | 16087.5 |
| 580 | 2025-07-27 06:55:58 | substates | 1 | 81242 | 4 | 3.203 | 25364.3 |
| 579 | 2025-07-23 12:04:06 | substates | 3 | 148641 | 107 | 33.080 | 4493.4 |
| 578 | 2025-07-22 15:40:47 | substates | 2 | 121436 | 15 | 9.390 | 12932.5 |
| 577 | 2025-07-20 00:19:42 | substates | 3 | 148641 | 107 | 7.156 | 20771.5 |
| 576 | 2025-07-16 08:56:42 | substates | 1 | 81242 | 4 | 1.890 | 42985.2 |
| 575 | 2025-07-15 15:29:35 | substates | 1 | 81242 | 4 | 4.266 | 19044.1 |
| 574 | 2025-07-12 21:27:09 | substates | 3 | 148641 | 107 | 14.626 | 10162.8 |
| 573 | 2025-07-12 18:50:47 | substates | 1 | 81242 | 4 | 1.516 | 53589.7 |
| 572 | 2025-07-12 11:36:53 | substates | 1 | 81242 | 4 | 1.750 | 46424.0 |
| 571 | 2025-07-09 08:46:01 | substates | 1 | 81242 | 4 | 10.580 | 7678.8 |
| 570 | 2025-07-09 02:54:43 | substates | 2 | 121436 | 15 | 4.283 | 28353.0 |
| 569 | 2025-07-08 10:11:24 | substates | 1 | 81242 | 4 | 7.606 | 10681.3 |
| 568 | 2025-07-07 19:38:05 | substates | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 567 | 2025-07-07 13:59:20 | substates | 3 | 148641 | 107 | 32.173 | 4620.1 |
| 566 | 2025-07-07 02:54:07 | substates | 1 | 81242 | 4 | 5.796 | 14016.9 |
| 565 | 2025-07-04 15:15:42 | substates | 3 | 148641 | 107 | 22.140 | 6713.7 |
| 564 | 2025-07-04 12:28:49 | substates | 1 | 81242 | 4 | 7.516 | 10809.2 |
| 563 | 2025-07-04 10:45:05 | substates | 2 | 121436 | 15 | 13.236 | 9174.7 |
| 562 | 2025-07-03 13:48:42 | substates | 1 | 81242 | 4 | 1.466 | 55417.5 |
| 561 | 2025-07-01 07:07:50 | substates | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 560 | 2025-06-30 18:43:00 | substates | 2 | 121436 | 15 | 12.686 | 9572.4 |
| 559 | 2025-06-28 04:40:41 | substates | 1 | 81242 | 4 | 3.203 | 25364.3 |
| 558 | 2025-06-27 16:46:32 | substates | 3 | 148641 | 107 | 21.263 | 6990.6 |
| 557 | 2025-06-26 21:39:06 | substates | 2 | 121436 | 15 | 3.546 | 34245.9 |
| 556 | 2025-06-26 05:42:48 | substates | 1 | 81242 | 4 | 6.826 | 11901.8 |
| 555 | 2025-06-25 17:32:41 | substates | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 554 | 2025-06-24 05:44:35 | substates | 1 | 81242 | 4 | 5.436 | 14945.2 |
| 553 | 2025-06-10 17:33:26 | substates | 1 | 81242 | 4 | 7.780 | 10442.4 |
| 552 | 2025-06-05 13:24:29 | substates | 1 | 81242 | 4 | 6.463 | 12570.3 |
| 551 | 2025-06-04 04:11:55 | substates | 1 | 81242 | 4 | 4.013 | 20244.7 |
| 550 | 2025-06-03 19:14:13 | substates | 1 | 81242 | 4 | 3.186 | 25499.7 |
| 549 | 2025-05-27 15:47:47 | substates | 3 | 148641 | 107 | 33.673 | 4414.2 |
| 548 | 2025-05-26 11:07:31 | substates | 3 | 148641 | 107 | 42.190 | 3523.1 |
| 547 | 2025-05-26 06:50:21 | substates | 1 | 81242 | 4 | 7.203 | 11278.9 |
| 546 | 2025-05-11 00:23:21 | substates | 3 | 148641 | 107 | 29.063 | 5114.4 |
| 545 | 2025-05-02 18:34:03 | substates | 2 | 121436 | 15 | 3.813 | 31847.9 |