History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"penner"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
784 | 2024-03-31 04:53:09 | penner | 1 | 48755 | 8 | 0.966 | 50471.0 |
783 | 2024-03-28 21:40:36 | penner | 1 | 48755 | 8 | 2.000 | 24377.5 |
782 | 2024-03-27 04:18:09 | penner | 1 | 48755 | 8 | 0.750 | 65006.7 |
781 | 2024-03-09 20:50:13 | penner | 2 | 82551 | 140 | 3.813 | 21649.9 |
780 | 2024-02-28 04:58:08 | penner | 2 | 82551 | 140 | 5.873 | 14056.0 |
779 | 2024-02-28 01:03:15 | penner | 2 | 82551 | 140 | 3.376 | 24452.3 |
778 | 2024-02-27 21:38:29 | penner | 2 | 82551 | 140 | 4.453 | 18538.3 |
777 | 2024-02-25 20:30:28 | penner | 1 | 48755 | 8 | 1.940 | 25131.4 |
776 | 2024-02-17 06:17:57 | penner | 2 | 82551 | 140 | 5.910 | 13968.0 |
775 | 2024-01-16 21:44:20 | penner | 2 | 82551 | 140 | 2.283 | 36159.0 |
774 | 2024-01-16 17:14:57 | penner | 2 | 82551 | 140 | 2.170 | 38041.9 |
773 | 2024-01-03 04:04:58 | penner | 2 | 82551 | 140 | 2.343 | 35233.0 |
772 | 2023-12-19 15:19:28 | penner | 1 | 48755 | 8 | 0.766 | 63648.8 |
771 | 2023-12-11 09:04:45 | penner | 2 | 82551 | 140 | 2.550 | 32372.9 |
770 | 2023-12-09 05:54:47 | penner | 1 | 48755 | 8 | 0.856 | 56956.8 |
769 | 2023-12-05 17:47:15 | penner | 1 | 48755 | 8 | 0.903 | 53992.2 |
768 | 2023-11-29 05:19:45 | penner | 2 | 82551 | 140 | 2.610 | 31628.7 |
767 | 2023-11-14 00:52:21 | penner | 1 | 48755 | 8 | 1.970 | 24748.7 |
766 | 2023-11-11 05:40:20 | penner | 1 | 48755 | 8 | 0.763 | 63899.1 |
765 | 2023-10-27 15:46:01 | penner | 1 | 48755 | 8 | 0.876 | 55656.4 |
764 | 2023-10-26 01:15:28 | penner | 2 | 82551 | 140 | 2.440 | 33832.4 |
763 | 2023-10-23 09:17:21 | penner | 1 | 48755 | 8 | 0.826 | 59025.4 |
762 | 2023-10-19 01:52:45 | penner | 1 | 48755 | 8 | 0.843 | 57835.1 |
761 | 2023-10-11 14:18:30 | penner | 1 | 48755 | 8 | 0.876 | 55656.4 |
760 | 2023-10-08 17:52:20 | penner | 1 | 48755 | 8 | 0.843 | 57835.1 |
759 | 2023-10-06 19:06:06 | penner | 1 | 48755 | 8 | 0.860 | 56691.9 |
758 | 2023-09-25 22:38:53 | penner | 1 | 48755 | 8 | 0.813 | 59969.2 |
757 | 2023-09-23 15:41:13 | penner | 1 | 48755 | 8 | 0.843 | 57835.1 |
756 | 2023-09-02 13:06:26 | penner | 2 | 82551 | 140 | 2.203 | 37472.1 |
755 | 2023-08-10 15:31:27 | penner | 2 | 82551 | 140 | 2.423 | 34069.7 |
754 | 2023-08-09 20:00:27 | penner | 1 | 48755 | 8 | 0.750 | 65006.7 |
753 | 2023-08-05 02:04:31 | penner | 2 | 82551 | 140 | 2.263 | 36478.6 |
752 | 2023-08-02 09:51:09 | penner | 1 | 48755 | 8 | 0.783 | 62266.9 |
751 | 2023-07-17 10:03:53 | penner | 2 | 82551 | 140 | 2.186 | 37763.5 |
750 | 2023-07-09 18:36:56 | penner | 2 | 82551 | 140 | 2.190 | 37694.5 |
749 | 2023-07-08 11:35:25 | penner | 2 | 82551 | 140 | 2.423 | 34069.7 |
748 | 2023-07-07 15:48:19 | penner | 2 | 82551 | 140 | 2.390 | 34540.2 |
747 | 2023-07-06 17:42:43 | penner | 2 | 82551 | 140 | 2.296 | 35954.3 |
746 | 2023-06-23 07:38:13 | penner | 2 | 82551 | 140 | 2.326 | 35490.5 |
745 | 2023-05-22 14:24:30 | penner | 2 | 82551 | 140 | 2.500 | 33020.4 |
744 | 2023-05-02 21:04:10 | penner | 2 | 82551 | 140 | 2.123 | 38884.1 |
743 | 2023-05-01 08:12:23 | penner | 1 | 48755 | 8 | 0.796 | 61250.0 |
742 | 2023-04-24 21:34:52 | penner | 1 | 48755 | 8 | 0.843 | 57835.1 |
741 | 2023-04-17 17:55:44 | penner | 2 | 82551 | 140 | 2.156 | 38289.0 |
740 | 2023-04-02 19:01:33 | penner | 2 | 82551 | 140 | 4.000 | 20637.8 |
739 | 2023-04-02 07:17:52 | penner | 2 | 82551 | 140 | 2.500 | 33020.4 |
738 | 2023-03-12 08:00:54 | penner | 2 | 82551 | 140 | 2.126 | 38829.3 |
737 | 2023-02-20 00:59:53 | penner | 1 | 48755 | 8 | 0.783 | 62266.9 |
736 | 2023-02-07 03:54:34 | penner | 2 | 82551 | 140 | 2.640 | 31269.3 |
735 | 2023-01-24 07:19:57 | penner | 2 | 82551 | 140 | 2.516 | 32810.4 |
734 | 2023-01-18 10:27:53 | penner | 2 | 82551 | 140 | 2.156 | 38289.0 |
733 | 2023-01-08 19:20:17 | penner | 1 | 48755 | 8 | 0.780 | 62506.4 |
732 | 2022-12-21 18:09:22 | penner | 2 | 82551 | 140 | 2.140 | 38575.2 |
731 | 2022-12-19 13:23:20 | penner | 1 | 48755 | 8 | 0.830 | 58741.0 |
730 | 2022-12-04 13:18:59 | penner | 2 | 82551 | 140 | 2.143 | 38521.2 |
729 | 2022-11-04 19:24:26 | penner | 2 | 82551 | 140 | 2.156 | 38289.0 |
728 | 2022-11-03 08:49:05 | penner | 2 | 82551 | 140 | 2.530 | 32628.9 |
727 | 2022-10-31 05:55:52 | penner | 2 | 82551 | 140 | 2.156 | 38289.0 |
726 | 2022-10-18 16:23:51 | penner | 2 | 82551 | 140 | 2.486 | 33206.4 |
725 | 2022-09-21 01:45:36 | penner | 2 | 82551 | 140 | 2.186 | 37763.5 |
724 | 2022-09-14 05:06:34 | penner | 1 | 48755 | 8 | 0.920 | 52994.6 |
723 | 2022-09-04 23:46:39 | penner | 2 | 82551 | 140 | 2.250 | 36689.3 |
722 | 2022-08-30 02:22:10 | penner | 1 | 48755 | 8 | 0.780 | 62506.4 |
721 | 2022-08-27 18:21:32 | penner | 1 | 48755 | 8 | 0.843 | 57835.1 |
720 | 2022-08-05 14:40:00 | penner | 2 | 82551 | 140 | 2.486 | 33206.4 |
719 | 2022-07-15 09:40:53 | penner | 2 | 82551 | 140 | 2.453 | 33653.1 |
718 | 2022-06-04 08:49:11 | penner | 2 | 82551 | 140 | 2.140 | 38575.2 |
717 | 2022-05-28 07:57:09 | penner | 2 | 82551 | 140 | 2.140 | 38575.2 |
716 | 2022-05-12 00:38:31 | penner | 1 | 48755 | 8 | 0.813 | 59969.2 |
715 | 2022-05-06 20:31:54 | penner | 2 | 82551 | 140 | 2.220 | 37185.1 |
714 | 2022-04-28 20:18:59 | penner | 2 | 82551 | 140 | 2.610 | 31628.7 |
713 | 2022-04-12 11:53:23 | penner | 1 | 48755 | 8 | 1.033 | 47197.5 |
712 | 2022-04-10 07:03:41 | penner | 1 | 48755 | 8 | 0.783 | 62266.9 |
711 | 2022-04-09 20:38:58 | penner | 2 | 82551 | 140 | 2.140 | 38575.2 |
710 | 2022-01-24 07:55:40 | penner | 1 | 48755 | 8 | 0.873 | 55847.7 |
709 | 2022-01-06 03:43:11 | penner | 1 | 48755 | 8 | 0.846 | 57630.0 |
708 | 2022-01-04 00:37:16 | penner | 1 | 48755 | 8 | 0.876 | 55656.4 |
707 | 2021-12-13 01:04:46 | penner | 2 | 82551 | 140 | 2.156 | 38289.0 |
706 | 2021-12-09 19:32:23 | penner | 2 | 82551 | 140 | 2.656 | 31080.9 |
705 | 2021-12-04 19:58:18 | penner | 2 | 82551 | 140 | 2.530 | 32628.9 |
704 | 2021-10-31 06:05:59 | penner | 1 | 48755 | 8 | 0.796 | 61250.0 |
703 | 2021-10-25 23:02:40 | penner | 2 | 82551 | 140 | 2.233 | 36968.7 |
702 | 2021-10-21 19:03:48 | penner | 2 | 82551 | 140 | 2.156 | 38289.0 |
701 | 2021-10-14 08:32:53 | penner | 1 | 48755 | 8 | 0.750 | 65006.7 |
700 | 2021-10-11 02:06:28 | penner | 1 | 48755 | 8 | 0.750 | 65006.7 |
699 | 2021-09-15 08:17:54 | penner | 1 | 48755 | 8 | 0.876 | 55656.4 |
698 | 2021-09-07 22:14:18 | penner | 2 | 82551 | 140 | 5.016 | 16457.5 |
697 | 2021-08-24 10:59:04 | penner | 1 | 48755 | 8 | 0.750 | 65006.7 |
696 | 2021-08-22 06:04:50 | penner | 1 | 48755 | 8 | 0.750 | 65006.7 |
695 | 2021-07-17 14:33:41 | penner | 2 | 82551 | 140 | 2.186 | 37763.5 |
694 | 2021-07-09 11:31:43 | penner | 1 | 48755 | 8 | 0.763 | 63899.1 |
693 | 2021-06-18 21:07:52 | penner | 2 | 82551 | 140 | 2.576 | 32046.2 |
692 | 2021-06-06 02:56:27 | penner | 2 | 82551 | 140 | 2.420 | 34112.0 |
691 | 2021-05-26 14:29:10 | penner | 1 | 48755 | 8 | 0.876 | 55656.4 |
690 | 2021-05-06 20:14:39 | penner | 2 | 82551 | 140 | 2.233 | 36968.7 |
689 | 2021-04-30 18:55:00 | penner | 1 | 48755 | 8 | 0.763 | 63899.1 |
688 | 2021-04-10 21:44:40 | penner | 2 | 82551 | 140 | 2.513 | 32849.6 |
687 | 2021-04-05 15:17:04 | penner | 1 | 48755 | 8 | 0.843 | 57835.1 |
686 | 2021-04-05 01:21:26 | penner | 2 | 82551 | 140 | 3.046 | 27101.4 |
685 | 2021-04-01 11:05:16 | penner | 1 | 48755 | 8 | 0.813 | 59969.2 |