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 |
| 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 |
| 1400 | 2024-03-07 05:20:18 | pupil | 2 | 53800 | 42 | 3.033 | 17738.2 |
| 1399 | 2024-03-07 04:33:10 | pupil | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1398 | 2024-03-07 04:09:56 | pupil | 3 | 83667 | 683 | 5.516 | 15168.1 |
| 1397 | 2024-03-06 13:38:17 | pupil | 3 | 83667 | 683 | 6.530 | 12812.7 |
| 1396 | 2024-03-06 03:35:39 | pupil | 3 | 83667 | 683 | 12.033 | 6953.1 |
| 1395 | 2024-03-04 22:35:52 | pupil | 3 | 83667 | 683 | 5.063 | 16525.2 |
| 1394 | 2024-03-03 21:30:57 | pupil | 3 | 83667 | 683 | 3.266 | 25617.6 |
| 1393 | 2024-03-03 17:18:54 | pupil | 3 | 83667 | 683 | 8.813 | 9493.6 |
| 1392 | 2024-03-03 08:05:41 | pupil | 3 | 83667 | 683 | 12.843 | 6514.6 |
| 1391 | 2024-03-02 17:27:31 | pupil | 3 | 83667 | 683 | 3.733 | 22412.8 |
| 1390 | 2024-03-01 17:25:10 | pupil | 3 | 83667 | 683 | 4.173 | 20049.6 |
| 1389 | 2024-03-01 12:03:29 | pupil | 3 | 83667 | 683 | 6.906 | 12115.1 |
| 1388 | 2024-03-01 03:20:56 | pupil | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1387 | 2024-02-29 19:49:54 | pupil | 3 | 83667 | 683 | 3.970 | 21074.8 |
| 1386 | 2024-02-29 10:16:41 | pupil | 3 | 83667 | 683 | 3.656 | 22884.8 |
| 1385 | 2024-02-28 15:10:36 | pupil | 3 | 83667 | 683 | 9.093 | 9201.3 |
| 1384 | 2024-02-28 04:46:00 | pupil | 3 | 83667 | 683 | 7.203 | 11615.6 |
| 1383 | 2024-02-28 02:14:04 | pupil | 2 | 53800 | 42 | 3.266 | 16472.7 |
| 1382 | 2024-02-28 02:13:37 | pupil | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1381 | 2024-02-27 15:14:22 | pupil | 3 | 83667 | 683 | 4.000 | 20916.8 |
| 1380 | 2024-02-27 04:58:34 | pupil | 3 | 83667 | 683 | 4.376 | 19119.5 |
| 1379 | 2024-02-26 17:41:39 | pupil | 3 | 83667 | 683 | 3.766 | 22216.4 |
| 1378 | 2024-02-26 05:12:11 | pupil | 3 | 83667 | 683 | 4.780 | 17503.6 |
| 1377 | 2024-02-25 04:51:53 | pupil | 3 | 83667 | 683 | 3.873 | 21602.6 |
| 1376 | 2024-02-25 01:13:18 | pupil | 2 | 53800 | 42 | 1.373 | 39184.3 |
| 1375 | 2024-02-24 11:57:31 | pupil | 3 | 83667 | 683 | 3.233 | 25879.1 |
| 1374 | 2024-02-24 00:58:09 | pupil | 3 | 83667 | 683 | 8.830 | 9475.3 |
| 1373 | 2024-02-23 00:49:56 | pupil | 3 | 83667 | 683 | 8.203 | 10199.6 |
| 1372 | 2024-02-22 01:19:17 | pupil | 3 | 83667 | 683 | 3.906 | 21420.1 |
| 1371 | 2024-02-21 12:16:15 | pupil | 3 | 83667 | 683 | 7.593 | 11019.0 |
| 1370 | 2024-02-21 00:36:21 | pupil | 3 | 83667 | 683 | 11.283 | 7415.3 |
| 1369 | 2024-02-20 12:36:38 | pupil | 3 | 83667 | 683 | 9.050 | 9245.0 |
| 1368 | 2024-02-20 00:57:57 | pupil | 3 | 83667 | 683 | 5.796 | 14435.3 |
| 1367 | 2024-02-19 13:37:50 | pupil | 3 | 83667 | 683 | 4.106 | 20376.8 |