History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"madams"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
867 | 2024-04-27 13:43:35 | madams | 1 | 48755 | 4 | 2.220 | 21961.7 |
866 | 2024-03-29 23:16:43 | madams | 1 | 48755 | 4 | 1.626 | 29984.6 |
865 | 2024-03-29 04:16:02 | madams | 1 | 48755 | 4 | 1.983 | 24586.5 |
864 | 2024-03-14 18:46:24 | madams | 1 | 48755 | 4 | 0.970 | 50262.9 |
863 | 2024-03-08 17:34:04 | madams | 3 | 112716 | 689 | 16.470 | 6843.7 |
862 | 2024-03-08 08:36:47 | madams | 3 | 112716 | 689 | 15.110 | 7459.7 |
861 | 2024-02-28 05:11:28 | madams | 1 | 48755 | 4 | 1.953 | 24964.2 |
860 | 2024-02-15 03:44:57 | madams | 1 | 48755 | 4 | 2.843 | 17149.1 |
859 | 2024-02-13 05:26:57 | madams | 1 | 48755 | 4 | 0.846 | 57630.0 |
858 | 2024-02-12 13:55:13 | madams | 1 | 48755 | 4 | 0.796 | 61250.0 |
857 | 2024-02-11 23:58:51 | madams | 1 | 48755 | 4 | 0.953 | 51159.5 |
856 | 2024-02-11 10:22:51 | madams | 1 | 48755 | 4 | 1.016 | 47987.2 |
855 | 2024-02-10 00:27:40 | madams | 1 | 48755 | 4 | 3.203 | 15221.7 |
854 | 2024-02-03 19:28:15 | madams | 1 | 48755 | 4 | 0.813 | 59969.2 |
853 | 2024-02-01 23:11:53 | madams | 1 | 48755 | 4 | 0.893 | 54596.9 |
852 | 2024-02-01 19:10:36 | madams | 1 | 48755 | 4 | 0.753 | 64747.7 |
851 | 2024-02-01 07:30:39 | madams | 1 | 48755 | 4 | 0.873 | 55847.7 |
850 | 2024-01-31 23:22:17 | madams | 1 | 48755 | 4 | 0.860 | 56691.9 |
849 | 2024-01-31 19:09:02 | madams | 1 | 48755 | 4 | 0.843 | 57835.1 |
848 | 2024-01-30 22:28:27 | madams | 1 | 48755 | 4 | 0.796 | 61250.0 |
847 | 2024-01-30 18:59:12 | madams | 1 | 48755 | 4 | 0.903 | 53992.2 |
846 | 2024-01-30 00:47:20 | madams | 1 | 48755 | 4 | 0.826 | 59025.4 |
845 | 2024-01-23 14:57:58 | madams | 1 | 48755 | 4 | 1.923 | 25353.6 |
844 | 2024-01-22 22:56:00 | madams | 1 | 48755 | 4 | 0.826 | 59025.4 |
843 | 2024-01-22 14:45:37 | madams | 1 | 48755 | 4 | 0.860 | 56691.9 |
842 | 2024-01-21 22:01:31 | madams | 1 | 48755 | 4 | 0.843 | 57835.1 |
841 | 2024-01-21 14:07:37 | madams | 1 | 48755 | 4 | 0.856 | 56956.8 |
840 | 2024-01-20 19:36:28 | madams | 1 | 48755 | 4 | 0.843 | 57835.1 |
839 | 2024-01-13 22:05:47 | madams | 1 | 48755 | 4 | 0.766 | 63648.8 |
838 | 2024-01-12 20:56:07 | madams | 1 | 48755 | 4 | 0.750 | 65006.7 |
837 | 2024-01-12 17:58:59 | madams | 1 | 48755 | 4 | 0.843 | 57835.1 |
836 | 2024-01-11 22:00:50 | madams | 1 | 48755 | 4 | 0.843 | 57835.1 |
835 | 2024-01-06 14:40:17 | madams | 3 | 112716 | 689 | 4.780 | 23580.8 |
834 | 2024-01-06 14:40:15 | madams | 2 | 82551 | 39 | 2.236 | 36919.1 |
833 | 2024-01-05 11:26:57 | madams | 1 | 48755 | 4 | 0.860 | 56691.9 |
832 | 2024-01-01 21:12:18 | madams | 1 | 48755 | 4 | 0.750 | 65006.7 |
831 | 2023-12-28 19:37:08 | madams | 1 | 48755 | 4 | 0.750 | 65006.7 |
830 | 2023-12-11 12:03:33 | madams | 1 | 48755 | 4 | 0.780 | 62506.4 |
829 | 2023-12-09 12:45:20 | madams | 3 | 112716 | 689 | 5.233 | 21539.5 |
828 | 2023-12-09 12:45:22 | madams | 2 | 82551 | 39 | 2.406 | 34310.5 |
827 | 2023-11-23 21:39:33 | madams | 3 | 112716 | 689 | 4.830 | 23336.6 |
826 | 2023-11-16 15:43:24 | madams | 1 | 48755 | 4 | 0.796 | 61250.0 |
825 | 2023-11-14 08:39:17 | madams | 1 | 48755 | 4 | 0.860 | 56691.9 |
824 | 2023-11-13 06:39:39 | madams | 1 | 48755 | 4 | 0.733 | 66514.3 |
823 | 2023-11-12 14:39:34 | madams | 1 | 48755 | 4 | 0.766 | 63648.8 |
822 | 2023-11-11 02:15:09 | madams | 1 | 48755 | 4 | 0.843 | 57835.1 |
821 | 2023-11-05 22:02:10 | madams | 1 | 48755 | 4 | 0.843 | 57835.1 |
820 | 2023-10-29 22:36:42 | madams | 1 | 48755 | 4 | 0.830 | 58741.0 |
819 | 2023-10-11 03:27:27 | madams | 1 | 48755 | 4 | 0.940 | 51867.0 |
818 | 2023-10-07 19:16:09 | madams | 1 | 48755 | 4 | 0.813 | 59969.2 |
817 | 2023-09-23 10:33:34 | madams | 1 | 48755 | 4 | 0.766 | 63648.8 |
816 | 2023-09-17 04:22:01 | madams | 1 | 48755 | 4 | 0.813 | 59969.2 |
815 | 2023-09-06 10:09:50 | madams | 1 | 48755 | 4 | 0.750 | 65006.7 |
814 | 2023-09-04 07:35:40 | madams | 1 | 48755 | 4 | 0.750 | 65006.7 |
813 | 2023-08-23 17:14:20 | madams | 3 | 112716 | 689 | 9.500 | 11864.8 |
812 | 2023-05-23 22:48:30 | madams | 1 | 48755 | 4 | 0.830 | 58741.0 |
811 | 2023-05-06 21:18:06 | madams | 3 | 112716 | 689 | 4.640 | 24292.2 |
810 | 2023-02-13 10:24:17 | madams | 3 | 112716 | 689 | 5.046 | 22337.7 |
809 | 2023-02-11 00:30:20 | madams | 1 | 48755 | 4 | 1.720 | 28345.9 |
808 | 2023-02-05 08:19:38 | madams | 1 | 48755 | 4 | 0.733 | 66514.3 |
807 | 2022-12-04 06:55:36 | madams | 1 | 48755 | 4 | 0.846 | 57630.0 |
806 | 2022-11-26 00:20:52 | madams | 3 | 112716 | 689 | 4.736 | 23799.8 |
805 | 2022-10-28 02:23:14 | madams | 1 | 48755 | 4 | 0.733 | 66514.3 |
804 | 2022-09-08 00:46:15 | madams | 2 | 82551 | 39 | 2.143 | 38521.2 |
803 | 2022-07-30 15:35:47 | madams | 1 | 48755 | 4 | 0.733 | 66514.3 |
802 | 2022-07-14 12:24:23 | madams | 1 | 48755 | 4 | 0.780 | 62506.4 |
801 | 2022-04-17 14:42:39 | madams | 3 | 112716 | 689 | 4.750 | 23729.7 |
800 | 2022-03-25 08:34:04 | madams | 2 | 82551 | 39 | 3.283 | 25145.0 |
799 | 2022-03-24 21:51:05 | madams | 2 | 82551 | 39 | 2.623 | 31472.0 |
798 | 2022-03-24 18:24:13 | madams | 2 | 82551 | 39 | 3.046 | 27101.4 |
797 | 2022-03-23 17:58:40 | madams | 2 | 82551 | 39 | 2.830 | 29170.0 |
796 | 2022-03-23 04:49:19 | madams | 2 | 82551 | 39 | 2.813 | 29346.2 |
795 | 2022-03-22 19:01:32 | madams | 2 | 82551 | 39 | 2.656 | 31080.9 |
794 | 2022-03-20 22:23:03 | madams | 1 | 48755 | 4 | 0.750 | 65006.7 |
793 | 2022-03-19 19:06:05 | madams | 2 | 82551 | 39 | 2.546 | 32423.8 |
792 | 2022-03-19 00:41:39 | madams | 2 | 82551 | 39 | 2.123 | 38884.1 |
791 | 2022-03-18 05:46:53 | madams | 2 | 82551 | 39 | 2.156 | 38289.0 |
790 | 2022-03-17 12:02:41 | madams | 2 | 82551 | 39 | 5.373 | 15364.0 |
789 | 2022-03-17 11:49:22 | madams | 1 | 48755 | 4 | 0.936 | 52088.7 |
788 | 2022-03-16 12:14:23 | madams | 2 | 82551 | 39 | 3.063 | 26951.0 |
787 | 2022-03-10 01:20:12 | madams | 1 | 48755 | 4 | 0.766 | 63648.8 |
786 | 2022-02-10 18:26:31 | madams | 2 | 82551 | 39 | 2.453 | 33653.1 |
785 | 2022-02-10 00:43:10 | madams | 2 | 82551 | 39 | 2.406 | 34310.5 |
784 | 2022-02-09 12:37:52 | madams | 2 | 82551 | 39 | 2.283 | 36159.0 |
783 | 2022-02-08 11:56:24 | madams | 2 | 82551 | 39 | 2.500 | 33020.4 |
782 | 2022-02-07 14:19:41 | madams | 2 | 82551 | 39 | 2.233 | 36968.7 |
781 | 2022-01-21 19:48:17 | madams | 2 | 82551 | 39 | 2.170 | 38041.9 |
780 | 2022-01-20 18:06:35 | madams | 2 | 82551 | 39 | 2.596 | 31799.3 |
779 | 2022-01-17 21:47:03 | madams | 2 | 82551 | 39 | 2.186 | 37763.5 |
778 | 2021-12-27 06:52:56 | madams | 3 | 112716 | 689 | 4.766 | 23650.0 |
777 | 2021-12-25 03:37:39 | madams | 3 | 112716 | 689 | 5.156 | 21861.1 |
776 | 2021-12-20 10:12:04 | madams | 1 | 48755 | 4 | 0.970 | 50262.9 |
775 | 2021-12-18 07:39:29 | madams | 1 | 48755 | 4 | 0.890 | 54780.9 |
774 | 2021-12-07 00:40:21 | madams | 1 | 48755 | 4 | 0.830 | 58741.0 |
773 | 2021-12-03 18:01:54 | madams | 1 | 48755 | 4 | 0.846 | 57630.0 |
772 | 2021-11-15 21:49:22 | madams | 2 | 82551 | 39 | 2.546 | 32423.8 |
771 | 2021-11-15 10:46:06 | madams | 2 | 82551 | 39 | 2.533 | 32590.2 |
770 | 2021-11-14 15:48:46 | madams | 2 | 82551 | 39 | 2.546 | 32423.8 |
769 | 2021-11-13 23:54:40 | madams | 2 | 82551 | 39 | 2.173 | 37989.4 |
768 | 2021-11-13 12:50:42 | madams | 2 | 82551 | 39 | 2.343 | 35233.0 |