History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yaffs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1516 | 2024-05-04 17:37:07 | yaffs | 3 | 83667 | 1183 | 13.343 | 6270.5 |
1515 | 2024-05-04 07:01:50 | yaffs | 3 | 83667 | 1183 | 4.466 | 18734.2 |
1514 | 2024-04-30 18:43:39 | yaffs | 1 | 28756 | 9 | 0.530 | 54256.6 |
1513 | 2024-04-29 16:44:41 | yaffs | 1 | 28756 | 9 | 0.530 | 54256.6 |
1512 | 2024-04-25 23:57:16 | yaffs | 3 | 83667 | 1183 | 7.856 | 10650.1 |
1511 | 2024-04-06 17:34:54 | yaffs | 3 | 83667 | 1183 | 10.940 | 7647.8 |
1510 | 2024-04-06 00:33:57 | yaffs | 3 | 83667 | 1183 | 4.610 | 18149.0 |
1509 | 2024-04-06 00:33:57 | yaffs | 2 | 53800 | 83 | 1.686 | 31909.8 |
1508 | 2024-04-06 00:33:55 | yaffs | 1 | 28756 | 9 | 0.500 | 57512.0 |
1507 | 2024-03-31 12:47:57 | yaffs | 3 | 83667 | 1183 | 12.220 | 6846.7 |
1506 | 2024-03-31 12:47:59 | yaffs | 2 | 53800 | 83 | 4.860 | 11070.0 |
1505 | 2024-03-31 12:43:12 | yaffs | 1 | 28756 | 9 | 1.063 | 27051.7 |
1504 | 2024-03-28 18:33:39 | yaffs | 1 | 28756 | 9 | 1.656 | 17364.7 |
1503 | 2024-03-04 06:28:36 | yaffs | 1 | 28756 | 9 | 0.470 | 61183.0 |
1502 | 2024-03-01 08:20:52 | yaffs | 1 | 28756 | 9 | 0.500 | 57512.0 |
1501 | 2024-02-27 09:58:30 | yaffs | 2 | 53800 | 83 | 1.966 | 27365.2 |
1500 | 2024-02-27 09:58:06 | yaffs | 3 | 83667 | 1183 | 4.063 | 20592.4 |
1499 | 2024-02-26 20:43:11 | yaffs | 3 | 83667 | 1183 | 4.206 | 19892.3 |
1498 | 2024-02-26 20:43:10 | yaffs | 2 | 53800 | 83 | 1.606 | 33499.4 |
1497 | 2024-02-26 20:43:02 | yaffs | 1 | 28756 | 9 | 0.436 | 65954.1 |
1496 | 2024-02-03 19:06:56 | yaffs | 1 | 28756 | 9 | 0.466 | 61708.2 |
1495 | 2024-02-03 01:31:23 | yaffs | 1 | 28756 | 9 | 0.450 | 63902.2 |
1494 | 2024-01-29 11:38:59 | yaffs | 1 | 28756 | 9 | 0.500 | 57512.0 |
1493 | 2024-01-26 03:02:01 | yaffs | 3 | 83667 | 1183 | 4.203 | 19906.5 |
1492 | 2024-01-24 06:20:35 | yaffs | 3 | 83667 | 1183 | 3.516 | 23796.1 |
1491 | 2024-01-14 11:48:25 | yaffs | 3 | 83667 | 1183 | 3.300 | 25353.6 |
1490 | 2024-01-12 16:03:29 | yaffs | 3 | 83667 | 1183 | 3.826 | 21868.0 |
1489 | 2024-01-10 03:44:15 | yaffs | 3 | 83667 | 1183 | 3.796 | 22040.8 |
1488 | 2024-01-09 15:05:17 | yaffs | 2 | 53800 | 83 | 1.360 | 39558.8 |
1487 | 2023-12-30 11:21:25 | yaffs | 1 | 28756 | 9 | 0.486 | 59168.7 |
1486 | 2023-12-26 01:14:13 | yaffs | 2 | 53800 | 83 | 1.313 | 40974.9 |
1485 | 2023-12-25 18:39:09 | yaffs | 2 | 53800 | 83 | 1.326 | 40573.2 |
1484 | 2023-12-13 01:38:52 | yaffs | 3 | 83667 | 1183 | 3.216 | 26015.9 |
1483 | 2023-12-07 03:54:42 | yaffs | 1 | 28756 | 9 | 0.983 | 29253.3 |
1482 | 2023-12-07 03:54:40 | yaffs | 1 | 28756 | 9 | 1.030 | 27918.4 |
1481 | 2023-12-07 03:41:07 | yaffs | 1 | 28756 | 9 | 0.516 | 55728.7 |
1480 | 2023-11-27 10:38:01 | yaffs | 1 | 28756 | 9 | 0.436 | 65954.1 |
1479 | 2023-11-25 16:07:26 | yaffs | 2 | 53800 | 83 | 1.673 | 32157.8 |
1478 | 2023-11-24 23:05:35 | yaffs | 1 | 28756 | 9 | 0.876 | 32826.5 |
1477 | 2023-11-15 09:28:14 | yaffs | 3 | 83667 | 1183 | 3.780 | 22134.1 |
1476 | 2023-11-12 18:12:51 | yaffs | 1 | 28756 | 9 | 0.423 | 67981.1 |
1475 | 2023-11-09 17:10:30 | yaffs | 3 | 83667 | 1183 | 3.530 | 23701.7 |
1474 | 2023-11-07 17:21:34 | yaffs | 3 | 83667 | 1183 | 3.716 | 22515.3 |
1473 | 2023-11-07 17:13:29 | yaffs | 3 | 83667 | 1183 | 3.233 | 25879.1 |
1472 | 2023-11-07 06:49:16 | yaffs | 3 | 83667 | 1183 | 4.140 | 20209.4 |
1471 | 2023-11-06 16:44:51 | yaffs | 3 | 83667 | 1183 | 3.640 | 22985.4 |
1470 | 2023-11-06 02:55:35 | yaffs | 3 | 83667 | 1183 | 3.856 | 21697.9 |
1469 | 2023-11-05 17:19:40 | yaffs | 3 | 83667 | 1183 | 3.423 | 24442.6 |
1468 | 2023-11-04 16:59:24 | yaffs | 3 | 83667 | 1183 | 3.923 | 21327.3 |
1467 | 2023-11-03 16:22:19 | yaffs | 3 | 83667 | 1183 | 3.390 | 24680.5 |
1466 | 2023-11-03 02:12:01 | yaffs | 3 | 83667 | 1183 | 4.063 | 20592.4 |
1465 | 2023-11-02 16:38:50 | yaffs | 3 | 83667 | 1183 | 5.046 | 16580.9 |
1464 | 2023-11-02 03:31:17 | yaffs | 3 | 83667 | 1183 | 3.530 | 23701.7 |
1463 | 2023-11-02 02:00:32 | yaffs | 3 | 83667 | 1183 | 4.486 | 18650.7 |
1462 | 2023-11-01 20:01:06 | yaffs | 3 | 83667 | 1183 | 3.266 | 25617.6 |
1461 | 2023-11-01 16:57:51 | yaffs | 3 | 83667 | 1183 | 3.220 | 25983.5 |
1460 | 2023-11-01 01:53:46 | yaffs | 3 | 83667 | 1183 | 3.640 | 22985.4 |
1459 | 2023-10-31 23:27:56 | yaffs | 1 | 28756 | 9 | 0.483 | 59536.2 |
1458 | 2023-10-31 20:10:37 | yaffs | 3 | 83667 | 1183 | 8.280 | 10104.7 |
1457 | 2023-10-31 17:02:36 | yaffs | 3 | 83667 | 1183 | 3.173 | 26368.4 |
1456 | 2023-10-31 01:48:47 | yaffs | 3 | 83667 | 1183 | 3.906 | 21420.1 |
1455 | 2023-10-30 16:33:42 | yaffs | 3 | 83667 | 1183 | 3.750 | 22311.2 |
1454 | 2023-10-30 01:32:33 | yaffs | 3 | 83667 | 1183 | 3.936 | 21256.9 |
1453 | 2023-10-29 01:36:42 | yaffs | 3 | 83667 | 1183 | 3.310 | 25277.0 |
1452 | 2023-10-28 16:31:01 | yaffs | 3 | 83667 | 1183 | 3.860 | 21675.4 |
1451 | 2023-10-28 01:31:06 | yaffs | 3 | 83667 | 1183 | 3.826 | 21868.0 |
1450 | 2023-10-27 15:56:26 | yaffs | 3 | 83667 | 1183 | 3.733 | 22412.8 |
1449 | 2023-10-27 01:21:42 | yaffs | 3 | 83667 | 1183 | 3.716 | 22515.3 |
1448 | 2023-10-27 01:17:48 | yaffs | 3 | 83667 | 1183 | 3.936 | 21256.9 |
1447 | 2023-10-26 17:01:50 | yaffs | 3 | 83667 | 1183 | 3.390 | 24680.5 |
1446 | 2023-10-26 04:19:57 | yaffs | 3 | 83667 | 1183 | 4.063 | 20592.4 |
1445 | 2023-10-26 01:59:45 | yaffs | 3 | 83667 | 1183 | 3.220 | 25983.5 |
1444 | 2023-10-25 19:40:37 | yaffs | 3 | 83667 | 1183 | 4.093 | 20441.5 |
1443 | 2023-10-25 02:40:33 | yaffs | 3 | 83667 | 1183 | 3.356 | 24930.6 |
1442 | 2023-10-24 19:39:59 | yaffs | 3 | 83667 | 1183 | 4.203 | 19906.5 |
1441 | 2023-10-24 09:46:27 | yaffs | 1 | 28756 | 9 | 0.466 | 61708.2 |
1440 | 2023-10-24 09:37:30 | yaffs | 3 | 83667 | 1183 | 5.076 | 16482.9 |
1439 | 2023-10-24 03:02:45 | yaffs | 3 | 83667 | 1183 | 3.843 | 21771.3 |
1438 | 2023-10-23 19:36:50 | yaffs | 3 | 83667 | 1183 | 3.846 | 21754.3 |
1437 | 2023-10-23 04:06:16 | yaffs | 3 | 83667 | 1183 | 4.220 | 19826.3 |
1436 | 2023-10-22 18:18:21 | yaffs | 3 | 83667 | 1183 | 7.420 | 11275.9 |
1435 | 2023-10-22 04:06:03 | yaffs | 3 | 83667 | 1183 | 3.826 | 21868.0 |
1434 | 2023-10-21 04:07:34 | yaffs | 3 | 83667 | 1183 | 3.893 | 21491.7 |
1433 | 2023-10-20 17:30:05 | yaffs | 3 | 83667 | 1183 | 3.670 | 22797.5 |
1432 | 2023-10-20 16:26:21 | yaffs | 1 | 28756 | 9 | 0.486 | 59168.7 |
1431 | 2023-10-20 04:04:20 | yaffs | 3 | 83667 | 1183 | 3.280 | 25508.2 |
1430 | 2023-10-19 23:24:36 | yaffs | 3 | 83667 | 1183 | 3.313 | 25254.2 |
1429 | 2023-10-19 16:02:05 | yaffs | 3 | 83667 | 1183 | 3.720 | 22491.1 |
1428 | 2023-10-18 16:11:41 | yaffs | 3 | 83667 | 1183 | 3.516 | 23796.1 |
1427 | 2023-10-17 16:24:09 | yaffs | 3 | 83667 | 1183 | 3.753 | 22293.4 |
1426 | 2023-10-17 00:26:58 | yaffs | 3 | 83667 | 1183 | 4.953 | 16892.2 |
1425 | 2023-10-16 22:39:35 | yaffs | 3 | 83667 | 1183 | 4.123 | 20292.7 |
1424 | 2023-10-16 00:20:37 | yaffs | 3 | 83667 | 1183 | 3.830 | 21845.2 |
1423 | 2023-10-15 00:11:20 | yaffs | 3 | 83667 | 1183 | 3.530 | 23701.7 |
1422 | 2023-10-14 02:10:45 | yaffs | 1 | 28756 | 9 | 0.470 | 61183.0 |
1421 | 2023-10-14 01:14:30 | yaffs | 3 | 83667 | 1183 | 3.203 | 26121.4 |
1420 | 2023-10-13 01:43:12 | yaffs | 3 | 83667 | 1183 | 3.923 | 21327.3 |
1419 | 2023-10-12 01:49:52 | yaffs | 3 | 83667 | 1183 | 3.233 | 25879.1 |
1418 | 2023-10-11 05:48:54 | yaffs | 3 | 83667 | 1183 | 3.830 | 21845.2 |
1417 | 2023-10-08 18:08:44 | yaffs | 3 | 83667 | 1183 | 5.953 | 14054.6 |