History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
890 | 2024-03-26 23:36:07 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
889 | 2024-03-02 17:02:44 | shot | 1 | 13983 | 27 | 0.203 | 68881.8 |
888 | 2024-03-02 14:42:48 | shot | 2 | 29872 | 268 | 2.060 | 14501.0 |
887 | 2024-03-02 13:36:10 | shot | 1 | 13983 | 27 | 0.546 | 25609.9 |
886 | 2024-02-25 20:51:33 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
885 | 2024-02-25 09:25:12 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
884 | 2024-01-26 17:56:53 | shot | 1 | 13983 | 27 | 0.263 | 53167.3 |
883 | 2024-01-21 00:59:01 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
882 | 2023-12-19 15:57:34 | shot | 2 | 29872 | 268 | 0.843 | 35435.3 |
881 | 2023-12-06 23:22:48 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
880 | 2023-11-28 10:14:26 | shot | 2 | 29872 | 268 | 0.843 | 35435.3 |
879 | 2023-11-21 16:54:15 | shot | 2 | 29872 | 268 | 0.766 | 38997.4 |
878 | 2023-11-12 01:31:52 | shot | 1 | 13983 | 27 | 0.203 | 68881.8 |
877 | 2023-11-09 06:55:08 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
876 | 2023-11-04 21:29:13 | shot | 2 | 29872 | 268 | 0.923 | 32364.0 |
875 | 2023-11-02 08:06:10 | shot | 1 | 13983 | 27 | 0.393 | 35580.2 |
874 | 2023-10-27 14:47:13 | shot | 1 | 13983 | 27 | 0.296 | 47239.9 |
873 | 2023-10-26 14:31:58 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
872 | 2023-10-21 04:15:49 | shot | 1 | 13983 | 27 | 0.236 | 59250.0 |
871 | 2023-10-17 19:50:28 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
870 | 2023-10-12 06:10:19 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
869 | 2023-10-03 16:56:21 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
868 | 2023-10-03 10:04:27 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
867 | 2023-09-27 04:01:06 | shot | 2 | 29872 | 268 | 1.173 | 25466.3 |
866 | 2023-09-25 16:24:25 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
865 | 2023-09-22 03:12:52 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
864 | 2023-09-19 17:25:44 | shot | 1 | 13983 | 27 | 0.280 | 49939.3 |
863 | 2023-09-12 10:29:49 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
862 | 2023-07-16 20:56:17 | shot | 1 | 13983 | 27 | 0.390 | 35853.8 |
861 | 2023-06-16 12:16:11 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
860 | 2023-04-19 15:54:21 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
859 | 2023-02-28 16:54:51 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
858 | 2023-02-06 22:46:58 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
857 | 2022-12-05 10:52:37 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
856 | 2022-11-08 08:39:03 | shot | 1 | 13983 | 27 | 0.236 | 59250.0 |
855 | 2022-11-04 20:30:15 | shot | 1 | 13983 | 27 | 0.236 | 59250.0 |
854 | 2022-09-12 12:49:44 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
853 | 2022-08-14 07:31:48 | shot | 1 | 13983 | 27 | 0.203 | 68881.8 |
852 | 2022-08-07 06:33:25 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
851 | 2022-08-05 23:58:01 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
850 | 2022-08-03 21:25:40 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
849 | 2022-07-29 03:01:59 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
848 | 2022-07-18 23:35:16 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
847 | 2022-07-17 22:54:37 | shot | 1 | 13983 | 27 | 0.203 | 68881.8 |
846 | 2022-03-24 23:36:01 | shot | 1 | 13983 | 27 | 0.563 | 24836.6 |
845 | 2022-03-24 17:42:07 | shot | 1 | 13983 | 27 | 0.310 | 45106.5 |
844 | 2021-12-24 07:13:32 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
843 | 2021-12-14 02:39:46 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
842 | 2021-10-25 01:29:34 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
841 | 2021-09-11 00:15:15 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
840 | 2021-09-06 20:01:38 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
839 | 2021-08-24 09:09:42 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
838 | 2021-06-24 12:43:53 | shot | 1 | 13983 | 27 | 0.263 | 53167.3 |
837 | 2021-06-05 19:54:37 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
836 | 2021-03-29 17:14:02 | shot | 2 | 29872 | 268 | 0.750 | 39829.3 |
835 | 2021-03-03 17:09:54 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
834 | 2021-02-25 18:50:30 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
833 | 2021-01-21 00:48:19 | shot | 1 | 13983 | 27 | 0.236 | 59250.0 |
832 | 2021-01-13 08:41:41 | shot | 2 | 29872 | 268 | 0.750 | 39829.3 |
831 | 2020-12-11 09:16:27 | shot | 2 | 29872 | 268 | 0.766 | 38997.4 |
830 | 2020-11-29 10:44:25 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
829 | 2020-11-28 05:28:47 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
828 | 2020-11-19 10:07:31 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
827 | 2020-11-01 20:15:27 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
826 | 2020-10-31 07:44:04 | shot | 2 | 29872 | 268 | 1.530 | 19524.2 |
825 | 2020-10-29 11:11:18 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
824 | 2020-10-25 18:29:56 | shot | 2 | 29872 | 268 | 0.750 | 39829.3 |
823 | 2020-10-19 16:08:41 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
822 | 2020-10-06 04:27:23 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
821 | 2020-09-15 07:30:38 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
820 | 2020-08-26 04:54:10 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
819 | 2020-08-24 01:26:32 | shot | 1 | 13983 | 27 | 0.236 | 59250.0 |
818 | 2020-08-22 00:45:46 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
817 | 2020-08-13 14:45:27 | shot | 2 | 29872 | 268 | 0.813 | 36742.9 |
816 | 2020-08-12 03:05:07 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
815 | 2020-08-04 23:42:03 | shot | 1 | 13983 | 27 | 0.206 | 67878.6 |
814 | 2020-07-31 07:48:35 | shot | 1 | 13983 | 27 | 0.203 | 68881.8 |
813 | 2020-07-30 02:52:20 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
812 | 2020-07-17 03:03:38 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
811 | 2020-06-18 07:40:13 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
810 | 2020-06-16 05:03:46 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
809 | 2020-06-12 02:52:47 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
808 | 2020-06-11 02:25:08 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
807 | 2020-06-10 11:57:29 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
806 | 2020-06-09 12:31:23 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
805 | 2020-06-08 12:41:51 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
804 | 2020-06-02 06:31:55 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
803 | 2020-06-01 07:08:43 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
802 | 2020-05-29 04:51:48 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
801 | 2020-05-28 04:36:56 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
800 | 2020-05-27 04:01:21 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
799 | 2020-05-26 07:24:27 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
798 | 2020-05-25 08:04:37 | shot | 1 | 13983 | 27 | 0.203 | 68881.8 |
797 | 2020-05-24 06:59:35 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
796 | 2020-05-23 07:35:05 | shot | 1 | 13983 | 27 | 0.236 | 59250.0 |
795 | 2020-05-20 17:18:09 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
794 | 2020-05-20 02:08:40 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
793 | 2020-05-19 01:24:09 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
792 | 2020-05-16 13:20:25 | shot | 1 | 13983 | 27 | 0.203 | 68881.8 |
791 | 2020-05-14 09:43:15 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |