History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"first"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1436 | 2024-12-27 00:40:40 | first | 1 | 28756 | 4 | 1.563 | 18398.0 |
| 1435 | 2024-12-25 09:13:49 | first | 1 | 28756 | 4 | 2.076 | 13851.6 |
| 1434 | 2024-12-12 20:08:19 | first | 3 | 83667 | 1220 | 23.033 | 3632.5 |
| 1433 | 2024-12-11 00:39:11 | first | 3 | 83667 | 1220 | 19.220 | 4353.1 |
| 1432 | 2024-12-11 00:39:07 | first | 2 | 53800 | 98 | 11.796 | 4560.9 |
| 1431 | 2024-12-11 00:25:54 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1430 | 2024-12-07 07:27:15 | first | 1 | 28756 | 4 | 2.500 | 11502.4 |
| 1429 | 2024-12-05 16:40:23 | first | 1 | 28756 | 4 | 1.440 | 19969.4 |
| 1428 | 2024-11-27 18:14:24 | first | 3 | 83667 | 1220 | 16.360 | 5114.1 |
| 1427 | 2024-11-27 00:13:30 | first | 3 | 83667 | 1220 | 27.580 | 3033.6 |
| 1426 | 2024-11-27 00:13:27 | first | 2 | 53800 | 98 | 11.640 | 4622.0 |
| 1425 | 2024-11-26 23:51:57 | first | 1 | 28756 | 4 | 0.440 | 65354.5 |
| 1424 | 2024-11-24 20:00:12 | first | 1 | 28756 | 4 | 1.970 | 14597.0 |
| 1423 | 2024-11-14 14:42:08 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1422 | 2024-11-11 21:39:47 | first | 2 | 53800 | 98 | 6.780 | 7935.1 |
| 1421 | 2024-11-10 07:44:35 | first | 2 | 53800 | 98 | 7.610 | 7069.6 |
| 1420 | 2024-11-09 08:37:08 | first | 3 | 83667 | 1220 | 10.626 | 7873.8 |
| 1419 | 2024-11-09 08:37:07 | first | 2 | 53800 | 98 | 11.953 | 4501.0 |
| 1418 | 2024-11-09 06:42:40 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1417 | 2024-11-07 05:05:37 | first | 1 | 28756 | 4 | 1.283 | 22413.1 |
| 1416 | 2024-10-29 12:52:40 | first | 3 | 83667 | 1220 | 23.343 | 3584.2 |
| 1415 | 2024-10-28 06:39:40 | first | 3 | 83667 | 1220 | 16.890 | 4953.6 |
| 1414 | 2024-10-27 22:08:15 | first | 3 | 83667 | 1220 | 14.906 | 5613.0 |
| 1413 | 2024-10-27 22:08:15 | first | 2 | 53800 | 98 | 8.093 | 6647.7 |
| 1412 | 2024-10-27 21:24:23 | first | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1411 | 2024-10-25 18:36:41 | first | 1 | 28756 | 4 | 1.280 | 22465.6 |
| 1410 | 2024-10-22 21:50:53 | first | 1 | 28756 | 4 | 1.093 | 26309.2 |
| 1409 | 2024-10-09 12:07:19 | first | 1 | 28756 | 4 | 0.440 | 65354.5 |
| 1408 | 2024-09-27 15:34:08 | first | 1 | 28756 | 4 | 4.123 | 6974.5 |
| 1407 | 2024-09-09 10:52:15 | first | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1406 | 2024-09-08 00:33:00 | first | 1 | 28756 | 4 | 4.873 | 5901.1 |
| 1405 | 2024-09-03 09:28:34 | first | 2 | 53800 | 98 | 11.470 | 4690.5 |
| 1404 | 2024-09-03 07:17:18 | first | 3 | 83667 | 1220 | 25.720 | 3253.0 |
| 1403 | 2024-09-02 15:45:11 | first | 3 | 83667 | 1220 | 35.003 | 2390.3 |
| 1402 | 2024-09-02 10:47:26 | first | 3 | 83667 | 1220 | 39.376 | 2124.8 |
| 1401 | 2024-09-02 10:46:49 | first | 2 | 53800 | 98 | 14.643 | 3674.1 |
| 1400 | 2024-09-02 09:26:43 | first | 3 | 83667 | 1220 | 26.580 | 3147.7 |
| 1399 | 2024-09-02 09:26:37 | first | 2 | 53800 | 98 | 5.766 | 9330.6 |
| 1398 | 2024-08-30 05:43:02 | first | 1 | 28756 | 4 | 1.826 | 15748.1 |
| 1397 | 2024-08-28 08:03:35 | first | 1 | 28756 | 4 | 5.203 | 5526.8 |
| 1396 | 2024-08-19 21:51:44 | first | 1 | 28756 | 4 | 2.220 | 12953.2 |
| 1395 | 2024-08-14 03:28:14 | first | 3 | 83667 | 1220 | 25.266 | 3311.4 |
| 1394 | 2024-08-14 03:28:19 | first | 2 | 53800 | 98 | 18.313 | 2937.8 |
| 1393 | 2024-08-14 03:09:35 | first | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 1392 | 2024-08-13 01:07:13 | first | 1 | 28756 | 4 | 3.453 | 8327.8 |
| 1391 | 2024-08-08 14:03:55 | first | 1 | 28756 | 4 | 2.970 | 9682.2 |
| 1390 | 2024-08-02 02:18:45 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1389 | 2024-07-29 10:59:41 | first | 2 | 53800 | 98 | 5.906 | 9109.4 |
| 1388 | 2024-07-29 06:50:39 | first | 2 | 53800 | 98 | 5.580 | 9641.6 |
| 1387 | 2024-07-29 06:22:37 | first | 1 | 28756 | 4 | 0.643 | 44721.6 |
| 1386 | 2024-07-29 04:26:16 | first | 3 | 83667 | 1220 | 18.893 | 4428.5 |
| 1385 | 2024-07-28 21:02:56 | first | 3 | 83667 | 1220 | 17.063 | 4903.4 |
| 1384 | 2024-07-28 15:10:41 | first | 3 | 83667 | 1220 | 16.376 | 5109.1 |
| 1383 | 2024-07-26 18:01:38 | first | 3 | 83667 | 1220 | 13.610 | 6147.5 |
| 1382 | 2024-07-26 10:55:55 | first | 3 | 83667 | 1220 | 14.686 | 5697.1 |
| 1381 | 2024-07-25 21:16:02 | first | 2 | 53800 | 98 | 3.186 | 16886.4 |
| 1380 | 2024-07-24 02:20:36 | first | 1 | 28756 | 4 | 0.576 | 49923.6 |
| 1379 | 2024-07-16 23:36:29 | first | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 1378 | 2024-07-10 05:10:13 | first | 1 | 28756 | 4 | 0.970 | 29645.4 |
| 1377 | 2024-07-09 21:23:18 | first | 1 | 28756 | 4 | 2.000 | 14378.0 |
| 1376 | 2024-07-06 11:41:46 | first | 1 | 28756 | 4 | 1.623 | 17717.8 |
| 1375 | 2024-07-01 10:24:47 | first | 1 | 28756 | 4 | 1.873 | 15352.9 |
| 1374 | 2024-06-30 19:36:09 | first | 1 | 28756 | 4 | 1.516 | 18968.3 |
| 1373 | 2024-06-29 04:41:57 | first | 2 | 53800 | 98 | 7.283 | 7387.1 |
| 1372 | 2024-06-29 04:36:08 | first | 1 | 28756 | 4 | 0.546 | 52666.7 |
| 1371 | 2024-06-29 00:53:38 | first | 3 | 83667 | 1220 | 9.936 | 8420.6 |
| 1370 | 2024-06-28 05:32:16 | first | 3 | 83667 | 1220 | 11.453 | 7305.2 |
| 1369 | 2024-06-13 00:48:11 | first | 1 | 28756 | 4 | 2.843 | 10114.7 |
| 1368 | 2024-06-08 04:18:23 | first | 1 | 28756 | 4 | 2.063 | 13938.9 |
| 1367 | 2024-06-08 03:35:58 | first | 2 | 53800 | 98 | 10.376 | 5185.0 |
| 1366 | 2024-06-07 12:19:31 | first | 2 | 53800 | 98 | 4.796 | 11217.7 |
| 1365 | 2024-06-05 12:42:32 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1364 | 2024-05-31 19:30:20 | first | 1 | 28756 | 4 | 0.546 | 52666.7 |
| 1363 | 2024-05-30 02:57:02 | first | 3 | 83667 | 1220 | 14.156 | 5910.4 |
| 1362 | 2024-05-30 00:31:58 | first | 3 | 83667 | 1220 | 8.360 | 10008.0 |
| 1361 | 2024-05-30 00:20:17 | first | 3 | 83667 | 1220 | 14.216 | 5885.4 |
| 1360 | 2024-05-29 22:33:55 | first | 1 | 28756 | 4 | 2.096 | 13719.5 |
| 1359 | 2024-05-20 13:17:05 | first | 1 | 28756 | 4 | 1.123 | 25606.4 |
| 1358 | 2024-05-08 23:27:16 | first | 1 | 28756 | 4 | 1.453 | 19790.8 |
| 1357 | 2024-05-06 07:56:35 | first | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 1356 | 2024-05-01 17:52:21 | first | 1 | 28756 | 4 | 0.593 | 48492.4 |
| 1355 | 2024-05-01 06:49:59 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1354 | 2024-04-29 21:42:05 | first | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 1353 | 2024-04-27 08:27:44 | first | 2 | 53800 | 98 | 2.390 | 22510.5 |
| 1352 | 2024-04-27 06:16:54 | first | 1 | 28756 | 4 | 0.563 | 51076.4 |
| 1351 | 2024-04-08 18:54:32 | first | 1 | 28756 | 4 | 0.953 | 30174.2 |
| 1350 | 2024-04-06 05:57:45 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1349 | 2024-04-02 18:51:38 | first | 2 | 53800 | 98 | 3.766 | 14285.7 |
| 1348 | 2024-04-01 17:36:37 | first | 2 | 53800 | 98 | 5.626 | 9562.7 |
| 1347 | 2024-03-31 15:33:03 | first | 2 | 53800 | 98 | 3.436 | 15657.7 |
| 1346 | 2024-03-31 15:33:02 | first | 3 | 83667 | 1220 | 4.703 | 17790.1 |
| 1345 | 2024-03-31 15:32:56 | first | 1 | 28756 | 4 | 1.093 | 26309.2 |
| 1344 | 2024-03-31 15:32:26 | first | 3 | 83667 | 1220 | 3.580 | 23370.7 |
| 1343 | 2024-03-31 15:32:25 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1342 | 2024-03-29 23:49:45 | first | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 1341 | 2024-03-09 00:26:27 | first | 1 | 28756 | 4 | 1.576 | 18246.2 |
| 1340 | 2024-03-07 04:10:03 | first | 1 | 28756 | 4 | 0.563 | 51076.4 |
| 1339 | 2024-03-05 07:47:08 | first | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 1338 | 2024-03-01 11:45:31 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1337 | 2024-02-29 18:03:45 | first | 2 | 53800 | 98 | 3.080 | 17467.5 |