History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grandpa"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
708 | 2024-04-27 19:04:55 | grandpa | 1 | 69583 | 3 | 1.266 | 54962.9 |
707 | 2024-04-27 14:28:25 | grandpa | 1 | 69583 | 3 | 4.470 | 15566.7 |
706 | 2024-04-20 21:42:30 | grandpa | 3 | 134027 | 111 | 8.640 | 15512.4 |
705 | 2024-04-20 15:42:51 | grandpa | 2 | 107671 | 19 | 7.860 | 13698.6 |
704 | 2024-04-20 15:42:33 | grandpa | 3 | 134027 | 111 | 8.873 | 15105.0 |
703 | 2024-04-19 23:55:18 | grandpa | 3 | 134027 | 111 | 7.643 | 17535.9 |
702 | 2024-04-19 23:55:17 | grandpa | 2 | 107671 | 19 | 5.406 | 19916.9 |
701 | 2024-04-13 16:33:03 | grandpa | 2 | 107671 | 19 | 3.483 | 30913.3 |
700 | 2024-04-13 16:24:35 | grandpa | 3 | 134027 | 111 | 7.986 | 16782.7 |
699 | 2024-04-13 16:22:37 | grandpa | 3 | 134027 | 111 | 9.080 | 14760.7 |
698 | 2024-04-13 16:22:33 | grandpa | 1 | 69583 | 3 | 2.300 | 30253.5 |
697 | 2024-04-13 16:22:25 | grandpa | 2 | 107671 | 19 | 3.530 | 30501.7 |
696 | 2024-04-10 22:22:20 | grandpa | 2 | 107671 | 19 | 3.750 | 28712.3 |
695 | 2024-03-20 20:42:38 | grandpa | 1 | 69583 | 3 | 3.796 | 18330.6 |
694 | 2024-03-05 22:07:21 | grandpa | 1 | 69583 | 3 | 4.030 | 17266.3 |
693 | 2024-02-29 08:44:26 | grandpa | 1 | 69583 | 3 | 1.300 | 53525.4 |
692 | 2024-02-03 20:29:34 | grandpa | 3 | 134027 | 111 | 6.826 | 19634.8 |
691 | 2024-02-03 20:29:26 | grandpa | 2 | 107671 | 19 | 3.346 | 32179.0 |
690 | 2024-02-02 22:43:25 | grandpa | 2 | 107671 | 19 | 4.766 | 22591.5 |
689 | 2024-02-02 22:43:05 | grandpa | 3 | 134027 | 111 | 6.813 | 19672.2 |
688 | 2024-02-02 08:08:51 | grandpa | 2 | 107671 | 19 | 3.110 | 34620.9 |
687 | 2024-02-02 08:01:23 | grandpa | 3 | 134027 | 111 | 6.936 | 19323.4 |
686 | 2024-01-15 21:23:06 | grandpa | 1 | 69583 | 3 | 1.093 | 63662.4 |
685 | 2024-01-10 06:54:33 | grandpa | 3 | 134027 | 111 | 6.000 | 22337.8 |
684 | 2023-12-31 09:36:28 | grandpa | 3 | 134027 | 111 | 6.796 | 19721.5 |
683 | 2023-12-30 19:16:05 | grandpa | 1 | 69583 | 3 | 1.046 | 66522.9 |
682 | 2023-12-30 13:47:42 | grandpa | 1 | 69583 | 3 | 1.123 | 61961.7 |
681 | 2023-12-30 07:45:35 | grandpa | 3 | 134027 | 111 | 6.186 | 21666.2 |
680 | 2023-12-23 15:06:44 | grandpa | 1 | 69583 | 3 | 1.173 | 59320.5 |
679 | 2023-12-11 20:25:18 | grandpa | 2 | 107671 | 19 | 4.393 | 24509.7 |
678 | 2023-12-07 09:48:50 | grandpa | 1 | 69583 | 3 | 1.253 | 55533.1 |
677 | 2023-12-07 07:11:05 | grandpa | 3 | 134027 | 111 | 6.530 | 20524.8 |
676 | 2023-12-07 02:15:49 | grandpa | 1 | 69583 | 3 | 1.140 | 61037.7 |
675 | 2023-12-07 02:15:46 | grandpa | 1 | 69583 | 3 | 1.220 | 57035.2 |
674 | 2023-11-13 08:22:52 | grandpa | 3 | 134027 | 111 | 5.720 | 23431.3 |
673 | 2023-11-13 06:14:34 | grandpa | 1 | 69583 | 3 | 1.076 | 64668.2 |
672 | 2023-10-28 03:09:54 | grandpa | 3 | 134027 | 111 | 7.063 | 18975.9 |
671 | 2023-10-19 03:42:48 | grandpa | 3 | 134027 | 111 | 6.440 | 20811.6 |
670 | 2023-09-11 13:02:23 | grandpa | 2 | 107671 | 19 | 3.453 | 31181.9 |
669 | 2023-09-01 13:28:30 | grandpa | 1 | 69583 | 3 | 1.050 | 66269.5 |
668 | 2023-08-07 06:10:25 | grandpa | 1 | 69583 | 3 | 1.063 | 65459.1 |
667 | 2023-07-29 09:18:10 | grandpa | 3 | 134027 | 111 | 5.800 | 23108.1 |
666 | 2023-06-06 00:10:32 | grandpa | 1 | 69583 | 3 | 1.030 | 67556.3 |
665 | 2023-06-02 16:36:40 | grandpa | 2 | 107671 | 19 | 2.766 | 38926.6 |
664 | 2023-04-13 12:36:22 | grandpa | 3 | 134027 | 111 | 6.393 | 20964.6 |
663 | 2023-04-07 16:21:42 | grandpa | 1 | 69583 | 3 | 1.016 | 68487.2 |
662 | 2023-03-27 14:42:09 | grandpa | 1 | 69583 | 3 | 1.033 | 67360.1 |
661 | 2023-03-08 01:39:37 | grandpa | 2 | 107671 | 19 | 2.783 | 38688.8 |
660 | 2023-01-21 15:25:42 | grandpa | 3 | 134027 | 111 | 6.313 | 21230.3 |
659 | 2023-01-10 20:39:44 | grandpa | 1 | 69583 | 3 | 1.033 | 67360.1 |
658 | 2022-12-14 04:42:13 | grandpa | 2 | 107671 | 19 | 2.796 | 38508.9 |
657 | 2022-12-02 12:02:50 | grandpa | 1 | 69583 | 3 | 1.156 | 60192.9 |
656 | 2022-11-03 01:58:20 | grandpa | 3 | 134027 | 111 | 5.750 | 23309.0 |
655 | 2022-10-13 06:20:57 | grandpa | 1 | 69583 | 3 | 1.063 | 65459.1 |
654 | 2022-09-10 20:20:40 | grandpa | 1 | 69583 | 3 | 1.033 | 67360.1 |
653 | 2022-08-31 18:59:55 | grandpa | 1 | 69583 | 3 | 1.063 | 65459.1 |
652 | 2022-08-05 21:03:06 | grandpa | 2 | 107671 | 19 | 2.876 | 37437.8 |
651 | 2022-07-15 04:57:34 | grandpa | 1 | 69583 | 3 | 1.156 | 60192.9 |
650 | 2022-06-05 11:40:25 | grandpa | 3 | 134027 | 111 | 5.780 | 23188.1 |
649 | 2022-06-04 02:53:45 | grandpa | 1 | 69583 | 3 | 1.016 | 68487.2 |
648 | 2022-06-01 21:16:19 | grandpa | 1 | 69583 | 3 | 1.046 | 66522.9 |
647 | 2022-03-04 10:57:40 | grandpa | 1 | 69583 | 3 | 1.560 | 44604.5 |
646 | 2021-10-31 14:29:22 | grandpa | 1 | 69583 | 3 | 1.173 | 59320.5 |
645 | 2021-07-14 10:40:36 | grandpa | 1 | 69583 | 3 | 1.093 | 63662.4 |
644 | 2021-07-12 22:19:54 | grandpa | 2 | 107671 | 19 | 2.810 | 38317.1 |
643 | 2021-06-02 16:00:51 | grandpa | 1 | 69583 | 3 | 1.220 | 57035.2 |
642 | 2021-06-01 11:00:16 | grandpa | 1 | 69583 | 3 | 1.140 | 61037.7 |
641 | 2021-05-01 16:16:53 | grandpa | 2 | 107671 | 19 | 3.373 | 31921.4 |
640 | 2021-04-06 22:15:28 | grandpa | 1 | 69583 | 3 | 1.206 | 57697.3 |
639 | 2021-04-06 21:45:55 | grandpa | 1 | 69583 | 3 | 1.186 | 58670.3 |
638 | 2021-02-14 03:48:01 | grandpa | 2 | 107671 | 19 | 3.076 | 35003.6 |
637 | 2021-01-14 11:58:26 | grandpa | 2 | 107671 | 19 | 2.800 | 38453.9 |
636 | 2020-12-25 10:13:55 | grandpa | 1 | 69583 | 3 | 1.206 | 57697.3 |
635 | 2020-10-31 13:38:27 | grandpa | 1 | 69583 | 3 | 1.266 | 54962.9 |
634 | 2020-10-26 23:45:01 | grandpa | 2 | 107671 | 19 | 2.953 | 36461.6 |
633 | 2020-10-24 16:03:57 | grandpa | 1 | 69583 | 3 | 1.030 | 67556.3 |
632 | 2020-10-20 03:13:07 | grandpa | 1 | 69583 | 3 | 1.173 | 59320.5 |
631 | 2020-10-19 08:13:24 | grandpa | 1 | 69583 | 3 | 1.156 | 60192.9 |
630 | 2020-10-06 04:57:23 | grandpa | 1 | 69583 | 3 | 1.046 | 66522.9 |
629 | 2020-09-21 13:38:19 | grandpa | 1 | 69583 | 3 | 1.063 | 65459.1 |
628 | 2020-07-28 12:23:38 | grandpa | 1 | 69583 | 3 | 1.096 | 63488.1 |
627 | 2020-07-25 04:19:42 | grandpa | 1 | 69583 | 3 | 1.140 | 61037.7 |
626 | 2020-06-01 22:31:56 | grandpa | 1 | 69583 | 3 | 1.046 | 66522.9 |
625 | 2020-04-19 03:58:40 | grandpa | 1 | 69583 | 3 | 1.330 | 52318.0 |
624 | 2020-03-28 23:43:48 | grandpa | 1 | 69583 | 3 | 1.206 | 57697.3 |
623 | 2020-03-26 06:09:32 | grandpa | 1 | 69583 | 3 | 1.203 | 57841.2 |
622 | 2020-03-22 02:07:12 | grandpa | 1 | 69583 | 3 | 1.263 | 55093.4 |
621 | 2020-02-25 20:57:35 | grandpa | 1 | 69583 | 3 | 1.233 | 56433.9 |
620 | 2020-02-25 18:58:56 | grandpa | 1 | 69583 | 3 | 2.453 | 28366.5 |
619 | 2020-02-25 09:35:17 | grandpa | 1 | 69583 | 3 | 2.563 | 27149.0 |
618 | 2020-02-17 16:38:13 | grandpa | 1 | 69583 | 3 | 2.516 | 27656.2 |
617 | 2020-02-06 01:36:07 | grandpa | 1 | 69583 | 3 | 2.030 | 34277.3 |
616 | 2020-01-31 15:30:22 | grandpa | 1 | 69583 | 3 | 1.326 | 52475.9 |
615 | 2020-01-29 02:06:00 | grandpa | 1 | 69583 | 3 | 2.690 | 25867.3 |
614 | 2020-01-25 16:32:54 | grandpa | 1 | 69583 | 3 | 1.360 | 51164.0 |
613 | 2020-01-24 06:07:24 | grandpa | 1 | 69583 | 3 | 1.233 | 56433.9 |
612 | 2020-01-17 15:02:13 | grandpa | 1 | 69583 | 3 | 1.313 | 52995.4 |
611 | 2020-01-10 19:40:26 | grandpa | 1 | 69583 | 3 | 2.170 | 32065.9 |
610 | 2020-01-03 01:55:29 | grandpa | 1 | 69583 | 3 | 2.563 | 27149.0 |
609 | 2019-12-31 07:31:29 | grandpa | 1 | 69583 | 3 | 1.300 | 53525.4 |