History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shannies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
357 | 2024-04-18 08:15:48 | shannies | 3 | 146162 | 265 | 17.050 | 8572.6 |
356 | 2024-04-17 09:43:07 | shannies | 3 | 146162 | 265 | 11.220 | 13026.9 |
355 | 2024-03-31 09:47:42 | shannies | 3 | 146162 | 265 | 25.610 | 5707.2 |
354 | 2024-03-31 06:13:33 | shannies | 3 | 146162 | 265 | 23.393 | 6248.1 |
353 | 2024-03-31 06:13:35 | shannies | 2 | 121059 | 27 | 8.796 | 13763.0 |
352 | 2024-03-31 06:09:49 | shannies | 1 | 82945 | 4 | 4.860 | 17066.9 |
351 | 2024-03-01 03:08:13 | shannies | 1 | 82945 | 4 | 2.796 | 29665.6 |
350 | 2024-02-10 05:36:52 | shannies | 2 | 121059 | 27 | 13.330 | 9081.7 |
349 | 2024-01-31 15:42:49 | shannies | 1 | 82945 | 4 | 1.420 | 58412.0 |
348 | 2024-01-30 22:44:31 | shannies | 1 | 82945 | 4 | 1.580 | 52496.8 |
347 | 2023-12-20 05:13:19 | shannies | 2 | 121059 | 27 | 3.373 | 35890.6 |
346 | 2023-12-14 17:02:24 | shannies | 3 | 146162 | 265 | 7.453 | 19611.2 |
345 | 2023-12-05 01:17:52 | shannies | 1 | 82945 | 4 | 1.280 | 64800.8 |
344 | 2023-12-02 11:58:09 | shannies | 1 | 82945 | 4 | 1.500 | 55296.7 |
343 | 2023-11-30 07:30:08 | shannies | 1 | 82945 | 4 | 1.470 | 56425.2 |
342 | 2023-11-26 12:53:59 | shannies | 1 | 82945 | 4 | 1.296 | 64000.8 |
341 | 2023-11-11 03:36:02 | shannies | 1 | 82945 | 4 | 1.500 | 55296.7 |
340 | 2023-11-01 21:19:20 | shannies | 1 | 82945 | 4 | 1.470 | 56425.2 |
339 | 2023-10-17 02:51:40 | shannies | 1 | 82945 | 4 | 1.406 | 58993.6 |
338 | 2023-10-15 16:19:30 | shannies | 1 | 82945 | 4 | 1.313 | 63172.1 |
337 | 2023-10-06 17:16:05 | shannies | 3 | 146162 | 265 | 10.063 | 14524.7 |
336 | 2023-10-01 04:12:26 | shannies | 3 | 146162 | 265 | 8.046 | 18165.8 |
335 | 2023-09-29 01:55:24 | shannies | 3 | 146162 | 265 | 13.033 | 11214.8 |
334 | 2023-09-26 20:06:29 | shannies | 1 | 82945 | 4 | 1.453 | 57085.3 |
333 | 2023-09-21 15:38:12 | shannies | 2 | 121059 | 27 | 3.436 | 35232.5 |
332 | 2023-09-14 12:47:42 | shannies | 1 | 82945 | 4 | 1.483 | 55930.5 |
331 | 2023-09-14 09:54:56 | shannies | 3 | 146162 | 265 | 6.530 | 22383.2 |
330 | 2023-09-12 14:40:36 | shannies | 1 | 82945 | 4 | 1.313 | 63172.1 |
329 | 2023-06-30 08:32:49 | shannies | 2 | 121059 | 27 | 3.733 | 32429.4 |
328 | 2023-06-25 01:52:48 | shannies | 1 | 82945 | 4 | 1.406 | 58993.6 |
327 | 2023-06-17 08:20:56 | shannies | 1 | 82945 | 4 | 1.280 | 64800.8 |
326 | 2023-06-12 18:37:53 | shannies | 3 | 146162 | 265 | 6.546 | 22328.4 |
325 | 2023-04-22 01:33:00 | shannies | 1 | 82945 | 4 | 1.296 | 64000.8 |
324 | 2023-03-31 22:36:55 | shannies | 1 | 82945 | 4 | 1.266 | 65517.4 |
323 | 2023-03-27 23:56:44 | shannies | 1 | 82945 | 4 | 1.300 | 63803.8 |
322 | 2023-03-22 00:16:47 | shannies | 1 | 82945 | 4 | 1.300 | 63803.8 |
321 | 2023-03-18 22:24:28 | shannies | 2 | 121059 | 27 | 3.190 | 37949.5 |
320 | 2023-03-13 01:46:54 | shannies | 3 | 146162 | 265 | 6.186 | 23627.9 |
319 | 2023-03-06 05:10:16 | shannies | 1 | 82945 | 4 | 2.563 | 32362.5 |
318 | 2023-03-03 01:11:37 | shannies | 1 | 82945 | 4 | 1.423 | 58288.8 |
317 | 2023-01-14 04:30:33 | shannies | 1 | 82945 | 4 | 1.266 | 65517.4 |
316 | 2022-12-21 04:39:17 | shannies | 2 | 121059 | 27 | 3.436 | 35232.5 |
315 | 2022-12-17 02:00:23 | shannies | 3 | 146162 | 265 | 7.000 | 20880.3 |
314 | 2022-11-10 09:23:59 | shannies | 1 | 82945 | 4 | 1.750 | 47397.1 |
313 | 2022-11-04 19:44:13 | shannies | 1 | 82945 | 4 | 1.300 | 63803.8 |
312 | 2022-08-13 13:50:27 | shannies | 2 | 121059 | 27 | 3.250 | 37248.9 |
311 | 2022-08-07 15:32:34 | shannies | 3 | 146162 | 265 | 6.406 | 22816.4 |
310 | 2022-07-21 05:22:44 | shannies | 1 | 82945 | 4 | 1.296 | 64000.8 |
309 | 2022-07-19 08:21:31 | shannies | 1 | 82945 | 4 | 1.376 | 60279.8 |
308 | 2022-06-24 02:47:07 | shannies | 1 | 82945 | 4 | 1.266 | 65517.4 |
307 | 2022-03-30 10:24:39 | shannies | 1 | 82945 | 4 | 1.873 | 44284.6 |
306 | 2022-03-26 22:56:44 | shannies | 1 | 82945 | 4 | 1.563 | 53067.8 |
305 | 2022-03-02 08:38:15 | shannies | 3 | 146162 | 265 | 7.983 | 18309.2 |
304 | 2022-02-27 03:23:30 | shannies | 1 | 82945 | 4 | 1.360 | 60989.0 |
303 | 2021-12-09 19:29:55 | shannies | 1 | 82945 | 4 | 1.610 | 51518.6 |
302 | 2021-12-09 13:25:34 | shannies | 1 | 82945 | 4 | 2.906 | 28542.7 |
301 | 2021-11-29 02:48:24 | shannies | 1 | 82945 | 4 | 1.296 | 64000.8 |
300 | 2021-11-24 03:52:20 | shannies | 3 | 146162 | 265 | 6.516 | 22431.2 |
299 | 2021-10-23 07:06:37 | shannies | 1 | 82945 | 4 | 1.470 | 56425.2 |
298 | 2021-10-14 19:43:45 | shannies | 1 | 82945 | 4 | 1.470 | 56425.2 |
297 | 2021-09-30 10:40:48 | shannies | 1 | 82945 | 4 | 1.343 | 61761.0 |
296 | 2021-09-26 04:28:43 | shannies | 3 | 146162 | 265 | 6.830 | 21400.0 |
295 | 2021-09-25 17:13:48 | shannies | 3 | 146162 | 265 | 7.310 | 19994.8 |
294 | 2021-09-20 07:40:55 | shannies | 3 | 146162 | 265 | 6.360 | 22981.4 |
293 | 2021-09-02 05:15:30 | shannies | 1 | 82945 | 4 | 1.296 | 64000.8 |
292 | 2021-08-29 21:56:19 | shannies | 1 | 82945 | 4 | 1.326 | 62552.8 |
291 | 2021-08-25 10:44:59 | shannies | 1 | 82945 | 4 | 1.423 | 58288.8 |
290 | 2021-08-23 22:59:07 | shannies | 1 | 82945 | 4 | 1.356 | 61168.9 |
289 | 2021-07-11 05:35:36 | shannies | 1 | 82945 | 4 | 1.313 | 63172.1 |
288 | 2021-07-09 16:08:03 | shannies | 1 | 82945 | 4 | 1.376 | 60279.8 |
287 | 2021-07-07 18:18:44 | shannies | 1 | 82945 | 4 | 1.593 | 52068.4 |
286 | 2021-05-29 06:01:20 | shannies | 1 | 82945 | 4 | 1.486 | 55817.6 |
285 | 2021-04-29 08:02:07 | shannies | 1 | 82945 | 4 | 1.440 | 57600.7 |
284 | 2021-04-24 11:25:29 | shannies | 1 | 82945 | 4 | 1.373 | 60411.5 |
283 | 2021-02-26 09:13:28 | shannies | 1 | 82945 | 4 | 1.300 | 63803.8 |
282 | 2021-02-02 00:36:44 | shannies | 3 | 146162 | 265 | 8.030 | 18202.0 |
281 | 2021-01-09 15:50:17 | shannies | 1 | 82945 | 4 | 1.296 | 64000.8 |
280 | 2020-11-26 11:12:26 | shannies | 1 | 82945 | 4 | 1.296 | 64000.8 |
279 | 2020-10-31 00:19:05 | shannies | 1 | 82945 | 4 | 1.343 | 61761.0 |
278 | 2020-10-26 23:25:21 | shannies | 1 | 82945 | 4 | 1.310 | 63316.8 |
277 | 2020-10-25 00:19:57 | shannies | 1 | 82945 | 4 | 1.360 | 60989.0 |
276 | 2020-10-20 11:39:23 | shannies | 1 | 82945 | 4 | 1.283 | 64649.3 |
275 | 2020-08-23 22:32:06 | shannies | 1 | 82945 | 4 | 1.326 | 62552.8 |
274 | 2020-08-07 15:28:23 | shannies | 1 | 82945 | 4 | 1.326 | 62552.8 |
273 | 2020-08-04 09:33:20 | shannies | 1 | 82945 | 4 | 1.330 | 62364.7 |
272 | 2020-05-22 14:25:53 | shannies | 1 | 82945 | 4 | 1.280 | 64800.8 |
271 | 2020-05-19 12:07:34 | shannies | 1 | 82945 | 4 | 1.280 | 64800.8 |
270 | 2020-03-29 20:01:02 | shannies | 1 | 82945 | 4 | 1.500 | 55296.7 |
269 | 2020-03-21 09:24:53 | shannies | 1 | 82945 | 4 | 1.703 | 48705.2 |
268 | 2020-03-14 07:30:53 | shannies | 1 | 82945 | 4 | 1.533 | 54106.3 |
267 | 2020-03-02 22:06:46 | shannies | 3 | 146162 | 265 | 16.483 | 8867.4 |
266 | 2020-03-01 06:21:31 | shannies | 1 | 82945 | 4 | 1.406 | 58993.6 |
265 | 2020-03-01 03:54:46 | shannies | 1 | 82945 | 4 | 1.593 | 52068.4 |
264 | 2020-02-28 02:46:56 | shannies | 3 | 146162 | 265 | 7.860 | 18595.7 |
263 | 2020-02-27 04:58:31 | shannies | 1 | 82945 | 4 | 3.423 | 24231.7 |
262 | 2020-02-25 01:45:22 | shannies | 1 | 82945 | 4 | 1.623 | 51106.0 |
261 | 2020-02-21 03:26:26 | shannies | 1 | 82945 | 4 | 1.703 | 48705.2 |
260 | 2020-02-14 11:06:15 | shannies | 2 | 121059 | 27 | 4.000 | 30264.8 |
259 | 2020-02-13 15:25:05 | shannies | 3 | 146162 | 265 | 9.016 | 16211.4 |
258 | 2020-02-12 03:05:58 | shannies | 2 | 121059 | 27 | 6.530 | 18538.9 |