History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"agency"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
722 | 2024-05-04 01:29:59 | agency | 1 | 48755 | 1 | 0.936 | 52088.7 |
721 | 2024-04-29 23:52:49 | agency | 2 | 82551 | 19 | 4.810 | 17162.4 |
720 | 2024-04-29 23:52:14 | agency | 3 | 112716 | 207 | 5.373 | 20978.2 |
719 | 2024-04-29 17:51:25 | agency | 2 | 82551 | 19 | 5.220 | 15814.4 |
718 | 2024-04-29 17:51:10 | agency | 3 | 112716 | 207 | 8.000 | 14089.5 |
717 | 2024-04-29 13:41:52 | agency | 2 | 82551 | 19 | 6.046 | 13653.8 |
716 | 2024-04-29 13:41:43 | agency | 2 | 82551 | 19 | 6.500 | 12700.2 |
715 | 2024-04-29 13:41:44 | agency | 1 | 48755 | 1 | 3.000 | 16251.7 |
714 | 2024-04-29 13:41:30 | agency | 3 | 112716 | 207 | 8.516 | 13235.8 |
713 | 2024-04-28 06:46:39 | agency | 3 | 112716 | 207 | 9.673 | 11652.6 |
712 | 2024-04-28 00:50:40 | agency | 3 | 112716 | 207 | 9.733 | 11580.8 |
711 | 2024-03-30 08:57:17 | agency | 1 | 48755 | 1 | 2.906 | 16777.4 |
710 | 2024-03-26 01:48:50 | agency | 3 | 112716 | 207 | 12.766 | 8829.4 |
709 | 2024-03-24 21:42:59 | agency | 3 | 112716 | 207 | 4.686 | 24053.8 |
708 | 2024-03-23 15:52:37 | agency | 3 | 112716 | 207 | 5.376 | 20966.5 |
707 | 2024-03-10 03:23:16 | agency | 3 | 112716 | 207 | 21.656 | 5204.8 |
706 | 2024-03-08 21:54:33 | agency | 2 | 82551 | 19 | 5.200 | 15875.2 |
705 | 2024-03-08 21:54:05 | agency | 3 | 112716 | 207 | 6.110 | 18447.8 |
704 | 2024-03-07 22:35:44 | agency | 2 | 82551 | 19 | 2.466 | 33475.7 |
703 | 2024-03-07 22:35:32 | agency | 3 | 112716 | 207 | 5.796 | 19447.2 |
702 | 2024-03-06 23:33:35 | agency | 3 | 112716 | 207 | 13.920 | 8097.4 |
701 | 2024-03-05 22:28:24 | agency | 3 | 112716 | 207 | 14.953 | 7538.0 |
700 | 2024-03-05 21:59:36 | agency | 3 | 112716 | 207 | 10.910 | 10331.4 |
699 | 2024-02-28 10:32:43 | agency | 1 | 48755 | 1 | 1.700 | 28679.4 |
698 | 2024-02-04 22:31:15 | agency | 3 | 112716 | 207 | 11.500 | 9801.4 |
697 | 2024-02-02 08:14:07 | agency | 1 | 48755 | 1 | 0.860 | 56691.9 |
696 | 2024-01-31 07:15:20 | agency | 2 | 82551 | 19 | 2.720 | 30349.6 |
695 | 2024-01-31 07:14:44 | agency | 3 | 112716 | 207 | 7.690 | 14657.5 |
694 | 2024-01-30 07:38:39 | agency | 2 | 82551 | 19 | 2.563 | 32208.7 |
693 | 2024-01-29 15:22:16 | agency | 3 | 112716 | 207 | 5.876 | 19182.4 |
692 | 2024-01-29 01:24:47 | agency | 2 | 82551 | 19 | 2.593 | 31836.1 |
691 | 2024-01-29 01:24:36 | agency | 3 | 112716 | 207 | 5.283 | 21335.6 |
690 | 2024-01-26 22:55:41 | agency | 3 | 112716 | 207 | 5.250 | 21469.7 |
689 | 2024-01-26 20:40:53 | agency | 3 | 112716 | 207 | 5.283 | 21335.6 |
688 | 2023-12-21 00:46:29 | agency | 3 | 112716 | 207 | 5.500 | 20493.8 |
687 | 2023-12-16 12:07:37 | agency | 1 | 48755 | 1 | 0.873 | 55847.7 |
686 | 2023-12-14 09:47:03 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
685 | 2023-12-12 23:37:11 | agency | 3 | 112716 | 207 | 5.670 | 19879.4 |
684 | 2023-11-27 12:46:21 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
683 | 2023-11-23 07:49:41 | agency | 1 | 48755 | 1 | 0.796 | 61250.0 |
682 | 2023-11-23 01:48:55 | agency | 2 | 82551 | 19 | 2.156 | 38289.0 |
681 | 2023-11-12 10:10:29 | agency | 1 | 48755 | 1 | 0.966 | 50471.0 |
680 | 2023-11-12 09:39:59 | agency | 2 | 82551 | 19 | 2.266 | 36430.3 |
679 | 2023-11-12 09:33:05 | agency | 3 | 112716 | 207 | 5.203 | 21663.7 |
678 | 2023-11-07 18:05:27 | agency | 2 | 82551 | 19 | 2.420 | 34112.0 |
677 | 2023-11-06 17:48:21 | agency | 3 | 112716 | 207 | 4.656 | 24208.8 |
676 | 2023-10-20 09:43:06 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
675 | 2023-10-04 15:02:44 | agency | 3 | 112716 | 207 | 4.983 | 22620.1 |
674 | 2023-10-03 08:13:22 | agency | 3 | 112716 | 207 | 5.466 | 20621.3 |
673 | 2023-09-24 12:21:21 | agency | 1 | 48755 | 1 | 0.750 | 65006.7 |
672 | 2023-09-13 09:27:25 | agency | 1 | 48755 | 1 | 0.750 | 65006.7 |
671 | 2023-09-12 20:46:41 | agency | 1 | 48755 | 1 | 0.860 | 56691.9 |
670 | 2023-08-24 18:58:43 | agency | 1 | 48755 | 1 | 0.763 | 63899.1 |
669 | 2023-08-12 23:02:42 | agency | 2 | 82551 | 19 | 2.406 | 34310.5 |
668 | 2023-08-10 22:20:43 | agency | 3 | 112716 | 207 | 4.826 | 23356.0 |
667 | 2023-06-28 19:27:43 | agency | 1 | 48755 | 1 | 0.860 | 56691.9 |
666 | 2023-05-11 03:19:39 | agency | 1 | 48755 | 1 | 0.750 | 65006.7 |
665 | 2023-04-23 12:47:33 | agency | 2 | 82551 | 19 | 2.140 | 38575.2 |
664 | 2023-04-22 04:49:14 | agency | 3 | 112716 | 207 | 4.593 | 24540.8 |
663 | 2023-04-10 01:18:02 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
662 | 2023-03-17 21:32:27 | agency | 3 | 112716 | 207 | 4.826 | 23356.0 |
661 | 2023-03-14 00:24:11 | agency | 3 | 112716 | 207 | 4.673 | 24120.7 |
660 | 2023-03-10 16:40:21 | agency | 3 | 112716 | 207 | 4.920 | 22909.8 |
659 | 2023-02-01 18:26:35 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
658 | 2023-01-30 06:22:57 | agency | 2 | 82551 | 19 | 2.406 | 34310.5 |
657 | 2023-01-30 06:11:06 | agency | 2 | 82551 | 19 | 2.093 | 39441.5 |
656 | 2023-01-27 10:19:10 | agency | 3 | 112716 | 207 | 5.216 | 21609.7 |
655 | 2023-01-25 08:41:47 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
654 | 2023-01-22 21:54:55 | agency | 3 | 112716 | 207 | 4.643 | 24276.5 |
653 | 2023-01-03 08:43:54 | agency | 3 | 112716 | 207 | 5.610 | 20092.0 |
652 | 2022-12-08 18:29:58 | agency | 3 | 112716 | 207 | 4.643 | 24276.5 |
651 | 2022-11-30 01:16:39 | agency | 1 | 48755 | 1 | 0.750 | 65006.7 |
650 | 2022-11-19 11:58:12 | agency | 3 | 112716 | 207 | 5.003 | 22529.7 |
649 | 2022-11-12 19:33:02 | agency | 3 | 112716 | 207 | 5.483 | 20557.4 |
648 | 2022-11-12 03:04:56 | agency | 2 | 82551 | 19 | 2.423 | 34069.7 |
647 | 2022-11-09 16:28:21 | agency | 3 | 112716 | 207 | 5.236 | 21527.1 |
646 | 2022-10-25 00:44:15 | agency | 3 | 112716 | 207 | 4.970 | 22679.3 |
645 | 2022-10-22 14:18:13 | agency | 3 | 112716 | 207 | 4.686 | 24053.8 |
644 | 2022-10-07 09:11:48 | agency | 1 | 48755 | 1 | 0.750 | 65006.7 |
643 | 2022-10-03 20:21:52 | agency | 3 | 112716 | 207 | 5.360 | 21029.1 |
642 | 2022-09-27 15:14:14 | agency | 3 | 112716 | 207 | 5.206 | 21651.2 |
641 | 2022-09-09 03:04:48 | agency | 3 | 112716 | 207 | 5.720 | 19705.6 |
640 | 2022-07-26 12:55:55 | agency | 1 | 48755 | 1 | 0.800 | 60943.8 |
639 | 2022-07-25 06:15:16 | agency | 3 | 112716 | 207 | 4.720 | 23880.5 |
638 | 2022-07-22 12:42:09 | agency | 1 | 48755 | 1 | 0.750 | 65006.7 |
637 | 2022-06-20 15:47:01 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
636 | 2022-06-20 01:45:04 | agency | 3 | 112716 | 207 | 4.720 | 23880.5 |
635 | 2022-06-16 22:19:44 | agency | 1 | 48755 | 1 | 0.733 | 66514.3 |
634 | 2022-06-12 19:11:10 | agency | 3 | 112716 | 207 | 4.716 | 23900.8 |
633 | 2022-06-03 09:16:48 | agency | 1 | 48755 | 1 | 0.733 | 66514.3 |
632 | 2022-05-14 16:14:40 | agency | 2 | 82551 | 19 | 2.220 | 37185.1 |
631 | 2022-05-03 20:06:39 | agency | 1 | 48755 | 1 | 1.080 | 45143.5 |
630 | 2022-03-23 11:36:33 | agency | 1 | 48755 | 1 | 0.906 | 53813.5 |
629 | 2022-03-21 06:35:09 | agency | 1 | 48755 | 1 | 0.750 | 65006.7 |
628 | 2022-02-26 02:02:28 | agency | 1 | 48755 | 1 | 0.763 | 63899.1 |
627 | 2022-02-22 16:04:39 | agency | 1 | 48755 | 1 | 1.063 | 45865.5 |
626 | 2021-12-31 12:38:13 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |
625 | 2021-11-17 21:05:14 | agency | 1 | 48755 | 1 | 0.876 | 55656.4 |
624 | 2021-11-03 01:17:29 | agency | 1 | 48755 | 1 | 0.796 | 61250.0 |
623 | 2021-11-01 00:10:25 | agency | 1 | 48755 | 1 | 0.843 | 57835.1 |