History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aggie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
893 | 2024-04-21 06:17:00 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
892 | 2024-04-12 17:20:44 | aggie | 1 | 28756 | 3 | 0.533 | 53951.2 |
891 | 2024-04-05 23:26:08 | aggie | 1 | 28756 | 3 | 0.533 | 53951.2 |
890 | 2024-04-05 06:01:25 | aggie | 1 | 28756 | 3 | 0.576 | 49923.6 |
889 | 2024-04-02 18:47:14 | aggie | 2 | 53800 | 66 | 3.703 | 14528.8 |
888 | 2024-04-01 09:21:38 | aggie | 2 | 53800 | 66 | 2.686 | 20029.8 |
887 | 2024-04-01 09:21:35 | aggie | 1 | 28756 | 3 | 0.580 | 49579.3 |
886 | 2024-04-01 09:21:00 | aggie | 3 | 83667 | 833 | 8.703 | 9613.6 |
885 | 2024-03-31 18:20:50 | aggie | 2 | 53800 | 66 | 5.580 | 9641.6 |
884 | 2024-03-31 18:20:44 | aggie | 3 | 83667 | 833 | 9.360 | 8938.8 |
883 | 2024-03-31 18:20:40 | aggie | 1 | 28756 | 3 | 0.580 | 49579.3 |
882 | 2024-03-29 08:34:23 | aggie | 1 | 28756 | 3 | 0.563 | 51076.4 |
881 | 2024-03-16 00:20:07 | aggie | 1 | 28756 | 3 | 0.516 | 55728.7 |
880 | 2024-03-09 23:24:56 | aggie | 2 | 53800 | 66 | 1.796 | 29955.5 |
879 | 2024-03-04 18:21:44 | aggie | 1 | 28756 | 3 | 1.126 | 25538.2 |
878 | 2024-03-01 12:23:11 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
877 | 2024-02-28 14:28:56 | aggie | 2 | 53800 | 66 | 2.560 | 21015.6 |
876 | 2024-02-28 14:28:36 | aggie | 3 | 83667 | 833 | 4.766 | 17555.0 |
875 | 2024-02-28 02:49:40 | aggie | 1 | 28756 | 3 | 1.046 | 27491.4 |
874 | 2024-02-28 02:48:39 | aggie | 2 | 53800 | 66 | 1.703 | 31591.3 |
873 | 2024-02-27 08:58:33 | aggie | 2 | 53800 | 66 | 1.656 | 32487.9 |
872 | 2024-02-27 08:58:13 | aggie | 3 | 83667 | 833 | 3.610 | 23176.5 |
871 | 2024-02-24 06:14:50 | aggie | 3 | 83667 | 833 | 3.280 | 25508.2 |
870 | 2024-02-03 18:43:51 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
869 | 2024-01-29 03:30:08 | aggie | 1 | 28756 | 3 | 0.436 | 65954.1 |
868 | 2024-01-29 02:42:53 | aggie | 1 | 28756 | 3 | 1.046 | 27491.4 |
867 | 2024-01-12 14:33:16 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
866 | 2024-01-10 23:49:36 | aggie | 3 | 83667 | 833 | 3.876 | 21585.9 |
865 | 2024-01-10 23:49:37 | aggie | 2 | 53800 | 66 | 1.640 | 32804.9 |
864 | 2023-12-25 18:56:32 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
863 | 2023-12-12 14:22:03 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
862 | 2023-12-08 22:16:26 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
861 | 2023-11-26 09:30:40 | aggie | 2 | 53800 | 66 | 1.436 | 37465.2 |
860 | 2023-11-23 20:26:04 | aggie | 1 | 28756 | 3 | 0.533 | 53951.2 |
859 | 2023-11-21 19:39:56 | aggie | 3 | 83667 | 833 | 3.890 | 21508.2 |
858 | 2023-11-21 19:39:50 | aggie | 2 | 53800 | 66 | 1.453 | 37026.8 |
857 | 2023-11-20 03:45:01 | aggie | 3 | 83667 | 833 | 3.826 | 21868.0 |
856 | 2023-11-20 03:44:55 | aggie | 2 | 53800 | 66 | 1.406 | 38264.6 |
855 | 2023-11-16 21:48:25 | aggie | 1 | 28756 | 3 | 0.466 | 61708.2 |
854 | 2023-11-09 02:08:36 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
853 | 2023-11-03 15:08:55 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
852 | 2023-10-22 08:59:47 | aggie | 2 | 53800 | 66 | 1.373 | 39184.3 |
851 | 2023-10-22 08:57:01 | aggie | 3 | 83667 | 833 | 7.703 | 10861.6 |
850 | 2023-10-21 15:21:46 | aggie | 1 | 28756 | 3 | 0.513 | 56054.6 |
849 | 2023-10-17 00:35:54 | aggie | 1 | 28756 | 3 | 0.466 | 61708.2 |
848 | 2023-10-14 05:10:42 | aggie | 3 | 83667 | 833 | 3.733 | 22412.8 |
847 | 2023-10-13 16:24:34 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
846 | 2023-10-13 15:16:57 | aggie | 1 | 28756 | 3 | 0.486 | 59168.7 |
845 | 2023-10-05 06:09:22 | aggie | 1 | 28756 | 3 | 0.500 | 57512.0 |
844 | 2023-09-23 16:19:55 | aggie | 1 | 28756 | 3 | 0.456 | 63061.4 |
843 | 2023-09-23 03:40:35 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
842 | 2023-09-17 05:05:45 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
841 | 2023-09-02 06:50:09 | aggie | 1 | 28756 | 3 | 0.516 | 55728.7 |
840 | 2023-08-26 14:53:17 | aggie | 2 | 53800 | 66 | 1.563 | 34421.0 |
839 | 2023-08-21 01:53:50 | aggie | 3 | 83667 | 833 | 3.266 | 25617.6 |
838 | 2023-08-09 20:23:39 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
837 | 2023-07-19 05:22:03 | aggie | 3 | 83667 | 833 | 3.390 | 24680.5 |
836 | 2023-07-05 09:38:36 | aggie | 3 | 83667 | 833 | 3.300 | 25353.6 |
835 | 2023-05-29 19:44:02 | aggie | 1 | 28756 | 3 | 0.516 | 55728.7 |
834 | 2023-05-12 00:05:30 | aggie | 1 | 28756 | 3 | 0.890 | 32310.1 |
833 | 2023-05-10 17:30:10 | aggie | 2 | 53800 | 66 | 1.580 | 34050.6 |
832 | 2023-03-31 15:22:27 | aggie | 3 | 83667 | 833 | 3.216 | 26015.9 |
831 | 2023-03-26 20:08:10 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
830 | 2023-03-06 07:01:36 | aggie | 1 | 28756 | 3 | 0.436 | 65954.1 |
829 | 2023-02-27 06:44:20 | aggie | 1 | 28756 | 3 | 0.436 | 65954.1 |
828 | 2023-02-18 06:42:51 | aggie | 2 | 53800 | 66 | 1.360 | 39558.8 |
827 | 2022-12-28 16:10:57 | aggie | 1 | 28756 | 3 | 0.436 | 65954.1 |
826 | 2022-11-27 02:38:55 | aggie | 2 | 53800 | 66 | 1.360 | 39558.8 |
825 | 2022-11-21 06:29:06 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
824 | 2022-11-02 17:28:21 | aggie | 3 | 83667 | 833 | 3.923 | 21327.3 |
823 | 2022-10-30 03:30:23 | aggie | 3 | 83667 | 833 | 3.703 | 22594.4 |
822 | 2022-09-16 19:00:24 | aggie | 1 | 28756 | 3 | 0.563 | 51076.4 |
821 | 2022-09-16 15:13:33 | aggie | 1 | 28756 | 3 | 0.436 | 65954.1 |
820 | 2022-09-16 02:52:52 | aggie | 3 | 83667 | 833 | 3.716 | 22515.3 |
819 | 2022-09-15 06:34:32 | aggie | 3 | 83667 | 833 | 3.626 | 23074.2 |
818 | 2022-09-14 05:12:56 | aggie | 3 | 83667 | 833 | 3.890 | 21508.2 |
817 | 2022-09-13 16:52:59 | aggie | 3 | 83667 | 833 | 3.653 | 22903.6 |
816 | 2022-09-12 02:28:17 | aggie | 3 | 83667 | 833 | 4.420 | 18929.2 |
815 | 2022-09-11 03:25:10 | aggie | 3 | 83667 | 833 | 3.703 | 22594.4 |
814 | 2022-09-10 09:30:24 | aggie | 3 | 83667 | 833 | 5.753 | 14543.2 |
813 | 2022-09-09 02:59:55 | aggie | 3 | 83667 | 833 | 3.983 | 21006.0 |
812 | 2022-09-08 13:26:15 | aggie | 3 | 83667 | 833 | 3.813 | 21942.6 |
811 | 2022-09-07 03:07:57 | aggie | 3 | 83667 | 833 | 3.906 | 21420.1 |
810 | 2022-09-06 04:36:19 | aggie | 3 | 83667 | 833 | 4.330 | 19322.6 |
809 | 2022-09-05 03:13:03 | aggie | 3 | 83667 | 833 | 3.780 | 22134.1 |
808 | 2022-09-04 05:01:43 | aggie | 3 | 83667 | 833 | 3.686 | 22698.6 |
807 | 2022-09-03 02:32:24 | aggie | 3 | 83667 | 833 | 4.030 | 20761.0 |
806 | 2022-09-02 06:08:55 | aggie | 3 | 83667 | 833 | 3.750 | 22311.2 |
805 | 2022-09-01 01:59:34 | aggie | 3 | 83667 | 833 | 3.780 | 22134.1 |
804 | 2022-08-31 14:36:16 | aggie | 3 | 83667 | 833 | 3.810 | 21959.8 |
803 | 2022-08-30 11:33:17 | aggie | 3 | 83667 | 833 | 3.766 | 22216.4 |
802 | 2022-08-29 04:54:31 | aggie | 3 | 83667 | 833 | 3.643 | 22966.5 |
801 | 2022-08-28 16:06:28 | aggie | 3 | 83667 | 833 | 3.906 | 21420.1 |
800 | 2022-08-17 07:27:11 | aggie | 1 | 28756 | 3 | 0.483 | 59536.2 |
799 | 2022-07-05 02:09:23 | aggie | 2 | 53800 | 66 | 1.376 | 39098.8 |
798 | 2022-07-02 19:08:56 | aggie | 2 | 53800 | 66 | 1.403 | 38346.4 |
797 | 2022-06-03 09:28:07 | aggie | 3 | 83667 | 833 | 3.330 | 25125.2 |
796 | 2022-05-18 20:42:41 | aggie | 3 | 83667 | 833 | 3.406 | 24564.6 |
795 | 2022-05-17 18:24:18 | aggie | 3 | 83667 | 833 | 3.296 | 25384.4 |
794 | 2022-05-16 18:55:45 | aggie | 3 | 83667 | 833 | 7.750 | 10795.7 |