History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doggy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1588 | 2024-04-19 12:34:07 | doggy | 1 | 28756 | 10 | 0.513 | 56054.6 |
1587 | 2024-04-19 00:19:53 | doggy | 3 | 83667 | 805 | 9.920 | 8434.2 |
1586 | 2024-04-18 15:10:00 | doggy | 3 | 83667 | 805 | 5.343 | 15659.2 |
1585 | 2024-04-18 03:05:32 | doggy | 3 | 83667 | 805 | 7.626 | 10971.3 |
1584 | 2024-04-17 18:00:44 | doggy | 3 | 83667 | 805 | 11.140 | 7510.5 |
1583 | 2024-04-17 03:27:58 | doggy | 3 | 83667 | 805 | 3.673 | 22778.9 |
1582 | 2024-04-16 17:03:24 | doggy | 3 | 83667 | 805 | 4.983 | 16790.5 |
1581 | 2024-04-16 07:25:45 | doggy | 3 | 83667 | 805 | 6.283 | 13316.4 |
1580 | 2024-04-15 16:50:47 | doggy | 3 | 83667 | 805 | 15.673 | 5338.3 |
1579 | 2024-04-15 06:58:50 | doggy | 3 | 83667 | 805 | 8.750 | 9561.9 |
1578 | 2024-04-14 16:59:08 | doggy | 3 | 83667 | 805 | 14.343 | 5833.3 |
1577 | 2024-04-14 07:37:21 | doggy | 3 | 83667 | 805 | 4.483 | 18663.2 |
1576 | 2024-04-13 17:05:55 | doggy | 3 | 83667 | 805 | 3.890 | 21508.2 |
1575 | 2024-04-13 11:37:44 | doggy | 3 | 83667 | 805 | 3.483 | 24021.5 |
1574 | 2024-04-12 11:32:05 | doggy | 3 | 83667 | 805 | 10.486 | 7978.9 |
1573 | 2024-04-11 11:45:58 | doggy | 3 | 83667 | 805 | 3.763 | 22234.1 |
1572 | 2024-04-10 19:52:51 | doggy | 3 | 83667 | 805 | 4.516 | 18526.8 |
1571 | 2024-04-10 06:41:46 | doggy | 3 | 83667 | 805 | 4.250 | 19686.4 |
1570 | 2024-04-09 20:01:47 | doggy | 3 | 83667 | 805 | 3.703 | 22594.4 |
1569 | 2024-04-09 08:11:57 | doggy | 3 | 83667 | 805 | 3.673 | 22778.9 |
1568 | 2024-04-08 20:33:51 | doggy | 3 | 83667 | 805 | 3.406 | 24564.6 |
1567 | 2024-04-07 20:11:00 | doggy | 3 | 83667 | 805 | 5.156 | 16227.1 |
1566 | 2024-04-07 09:00:26 | doggy | 3 | 83667 | 805 | 7.640 | 10951.2 |
1565 | 2024-04-06 20:20:18 | doggy | 3 | 83667 | 805 | 5.826 | 14361.0 |
1564 | 2024-04-05 20:09:59 | doggy | 3 | 83667 | 805 | 4.923 | 16995.1 |
1563 | 2024-04-04 14:14:51 | doggy | 3 | 83667 | 805 | 3.390 | 24680.5 |
1562 | 2024-04-04 00:44:55 | doggy | 3 | 83667 | 805 | 10.000 | 8366.7 |
1561 | 2024-04-03 04:52:21 | doggy | 1 | 28756 | 10 | 1.250 | 23004.8 |
1560 | 2024-04-03 00:07:28 | doggy | 3 | 83667 | 805 | 4.936 | 16950.4 |
1559 | 2024-04-02 20:05:22 | doggy | 3 | 83667 | 805 | 3.436 | 24350.1 |
1558 | 2024-04-01 20:41:26 | doggy | 3 | 83667 | 805 | 13.346 | 6269.1 |
1557 | 2024-04-01 04:48:49 | doggy | 3 | 83667 | 805 | 11.626 | 7196.5 |
1556 | 2024-03-31 20:46:17 | doggy | 3 | 83667 | 805 | 8.143 | 10274.7 |
1555 | 2024-03-30 22:08:37 | doggy | 2 | 53800 | 94 | 1.643 | 32745.0 |
1554 | 2024-03-30 22:08:17 | doggy | 1 | 28756 | 10 | 1.703 | 16885.5 |
1553 | 2024-03-30 22:07:50 | doggy | 2 | 53800 | 94 | 4.923 | 10928.3 |
1552 | 2024-03-30 22:07:24 | doggy | 1 | 28756 | 10 | 0.453 | 63479.0 |
1551 | 2024-03-30 06:58:51 | doggy | 1 | 28756 | 10 | 1.110 | 25906.3 |
1550 | 2024-03-30 01:17:55 | doggy | 3 | 83667 | 805 | 12.156 | 6882.8 |
1549 | 2024-03-29 20:19:48 | doggy | 3 | 83667 | 805 | 4.283 | 19534.7 |
1548 | 2024-03-29 10:06:47 | doggy | 3 | 83667 | 805 | 4.796 | 17445.2 |
1547 | 2024-03-29 02:50:15 | doggy | 1 | 28756 | 10 | 0.500 | 57512.0 |
1546 | 2024-03-29 01:46:35 | doggy | 1 | 28756 | 10 | 1.953 | 14724.0 |
1545 | 2024-03-29 00:11:30 | doggy | 3 | 83667 | 805 | 7.173 | 11664.2 |
1544 | 2024-03-28 13:28:15 | doggy | 3 | 83667 | 805 | 3.953 | 21165.4 |
1543 | 2024-03-28 00:23:28 | doggy | 3 | 83667 | 805 | 7.436 | 11251.6 |
1542 | 2024-03-27 13:37:34 | doggy | 3 | 83667 | 805 | 7.233 | 11567.4 |
1541 | 2024-03-27 12:45:56 | doggy | 3 | 83667 | 805 | 7.750 | 10795.7 |
1540 | 2024-03-26 23:54:03 | doggy | 3 | 83667 | 805 | 5.283 | 15837.0 |
1539 | 2024-03-26 19:08:39 | doggy | 3 | 83667 | 805 | 3.966 | 21096.1 |
1538 | 2024-03-26 10:19:20 | doggy | 3 | 83667 | 805 | 9.406 | 8895.1 |
1537 | 2024-03-25 11:24:49 | doggy | 3 | 83667 | 805 | 3.580 | 23370.7 |
1536 | 2024-03-24 15:00:26 | doggy | 3 | 83667 | 805 | 10.940 | 7647.8 |
1535 | 2024-03-24 07:17:01 | doggy | 3 | 83667 | 805 | 9.673 | 8649.5 |
1534 | 2024-03-23 15:23:09 | doggy | 3 | 83667 | 805 | 3.860 | 21675.4 |
1533 | 2024-03-23 07:05:53 | doggy | 3 | 83667 | 805 | 8.203 | 10199.6 |
1532 | 2024-03-22 07:14:37 | doggy | 3 | 83667 | 805 | 6.503 | 12865.9 |
1531 | 2024-03-21 07:28:35 | doggy | 3 | 83667 | 805 | 14.123 | 5924.2 |
1530 | 2024-03-20 06:34:58 | doggy | 3 | 83667 | 805 | 13.173 | 6351.4 |
1529 | 2024-03-19 13:40:26 | doggy | 3 | 83667 | 805 | 4.733 | 17677.4 |
1528 | 2024-03-19 03:19:46 | doggy | 3 | 83667 | 805 | 9.390 | 8910.2 |
1527 | 2024-03-17 04:10:58 | doggy | 3 | 83667 | 805 | 4.266 | 19612.5 |
1526 | 2024-03-16 14:58:27 | doggy | 3 | 83667 | 805 | 14.080 | 5942.3 |
1525 | 2024-03-16 04:52:21 | doggy | 3 | 83667 | 805 | 6.860 | 12196.4 |
1524 | 2024-03-15 17:20:14 | doggy | 3 | 83667 | 805 | 5.013 | 16690.0 |
1523 | 2024-03-15 15:07:44 | doggy | 3 | 83667 | 805 | 3.673 | 22778.9 |
1522 | 2024-03-13 17:34:44 | doggy | 3 | 83667 | 805 | 5.953 | 14054.6 |
1521 | 2024-03-12 19:42:43 | doggy | 3 | 83667 | 805 | 12.706 | 6584.8 |
1520 | 2024-03-12 11:09:35 | doggy | 3 | 83667 | 805 | 7.780 | 10754.1 |
1519 | 2024-03-11 13:31:55 | doggy | 3 | 83667 | 805 | 4.596 | 18204.3 |
1518 | 2024-03-10 14:42:51 | doggy | 3 | 83667 | 805 | 9.453 | 8850.8 |
1517 | 2024-03-07 12:14:10 | doggy | 3 | 83667 | 805 | 9.406 | 8895.1 |
1516 | 2024-03-07 01:50:20 | doggy | 3 | 83667 | 805 | 3.623 | 23093.3 |
1515 | 2024-03-06 00:39:53 | doggy | 3 | 83667 | 805 | 6.266 | 13352.5 |
1514 | 2024-03-05 05:49:22 | doggy | 3 | 83667 | 805 | 3.486 | 24000.9 |
1513 | 2024-03-04 06:18:15 | doggy | 3 | 83667 | 805 | 3.356 | 24930.6 |
1512 | 2024-03-04 00:02:31 | doggy | 1 | 28756 | 10 | 1.123 | 25606.4 |
1511 | 2024-03-03 10:21:49 | doggy | 3 | 83667 | 805 | 4.170 | 20064.0 |
1510 | 2024-03-02 23:13:32 | doggy | 3 | 83667 | 805 | 9.266 | 9029.5 |
1509 | 2024-03-02 10:57:27 | doggy | 3 | 83667 | 805 | 4.390 | 19058.5 |
1508 | 2024-03-02 03:06:25 | doggy | 3 | 83667 | 805 | 12.766 | 6553.9 |
1507 | 2024-03-01 23:20:53 | doggy | 3 | 83667 | 805 | 3.873 | 21602.6 |
1506 | 2024-03-01 03:09:20 | doggy | 3 | 83667 | 805 | 3.766 | 22216.4 |
1505 | 2024-02-29 18:15:13 | doggy | 1 | 28756 | 10 | 0.530 | 54256.6 |
1504 | 2024-02-29 15:59:27 | doggy | 3 | 83667 | 805 | 3.796 | 22040.8 |
1503 | 2024-02-29 03:02:13 | doggy | 3 | 83667 | 805 | 3.796 | 22040.8 |
1502 | 2024-02-28 19:22:50 | doggy | 2 | 53800 | 94 | 1.343 | 40059.6 |
1501 | 2024-02-28 18:20:28 | doggy | 3 | 83667 | 805 | 3.936 | 21256.9 |
1500 | 2024-02-28 07:48:45 | doggy | 3 | 83667 | 805 | 3.936 | 21256.9 |
1499 | 2024-02-27 22:32:49 | doggy | 2 | 53800 | 94 | 2.843 | 18923.7 |
1498 | 2024-02-27 20:54:59 | doggy | 1 | 28756 | 10 | 0.546 | 52666.7 |
1497 | 2024-02-27 16:30:33 | doggy | 3 | 83667 | 805 | 3.893 | 21491.7 |
1496 | 2024-02-27 07:52:15 | doggy | 3 | 83667 | 805 | 4.060 | 20607.6 |
1495 | 2024-02-26 07:33:03 | doggy | 3 | 83667 | 805 | 8.300 | 10080.4 |
1494 | 2024-02-25 07:22:46 | doggy | 3 | 83667 | 805 | 4.296 | 19475.6 |
1493 | 2024-02-24 06:11:19 | doggy | 3 | 83667 | 805 | 3.343 | 25027.5 |
1492 | 2024-02-23 14:47:40 | doggy | 3 | 83667 | 805 | 8.986 | 9310.8 |
1491 | 2024-02-23 06:26:14 | doggy | 3 | 83667 | 805 | 7.390 | 11321.7 |
1490 | 2024-02-22 06:11:56 | doggy | 3 | 83667 | 805 | 5.813 | 14393.1 |
1489 | 2024-02-21 15:53:10 | doggy | 3 | 83667 | 805 | 10.780 | 7761.3 |