History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lewis"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1680 | 2024-04-11 19:53:29 | lewis | 3 | 83667 | 1662 | 5.903 | 14173.6 |
1679 | 2024-04-11 16:32:02 | lewis | 3 | 83667 | 1662 | 3.826 | 21868.0 |
1678 | 2024-04-11 02:49:56 | lewis | 3 | 83667 | 1662 | 4.233 | 19765.4 |
1677 | 2024-04-05 18:52:57 | lewis | 3 | 83667 | 1662 | 10.156 | 8238.2 |
1676 | 2024-04-05 18:52:59 | lewis | 2 | 53800 | 99 | 1.923 | 27977.1 |
1675 | 2024-04-05 18:52:37 | lewis | 1 | 28756 | 6 | 0.546 | 52666.7 |
1674 | 2024-04-01 17:28:35 | lewis | 2 | 53800 | 99 | 3.830 | 14047.0 |
1673 | 2024-03-31 11:13:19 | lewis | 2 | 53800 | 99 | 4.190 | 12840.1 |
1672 | 2024-03-31 11:13:11 | lewis | 1 | 28756 | 6 | 1.000 | 28756.0 |
1671 | 2024-03-31 11:13:05 | lewis | 2 | 53800 | 99 | 1.733 | 31044.4 |
1670 | 2024-03-31 11:12:37 | lewis | 3 | 83667 | 1662 | 6.093 | 13731.7 |
1669 | 2024-03-31 05:20:10 | lewis | 3 | 83667 | 1662 | 15.080 | 5548.2 |
1668 | 2024-03-31 05:20:09 | lewis | 2 | 53800 | 99 | 1.813 | 29674.6 |
1667 | 2024-03-31 04:03:00 | lewis | 1 | 28756 | 6 | 0.530 | 54256.6 |
1666 | 2024-03-27 05:05:23 | lewis | 1 | 28756 | 6 | 0.530 | 54256.6 |
1665 | 2024-03-04 09:37:35 | lewis | 3 | 83667 | 1662 | 9.593 | 8721.7 |
1664 | 2024-03-04 08:34:56 | lewis | 3 | 83667 | 1662 | 4.080 | 20506.6 |
1663 | 2024-03-04 08:34:56 | lewis | 2 | 53800 | 99 | 1.716 | 31352.0 |
1662 | 2024-03-04 08:34:45 | lewis | 1 | 28756 | 6 | 0.483 | 59536.2 |
1661 | 2024-03-01 02:44:57 | lewis | 1 | 28756 | 6 | 0.516 | 55728.7 |
1660 | 2024-02-25 19:17:51 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1659 | 2024-02-06 14:34:15 | lewis | 1 | 28756 | 6 | 1.076 | 26724.9 |
1658 | 2024-02-03 04:18:07 | lewis | 1 | 28756 | 6 | 0.500 | 57512.0 |
1657 | 2024-02-02 19:16:00 | lewis | 1 | 28756 | 6 | 1.016 | 28303.1 |
1656 | 2024-02-01 04:45:04 | lewis | 2 | 53800 | 99 | 1.610 | 33416.1 |
1655 | 2024-02-01 04:44:36 | lewis | 3 | 83667 | 1662 | 3.703 | 22594.4 |
1654 | 2024-01-31 21:04:31 | lewis | 2 | 53800 | 99 | 1.780 | 30224.7 |
1653 | 2024-01-31 21:04:16 | lewis | 3 | 83667 | 1662 | 3.733 | 22412.8 |
1652 | 2024-01-29 00:45:51 | lewis | 1 | 28756 | 6 | 0.500 | 57512.0 |
1651 | 2024-01-25 21:20:37 | lewis | 1 | 28756 | 6 | 0.486 | 59168.7 |
1650 | 2024-01-22 22:00:45 | lewis | 3 | 83667 | 1662 | 3.763 | 22234.1 |
1649 | 2024-01-19 19:13:28 | lewis | 2 | 53800 | 99 | 2.733 | 19685.3 |
1648 | 2024-01-05 03:14:35 | lewis | 1 | 28756 | 6 | 0.500 | 57512.0 |
1647 | 2023-12-28 09:51:25 | lewis | 2 | 53800 | 99 | 1.420 | 37887.3 |
1646 | 2023-12-26 16:50:46 | lewis | 3 | 83667 | 1662 | 3.703 | 22594.4 |
1645 | 2023-12-18 19:51:31 | lewis | 3 | 83667 | 1662 | 3.500 | 23904.9 |
1644 | 2023-12-18 19:51:32 | lewis | 2 | 53800 | 99 | 1.546 | 34799.5 |
1643 | 2023-11-19 02:29:19 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1642 | 2023-11-13 13:41:06 | lewis | 2 | 53800 | 99 | 1.356 | 39675.5 |
1641 | 2023-11-13 13:41:01 | lewis | 3 | 83667 | 1662 | 3.830 | 21845.2 |
1640 | 2023-11-12 01:44:27 | lewis | 1 | 28756 | 6 | 0.483 | 59536.2 |
1639 | 2023-10-31 03:47:48 | lewis | 2 | 53800 | 99 | 1.656 | 32487.9 |
1638 | 2023-10-30 03:23:43 | lewis | 3 | 83667 | 1662 | 3.440 | 24321.8 |
1637 | 2023-10-30 03:23:35 | lewis | 2 | 53800 | 99 | 1.390 | 38705.0 |
1636 | 2023-10-27 12:37:43 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1635 | 2023-10-25 22:51:05 | lewis | 1 | 28756 | 6 | 0.456 | 63061.4 |
1634 | 2023-10-21 09:27:48 | lewis | 1 | 28756 | 6 | 0.453 | 63479.0 |
1633 | 2023-10-18 16:42:03 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1632 | 2023-10-17 03:10:20 | lewis | 3 | 83667 | 1662 | 5.923 | 14125.8 |
1631 | 2023-10-15 05:47:12 | lewis | 3 | 83667 | 1662 | 7.563 | 11062.7 |
1630 | 2023-10-13 07:29:16 | lewis | 1 | 28756 | 6 | 0.423 | 67981.1 |
1629 | 2023-10-12 14:51:12 | lewis | 3 | 83667 | 1662 | 3.266 | 25617.6 |
1628 | 2023-10-11 11:23:18 | lewis | 1 | 28756 | 6 | 0.470 | 61183.0 |
1627 | 2023-10-05 21:58:53 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1626 | 2023-09-27 14:56:02 | lewis | 3 | 83667 | 1662 | 6.046 | 13838.4 |
1625 | 2023-09-22 12:12:25 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1624 | 2023-09-21 15:15:40 | lewis | 3 | 83667 | 1662 | 3.440 | 24321.8 |
1623 | 2023-09-21 12:47:13 | lewis | 3 | 83667 | 1662 | 3.406 | 24564.6 |
1622 | 2023-09-17 22:23:06 | lewis | 3 | 83667 | 1662 | 3.906 | 21420.1 |
1621 | 2023-09-16 15:20:07 | lewis | 3 | 83667 | 1662 | 3.423 | 24442.6 |
1620 | 2023-09-15 15:19:53 | lewis | 3 | 83667 | 1662 | 3.296 | 25384.4 |
1619 | 2023-09-14 09:53:17 | lewis | 1 | 28756 | 6 | 0.470 | 61183.0 |
1618 | 2023-08-22 11:32:38 | lewis | 1 | 28756 | 6 | 0.483 | 59536.2 |
1617 | 2023-08-09 00:41:49 | lewis | 2 | 53800 | 99 | 1.390 | 38705.0 |
1616 | 2023-07-09 23:51:26 | lewis | 3 | 83667 | 1662 | 5.046 | 16580.9 |
1615 | 2023-06-20 23:11:13 | lewis | 1 | 28756 | 6 | 0.470 | 61183.0 |
1614 | 2023-06-17 18:41:03 | lewis | 1 | 28756 | 6 | 0.563 | 51076.4 |
1613 | 2023-06-01 06:44:40 | lewis | 3 | 83667 | 1662 | 3.220 | 25983.5 |
1612 | 2023-05-22 22:28:46 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1611 | 2023-04-20 00:43:16 | lewis | 2 | 53800 | 99 | 1.390 | 38705.0 |
1610 | 2023-04-18 01:22:54 | lewis | 3 | 83667 | 1662 | 3.690 | 22674.0 |
1609 | 2023-04-12 14:04:01 | lewis | 3 | 83667 | 1662 | 3.220 | 25983.5 |
1608 | 2023-03-21 19:24:59 | lewis | 3 | 83667 | 1662 | 3.330 | 25125.2 |
1607 | 2023-03-18 22:55:42 | lewis | 1 | 28756 | 6 | 0.530 | 54256.6 |
1606 | 2023-03-14 18:44:54 | lewis | 3 | 83667 | 1662 | 3.606 | 23202.2 |
1605 | 2023-03-08 20:00:05 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1604 | 2023-01-19 01:25:48 | lewis | 2 | 53800 | 99 | 2.686 | 20029.8 |
1603 | 2023-01-07 02:05:11 | lewis | 1 | 28756 | 6 | 0.486 | 59168.7 |
1602 | 2022-11-16 23:25:10 | lewis | 1 | 28756 | 6 | 0.453 | 63479.0 |
1601 | 2022-10-29 01:52:54 | lewis | 2 | 53800 | 99 | 1.330 | 40451.1 |
1600 | 2022-10-02 02:58:27 | lewis | 1 | 28756 | 6 | 0.500 | 57512.0 |
1599 | 2022-09-19 18:05:44 | lewis | 1 | 28756 | 6 | 0.500 | 57512.0 |
1598 | 2022-09-17 16:57:15 | lewis | 1 | 28756 | 6 | 0.486 | 59168.7 |
1597 | 2022-09-10 15:07:18 | lewis | 1 | 28756 | 6 | 0.486 | 59168.7 |
1596 | 2022-08-31 02:23:36 | lewis | 1 | 28756 | 6 | 0.483 | 59536.2 |
1595 | 2022-08-14 18:17:06 | lewis | 1 | 28756 | 6 | 0.436 | 65954.1 |
1594 | 2022-08-12 18:29:47 | lewis | 3 | 83667 | 1662 | 3.686 | 22698.6 |
1593 | 2022-07-29 02:30:10 | lewis | 1 | 28756 | 6 | 0.466 | 61708.2 |
1592 | 2022-07-20 10:47:48 | lewis | 1 | 28756 | 6 | 0.453 | 63479.0 |
1591 | 2022-07-16 17:35:00 | lewis | 1 | 28756 | 6 | 0.483 | 59536.2 |
1590 | 2022-06-10 09:48:09 | lewis | 3 | 83667 | 1662 | 3.953 | 21165.4 |
1589 | 2022-05-30 21:37:40 | lewis | 2 | 53800 | 99 | 1.390 | 38705.0 |
1588 | 2022-05-28 17:03:53 | lewis | 2 | 53800 | 99 | 1.373 | 39184.3 |
1587 | 2022-05-18 22:38:22 | lewis | 3 | 83667 | 1662 | 3.796 | 22040.8 |
1586 | 2022-05-17 20:17:36 | lewis | 3 | 83667 | 1662 | 3.296 | 25384.4 |
1585 | 2022-05-16 20:52:00 | lewis | 3 | 83667 | 1662 | 4.436 | 18860.9 |
1584 | 2022-05-16 03:39:38 | lewis | 3 | 83667 | 1662 | 3.313 | 25254.2 |
1583 | 2022-05-15 16:45:28 | lewis | 1 | 28756 | 6 | 0.486 | 59168.7 |
1582 | 2022-05-14 19:34:57 | lewis | 3 | 83667 | 1662 | 3.766 | 22216.4 |
1581 | 2022-05-13 12:57:51 | lewis | 3 | 83667 | 1662 | 3.950 | 21181.5 |