History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prog"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
912 | 2024-04-27 16:53:29 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
911 | 2024-04-20 18:37:55 | prog | 1 | 13983 | 16 | 0.826 | 16928.6 |
910 | 2024-04-19 17:25:53 | prog | 1 | 13983 | 16 | 0.263 | 53167.3 |
909 | 2024-04-19 17:25:29 | prog | 1 | 13983 | 16 | 0.466 | 30006.4 |
908 | 2024-04-13 05:57:43 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
907 | 2024-04-08 11:56:23 | prog | 1 | 13983 | 16 | 0.483 | 28950.3 |
906 | 2024-04-08 10:31:52 | prog | 1 | 13983 | 16 | 0.846 | 16528.4 |
905 | 2024-04-08 08:37:12 | prog | 1 | 13983 | 16 | 0.533 | 26234.5 |
904 | 2024-04-01 15:39:49 | prog | 1 | 13983 | 16 | 0.530 | 26383.0 |
903 | 2024-03-30 22:26:42 | prog | 2 | 29872 | 182 | 1.033 | 28917.7 |
902 | 2024-03-30 19:27:07 | prog | 2 | 29872 | 182 | 2.203 | 13559.7 |
901 | 2024-03-30 19:16:44 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
900 | 2024-03-28 19:16:00 | prog | 2 | 29872 | 182 | 2.046 | 14600.2 |
899 | 2024-03-28 17:48:11 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
898 | 2024-03-10 09:05:48 | prog | 1 | 13983 | 16 | 0.266 | 52567.7 |
897 | 2024-03-02 14:27:30 | prog | 2 | 29872 | 182 | 1.920 | 15558.3 |
896 | 2024-03-02 13:49:44 | prog | 1 | 13983 | 16 | 0.266 | 52567.7 |
895 | 2024-02-27 14:30:28 | prog | 2 | 29872 | 182 | 0.890 | 33564.0 |
894 | 2024-02-26 22:44:12 | prog | 2 | 29872 | 182 | 0.910 | 32826.4 |
893 | 2024-02-26 19:36:22 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
892 | 2024-02-26 13:35:48 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
891 | 2024-02-24 07:45:05 | prog | 2 | 29872 | 182 | 0.830 | 35990.4 |
890 | 2024-01-31 05:20:43 | prog | 1 | 13983 | 16 | 0.263 | 53167.3 |
889 | 2024-01-27 19:00:57 | prog | 1 | 13983 | 16 | 0.216 | 64736.1 |
888 | 2024-01-26 14:33:41 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
887 | 2024-01-14 14:02:22 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
886 | 2024-01-06 19:15:27 | prog | 1 | 13983 | 16 | 0.216 | 64736.1 |
885 | 2023-12-30 03:53:14 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
884 | 2023-12-12 18:24:32 | prog | 2 | 29872 | 182 | 0.733 | 40753.1 |
883 | 2023-12-12 01:26:51 | prog | 2 | 29872 | 182 | 0.813 | 36742.9 |
882 | 2023-11-25 05:47:37 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
881 | 2023-11-21 11:10:31 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
880 | 2023-11-18 14:47:57 | prog | 2 | 29872 | 182 | 0.860 | 34734.9 |
879 | 2023-11-18 04:50:22 | prog | 1 | 13983 | 16 | 0.313 | 44674.1 |
878 | 2023-11-14 14:28:01 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
877 | 2023-11-11 08:14:56 | prog | 2 | 29872 | 182 | 1.843 | 16208.4 |
876 | 2023-11-11 06:25:27 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
875 | 2023-11-07 08:18:35 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
874 | 2023-11-03 08:43:14 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
873 | 2023-10-21 09:52:41 | prog | 1 | 13983 | 16 | 0.530 | 26383.0 |
872 | 2023-10-18 07:29:04 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
871 | 2023-10-11 17:32:53 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
870 | 2023-10-03 23:15:22 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
869 | 2023-09-28 22:53:54 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
868 | 2023-09-14 01:36:00 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
867 | 2023-09-06 22:08:18 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
866 | 2023-09-01 04:06:04 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
865 | 2023-08-28 20:10:46 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
864 | 2023-08-21 01:10:55 | prog | 2 | 29872 | 182 | 0.736 | 40587.0 |
863 | 2023-06-10 13:25:58 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
862 | 2023-04-29 19:13:53 | prog | 2 | 29872 | 182 | 0.783 | 38150.7 |
861 | 2023-04-28 22:37:47 | prog | 2 | 29872 | 182 | 0.780 | 38297.4 |
860 | 2023-04-27 00:10:40 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
859 | 2023-03-30 06:42:44 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
858 | 2023-03-27 20:23:46 | prog | 2 | 29872 | 182 | 0.716 | 41720.7 |
857 | 2023-03-20 05:21:11 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
856 | 2023-02-11 01:45:56 | prog | 2 | 29872 | 182 | 0.716 | 41720.7 |
855 | 2023-02-03 00:22:20 | prog | 2 | 29872 | 182 | 0.733 | 40753.1 |
854 | 2023-01-13 00:28:15 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
853 | 2023-01-07 05:23:19 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
852 | 2022-12-24 17:22:18 | prog | 2 | 29872 | 182 | 0.720 | 41488.9 |
851 | 2022-11-16 01:12:41 | prog | 2 | 29872 | 182 | 0.750 | 39829.3 |
850 | 2022-10-20 08:30:41 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
849 | 2022-09-11 23:33:28 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
848 | 2022-09-05 13:14:21 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
847 | 2022-08-26 00:45:59 | prog | 1 | 13983 | 16 | 0.216 | 64736.1 |
846 | 2022-08-06 17:30:15 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
845 | 2022-07-29 22:33:39 | prog | 1 | 13983 | 16 | 0.216 | 64736.1 |
844 | 2022-07-29 13:42:17 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
843 | 2022-07-03 05:43:48 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
842 | 2022-06-19 18:48:02 | prog | 2 | 29872 | 182 | 0.750 | 39829.3 |
841 | 2022-06-16 05:49:04 | prog | 1 | 13983 | 16 | 0.420 | 33292.9 |
840 | 2022-06-15 15:54:44 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
839 | 2022-06-10 08:12:29 | prog | 1 | 13983 | 16 | 0.280 | 49939.3 |
838 | 2022-06-08 21:42:04 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
837 | 2022-06-08 17:39:44 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
836 | 2022-05-26 06:39:33 | prog | 1 | 13983 | 16 | 0.203 | 68881.8 |
835 | 2022-05-13 21:52:52 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
834 | 2022-04-22 11:21:48 | prog | 1 | 13983 | 16 | 0.360 | 38841.7 |
833 | 2022-02-13 13:21:14 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
832 | 2022-01-26 02:04:04 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
831 | 2022-01-09 17:01:14 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
830 | 2022-01-08 23:31:30 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
829 | 2022-01-07 18:03:38 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
828 | 2022-01-06 18:39:32 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
827 | 2021-12-30 17:45:45 | prog | 1 | 13983 | 16 | 0.263 | 53167.3 |
826 | 2021-12-27 16:18:03 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
825 | 2021-12-25 19:54:44 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
824 | 2021-12-24 20:22:44 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
823 | 2021-12-11 16:00:14 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
822 | 2021-12-11 08:00:07 | prog | 1 | 13983 | 16 | 0.220 | 63559.1 |
821 | 2021-12-10 23:30:43 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
820 | 2021-12-10 13:25:04 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
819 | 2021-12-10 05:07:07 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |
818 | 2021-12-09 15:11:28 | prog | 1 | 13983 | 16 | 0.440 | 31779.5 |
817 | 2021-12-09 06:51:11 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
816 | 2021-12-09 00:02:10 | prog | 1 | 13983 | 16 | 0.233 | 60012.9 |
815 | 2021-12-08 13:42:12 | prog | 1 | 13983 | 16 | 0.236 | 59250.0 |
814 | 2021-12-08 03:58:14 | prog | 1 | 13983 | 16 | 0.466 | 30006.4 |
813 | 2021-12-05 04:06:25 | prog | 1 | 13983 | 16 | 0.250 | 55932.0 |