History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trotter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
891 | 2024-04-27 16:37:44 | trotter | 1 | 69583 | 5 | 1.360 | 51164.0 |
890 | 2024-04-26 03:55:25 | trotter | 3 | 134027 | 642 | 7.266 | 18445.8 |
889 | 2024-03-19 21:45:39 | trotter | 2 | 107671 | 66 | 4.873 | 22095.4 |
888 | 2024-03-18 05:30:08 | trotter | 2 | 107671 | 66 | 3.453 | 31181.9 |
887 | 2024-03-12 19:35:30 | trotter | 3 | 134027 | 642 | 11.440 | 11715.6 |
886 | 2024-03-12 06:13:14 | trotter | 2 | 107671 | 66 | 3.296 | 32667.2 |
885 | 2024-03-11 18:53:28 | trotter | 3 | 134027 | 642 | 20.360 | 6582.9 |
884 | 2024-03-08 23:53:03 | trotter | 3 | 134027 | 642 | 24.550 | 5459.3 |
883 | 2024-03-08 23:50:35 | trotter | 3 | 134027 | 642 | 21.813 | 6144.4 |
882 | 2024-03-07 06:11:23 | trotter | 3 | 134027 | 642 | 9.360 | 14319.1 |
881 | 2024-03-07 06:11:21 | trotter | 2 | 107671 | 66 | 3.860 | 27894.0 |
880 | 2024-03-07 00:53:58 | trotter | 1 | 69583 | 5 | 1.046 | 66522.9 |
879 | 2024-02-02 00:04:56 | trotter | 1 | 69583 | 5 | 1.186 | 58670.3 |
878 | 2024-01-16 17:34:22 | trotter | 3 | 134027 | 642 | 7.533 | 17792.0 |
877 | 2024-01-16 17:34:25 | trotter | 2 | 107671 | 66 | 4.470 | 24087.5 |
876 | 2024-01-02 18:16:26 | trotter | 3 | 134027 | 642 | 6.156 | 21771.8 |
875 | 2023-11-26 09:20:19 | trotter | 3 | 134027 | 642 | 7.080 | 18930.4 |
874 | 2023-11-25 12:36:47 | trotter | 1 | 69583 | 5 | 1.093 | 63662.4 |
873 | 2023-11-21 10:25:56 | trotter | 1 | 69583 | 5 | 1.190 | 58473.1 |
872 | 2023-11-16 10:48:15 | trotter | 1 | 69583 | 5 | 1.063 | 65459.1 |
871 | 2023-11-15 19:52:25 | trotter | 1 | 69583 | 5 | 1.046 | 66522.9 |
870 | 2023-10-23 03:34:18 | trotter | 1 | 69583 | 5 | 1.093 | 63662.4 |
869 | 2023-10-16 15:36:57 | trotter | 1 | 69583 | 5 | 1.076 | 64668.2 |
868 | 2023-10-16 07:27:30 | trotter | 1 | 69583 | 5 | 1.173 | 59320.5 |
867 | 2023-09-27 09:01:53 | trotter | 2 | 107671 | 66 | 3.093 | 34811.2 |
866 | 2023-09-24 03:25:08 | trotter | 3 | 134027 | 642 | 6.356 | 21086.7 |
865 | 2023-09-19 00:59:51 | trotter | 3 | 134027 | 642 | 6.843 | 19586.0 |
864 | 2023-09-14 05:14:44 | trotter | 3 | 134027 | 642 | 8.326 | 16097.4 |
863 | 2023-09-12 19:15:28 | trotter | 1 | 69583 | 5 | 1.700 | 40931.2 |
862 | 2023-09-11 09:09:39 | trotter | 1 | 69583 | 5 | 1.233 | 56433.9 |
861 | 2023-09-04 22:30:42 | trotter | 3 | 134027 | 642 | 6.266 | 21389.6 |
860 | 2023-08-23 09:25:39 | trotter | 3 | 134027 | 642 | 5.813 | 23056.4 |
859 | 2023-06-15 00:18:21 | trotter | 1 | 69583 | 5 | 1.080 | 64428.7 |
858 | 2023-06-12 10:36:45 | trotter | 1 | 69583 | 5 | 1.063 | 65459.1 |
857 | 2023-06-09 03:45:38 | trotter | 1 | 69583 | 5 | 1.063 | 65459.1 |
856 | 2023-03-31 00:10:20 | trotter | 1 | 69583 | 5 | 1.046 | 66522.9 |
855 | 2023-03-20 06:57:01 | trotter | 3 | 134027 | 642 | 5.923 | 22628.2 |
854 | 2023-02-07 04:46:00 | trotter | 1 | 69583 | 5 | 1.156 | 60192.9 |
853 | 2023-01-24 21:35:04 | trotter | 3 | 134027 | 642 | 5.703 | 23501.1 |
852 | 2023-01-15 01:16:11 | trotter | 3 | 134027 | 642 | 5.673 | 23625.4 |
851 | 2023-01-13 20:59:34 | trotter | 1 | 69583 | 5 | 1.046 | 66522.9 |
850 | 2022-12-26 21:37:49 | trotter | 3 | 134027 | 642 | 7.110 | 18850.5 |
849 | 2022-12-16 20:11:32 | trotter | 3 | 134027 | 642 | 5.703 | 23501.1 |
848 | 2022-12-13 15:41:43 | trotter | 3 | 134027 | 642 | 6.736 | 19897.1 |
847 | 2022-12-10 17:09:30 | trotter | 3 | 134027 | 642 | 5.796 | 23124.1 |
846 | 2022-12-09 23:57:24 | trotter | 3 | 134027 | 642 | 6.173 | 21711.8 |
845 | 2022-11-06 03:08:09 | trotter | 3 | 134027 | 642 | 6.673 | 20085.0 |
844 | 2022-10-31 23:35:35 | trotter | 1 | 69583 | 5 | 1.063 | 65459.1 |
843 | 2022-09-28 21:44:37 | trotter | 1 | 69583 | 5 | 1.313 | 52995.4 |
842 | 2022-06-21 13:06:53 | trotter | 1 | 69583 | 5 | 1.096 | 63488.1 |
841 | 2022-05-26 02:40:04 | trotter | 1 | 69583 | 5 | 1.076 | 64668.2 |
840 | 2022-02-26 18:23:36 | trotter | 1 | 69583 | 5 | 1.063 | 65459.1 |
839 | 2022-02-06 00:07:44 | trotter | 3 | 134027 | 642 | 5.813 | 23056.4 |
838 | 2022-01-29 00:13:07 | trotter | 3 | 134027 | 642 | 7.296 | 18369.9 |
837 | 2022-01-28 01:19:25 | trotter | 1 | 69583 | 5 | 1.063 | 65459.1 |
836 | 2022-01-19 19:01:50 | trotter | 3 | 134027 | 642 | 7.030 | 19065.0 |
835 | 2022-01-17 02:05:33 | trotter | 3 | 134027 | 642 | 5.890 | 22755.0 |
834 | 2022-01-16 14:05:13 | trotter | 3 | 134027 | 642 | 6.580 | 20368.8 |
833 | 2022-01-16 12:39:19 | trotter | 3 | 134027 | 642 | 7.156 | 18729.3 |
832 | 2022-01-16 03:41:32 | trotter | 3 | 134027 | 642 | 6.483 | 20673.6 |
831 | 2022-01-15 15:04:25 | trotter | 3 | 134027 | 642 | 6.720 | 19944.5 |
830 | 2022-01-15 02:59:48 | trotter | 3 | 134027 | 642 | 6.563 | 20421.6 |
829 | 2022-01-14 11:47:03 | trotter | 3 | 134027 | 642 | 7.406 | 18097.1 |
828 | 2022-01-14 00:11:15 | trotter | 3 | 134027 | 642 | 6.300 | 21274.1 |
827 | 2022-01-13 21:41:53 | trotter | 3 | 134027 | 642 | 6.063 | 22105.7 |
826 | 2022-01-13 12:31:15 | trotter | 3 | 134027 | 642 | 7.170 | 18692.7 |
825 | 2022-01-13 05:49:52 | trotter | 3 | 134027 | 642 | 5.873 | 22820.9 |
824 | 2022-01-13 00:13:23 | trotter | 3 | 134027 | 642 | 13.203 | 10151.3 |
823 | 2022-01-12 11:42:50 | trotter | 3 | 134027 | 642 | 7.266 | 18445.8 |
822 | 2022-01-12 07:32:11 | trotter | 3 | 134027 | 642 | 8.280 | 16186.8 |
821 | 2022-01-11 11:39:17 | trotter | 3 | 134027 | 642 | 5.986 | 22390.1 |
820 | 2022-01-11 08:41:10 | trotter | 3 | 134027 | 642 | 6.843 | 19586.0 |
819 | 2022-01-10 18:54:31 | trotter | 3 | 134027 | 642 | 6.940 | 19312.2 |
818 | 2022-01-10 11:38:17 | trotter | 3 | 134027 | 642 | 6.656 | 20136.3 |
817 | 2022-01-10 04:06:54 | trotter | 3 | 134027 | 642 | 6.313 | 21230.3 |
816 | 2022-01-09 15:10:32 | trotter | 3 | 134027 | 642 | 6.783 | 19759.3 |
815 | 2022-01-09 11:33:14 | trotter | 3 | 134027 | 642 | 6.486 | 20664.0 |
814 | 2022-01-09 08:38:13 | trotter | 3 | 134027 | 642 | 6.970 | 19229.1 |
813 | 2022-01-08 16:41:55 | trotter | 3 | 134027 | 642 | 6.890 | 19452.4 |
812 | 2022-01-08 11:32:31 | trotter | 3 | 134027 | 642 | 5.703 | 23501.1 |
811 | 2022-01-07 15:12:37 | trotter | 3 | 134027 | 642 | 6.703 | 19995.1 |
810 | 2022-01-07 11:29:30 | trotter | 3 | 134027 | 642 | 6.656 | 20136.3 |
809 | 2022-01-06 22:55:42 | trotter | 3 | 134027 | 642 | 6.233 | 21502.8 |
808 | 2022-01-06 11:26:17 | trotter | 3 | 134027 | 642 | 6.750 | 19855.9 |
807 | 2022-01-06 00:14:03 | trotter | 3 | 134027 | 642 | 12.610 | 10628.6 |
806 | 2022-01-05 13:04:39 | trotter | 3 | 134027 | 642 | 6.343 | 21129.9 |
805 | 2022-01-05 11:24:55 | trotter | 3 | 134027 | 642 | 6.326 | 21186.7 |
804 | 2022-01-04 21:11:47 | trotter | 3 | 134027 | 642 | 7.233 | 18529.9 |
803 | 2022-01-04 11:21:34 | trotter | 3 | 134027 | 642 | 6.063 | 22105.7 |
802 | 2022-01-03 23:45:45 | trotter | 3 | 134027 | 642 | 5.826 | 23005.0 |
801 | 2021-12-30 21:20:26 | trotter | 3 | 134027 | 642 | 6.373 | 21030.4 |
800 | 2021-12-30 14:14:41 | trotter | 3 | 134027 | 642 | 7.686 | 17437.8 |
799 | 2021-12-29 11:19:24 | trotter | 3 | 134027 | 642 | 6.513 | 20578.4 |
798 | 2021-12-28 11:17:42 | trotter | 3 | 134027 | 642 | 6.000 | 22337.8 |
797 | 2021-12-27 11:16:20 | trotter | 3 | 134027 | 642 | 6.690 | 20033.9 |
796 | 2021-12-26 11:13:28 | trotter | 3 | 134027 | 642 | 6.923 | 19359.7 |
795 | 2021-12-25 11:31:09 | trotter | 3 | 134027 | 642 | 6.000 | 22337.8 |
794 | 2021-12-24 14:02:43 | trotter | 3 | 134027 | 642 | 7.800 | 17182.9 |
793 | 2021-12-23 20:55:26 | trotter | 3 | 134027 | 642 | 7.110 | 18850.5 |
792 | 2021-12-23 14:36:00 | trotter | 3 | 134027 | 642 | 7.593 | 17651.4 |