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 |
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 |
932 | 2025-02-27 12:39:38 | light | 3 | 83667 | 688 | 25.613 | 3266.6 |
931 | 2025-02-27 12:36:38 | light | 2 | 53800 | 91 | 7.580 | 7097.6 |
930 | 2025-02-27 12:32:39 | light | 1 | 28756 | 19 | 0.596 | 48248.3 |
929 | 2025-02-27 09:15:44 | light | 3 | 83667 | 688 | 18.580 | 4503.1 |
928 | 2025-02-27 09:02:45 | light | 1 | 28756 | 19 | 0.483 | 59536.2 |
927 | 2025-02-11 01:10:50 | light | 3 | 83667 | 688 | 20.783 | 4025.7 |
926 | 2025-02-10 23:40:37 | light | 3 | 83667 | 688 | 28.986 | 2886.5 |
925 | 2025-02-07 12:16:51 | light | 1 | 28756 | 19 | 1.236 | 23265.4 |
924 | 2025-01-28 18:54:09 | light | 2 | 53800 | 91 | 7.670 | 7014.3 |
923 | 2025-01-28 12:42:39 | light | 3 | 83667 | 688 | 19.876 | 4209.4 |
922 | 2025-01-28 06:55:39 | light | 2 | 53800 | 91 | 7.970 | 6750.3 |
921 | 2025-01-28 06:53:36 | light | 1 | 28756 | 19 | 1.360 | 21144.1 |
920 | 2025-01-28 05:52:04 | light | 3 | 83667 | 688 | 24.846 | 3367.4 |
919 | 2025-01-28 03:33:57 | light | 3 | 83667 | 688 | 17.966 | 4657.0 |
918 | 2025-01-28 03:28:16 | light | 1 | 28756 | 19 | 1.000 | 28756.0 |
917 | 2025-01-27 18:50:25 | light | 1 | 28756 | 19 | 2.453 | 11722.8 |
916 | 2025-01-27 14:08:04 | light | 3 | 83667 | 688 | 28.020 | 2986.0 |
915 | 2025-01-27 14:03:54 | light | 3 | 83667 | 688 | 20.000 | 4183.4 |
914 | 2025-01-20 11:32:33 | light | 1 | 28756 | 19 | 1.813 | 15861.0 |
913 | 2025-01-09 17:42:36 | light | 2 | 53800 | 91 | 5.390 | 9981.4 |
912 | 2025-01-09 17:41:54 | light | 3 | 83667 | 688 | 4.126 | 20278.0 |
911 | 2024-12-29 06:25:53 | light | 2 | 53800 | 91 | 7.846 | 6857.0 |
910 | 2024-12-29 04:51:53 | light | 3 | 83667 | 688 | 19.406 | 4311.4 |
909 | 2024-12-29 01:42:19 | light | 3 | 83667 | 688 | 22.953 | 3645.1 |
908 | 2024-12-29 01:42:18 | light | 2 | 53800 | 91 | 7.263 | 7407.4 |