History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crimes"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 711 | 2025-10-24 20:31:52 | crimes | 1 | 48755 | 12 | 0.846 | 57630.0 |
| 710 | 2025-10-24 16:50:11 | crimes | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 709 | 2025-10-22 18:54:09 | crimes | 1 | 48755 | 12 | 2.046 | 23829.4 |
| 708 | 2025-10-21 14:11:09 | crimes | 1 | 48755 | 12 | 0.873 | 55847.7 |
| 707 | 2025-10-21 02:26:39 | crimes | 1 | 48755 | 12 | 1.546 | 31536.2 |
| 706 | 2025-10-16 09:59:03 | crimes | 1 | 48755 | 12 | 0.970 | 50262.9 |
| 705 | 2025-10-14 22:13:26 | crimes | 1 | 48755 | 12 | 0.763 | 63899.1 |
| 704 | 2025-10-11 00:11:12 | crimes | 1 | 48755 | 12 | 0.780 | 62506.4 |
| 703 | 2025-10-07 08:01:00 | crimes | 1 | 48755 | 12 | 0.810 | 60191.4 |
| 702 | 2025-10-07 03:36:35 | crimes | 1 | 48755 | 12 | 0.876 | 55656.4 |
| 701 | 2025-10-03 06:05:59 | crimes | 1 | 48755 | 12 | 0.796 | 61250.0 |
| 700 | 2025-09-29 21:07:19 | crimes | 1 | 48755 | 12 | 0.940 | 51867.0 |
| 699 | 2025-09-28 19:17:40 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 698 | 2025-09-28 06:55:02 | crimes | 2 | 82551 | 165 | 2.283 | 36159.0 |
| 697 | 2025-09-22 22:43:30 | crimes | 1 | 48755 | 12 | 0.873 | 55847.7 |
| 696 | 2025-09-21 05:53:27 | crimes | 1 | 48755 | 12 | 0.796 | 61250.0 |
| 695 | 2025-09-17 22:44:03 | crimes | 1 | 48755 | 12 | 0.780 | 62506.4 |
| 694 | 2025-09-15 05:19:55 | crimes | 1 | 48755 | 12 | 0.846 | 57630.0 |
| 693 | 2025-09-13 01:24:08 | crimes | 1 | 48755 | 12 | 0.873 | 55847.7 |
| 692 | 2025-09-09 08:10:01 | crimes | 2 | 82551 | 165 | 2.610 | 31628.7 |
| 691 | 2025-09-09 04:13:38 | crimes | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 690 | 2025-09-07 15:35:00 | crimes | 1 | 48755 | 12 | 0.893 | 54596.9 |
| 689 | 2025-09-06 01:48:35 | crimes | 1 | 48755 | 12 | 0.876 | 55656.4 |
| 688 | 2025-09-05 14:10:53 | crimes | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 687 | 2025-09-03 13:55:47 | crimes | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 686 | 2025-09-01 07:56:37 | crimes | 1 | 48755 | 12 | 0.856 | 56956.8 |
| 685 | 2025-08-27 21:04:22 | crimes | 1 | 48755 | 12 | 0.923 | 52822.3 |
| 684 | 2025-08-27 03:50:14 | crimes | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 683 | 2025-08-26 04:29:11 | crimes | 1 | 48755 | 12 | 0.856 | 56956.8 |
| 682 | 2025-08-19 23:32:13 | crimes | 1 | 48755 | 12 | 0.873 | 55847.7 |
| 681 | 2025-08-18 15:42:44 | crimes | 1 | 48755 | 12 | 1.860 | 26212.4 |
| 680 | 2025-08-18 00:15:43 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 679 | 2025-08-05 00:10:39 | crimes | 2 | 82551 | 165 | 12.456 | 6627.4 |
| 678 | 2025-08-04 11:09:27 | crimes | 1 | 48755 | 12 | 3.060 | 15933.0 |
| 677 | 2025-08-03 12:49:46 | crimes | 2 | 82551 | 165 | 11.453 | 7207.8 |
| 676 | 2025-08-01 21:44:27 | crimes | 1 | 48755 | 12 | 2.250 | 21668.9 |
| 675 | 2025-08-01 15:51:49 | crimes | 1 | 48755 | 12 | 4.266 | 11428.7 |
| 674 | 2025-07-31 07:03:53 | crimes | 1 | 48755 | 12 | 2.266 | 21515.9 |
| 673 | 2025-07-30 09:37:04 | crimes | 1 | 48755 | 12 | 1.860 | 26212.4 |
| 672 | 2025-07-28 19:49:38 | crimes | 1 | 48755 | 12 | 2.170 | 22467.7 |
| 671 | 2025-07-27 08:06:42 | crimes | 1 | 48755 | 12 | 2.220 | 21961.7 |
| 670 | 2025-07-26 19:23:02 | crimes | 1 | 48755 | 12 | 1.796 | 27146.4 |
| 669 | 2025-07-26 19:23:01 | crimes | 1 | 48755 | 12 | 2.123 | 22965.1 |
| 668 | 2025-07-23 07:28:07 | crimes | 1 | 48755 | 12 | 2.390 | 20399.6 |
| 667 | 2025-07-23 01:54:45 | crimes | 1 | 48755 | 12 | 2.093 | 23294.3 |
| 666 | 2025-07-22 15:12:15 | crimes | 1 | 48755 | 12 | 3.533 | 13799.9 |
| 665 | 2025-07-21 14:14:05 | crimes | 1 | 48755 | 12 | 0.906 | 53813.5 |
| 664 | 2025-07-18 15:31:06 | crimes | 1 | 48755 | 12 | 5.656 | 8620.0 |
| 663 | 2025-07-12 20:22:15 | crimes | 1 | 48755 | 12 | 1.780 | 27390.4 |
| 662 | 2025-07-12 00:24:31 | crimes | 1 | 48755 | 12 | 0.906 | 53813.5 |
| 661 | 2025-07-08 10:35:12 | crimes | 1 | 48755 | 12 | 6.873 | 7093.7 |
| 660 | 2025-07-01 21:08:48 | crimes | 1 | 48755 | 12 | 2.673 | 18239.8 |
| 659 | 2025-07-01 12:35:55 | crimes | 1 | 48755 | 12 | 0.906 | 53813.5 |
| 658 | 2025-06-28 10:52:15 | crimes | 1 | 48755 | 12 | 3.533 | 13799.9 |
| 657 | 2025-06-28 07:51:12 | crimes | 1 | 48755 | 12 | 5.923 | 8231.5 |
| 656 | 2025-06-18 21:32:40 | crimes | 1 | 48755 | 12 | 6.373 | 7650.2 |
| 655 | 2025-06-18 00:45:34 | crimes | 1 | 48755 | 12 | 2.453 | 19875.7 |
| 654 | 2025-06-16 08:07:06 | crimes | 2 | 82551 | 165 | 9.546 | 8647.7 |
| 653 | 2025-06-15 17:34:47 | crimes | 2 | 82551 | 165 | 2.733 | 30205.3 |
| 652 | 2025-06-13 13:51:39 | crimes | 1 | 48755 | 12 | 1.796 | 27146.4 |
| 651 | 2025-06-13 00:54:11 | crimes | 2 | 82551 | 165 | 2.500 | 33020.4 |
| 650 | 2025-06-11 20:36:50 | crimes | 1 | 48755 | 12 | 4.250 | 11471.8 |
| 649 | 2025-06-07 06:38:20 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 648 | 2025-06-05 10:32:40 | crimes | 1 | 48755 | 12 | 4.343 | 11226.1 |
| 647 | 2025-06-01 03:16:54 | crimes | 1 | 48755 | 12 | 2.813 | 17332.0 |
| 646 | 2025-05-30 20:59:07 | crimes | 1 | 48755 | 12 | 4.313 | 11304.2 |
| 645 | 2025-05-25 01:45:07 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 644 | 2025-05-24 03:05:18 | crimes | 1 | 48755 | 12 | 3.890 | 12533.4 |
| 643 | 2025-05-22 04:10:30 | crimes | 1 | 48755 | 12 | 2.076 | 23485.1 |
| 642 | 2025-05-18 00:13:51 | crimes | 1 | 48755 | 12 | 2.720 | 17924.6 |
| 641 | 2025-05-16 15:06:23 | crimes | 1 | 48755 | 12 | 1.840 | 26497.3 |
| 640 | 2025-05-10 20:53:13 | crimes | 1 | 48755 | 12 | 2.186 | 22303.3 |
| 639 | 2025-05-09 10:58:30 | crimes | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 638 | 2025-05-02 18:20:38 | crimes | 1 | 48755 | 12 | 0.856 | 56956.8 |
| 637 | 2025-05-02 10:58:48 | crimes | 2 | 82551 | 165 | 8.970 | 9203.0 |
| 636 | 2025-05-02 01:35:01 | crimes | 2 | 82551 | 165 | 12.050 | 6850.7 |
| 635 | 2025-05-02 01:16:01 | crimes | 2 | 82551 | 165 | 9.203 | 8970.0 |
| 634 | 2025-05-01 01:39:30 | crimes | 2 | 82551 | 165 | 11.110 | 7430.3 |
| 633 | 2025-04-30 07:40:47 | crimes | 2 | 82551 | 165 | 16.126 | 5119.1 |
| 632 | 2025-04-30 06:37:34 | crimes | 1 | 48755 | 12 | 6.186 | 7881.5 |
| 631 | 2025-04-29 02:34:52 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 630 | 2025-04-27 20:22:19 | crimes | 1 | 48755 | 12 | 4.533 | 10755.6 |
| 629 | 2025-04-24 16:32:25 | crimes | 2 | 82551 | 165 | 2.233 | 36968.7 |
| 628 | 2025-04-20 18:45:49 | crimes | 2 | 82551 | 165 | 2.813 | 29346.2 |
| 627 | 2025-04-20 03:54:31 | crimes | 1 | 48755 | 12 | 1.966 | 24799.1 |
| 626 | 2025-04-18 23:18:30 | crimes | 2 | 82551 | 165 | 12.766 | 6466.5 |
| 625 | 2025-04-14 23:30:51 | crimes | 1 | 48755 | 12 | 2.623 | 18587.5 |
| 624 | 2025-04-11 01:13:51 | crimes | 2 | 82551 | 165 | 13.016 | 6342.3 |
| 623 | 2025-04-09 20:33:22 | crimes | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 622 | 2025-04-04 04:44:28 | crimes | 2 | 82551 | 165 | 12.923 | 6387.9 |
| 621 | 2025-04-02 21:03:33 | crimes | 2 | 82551 | 165 | 12.856 | 6421.2 |
| 620 | 2025-03-31 15:19:53 | crimes | 1 | 48755 | 12 | 4.406 | 11065.6 |
| 619 | 2025-03-31 15:11:39 | crimes | 1 | 48755 | 12 | 4.076 | 11961.5 |
| 618 | 2025-03-31 00:08:54 | crimes | 2 | 82551 | 165 | 9.830 | 8397.9 |
| 617 | 2025-03-30 18:17:56 | crimes | 2 | 82551 | 165 | 2.796 | 29524.7 |
| 616 | 2025-03-29 07:49:52 | crimes | 1 | 48755 | 12 | 5.983 | 8148.9 |
| 615 | 2025-03-29 03:17:02 | crimes | 1 | 48755 | 12 | 4.326 | 11270.2 |
| 614 | 2025-03-26 22:12:14 | crimes | 1 | 48755 | 12 | 4.686 | 10404.4 |
| 613 | 2025-03-20 05:39:13 | crimes | 1 | 48755 | 12 | 1.813 | 26891.9 |
| 612 | 2025-03-15 08:59:19 | crimes | 1 | 48755 | 12 | 2.436 | 20014.4 |