History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"midge"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1298 | 2024-04-20 21:38:40 | midge | 1 | 28756 | 6 | 1.173 | 24514.9 |
1297 | 2024-04-06 05:53:24 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1296 | 2024-03-29 04:47:25 | midge | 2 | 53800 | 103 | 5.890 | 9134.1 |
1295 | 2024-03-28 19:12:13 | midge | 2 | 53800 | 103 | 3.796 | 14172.8 |
1294 | 2024-03-28 19:10:10 | midge | 1 | 28756 | 6 | 1.156 | 24875.4 |
1293 | 2024-03-18 07:16:58 | midge | 1 | 28756 | 6 | 0.533 | 53951.2 |
1292 | 2024-03-07 05:48:34 | midge | 2 | 53800 | 103 | 2.970 | 18114.5 |
1291 | 2024-03-07 02:25:39 | midge | 1 | 28756 | 6 | 0.593 | 48492.4 |
1290 | 2024-02-27 14:31:28 | midge | 2 | 53800 | 103 | 1.486 | 36204.6 |
1289 | 2024-02-26 10:27:56 | midge | 2 | 53800 | 103 | 1.686 | 31909.8 |
1288 | 2024-02-26 10:27:54 | midge | 1 | 28756 | 6 | 1.063 | 27051.7 |
1287 | 2024-02-14 17:34:48 | midge | 1 | 28756 | 6 | 1.766 | 16283.1 |
1286 | 2024-02-03 20:47:11 | midge | 1 | 28756 | 6 | 0.483 | 59536.2 |
1285 | 2024-01-27 09:07:17 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1284 | 2024-01-14 01:27:10 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1283 | 2024-01-11 20:51:05 | midge | 1 | 28756 | 6 | 0.533 | 53951.2 |
1282 | 2023-12-14 07:46:14 | midge | 1 | 28756 | 6 | 0.486 | 59168.7 |
1281 | 2023-11-22 12:01:33 | midge | 1 | 28756 | 6 | 0.440 | 65354.5 |
1280 | 2023-11-21 12:54:19 | midge | 2 | 53800 | 103 | 1.436 | 37465.2 |
1279 | 2023-11-20 15:30:20 | midge | 2 | 53800 | 103 | 1.563 | 34421.0 |
1278 | 2023-11-18 04:07:53 | midge | 1 | 28756 | 6 | 0.440 | 65354.5 |
1277 | 2023-11-15 11:13:43 | midge | 2 | 53800 | 103 | 1.626 | 33087.3 |
1276 | 2023-11-09 10:31:33 | midge | 1 | 28756 | 6 | 0.610 | 47141.0 |
1275 | 2023-11-09 02:34:18 | midge | 1 | 28756 | 6 | 0.486 | 59168.7 |
1274 | 2023-11-08 07:02:10 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1273 | 2023-11-08 02:09:22 | midge | 1 | 28756 | 6 | 0.483 | 59536.2 |
1272 | 2023-11-08 02:02:09 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1271 | 2023-10-27 04:23:07 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1270 | 2023-10-19 16:48:02 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1269 | 2023-10-19 15:49:04 | midge | 2 | 53800 | 103 | 3.330 | 16156.2 |
1268 | 2023-10-19 10:31:00 | midge | 2 | 53800 | 103 | 1.596 | 33709.3 |
1267 | 2023-10-16 20:28:58 | midge | 1 | 28756 | 6 | 0.530 | 54256.6 |
1266 | 2023-10-12 01:29:37 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1265 | 2023-10-04 07:24:26 | midge | 1 | 28756 | 6 | 0.486 | 59168.7 |
1264 | 2023-09-23 15:12:59 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1263 | 2023-09-12 07:41:56 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1262 | 2023-08-30 02:25:18 | midge | 1 | 28756 | 6 | 0.423 | 67981.1 |
1261 | 2023-07-29 13:11:20 | midge | 1 | 28756 | 6 | 0.503 | 57169.0 |
1260 | 2023-05-31 12:50:27 | midge | 1 | 28756 | 6 | 0.466 | 61708.2 |
1259 | 2023-04-21 17:31:57 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1258 | 2023-04-10 05:55:35 | midge | 1 | 28756 | 6 | 0.466 | 61708.2 |
1257 | 2023-03-25 03:00:40 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1256 | 2023-03-18 10:36:34 | midge | 1 | 28756 | 6 | 0.420 | 68466.7 |
1255 | 2023-01-09 04:00:53 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1254 | 2022-12-21 05:48:45 | midge | 1 | 28756 | 6 | 0.483 | 59536.2 |
1253 | 2022-10-12 15:49:47 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1252 | 2022-08-17 14:09:16 | midge | 1 | 28756 | 6 | 0.420 | 68466.7 |
1251 | 2022-07-18 03:28:34 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1250 | 2022-07-11 14:52:27 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1249 | 2022-07-10 06:21:05 | midge | 1 | 28756 | 6 | 0.440 | 65354.5 |
1248 | 2022-06-25 11:25:07 | midge | 1 | 28756 | 6 | 0.423 | 67981.1 |
1247 | 2022-06-09 22:48:47 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1246 | 2022-06-01 16:45:28 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1245 | 2022-05-28 11:00:00 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1244 | 2022-05-26 04:39:04 | midge | 1 | 28756 | 6 | 0.466 | 61708.2 |
1243 | 2022-05-18 00:08:23 | midge | 1 | 28756 | 6 | 0.483 | 59536.2 |
1242 | 2022-04-13 14:51:05 | midge | 1 | 28756 | 6 | 0.580 | 49579.3 |
1241 | 2022-02-01 00:53:50 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1240 | 2021-12-25 22:21:48 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1239 | 2021-12-16 09:25:33 | midge | 1 | 28756 | 6 | 0.440 | 65354.5 |
1238 | 2021-11-22 22:25:42 | midge | 1 | 28756 | 6 | 0.440 | 65354.5 |
1237 | 2021-10-08 17:04:30 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1236 | 2021-09-15 12:31:00 | midge | 1 | 28756 | 6 | 0.983 | 29253.3 |
1235 | 2021-09-06 16:21:49 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1234 | 2021-08-22 05:53:59 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1233 | 2021-06-17 08:28:01 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1232 | 2021-06-15 13:58:54 | midge | 1 | 28756 | 6 | 0.530 | 54256.6 |
1231 | 2021-03-28 03:25:50 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1230 | 2021-03-09 00:13:33 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1229 | 2021-01-11 10:31:23 | midge | 1 | 28756 | 6 | 0.450 | 63902.2 |
1228 | 2020-11-17 09:08:50 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1227 | 2020-11-10 21:14:02 | midge | 1 | 28756 | 6 | 0.530 | 54256.6 |
1226 | 2020-10-29 16:05:40 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1225 | 2020-10-28 00:19:15 | midge | 1 | 28756 | 6 | 0.440 | 65354.5 |
1224 | 2020-10-23 15:20:18 | midge | 1 | 28756 | 6 | 0.466 | 61708.2 |
1223 | 2020-10-18 00:35:16 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1222 | 2020-08-25 00:48:34 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1221 | 2020-08-16 13:40:42 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1220 | 2020-08-13 13:32:31 | midge | 1 | 28756 | 6 | 0.580 | 49579.3 |
1219 | 2020-08-05 20:07:10 | midge | 1 | 28756 | 6 | 0.453 | 63479.0 |
1218 | 2020-06-12 16:19:16 | midge | 1 | 28756 | 6 | 0.436 | 65954.1 |
1217 | 2020-05-04 08:29:10 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1216 | 2020-03-25 23:09:09 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1215 | 2020-03-25 01:30:55 | midge | 1 | 28756 | 6 | 0.543 | 52957.6 |
1214 | 2020-03-22 21:44:54 | midge | 1 | 28756 | 6 | 0.470 | 61183.0 |
1213 | 2020-03-21 16:58:30 | midge | 1 | 28756 | 6 | 0.530 | 54256.6 |
1212 | 2020-03-21 14:44:23 | midge | 1 | 28756 | 6 | 0.483 | 59536.2 |
1211 | 2020-03-18 15:39:46 | midge | 1 | 28756 | 6 | 0.483 | 59536.2 |
1210 | 2020-02-25 03:03:28 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1209 | 2020-02-24 20:17:22 | midge | 1 | 28756 | 6 | 0.513 | 56054.6 |
1208 | 2020-02-22 20:37:42 | midge | 1 | 28756 | 6 | 0.513 | 56054.6 |
1207 | 2020-02-22 14:25:58 | midge | 1 | 28756 | 6 | 0.563 | 51076.4 |
1206 | 2020-02-13 00:49:54 | midge | 1 | 28756 | 6 | 0.560 | 51350.0 |
1205 | 2020-02-10 07:27:59 | midge | 1 | 28756 | 6 | 1.156 | 24875.4 |
1204 | 2020-02-02 03:10:45 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |
1203 | 2020-02-01 03:54:09 | midge | 1 | 28756 | 6 | 0.563 | 51076.4 |
1202 | 2020-01-30 22:40:03 | midge | 1 | 28756 | 6 | 0.546 | 52666.7 |
1201 | 2020-01-30 04:28:57 | midge | 1 | 28756 | 6 | 1.080 | 26625.9 |
1200 | 2020-01-26 15:35:04 | midge | 1 | 28756 | 6 | 1.126 | 25538.2 |
1199 | 2020-01-23 12:14:43 | midge | 1 | 28756 | 6 | 0.500 | 57512.0 |