History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lighting"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1068 | 2025-11-17 10:33:03 | lighting | 3 | 146162 | 241 | 6.876 | 21256.8 |
| 1067 | 2025-11-16 10:01:27 | lighting | 1 | 82945 | 16 | 1.390 | 59672.7 |
| 1066 | 2025-11-05 16:24:58 | lighting | 3 | 146162 | 241 | 6.470 | 22590.7 |
| 1065 | 2025-11-01 17:16:48 | lighting | 1 | 82945 | 16 | 1.313 | 63172.1 |
| 1064 | 2025-10-28 18:14:20 | lighting | 3 | 146162 | 241 | 6.643 | 22002.4 |
| 1063 | 2025-10-28 08:22:07 | lighting | 3 | 146162 | 241 | 6.360 | 22981.4 |
| 1062 | 2025-10-24 23:59:46 | lighting | 3 | 146162 | 241 | 7.110 | 20557.2 |
| 1061 | 2025-10-15 14:38:31 | lighting | 1 | 82945 | 16 | 1.390 | 59672.7 |
| 1060 | 2025-10-10 20:10:50 | lighting | 1 | 82945 | 16 | 1.450 | 57203.4 |
| 1059 | 2025-10-08 15:17:06 | lighting | 1 | 82945 | 16 | 1.470 | 56425.2 |
| 1058 | 2025-10-06 05:14:11 | lighting | 1 | 82945 | 16 | 1.310 | 63316.8 |
| 1057 | 2025-09-19 23:51:08 | lighting | 1 | 82945 | 16 | 1.436 | 57761.1 |
| 1056 | 2025-09-16 01:47:29 | lighting | 1 | 82945 | 16 | 1.483 | 55930.5 |
| 1055 | 2025-08-27 21:11:31 | lighting | 1 | 82945 | 16 | 1.436 | 57761.1 |
| 1054 | 2025-08-23 10:27:17 | lighting | 3 | 146162 | 241 | 24.720 | 5912.7 |
| 1053 | 2025-08-19 04:12:39 | lighting | 3 | 146162 | 241 | 32.396 | 4511.7 |
| 1052 | 2025-08-17 03:56:38 | lighting | 1 | 82945 | 16 | 3.560 | 23299.2 |
| 1051 | 2025-08-15 07:55:08 | lighting | 3 | 146162 | 241 | 42.536 | 3436.2 |
| 1050 | 2025-08-13 18:26:25 | lighting | 3 | 146162 | 241 | 21.890 | 6677.1 |
| 1049 | 2025-08-09 03:01:45 | lighting | 1 | 82945 | 16 | 10.610 | 7817.6 |
| 1048 | 2025-07-30 20:32:19 | lighting | 1 | 82945 | 16 | 1.280 | 64800.8 |
| 1047 | 2025-07-27 14:47:33 | lighting | 3 | 146162 | 241 | 14.326 | 10202.6 |
| 1046 | 2025-07-27 00:26:51 | lighting | 3 | 146162 | 241 | 31.660 | 4616.6 |
| 1045 | 2025-07-26 23:52:10 | lighting | 1 | 82945 | 16 | 4.190 | 19795.9 |
| 1044 | 2025-07-22 05:01:50 | lighting | 1 | 82945 | 16 | 1.406 | 58993.6 |
| 1043 | 2025-07-20 20:31:34 | lighting | 1 | 82945 | 16 | 1.453 | 57085.3 |
| 1042 | 2025-07-20 07:36:00 | lighting | 3 | 146162 | 241 | 6.920 | 21121.7 |
| 1041 | 2025-07-18 18:28:40 | lighting | 1 | 82945 | 16 | 3.953 | 20982.8 |
| 1040 | 2025-07-17 14:08:53 | lighting | 2 | 121059 | 40 | 16.110 | 7514.5 |
| 1039 | 2025-07-11 17:36:23 | lighting | 3 | 146162 | 241 | 28.593 | 5111.8 |
| 1038 | 2025-07-10 05:40:42 | lighting | 2 | 121059 | 40 | 9.640 | 12558.0 |
| 1037 | 2025-07-07 15:30:30 | lighting | 2 | 121059 | 40 | 9.250 | 13087.5 |
| 1036 | 2025-07-07 13:21:15 | lighting | 3 | 146162 | 241 | 26.533 | 5508.7 |
| 1035 | 2025-07-05 21:18:07 | lighting | 1 | 82945 | 16 | 1.436 | 57761.1 |
| 1034 | 2025-07-05 12:44:41 | lighting | 3 | 146162 | 241 | 34.923 | 4185.3 |
| 1033 | 2025-07-04 05:34:42 | lighting | 3 | 146162 | 241 | 25.483 | 5735.7 |
| 1032 | 2025-07-04 05:34:18 | lighting | 3 | 146162 | 241 | 41.096 | 3556.6 |
| 1031 | 2025-07-03 02:11:52 | lighting | 3 | 146162 | 241 | 36.410 | 4014.3 |
| 1030 | 2025-07-01 20:33:44 | lighting | 1 | 82945 | 16 | 3.360 | 24686.0 |
| 1029 | 2025-07-01 04:21:07 | lighting | 1 | 82945 | 16 | 1.440 | 57600.7 |
| 1028 | 2025-06-26 00:46:06 | lighting | 2 | 121059 | 40 | 19.873 | 6091.6 |
| 1027 | 2025-06-25 23:09:50 | lighting | 1 | 82945 | 16 | 7.016 | 11822.3 |
| 1026 | 2025-06-16 04:29:02 | lighting | 1 | 82945 | 16 | 4.203 | 19734.7 |
| 1025 | 2025-06-10 12:33:24 | lighting | 1 | 82945 | 16 | 6.893 | 12033.2 |
| 1024 | 2025-06-10 11:08:48 | lighting | 3 | 146162 | 241 | 38.453 | 3801.1 |
| 1023 | 2025-06-06 14:12:01 | lighting | 3 | 146162 | 241 | 29.423 | 4967.6 |
| 1022 | 2025-06-05 21:09:30 | lighting | 1 | 82945 | 16 | 6.876 | 12063.0 |
| 1021 | 2025-06-05 11:49:59 | lighting | 3 | 146162 | 241 | 26.626 | 5489.4 |
| 1020 | 2025-06-05 11:32:05 | lighting | 3 | 146162 | 241 | 10.656 | 13716.4 |
| 1019 | 2025-06-04 00:54:58 | lighting | 3 | 146162 | 241 | 33.016 | 4427.0 |
| 1018 | 2025-06-02 12:33:46 | lighting | 3 | 146162 | 241 | 31.986 | 4569.6 |
| 1017 | 2025-06-02 03:51:24 | lighting | 2 | 121059 | 40 | 13.140 | 9213.0 |
| 1016 | 2025-06-01 02:49:38 | lighting | 1 | 82945 | 16 | 3.560 | 23299.2 |
| 1015 | 2025-06-01 01:42:27 | lighting | 3 | 146162 | 241 | 39.720 | 3679.8 |
| 1014 | 2025-06-01 00:09:29 | lighting | 1 | 82945 | 16 | 5.533 | 14991.0 |
| 1013 | 2025-05-31 21:58:45 | lighting | 2 | 121059 | 40 | 22.390 | 5406.8 |
| 1012 | 2025-05-30 20:27:36 | lighting | 1 | 82945 | 16 | 1.703 | 48705.2 |
| 1011 | 2025-05-27 06:34:13 | lighting | 1 | 82945 | 16 | 6.596 | 12575.0 |
| 1010 | 2025-05-24 00:07:35 | lighting | 1 | 82945 | 16 | 8.686 | 9549.3 |
| 1009 | 2025-05-23 20:57:18 | lighting | 3 | 146162 | 241 | 21.563 | 6778.4 |
| 1008 | 2025-05-20 00:51:46 | lighting | 2 | 121059 | 40 | 12.266 | 9869.5 |
| 1007 | 2025-05-10 12:52:05 | lighting | 1 | 82945 | 16 | 6.343 | 13076.6 |
| 1006 | 2025-05-06 21:39:56 | lighting | 3 | 146162 | 241 | 6.623 | 22068.9 |
| 1005 | 2025-05-06 14:31:46 | lighting | 3 | 146162 | 241 | 22.250 | 6569.1 |
| 1004 | 2025-04-30 12:17:47 | lighting | 3 | 146162 | 241 | 32.720 | 4467.1 |
| 1003 | 2025-04-30 00:38:04 | lighting | 1 | 82945 | 16 | 4.486 | 18489.7 |
| 1002 | 2025-04-29 21:29:58 | lighting | 1 | 82945 | 16 | 9.890 | 8386.8 |
| 1001 | 2025-04-28 12:04:24 | lighting | 3 | 146162 | 241 | 34.453 | 4242.4 |
| 1000 | 2025-04-28 02:32:33 | lighting | 3 | 146162 | 241 | 24.346 | 6003.5 |
| 999 | 2025-04-27 20:25:32 | lighting | 1 | 82945 | 16 | 4.830 | 17172.9 |
| 998 | 2025-04-27 01:06:47 | lighting | 3 | 146162 | 241 | 7.110 | 20557.2 |
| 997 | 2025-04-22 23:03:54 | lighting | 1 | 82945 | 16 | 3.673 | 22582.4 |
| 996 | 2025-04-22 12:01:45 | lighting | 1 | 82945 | 16 | 1.310 | 63316.8 |
| 995 | 2025-04-14 04:40:42 | lighting | 1 | 82945 | 16 | 8.080 | 10265.5 |
| 994 | 2025-04-09 12:15:19 | lighting | 1 | 82945 | 16 | 10.233 | 8105.6 |
| 993 | 2025-03-29 02:05:26 | lighting | 1 | 82945 | 16 | 4.906 | 16906.8 |
| 992 | 2025-03-27 14:12:10 | lighting | 3 | 146162 | 241 | 51.063 | 2862.4 |
| 991 | 2025-03-25 17:06:37 | lighting | 3 | 146162 | 241 | 22.453 | 6509.7 |
| 990 | 2025-03-23 19:19:43 | lighting | 3 | 146162 | 241 | 39.066 | 3741.4 |
| 989 | 2025-03-23 00:21:15 | lighting | 1 | 82945 | 16 | 6.330 | 13103.5 |
| 988 | 2025-03-22 21:53:54 | lighting | 1 | 82945 | 16 | 5.876 | 14115.9 |
| 987 | 2025-03-18 07:21:45 | lighting | 1 | 82945 | 16 | 9.783 | 8478.5 |
| 986 | 2025-03-13 18:02:43 | lighting | 1 | 82945 | 16 | 7.580 | 10942.6 |
| 985 | 2025-03-11 14:21:16 | lighting | 3 | 146162 | 241 | 26.673 | 5479.8 |
| 984 | 2025-03-11 07:18:13 | lighting | 3 | 146162 | 241 | 39.143 | 3734.1 |
| 983 | 2025-02-26 19:52:40 | lighting | 1 | 82945 | 16 | 5.436 | 15258.5 |
| 982 | 2025-02-24 03:04:18 | lighting | 1 | 82945 | 16 | 3.986 | 20809.1 |
| 981 | 2025-02-15 18:20:06 | lighting | 3 | 146162 | 241 | 42.270 | 3457.8 |
| 980 | 2025-02-15 10:22:20 | lighting | 1 | 82945 | 16 | 4.250 | 19516.5 |
| 979 | 2025-02-15 10:20:51 | lighting | 2 | 121059 | 40 | 24.033 | 5037.2 |
| 978 | 2025-02-10 06:43:47 | lighting | 3 | 146162 | 241 | 35.943 | 4066.5 |
| 977 | 2025-02-07 21:49:16 | lighting | 2 | 121059 | 40 | 15.343 | 7890.2 |
| 976 | 2025-02-07 20:51:00 | lighting | 3 | 146162 | 241 | 7.356 | 19869.8 |
| 975 | 2025-02-07 17:45:20 | lighting | 3 | 146162 | 241 | 35.566 | 4109.6 |
| 974 | 2025-02-02 21:55:11 | lighting | 1 | 82945 | 16 | 6.906 | 12010.6 |
| 973 | 2025-01-28 10:02:17 | lighting | 3 | 146162 | 241 | 6.203 | 23563.1 |
| 972 | 2025-01-26 19:43:12 | lighting | 1 | 82945 | 16 | 6.013 | 13794.3 |
| 971 | 2025-01-24 19:34:06 | lighting | 1 | 82945 | 16 | 4.966 | 16702.6 |
| 970 | 2025-01-24 19:26:29 | lighting | 2 | 121059 | 40 | 3.513 | 34460.3 |
| 969 | 2025-01-16 16:17:41 | lighting | 2 | 121059 | 40 | 20.420 | 5928.5 |