History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"planned"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
704 | 2024-05-02 03:12:59 | planned | 1 | 69583 | 7 | 1.360 | 51164.0 |
703 | 2024-04-24 22:43:34 | planned | 2 | 107671 | 66 | 4.640 | 23205.0 |
702 | 2024-04-24 22:40:27 | planned | 3 | 134027 | 570 | 8.610 | 15566.4 |
701 | 2024-04-23 23:12:47 | planned | 3 | 134027 | 570 | 16.003 | 8375.1 |
700 | 2024-04-23 03:49:46 | planned | 3 | 134027 | 570 | 16.030 | 8361.0 |
699 | 2024-04-23 03:49:52 | planned | 2 | 107671 | 66 | 5.780 | 18628.2 |
698 | 2024-04-23 02:00:32 | planned | 1 | 69583 | 7 | 1.356 | 51314.9 |
697 | 2024-03-23 08:29:26 | planned | 2 | 107671 | 66 | 11.953 | 9007.9 |
696 | 2024-03-23 07:53:19 | planned | 1 | 69583 | 7 | 1.216 | 57222.9 |
695 | 2024-03-02 11:23:21 | planned | 3 | 134027 | 570 | 7.000 | 19146.7 |
694 | 2024-03-01 11:04:24 | planned | 2 | 107671 | 66 | 7.360 | 14629.2 |
693 | 2024-03-01 09:33:29 | planned | 2 | 107671 | 66 | 8.843 | 12175.8 |
692 | 2024-03-01 07:45:27 | planned | 3 | 134027 | 570 | 7.470 | 17942.0 |
691 | 2024-02-29 16:14:59 | planned | 3 | 134027 | 570 | 6.140 | 21828.5 |
690 | 2024-02-21 12:40:32 | planned | 1 | 69583 | 7 | 4.220 | 16488.9 |
689 | 2024-02-05 22:32:50 | planned | 1 | 69583 | 7 | 1.170 | 59472.6 |
688 | 2024-02-02 02:48:55 | planned | 1 | 69583 | 7 | 1.080 | 64428.7 |
687 | 2024-01-19 16:50:16 | planned | 1 | 69583 | 7 | 2.440 | 28517.6 |
686 | 2024-01-18 12:35:07 | planned | 2 | 107671 | 66 | 3.220 | 33438.2 |
685 | 2024-01-16 19:52:38 | planned | 3 | 134027 | 570 | 6.533 | 20515.4 |
684 | 2024-01-12 00:56:30 | planned | 1 | 69583 | 7 | 1.326 | 52475.9 |
683 | 2023-12-16 10:08:31 | planned | 3 | 134027 | 570 | 6.950 | 19284.5 |
682 | 2023-12-15 19:18:49 | planned | 3 | 134027 | 570 | 8.016 | 16719.9 |
681 | 2023-12-15 14:53:20 | planned | 1 | 69583 | 7 | 1.216 | 57222.9 |
680 | 2023-12-05 04:21:19 | planned | 1 | 69583 | 7 | 1.220 | 57035.2 |
679 | 2023-11-18 23:49:43 | planned | 3 | 134027 | 570 | 6.313 | 21230.3 |
678 | 2023-11-17 16:58:38 | planned | 1 | 69583 | 7 | 1.093 | 63662.4 |
677 | 2023-11-03 15:27:53 | planned | 1 | 69583 | 7 | 1.280 | 54361.7 |
676 | 2023-10-25 08:59:32 | planned | 1 | 69583 | 7 | 1.173 | 59320.5 |
675 | 2023-10-25 07:02:43 | planned | 1 | 69583 | 7 | 1.203 | 57841.2 |
674 | 2023-10-21 16:54:31 | planned | 1 | 69583 | 7 | 1.206 | 57697.3 |
673 | 2023-09-29 12:11:02 | planned | 1 | 69583 | 7 | 1.203 | 57841.2 |
672 | 2023-09-26 00:21:51 | planned | 1 | 69583 | 7 | 1.080 | 64428.7 |
671 | 2023-08-27 23:57:26 | planned | 1 | 69583 | 7 | 1.123 | 61961.7 |
670 | 2023-07-04 07:59:53 | planned | 3 | 134027 | 570 | 6.576 | 20381.2 |
669 | 2023-07-03 10:56:44 | planned | 3 | 134027 | 570 | 6.016 | 22278.4 |
668 | 2023-07-02 07:19:57 | planned | 3 | 134027 | 570 | 5.970 | 22450.1 |
667 | 2023-07-01 06:22:47 | planned | 3 | 134027 | 570 | 5.750 | 23309.0 |
666 | 2023-07-01 01:59:20 | planned | 1 | 69583 | 7 | 1.063 | 65459.1 |
665 | 2023-06-30 07:26:06 | planned | 3 | 134027 | 570 | 5.766 | 23244.4 |
664 | 2023-06-29 11:52:46 | planned | 3 | 134027 | 570 | 5.846 | 22926.3 |
663 | 2023-06-28 12:48:42 | planned | 3 | 134027 | 570 | 12.206 | 10980.4 |
662 | 2023-06-27 07:55:51 | planned | 3 | 134027 | 570 | 5.766 | 23244.4 |
661 | 2023-06-26 13:14:06 | planned | 3 | 134027 | 570 | 5.720 | 23431.3 |
660 | 2023-06-25 13:45:40 | planned | 3 | 134027 | 570 | 5.830 | 22989.2 |
659 | 2023-06-25 07:07:42 | planned | 3 | 134027 | 570 | 5.906 | 22693.4 |
658 | 2023-06-24 07:23:13 | planned | 3 | 134027 | 570 | 6.076 | 22058.4 |
657 | 2023-06-23 12:43:21 | planned | 3 | 134027 | 570 | 6.173 | 21711.8 |
656 | 2023-06-22 06:55:24 | planned | 3 | 134027 | 570 | 5.766 | 23244.4 |
655 | 2023-06-21 06:55:43 | planned | 3 | 134027 | 570 | 6.216 | 21561.6 |
654 | 2023-06-20 07:30:38 | planned | 3 | 134027 | 570 | 5.780 | 23188.1 |
653 | 2023-06-19 08:03:06 | planned | 3 | 134027 | 570 | 6.283 | 21331.7 |
652 | 2023-06-18 07:22:57 | planned | 3 | 134027 | 570 | 6.033 | 22215.6 |
651 | 2023-06-17 13:28:56 | planned | 3 | 134027 | 570 | 5.686 | 23571.4 |
650 | 2023-06-09 16:51:58 | planned | 3 | 134027 | 570 | 5.950 | 22525.5 |
649 | 2023-06-08 20:03:10 | planned | 3 | 134027 | 570 | 5.686 | 23571.4 |
648 | 2023-05-28 15:34:10 | planned | 1 | 69583 | 7 | 1.063 | 65459.1 |
647 | 2023-03-28 08:05:56 | planned | 1 | 69583 | 7 | 1.170 | 59472.6 |
646 | 2023-03-22 21:04:29 | planned | 1 | 69583 | 7 | 1.046 | 66522.9 |
645 | 2023-01-09 05:17:08 | planned | 1 | 69583 | 7 | 1.043 | 66714.3 |
644 | 2022-12-24 04:03:01 | planned | 3 | 134027 | 570 | 12.703 | 10550.8 |
643 | 2022-12-23 04:03:18 | planned | 3 | 134027 | 570 | 6.190 | 21652.2 |
642 | 2022-12-22 04:02:50 | planned | 3 | 134027 | 570 | 6.170 | 21722.4 |
641 | 2022-12-21 04:02:20 | planned | 3 | 134027 | 570 | 6.923 | 19359.7 |
640 | 2022-12-06 14:12:41 | planned | 1 | 69583 | 7 | 1.156 | 60192.9 |
639 | 2022-12-06 03:38:46 | planned | 3 | 134027 | 570 | 6.046 | 22167.9 |
638 | 2022-12-05 03:51:56 | planned | 3 | 134027 | 570 | 5.750 | 23309.0 |
637 | 2022-12-04 04:06:18 | planned | 3 | 134027 | 570 | 5.720 | 23431.3 |
636 | 2022-12-03 03:38:24 | planned | 3 | 134027 | 570 | 7.813 | 17154.4 |
635 | 2022-12-02 03:39:08 | planned | 3 | 134027 | 570 | 6.813 | 19672.2 |
634 | 2022-12-01 03:37:56 | planned | 3 | 134027 | 570 | 6.266 | 21389.6 |
633 | 2022-11-13 23:08:49 | planned | 3 | 134027 | 570 | 6.436 | 20824.6 |
632 | 2022-11-12 16:19:06 | planned | 3 | 134027 | 570 | 10.673 | 12557.6 |
631 | 2022-11-11 05:52:23 | planned | 3 | 134027 | 570 | 6.453 | 20769.7 |
630 | 2022-11-10 21:29:48 | planned | 3 | 134027 | 570 | 6.720 | 19944.5 |
629 | 2022-11-09 09:34:20 | planned | 3 | 134027 | 570 | 7.360 | 18210.2 |
628 | 2022-11-08 12:35:19 | planned | 3 | 134027 | 570 | 6.813 | 19672.2 |
627 | 2022-11-07 18:41:07 | planned | 3 | 134027 | 570 | 9.906 | 13529.9 |
626 | 2022-11-06 15:02:30 | planned | 3 | 134027 | 570 | 6.970 | 19229.1 |
625 | 2022-10-30 17:33:29 | planned | 3 | 134027 | 570 | 6.236 | 21492.5 |
624 | 2022-10-09 20:20:34 | planned | 1 | 69583 | 7 | 1.063 | 65459.1 |
623 | 2022-09-22 23:52:37 | planned | 3 | 134027 | 570 | 5.783 | 23176.0 |
622 | 2022-08-25 06:56:52 | planned | 3 | 134027 | 570 | 5.860 | 22871.5 |
621 | 2022-08-24 05:20:02 | planned | 3 | 134027 | 570 | 6.686 | 20045.9 |
620 | 2022-08-03 01:17:11 | planned | 1 | 69583 | 7 | 1.110 | 62687.4 |
619 | 2022-07-05 23:20:51 | planned | 3 | 134027 | 570 | 6.000 | 22337.8 |
618 | 2022-05-26 05:56:18 | planned | 1 | 69583 | 7 | 1.060 | 65644.3 |
617 | 2022-05-16 11:27:42 | planned | 3 | 134027 | 570 | 6.656 | 20136.3 |
616 | 2022-04-30 14:31:15 | planned | 3 | 134027 | 570 | 6.186 | 21666.2 |
615 | 2022-04-08 11:47:16 | planned | 1 | 69583 | 7 | 3.000 | 23194.3 |
614 | 2022-04-05 01:08:40 | planned | 1 | 69583 | 7 | 1.296 | 53690.6 |
613 | 2022-03-31 03:32:54 | planned | 3 | 134027 | 570 | 7.093 | 18895.7 |
612 | 2022-03-28 07:29:13 | planned | 3 | 134027 | 570 | 5.830 | 22989.2 |
611 | 2022-02-09 13:03:35 | planned | 3 | 134027 | 570 | 5.843 | 22938.0 |
610 | 2022-02-05 09:10:04 | planned | 1 | 69583 | 7 | 1.216 | 57222.9 |
609 | 2021-12-24 10:03:45 | planned | 1 | 69583 | 7 | 1.250 | 55666.4 |
608 | 2021-11-25 01:28:10 | planned | 1 | 69583 | 7 | 1.033 | 67360.1 |
607 | 2021-10-06 16:08:55 | planned | 1 | 69583 | 7 | 1.343 | 51811.6 |
606 | 2021-09-20 11:00:10 | planned | 1 | 69583 | 7 | 1.266 | 54962.9 |
605 | 2021-09-06 16:53:22 | planned | 1 | 69583 | 7 | 1.046 | 66522.9 |