History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"honours"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
946 | 2024-03-28 09:00:15 | honours | 1 | 69583 | 3 | 1.216 | 57222.9 |
945 | 2024-02-19 18:50:43 | honours | 1 | 69583 | 3 | 1.170 | 59472.6 |
944 | 2024-01-26 06:58:49 | honours | 1 | 69583 | 3 | 1.250 | 55666.4 |
943 | 2023-12-17 07:12:42 | honours | 2 | 107671 | 20 | 2.813 | 38276.2 |
942 | 2023-12-08 08:15:18 | honours | 1 | 69583 | 3 | 1.140 | 61037.7 |
941 | 2023-12-06 00:46:30 | honours | 1 | 69583 | 3 | 1.216 | 57222.9 |
940 | 2023-12-03 01:43:46 | honours | 1 | 69583 | 3 | 1.046 | 66522.9 |
939 | 2023-11-23 03:44:07 | honours | 3 | 134027 | 260 | 6.233 | 21502.8 |
938 | 2023-11-23 03:44:04 | honours | 2 | 107671 | 20 | 3.096 | 34777.5 |
937 | 2023-11-09 12:39:29 | honours | 1 | 69583 | 3 | 2.440 | 28517.6 |
936 | 2023-11-01 18:48:05 | honours | 1 | 69583 | 3 | 1.143 | 60877.5 |
935 | 2023-10-11 22:36:47 | honours | 1 | 69583 | 3 | 1.140 | 61037.7 |
934 | 2023-10-04 21:57:03 | honours | 1 | 69583 | 3 | 1.266 | 54962.9 |
933 | 2023-10-04 13:54:35 | honours | 3 | 134027 | 260 | 10.390 | 12899.6 |
932 | 2023-10-02 16:36:31 | honours | 3 | 134027 | 260 | 5.580 | 24019.2 |
931 | 2023-10-01 12:49:23 | honours | 1 | 69583 | 3 | 1.516 | 45899.1 |
930 | 2023-09-28 06:41:02 | honours | 1 | 69583 | 3 | 1.170 | 59472.6 |
929 | 2023-09-25 02:31:21 | honours | 3 | 134027 | 260 | 6.046 | 22167.9 |
928 | 2023-09-25 00:06:38 | honours | 1 | 69583 | 3 | 1.236 | 56296.9 |
927 | 2023-09-22 02:35:40 | honours | 1 | 69583 | 3 | 1.046 | 66522.9 |
926 | 2023-09-19 12:51:31 | honours | 2 | 107671 | 20 | 3.376 | 31893.1 |
925 | 2023-09-18 02:18:31 | honours | 1 | 69583 | 3 | 1.063 | 65459.1 |
924 | 2023-09-17 16:36:27 | honours | 2 | 107671 | 20 | 3.280 | 32826.5 |
923 | 2023-08-15 10:48:17 | honours | 3 | 134027 | 260 | 6.016 | 22278.4 |
922 | 2023-08-12 05:32:45 | honours | 3 | 134027 | 260 | 5.720 | 23431.3 |
921 | 2023-07-08 19:00:18 | honours | 1 | 69583 | 3 | 1.233 | 56433.9 |
920 | 2023-06-20 04:40:54 | honours | 2 | 107671 | 20 | 3.093 | 34811.2 |
919 | 2023-06-11 05:54:13 | honours | 1 | 69583 | 3 | 1.046 | 66522.9 |
918 | 2023-04-12 07:00:00 | honours | 1 | 69583 | 3 | 1.156 | 60192.9 |
917 | 2023-03-14 12:10:55 | honours | 2 | 107671 | 20 | 3.203 | 33615.7 |
916 | 2023-03-05 13:13:46 | honours | 1 | 69583 | 3 | 1.063 | 65459.1 |
915 | 2023-02-05 03:50:26 | honours | 1 | 69583 | 3 | 1.156 | 60192.9 |
914 | 2023-01-29 14:51:36 | honours | 3 | 134027 | 260 | 5.550 | 24149.0 |
913 | 2022-12-17 08:50:07 | honours | 2 | 107671 | 20 | 2.750 | 39153.1 |
912 | 2022-11-30 13:13:15 | honours | 3 | 134027 | 260 | 5.826 | 23005.0 |
911 | 2022-11-16 23:05:02 | honours | 1 | 69583 | 3 | 2.390 | 29114.2 |
910 | 2022-11-04 13:36:45 | honours | 3 | 134027 | 260 | 6.186 | 21666.2 |
909 | 2022-11-02 00:59:52 | honours | 3 | 134027 | 260 | 5.576 | 24036.4 |
908 | 2022-11-01 07:14:17 | honours | 3 | 134027 | 260 | 5.780 | 23188.1 |
907 | 2022-09-21 20:12:23 | honours | 3 | 134027 | 260 | 6.000 | 22337.8 |
906 | 2022-09-19 12:50:59 | honours | 1 | 69583 | 3 | 1.173 | 59320.5 |
905 | 2022-08-31 20:23:24 | honours | 1 | 69583 | 3 | 1.060 | 65644.3 |
904 | 2022-08-28 13:26:48 | honours | 3 | 134027 | 260 | 5.670 | 23637.9 |
903 | 2022-08-26 22:49:19 | honours | 3 | 134027 | 260 | 5.656 | 23696.4 |
902 | 2022-08-23 08:02:41 | honours | 1 | 69583 | 3 | 1.220 | 57035.2 |
901 | 2022-08-14 15:57:59 | honours | 1 | 69583 | 3 | 1.156 | 60192.9 |
900 | 2022-08-09 14:12:05 | honours | 2 | 107671 | 20 | 2.813 | 38276.2 |
899 | 2022-07-29 00:10:34 | honours | 1 | 69583 | 3 | 1.076 | 64668.2 |
898 | 2022-07-20 10:49:37 | honours | 1 | 69583 | 3 | 1.060 | 65644.3 |
897 | 2022-07-16 17:34:51 | honours | 1 | 69583 | 3 | 1.126 | 61796.6 |
896 | 2022-07-11 19:16:50 | honours | 3 | 134027 | 260 | 6.970 | 19229.1 |
895 | 2022-06-12 15:19:13 | honours | 3 | 134027 | 260 | 5.830 | 22989.2 |
894 | 2022-05-23 07:20:57 | honours | 1 | 69583 | 3 | 1.080 | 64428.7 |
893 | 2022-03-25 23:23:53 | honours | 3 | 134027 | 260 | 6.156 | 21771.8 |
892 | 2022-03-19 11:10:06 | honours | 1 | 69583 | 3 | 1.156 | 60192.9 |
891 | 2022-03-16 00:21:31 | honours | 1 | 69583 | 3 | 2.703 | 25742.9 |
890 | 2022-02-08 23:34:24 | honours | 1 | 69583 | 3 | 1.173 | 59320.5 |
889 | 2021-12-30 23:26:01 | honours | 3 | 134027 | 260 | 5.750 | 23309.0 |
888 | 2021-12-02 08:29:59 | honours | 1 | 69583 | 3 | 1.093 | 63662.4 |
887 | 2021-11-30 17:08:10 | honours | 1 | 69583 | 3 | 2.530 | 27503.2 |
886 | 2021-11-22 09:26:47 | honours | 1 | 69583 | 3 | 1.186 | 58670.3 |
885 | 2021-10-26 12:56:32 | honours | 1 | 69583 | 3 | 1.326 | 52475.9 |
884 | 2021-09-30 07:22:31 | honours | 3 | 134027 | 260 | 6.406 | 20922.1 |
883 | 2021-09-02 06:20:15 | honours | 3 | 134027 | 260 | 6.093 | 21996.9 |
882 | 2021-08-25 23:35:52 | honours | 1 | 69583 | 3 | 1.080 | 64428.7 |
881 | 2021-08-08 01:39:01 | honours | 3 | 134027 | 260 | 5.920 | 22639.7 |
880 | 2021-07-30 05:58:07 | honours | 3 | 134027 | 260 | 6.203 | 21606.8 |
879 | 2021-07-28 07:49:34 | honours | 3 | 134027 | 260 | 6.486 | 20664.0 |
878 | 2021-07-27 05:43:14 | honours | 3 | 134027 | 260 | 6.576 | 20381.2 |
877 | 2021-07-26 13:05:38 | honours | 3 | 134027 | 260 | 6.763 | 19817.7 |
876 | 2021-07-25 00:39:01 | honours | 3 | 134027 | 260 | 6.016 | 22278.4 |
875 | 2021-07-23 13:33:35 | honours | 2 | 107671 | 20 | 2.750 | 39153.1 |
874 | 2021-07-23 04:03:42 | honours | 3 | 134027 | 260 | 6.483 | 20673.6 |
873 | 2021-07-22 08:50:46 | honours | 3 | 134027 | 260 | 6.673 | 20085.0 |
872 | 2021-07-20 08:47:49 | honours | 3 | 134027 | 260 | 7.076 | 18941.1 |
871 | 2021-07-18 22:27:16 | honours | 3 | 134027 | 260 | 6.690 | 20033.9 |
870 | 2021-07-18 18:09:16 | honours | 3 | 134027 | 260 | 5.656 | 23696.4 |
869 | 2021-07-17 01:45:19 | honours | 3 | 134027 | 260 | 6.966 | 19240.2 |
868 | 2021-07-14 14:49:34 | honours | 3 | 134027 | 260 | 6.623 | 20236.6 |
867 | 2021-07-04 12:25:21 | honours | 3 | 134027 | 260 | 13.890 | 9649.2 |
866 | 2021-07-03 23:25:37 | honours | 3 | 134027 | 260 | 10.406 | 12879.8 |
865 | 2021-07-02 13:22:06 | honours | 3 | 134027 | 260 | 8.970 | 14941.7 |
864 | 2021-06-30 17:24:29 | honours | 3 | 134027 | 260 | 6.593 | 20328.7 |
863 | 2021-06-23 18:43:08 | honours | 3 | 134027 | 260 | 6.703 | 19995.1 |
862 | 2021-06-21 03:17:49 | honours | 3 | 134027 | 260 | 7.876 | 17017.1 |
861 | 2021-06-20 22:12:08 | honours | 1 | 69583 | 3 | 1.170 | 59472.6 |
860 | 2021-06-14 03:27:00 | honours | 3 | 134027 | 260 | 6.466 | 20728.0 |
859 | 2021-06-12 03:54:11 | honours | 3 | 134027 | 260 | 9.936 | 13489.0 |
858 | 2021-06-03 09:40:47 | honours | 3 | 134027 | 260 | 5.923 | 22628.2 |
857 | 2021-06-02 11:15:01 | honours | 3 | 134027 | 260 | 6.080 | 22043.9 |
856 | 2021-05-30 07:16:48 | honours | 3 | 134027 | 260 | 5.720 | 23431.3 |
855 | 2021-05-29 10:40:48 | honours | 1 | 69583 | 3 | 1.906 | 36507.3 |
854 | 2021-05-29 10:00:08 | honours | 3 | 134027 | 260 | 6.660 | 20124.2 |
853 | 2021-05-29 06:44:37 | honours | 3 | 134027 | 260 | 7.220 | 18563.3 |
852 | 2021-05-28 11:54:28 | honours | 3 | 134027 | 260 | 6.456 | 20760.1 |
851 | 2021-05-25 21:56:14 | honours | 3 | 134027 | 260 | 6.563 | 20421.6 |
850 | 2021-05-25 11:47:47 | honours | 3 | 134027 | 260 | 7.486 | 17903.7 |
849 | 2021-05-25 04:00:10 | honours | 1 | 69583 | 3 | 1.156 | 60192.9 |
848 | 2021-05-24 18:29:27 | honours | 3 | 134027 | 260 | 6.563 | 20421.6 |
847 | 2021-05-24 00:17:57 | honours | 3 | 134027 | 260 | 12.486 | 10734.2 |