History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pupil"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1500 | 2024-05-07 04:52:01 | pupil | 1 | 28756 | 3 | 1.220 | 23570.5 |
| 1499 | 2024-05-06 08:20:59 | pupil | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1498 | 2024-05-03 17:03:39 | pupil | 3 | 83667 | 683 | 4.423 | 18916.3 |
| 1497 | 2024-05-02 23:32:51 | pupil | 3 | 83667 | 683 | 12.593 | 6643.9 |
| 1496 | 2024-05-02 23:27:06 | pupil | 3 | 83667 | 683 | 10.326 | 8102.6 |
| 1495 | 2024-05-02 02:48:55 | pupil | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 1494 | 2024-05-01 11:02:57 | pupil | 3 | 83667 | 683 | 10.893 | 7680.8 |
| 1493 | 2024-05-01 07:56:31 | pupil | 3 | 83667 | 683 | 9.500 | 8807.1 |
| 1492 | 2024-05-01 07:13:07 | pupil | 1 | 28756 | 3 | 1.156 | 24875.4 |
| 1491 | 2024-04-30 19:16:08 | pupil | 3 | 83667 | 683 | 3.220 | 25983.5 |
| 1490 | 2024-04-30 11:32:43 | pupil | 1 | 28756 | 3 | 0.503 | 57169.0 |
| 1489 | 2024-04-30 07:46:22 | pupil | 3 | 83667 | 683 | 4.596 | 18204.3 |
| 1488 | 2024-04-30 00:50:01 | pupil | 1 | 28756 | 3 | 1.076 | 26724.9 |
| 1487 | 2024-04-29 20:08:48 | pupil | 3 | 83667 | 683 | 4.203 | 19906.5 |
| 1486 | 2024-04-29 07:57:17 | pupil | 3 | 83667 | 683 | 3.983 | 21006.0 |
| 1485 | 2024-04-28 07:50:22 | pupil | 3 | 83667 | 683 | 3.920 | 21343.6 |
| 1484 | 2024-04-27 16:03:14 | pupil | 3 | 83667 | 683 | 5.563 | 15039.9 |
| 1483 | 2024-04-27 05:07:33 | pupil | 3 | 83667 | 683 | 8.830 | 9475.3 |
| 1482 | 2024-04-26 17:45:05 | pupil | 3 | 83667 | 683 | 4.390 | 19058.5 |
| 1481 | 2024-04-26 05:17:34 | pupil | 3 | 83667 | 683 | 3.953 | 21165.4 |
| 1480 | 2024-04-25 14:04:49 | pupil | 3 | 83667 | 683 | 6.906 | 12115.1 |
| 1479 | 2024-04-24 13:54:43 | pupil | 3 | 83667 | 683 | 5.703 | 14670.7 |
| 1478 | 2024-04-23 14:03:44 | pupil | 3 | 83667 | 683 | 4.500 | 18592.7 |
| 1477 | 2024-04-23 10:57:37 | pupil | 3 | 83667 | 683 | 6.623 | 12632.8 |
| 1476 | 2024-04-22 15:01:19 | pupil | 3 | 83667 | 683 | 5.500 | 15212.2 |
| 1475 | 2024-04-22 05:47:57 | pupil | 3 | 83667 | 683 | 4.720 | 17726.1 |
| 1474 | 2024-04-21 14:58:02 | pupil | 3 | 83667 | 683 | 11.846 | 7062.9 |
| 1473 | 2024-04-21 05:44:20 | pupil | 3 | 83667 | 683 | 10.436 | 8017.2 |
| 1472 | 2024-04-20 21:30:53 | pupil | 3 | 83667 | 683 | 3.423 | 24442.6 |
| 1471 | 2024-04-20 14:59:50 | pupil | 3 | 83667 | 683 | 10.533 | 7943.3 |
| 1470 | 2024-04-20 08:28:22 | pupil | 3 | 83667 | 683 | 3.656 | 22884.8 |
| 1469 | 2024-04-19 22:19:34 | pupil | 3 | 83667 | 683 | 4.813 | 17383.5 |
| 1468 | 2024-04-19 18:22:46 | pupil | 3 | 83667 | 683 | 7.750 | 10795.7 |
| 1467 | 2024-04-19 08:22:52 | pupil | 3 | 83667 | 683 | 3.376 | 24782.9 |
| 1466 | 2024-04-18 22:59:07 | pupil | 3 | 83667 | 683 | 4.576 | 18283.9 |
| 1465 | 2024-04-18 18:18:12 | pupil | 3 | 83667 | 683 | 9.076 | 9218.5 |
| 1464 | 2024-04-18 11:30:01 | pupil | 3 | 83667 | 683 | 10.796 | 7749.8 |
| 1463 | 2024-04-17 22:17:52 | pupil | 3 | 83667 | 683 | 5.763 | 14518.0 |
| 1462 | 2024-04-17 12:27:24 | pupil | 3 | 83667 | 683 | 3.486 | 24000.9 |
| 1461 | 2024-04-16 22:22:26 | pupil | 3 | 83667 | 683 | 10.656 | 7851.6 |
| 1460 | 2024-04-15 22:10:11 | pupil | 3 | 83667 | 683 | 3.860 | 21675.4 |
| 1459 | 2024-04-14 22:12:08 | pupil | 3 | 83667 | 683 | 10.436 | 8017.2 |
| 1458 | 2024-04-13 22:21:11 | pupil | 3 | 83667 | 683 | 10.126 | 8262.6 |
| 1457 | 2024-04-13 13:16:49 | pupil | 3 | 83667 | 683 | 5.626 | 14871.5 |
| 1456 | 2024-04-12 23:18:10 | pupil | 3 | 83667 | 683 | 4.096 | 20426.5 |
| 1455 | 2024-04-12 19:30:46 | pupil | 3 | 83667 | 683 | 4.546 | 18404.5 |
| 1454 | 2024-04-12 14:03:04 | pupil | 3 | 83667 | 683 | 6.203 | 13488.2 |
| 1453 | 2024-04-11 21:36:26 | pupil | 3 | 83667 | 683 | 4.513 | 18539.1 |
| 1452 | 2024-04-11 21:23:25 | pupil | 3 | 83667 | 683 | 4.420 | 18929.2 |
| 1451 | 2024-04-11 14:25:15 | pupil | 3 | 83667 | 683 | 4.656 | 17969.7 |
| 1450 | 2024-04-10 17:57:36 | pupil | 3 | 83667 | 683 | 6.626 | 12627.1 |
| 1449 | 2024-04-10 14:14:49 | pupil | 3 | 83667 | 683 | 3.406 | 24564.6 |
| 1448 | 2024-04-10 04:40:29 | pupil | 3 | 83667 | 683 | 5.970 | 14014.6 |
| 1447 | 2024-04-09 19:10:49 | pupil | 3 | 83667 | 683 | 9.436 | 8866.8 |
| 1446 | 2024-04-09 17:13:55 | pupil | 3 | 83667 | 683 | 4.533 | 18457.3 |
| 1445 | 2024-04-09 10:36:46 | pupil | 2 | 53800 | 42 | 1.610 | 33416.1 |
| 1444 | 2024-04-09 10:36:45 | pupil | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1443 | 2024-04-09 10:36:26 | pupil | 3 | 83667 | 683 | 3.420 | 24464.0 |
| 1442 | 2024-04-08 18:19:30 | pupil | 3 | 83667 | 683 | 5.156 | 16227.1 |
| 1441 | 2024-04-08 08:25:32 | pupil | 3 | 83667 | 683 | 9.813 | 8526.1 |
| 1440 | 2024-04-08 03:46:21 | pupil | 3 | 83667 | 683 | 3.953 | 21165.4 |
| 1439 | 2024-04-07 20:54:43 | pupil | 3 | 83667 | 683 | 4.500 | 18592.7 |
| 1438 | 2024-04-07 09:34:40 | pupil | 3 | 83667 | 683 | 13.580 | 6161.0 |
| 1437 | 2024-04-06 21:01:43 | pupil | 3 | 83667 | 683 | 6.546 | 12781.4 |
| 1436 | 2024-04-06 09:01:50 | pupil | 3 | 83667 | 683 | 9.330 | 8967.5 |
| 1435 | 2024-04-06 05:46:17 | pupil | 1 | 28756 | 3 | 1.046 | 27491.4 |
| 1434 | 2024-04-05 19:25:17 | pupil | 3 | 83667 | 683 | 5.936 | 14094.8 |
| 1433 | 2024-04-05 00:28:19 | pupil | 3 | 83667 | 683 | 3.236 | 25855.1 |
| 1432 | 2024-04-04 03:19:56 | pupil | 3 | 83667 | 683 | 6.986 | 11976.4 |
| 1431 | 2024-04-03 06:55:43 | pupil | 3 | 83667 | 683 | 3.716 | 22515.3 |
| 1430 | 2024-04-02 13:11:29 | pupil | 3 | 83667 | 683 | 3.330 | 25125.2 |
| 1429 | 2024-04-01 13:14:56 | pupil | 3 | 83667 | 683 | 4.376 | 19119.5 |
| 1428 | 2024-04-01 03:06:54 | pupil | 3 | 83667 | 683 | 12.220 | 6846.7 |
| 1427 | 2024-03-31 18:31:10 | pupil | 2 | 53800 | 42 | 1.546 | 34799.5 |
| 1426 | 2024-03-31 18:30:22 | pupil | 3 | 83667 | 683 | 8.936 | 9362.9 |
| 1425 | 2024-03-31 13:45:24 | pupil | 3 | 83667 | 683 | 12.126 | 6899.8 |
| 1424 | 2024-03-31 06:36:32 | pupil | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1423 | 2024-03-29 08:50:08 | pupil | 2 | 53800 | 42 | 1.856 | 28987.1 |
| 1422 | 2024-03-29 08:45:52 | pupil | 1 | 28756 | 3 | 0.750 | 38341.3 |
| 1421 | 2024-03-28 10:04:31 | pupil | 3 | 83667 | 683 | 7.563 | 11062.7 |
| 1420 | 2024-03-27 17:19:01 | pupil | 3 | 83667 | 683 | 4.436 | 18860.9 |
| 1419 | 2024-03-27 09:36:43 | pupil | 3 | 83667 | 683 | 3.576 | 23396.8 |
| 1418 | 2024-03-26 11:29:52 | pupil | 3 | 83667 | 683 | 3.766 | 22216.4 |
| 1417 | 2024-03-25 22:16:25 | pupil | 3 | 83667 | 683 | 3.796 | 22040.8 |
| 1416 | 2024-03-25 05:44:38 | pupil | 3 | 83667 | 683 | 3.406 | 24564.6 |
| 1415 | 2024-03-23 21:12:48 | pupil | 3 | 83667 | 683 | 3.203 | 26121.4 |
| 1414 | 2024-03-23 10:41:31 | pupil | 3 | 83667 | 683 | 4.780 | 17503.6 |
| 1413 | 2024-03-22 21:33:29 | pupil | 3 | 83667 | 683 | 4.923 | 16995.1 |
| 1412 | 2024-03-20 01:59:56 | pupil | 3 | 83667 | 683 | 4.000 | 20916.8 |
| 1411 | 2024-03-19 07:19:51 | pupil | 3 | 83667 | 683 | 5.436 | 15391.3 |
| 1410 | 2024-03-18 15:33:48 | pupil | 3 | 83667 | 683 | 15.780 | 5302.1 |
| 1409 | 2024-03-18 07:16:30 | pupil | 3 | 83667 | 683 | 3.983 | 21006.0 |
| 1408 | 2024-03-17 00:17:09 | pupil | 3 | 83667 | 683 | 3.220 | 25983.5 |
| 1407 | 2024-03-16 14:26:26 | pupil | 3 | 83667 | 683 | 5.390 | 15522.6 |
| 1406 | 2024-03-16 00:39:44 | pupil | 3 | 83667 | 683 | 5.780 | 14475.3 |
| 1405 | 2024-03-15 01:18:26 | pupil | 3 | 83667 | 683 | 8.343 | 10028.4 |
| 1404 | 2024-03-14 02:34:41 | pupil | 3 | 83667 | 683 | 4.576 | 18283.9 |
| 1403 | 2024-03-13 01:38:43 | pupil | 3 | 83667 | 683 | 8.940 | 9358.7 |
| 1402 | 2024-03-10 17:56:26 | pupil | 3 | 83667 | 683 | 4.330 | 19322.6 |
| 1401 | 2024-03-08 19:00:55 | pupil | 3 | 83667 | 683 | 9.220 | 9074.5 |