History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lamp"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1020 | 2026-03-07 17:13:04 | lamp | 2 | 29872 | 258 | 2.346 | 12733.2 |
| 1019 | 2026-03-06 11:21:33 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 1018 | 2026-03-06 06:38:39 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 1017 | 2026-03-06 06:38:35 | lamp | 1 | 13983 | 19 | 0.360 | 38841.7 |
| 1016 | 2026-03-06 06:05:14 | lamp | 1 | 13983 | 19 | 0.296 | 47239.9 |
| 1015 | 2026-03-06 03:54:17 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 1014 | 2026-03-04 14:26:51 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
| 1013 | 2026-03-04 05:36:59 | lamp | 1 | 13983 | 19 | 0.673 | 20777.1 |
| 1012 | 2026-03-03 14:10:34 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 1011 | 2026-03-02 07:05:33 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
| 1010 | 2026-03-01 06:16:12 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 1009 | 2026-03-01 06:16:02 | lamp | 2 | 29872 | 258 | 0.890 | 33564.0 |
| 1008 | 2026-02-28 21:30:34 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 1007 | 2026-02-28 10:59:04 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 1006 | 2026-02-28 01:10:03 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
| 1005 | 2026-02-28 00:20:05 | lamp | 1 | 13983 | 19 | 0.283 | 49409.9 |
| 1004 | 2026-02-28 00:06:06 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 1003 | 2026-02-26 19:43:36 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 1002 | 2026-02-26 13:09:35 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 1001 | 2026-02-25 13:35:06 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 1000 | 2026-02-22 19:30:18 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 999 | 2026-02-22 00:02:33 | lamp | 1 | 13983 | 19 | 0.703 | 19890.5 |
| 998 | 2026-02-21 00:26:38 | lamp | 1 | 13983 | 19 | 0.546 | 25609.9 |
| 997 | 2026-02-20 10:28:08 | lamp | 1 | 13983 | 19 | 0.530 | 26383.0 |
| 996 | 2026-02-20 07:47:27 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 995 | 2026-02-20 05:40:16 | lamp | 1 | 13983 | 19 | 0.283 | 49409.9 |
| 994 | 2026-02-20 00:41:44 | lamp | 1 | 13983 | 19 | 0.983 | 14224.8 |
| 993 | 2026-02-19 07:59:29 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 992 | 2026-02-16 04:05:48 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 991 | 2026-02-12 05:44:52 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 990 | 2026-02-08 23:44:55 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 989 | 2026-02-08 09:34:45 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 988 | 2026-02-02 09:09:01 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 987 | 2026-02-02 00:23:03 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 986 | 2026-01-29 11:03:27 | lamp | 1 | 13983 | 19 | 0.783 | 17858.2 |
| 985 | 2026-01-29 10:56:20 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 984 | 2026-01-29 06:36:52 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 983 | 2026-01-27 11:27:22 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 982 | 2026-01-27 09:04:08 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 981 | 2026-01-26 16:50:33 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 980 | 2026-01-25 11:06:48 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 979 | 2026-01-23 00:19:27 | lamp | 1 | 13983 | 19 | 1.173 | 11920.7 |
| 978 | 2026-01-19 06:02:57 | lamp | 1 | 13983 | 19 | 0.986 | 14181.5 |
| 977 | 2026-01-14 12:28:05 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 976 | 2026-01-13 20:44:41 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
| 975 | 2026-01-11 07:30:04 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
| 974 | 2026-01-07 01:08:07 | lamp | 1 | 13983 | 19 | 0.406 | 34440.9 |
| 973 | 2026-01-06 18:02:56 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 972 | 2026-01-06 11:25:14 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 971 | 2026-01-06 11:24:32 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 970 | 2026-01-06 08:05:54 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 969 | 2026-01-04 17:01:42 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
| 968 | 2026-01-02 17:49:29 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
| 967 | 2025-12-30 17:03:26 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 966 | 2025-12-29 13:59:32 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
| 965 | 2025-12-28 20:16:40 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 964 | 2025-12-28 14:04:11 | lamp | 1 | 13983 | 19 | 0.283 | 49409.9 |
| 963 | 2025-12-26 00:44:55 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 962 | 2025-12-25 06:37:05 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 961 | 2025-12-25 01:58:20 | lamp | 1 | 13983 | 19 | 0.670 | 20870.1 |
| 960 | 2025-12-24 03:11:16 | lamp | 2 | 29872 | 258 | 0.936 | 31914.5 |
| 959 | 2025-12-22 02:25:48 | lamp | 2 | 29872 | 258 | 4.250 | 7028.7 |
| 958 | 2025-12-19 20:22:17 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 957 | 2025-12-19 04:47:43 | lamp | 1 | 13983 | 19 | 0.700 | 19975.7 |
| 956 | 2025-12-19 04:47:30 | lamp | 2 | 29872 | 258 | 2.326 | 12842.6 |
| 955 | 2025-12-18 13:20:58 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 954 | 2025-12-14 09:57:24 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 953 | 2025-12-14 01:50:14 | lamp | 1 | 13983 | 19 | 2.033 | 6878.0 |
| 952 | 2025-12-14 01:50:07 | lamp | 1 | 13983 | 19 | 0.983 | 14224.8 |
| 951 | 2025-12-10 16:14:52 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 950 | 2025-12-09 21:08:04 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 949 | 2025-12-09 15:49:28 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 948 | 2025-12-08 16:00:55 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 947 | 2025-12-07 22:56:12 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 946 | 2025-12-01 15:33:06 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
| 945 | 2025-11-30 03:43:39 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
| 944 | 2025-11-24 05:11:14 | lamp | 1 | 13983 | 19 | 0.296 | 47239.9 |
| 943 | 2025-11-23 17:53:21 | lamp | 2 | 29872 | 258 | 0.910 | 32826.4 |
| 942 | 2025-11-23 09:05:20 | lamp | 1 | 13983 | 19 | 0.313 | 44674.1 |
| 941 | 2025-11-21 18:36:43 | lamp | 2 | 29872 | 258 | 0.873 | 34217.6 |
| 940 | 2025-11-19 11:02:55 | lamp | 1 | 13983 | 19 | 0.283 | 49409.9 |
| 939 | 2025-11-18 05:55:41 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 938 | 2025-11-17 10:31:29 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 937 | 2025-11-17 01:45:32 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 936 | 2025-11-15 13:19:09 | lamp | 1 | 13983 | 19 | 0.310 | 45106.5 |
| 935 | 2025-11-14 21:00:59 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 934 | 2025-11-14 04:38:18 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
| 933 | 2025-11-13 14:28:28 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 932 | 2025-11-10 18:22:50 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
| 931 | 2025-11-03 23:08:25 | lamp | 1 | 13983 | 19 | 2.063 | 6778.0 |
| 930 | 2025-10-28 14:16:04 | lamp | 1 | 13983 | 19 | 0.283 | 49409.9 |
| 929 | 2025-10-25 07:51:50 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 928 | 2025-10-20 01:40:04 | lamp | 1 | 13983 | 19 | 1.266 | 11045.0 |
| 927 | 2025-10-19 21:56:58 | lamp | 1 | 13983 | 19 | 0.283 | 49409.9 |
| 926 | 2025-10-19 11:48:41 | lamp | 1 | 13983 | 19 | 1.390 | 10059.7 |
| 925 | 2025-10-15 07:20:54 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 924 | 2025-10-12 18:28:19 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 923 | 2025-10-08 21:41:14 | lamp | 2 | 29872 | 258 | 0.936 | 31914.5 |
| 922 | 2025-10-08 02:25:23 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
| 921 | 2025-10-05 05:43:36 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |