History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"login"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1798 | 2024-04-24 20:11:00 | login | 1 | 28756 | 9 | 0.593 | 48492.4 |
1797 | 2024-04-24 16:12:53 | login | 1 | 28756 | 9 | 0.970 | 29645.4 |
1796 | 2024-04-24 15:11:29 | login | 1 | 28756 | 9 | 1.000 | 28756.0 |
1795 | 2024-04-21 07:21:31 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1794 | 2024-04-20 12:22:12 | login | 1 | 28756 | 9 | 0.610 | 47141.0 |
1793 | 2024-04-17 21:34:09 | login | 1 | 28756 | 9 | 0.970 | 29645.4 |
1792 | 2024-04-17 09:03:34 | login | 1 | 28756 | 9 | 0.450 | 63902.2 |
1791 | 2024-04-13 14:27:36 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1790 | 2024-04-11 06:12:43 | login | 1 | 28756 | 9 | 0.453 | 63479.0 |
1789 | 2024-04-02 20:48:17 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1788 | 2024-03-31 10:04:41 | login | 2 | 53800 | 107 | 3.780 | 14232.8 |
1787 | 2024-03-31 08:30:00 | login | 1 | 28756 | 9 | 1.190 | 24164.7 |
1786 | 2024-03-28 22:31:54 | login | 1 | 28756 | 9 | 1.126 | 25538.2 |
1785 | 2024-03-26 22:38:20 | login | 1 | 28756 | 9 | 1.733 | 16593.2 |
1784 | 2024-03-12 03:02:14 | login | 1 | 28756 | 9 | 0.546 | 52666.7 |
1783 | 2024-03-05 09:20:39 | login | 1 | 28756 | 9 | 1.000 | 28756.0 |
1782 | 2024-02-25 18:36:01 | login | 1 | 28756 | 9 | 0.546 | 52666.7 |
1781 | 2024-02-25 15:59:46 | login | 1 | 28756 | 9 | 0.483 | 59536.2 |
1780 | 2024-02-23 07:08:41 | login | 1 | 28756 | 9 | 0.530 | 54256.6 |
1779 | 2024-02-21 20:09:29 | login | 1 | 28756 | 9 | 0.560 | 51350.0 |
1778 | 2024-01-26 13:35:04 | login | 1 | 28756 | 9 | 0.533 | 53951.2 |
1777 | 2024-01-24 00:30:33 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1776 | 2024-01-21 09:20:08 | login | 1 | 28756 | 9 | 0.513 | 56054.6 |
1775 | 2024-01-07 18:00:44 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1774 | 2024-01-02 02:08:00 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1773 | 2023-12-29 04:44:21 | login | 1 | 28756 | 9 | 0.466 | 61708.2 |
1772 | 2023-12-24 01:28:24 | login | 1 | 28756 | 9 | 0.486 | 59168.7 |
1771 | 2023-12-15 10:10:37 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1770 | 2023-12-04 16:29:59 | login | 1 | 28756 | 9 | 0.563 | 51076.4 |
1769 | 2023-12-02 17:06:40 | login | 1 | 28756 | 9 | 0.610 | 47141.0 |
1768 | 2023-11-28 17:57:34 | login | 1 | 28756 | 9 | 0.470 | 61183.0 |
1767 | 2023-11-28 00:13:13 | login | 2 | 53800 | 107 | 1.546 | 34799.5 |
1766 | 2023-11-19 22:02:51 | login | 1 | 28756 | 9 | 0.470 | 61183.0 |
1765 | 2023-11-12 18:42:31 | login | 2 | 53800 | 107 | 1.626 | 33087.3 |
1764 | 2023-11-09 22:39:00 | login | 2 | 53800 | 107 | 1.406 | 38264.6 |
1763 | 2023-11-08 11:41:30 | login | 1 | 28756 | 9 | 0.486 | 59168.7 |
1762 | 2023-11-08 06:20:33 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1761 | 2023-11-08 02:28:13 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1760 | 2023-11-07 08:36:36 | login | 1 | 28756 | 9 | 0.483 | 59536.2 |
1759 | 2023-11-07 05:18:14 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1758 | 2023-11-06 11:14:52 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1757 | 2023-11-05 18:01:01 | login | 1 | 28756 | 9 | 0.440 | 65354.5 |
1756 | 2023-10-31 22:58:27 | login | 1 | 28756 | 9 | 0.440 | 65354.5 |
1755 | 2023-10-26 18:22:29 | login | 2 | 53800 | 107 | 2.890 | 18615.9 |
1754 | 2023-10-25 19:44:22 | login | 1 | 28756 | 9 | 0.483 | 59536.2 |
1753 | 2023-10-24 08:49:26 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1752 | 2023-10-23 13:55:46 | login | 1 | 28756 | 9 | 0.466 | 61708.2 |
1751 | 2023-10-20 10:16:34 | login | 2 | 53800 | 107 | 1.436 | 37465.2 |
1750 | 2023-10-19 14:43:20 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1749 | 2023-10-17 06:50:24 | login | 2 | 53800 | 107 | 1.593 | 33772.8 |
1748 | 2023-10-16 18:30:04 | login | 1 | 28756 | 9 | 0.486 | 59168.7 |
1747 | 2023-10-10 09:53:07 | login | 2 | 53800 | 107 | 1.610 | 33416.1 |
1746 | 2023-10-09 21:25:10 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1745 | 2023-10-04 00:24:55 | login | 2 | 53800 | 107 | 1.640 | 32804.9 |
1744 | 2023-10-03 08:35:43 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1743 | 2023-09-25 11:40:11 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1742 | 2023-09-23 06:32:45 | login | 2 | 53800 | 107 | 1.593 | 33772.8 |
1741 | 2023-09-18 22:26:26 | login | 1 | 28756 | 9 | 0.530 | 54256.6 |
1740 | 2023-09-15 19:06:52 | login | 1 | 28756 | 9 | 0.953 | 30174.2 |
1739 | 2023-09-11 03:57:24 | login | 2 | 53800 | 107 | 1.670 | 32215.6 |
1738 | 2023-09-10 11:39:51 | login | 1 | 28756 | 9 | 0.420 | 68466.7 |
1737 | 2023-08-20 00:39:19 | login | 1 | 28756 | 9 | 0.453 | 63479.0 |
1736 | 2023-08-03 04:51:41 | login | 1 | 28756 | 9 | 0.533 | 53951.2 |
1735 | 2023-07-26 10:43:54 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1734 | 2023-07-23 16:11:28 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1733 | 2023-07-23 09:43:26 | login | 1 | 28756 | 9 | 0.483 | 59536.2 |
1732 | 2023-07-16 19:23:49 | login | 1 | 28756 | 9 | 0.486 | 59168.7 |
1731 | 2023-07-16 18:36:45 | login | 1 | 28756 | 9 | 0.513 | 56054.6 |
1730 | 2023-06-10 12:19:39 | login | 1 | 28756 | 9 | 0.453 | 63479.0 |
1729 | 2023-06-01 10:50:04 | login | 1 | 28756 | 9 | 0.486 | 59168.7 |
1728 | 2023-05-23 06:46:00 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1727 | 2023-05-19 11:21:22 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1726 | 2023-04-28 17:35:16 | login | 1 | 28756 | 9 | 0.453 | 63479.0 |
1725 | 2023-04-25 18:01:17 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1724 | 2023-04-17 05:59:02 | login | 1 | 28756 | 9 | 0.453 | 63479.0 |
1723 | 2023-04-15 22:08:33 | login | 1 | 28756 | 9 | 0.440 | 65354.5 |
1722 | 2023-04-12 18:38:34 | login | 1 | 28756 | 9 | 0.420 | 68466.7 |
1721 | 2023-03-27 13:24:44 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1720 | 2023-03-18 10:48:27 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1719 | 2023-03-14 16:23:26 | login | 1 | 28756 | 9 | 0.453 | 63479.0 |
1718 | 2023-03-12 11:49:11 | login | 1 | 28756 | 9 | 0.453 | 63479.0 |
1717 | 2023-03-10 07:08:14 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1716 | 2023-02-18 20:26:27 | login | 1 | 28756 | 9 | 0.966 | 29768.1 |
1715 | 2023-02-04 02:59:16 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1714 | 2023-01-30 06:42:14 | login | 1 | 28756 | 9 | 0.470 | 61183.0 |
1713 | 2023-01-26 17:23:41 | login | 1 | 28756 | 9 | 0.436 | 65954.1 |
1712 | 2023-01-17 08:22:06 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1711 | 2023-01-13 09:48:22 | login | 1 | 28756 | 9 | 0.483 | 59536.2 |
1710 | 2023-01-09 15:59:56 | login | 1 | 28756 | 9 | 0.450 | 63902.2 |
1709 | 2023-01-08 18:08:42 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1708 | 2023-01-06 04:47:17 | login | 1 | 28756 | 9 | 0.440 | 65354.5 |
1707 | 2023-01-02 20:13:41 | login | 1 | 28756 | 9 | 0.513 | 56054.6 |
1706 | 2022-12-29 16:45:33 | login | 1 | 28756 | 9 | 0.530 | 54256.6 |
1705 | 2022-12-14 08:06:08 | login | 1 | 28756 | 9 | 0.513 | 56054.6 |
1704 | 2022-12-08 10:17:39 | login | 1 | 28756 | 9 | 0.970 | 29645.4 |
1703 | 2022-11-24 05:52:05 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1702 | 2022-11-18 21:54:26 | login | 1 | 28756 | 9 | 0.500 | 57512.0 |
1701 | 2022-11-17 11:04:30 | login | 1 | 28756 | 9 | 0.516 | 55728.7 |
1700 | 2022-11-08 02:29:00 | login | 1 | 28756 | 9 | 0.483 | 59536.2 |
1699 | 2022-11-05 09:49:38 | login | 1 | 28756 | 9 | 0.486 | 59168.7 |