History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"event"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1491 | 2025-06-07 07:11:21 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1490 | 2025-06-06 10:09:20 | event | 1 | 28756 | 6 | 3.750 | 7668.3 |
1489 | 2025-06-04 05:00:10 | event | 1 | 28756 | 6 | 2.266 | 12690.2 |
1488 | 2025-06-01 20:58:14 | event | 3 | 83667 | 887 | 16.846 | 4966.6 |
1487 | 2025-05-29 18:01:18 | event | 1 | 28756 | 6 | 0.500 | 57512.0 |
1486 | 2025-05-27 22:59:28 | event | 1 | 28756 | 6 | 0.453 | 63479.0 |
1485 | 2025-05-27 02:49:13 | event | 1 | 28756 | 6 | 1.686 | 17055.8 |
1484 | 2025-05-26 17:21:38 | event | 1 | 28756 | 6 | 2.766 | 10396.2 |
1483 | 2025-05-16 04:42:22 | event | 2 | 53800 | 87 | 5.610 | 9590.0 |
1482 | 2025-05-14 09:25:35 | event | 2 | 53800 | 87 | 4.170 | 12901.7 |
1481 | 2025-05-12 20:53:30 | event | 3 | 83667 | 887 | 3.810 | 21959.8 |
1480 | 2025-05-12 12:03:27 | event | 2 | 53800 | 87 | 7.296 | 7373.9 |
1479 | 2025-05-12 00:56:04 | event | 3 | 83667 | 887 | 14.313 | 5845.5 |
1478 | 2025-05-11 09:22:04 | event | 3 | 83667 | 887 | 4.186 | 19987.3 |
1477 | 2025-05-10 13:20:10 | event | 1 | 28756 | 6 | 0.546 | 52666.7 |
1476 | 2025-05-04 14:07:51 | event | 1 | 28756 | 6 | 1.436 | 20025.1 |
1475 | 2025-05-03 04:10:51 | event | 1 | 28756 | 6 | 1.486 | 19351.3 |
1474 | 2025-05-02 12:22:31 | event | 1 | 28756 | 6 | 3.016 | 9534.5 |
1473 | 2025-04-20 04:42:42 | event | 1 | 28756 | 6 | 1.780 | 16155.1 |
1472 | 2025-04-13 20:29:27 | event | 1 | 28756 | 6 | 2.436 | 11804.6 |
1471 | 2025-04-13 17:55:49 | event | 1 | 28756 | 6 | 0.440 | 65354.5 |
1470 | 2025-04-09 11:07:42 | event | 2 | 53800 | 87 | 4.673 | 11512.9 |
1469 | 2025-04-09 09:37:46 | event | 1 | 28756 | 6 | 1.750 | 16432.0 |
1468 | 2025-04-09 00:54:46 | event | 3 | 83667 | 887 | 19.440 | 4303.9 |
1467 | 2025-04-08 09:10:24 | event | 3 | 83667 | 887 | 14.123 | 5924.2 |
1466 | 2025-04-08 03:18:26 | event | 3 | 83667 | 887 | 12.876 | 6497.9 |
1465 | 2025-04-08 00:30:53 | event | 3 | 83667 | 887 | 18.970 | 4410.5 |
1464 | 2025-04-06 09:01:16 | event | 2 | 53800 | 87 | 9.156 | 5875.9 |
1463 | 2025-04-06 04:29:14 | event | 3 | 83667 | 887 | 17.766 | 4709.4 |
1462 | 2025-04-05 09:44:46 | event | 1 | 28756 | 6 | 0.440 | 65354.5 |
1461 | 2025-04-02 11:44:15 | event | 1 | 28756 | 6 | 2.326 | 12362.9 |
1460 | 2025-04-02 04:19:16 | event | 1 | 28756 | 6 | 3.280 | 8767.1 |
1459 | 2025-03-31 09:10:47 | event | 1 | 28756 | 6 | 2.420 | 11882.6 |
1458 | 2025-03-28 08:08:10 | event | 1 | 28756 | 6 | 1.016 | 28303.1 |
1457 | 2025-03-20 07:24:22 | event | 3 | 83667 | 887 | 19.750 | 4236.3 |
1456 | 2025-03-20 06:46:19 | event | 2 | 53800 | 87 | 5.940 | 9057.2 |
1455 | 2025-03-19 06:22:06 | event | 1 | 28756 | 6 | 0.420 | 68466.7 |
1454 | 2025-03-16 00:52:47 | event | 1 | 28756 | 6 | 2.140 | 13437.4 |
1453 | 2025-03-10 23:39:29 | event | 1 | 28756 | 6 | 1.580 | 18200.0 |
1452 | 2025-03-09 21:13:37 | event | 1 | 28756 | 6 | 2.346 | 12257.5 |
1451 | 2025-03-05 19:44:38 | event | 2 | 53800 | 87 | 7.890 | 6818.8 |
1450 | 2025-03-05 19:42:35 | event | 1 | 28756 | 6 | 0.483 | 59536.2 |
1449 | 2025-03-05 11:17:13 | event | 3 | 83667 | 887 | 13.190 | 6343.2 |
1448 | 2025-03-03 14:33:29 | event | 3 | 83667 | 887 | 18.893 | 4428.5 |
1447 | 2025-03-02 06:32:21 | event | 1 | 28756 | 6 | 1.343 | 21411.8 |
1446 | 2025-03-02 04:59:27 | event | 3 | 83667 | 887 | 20.766 | 4029.0 |
1445 | 2025-03-01 03:53:48 | event | 3 | 83667 | 887 | 19.406 | 4311.4 |
1444 | 2025-02-28 17:55:12 | event | 3 | 83667 | 887 | 14.110 | 5929.6 |
1443 | 2025-02-28 17:55:12 | event | 2 | 53800 | 87 | 7.780 | 6915.2 |
1442 | 2025-02-28 17:54:29 | event | 1 | 28756 | 6 | 3.486 | 8249.0 |
1441 | 2025-02-27 21:03:40 | event | 1 | 28756 | 6 | 3.673 | 7829.0 |
1440 | 2025-02-25 02:01:43 | event | 1 | 28756 | 6 | 2.376 | 12102.7 |
1439 | 2025-02-15 07:02:35 | event | 1 | 28756 | 6 | 2.373 | 12118.0 |
1438 | 2025-02-15 06:13:51 | event | 1 | 28756 | 6 | 3.733 | 7703.2 |
1437 | 2025-02-06 22:28:21 | event | 2 | 53800 | 87 | 7.716 | 6972.5 |
1436 | 2025-02-06 11:45:53 | event | 2 | 53800 | 87 | 6.690 | 8041.9 |
1435 | 2025-02-06 11:41:55 | event | 1 | 28756 | 6 | 0.453 | 63479.0 |
1434 | 2025-02-06 03:27:27 | event | 1 | 28756 | 6 | 1.390 | 20687.8 |
1433 | 2025-02-01 01:20:37 | event | 1 | 28756 | 6 | 0.440 | 65354.5 |
1432 | 2025-01-29 14:35:14 | event | 3 | 83667 | 887 | 15.686 | 5333.9 |
1431 | 2025-01-29 14:35:17 | event | 2 | 53800 | 87 | 7.860 | 6844.8 |
1430 | 2025-01-29 14:32:05 | event | 1 | 28756 | 6 | 1.060 | 27128.3 |
1429 | 2025-01-28 05:56:31 | event | 2 | 53800 | 87 | 3.860 | 13937.8 |
1428 | 2025-01-27 21:54:37 | event | 1 | 28756 | 6 | 1.563 | 18398.0 |
1427 | 2025-01-26 18:15:56 | event | 3 | 83667 | 887 | 18.910 | 4424.5 |
1426 | 2025-01-26 13:50:56 | event | 3 | 83667 | 887 | 10.843 | 7716.2 |
1425 | 2025-01-05 17:42:19 | event | 3 | 83667 | 887 | 5.813 | 14393.1 |
1424 | 2025-01-02 17:35:24 | event | 3 | 83667 | 887 | 20.580 | 4065.5 |
1423 | 2025-01-01 18:49:38 | event | 2 | 53800 | 87 | 4.000 | 13450.0 |
1422 | 2025-01-01 18:04:32 | event | 1 | 28756 | 6 | 0.423 | 67981.1 |
1421 | 2024-12-31 01:12:10 | event | 3 | 83667 | 887 | 27.530 | 3039.1 |
1420 | 2024-12-30 18:59:23 | event | 2 | 53800 | 87 | 7.533 | 7141.9 |
1419 | 2024-12-30 12:18:56 | event | 3 | 83667 | 887 | 23.843 | 3509.1 |
1418 | 2024-12-30 11:32:22 | event | 3 | 83667 | 887 | 22.203 | 3768.3 |
1417 | 2024-12-30 11:32:18 | event | 2 | 53800 | 87 | 3.796 | 14172.8 |
1416 | 2024-12-30 11:32:05 | event | 1 | 28756 | 6 | 2.873 | 10009.0 |
1415 | 2024-12-28 04:09:25 | event | 1 | 28756 | 6 | 2.720 | 10572.1 |
1414 | 2024-12-25 19:13:27 | event | 3 | 83667 | 887 | 13.076 | 6398.5 |
1413 | 2024-12-25 02:34:39 | event | 3 | 83667 | 887 | 18.373 | 4553.8 |
1412 | 2024-12-01 01:06:15 | event | 2 | 53800 | 87 | 8.033 | 6697.4 |
1411 | 2024-12-01 01:04:54 | event | 1 | 28756 | 6 | 0.906 | 31739.5 |
1410 | 2024-11-30 19:54:01 | event | 3 | 83667 | 887 | 20.363 | 4108.8 |
1409 | 2024-11-30 19:50:54 | event | 3 | 83667 | 887 | 32.596 | 2566.8 |
1408 | 2024-11-30 09:57:38 | event | 3 | 83667 | 887 | 4.530 | 18469.5 |
1407 | 2024-11-30 09:57:37 | event | 2 | 53800 | 87 | 1.626 | 33087.3 |
1406 | 2024-11-30 09:57:36 | event | 1 | 28756 | 6 | 0.513 | 56054.6 |
1405 | 2024-11-24 23:56:55 | event | 3 | 83667 | 887 | 8.813 | 9493.6 |
1404 | 2024-11-21 21:36:53 | event | 3 | 83667 | 887 | 28.780 | 2907.1 |
1403 | 2024-11-20 22:01:26 | event | 1 | 28756 | 6 | 1.940 | 14822.7 |
1402 | 2024-11-17 16:16:59 | event | 1 | 28756 | 6 | 2.406 | 11951.8 |
1401 | 2024-11-06 20:05:58 | event | 1 | 28756 | 6 | 3.516 | 8178.6 |
1400 | 2024-11-04 04:19:51 | event | 2 | 53800 | 87 | 4.843 | 11108.8 |
1399 | 2024-11-04 02:17:21 | event | 3 | 83667 | 887 | 8.123 | 10300.0 |
1398 | 2024-10-31 20:45:43 | event | 1 | 28756 | 6 | 0.483 | 59536.2 |
1397 | 2024-10-31 20:45:40 | event | 2 | 53800 | 87 | 1.563 | 34421.0 |
1396 | 2024-10-31 20:45:29 | event | 3 | 83667 | 887 | 4.313 | 19398.8 |
1395 | 2024-10-31 19:12:24 | event | 3 | 83667 | 887 | 18.516 | 4518.6 |
1394 | 2024-10-31 10:43:59 | event | 3 | 83667 | 887 | 18.373 | 4553.8 |
1393 | 2024-10-31 10:43:57 | event | 2 | 53800 | 87 | 8.220 | 6545.0 |
1392 | 2024-10-31 10:43:09 | event | 1 | 28756 | 6 | 2.610 | 11017.6 |