History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
502 | 2024-04-20 20:40:18 | knap | 1 | 13983 | 6 | 0.513 | 27257.3 |
501 | 2024-04-04 19:32:13 | knap | 1 | 13983 | 6 | 0.783 | 17858.2 |
500 | 2024-03-31 10:16:29 | knap | 2 | 29872 | 118 | 2.423 | 12328.5 |
499 | 2024-03-31 08:19:00 | knap | 1 | 13983 | 6 | 0.466 | 30006.4 |
498 | 2024-03-29 07:25:49 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
497 | 2024-03-29 07:12:42 | knap | 2 | 29872 | 118 | 3.436 | 8693.8 |
496 | 2024-03-28 19:05:02 | knap | 2 | 29872 | 118 | 2.203 | 13559.7 |
495 | 2024-03-28 17:56:46 | knap | 1 | 13983 | 6 | 0.500 | 27966.0 |
494 | 2024-03-05 17:32:35 | knap | 1 | 13983 | 6 | 0.533 | 26234.5 |
493 | 2024-03-02 18:31:00 | knap | 2 | 29872 | 118 | 0.970 | 30795.9 |
492 | 2024-03-02 17:06:27 | knap | 1 | 13983 | 6 | 0.216 | 64736.1 |
491 | 2024-02-26 03:26:57 | knap | 1 | 13983 | 6 | 0.280 | 49939.3 |
490 | 2024-02-03 03:27:46 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
489 | 2024-01-26 22:25:33 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
488 | 2024-01-09 01:10:04 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
487 | 2024-01-06 01:36:12 | knap | 2 | 29872 | 118 | 0.783 | 38150.7 |
486 | 2024-01-03 16:36:29 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
485 | 2023-12-06 23:05:21 | knap | 2 | 29872 | 118 | 0.750 | 39829.3 |
484 | 2023-12-03 10:11:56 | knap | 2 | 29872 | 118 | 1.610 | 18554.0 |
483 | 2023-11-28 20:22:25 | knap | 2 | 29872 | 118 | 0.733 | 40753.1 |
482 | 2023-11-15 00:45:24 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
481 | 2023-11-10 21:22:31 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
480 | 2023-11-10 13:26:43 | knap | 2 | 29872 | 118 | 0.813 | 36742.9 |
479 | 2023-11-08 02:23:01 | knap | 1 | 13983 | 6 | 0.186 | 75177.4 |
478 | 2023-10-27 15:27:28 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
477 | 2023-10-26 17:43:12 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
476 | 2023-10-21 08:40:35 | knap | 1 | 13983 | 6 | 0.216 | 64736.1 |
475 | 2023-10-17 20:09:18 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
474 | 2023-10-13 11:08:55 | knap | 1 | 13983 | 6 | 0.453 | 30867.5 |
473 | 2023-10-04 11:10:12 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
472 | 2023-09-28 11:19:56 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
471 | 2023-09-06 05:59:54 | knap | 1 | 13983 | 6 | 0.296 | 47239.9 |
470 | 2023-08-20 07:55:12 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
469 | 2023-05-22 19:27:18 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
468 | 2023-05-13 12:11:06 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
467 | 2023-05-09 20:33:05 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
466 | 2023-03-18 04:34:32 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
465 | 2023-01-26 17:56:03 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
464 | 2023-01-16 13:03:53 | knap | 1 | 13983 | 6 | 0.216 | 64736.1 |
463 | 2023-01-12 20:09:03 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
462 | 2023-01-05 19:13:19 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
461 | 2022-10-01 09:19:01 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
460 | 2022-09-14 12:20:10 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
459 | 2022-05-15 18:04:45 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
458 | 2022-05-14 07:47:37 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
457 | 2022-05-12 01:47:19 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
456 | 2022-01-28 01:09:33 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
455 | 2022-01-03 02:21:23 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
454 | 2021-12-31 23:07:11 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
453 | 2021-12-10 02:40:40 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
452 | 2021-11-15 11:33:00 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
451 | 2021-11-01 10:34:14 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
450 | 2021-10-30 09:39:11 | knap | 1 | 13983 | 6 | 0.483 | 28950.3 |
449 | 2021-10-11 08:33:38 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
448 | 2021-10-01 12:39:11 | knap | 1 | 13983 | 6 | 0.453 | 30867.5 |
447 | 2021-08-16 23:43:24 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
446 | 2021-07-09 19:48:03 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
445 | 2021-06-05 13:47:09 | knap | 1 | 13983 | 6 | 0.420 | 33292.9 |
444 | 2021-04-05 23:19:06 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
443 | 2021-04-01 19:05:43 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
442 | 2021-03-14 08:35:45 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
441 | 2021-02-17 20:32:42 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
440 | 2021-01-24 17:18:19 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
439 | 2020-12-24 12:59:12 | knap | 1 | 13983 | 6 | 0.216 | 64736.1 |
438 | 2020-10-22 02:53:18 | knap | 1 | 13983 | 6 | 0.216 | 64736.1 |
437 | 2020-10-13 02:11:40 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
436 | 2020-10-12 20:01:30 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
435 | 2020-09-20 16:47:22 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
434 | 2020-08-12 03:30:48 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
433 | 2020-06-13 19:32:25 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
432 | 2020-06-04 09:24:21 | knap | 1 | 13983 | 6 | 0.296 | 47239.9 |
431 | 2020-03-25 13:21:50 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
430 | 2020-03-25 02:04:22 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
429 | 2020-03-22 19:13:18 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
428 | 2020-03-21 11:27:13 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
427 | 2020-03-20 14:56:00 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
426 | 2020-03-20 02:32:08 | knap | 1 | 13983 | 6 | 0.236 | 59250.0 |
425 | 2020-03-19 18:50:05 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
424 | 2020-03-18 06:22:38 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
423 | 2020-03-17 13:22:10 | knap | 1 | 13983 | 6 | 0.220 | 63559.1 |
422 | 2020-03-10 04:11:48 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
421 | 2020-03-02 20:44:03 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
420 | 2020-02-25 01:12:32 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
419 | 2020-02-22 08:20:20 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
418 | 2020-02-19 23:46:29 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
417 | 2020-02-17 15:30:26 | knap | 1 | 13983 | 6 | 0.546 | 25609.9 |
416 | 2020-02-09 17:09:50 | knap | 1 | 13983 | 6 | 0.530 | 26383.0 |
415 | 2020-01-30 22:55:24 | knap | 1 | 13983 | 6 | 0.483 | 28950.3 |
414 | 2020-01-29 03:35:59 | knap | 1 | 13983 | 6 | 0.466 | 30006.4 |
413 | 2020-01-26 21:49:30 | knap | 1 | 13983 | 6 | 0.516 | 27098.8 |
412 | 2020-01-23 13:38:41 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
411 | 2020-01-22 20:48:23 | knap | 1 | 13983 | 6 | 0.296 | 47239.9 |
410 | 2020-01-20 17:41:06 | knap | 1 | 13983 | 6 | 0.486 | 28771.6 |
409 | 2020-01-14 14:50:11 | knap | 1 | 13983 | 6 | 0.500 | 27966.0 |
408 | 2020-01-10 10:56:35 | knap | 1 | 13983 | 6 | 0.233 | 60012.9 |
407 | 2020-01-10 06:41:40 | knap | 1 | 13983 | 6 | 0.500 | 27966.0 |
406 | 2020-01-07 00:32:11 | knap | 1 | 13983 | 6 | 0.546 | 25609.9 |
405 | 2020-01-01 21:32:09 | knap | 1 | 13983 | 6 | 0.250 | 55932.0 |
404 | 2019-12-23 17:30:45 | knap | 1 | 13983 | 6 | 0.203 | 68881.8 |
403 | 2019-12-23 16:50:00 | knap | 1 | 13983 | 6 | 0.266 | 52567.7 |