History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"light"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1032 | 2025-08-28 09:25:31 | light | 1 | 28756 | 19 | 0.500 | 57512.0 |
1031 | 2025-08-23 07:16:52 | light | 1 | 28756 | 19 | 1.453 | 19790.8 |
1030 | 2025-08-23 00:00:34 | light | 1 | 28756 | 19 | 1.220 | 23570.5 |
1029 | 2025-08-18 20:34:37 | light | 1 | 28756 | 19 | 3.750 | 7668.3 |
1028 | 2025-08-04 14:31:33 | light | 3 | 83667 | 688 | 3.783 | 22116.6 |
1027 | 2025-08-04 03:23:51 | light | 1 | 28756 | 19 | 1.516 | 18968.3 |
1026 | 2025-08-01 19:20:32 | light | 3 | 83667 | 688 | 14.263 | 5866.0 |
1025 | 2025-08-01 14:20:32 | light | 1 | 28756 | 19 | 1.140 | 25224.6 |
1024 | 2025-07-31 19:10:08 | light | 1 | 28756 | 19 | 1.140 | 25224.6 |
1023 | 2025-07-27 10:08:45 | light | 1 | 28756 | 19 | 2.233 | 12877.7 |
1022 | 2025-07-27 00:59:34 | light | 3 | 83667 | 688 | 18.813 | 4447.3 |
1021 | 2025-07-26 18:09:23 | light | 1 | 28756 | 19 | 1.783 | 16127.9 |
1020 | 2025-07-23 10:25:12 | light | 1 | 28756 | 19 | 1.373 | 20943.9 |
1019 | 2025-07-22 14:39:51 | light | 1 | 28756 | 19 | 0.953 | 30174.2 |
1018 | 2025-07-22 14:21:59 | light | 1 | 28756 | 19 | 1.376 | 20898.3 |
1017 | 2025-07-21 10:28:15 | light | 1 | 28756 | 19 | 1.030 | 27918.4 |
1016 | 2025-07-21 09:46:06 | light | 3 | 83667 | 688 | 13.970 | 5989.0 |
1015 | 2025-07-18 00:42:06 | light | 3 | 83667 | 688 | 11.423 | 7324.4 |
1014 | 2025-07-17 23:44:59 | light | 3 | 83667 | 688 | 22.703 | 3685.3 |
1013 | 2025-07-17 16:50:22 | light | 2 | 53800 | 91 | 7.500 | 7173.3 |
1012 | 2025-07-17 15:47:05 | light | 3 | 83667 | 688 | 14.376 | 5819.9 |
1011 | 2025-07-17 12:42:08 | light | 3 | 83667 | 688 | 10.310 | 8115.1 |
1010 | 2025-07-15 22:04:35 | light | 1 | 28756 | 19 | 0.563 | 51076.4 |
1009 | 2025-07-15 22:04:15 | light | 3 | 83667 | 688 | 5.190 | 16120.8 |
1008 | 2025-07-15 19:50:10 | light | 1 | 28756 | 19 | 1.030 | 27918.4 |
1007 | 2025-07-14 10:53:52 | light | 1 | 28756 | 19 | 2.750 | 10456.7 |
1006 | 2025-07-14 00:37:31 | light | 2 | 53800 | 91 | 4.656 | 11555.0 |
1005 | 2025-07-13 04:31:45 | light | 1 | 28756 | 19 | 0.970 | 29645.4 |
1004 | 2025-07-06 08:03:57 | light | 1 | 28756 | 19 | 2.046 | 14054.7 |
1003 | 2025-07-04 12:02:48 | light | 1 | 28756 | 19 | 1.906 | 15087.1 |
1002 | 2025-07-04 03:27:49 | light | 1 | 28756 | 19 | 3.220 | 8930.4 |
1001 | 2025-07-02 13:23:30 | light | 1 | 28756 | 19 | 2.436 | 11804.6 |
1000 | 2025-07-02 11:11:59 | light | 3 | 83667 | 688 | 18.706 | 4472.7 |
999 | 2025-06-30 11:45:00 | light | 1 | 28756 | 19 | 2.250 | 12780.4 |
998 | 2025-06-29 13:43:26 | light | 1 | 28756 | 19 | 0.453 | 63479.0 |
997 | 2025-06-27 19:35:04 | light | 1 | 28756 | 19 | 1.030 | 27918.4 |
996 | 2025-06-22 23:23:45 | light | 1 | 28756 | 19 | 0.530 | 54256.6 |
995 | 2025-06-21 15:19:17 | light | 1 | 28756 | 19 | 0.513 | 56054.6 |
994 | 2025-06-20 22:18:35 | light | 3 | 83667 | 688 | 14.923 | 5606.6 |
993 | 2025-06-20 10:07:11 | light | 1 | 28756 | 19 | 3.780 | 7607.4 |
992 | 2025-06-17 22:46:46 | light | 3 | 83667 | 688 | 13.220 | 6328.8 |
991 | 2025-06-16 15:44:01 | light | 1 | 28756 | 19 | 3.720 | 7730.1 |
990 | 2025-06-16 12:00:14 | light | 3 | 83667 | 688 | 22.233 | 3763.2 |
989 | 2025-06-16 10:41:12 | light | 3 | 83667 | 688 | 16.706 | 5008.2 |
988 | 2025-06-16 07:00:20 | light | 3 | 83667 | 688 | 21.533 | 3885.5 |
987 | 2025-06-14 23:17:02 | light | 3 | 83667 | 688 | 4.266 | 19612.5 |
986 | 2025-06-14 03:40:48 | light | 1 | 28756 | 19 | 3.296 | 8724.5 |
985 | 2025-06-12 02:55:44 | light | 1 | 28756 | 19 | 1.856 | 15493.5 |
984 | 2025-06-11 12:09:26 | light | 1 | 28756 | 19 | 1.373 | 20943.9 |
983 | 2025-06-02 12:39:12 | light | 1 | 28756 | 19 | 1.826 | 15748.1 |
982 | 2025-06-02 03:19:12 | light | 1 | 28756 | 19 | 2.390 | 12031.8 |
981 | 2025-05-31 04:55:16 | light | 3 | 83667 | 688 | 14.920 | 5607.7 |
980 | 2025-05-30 11:59:51 | light | 1 | 28756 | 19 | 1.406 | 20452.3 |
979 | 2025-05-30 07:25:11 | light | 1 | 28756 | 19 | 1.033 | 27837.4 |
978 | 2025-05-29 04:09:22 | light | 3 | 83667 | 688 | 19.093 | 4382.1 |
977 | 2025-05-28 21:10:15 | light | 3 | 83667 | 688 | 27.186 | 3077.6 |
976 | 2025-05-28 21:10:34 | light | 1 | 28756 | 19 | 2.516 | 11429.3 |
975 | 2025-05-28 19:00:39 | light | 1 | 28756 | 19 | 0.436 | 65954.1 |
974 | 2025-05-27 09:01:58 | light | 2 | 53800 | 91 | 4.516 | 11913.2 |
973 | 2025-05-26 10:47:06 | light | 1 | 28756 | 19 | 1.420 | 20250.7 |
972 | 2025-05-25 06:48:01 | light | 2 | 53800 | 91 | 1.656 | 32487.9 |
971 | 2025-05-24 10:56:43 | light | 3 | 83667 | 688 | 12.216 | 6849.0 |
970 | 2025-05-23 16:52:08 | light | 1 | 28756 | 19 | 2.516 | 11429.3 |
969 | 2025-05-20 23:08:19 | light | 3 | 83667 | 688 | 3.890 | 21508.2 |
968 | 2025-05-20 20:30:31 | light | 3 | 83667 | 688 | 3.953 | 21165.4 |
967 | 2025-05-20 07:21:28 | light | 1 | 28756 | 19 | 3.016 | 9534.5 |
966 | 2025-05-19 01:37:37 | light | 1 | 28756 | 19 | 0.843 | 34111.5 |
965 | 2025-05-14 03:36:15 | light | 1 | 28756 | 19 | 1.953 | 14724.0 |
964 | 2025-05-12 11:44:48 | light | 3 | 83667 | 688 | 13.420 | 6234.5 |
963 | 2025-05-12 03:14:04 | light | 1 | 28756 | 19 | 0.936 | 30722.2 |
962 | 2025-05-11 04:04:46 | light | 3 | 83667 | 688 | 19.890 | 4206.5 |
961 | 2025-05-10 19:35:15 | light | 3 | 83667 | 688 | 21.216 | 3943.6 |
960 | 2025-05-10 18:18:14 | light | 3 | 83667 | 688 | 15.143 | 5525.1 |
959 | 2025-05-10 06:58:23 | light | 3 | 83667 | 688 | 13.360 | 6262.5 |
958 | 2025-05-08 23:14:35 | light | 3 | 83667 | 688 | 3.423 | 24442.6 |
957 | 2025-05-05 08:02:41 | light | 1 | 28756 | 19 | 0.470 | 61183.0 |
956 | 2025-05-03 18:24:56 | light | 1 | 28756 | 19 | 0.563 | 51076.4 |
955 | 2025-04-25 14:47:07 | light | 2 | 53800 | 91 | 4.220 | 12748.8 |
954 | 2025-04-23 19:05:02 | light | 3 | 83667 | 688 | 5.000 | 16733.4 |
953 | 2025-04-21 08:10:09 | light | 3 | 83667 | 688 | 25.673 | 3258.9 |
952 | 2025-04-20 06:34:39 | light | 1 | 28756 | 19 | 1.390 | 20687.8 |
951 | 2025-04-13 07:07:39 | light | 3 | 83667 | 688 | 3.546 | 23594.8 |
950 | 2025-04-12 03:30:33 | light | 1 | 28756 | 19 | 1.183 | 24307.7 |
949 | 2025-04-10 23:27:36 | light | 2 | 53800 | 91 | 5.766 | 9330.6 |
948 | 2025-04-10 03:13:06 | light | 1 | 28756 | 19 | 0.500 | 57512.0 |
947 | 2025-04-04 12:02:38 | light | 3 | 83667 | 688 | 18.686 | 4477.5 |
946 | 2025-04-04 10:14:41 | light | 3 | 83667 | 688 | 14.250 | 5871.4 |
945 | 2025-04-02 08:59:00 | light | 3 | 83667 | 688 | 14.580 | 5738.5 |
944 | 2025-04-02 06:06:05 | light | 3 | 83667 | 688 | 31.033 | 2696.1 |
943 | 2025-03-31 14:22:36 | light | 3 | 83667 | 688 | 22.923 | 3649.9 |
942 | 2025-03-30 11:42:41 | light | 1 | 28756 | 19 | 0.500 | 57512.0 |
941 | 2025-03-21 00:53:51 | light | 2 | 53800 | 91 | 8.420 | 6389.5 |
940 | 2025-03-20 23:56:10 | light | 3 | 83667 | 688 | 27.033 | 3095.0 |
939 | 2025-03-19 08:38:24 | light | 1 | 28756 | 19 | 0.486 | 59168.7 |
938 | 2025-03-12 19:46:23 | light | 1 | 28756 | 19 | 3.720 | 7730.1 |
937 | 2025-03-12 11:56:40 | light | 1 | 28756 | 19 | 1.076 | 26724.9 |
936 | 2025-02-28 01:12:20 | light | 2 | 53800 | 91 | 10.533 | 5107.8 |
935 | 2025-02-27 19:28:05 | light | 2 | 53800 | 91 | 10.533 | 5107.8 |
934 | 2025-02-27 16:39:35 | light | 1 | 28756 | 19 | 2.406 | 11951.8 |
933 | 2025-02-27 16:01:57 | light | 3 | 83667 | 688 | 19.390 | 4315.0 |