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 |
| 1064 | 2025-10-26 20:35:11 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1063 | 2025-10-25 02:17:42 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1062 | 2025-10-21 06:41:20 | shot | 1 | 13983 | 27 | 0.953 | 14672.6 |
| 1061 | 2025-10-19 19:53:50 | shot | 1 | 13983 | 27 | 1.640 | 8526.2 |
| 1060 | 2025-10-09 07:45:08 | shot | 1 | 13983 | 27 | 0.263 | 53167.3 |
| 1059 | 2025-10-07 06:22:42 | shot | 1 | 13983 | 27 | 0.436 | 32071.1 |
| 1058 | 2025-10-06 09:37:16 | shot | 2 | 29872 | 268 | 0.780 | 38297.4 |
| 1057 | 2025-10-05 10:22:05 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1056 | 2025-10-03 18:42:03 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
| 1055 | 2025-09-28 16:02:14 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1054 | 2025-09-25 10:51:02 | shot | 1 | 13983 | 27 | 1.440 | 9710.4 |
| 1053 | 2025-09-25 10:50:37 | shot | 1 | 13983 | 27 | 1.343 | 10411.8 |
| 1052 | 2025-09-25 10:50:22 | shot | 1 | 13983 | 27 | 1.140 | 12265.8 |
| 1051 | 2025-09-25 10:49:56 | shot | 1 | 13983 | 27 | 1.390 | 10059.7 |
| 1050 | 2025-09-22 16:00:19 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1049 | 2025-09-17 09:06:18 | shot | 1 | 13983 | 27 | 0.216 | 64736.1 |
| 1048 | 2025-09-06 09:01:18 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
| 1047 | 2025-09-04 20:14:55 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
| 1046 | 2025-09-03 07:28:04 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1045 | 2025-09-02 04:20:50 | shot | 1 | 13983 | 27 | 0.233 | 60012.9 |
| 1044 | 2025-08-27 20:13:44 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
| 1043 | 2025-08-26 02:55:18 | shot | 1 | 13983 | 27 | 1.483 | 9428.9 |
| 1042 | 2025-08-21 04:46:39 | shot | 1 | 13983 | 27 | 0.690 | 20265.2 |
| 1041 | 2025-08-18 16:46:44 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
| 1040 | 2025-08-10 03:04:48 | shot | 1 | 13983 | 27 | 0.656 | 21315.5 |
| 1039 | 2025-08-05 05:32:09 | shot | 2 | 29872 | 268 | 1.983 | 15064.0 |
| 1038 | 2025-08-03 01:20:09 | shot | 2 | 29872 | 268 | 4.533 | 6589.9 |
| 1037 | 2025-07-31 16:46:23 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1036 | 2025-07-31 12:45:07 | shot | 1 | 13983 | 27 | 0.390 | 35853.8 |
| 1035 | 2025-07-27 18:19:47 | shot | 1 | 13983 | 27 | 0.500 | 27966.0 |
| 1034 | 2025-07-26 23:14:38 | shot | 1 | 13983 | 27 | 1.280 | 10924.2 |
| 1033 | 2025-07-24 23:56:27 | shot | 1 | 13983 | 27 | 0.500 | 27966.0 |
| 1032 | 2025-07-23 19:26:14 | shot | 1 | 13983 | 27 | 1.546 | 9044.6 |
| 1031 | 2025-07-22 20:54:03 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
| 1030 | 2025-07-16 04:48:27 | shot | 1 | 13983 | 27 | 1.266 | 11045.0 |
| 1029 | 2025-07-12 23:38:43 | shot | 1 | 13983 | 27 | 0.686 | 20383.4 |
| 1028 | 2025-07-10 03:15:51 | shot | 1 | 13983 | 27 | 0.686 | 20383.4 |
| 1027 | 2025-06-30 14:13:16 | shot | 1 | 13983 | 27 | 1.360 | 10281.6 |
| 1026 | 2025-06-29 12:30:59 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1025 | 2025-06-28 12:46:34 | shot | 1 | 13983 | 27 | 1.360 | 10281.6 |
| 1024 | 2025-06-26 08:22:21 | shot | 1 | 13983 | 27 | 0.940 | 14875.5 |
| 1023 | 2025-06-17 22:25:44 | shot | 1 | 13983 | 27 | 0.970 | 14415.5 |
| 1022 | 2025-06-17 16:49:31 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1021 | 2025-06-15 09:44:29 | shot | 1 | 13983 | 27 | 0.236 | 59250.0 |
| 1020 | 2025-06-10 01:55:42 | shot | 1 | 13983 | 27 | 1.390 | 10059.7 |
| 1019 | 2025-06-03 01:24:36 | shot | 1 | 13983 | 27 | 0.500 | 27966.0 |
| 1018 | 2025-05-31 14:40:12 | shot | 1 | 13983 | 27 | 0.983 | 14224.8 |
| 1017 | 2025-05-30 12:18:31 | shot | 1 | 13983 | 27 | 1.013 | 13803.6 |
| 1016 | 2025-05-30 11:45:28 | shot | 1 | 13983 | 27 | 0.686 | 20383.4 |
| 1015 | 2025-05-26 10:48:47 | shot | 2 | 29872 | 268 | 2.220 | 13455.9 |
| 1014 | 2025-05-25 09:38:43 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1013 | 2025-05-17 23:17:04 | shot | 1 | 13983 | 27 | 1.140 | 12265.8 |
| 1012 | 2025-05-16 05:32:11 | shot | 1 | 13983 | 27 | 0.673 | 20777.1 |
| 1011 | 2025-05-09 01:22:38 | shot | 1 | 13983 | 27 | 0.266 | 52567.7 |
| 1010 | 2025-05-08 23:57:21 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1009 | 2025-05-08 00:21:51 | shot | 1 | 13983 | 27 | 0.983 | 14224.8 |
| 1008 | 2025-05-06 06:10:05 | shot | 1 | 13983 | 27 | 0.296 | 47239.9 |
| 1007 | 2025-05-04 17:50:34 | shot | 1 | 13983 | 27 | 1.390 | 10059.7 |
| 1006 | 2025-05-02 16:54:05 | shot | 2 | 29872 | 268 | 4.953 | 6031.1 |
| 1005 | 2025-05-01 15:32:01 | shot | 1 | 13983 | 27 | 0.923 | 15149.5 |
| 1004 | 2025-04-30 03:01:14 | shot | 2 | 29872 | 268 | 1.813 | 16476.6 |
| 1003 | 2025-04-29 15:39:13 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 1002 | 2025-04-29 14:52:44 | shot | 1 | 13983 | 27 | 1.063 | 13154.3 |
| 1001 | 2025-04-29 12:30:53 | shot | 1 | 13983 | 27 | 0.690 | 20265.2 |
| 1000 | 2025-04-17 22:32:04 | shot | 1 | 13983 | 27 | 0.970 | 14415.5 |
| 999 | 2025-04-14 04:05:42 | shot | 1 | 13983 | 27 | 1.860 | 7517.7 |
| 998 | 2025-04-08 01:32:43 | shot | 1 | 13983 | 27 | 0.846 | 16528.4 |
| 997 | 2025-04-06 11:06:49 | shot | 1 | 13983 | 27 | 0.606 | 23074.3 |
| 996 | 2025-03-27 14:48:11 | shot | 1 | 13983 | 27 | 0.860 | 16259.3 |
| 995 | 2025-03-16 23:47:14 | shot | 1 | 13983 | 27 | 0.500 | 27966.0 |
| 994 | 2025-03-15 23:32:04 | shot | 1 | 13983 | 27 | 1.533 | 9121.3 |
| 993 | 2025-03-14 22:02:51 | shot | 1 | 13983 | 27 | 1.313 | 10649.7 |
| 992 | 2025-03-07 19:36:00 | shot | 2 | 29872 | 268 | 4.313 | 6926.0 |
| 991 | 2025-03-07 11:34:19 | shot | 2 | 29872 | 268 | 3.970 | 7524.4 |
| 990 | 2025-03-07 11:32:04 | shot | 1 | 13983 | 27 | 2.030 | 6888.2 |
| 989 | 2025-02-25 12:50:42 | shot | 2 | 29872 | 268 | 5.826 | 5127.4 |
| 988 | 2025-02-25 09:28:12 | shot | 2 | 29872 | 268 | 3.423 | 8726.8 |
| 987 | 2025-02-25 08:42:48 | shot | 1 | 13983 | 27 | 0.220 | 63559.1 |
| 986 | 2025-02-24 18:33:09 | shot | 1 | 13983 | 27 | 0.280 | 49939.3 |
| 985 | 2025-02-23 19:18:02 | shot | 1 | 13983 | 27 | 0.703 | 19890.5 |
| 984 | 2025-02-16 00:21:41 | shot | 2 | 29872 | 268 | 6.156 | 4852.5 |
| 983 | 2025-02-05 12:54:33 | shot | 2 | 29872 | 268 | 5.203 | 5741.3 |
| 982 | 2025-02-04 23:41:20 | shot | 2 | 29872 | 268 | 2.966 | 10071.5 |
| 981 | 2025-02-04 23:38:42 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 980 | 2025-01-26 07:19:13 | shot | 1 | 13983 | 27 | 1.436 | 9737.5 |
| 979 | 2025-01-25 14:31:27 | shot | 2 | 29872 | 268 | 4.203 | 7107.3 |
| 978 | 2025-01-25 13:24:37 | shot | 2 | 29872 | 268 | 4.563 | 6546.6 |
| 977 | 2025-01-25 11:52:35 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 976 | 2025-01-05 18:38:27 | shot | 1 | 13983 | 27 | 0.876 | 15962.3 |
| 975 | 2024-12-27 06:19:12 | shot | 1 | 13983 | 27 | 0.250 | 55932.0 |
| 974 | 2024-12-26 19:09:44 | shot | 2 | 29872 | 268 | 3.766 | 7932.0 |
| 973 | 2024-12-26 14:17:18 | shot | 2 | 29872 | 268 | 4.156 | 7187.7 |
| 972 | 2024-12-26 07:47:17 | shot | 2 | 29872 | 268 | 4.343 | 6878.2 |
| 971 | 2024-12-26 07:21:17 | shot | 1 | 13983 | 27 | 1.296 | 10789.4 |
| 970 | 2024-12-25 16:23:20 | shot | 1 | 13983 | 27 | 0.263 | 53167.3 |
| 969 | 2024-12-06 13:15:46 | shot | 2 | 29872 | 268 | 4.546 | 6571.1 |
| 968 | 2024-12-06 12:38:28 | shot | 1 | 13983 | 27 | 1.173 | 11920.7 |
| 967 | 2024-11-27 01:40:03 | shot | 1 | 13983 | 27 | 0.296 | 47239.9 |
| 966 | 2024-11-26 14:56:15 | shot | 2 | 29872 | 268 | 4.360 | 6851.4 |
| 965 | 2024-11-26 12:52:51 | shot | 2 | 29872 | 268 | 8.390 | 3560.4 |