History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1247 | 2024-04-27 16:30:55 | canes | 1 | 28756 | 33 | 0.796 | 36125.6 |
1246 | 2024-04-07 11:33:24 | canes | 1 | 28756 | 33 | 1.153 | 24940.2 |
1245 | 2024-04-03 06:46:53 | canes | 1 | 28756 | 33 | 1.173 | 24514.9 |
1244 | 2024-03-31 03:17:20 | canes | 1 | 28756 | 33 | 1.106 | 26000.0 |
1243 | 2024-03-27 04:00:37 | canes | 1 | 28756 | 33 | 0.533 | 53951.2 |
1242 | 2024-03-27 01:54:51 | canes | 1 | 28756 | 33 | 0.580 | 49579.3 |
1241 | 2024-03-04 01:15:51 | canes | 2 | 53800 | 540 | 1.780 | 30224.7 |
1240 | 2024-03-04 01:15:47 | canes | 1 | 28756 | 33 | 0.533 | 53951.2 |
1239 | 2024-02-25 18:14:43 | canes | 1 | 28756 | 33 | 0.546 | 52666.7 |
1238 | 2024-02-02 20:23:07 | canes | 1 | 28756 | 33 | 0.513 | 56054.6 |
1237 | 2024-01-31 18:38:49 | canes | 2 | 53800 | 540 | 1.483 | 36277.8 |
1236 | 2024-01-20 05:45:09 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1235 | 2024-01-18 02:19:19 | canes | 2 | 53800 | 540 | 1.436 | 37465.2 |
1234 | 2024-01-17 23:27:26 | canes | 1 | 28756 | 33 | 0.546 | 52666.7 |
1233 | 2023-12-30 11:40:03 | canes | 2 | 53800 | 540 | 1.690 | 31834.3 |
1232 | 2023-12-14 22:16:15 | canes | 1 | 28756 | 33 | 0.516 | 55728.7 |
1231 | 2023-12-14 22:01:50 | canes | 2 | 53800 | 540 | 1.580 | 34050.6 |
1230 | 2023-12-12 09:22:08 | canes | 1 | 28756 | 33 | 0.533 | 53951.2 |
1229 | 2023-12-01 17:41:34 | canes | 1 | 28756 | 33 | 0.516 | 55728.7 |
1228 | 2023-11-25 20:39:12 | canes | 2 | 53800 | 540 | 1.470 | 36598.6 |
1227 | 2023-11-24 00:44:20 | canes | 2 | 53800 | 540 | 1.500 | 35866.7 |
1226 | 2023-11-15 09:52:10 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1225 | 2023-11-15 07:40:56 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1224 | 2023-11-14 01:56:30 | canes | 1 | 28756 | 33 | 0.906 | 31739.5 |
1223 | 2023-11-13 06:14:03 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1222 | 2023-11-09 03:52:51 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1221 | 2023-10-29 03:02:34 | canes | 2 | 53800 | 540 | 1.466 | 36698.5 |
1220 | 2023-10-27 00:48:18 | canes | 2 | 53800 | 540 | 3.720 | 14462.4 |
1219 | 2023-10-26 00:15:11 | canes | 1 | 28756 | 33 | 0.450 | 63902.2 |
1218 | 2023-10-25 22:47:53 | canes | 1 | 28756 | 33 | 0.440 | 65354.5 |
1217 | 2023-10-25 19:46:21 | canes | 2 | 53800 | 540 | 1.906 | 28226.7 |
1216 | 2023-10-22 01:23:47 | canes | 2 | 53800 | 540 | 1.626 | 33087.3 |
1215 | 2023-10-21 22:13:00 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1214 | 2023-10-17 00:19:46 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1213 | 2023-10-13 21:19:37 | canes | 1 | 28756 | 33 | 0.513 | 56054.6 |
1212 | 2023-10-05 03:18:22 | canes | 1 | 28756 | 33 | 0.516 | 55728.7 |
1211 | 2023-09-25 18:37:22 | canes | 1 | 28756 | 33 | 0.546 | 52666.7 |
1210 | 2023-09-15 04:19:19 | canes | 1 | 28756 | 33 | 0.436 | 65954.1 |
1209 | 2023-09-12 19:53:26 | canes | 1 | 28756 | 33 | 0.546 | 52666.7 |
1208 | 2023-09-01 18:44:54 | canes | 1 | 28756 | 33 | 0.923 | 31154.9 |
1207 | 2023-08-29 17:39:02 | canes | 1 | 28756 | 33 | 0.456 | 63061.4 |
1206 | 2023-08-26 19:15:58 | canes | 2 | 53800 | 540 | 1.750 | 30742.9 |
1205 | 2023-08-07 15:47:02 | canes | 2 | 53800 | 540 | 1.440 | 37361.1 |
1204 | 2023-07-28 04:03:37 | canes | 2 | 53800 | 540 | 1.483 | 36277.8 |
1203 | 2023-07-26 00:53:17 | canes | 2 | 53800 | 540 | 1.563 | 34421.0 |
1202 | 2023-07-24 00:19:43 | canes | 2 | 53800 | 540 | 1.686 | 31909.8 |
1201 | 2023-07-21 14:26:20 | canes | 2 | 53800 | 540 | 3.016 | 17838.2 |
1200 | 2023-07-19 23:08:05 | canes | 2 | 53800 | 540 | 1.610 | 33416.1 |
1199 | 2023-07-11 21:30:45 | canes | 2 | 53800 | 540 | 1.843 | 29191.5 |
1198 | 2023-07-10 07:28:19 | canes | 2 | 53800 | 540 | 1.716 | 31352.0 |
1197 | 2023-06-05 17:40:16 | canes | 2 | 53800 | 540 | 1.610 | 33416.1 |
1196 | 2023-06-04 09:12:58 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1195 | 2023-06-01 17:35:21 | canes | 2 | 53800 | 540 | 1.470 | 36598.6 |
1194 | 2023-05-26 05:36:11 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1193 | 2023-04-21 22:26:22 | canes | 2 | 53800 | 540 | 1.593 | 33772.8 |
1192 | 2023-03-31 12:25:43 | canes | 1 | 28756 | 33 | 0.516 | 55728.7 |
1191 | 2023-03-27 16:37:54 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1190 | 2023-02-23 13:03:21 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1189 | 2023-01-25 12:18:26 | canes | 2 | 53800 | 540 | 1.610 | 33416.1 |
1188 | 2023-01-11 10:47:03 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1187 | 2023-01-04 03:50:28 | canes | 2 | 53800 | 540 | 3.236 | 16625.5 |
1186 | 2022-12-26 18:43:08 | canes | 1 | 28756 | 33 | 0.436 | 65954.1 |
1185 | 2022-12-24 12:43:22 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1184 | 2022-11-20 22:40:57 | canes | 1 | 28756 | 33 | 0.456 | 63061.4 |
1183 | 2022-11-20 10:18:46 | canes | 2 | 53800 | 540 | 2.690 | 20000.0 |
1182 | 2022-11-08 12:39:26 | canes | 2 | 53800 | 540 | 1.593 | 33772.8 |
1181 | 2022-11-07 18:34:50 | canes | 2 | 53800 | 540 | 1.546 | 34799.5 |
1180 | 2022-11-07 08:02:36 | canes | 2 | 53800 | 540 | 1.656 | 32487.9 |
1179 | 2022-11-06 15:13:39 | canes | 2 | 53800 | 540 | 1.720 | 31279.1 |
1178 | 2022-11-05 22:23:15 | canes | 2 | 53800 | 540 | 1.576 | 34137.1 |
1177 | 2022-11-05 16:18:49 | canes | 2 | 53800 | 540 | 1.733 | 31044.4 |
1176 | 2022-11-04 19:10:03 | canes | 2 | 53800 | 540 | 1.406 | 38264.6 |
1175 | 2022-11-03 23:56:01 | canes | 2 | 53800 | 540 | 1.623 | 33148.5 |
1174 | 2022-10-20 13:51:41 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1173 | 2022-10-04 16:00:01 | canes | 2 | 53800 | 540 | 1.610 | 33416.1 |
1172 | 2022-09-23 13:01:25 | canes | 2 | 53800 | 540 | 1.733 | 31044.4 |
1171 | 2022-09-03 17:02:20 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1170 | 2022-09-02 21:11:05 | canes | 2 | 53800 | 540 | 1.466 | 36698.5 |
1169 | 2022-08-24 15:01:21 | canes | 2 | 53800 | 540 | 1.436 | 37465.2 |
1168 | 2022-08-17 00:43:41 | canes | 1 | 28756 | 33 | 0.470 | 61183.0 |
1167 | 2022-06-26 14:08:15 | canes | 2 | 53800 | 540 | 1.423 | 37807.4 |
1166 | 2022-06-11 09:25:18 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1165 | 2022-06-09 04:04:28 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1164 | 2022-06-08 06:00:27 | canes | 2 | 53800 | 540 | 1.420 | 37887.3 |
1163 | 2022-06-06 01:58:19 | canes | 2 | 53800 | 540 | 1.440 | 37361.1 |
1162 | 2022-05-11 10:38:41 | canes | 1 | 28756 | 33 | 0.733 | 39230.6 |
1161 | 2022-05-07 23:49:18 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1160 | 2022-02-16 20:13:52 | canes | 1 | 28756 | 33 | 0.513 | 56054.6 |
1159 | 2022-02-14 15:11:32 | canes | 1 | 28756 | 33 | 0.513 | 56054.6 |
1158 | 2022-02-06 19:17:41 | canes | 1 | 28756 | 33 | 0.453 | 63479.0 |
1157 | 2022-02-05 15:11:53 | canes | 1 | 28756 | 33 | 1.000 | 28756.0 |
1156 | 2022-02-04 16:14:57 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1155 | 2022-02-03 12:24:33 | canes | 1 | 28756 | 33 | 0.516 | 55728.7 |
1154 | 2022-02-03 03:41:42 | canes | 1 | 28756 | 33 | 0.530 | 54256.6 |
1153 | 2022-02-02 09:38:22 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1152 | 2022-02-01 11:09:14 | canes | 1 | 28756 | 33 | 0.530 | 54256.6 |
1151 | 2022-01-31 11:18:47 | canes | 1 | 28756 | 33 | 0.686 | 41918.4 |
1150 | 2022-01-30 17:25:05 | canes | 1 | 28756 | 33 | 0.530 | 54256.6 |
1149 | 2022-01-29 17:39:21 | canes | 1 | 28756 | 33 | 0.500 | 57512.0 |
1148 | 2022-01-29 15:10:58 | canes | 2 | 53800 | 540 | 1.733 | 31044.4 |