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 |
| 1039 | 2026-04-14 23:54:33 | lamp | 1 | 13983 | 19 | 0.530 | 26383.0 |
| 1038 | 2026-04-14 08:34:18 | lamp | 2 | 29872 | 258 | 0.893 | 33451.3 |
| 1037 | 2026-04-13 02:25:14 | lamp | 2 | 29872 | 258 | 2.280 | 13101.8 |
| 1036 | 2026-04-09 14:43:39 | lamp | 1 | 13983 | 19 | 0.296 | 47239.9 |
| 1035 | 2026-04-06 12:22:41 | lamp | 1 | 13983 | 19 | 1.203 | 11623.4 |
| 1034 | 2026-04-02 18:07:45 | lamp | 1 | 13983 | 19 | 0.750 | 18644.0 |
| 1033 | 2026-04-02 07:04:20 | lamp | 1 | 13983 | 19 | 0.796 | 17566.6 |
| 1032 | 2026-04-01 15:49:11 | lamp | 2 | 29872 | 258 | 4.160 | 7180.8 |
| 1031 | 2026-03-31 23:43:54 | lamp | 2 | 29872 | 258 | 2.156 | 13855.3 |
| 1030 | 2026-03-30 18:35:47 | lamp | 2 | 29872 | 258 | 3.923 | 7614.6 |
| 1029 | 2026-03-23 22:17:50 | lamp | 2 | 29872 | 258 | 4.436 | 6734.0 |
| 1028 | 2026-03-23 10:45:31 | lamp | 1 | 13983 | 19 | 1.266 | 11045.0 |
| 1027 | 2026-03-22 04:48:57 | lamp | 1 | 13983 | 19 | 0.936 | 14939.1 |
| 1026 | 2026-03-19 00:08:55 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
| 1025 | 2026-03-15 12:15:58 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
| 1024 | 2026-03-15 07:02:17 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 1023 | 2026-03-12 09:44:40 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 1022 | 2026-03-11 05:03:06 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
| 1021 | 2026-03-11 00:30:19 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
| 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 |