History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"kelly"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
664 | 2024-04-23 15:32:27 | kelly | 1 | 28756 | 9 | 0.486 | 59168.7 |
663 | 2024-04-23 15:14:06 | kelly | 1 | 28756 | 9 | 1.126 | 25538.2 |
662 | 2024-04-18 22:00:40 | kelly | 1 | 28756 | 9 | 0.733 | 39230.6 |
661 | 2024-04-17 07:02:13 | kelly | 1 | 28756 | 9 | 0.640 | 44931.3 |
660 | 2024-04-13 00:20:50 | kelly | 1 | 28756 | 9 | 0.533 | 53951.2 |
659 | 2024-04-04 23:01:15 | kelly | 2 | 53800 | 115 | 4.750 | 11326.3 |
658 | 2024-04-04 05:18:31 | kelly | 2 | 53800 | 115 | 1.720 | 31279.1 |
657 | 2024-04-03 05:33:36 | kelly | 1 | 28756 | 9 | 1.156 | 24875.4 |
656 | 2024-03-31 04:32:20 | kelly | 2 | 53800 | 115 | 5.373 | 10013.0 |
655 | 2024-03-31 04:23:51 | kelly | 1 | 28756 | 9 | 1.673 | 17188.3 |
654 | 2024-03-29 06:10:23 | kelly | 1 | 28756 | 9 | 1.123 | 25606.4 |
653 | 2024-03-29 06:10:16 | kelly | 2 | 53800 | 115 | 2.330 | 23090.1 |
652 | 2024-03-29 01:55:07 | kelly | 2 | 53800 | 115 | 5.533 | 9723.5 |
651 | 2024-03-29 01:53:11 | kelly | 1 | 28756 | 9 | 0.563 | 51076.4 |
650 | 2024-03-03 21:44:28 | kelly | 1 | 28756 | 9 | 0.516 | 55728.7 |
649 | 2024-03-01 02:53:52 | kelly | 1 | 28756 | 9 | 0.516 | 55728.7 |
648 | 2024-02-27 20:14:08 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
647 | 2024-02-22 16:28:15 | kelly | 1 | 28756 | 9 | 0.533 | 53951.2 |
646 | 2024-01-26 00:04:27 | kelly | 1 | 28756 | 9 | 0.513 | 56054.6 |
645 | 2024-01-12 03:26:49 | kelly | 2 | 53800 | 115 | 1.343 | 40059.6 |
644 | 2024-01-09 17:23:35 | kelly | 2 | 53800 | 115 | 1.533 | 35094.6 |
643 | 2023-12-29 23:53:07 | kelly | 1 | 28756 | 9 | 0.483 | 59536.2 |
642 | 2023-12-07 22:13:47 | kelly | 1 | 28756 | 9 | 1.046 | 27491.4 |
641 | 2023-12-05 10:34:13 | kelly | 2 | 53800 | 115 | 1.343 | 40059.6 |
640 | 2023-12-02 16:12:11 | kelly | 2 | 53800 | 115 | 1.593 | 33772.8 |
639 | 2023-11-16 07:39:59 | kelly | 1 | 28756 | 9 | 0.466 | 61708.2 |
638 | 2023-11-16 06:15:20 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
637 | 2023-11-04 02:14:34 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
636 | 2023-10-22 06:17:08 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
635 | 2023-10-19 11:39:26 | kelly | 1 | 28756 | 9 | 0.483 | 59536.2 |
634 | 2023-10-18 11:10:15 | kelly | 1 | 28756 | 9 | 0.483 | 59536.2 |
633 | 2023-10-11 21:59:36 | kelly | 1 | 28756 | 9 | 0.483 | 59536.2 |
632 | 2023-10-05 00:56:21 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
631 | 2023-09-29 05:13:39 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
630 | 2023-09-22 10:00:08 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
629 | 2023-09-01 20:19:07 | kelly | 2 | 53800 | 115 | 1.516 | 35488.1 |
628 | 2023-08-18 20:04:38 | kelly | 1 | 28756 | 9 | 0.440 | 65354.5 |
627 | 2023-08-14 13:39:01 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
626 | 2023-08-10 06:59:36 | kelly | 1 | 28756 | 9 | 0.486 | 59168.7 |
625 | 2023-08-09 07:50:55 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
624 | 2023-07-01 04:51:50 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
623 | 2023-05-19 09:00:23 | kelly | 2 | 53800 | 115 | 1.330 | 40451.1 |
622 | 2023-05-13 22:37:06 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
621 | 2023-05-09 02:38:18 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
620 | 2023-05-08 09:38:41 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
619 | 2023-05-04 21:16:42 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
618 | 2023-03-28 17:45:22 | kelly | 2 | 53800 | 115 | 1.326 | 40573.2 |
617 | 2023-03-19 00:37:25 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
616 | 2023-03-14 08:05:39 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
615 | 2023-03-07 15:58:41 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
614 | 2023-02-26 08:03:37 | kelly | 2 | 53800 | 115 | 1.313 | 40974.9 |
613 | 2023-01-29 15:53:57 | kelly | 1 | 28756 | 9 | 0.420 | 68466.7 |
612 | 2023-01-23 19:56:25 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
611 | 2023-01-20 09:43:17 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
610 | 2022-12-29 08:41:11 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
609 | 2022-12-09 13:34:50 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
608 | 2022-12-08 08:05:36 | kelly | 2 | 53800 | 115 | 1.546 | 34799.5 |
607 | 2022-12-06 08:50:23 | kelly | 1 | 28756 | 9 | 0.983 | 29253.3 |
606 | 2022-10-23 09:12:01 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
605 | 2022-10-20 09:56:05 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
604 | 2022-10-15 10:57:26 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
603 | 2022-09-16 23:25:25 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
602 | 2022-09-12 10:54:07 | kelly | 1 | 28756 | 9 | 0.420 | 68466.7 |
601 | 2022-09-06 18:14:44 | kelly | 1 | 28756 | 9 | 0.466 | 61708.2 |
600 | 2022-08-26 03:21:54 | kelly | 1 | 28756 | 9 | 0.420 | 68466.7 |
599 | 2022-08-17 14:50:53 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
598 | 2022-08-07 01:55:43 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
597 | 2022-07-30 03:02:57 | kelly | 1 | 28756 | 9 | 0.483 | 59536.2 |
596 | 2022-07-21 21:04:58 | kelly | 2 | 53800 | 115 | 1.343 | 40059.6 |
595 | 2022-07-21 00:17:47 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
594 | 2022-07-17 22:16:23 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
593 | 2022-07-16 21:41:15 | kelly | 1 | 28756 | 9 | 0.530 | 54256.6 |
592 | 2022-07-02 22:37:48 | kelly | 1 | 28756 | 9 | 0.486 | 59168.7 |
591 | 2022-07-01 00:53:18 | kelly | 1 | 28756 | 9 | 0.420 | 68466.7 |
590 | 2022-06-28 22:43:37 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
589 | 2022-06-28 20:36:39 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
588 | 2022-06-02 00:33:41 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
587 | 2022-05-29 22:02:07 | kelly | 1 | 28756 | 9 | 0.466 | 61708.2 |
586 | 2022-04-14 21:00:49 | kelly | 1 | 28756 | 9 | 0.610 | 47141.0 |
585 | 2022-04-11 07:02:10 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
584 | 2022-03-08 23:21:17 | kelly | 1 | 28756 | 9 | 0.686 | 41918.4 |
583 | 2022-03-05 22:58:17 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
582 | 2021-12-16 10:42:30 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
581 | 2021-11-25 07:15:03 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |
580 | 2021-11-21 20:26:33 | kelly | 1 | 28756 | 9 | 0.483 | 59536.2 |
579 | 2021-11-21 20:22:42 | kelly | 1 | 28756 | 9 | 0.516 | 55728.7 |
578 | 2021-10-27 01:51:42 | kelly | 1 | 28756 | 9 | 0.486 | 59168.7 |
577 | 2021-10-21 13:40:09 | kelly | 1 | 28756 | 9 | 0.580 | 49579.3 |
576 | 2021-09-11 14:08:34 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
575 | 2021-08-27 03:00:07 | kelly | 1 | 28756 | 9 | 0.420 | 68466.7 |
574 | 2021-08-18 23:48:53 | kelly | 1 | 28756 | 9 | 0.436 | 65954.1 |
573 | 2021-07-23 07:06:00 | kelly | 1 | 28756 | 9 | 0.470 | 61183.0 |
572 | 2021-06-12 04:59:31 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
571 | 2021-06-07 08:40:24 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
570 | 2021-05-18 06:46:56 | kelly | 1 | 28756 | 9 | 0.513 | 56054.6 |
569 | 2021-05-17 23:07:27 | kelly | 1 | 28756 | 9 | 0.513 | 56054.6 |
568 | 2021-04-17 23:31:46 | kelly | 1 | 28756 | 9 | 0.500 | 57512.0 |
567 | 2021-03-20 20:13:57 | kelly | 1 | 28756 | 9 | 0.453 | 63479.0 |
566 | 2021-02-23 00:13:02 | kelly | 2 | 53800 | 115 | 1.736 | 30990.8 |
565 | 2021-02-15 01:01:40 | kelly | 1 | 28756 | 9 | 0.423 | 67981.1 |