History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smithers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
278 | 2024-04-12 22:03:12 | smithers | 1 | 82945 | 7 | 1.610 | 51518.6 |
277 | 2024-03-05 06:41:07 | smithers | 1 | 82945 | 7 | 3.266 | 25396.5 |
276 | 2024-02-21 08:28:07 | smithers | 1 | 82945 | 7 | 3.300 | 25134.8 |
275 | 2024-01-30 10:30:14 | smithers | 1 | 82945 | 7 | 1.593 | 52068.4 |
274 | 2024-01-17 06:07:55 | smithers | 1 | 82945 | 7 | 1.313 | 63172.1 |
273 | 2024-01-14 11:18:41 | smithers | 3 | 146162 | 380 | 7.016 | 20832.7 |
272 | 2024-01-14 11:18:42 | smithers | 2 | 121059 | 49 | 3.813 | 31749.0 |
271 | 2024-01-13 14:39:38 | smithers | 1 | 82945 | 7 | 1.310 | 63316.8 |
270 | 2023-12-02 15:18:39 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
269 | 2023-12-02 04:13:18 | smithers | 1 | 82945 | 7 | 1.266 | 65517.4 |
268 | 2023-11-17 07:01:54 | smithers | 1 | 82945 | 7 | 2.953 | 28088.4 |
267 | 2023-11-13 08:35:56 | smithers | 1 | 82945 | 7 | 2.966 | 27965.3 |
266 | 2023-11-05 19:30:21 | smithers | 1 | 82945 | 7 | 1.483 | 55930.5 |
265 | 2023-10-20 04:54:42 | smithers | 1 | 82945 | 7 | 1.640 | 50576.2 |
264 | 2023-09-26 19:58:21 | smithers | 1 | 82945 | 7 | 1.486 | 55817.6 |
263 | 2023-09-13 20:51:21 | smithers | 1 | 82945 | 7 | 1.280 | 64800.8 |
262 | 2023-09-01 15:37:15 | smithers | 1 | 82945 | 7 | 1.266 | 65517.4 |
261 | 2023-06-06 18:40:13 | smithers | 1 | 82945 | 7 | 1.250 | 66356.0 |
260 | 2023-05-14 09:09:04 | smithers | 1 | 82945 | 7 | 1.453 | 57085.3 |
259 | 2023-03-28 18:26:20 | smithers | 1 | 82945 | 7 | 2.640 | 31418.6 |
258 | 2023-01-17 10:32:23 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
257 | 2023-01-12 01:53:03 | smithers | 1 | 82945 | 7 | 1.423 | 58288.8 |
256 | 2022-10-24 23:49:45 | smithers | 1 | 82945 | 7 | 1.280 | 64800.8 |
255 | 2022-09-18 22:43:48 | smithers | 1 | 82945 | 7 | 1.250 | 66356.0 |
254 | 2022-08-28 21:23:39 | smithers | 1 | 82945 | 7 | 1.406 | 58993.6 |
253 | 2022-08-18 14:05:13 | smithers | 1 | 82945 | 7 | 1.280 | 64800.8 |
252 | 2022-07-26 07:40:07 | smithers | 1 | 82945 | 7 | 1.453 | 57085.3 |
251 | 2022-06-18 14:42:18 | smithers | 1 | 82945 | 7 | 1.266 | 65517.4 |
250 | 2022-06-15 01:57:19 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
249 | 2022-05-20 02:06:33 | smithers | 1 | 82945 | 7 | 1.313 | 63172.1 |
248 | 2022-02-20 11:47:30 | smithers | 1 | 82945 | 7 | 2.860 | 29001.7 |
247 | 2022-02-18 06:49:03 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
246 | 2022-01-28 20:31:56 | smithers | 1 | 82945 | 7 | 1.406 | 58993.6 |
245 | 2021-12-07 13:16:56 | smithers | 1 | 82945 | 7 | 1.610 | 51518.6 |
244 | 2021-10-12 02:53:02 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
243 | 2021-10-10 18:40:30 | smithers | 1 | 82945 | 7 | 1.420 | 58412.0 |
242 | 2021-09-19 15:05:31 | smithers | 1 | 82945 | 7 | 1.456 | 56967.7 |
241 | 2021-07-10 19:43:57 | smithers | 1 | 82945 | 7 | 1.483 | 55930.5 |
240 | 2021-05-01 14:29:48 | smithers | 1 | 82945 | 7 | 1.440 | 57600.7 |
239 | 2021-04-11 07:20:22 | smithers | 1 | 82945 | 7 | 1.453 | 57085.3 |
238 | 2021-03-04 14:20:01 | smithers | 1 | 82945 | 7 | 1.516 | 54713.1 |
237 | 2021-02-08 13:28:29 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
236 | 2021-01-14 09:04:00 | smithers | 1 | 82945 | 7 | 1.313 | 63172.1 |
235 | 2020-12-28 23:24:54 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
234 | 2020-12-14 14:37:00 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
233 | 2020-11-08 14:05:44 | smithers | 1 | 82945 | 7 | 1.343 | 61761.0 |
232 | 2020-11-04 12:18:31 | smithers | 1 | 82945 | 7 | 1.360 | 60989.0 |
231 | 2020-10-31 21:28:18 | smithers | 1 | 82945 | 7 | 1.453 | 57085.3 |
230 | 2020-10-28 13:07:05 | smithers | 1 | 82945 | 7 | 2.876 | 28840.4 |
229 | 2020-09-21 14:34:48 | smithers | 1 | 82945 | 7 | 1.250 | 66356.0 |
228 | 2020-08-19 10:06:34 | smithers | 1 | 82945 | 7 | 1.453 | 57085.3 |
227 | 2020-07-23 06:10:32 | smithers | 1 | 82945 | 7 | 1.343 | 61761.0 |
226 | 2020-06-05 00:42:37 | smithers | 1 | 82945 | 7 | 1.733 | 47862.1 |
225 | 2020-05-21 04:19:48 | smithers | 1 | 82945 | 7 | 1.406 | 58993.6 |
224 | 2020-03-22 18:45:45 | smithers | 1 | 82945 | 7 | 3.203 | 25896.0 |
223 | 2020-03-04 11:48:12 | smithers | 1 | 82945 | 7 | 1.486 | 55817.6 |
222 | 2020-03-03 12:30:34 | smithers | 1 | 82945 | 7 | 1.300 | 63803.8 |
221 | 2020-03-02 19:33:23 | smithers | 1 | 82945 | 7 | 3.860 | 21488.3 |
220 | 2020-02-29 13:48:55 | smithers | 1 | 82945 | 7 | 3.096 | 26791.0 |
219 | 2020-02-21 12:41:38 | smithers | 1 | 82945 | 7 | 1.640 | 50576.2 |
218 | 2020-02-14 09:21:09 | smithers | 1 | 82945 | 7 | 3.186 | 26034.2 |
217 | 2020-02-12 05:39:59 | smithers | 1 | 82945 | 7 | 3.190 | 26001.6 |
216 | 2020-02-07 23:22:28 | smithers | 1 | 82945 | 7 | 1.530 | 54212.4 |
215 | 2020-02-07 19:21:09 | smithers | 1 | 82945 | 7 | 1.500 | 55296.7 |
214 | 2020-02-01 12:23:52 | smithers | 1 | 82945 | 7 | 2.156 | 38471.7 |
213 | 2020-01-30 00:11:58 | smithers | 1 | 82945 | 7 | 3.376 | 24569.0 |
212 | 2020-01-29 18:46:57 | smithers | 1 | 82945 | 7 | 1.530 | 54212.4 |
211 | 2020-01-25 19:01:45 | smithers | 1 | 82945 | 7 | 1.716 | 48336.2 |
210 | 2020-01-21 16:32:32 | smithers | 1 | 82945 | 7 | 3.220 | 25759.3 |
209 | 2020-01-20 01:19:48 | smithers | 1 | 82945 | 7 | 1.533 | 54106.3 |
208 | 2020-01-15 05:54:40 | smithers | 1 | 82945 | 7 | 3.266 | 25396.5 |
207 | 2020-01-10 18:05:18 | smithers | 1 | 82945 | 7 | 1.530 | 54212.4 |
206 | 2020-01-01 22:55:07 | smithers | 1 | 82945 | 7 | 1.606 | 51646.9 |
205 | 2019-12-30 03:53:02 | smithers | 1 | 82945 | 7 | 3.046 | 27230.8 |
204 | 2019-12-30 00:07:43 | smithers | 1 | 82945 | 7 | 1.563 | 53067.8 |
203 | 2019-11-30 13:09:31 | smithers | 1 | 82945 | 7 | 1.343 | 61761.0 |
202 | 2019-08-29 01:09:44 | smithers | 1 | 82945 | 7 | 1.343 | 61761.0 |
201 | 2019-07-23 00:02:24 | smithers | 1 | 82945 | 7 | 1.466 | 56579.1 |
200 | 2019-05-29 09:29:18 | smithers | 1 | 82945 | 7 | 1.536 | 54000.7 |
199 | 2019-03-14 06:31:53 | smithers | 1 | 82945 | 7 | 1.280 | 64800.8 |
198 | 2019-02-20 03:14:10 | smithers | 1 | 82945 | 7 | 1.270 | 65311.0 |
197 | 2019-01-01 20:02:04 | smithers | 1 | 82945 | 7 | 1.250 | 66356.0 |
196 | 2018-11-26 21:30:32 | smithers | 1 | 82945 | 7 | 1.320 | 62837.1 |
195 | 2018-11-09 10:30:47 | smithers | 1 | 82945 | 7 | 1.250 | 66356.0 |
194 | 2018-10-01 15:20:28 | smithers | 1 | 82945 | 7 | 1.350 | 61440.7 |
193 | 2018-08-25 17:55:12 | smithers | 1 | 82945 | 7 | 1.296 | 64000.8 |
192 | 2018-08-22 01:59:55 | smithers | 1 | 82945 | 7 | 1.283 | 64649.3 |
191 | 2018-08-15 05:03:40 | smithers | 1 | 82945 | 7 | 1.486 | 55817.6 |
190 | 2018-08-11 16:58:27 | smithers | 1 | 82945 | 7 | 1.643 | 50483.9 |
189 | 2018-08-02 08:11:11 | smithers | 1 | 82945 | 7 | 1.280 | 64800.8 |
188 | 2018-07-31 15:45:28 | smithers | 1 | 82945 | 7 | 1.266 | 65517.4 |
187 | 2018-07-28 18:15:04 | smithers | 1 | 82945 | 7 | 1.376 | 60279.8 |
186 | 2018-06-29 21:12:29 | smithers | 1 | 82945 | 7 | 1.236 | 67107.6 |
185 | 2018-06-28 11:22:47 | smithers | 1 | 82945 | 7 | 3.036 | 27320.5 |
184 | 2018-06-27 03:04:22 | smithers | 1 | 82945 | 7 | 1.526 | 54354.5 |
183 | 2018-06-23 10:01:36 | smithers | 1 | 82945 | 7 | 1.533 | 54106.3 |
182 | 2018-06-16 19:16:48 | smithers | 1 | 82945 | 7 | 1.470 | 56425.2 |
181 | 2018-06-14 09:09:56 | smithers | 1 | 82945 | 7 | 1.880 | 44119.7 |
180 | 2018-06-12 22:40:49 | smithers | 1 | 82945 | 7 | 1.443 | 57480.9 |
179 | 2018-06-02 09:45:29 | smithers | 1 | 82945 | 7 | 1.420 | 58412.0 |