History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doornail"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
401 | 2024-04-13 16:27:55 | doornail | 1 | 82945 | 2 | 1.453 | 57085.3 |
400 | 2024-04-10 22:26:17 | doornail | 4 | 161609 | 292 | 26.296 | 6145.8 |
399 | 2024-04-10 22:25:59 | doornail | 3 | 146162 | 27 | 17.313 | 8442.3 |
398 | 2024-04-10 22:25:58 | doornail | 2 | 121059 | 2 | 4.186 | 28920.0 |
397 | 2024-04-10 22:25:55 | doornail | 1 | 82945 | 2 | 1.563 | 53067.8 |
396 | 2024-04-09 22:09:57 | doornail | 4 | 161609 | 292 | 24.110 | 6703.0 |
395 | 2024-04-08 09:58:12 | doornail | 3 | 146162 | 27 | 23.126 | 6320.2 |
394 | 2024-04-08 09:58:14 | doornail | 2 | 121059 | 2 | 12.313 | 9831.8 |
393 | 2024-04-08 08:38:12 | doornail | 1 | 82945 | 2 | 3.406 | 24352.6 |
392 | 2024-04-06 16:07:06 | doornail | 1 | 82945 | 2 | 1.736 | 47779.4 |
391 | 2024-04-05 18:15:57 | doornail | 2 | 121059 | 2 | 4.016 | 30144.2 |
390 | 2024-04-05 18:15:56 | doornail | 1 | 82945 | 2 | 1.450 | 57203.4 |
389 | 2024-04-01 03:22:18 | doornail | 4 | 161609 | 292 | 19.453 | 8307.7 |
388 | 2024-04-01 03:18:31 | doornail | 3 | 146162 | 27 | 13.580 | 10763.0 |
387 | 2024-03-31 04:24:32 | doornail | 1 | 82945 | 2 | 2.046 | 40540.1 |
386 | 2024-03-31 04:18:09 | doornail | 2 | 121059 | 2 | 7.626 | 15874.5 |
385 | 2024-03-31 04:17:49 | doornail | 3 | 146162 | 27 | 8.326 | 17554.9 |
384 | 2024-03-30 06:17:59 | doornail | 4 | 161609 | 292 | 29.126 | 5548.6 |
383 | 2024-03-29 20:07:56 | doornail | 1 | 82945 | 2 | 1.610 | 51518.6 |
382 | 2024-03-29 18:40:17 | doornail | 2 | 121059 | 2 | 7.313 | 16553.9 |
381 | 2024-03-29 18:40:15 | doornail | 3 | 146162 | 27 | 7.656 | 19091.2 |
380 | 2024-03-29 04:17:21 | doornail | 4 | 161609 | 292 | 30.220 | 5347.7 |
379 | 2024-03-29 02:56:06 | doornail | 4 | 161609 | 292 | 13.500 | 11971.0 |
378 | 2024-03-11 08:33:12 | doornail | 2 | 121059 | 2 | 9.750 | 12416.3 |
377 | 2024-03-11 08:33:00 | doornail | 3 | 146162 | 27 | 9.250 | 15801.3 |
376 | 2024-03-11 08:32:13 | doornail | 1 | 82945 | 2 | 1.626 | 51011.7 |
375 | 2024-03-11 05:04:11 | doornail | 4 | 161609 | 292 | 17.363 | 9307.7 |
374 | 2024-03-10 21:22:18 | doornail | 4 | 161609 | 292 | 13.576 | 11904.0 |
373 | 2024-03-10 21:22:23 | doornail | 2 | 121059 | 2 | 3.953 | 30624.6 |
372 | 2024-03-10 21:22:02 | doornail | 3 | 146162 | 27 | 8.186 | 17855.1 |
371 | 2024-03-09 07:17:33 | doornail | 3 | 146162 | 27 | 26.126 | 5594.5 |
370 | 2024-03-09 07:17:37 | doornail | 2 | 121059 | 2 | 6.516 | 18578.7 |
369 | 2024-03-09 06:59:37 | doornail | 1 | 82945 | 2 | 1.483 | 55930.5 |
368 | 2024-03-01 16:01:16 | doornail | 3 | 146162 | 27 | 8.126 | 17987.0 |
367 | 2024-02-29 14:06:31 | doornail | 2 | 121059 | 2 | 5.500 | 22010.7 |
366 | 2024-02-29 14:06:23 | doornail | 1 | 82945 | 2 | 3.050 | 27195.1 |
365 | 2024-02-28 07:23:42 | doornail | 3 | 146162 | 27 | 18.330 | 7973.9 |
364 | 2024-02-27 08:36:25 | doornail | 4 | 161609 | 292 | 23.220 | 6959.9 |
363 | 2024-02-26 22:04:11 | doornail | 4 | 161609 | 292 | 18.000 | 8978.3 |
362 | 2024-02-26 22:04:10 | doornail | 3 | 146162 | 27 | 13.750 | 10630.0 |
361 | 2024-02-26 22:04:09 | doornail | 2 | 121059 | 2 | 3.936 | 30756.9 |
360 | 2024-02-26 22:04:08 | doornail | 1 | 82945 | 2 | 1.516 | 54713.1 |
359 | 2024-02-18 13:15:28 | doornail | 1 | 82945 | 2 | 1.280 | 64800.8 |
358 | 2024-02-09 18:23:47 | doornail | 1 | 82945 | 2 | 2.186 | 37943.7 |
357 | 2024-02-08 00:51:34 | doornail | 1 | 82945 | 2 | 3.110 | 26670.4 |
356 | 2024-02-05 13:59:42 | doornail | 4 | 161609 | 292 | 13.920 | 11609.8 |
355 | 2024-02-05 13:59:34 | doornail | 3 | 146162 | 27 | 8.830 | 16552.9 |
354 | 2024-02-05 13:59:30 | doornail | 2 | 121059 | 2 | 7.580 | 15970.8 |
353 | 2024-02-04 17:12:51 | doornail | 3 | 146162 | 27 | 7.766 | 18820.8 |
352 | 2024-02-03 04:55:00 | doornail | 2 | 121059 | 2 | 7.266 | 16661.0 |
351 | 2024-02-03 03:03:46 | doornail | 1 | 82945 | 2 | 1.423 | 58288.8 |
350 | 2024-02-03 03:02:09 | doornail | 3 | 146162 | 27 | 7.703 | 18974.7 |
349 | 2024-01-31 04:41:19 | doornail | 1 | 82945 | 2 | 1.513 | 54821.5 |
348 | 2024-01-30 20:08:44 | doornail | 1 | 82945 | 2 | 1.470 | 56425.2 |
347 | 2024-01-29 23:05:39 | doornail | 1 | 82945 | 2 | 1.436 | 57761.1 |
346 | 2024-01-29 07:24:31 | doornail | 2 | 121059 | 2 | 3.923 | 30858.8 |
345 | 2024-01-29 07:23:23 | doornail | 3 | 146162 | 27 | 7.236 | 20199.3 |
344 | 2024-01-28 18:53:51 | doornail | 1 | 82945 | 2 | 1.390 | 59672.7 |
343 | 2024-01-27 15:45:49 | doornail | 1 | 82945 | 2 | 1.486 | 55817.6 |
342 | 2024-01-27 15:44:45 | doornail | 4 | 161609 | 292 | 25.360 | 6372.6 |
341 | 2024-01-27 15:44:49 | doornail | 2 | 121059 | 2 | 4.080 | 29671.3 |
340 | 2024-01-27 15:44:41 | doornail | 3 | 146162 | 27 | 8.283 | 17646.0 |
339 | 2024-01-27 14:16:03 | doornail | 1 | 82945 | 2 | 1.390 | 59672.7 |
338 | 2024-01-27 14:10:59 | doornail | 4 | 161609 | 292 | 23.176 | 6973.1 |
337 | 2024-01-27 14:10:27 | doornail | 4 | 161609 | 292 | 12.936 | 12493.0 |
336 | 2024-01-27 14:10:23 | doornail | 3 | 146162 | 27 | 7.170 | 20385.2 |
335 | 2024-01-27 14:10:19 | doornail | 2 | 121059 | 2 | 3.500 | 34588.3 |
334 | 2024-01-27 12:06:46 | doornail | 1 | 82945 | 2 | 1.500 | 55296.7 |
333 | 2024-01-26 18:49:44 | doornail | 1 | 82945 | 2 | 3.063 | 27079.7 |
332 | 2024-01-14 22:22:58 | doornail | 1 | 82945 | 2 | 1.423 | 58288.8 |
331 | 2024-01-07 20:46:33 | doornail | 4 | 161609 | 292 | 10.563 | 15299.5 |
330 | 2024-01-07 19:05:24 | doornail | 3 | 146162 | 27 | 6.703 | 21805.5 |
329 | 2023-12-31 20:32:19 | doornail | 1 | 82945 | 2 | 1.376 | 60279.8 |
328 | 2023-12-31 09:25:42 | doornail | 1 | 82945 | 2 | 1.343 | 61761.0 |
327 | 2023-12-21 17:39:32 | doornail | 2 | 121059 | 2 | 3.313 | 36540.6 |
326 | 2023-12-13 19:51:11 | doornail | 1 | 82945 | 2 | 1.390 | 59672.7 |
325 | 2023-12-09 11:47:34 | doornail | 4 | 161609 | 292 | 14.703 | 10991.6 |
324 | 2023-12-05 23:50:26 | doornail | 4 | 161609 | 292 | 11.860 | 13626.4 |
323 | 2023-11-29 20:14:49 | doornail | 1 | 82945 | 2 | 1.406 | 58993.6 |
322 | 2023-11-28 22:15:22 | doornail | 1 | 82945 | 2 | 1.313 | 63172.1 |
321 | 2023-11-27 19:34:03 | doornail | 1 | 82945 | 2 | 1.436 | 57761.1 |
320 | 2023-11-10 17:53:42 | doornail | 4 | 161609 | 292 | 28.066 | 5758.2 |
319 | 2023-10-29 06:10:55 | doornail | 1 | 82945 | 2 | 1.626 | 51011.7 |
318 | 2023-10-21 03:27:47 | doornail | 4 | 161609 | 292 | 12.656 | 12769.4 |
317 | 2023-10-20 11:29:36 | doornail | 1 | 82945 | 2 | 1.453 | 57085.3 |
316 | 2023-10-20 05:16:45 | doornail | 1 | 82945 | 2 | 1.393 | 59544.1 |
315 | 2023-10-17 04:18:54 | doornail | 3 | 146162 | 27 | 7.296 | 20033.2 |
314 | 2023-10-16 19:48:17 | doornail | 4 | 161609 | 292 | 13.936 | 11596.5 |
313 | 2023-09-27 09:14:05 | doornail | 1 | 82945 | 2 | 1.483 | 55930.5 |
312 | 2023-09-26 15:10:36 | doornail | 1 | 82945 | 2 | 1.266 | 65517.4 |
311 | 2023-09-25 21:00:11 | doornail | 1 | 82945 | 2 | 1.330 | 62364.7 |
310 | 2023-09-21 12:30:48 | doornail | 1 | 82945 | 2 | 1.283 | 64649.3 |
309 | 2023-09-21 02:40:11 | doornail | 2 | 121059 | 2 | 3.606 | 33571.5 |
308 | 2023-09-20 04:01:56 | doornail | 1 | 82945 | 2 | 1.280 | 64800.8 |
307 | 2023-09-09 17:34:28 | doornail | 1 | 82945 | 2 | 1.453 | 57085.3 |
306 | 2023-09-08 05:54:48 | doornail | 1 | 82945 | 2 | 1.266 | 65517.4 |
305 | 2023-08-20 09:44:27 | doornail | 1 | 82945 | 2 | 1.376 | 60279.8 |
304 | 2023-08-19 02:02:11 | doornail | 1 | 82945 | 2 | 1.343 | 61761.0 |
303 | 2023-08-17 00:32:06 | doornail | 1 | 82945 | 2 | 1.250 | 66356.0 |
302 | 2023-08-16 19:31:38 | doornail | 1 | 82945 | 2 | 1.360 | 60989.0 |