History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"parole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
941 | 2024-03-03 23:29:59 | parole | 1 | 48755 | 8 | 3.923 | 12428.0 |
940 | 2024-02-26 03:55:33 | parole | 1 | 48755 | 8 | 5.016 | 9719.9 |
939 | 2024-01-30 12:03:31 | parole | 3 | 112716 | 1037 | 6.050 | 18630.7 |
938 | 2024-01-30 08:04:50 | parole | 2 | 82551 | 87 | 2.686 | 30733.8 |
937 | 2024-01-30 08:01:46 | parole | 3 | 112716 | 1037 | 6.000 | 18786.0 |
936 | 2024-01-29 18:29:59 | parole | 3 | 112716 | 1037 | 6.313 | 17854.6 |
935 | 2024-01-27 05:18:23 | parole | 1 | 48755 | 8 | 0.920 | 52994.6 |
934 | 2024-01-24 21:27:00 | parole | 3 | 112716 | 1037 | 5.436 | 20735.1 |
933 | 2024-01-21 04:51:46 | parole | 1 | 48755 | 8 | 0.750 | 65006.7 |
932 | 2024-01-19 06:21:59 | parole | 1 | 48755 | 8 | 0.780 | 62506.4 |
931 | 2024-01-14 13:19:06 | parole | 2 | 82551 | 87 | 2.343 | 35233.0 |
930 | 2024-01-09 07:08:20 | parole | 3 | 112716 | 1037 | 5.533 | 20371.6 |
929 | 2024-01-09 07:08:22 | parole | 2 | 82551 | 87 | 2.546 | 32423.8 |
928 | 2023-12-25 02:14:31 | parole | 1 | 48755 | 8 | 1.783 | 27344.4 |
927 | 2023-12-16 18:54:19 | parole | 1 | 48755 | 8 | 0.890 | 54780.9 |
926 | 2023-12-15 00:24:11 | parole | 3 | 112716 | 1037 | 5.143 | 21916.4 |
925 | 2023-12-07 10:40:32 | parole | 3 | 112716 | 1037 | 5.233 | 21539.5 |
924 | 2023-12-07 10:40:31 | parole | 2 | 82551 | 87 | 2.453 | 33653.1 |
923 | 2023-12-01 00:51:29 | parole | 3 | 112716 | 1037 | 5.533 | 20371.6 |
922 | 2023-12-01 00:51:31 | parole | 2 | 82551 | 87 | 2.653 | 31116.1 |
921 | 2023-11-16 05:40:15 | parole | 1 | 48755 | 8 | 0.920 | 52994.6 |
920 | 2023-11-15 03:10:23 | parole | 1 | 48755 | 8 | 0.766 | 63648.8 |
919 | 2023-11-10 15:18:15 | parole | 1 | 48755 | 8 | 0.763 | 63899.1 |
918 | 2023-11-04 01:15:29 | parole | 3 | 112716 | 1037 | 5.046 | 22337.7 |
917 | 2023-10-28 22:32:03 | parole | 1 | 48755 | 8 | 0.843 | 57835.1 |
916 | 2023-10-28 22:28:07 | parole | 2 | 82551 | 87 | 5.483 | 15055.8 |
915 | 2023-10-25 06:15:34 | parole | 2 | 82551 | 87 | 9.203 | 8970.0 |
914 | 2023-10-22 06:11:48 | parole | 1 | 48755 | 8 | 0.763 | 63899.1 |
913 | 2023-10-17 01:38:12 | parole | 1 | 48755 | 8 | 0.796 | 61250.0 |
912 | 2023-10-13 04:16:55 | parole | 1 | 48755 | 8 | 0.893 | 54596.9 |
911 | 2023-10-05 01:16:10 | parole | 1 | 48755 | 8 | 0.846 | 57630.0 |
910 | 2023-09-24 21:05:41 | parole | 1 | 48755 | 8 | 0.783 | 62266.9 |
909 | 2023-09-24 10:08:47 | parole | 1 | 48755 | 8 | 0.766 | 63648.8 |
908 | 2023-09-01 20:49:47 | parole | 1 | 48755 | 8 | 0.763 | 63899.1 |
907 | 2023-08-29 13:03:10 | parole | 1 | 48755 | 8 | 0.766 | 63648.8 |
906 | 2023-08-25 23:07:43 | parole | 1 | 48755 | 8 | 0.763 | 63899.1 |
905 | 2023-08-10 16:45:07 | parole | 3 | 112716 | 1037 | 5.826 | 19347.1 |
904 | 2023-08-05 07:46:42 | parole | 2 | 82551 | 87 | 2.236 | 36919.1 |
903 | 2023-06-06 07:17:35 | parole | 1 | 48755 | 8 | 0.733 | 66514.3 |
902 | 2023-05-12 07:20:53 | parole | 1 | 48755 | 8 | 0.673 | 72444.3 |
901 | 2023-04-20 21:40:20 | parole | 3 | 112716 | 1037 | 4.986 | 22606.5 |
900 | 2023-04-17 18:59:08 | parole | 2 | 82551 | 87 | 2.173 | 37989.4 |
899 | 2023-03-28 04:09:59 | parole | 1 | 48755 | 8 | 0.843 | 57835.1 |
898 | 2023-02-02 11:12:06 | parole | 1 | 48755 | 8 | 0.813 | 59969.2 |
897 | 2023-01-26 15:17:35 | parole | 3 | 112716 | 1037 | 4.750 | 23729.7 |
896 | 2023-01-22 13:03:05 | parole | 2 | 82551 | 87 | 2.500 | 33020.4 |
895 | 2023-01-11 12:40:07 | parole | 1 | 48755 | 8 | 0.763 | 63899.1 |
894 | 2022-11-25 16:27:37 | parole | 1 | 48755 | 8 | 0.860 | 56691.9 |
893 | 2022-11-08 02:12:02 | parole | 3 | 112716 | 1037 | 5.126 | 21989.1 |
892 | 2022-11-08 02:02:19 | parole | 3 | 112716 | 1037 | 4.860 | 23192.6 |
891 | 2022-11-02 07:56:35 | parole | 2 | 82551 | 87 | 2.440 | 33832.4 |
890 | 2022-10-22 05:24:45 | parole | 1 | 48755 | 8 | 0.843 | 57835.1 |
889 | 2022-10-19 14:46:14 | parole | 1 | 48755 | 8 | 0.766 | 63648.8 |
888 | 2022-09-03 19:07:00 | parole | 1 | 48755 | 8 | 0.826 | 59025.4 |
887 | 2022-08-23 13:35:10 | parole | 1 | 48755 | 8 | 0.780 | 62506.4 |
886 | 2022-08-10 16:54:59 | parole | 1 | 48755 | 8 | 0.766 | 63648.8 |
885 | 2022-08-03 00:42:47 | parole | 1 | 48755 | 8 | 0.780 | 62506.4 |
884 | 2022-07-29 10:13:12 | parole | 1 | 48755 | 8 | 0.783 | 62266.9 |
883 | 2022-07-03 08:45:13 | parole | 1 | 48755 | 8 | 0.766 | 63648.8 |
882 | 2022-06-12 15:06:03 | parole | 1 | 48755 | 8 | 0.843 | 57835.1 |
881 | 2022-06-10 04:30:36 | parole | 3 | 112716 | 1037 | 5.000 | 22543.2 |
880 | 2022-05-12 03:57:35 | parole | 2 | 82551 | 87 | 2.516 | 32810.4 |
879 | 2022-03-16 04:39:04 | parole | 1 | 48755 | 8 | 1.033 | 47197.5 |
878 | 2022-03-12 17:49:10 | parole | 1 | 48755 | 8 | 0.906 | 53813.5 |
877 | 2022-03-03 00:04:15 | parole | 1 | 48755 | 8 | 0.876 | 55656.4 |
876 | 2022-01-27 03:22:36 | parole | 3 | 112716 | 1037 | 7.643 | 14747.6 |
875 | 2022-01-07 09:14:04 | parole | 2 | 82551 | 87 | 2.280 | 36206.6 |
874 | 2021-12-15 15:49:23 | parole | 1 | 48755 | 8 | 0.830 | 58741.0 |
873 | 2021-11-29 01:29:55 | parole | 1 | 48755 | 8 | 0.830 | 58741.0 |
872 | 2021-11-05 23:29:36 | parole | 3 | 112716 | 1037 | 5.436 | 20735.1 |
871 | 2021-10-20 20:50:39 | parole | 1 | 48755 | 8 | 0.796 | 61250.0 |
870 | 2021-09-15 02:50:30 | parole | 1 | 48755 | 8 | 0.910 | 53576.9 |
869 | 2021-08-30 17:43:44 | parole | 1 | 48755 | 8 | 0.890 | 54780.9 |
868 | 2021-08-26 03:27:33 | parole | 1 | 48755 | 8 | 0.780 | 62506.4 |
867 | 2021-08-12 17:07:20 | parole | 1 | 48755 | 8 | 0.876 | 55656.4 |
866 | 2021-07-25 23:48:41 | parole | 1 | 48755 | 8 | 0.750 | 65006.7 |
865 | 2021-05-25 08:43:12 | parole | 1 | 48755 | 8 | 0.860 | 56691.9 |
864 | 2021-05-16 09:35:43 | parole | 1 | 48755 | 8 | 0.860 | 56691.9 |
863 | 2021-05-07 20:38:48 | parole | 3 | 112716 | 1037 | 4.953 | 22757.1 |
862 | 2021-02-25 12:04:35 | parole | 3 | 112716 | 1037 | 4.970 | 22679.3 |
861 | 2021-02-19 20:11:10 | parole | 1 | 48755 | 8 | 0.763 | 63899.1 |
860 | 2021-02-17 09:24:08 | parole | 1 | 48755 | 8 | 0.796 | 61250.0 |
859 | 2021-01-29 00:21:04 | parole | 1 | 48755 | 8 | 1.546 | 31536.2 |
858 | 2021-01-21 12:54:54 | parole | 3 | 112716 | 1037 | 5.670 | 19879.4 |
857 | 2020-12-31 09:38:48 | parole | 1 | 48755 | 8 | 0.923 | 52822.3 |
856 | 2020-12-04 07:05:19 | parole | 1 | 48755 | 8 | 0.876 | 55656.4 |
855 | 2020-11-20 21:56:29 | parole | 1 | 48755 | 8 | 0.780 | 62506.4 |
854 | 2020-11-01 12:43:54 | parole | 3 | 112716 | 1037 | 5.546 | 20323.8 |
853 | 2020-10-24 00:29:22 | parole | 1 | 48755 | 8 | 0.826 | 59025.4 |
852 | 2020-10-13 19:07:16 | parole | 1 | 48755 | 8 | 0.783 | 62266.9 |
851 | 2020-09-01 13:03:31 | parole | 1 | 48755 | 8 | 0.843 | 57835.1 |
850 | 2020-08-28 20:49:59 | parole | 1 | 48755 | 8 | 0.783 | 62266.9 |
849 | 2020-08-20 07:09:45 | parole | 1 | 48755 | 8 | 0.876 | 55656.4 |
848 | 2020-08-16 03:34:09 | parole | 1 | 48755 | 8 | 0.780 | 62506.4 |
847 | 2020-08-13 06:02:13 | parole | 1 | 48755 | 8 | 0.890 | 54780.9 |
846 | 2020-08-06 10:55:15 | parole | 1 | 48755 | 8 | 0.810 | 60191.4 |
845 | 2020-08-03 11:28:36 | parole | 1 | 48755 | 8 | 0.920 | 52994.6 |
844 | 2020-07-30 20:14:50 | parole | 1 | 48755 | 8 | 0.843 | 57835.1 |
843 | 2020-05-19 00:38:06 | parole | 1 | 48755 | 8 | 0.860 | 56691.9 |
842 | 2020-05-15 20:22:02 | parole | 1 | 48755 | 8 | 0.766 | 63648.8 |