History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piano"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1777 | 2024-04-26 17:02:50 | piano | 1 | 28756 | 4 | 0.970 | 29645.4 |
1776 | 2024-04-23 18:06:06 | piano | 3 | 83667 | 1132 | 3.313 | 25254.2 |
1775 | 2024-04-23 17:46:49 | piano | 1 | 28756 | 4 | 0.530 | 54256.6 |
1774 | 2024-04-04 19:48:35 | piano | 3 | 83667 | 1132 | 13.546 | 6176.5 |
1773 | 2024-04-03 19:29:17 | piano | 2 | 53800 | 83 | 2.593 | 20748.2 |
1772 | 2024-04-03 19:26:09 | piano | 2 | 53800 | 83 | 2.000 | 26900.0 |
1771 | 2024-04-03 19:26:03 | piano | 1 | 28756 | 4 | 0.580 | 49579.3 |
1770 | 2024-04-03 19:25:36 | piano | 3 | 83667 | 1132 | 4.720 | 17726.1 |
1769 | 2024-04-03 04:42:43 | piano | 1 | 28756 | 4 | 1.156 | 24875.4 |
1768 | 2024-04-02 02:50:36 | piano | 3 | 83667 | 1132 | 3.796 | 22040.8 |
1767 | 2024-03-31 06:07:42 | piano | 1 | 28756 | 4 | 1.846 | 15577.5 |
1766 | 2024-03-27 06:07:31 | piano | 1 | 28756 | 4 | 0.466 | 61708.2 |
1765 | 2024-03-19 06:26:30 | piano | 3 | 83667 | 1132 | 5.716 | 14637.3 |
1764 | 2024-03-06 12:16:56 | piano | 3 | 83667 | 1132 | 4.750 | 17614.1 |
1763 | 2024-03-06 11:48:16 | piano | 3 | 83667 | 1132 | 10.876 | 7692.8 |
1762 | 2024-03-03 23:48:26 | piano | 2 | 53800 | 83 | 5.403 | 9957.4 |
1761 | 2024-03-03 22:05:02 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
1760 | 2024-03-02 15:40:55 | piano | 3 | 83667 | 1132 | 5.736 | 14586.3 |
1759 | 2024-03-02 09:52:14 | piano | 3 | 83667 | 1132 | 10.406 | 8040.3 |
1758 | 2024-03-01 08:43:25 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
1757 | 2024-02-25 17:24:44 | piano | 1 | 28756 | 4 | 1.140 | 25224.6 |
1756 | 2024-02-19 06:37:37 | piano | 1 | 28756 | 4 | 0.546 | 52666.7 |
1755 | 2024-01-29 05:26:56 | piano | 3 | 83667 | 1132 | 3.830 | 21845.2 |
1754 | 2024-01-29 00:32:39 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
1753 | 2024-01-26 01:23:21 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
1752 | 2024-01-13 00:42:05 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
1751 | 2024-01-06 13:54:09 | piano | 1 | 28756 | 4 | 0.513 | 56054.6 |
1750 | 2024-01-01 07:30:17 | piano | 2 | 53800 | 83 | 1.450 | 37103.4 |
1749 | 2023-12-22 14:29:04 | piano | 3 | 83667 | 1132 | 3.360 | 24900.9 |
1748 | 2023-12-21 15:12:52 | piano | 3 | 83667 | 1132 | 4.530 | 18469.5 |
1747 | 2023-12-16 07:43:46 | piano | 3 | 83667 | 1132 | 3.390 | 24680.5 |
1746 | 2023-12-14 14:39:09 | piano | 2 | 53800 | 83 | 2.920 | 18424.7 |
1745 | 2023-12-08 00:49:03 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
1744 | 2023-12-08 00:49:02 | piano | 1 | 28756 | 4 | 0.576 | 49923.6 |
1743 | 2023-12-06 07:30:01 | piano | 3 | 83667 | 1132 | 3.796 | 22040.8 |
1742 | 2023-12-06 06:29:52 | piano | 3 | 83667 | 1132 | 3.393 | 24658.7 |
1741 | 2023-12-02 03:21:11 | piano | 3 | 83667 | 1132 | 4.046 | 20678.9 |
1740 | 2023-11-28 03:58:54 | piano | 3 | 83667 | 1132 | 4.000 | 20916.8 |
1739 | 2023-11-26 21:37:57 | piano | 2 | 53800 | 83 | 1.436 | 37465.2 |
1738 | 2023-11-25 17:52:44 | piano | 1 | 28756 | 4 | 0.560 | 51350.0 |
1737 | 2023-11-21 22:09:01 | piano | 3 | 83667 | 1132 | 3.876 | 21585.9 |
1736 | 2023-11-14 17:52:24 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
1735 | 2023-11-11 11:29:14 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
1734 | 2023-11-10 00:25:10 | piano | 3 | 83667 | 1132 | 4.700 | 17801.5 |
1733 | 2023-11-02 07:40:34 | piano | 3 | 83667 | 1132 | 8.186 | 10220.7 |
1732 | 2023-11-02 07:40:38 | piano | 2 | 53800 | 83 | 1.763 | 30516.2 |
1731 | 2023-10-30 23:48:40 | piano | 1 | 28756 | 4 | 0.533 | 53951.2 |
1730 | 2023-10-29 22:26:47 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
1729 | 2023-10-26 02:10:15 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
1728 | 2023-10-21 09:09:35 | piano | 1 | 28756 | 4 | 0.513 | 56054.6 |
1727 | 2023-10-19 01:53:23 | piano | 1 | 28756 | 4 | 0.440 | 65354.5 |
1726 | 2023-10-11 07:37:23 | piano | 1 | 28756 | 4 | 0.486 | 59168.7 |
1725 | 2023-10-05 21:47:29 | piano | 2 | 53800 | 83 | 1.686 | 31909.8 |
1724 | 2023-10-05 17:22:15 | piano | 1 | 28756 | 4 | 0.436 | 65954.1 |
1723 | 2023-09-28 07:42:20 | piano | 1 | 28756 | 4 | 0.483 | 59536.2 |
1722 | 2023-09-26 12:40:50 | piano | 1 | 28756 | 4 | 0.436 | 65954.1 |
1721 | 2023-09-12 18:42:57 | piano | 2 | 53800 | 83 | 1.643 | 32745.0 |
1720 | 2023-09-12 18:36:37 | piano | 1 | 28756 | 4 | 0.530 | 54256.6 |
1719 | 2023-09-10 13:14:35 | piano | 3 | 83667 | 1132 | 4.296 | 19475.6 |
1718 | 2023-09-03 06:38:53 | piano | 3 | 83667 | 1132 | 3.953 | 21165.4 |
1717 | 2023-08-23 15:47:22 | piano | 1 | 28756 | 4 | 0.456 | 63061.4 |
1716 | 2023-08-11 12:52:28 | piano | 3 | 83667 | 1132 | 3.343 | 25027.5 |
1715 | 2023-08-11 03:05:11 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
1714 | 2023-07-18 21:57:23 | piano | 2 | 53800 | 83 | 1.390 | 38705.0 |
1713 | 2023-07-08 05:35:14 | piano | 1 | 28756 | 4 | 0.546 | 52666.7 |
1712 | 2023-06-28 23:00:53 | piano | 3 | 83667 | 1132 | 3.500 | 23904.9 |
1711 | 2023-06-23 05:48:52 | piano | 3 | 83667 | 1132 | 3.343 | 25027.5 |
1710 | 2023-05-24 23:19:01 | piano | 1 | 28756 | 4 | 0.440 | 65354.5 |
1709 | 2023-04-04 01:16:25 | piano | 2 | 53800 | 83 | 1.356 | 39675.5 |
1708 | 2023-03-17 19:44:25 | piano | 1 | 28756 | 4 | 0.436 | 65954.1 |
1707 | 2023-01-06 19:06:49 | piano | 1 | 28756 | 4 | 0.483 | 59536.2 |
1706 | 2022-12-31 01:12:26 | piano | 2 | 53800 | 83 | 1.546 | 34799.5 |
1705 | 2022-12-22 04:11:46 | piano | 3 | 83667 | 1132 | 3.266 | 25617.6 |
1704 | 2022-12-21 23:33:20 | piano | 3 | 83667 | 1132 | 3.796 | 22040.8 |
1703 | 2022-11-26 09:53:26 | piano | 1 | 28756 | 4 | 0.470 | 61183.0 |
1702 | 2022-11-23 01:21:25 | piano | 1 | 28756 | 4 | 0.456 | 63061.4 |
1701 | 2022-11-05 00:26:53 | piano | 3 | 83667 | 1132 | 3.860 | 21675.4 |
1700 | 2022-10-31 08:13:40 | piano | 3 | 83667 | 1132 | 3.860 | 21675.4 |
1699 | 2022-10-03 14:46:04 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
1698 | 2022-09-21 22:25:23 | piano | 3 | 83667 | 1132 | 3.296 | 25384.4 |
1697 | 2022-09-14 21:00:14 | piano | 1 | 28756 | 4 | 0.436 | 65954.1 |
1696 | 2022-08-31 07:57:44 | piano | 2 | 53800 | 83 | 1.356 | 39675.5 |
1695 | 2022-08-24 14:12:27 | piano | 3 | 83667 | 1132 | 3.343 | 25027.5 |
1694 | 2022-08-17 21:00:37 | piano | 3 | 83667 | 1132 | 3.550 | 23568.2 |
1693 | 2022-08-02 18:33:52 | piano | 1 | 28756 | 4 | 0.470 | 61183.0 |
1692 | 2022-05-22 15:34:56 | piano | 1 | 28756 | 4 | 0.470 | 61183.0 |
1691 | 2022-05-06 05:28:43 | piano | 3 | 83667 | 1132 | 3.813 | 21942.6 |
1690 | 2022-04-08 03:54:36 | piano | 1 | 28756 | 4 | 1.080 | 26625.9 |
1689 | 2022-04-04 17:34:22 | piano | 1 | 28756 | 4 | 0.670 | 42919.4 |
1688 | 2022-01-28 12:43:22 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
1687 | 2022-01-26 07:50:29 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
1686 | 2022-01-11 00:15:39 | piano | 3 | 83667 | 1132 | 3.970 | 21074.8 |
1685 | 2022-01-09 09:04:19 | piano | 3 | 83667 | 1132 | 3.826 | 21868.0 |
1684 | 2022-01-08 17:26:59 | piano | 3 | 83667 | 1132 | 3.563 | 23482.2 |
1683 | 2022-01-07 17:44:53 | piano | 3 | 83667 | 1132 | 3.423 | 24442.6 |
1682 | 2022-01-07 01:57:33 | piano | 3 | 83667 | 1132 | 3.843 | 21771.3 |
1681 | 2022-01-06 06:51:33 | piano | 3 | 83667 | 1132 | 3.500 | 23904.9 |
1680 | 2022-01-05 17:17:58 | piano | 3 | 83667 | 1132 | 4.076 | 20526.7 |
1679 | 2022-01-05 06:50:47 | piano | 3 | 83667 | 1132 | 3.640 | 22985.4 |
1678 | 2022-01-04 14:22:30 | piano | 3 | 83667 | 1132 | 3.763 | 22234.1 |