History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hotch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
556 | 2024-05-04 06:09:40 | hotch | 1 | 28756 | 9 | 1.220 | 23570.5 |
555 | 2024-04-29 21:38:57 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
554 | 2024-04-29 17:06:30 | hotch | 1 | 28756 | 9 | 0.580 | 49579.3 |
553 | 2024-04-27 18:05:09 | hotch | 1 | 28756 | 9 | 1.170 | 24577.8 |
552 | 2024-04-25 22:16:04 | hotch | 3 | 83667 | 724 | 10.016 | 8353.3 |
551 | 2024-04-24 20:52:13 | hotch | 3 | 83667 | 724 | 4.216 | 19845.1 |
550 | 2024-04-05 17:30:23 | hotch | 3 | 83667 | 724 | 12.953 | 6459.3 |
549 | 2024-04-05 05:46:58 | hotch | 3 | 83667 | 724 | 9.326 | 8971.4 |
548 | 2024-04-05 05:46:59 | hotch | 2 | 53800 | 79 | 5.063 | 10626.1 |
547 | 2024-04-05 05:46:46 | hotch | 1 | 28756 | 9 | 1.673 | 17188.3 |
546 | 2024-04-05 05:46:34 | hotch | 3 | 83667 | 724 | 9.033 | 9262.4 |
545 | 2024-04-05 05:46:34 | hotch | 2 | 53800 | 79 | 5.640 | 9539.0 |
544 | 2024-04-05 05:46:29 | hotch | 1 | 28756 | 9 | 1.873 | 15352.9 |
543 | 2024-04-03 20:03:36 | hotch | 1 | 28756 | 9 | 0.560 | 51350.0 |
542 | 2024-04-03 03:38:35 | hotch | 1 | 28756 | 9 | 0.576 | 49923.6 |
541 | 2024-03-31 16:02:38 | hotch | 1 | 28756 | 9 | 0.546 | 52666.7 |
540 | 2024-03-31 07:47:25 | hotch | 1 | 28756 | 9 | 0.470 | 61183.0 |
539 | 2024-03-29 02:13:23 | hotch | 1 | 28756 | 9 | 0.673 | 42728.1 |
538 | 2024-03-06 02:00:06 | hotch | 3 | 83667 | 724 | 4.156 | 20131.6 |
537 | 2024-03-06 02:00:07 | hotch | 2 | 53800 | 79 | 1.716 | 31352.0 |
536 | 2024-03-06 02:00:04 | hotch | 1 | 28756 | 9 | 0.546 | 52666.7 |
535 | 2024-03-03 21:31:01 | hotch | 1 | 28756 | 9 | 0.470 | 61183.0 |
534 | 2024-03-01 05:56:20 | hotch | 1 | 28756 | 9 | 1.063 | 27051.7 |
533 | 2024-02-28 11:05:48 | hotch | 2 | 53800 | 79 | 1.686 | 31909.8 |
532 | 2024-02-28 11:05:27 | hotch | 3 | 83667 | 724 | 6.313 | 13253.1 |
531 | 2024-02-28 02:47:57 | hotch | 2 | 53800 | 79 | 1.983 | 27130.6 |
530 | 2024-02-28 02:47:40 | hotch | 3 | 83667 | 724 | 4.356 | 19207.3 |
529 | 2024-02-28 01:09:22 | hotch | 3 | 83667 | 724 | 5.610 | 14913.9 |
528 | 2024-02-28 01:09:18 | hotch | 2 | 53800 | 79 | 1.686 | 31909.8 |
527 | 2024-02-28 01:09:14 | hotch | 1 | 28756 | 9 | 0.546 | 52666.7 |
526 | 2024-02-02 20:37:15 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
525 | 2024-01-28 22:17:25 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
524 | 2024-01-15 13:09:31 | hotch | 3 | 83667 | 724 | 3.733 | 22412.8 |
523 | 2024-01-15 13:09:30 | hotch | 2 | 53800 | 79 | 1.660 | 32409.6 |
522 | 2023-12-29 12:19:24 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
521 | 2023-12-21 13:36:46 | hotch | 1 | 28756 | 9 | 0.440 | 65354.5 |
520 | 2023-12-18 05:27:18 | hotch | 3 | 83667 | 724 | 3.563 | 23482.2 |
519 | 2023-12-18 05:27:16 | hotch | 2 | 53800 | 79 | 1.656 | 32487.9 |
518 | 2023-12-17 11:10:26 | hotch | 3 | 83667 | 724 | 3.296 | 25384.4 |
517 | 2023-11-28 15:00:21 | hotch | 3 | 83667 | 724 | 3.326 | 25155.4 |
516 | 2023-11-28 15:00:14 | hotch | 2 | 53800 | 79 | 1.436 | 37465.2 |
515 | 2023-11-17 11:37:55 | hotch | 1 | 28756 | 9 | 0.440 | 65354.5 |
514 | 2023-11-11 21:41:19 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
513 | 2023-11-04 23:09:52 | hotch | 1 | 28756 | 9 | 0.450 | 63902.2 |
512 | 2023-10-25 07:18:04 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
511 | 2023-10-22 01:57:37 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
510 | 2023-10-17 07:42:52 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
509 | 2023-10-13 15:45:29 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
508 | 2023-10-09 06:09:29 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
507 | 2023-10-07 20:42:04 | hotch | 2 | 53800 | 79 | 1.373 | 39184.3 |
506 | 2023-10-05 06:45:51 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
505 | 2023-10-01 08:39:03 | hotch | 2 | 53800 | 79 | 1.360 | 39558.8 |
504 | 2023-09-29 07:53:07 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
503 | 2023-09-23 08:09:58 | hotch | 3 | 83667 | 724 | 3.266 | 25617.6 |
502 | 2023-09-18 07:49:13 | hotch | 3 | 83667 | 724 | 3.326 | 25155.4 |
501 | 2023-08-30 20:05:37 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
500 | 2023-08-05 17:50:21 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
499 | 2023-06-16 10:43:41 | hotch | 3 | 83667 | 724 | 3.233 | 25879.1 |
498 | 2023-05-17 07:05:33 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
497 | 2023-05-04 15:57:44 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
496 | 2023-03-14 17:35:45 | hotch | 3 | 83667 | 724 | 3.156 | 26510.5 |
495 | 2023-02-26 16:03:27 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
494 | 2023-01-31 10:32:53 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
493 | 2023-01-27 22:16:08 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
492 | 2022-12-24 16:42:11 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
491 | 2022-12-17 01:27:14 | hotch | 3 | 83667 | 724 | 3.750 | 22311.2 |
490 | 2022-11-25 03:51:06 | hotch | 1 | 28756 | 9 | 0.496 | 57975.8 |
489 | 2022-10-06 08:34:48 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
488 | 2022-10-02 18:39:44 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
487 | 2022-09-14 22:42:36 | hotch | 3 | 83667 | 724 | 3.326 | 25155.4 |
486 | 2022-09-13 11:06:35 | hotch | 3 | 83667 | 724 | 3.390 | 24680.5 |
485 | 2022-09-07 20:21:34 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
484 | 2022-09-05 17:43:26 | hotch | 1 | 28756 | 9 | 0.466 | 61708.2 |
483 | 2022-08-09 06:09:21 | hotch | 3 | 83667 | 724 | 3.203 | 26121.4 |
482 | 2022-06-15 20:15:42 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
481 | 2022-04-18 23:36:08 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
480 | 2022-03-12 11:18:47 | hotch | 3 | 83667 | 724 | 3.373 | 24804.9 |
479 | 2022-02-28 12:49:56 | hotch | 1 | 28756 | 9 | 0.623 | 46157.3 |
478 | 2022-02-05 07:37:14 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
477 | 2022-01-16 23:37:30 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
476 | 2022-01-01 01:23:49 | hotch | 1 | 28756 | 9 | 0.546 | 52666.7 |
475 | 2021-12-09 02:52:02 | hotch | 1 | 28756 | 9 | 0.533 | 53951.2 |
474 | 2021-11-20 06:31:01 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
473 | 2021-11-14 17:43:00 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
472 | 2021-11-12 16:08:01 | hotch | 1 | 28756 | 9 | 0.470 | 61183.0 |
471 | 2021-10-07 13:06:56 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
470 | 2021-09-30 08:31:09 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
469 | 2021-09-11 02:01:52 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
468 | 2021-08-14 01:55:22 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |
467 | 2021-07-09 13:04:48 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
466 | 2021-06-26 10:16:35 | hotch | 1 | 28756 | 9 | 0.486 | 59168.7 |
465 | 2021-06-23 00:21:11 | hotch | 2 | 53800 | 79 | 2.390 | 22510.5 |
464 | 2021-05-13 09:01:55 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
463 | 2021-04-28 13:48:28 | hotch | 1 | 28756 | 9 | 0.470 | 61183.0 |
462 | 2021-04-26 20:44:19 | hotch | 1 | 28756 | 9 | 0.456 | 63061.4 |
461 | 2021-04-03 16:33:41 | hotch | 2 | 53800 | 79 | 1.406 | 38264.6 |
460 | 2021-03-27 00:14:04 | hotch | 1 | 28756 | 9 | 0.483 | 59536.2 |
459 | 2021-02-18 02:46:05 | hotch | 1 | 28756 | 9 | 0.500 | 57512.0 |
458 | 2021-02-09 16:23:36 | hotch | 1 | 28756 | 9 | 0.453 | 63479.0 |
457 | 2021-01-28 10:28:53 | hotch | 1 | 28756 | 9 | 0.436 | 65954.1 |