History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shothole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
221 | 2024-04-26 05:36:48 | shothole | 1 | 82945 | 2 | 5.250 | 15799.0 |
220 | 2024-04-20 13:34:59 | shothole | 2 | 121059 | 4 | 3.203 | 37795.5 |
219 | 2024-04-03 02:33:03 | shothole | 4 | 161609 | 456 | 42.673 | 3787.1 |
218 | 2024-04-01 18:38:30 | shothole | 4 | 161609 | 456 | 41.206 | 3922.0 |
217 | 2024-04-01 18:05:25 | shothole | 4 | 161609 | 456 | 48.316 | 3344.8 |
216 | 2024-04-01 13:30:20 | shothole | 4 | 161609 | 456 | 16.173 | 9992.5 |
215 | 2024-04-01 13:30:20 | shothole | 3 | 146162 | 38 | 11.123 | 13140.5 |
214 | 2024-04-01 13:29:48 | shothole | 4 | 161609 | 456 | 28.016 | 5768.5 |
213 | 2024-04-01 13:30:01 | shothole | 2 | 121059 | 4 | 9.046 | 13382.6 |
212 | 2024-04-01 13:29:49 | shothole | 3 | 146162 | 38 | 9.000 | 16240.2 |
211 | 2024-04-01 13:29:50 | shothole | 2 | 121059 | 4 | 4.393 | 27557.3 |
210 | 2024-04-01 13:29:42 | shothole | 1 | 82945 | 2 | 1.720 | 48223.8 |
209 | 2024-03-30 21:34:37 | shothole | 1 | 82945 | 2 | 4.970 | 16689.1 |
208 | 2024-03-27 07:18:21 | shothole | 1 | 82945 | 2 | 1.280 | 64800.8 |
207 | 2024-03-09 20:17:23 | shothole | 2 | 121059 | 4 | 9.923 | 12199.8 |
206 | 2024-03-07 23:35:24 | shothole | 2 | 121059 | 4 | 8.296 | 14592.5 |
205 | 2024-03-07 10:34:23 | shothole | 1 | 82945 | 2 | 4.890 | 16962.2 |
204 | 2024-03-05 20:05:23 | shothole | 2 | 121059 | 4 | 13.003 | 9310.1 |
203 | 2024-03-02 10:11:05 | shothole | 2 | 121059 | 4 | 12.503 | 9682.4 |
202 | 2024-03-02 10:10:41 | shothole | 3 | 146162 | 38 | 8.983 | 16271.0 |
201 | 2024-03-01 03:01:04 | shothole | 4 | 161609 | 456 | 29.003 | 5572.1 |
200 | 2024-02-29 23:56:21 | shothole | 2 | 121059 | 4 | 3.843 | 31501.2 |
199 | 2024-02-29 01:56:20 | shothole | 4 | 161609 | 456 | 13.813 | 11699.8 |
198 | 2024-02-28 09:58:09 | shothole | 4 | 161609 | 456 | 34.770 | 4647.9 |
197 | 2024-02-27 17:34:16 | shothole | 4 | 161609 | 456 | 26.393 | 6123.2 |
196 | 2024-02-27 17:34:17 | shothole | 2 | 121059 | 4 | 8.093 | 14958.5 |
195 | 2024-02-27 17:34:15 | shothole | 3 | 146162 | 38 | 8.033 | 18195.2 |
194 | 2024-02-27 17:34:13 | shothole | 1 | 82945 | 2 | 1.563 | 53067.8 |
193 | 2024-02-17 01:33:04 | shothole | 1 | 82945 | 2 | 1.640 | 50576.2 |
192 | 2024-01-13 03:19:34 | shothole | 1 | 82945 | 2 | 1.360 | 60989.0 |
191 | 2024-01-06 15:06:01 | shothole | 1 | 82945 | 2 | 1.313 | 63172.1 |
190 | 2023-12-15 07:10:39 | shothole | 2 | 121059 | 4 | 3.406 | 35542.9 |
189 | 2023-10-30 11:57:26 | shothole | 1 | 82945 | 2 | 1.500 | 55296.7 |
188 | 2023-10-15 23:39:19 | shothole | 1 | 82945 | 2 | 1.343 | 61761.0 |
187 | 2023-10-13 22:45:42 | shothole | 1 | 82945 | 2 | 1.360 | 60989.0 |
186 | 2023-09-15 13:48:24 | shothole | 2 | 121059 | 4 | 3.846 | 31476.6 |
185 | 2023-08-23 20:29:31 | shothole | 1 | 82945 | 2 | 1.326 | 62552.8 |
184 | 2023-06-11 03:13:23 | shothole | 2 | 121059 | 4 | 3.126 | 38726.5 |
183 | 2023-06-03 19:09:50 | shothole | 1 | 82945 | 2 | 1.250 | 66356.0 |
182 | 2023-05-28 16:47:21 | shothole | 1 | 82945 | 2 | 1.330 | 62364.7 |
181 | 2023-03-23 03:56:43 | shothole | 1 | 82945 | 2 | 1.280 | 64800.8 |
180 | 2023-03-12 00:28:45 | shothole | 2 | 121059 | 4 | 3.283 | 36874.5 |
179 | 2023-01-25 07:37:25 | shothole | 1 | 82945 | 2 | 1.436 | 57761.1 |
178 | 2023-01-21 19:14:04 | shothole | 1 | 82945 | 2 | 1.250 | 66356.0 |
177 | 2023-01-09 09:13:38 | shothole | 1 | 82945 | 2 | 1.250 | 66356.0 |
176 | 2022-12-16 21:32:27 | shothole | 2 | 121059 | 4 | 3.080 | 39304.9 |
175 | 2022-12-07 15:51:02 | shothole | 1 | 82945 | 2 | 1.483 | 55930.5 |
174 | 2022-11-08 22:52:54 | shothole | 1 | 82945 | 2 | 1.470 | 56425.2 |
173 | 2022-10-09 12:07:04 | shothole | 1 | 82945 | 2 | 1.420 | 58412.0 |
172 | 2022-09-08 14:07:38 | shothole | 1 | 82945 | 2 | 1.296 | 64000.8 |
171 | 2022-08-09 18:40:23 | shothole | 2 | 121059 | 4 | 3.206 | 37760.1 |
170 | 2022-07-15 20:10:37 | shothole | 1 | 82945 | 2 | 1.346 | 61623.3 |
169 | 2022-04-18 14:48:27 | shothole | 1 | 82945 | 2 | 1.686 | 49196.3 |
168 | 2021-12-17 16:47:04 | shothole | 1 | 82945 | 2 | 1.326 | 62552.8 |
167 | 2021-09-11 19:51:47 | shothole | 1 | 82945 | 2 | 1.456 | 56967.7 |
166 | 2021-08-25 01:48:02 | shothole | 1 | 82945 | 2 | 1.280 | 64800.8 |
165 | 2021-08-01 22:11:43 | shothole | 1 | 82945 | 2 | 1.313 | 63172.1 |
164 | 2021-06-25 02:36:19 | shothole | 1 | 82945 | 2 | 1.296 | 64000.8 |
163 | 2021-05-10 21:49:37 | shothole | 1 | 82945 | 2 | 2.093 | 39629.7 |
162 | 2021-03-19 06:02:23 | shothole | 1 | 82945 | 2 | 1.470 | 56425.2 |
161 | 2021-02-22 02:00:55 | shothole | 1 | 82945 | 2 | 1.326 | 62552.8 |
160 | 2021-01-18 15:11:01 | shothole | 1 | 82945 | 2 | 1.280 | 64800.8 |
159 | 2020-11-06 09:36:06 | shothole | 1 | 82945 | 2 | 1.296 | 64000.8 |
158 | 2020-10-16 17:40:19 | shothole | 1 | 82945 | 2 | 1.516 | 54713.1 |
157 | 2020-10-09 13:42:03 | shothole | 1 | 82945 | 2 | 1.313 | 63172.1 |
156 | 2020-06-17 05:57:48 | shothole | 1 | 82945 | 2 | 1.470 | 56425.2 |
155 | 2020-03-23 04:23:03 | shothole | 1 | 82945 | 2 | 1.623 | 51106.0 |
154 | 2020-03-03 20:40:17 | shothole | 1 | 82945 | 2 | 1.500 | 55296.7 |
153 | 2020-03-01 00:39:05 | shothole | 4 | 161609 | 456 | 27.943 | 5783.5 |
152 | 2020-02-29 23:17:07 | shothole | 1 | 82945 | 2 | 1.296 | 64000.8 |
151 | 2020-02-24 09:20:52 | shothole | 4 | 161609 | 456 | 28.000 | 5771.8 |
150 | 2020-02-23 18:55:19 | shothole | 1 | 82945 | 2 | 1.596 | 51970.6 |
149 | 2020-02-18 20:41:39 | shothole | 1 | 82945 | 2 | 3.343 | 24811.5 |
148 | 2020-02-18 03:18:53 | shothole | 1 | 82945 | 2 | 1.953 | 42470.6 |
147 | 2020-02-06 12:04:20 | shothole | 1 | 82945 | 2 | 1.623 | 51106.0 |
146 | 2020-02-03 14:17:50 | shothole | 1 | 82945 | 2 | 1.986 | 41764.9 |
145 | 2020-01-31 19:22:58 | shothole | 3 | 146162 | 38 | 6.436 | 22710.1 |
144 | 2020-01-31 11:16:24 | shothole | 3 | 146162 | 38 | 8.783 | 16641.5 |
143 | 2020-01-27 14:51:13 | shothole | 1 | 82945 | 2 | 1.610 | 51518.6 |
142 | 2020-01-24 19:37:19 | shothole | 1 | 82945 | 2 | 1.486 | 55817.6 |
141 | 2020-01-22 07:22:33 | shothole | 1 | 82945 | 2 | 1.546 | 53651.4 |
140 | 2020-01-21 20:59:13 | shothole | 4 | 161609 | 456 | 29.080 | 5557.4 |
139 | 2020-01-21 20:56:31 | shothole | 4 | 161609 | 456 | 16.876 | 9576.3 |
138 | 2020-01-21 16:27:04 | shothole | 4 | 161609 | 456 | 32.206 | 5018.0 |
137 | 2020-01-19 18:42:52 | shothole | 4 | 161609 | 456 | 38.050 | 4247.3 |
136 | 2020-01-19 12:53:16 | shothole | 4 | 161609 | 456 | 30.736 | 5258.0 |
135 | 2020-01-19 07:04:03 | shothole | 4 | 161609 | 456 | 17.110 | 9445.3 |
134 | 2020-01-19 07:03:40 | shothole | 3 | 146162 | 38 | 15.846 | 9223.9 |
133 | 2020-01-19 07:03:19 | shothole | 2 | 121059 | 4 | 8.250 | 14673.8 |
132 | 2020-01-19 02:09:53 | shothole | 1 | 82945 | 2 | 1.436 | 57761.1 |
131 | 2020-01-14 07:54:45 | shothole | 1 | 82945 | 2 | 3.780 | 21943.1 |
130 | 2020-01-03 01:20:04 | shothole | 1 | 82945 | 2 | 1.750 | 47397.1 |
129 | 2020-01-01 12:36:45 | shothole | 1 | 82945 | 2 | 1.313 | 63172.1 |
128 | 2019-11-27 23:30:40 | shothole | 1 | 82945 | 2 | 1.283 | 64649.3 |
127 | 2019-08-26 07:56:06 | shothole | 1 | 82945 | 2 | 1.370 | 60543.8 |
126 | 2019-05-20 09:43:11 | shothole | 1 | 82945 | 2 | 1.476 | 56195.8 |
125 | 2019-02-11 06:18:10 | shothole | 1 | 82945 | 2 | 1.333 | 62224.3 |
124 | 2019-01-31 19:22:16 | shothole | 1 | 82945 | 2 | 2.106 | 39385.1 |
123 | 2019-01-26 05:02:59 | shothole | 1 | 82945 | 2 | 1.533 | 54106.3 |
122 | 2019-01-23 00:13:43 | shothole | 1 | 82945 | 2 | 1.356 | 61168.9 |