History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
925 | 2024-04-17 12:57:27 | shots | 1 | 28756 | 27 | 0.576 | 49923.6 |
924 | 2024-04-02 20:48:21 | shots | 1 | 28756 | 27 | 0.516 | 55728.7 |
923 | 2024-03-31 02:42:13 | shots | 1 | 28756 | 27 | 0.513 | 56054.6 |
922 | 2024-02-26 01:40:49 | shots | 2 | 53800 | 263 | 1.936 | 27789.3 |
921 | 2024-02-25 22:19:14 | shots | 2 | 53800 | 263 | 3.173 | 16955.6 |
920 | 2024-02-25 22:15:30 | shots | 1 | 28756 | 27 | 2.250 | 12780.4 |
919 | 2024-01-28 19:02:40 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
918 | 2024-01-26 20:20:45 | shots | 1 | 28756 | 27 | 0.513 | 56054.6 |
917 | 2024-01-26 20:20:29 | shots | 1 | 28756 | 27 | 0.533 | 53951.2 |
916 | 2024-01-13 00:57:02 | shots | 1 | 28756 | 27 | 0.436 | 65954.1 |
915 | 2023-12-29 00:55:39 | shots | 2 | 53800 | 263 | 1.346 | 39970.3 |
914 | 2023-12-21 20:25:05 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
913 | 2023-12-07 11:07:54 | shots | 1 | 28756 | 27 | 0.503 | 57169.0 |
912 | 2023-12-07 11:07:53 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
911 | 2023-12-05 08:02:56 | shots | 2 | 53800 | 263 | 1.626 | 33087.3 |
910 | 2023-12-04 08:07:33 | shots | 2 | 53800 | 263 | 1.843 | 29191.5 |
909 | 2023-11-26 01:10:50 | shots | 1 | 28756 | 27 | 0.440 | 65354.5 |
908 | 2023-11-19 10:54:44 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
907 | 2023-11-18 18:42:28 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
906 | 2023-11-10 16:44:21 | shots | 1 | 28756 | 27 | 0.486 | 59168.7 |
905 | 2023-11-05 13:08:29 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
904 | 2023-10-28 04:42:01 | shots | 2 | 53800 | 263 | 1.640 | 32804.9 |
903 | 2023-10-28 00:29:20 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
902 | 2023-10-19 20:40:25 | shots | 1 | 28756 | 27 | 0.483 | 59536.2 |
901 | 2023-10-19 08:46:02 | shots | 1 | 28756 | 27 | 0.516 | 55728.7 |
900 | 2023-10-11 11:47:50 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
899 | 2023-10-09 07:05:23 | shots | 2 | 53800 | 263 | 1.423 | 37807.4 |
898 | 2023-10-04 06:41:35 | shots | 2 | 53800 | 263 | 1.423 | 37807.4 |
897 | 2023-10-03 15:29:07 | shots | 1 | 28756 | 27 | 0.436 | 65954.1 |
896 | 2023-09-26 06:54:34 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
895 | 2023-09-22 07:25:39 | shots | 1 | 28756 | 27 | 0.483 | 59536.2 |
894 | 2023-08-28 00:26:40 | shots | 1 | 28756 | 27 | 0.436 | 65954.1 |
893 | 2023-08-22 11:03:13 | shots | 1 | 28756 | 27 | 0.440 | 65354.5 |
892 | 2023-07-15 08:53:55 | shots | 2 | 53800 | 263 | 1.610 | 33416.1 |
891 | 2023-05-28 16:11:42 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
890 | 2023-05-05 01:44:45 | shots | 1 | 28756 | 27 | 0.873 | 32939.3 |
889 | 2023-04-04 20:16:50 | shots | 2 | 53800 | 263 | 1.580 | 34050.6 |
888 | 2023-03-22 22:39:40 | shots | 1 | 28756 | 27 | 0.483 | 59536.2 |
887 | 2023-01-22 19:13:39 | shots | 1 | 28756 | 27 | 0.440 | 65354.5 |
886 | 2023-01-14 23:14:14 | shots | 2 | 53800 | 263 | 1.470 | 36598.6 |
885 | 2023-01-09 05:50:56 | shots | 1 | 28756 | 27 | 0.436 | 65954.1 |
884 | 2023-01-03 09:21:57 | shots | 2 | 53800 | 263 | 1.343 | 40059.6 |
883 | 2022-11-30 23:22:47 | shots | 2 | 53800 | 263 | 1.343 | 40059.6 |
882 | 2022-11-05 04:51:05 | shots | 2 | 53800 | 263 | 1.390 | 38705.0 |
881 | 2022-10-14 22:00:27 | shots | 2 | 53800 | 263 | 1.643 | 32745.0 |
880 | 2022-10-09 20:29:13 | shots | 1 | 28756 | 27 | 0.470 | 61183.0 |
879 | 2022-09-10 21:21:31 | shots | 2 | 53800 | 263 | 1.376 | 39098.8 |
878 | 2022-09-09 10:56:18 | shots | 2 | 53800 | 263 | 1.376 | 39098.8 |
877 | 2022-09-08 16:22:48 | shots | 2 | 53800 | 263 | 1.593 | 33772.8 |
876 | 2022-08-10 00:27:40 | shots | 2 | 53800 | 263 | 1.390 | 38705.0 |
875 | 2022-07-03 06:35:28 | shots | 1 | 28756 | 27 | 0.470 | 61183.0 |
874 | 2022-06-12 19:25:12 | shots | 1 | 28756 | 27 | 0.436 | 65954.1 |
873 | 2022-06-10 19:16:34 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
872 | 2022-06-09 19:00:06 | shots | 1 | 28756 | 27 | 0.513 | 56054.6 |
871 | 2022-06-08 20:01:03 | shots | 1 | 28756 | 27 | 0.483 | 59536.2 |
870 | 2022-05-26 20:31:51 | shots | 1 | 28756 | 27 | 0.470 | 61183.0 |
869 | 2022-05-18 10:44:55 | shots | 1 | 28756 | 27 | 0.456 | 63061.4 |
868 | 2022-04-28 20:59:53 | shots | 2 | 53800 | 263 | 1.360 | 39558.8 |
867 | 2022-03-30 00:16:30 | shots | 2 | 53800 | 263 | 1.813 | 29674.6 |
866 | 2022-03-05 23:37:28 | shots | 1 | 28756 | 27 | 0.456 | 63061.4 |
865 | 2022-02-12 10:17:47 | shots | 1 | 28756 | 27 | 0.486 | 59168.7 |
864 | 2022-02-10 06:06:10 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
863 | 2022-02-07 10:43:38 | shots | 1 | 28756 | 27 | 0.450 | 63902.2 |
862 | 2022-02-06 09:34:26 | shots | 1 | 28756 | 27 | 0.513 | 56054.6 |
861 | 2022-02-05 08:17:55 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
860 | 2022-02-04 08:22:16 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
859 | 2022-02-03 02:49:53 | shots | 1 | 28756 | 27 | 0.563 | 51076.4 |
858 | 2022-02-02 08:15:36 | shots | 1 | 28756 | 27 | 0.483 | 59536.2 |
857 | 2022-02-01 06:10:17 | shots | 1 | 28756 | 27 | 0.470 | 61183.0 |
856 | 2022-01-31 04:03:28 | shots | 1 | 28756 | 27 | 0.466 | 61708.2 |
855 | 2022-01-30 09:49:07 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
854 | 2022-01-29 08:58:43 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
853 | 2022-01-28 19:34:14 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
852 | 2022-01-27 14:39:23 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
851 | 2022-01-26 18:11:45 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
850 | 2022-01-25 19:18:21 | shots | 1 | 28756 | 27 | 0.436 | 65954.1 |
849 | 2022-01-24 20:36:48 | shots | 1 | 28756 | 27 | 1.063 | 27051.7 |
848 | 2022-01-23 12:25:54 | shots | 1 | 28756 | 27 | 0.470 | 61183.0 |
847 | 2022-01-22 21:23:24 | shots | 1 | 28756 | 27 | 0.910 | 31600.0 |
846 | 2022-01-22 05:52:38 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
845 | 2022-01-21 17:07:20 | shots | 1 | 28756 | 27 | 1.046 | 27491.4 |
844 | 2022-01-21 06:53:31 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
843 | 2022-01-20 19:04:52 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
842 | 2022-01-20 07:56:09 | shots | 1 | 28756 | 27 | 0.516 | 55728.7 |
841 | 2022-01-19 23:20:49 | shots | 1 | 28756 | 27 | 0.450 | 63902.2 |
840 | 2022-01-19 11:43:50 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
839 | 2022-01-18 22:02:56 | shots | 1 | 28756 | 27 | 0.470 | 61183.0 |
838 | 2022-01-18 10:21:14 | shots | 1 | 28756 | 27 | 1.076 | 26724.9 |
837 | 2022-01-17 17:25:44 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
836 | 2022-01-13 06:32:23 | shots | 1 | 28756 | 27 | 1.003 | 28670.0 |
835 | 2022-01-12 11:16:31 | shots | 1 | 28756 | 27 | 0.453 | 63479.0 |
834 | 2022-01-11 23:21:54 | shots | 1 | 28756 | 27 | 0.576 | 49923.6 |
833 | 2022-01-11 06:25:16 | shots | 1 | 28756 | 27 | 0.466 | 61708.2 |
832 | 2022-01-10 15:58:01 | shots | 1 | 28756 | 27 | 0.513 | 56054.6 |
831 | 2022-01-09 21:44:48 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
830 | 2022-01-09 13:04:06 | shots | 1 | 28756 | 27 | 1.033 | 27837.4 |
829 | 2021-12-11 14:07:21 | shots | 1 | 28756 | 27 | 0.530 | 54256.6 |
828 | 2021-12-11 04:08:13 | shots | 1 | 28756 | 27 | 0.546 | 52666.7 |
827 | 2021-12-10 16:58:08 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |
826 | 2021-12-10 04:41:42 | shots | 1 | 28756 | 27 | 0.500 | 57512.0 |