History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"where"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1373 | 2024-04-17 10:31:59 | where | 1 | 28756 | 8 | 0.486 | 59168.7 |
1372 | 2024-04-17 07:26:41 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1371 | 2024-04-02 22:39:53 | where | 2 | 53800 | 105 | 3.530 | 15240.8 |
1370 | 2024-04-02 21:48:52 | where | 1 | 28756 | 8 | 0.530 | 54256.6 |
1369 | 2024-03-31 12:25:25 | where | 1 | 28756 | 8 | 0.530 | 54256.6 |
1368 | 2024-03-31 10:33:38 | where | 2 | 53800 | 105 | 4.093 | 13144.4 |
1367 | 2024-03-31 08:09:36 | where | 1 | 28756 | 8 | 0.893 | 32201.6 |
1366 | 2024-03-27 02:58:27 | where | 1 | 28756 | 8 | 1.140 | 25224.6 |
1365 | 2024-03-05 10:30:09 | where | 1 | 28756 | 8 | 0.516 | 55728.7 |
1364 | 2024-02-25 18:10:37 | where | 1 | 28756 | 8 | 0.830 | 34645.8 |
1363 | 2024-02-25 16:23:16 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1362 | 2024-01-26 13:18:43 | where | 1 | 28756 | 8 | 0.516 | 55728.7 |
1361 | 2024-01-04 21:19:41 | where | 2 | 53800 | 105 | 1.326 | 40573.2 |
1360 | 2023-12-22 20:21:42 | where | 1 | 28756 | 8 | 0.500 | 57512.0 |
1359 | 2023-12-09 21:01:11 | where | 2 | 53800 | 105 | 3.266 | 16472.7 |
1358 | 2023-11-11 03:43:11 | where | 2 | 53800 | 105 | 1.563 | 34421.0 |
1357 | 2023-11-08 11:42:57 | where | 1 | 28756 | 8 | 0.420 | 68466.7 |
1356 | 2023-11-08 02:45:39 | where | 1 | 28756 | 8 | 0.470 | 61183.0 |
1355 | 2023-11-07 09:34:04 | where | 1 | 28756 | 8 | 0.546 | 52666.7 |
1354 | 2023-11-06 15:57:06 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1353 | 2023-11-02 07:38:00 | where | 2 | 53800 | 105 | 1.830 | 29398.9 |
1352 | 2023-11-02 07:37:44 | where | 2 | 53800 | 105 | 1.826 | 29463.3 |
1351 | 2023-11-02 06:27:12 | where | 1 | 28756 | 8 | 0.546 | 52666.7 |
1350 | 2023-10-27 20:49:12 | where | 2 | 53800 | 105 | 1.486 | 36204.6 |
1349 | 2023-10-25 20:36:28 | where | 1 | 28756 | 8 | 0.500 | 57512.0 |
1348 | 2023-10-19 18:32:41 | where | 2 | 53800 | 105 | 1.453 | 37026.8 |
1347 | 2023-10-19 14:15:34 | where | 1 | 28756 | 8 | 0.470 | 61183.0 |
1346 | 2023-10-17 19:37:49 | where | 2 | 53800 | 105 | 1.580 | 34050.6 |
1345 | 2023-10-16 18:52:13 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1344 | 2023-10-13 22:08:48 | where | 2 | 53800 | 105 | 1.343 | 40059.6 |
1343 | 2023-10-11 06:38:27 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1342 | 2023-10-11 01:59:29 | where | 2 | 53800 | 105 | 1.296 | 41512.3 |
1341 | 2023-10-10 11:00:25 | where | 1 | 28756 | 8 | 0.486 | 59168.7 |
1340 | 2023-10-03 14:57:48 | where | 2 | 53800 | 105 | 1.483 | 36277.8 |
1339 | 2023-10-03 08:18:20 | where | 1 | 28756 | 8 | 0.420 | 68466.7 |
1338 | 2023-09-25 13:44:23 | where | 1 | 28756 | 8 | 0.516 | 55728.7 |
1337 | 2023-09-23 16:44:15 | where | 2 | 53800 | 105 | 1.483 | 36277.8 |
1336 | 2023-09-18 23:22:26 | where | 1 | 28756 | 8 | 0.563 | 51076.4 |
1335 | 2023-09-12 08:24:23 | where | 2 | 53800 | 105 | 1.376 | 39098.8 |
1334 | 2023-09-10 12:48:07 | where | 1 | 28756 | 8 | 0.406 | 70827.6 |
1333 | 2023-08-07 04:24:03 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1332 | 2023-07-23 10:08:36 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1331 | 2023-07-21 12:35:35 | where | 2 | 53800 | 105 | 1.313 | 40974.9 |
1330 | 2023-07-16 19:43:29 | where | 1 | 28756 | 8 | 0.466 | 61708.2 |
1329 | 2023-05-06 00:39:24 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1328 | 2023-04-02 21:26:50 | where | 2 | 53800 | 105 | 1.310 | 41068.7 |
1327 | 2023-03-14 17:08:40 | where | 1 | 28756 | 8 | 0.420 | 68466.7 |
1326 | 2023-03-12 12:11:44 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1325 | 2023-03-03 04:40:31 | where | 1 | 28756 | 8 | 0.420 | 68466.7 |
1324 | 2023-01-17 08:34:57 | where | 1 | 28756 | 8 | 0.406 | 70827.6 |
1323 | 2023-01-01 22:09:06 | where | 2 | 53800 | 105 | 1.453 | 37026.8 |
1322 | 2022-12-26 23:39:09 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1321 | 2022-11-24 18:33:52 | where | 1 | 28756 | 8 | 0.403 | 71354.8 |
1320 | 2022-09-19 20:24:10 | where | 1 | 28756 | 8 | 0.440 | 65354.5 |
1319 | 2022-09-18 15:09:03 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1318 | 2022-09-15 00:11:54 | where | 1 | 28756 | 8 | 0.466 | 61708.2 |
1317 | 2022-09-09 11:59:43 | where | 1 | 28756 | 8 | 0.440 | 65354.5 |
1316 | 2022-09-06 01:52:46 | where | 2 | 53800 | 105 | 1.313 | 40974.9 |
1315 | 2022-09-02 09:32:49 | where | 1 | 28756 | 8 | 0.530 | 54256.6 |
1314 | 2022-09-01 21:57:22 | where | 1 | 28756 | 8 | 0.486 | 59168.7 |
1313 | 2022-08-29 08:15:19 | where | 1 | 28756 | 8 | 0.500 | 57512.0 |
1312 | 2022-08-15 00:32:48 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1311 | 2022-08-14 05:45:20 | where | 1 | 28756 | 8 | 0.420 | 68466.7 |
1310 | 2022-08-07 05:28:16 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1309 | 2022-08-05 22:15:55 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1308 | 2022-07-25 12:55:36 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1307 | 2022-05-18 10:44:29 | where | 1 | 28756 | 8 | 0.470 | 61183.0 |
1306 | 2022-05-11 05:12:06 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1305 | 2022-04-21 04:30:55 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1304 | 2022-04-18 23:18:52 | where | 1 | 28756 | 8 | 0.486 | 59168.7 |
1303 | 2022-02-23 09:19:19 | where | 1 | 28756 | 8 | 0.453 | 63479.0 |
1302 | 2022-01-14 16:37:42 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1301 | 2021-12-02 06:40:40 | where | 1 | 28756 | 8 | 0.513 | 56054.6 |
1300 | 2021-11-16 18:26:51 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1299 | 2021-11-14 16:57:55 | where | 1 | 28756 | 8 | 0.500 | 57512.0 |
1298 | 2021-11-10 18:03:36 | where | 1 | 28756 | 8 | 0.530 | 54256.6 |
1297 | 2021-11-05 06:53:53 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1296 | 2021-09-26 03:44:38 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1295 | 2021-08-26 14:29:15 | where | 1 | 28756 | 8 | 0.420 | 68466.7 |
1294 | 2021-08-24 11:11:16 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1293 | 2021-08-12 16:57:24 | where | 1 | 28756 | 8 | 0.453 | 63479.0 |
1292 | 2021-08-07 01:13:29 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1291 | 2021-06-13 20:51:02 | where | 1 | 28756 | 8 | 0.486 | 59168.7 |
1290 | 2021-06-02 22:20:41 | where | 1 | 28756 | 8 | 0.453 | 63479.0 |
1289 | 2021-05-26 09:56:30 | where | 1 | 28756 | 8 | 0.483 | 59536.2 |
1288 | 2021-04-05 11:27:26 | where | 1 | 28756 | 8 | 0.466 | 61708.2 |
1287 | 2021-03-23 21:30:12 | where | 1 | 28756 | 8 | 0.500 | 57512.0 |
1286 | 2021-02-02 06:55:57 | where | 1 | 28756 | 8 | 0.440 | 65354.5 |
1285 | 2021-02-01 08:13:31 | where | 2 | 53800 | 105 | 1.313 | 40974.9 |
1284 | 2020-12-24 17:47:49 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1283 | 2020-11-01 01:04:33 | where | 1 | 28756 | 8 | 0.470 | 61183.0 |
1282 | 2020-10-20 00:41:11 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1281 | 2020-10-14 00:06:31 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1280 | 2020-10-05 21:13:43 | where | 1 | 28756 | 8 | 0.470 | 61183.0 |
1279 | 2020-08-28 02:08:56 | where | 1 | 28756 | 8 | 0.436 | 65954.1 |
1278 | 2020-08-24 11:51:30 | where | 2 | 53800 | 105 | 1.296 | 41512.3 |
1277 | 2020-08-24 00:13:28 | where | 1 | 28756 | 8 | 0.516 | 55728.7 |
1276 | 2020-07-29 00:33:02 | where | 1 | 28756 | 8 | 0.450 | 63902.2 |
1275 | 2020-05-21 03:15:15 | where | 1 | 28756 | 8 | 0.423 | 67981.1 |
1274 | 2020-04-20 14:18:24 | where | 1 | 28756 | 8 | 0.453 | 63479.0 |