History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"items"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1744 | 2024-04-28 08:52:52 | items | 1 | 28756 | 3 | 1.013 | 28387.0 |
1743 | 2024-04-27 17:49:14 | items | 2 | 53800 | 73 | 4.156 | 12945.1 |
1742 | 2024-04-18 20:48:11 | items | 1 | 28756 | 3 | 0.453 | 63479.0 |
1741 | 2024-04-06 11:18:06 | items | 1 | 28756 | 3 | 1.233 | 23322.0 |
1740 | 2024-04-05 05:40:00 | items | 1 | 28756 | 3 | 1.140 | 25224.6 |
1739 | 2024-04-04 01:58:57 | items | 1 | 28756 | 3 | 1.033 | 27837.4 |
1738 | 2024-03-31 03:20:17 | items | 1 | 28756 | 3 | 0.516 | 55728.7 |
1737 | 2024-03-28 16:06:01 | items | 3 | 83667 | 1464 | 3.970 | 21074.8 |
1736 | 2024-03-26 22:10:05 | items | 1 | 28756 | 3 | 0.563 | 51076.4 |
1735 | 2024-03-19 17:20:21 | items | 2 | 53800 | 73 | 1.533 | 35094.6 |
1734 | 2024-03-19 17:19:41 | items | 3 | 83667 | 1464 | 4.063 | 20592.4 |
1733 | 2024-03-18 07:08:27 | items | 2 | 53800 | 73 | 1.563 | 34421.0 |
1732 | 2024-03-18 07:07:12 | items | 3 | 83667 | 1464 | 4.343 | 19264.8 |
1731 | 2024-03-18 06:12:13 | items | 3 | 83667 | 1464 | 3.953 | 21165.4 |
1730 | 2024-03-08 03:58:13 | items | 3 | 83667 | 1464 | 5.860 | 14277.6 |
1729 | 2024-03-07 08:31:18 | items | 2 | 53800 | 73 | 3.813 | 14109.6 |
1728 | 2024-03-07 08:31:11 | items | 3 | 83667 | 1464 | 4.826 | 17336.7 |
1727 | 2024-03-07 06:09:56 | items | 1 | 28756 | 3 | 1.063 | 27051.7 |
1726 | 2024-02-25 18:29:14 | items | 1 | 28756 | 3 | 0.516 | 55728.7 |
1725 | 2024-02-04 23:08:40 | items | 3 | 83667 | 1464 | 6.076 | 13770.1 |
1724 | 2024-02-04 21:03:51 | items | 3 | 83667 | 1464 | 4.533 | 18457.3 |
1723 | 2024-02-03 19:41:55 | items | 1 | 28756 | 3 | 0.860 | 33437.2 |
1722 | 2024-01-26 10:30:04 | items | 1 | 28756 | 3 | 0.533 | 53951.2 |
1721 | 2024-01-24 11:31:38 | items | 1 | 28756 | 3 | 0.483 | 59536.2 |
1720 | 2024-01-11 06:35:52 | items | 3 | 83667 | 1464 | 3.593 | 23286.1 |
1719 | 2024-01-11 06:35:53 | items | 2 | 53800 | 73 | 1.560 | 34487.2 |
1718 | 2024-01-07 05:00:50 | items | 3 | 83667 | 1464 | 3.500 | 23904.9 |
1717 | 2024-01-07 05:00:45 | items | 2 | 53800 | 73 | 1.626 | 33087.3 |
1716 | 2024-01-02 22:13:35 | items | 3 | 83667 | 1464 | 3.890 | 21508.2 |
1715 | 2023-12-29 13:45:31 | items | 1 | 28756 | 3 | 0.483 | 59536.2 |
1714 | 2023-11-27 06:15:02 | items | 1 | 28756 | 3 | 0.533 | 53951.2 |
1713 | 2023-11-22 22:54:08 | items | 1 | 28756 | 3 | 1.093 | 26309.2 |
1712 | 2023-11-19 16:07:26 | items | 3 | 83667 | 1464 | 3.640 | 22985.4 |
1711 | 2023-11-17 14:36:23 | items | 1 | 28756 | 3 | 0.436 | 65954.1 |
1710 | 2023-11-14 16:35:09 | items | 1 | 28756 | 3 | 0.423 | 67981.1 |
1709 | 2023-11-05 17:57:58 | items | 1 | 28756 | 3 | 0.486 | 59168.7 |
1708 | 2023-11-02 14:07:02 | items | 3 | 83667 | 1464 | 8.123 | 10300.0 |
1707 | 2023-10-30 17:33:23 | items | 2 | 53800 | 73 | 3.423 | 15717.2 |
1706 | 2023-10-30 17:33:21 | items | 3 | 83667 | 1464 | 4.236 | 19751.4 |
1705 | 2023-10-25 23:24:21 | items | 1 | 28756 | 3 | 0.466 | 61708.2 |
1704 | 2023-10-22 11:44:02 | items | 1 | 28756 | 3 | 0.483 | 59536.2 |
1703 | 2023-10-17 09:26:34 | items | 1 | 28756 | 3 | 0.513 | 56054.6 |
1702 | 2023-10-16 19:34:57 | items | 3 | 83667 | 1464 | 3.720 | 22491.1 |
1701 | 2023-10-15 14:18:42 | items | 3 | 83667 | 1464 | 3.516 | 23796.1 |
1700 | 2023-10-13 17:14:05 | items | 1 | 28756 | 3 | 0.610 | 47141.0 |
1699 | 2023-10-07 18:23:52 | items | 1 | 28756 | 3 | 0.530 | 54256.6 |
1698 | 2023-09-26 21:25:14 | items | 1 | 28756 | 3 | 0.470 | 61183.0 |
1697 | 2023-09-14 10:13:23 | items | 1 | 28756 | 3 | 0.423 | 67981.1 |
1696 | 2023-09-08 01:39:53 | items | 1 | 28756 | 3 | 0.420 | 68466.7 |
1695 | 2023-09-06 13:42:14 | items | 1 | 28756 | 3 | 0.436 | 65954.1 |
1694 | 2023-09-01 14:52:21 | items | 3 | 83667 | 1464 | 3.390 | 24680.5 |
1693 | 2023-08-17 12:47:24 | items | 3 | 83667 | 1464 | 3.686 | 22698.6 |
1692 | 2023-08-14 05:35:26 | items | 3 | 83667 | 1464 | 4.000 | 20916.8 |
1691 | 2023-08-08 23:20:09 | items | 3 | 83667 | 1464 | 3.360 | 24900.9 |
1690 | 2023-08-06 22:32:49 | items | 3 | 83667 | 1464 | 3.956 | 21149.4 |
1689 | 2023-06-14 11:18:56 | items | 1 | 28756 | 3 | 0.470 | 61183.0 |
1688 | 2023-05-20 18:01:36 | items | 1 | 28756 | 3 | 0.436 | 65954.1 |
1687 | 2023-03-31 04:19:25 | items | 1 | 28756 | 3 | 0.470 | 61183.0 |
1686 | 2023-02-03 22:31:33 | items | 1 | 28756 | 3 | 0.516 | 55728.7 |
1685 | 2023-02-02 00:45:43 | items | 3 | 83667 | 1464 | 3.360 | 24900.9 |
1684 | 2023-01-13 04:36:32 | items | 1 | 28756 | 3 | 0.420 | 68466.7 |
1683 | 2022-12-17 05:41:05 | items | 3 | 83667 | 1464 | 3.406 | 24564.6 |
1682 | 2022-12-11 13:20:39 | items | 3 | 83667 | 1464 | 3.906 | 21420.1 |
1681 | 2022-12-06 23:26:56 | items | 3 | 83667 | 1464 | 3.373 | 24804.9 |
1680 | 2022-11-16 18:01:46 | items | 3 | 83667 | 1464 | 3.796 | 22040.8 |
1679 | 2022-11-10 22:27:49 | items | 3 | 83667 | 1464 | 3.360 | 24900.9 |
1678 | 2022-11-01 20:56:20 | items | 3 | 83667 | 1464 | 4.096 | 20426.5 |
1677 | 2022-11-01 08:27:52 | items | 1 | 28756 | 3 | 0.453 | 63479.0 |
1676 | 2022-10-17 20:26:41 | items | 3 | 83667 | 1464 | 3.280 | 25508.2 |
1675 | 2022-10-17 11:34:21 | items | 1 | 28756 | 3 | 0.470 | 61183.0 |
1674 | 2022-10-08 02:43:43 | items | 3 | 83667 | 1464 | 3.390 | 24680.5 |
1673 | 2022-10-01 14:51:35 | items | 3 | 83667 | 1464 | 3.296 | 25384.4 |
1672 | 2022-09-12 04:42:48 | items | 1 | 28756 | 3 | 0.500 | 57512.0 |
1671 | 2022-08-26 03:07:41 | items | 3 | 83667 | 1464 | 3.313 | 25254.2 |
1670 | 2022-08-07 00:50:00 | items | 1 | 28756 | 3 | 0.436 | 65954.1 |
1669 | 2022-07-30 02:09:42 | items | 1 | 28756 | 3 | 0.423 | 67981.1 |
1668 | 2022-07-19 15:21:29 | items | 3 | 83667 | 1464 | 3.623 | 23093.3 |
1667 | 2022-07-17 22:08:43 | items | 1 | 28756 | 3 | 0.606 | 47452.1 |
1666 | 2022-07-17 17:30:31 | items | 1 | 28756 | 3 | 0.453 | 63479.0 |
1665 | 2022-07-16 02:45:48 | items | 2 | 53800 | 73 | 1.373 | 39184.3 |
1664 | 2022-07-11 09:28:20 | items | 3 | 83667 | 1464 | 3.703 | 22594.4 |
1663 | 2022-07-01 01:24:46 | items | 1 | 28756 | 3 | 0.440 | 65354.5 |
1662 | 2022-06-29 03:19:08 | items | 3 | 83667 | 1464 | 3.983 | 21006.0 |
1661 | 2022-06-28 03:14:15 | items | 3 | 83667 | 1464 | 3.580 | 23370.7 |
1660 | 2022-06-27 04:02:51 | items | 3 | 83667 | 1464 | 3.873 | 21602.6 |
1659 | 2022-06-25 04:37:15 | items | 3 | 83667 | 1464 | 3.486 | 24000.9 |
1658 | 2022-06-23 18:29:33 | items | 3 | 83667 | 1464 | 3.343 | 25027.5 |
1657 | 2022-06-23 03:48:00 | items | 3 | 83667 | 1464 | 3.953 | 21165.4 |
1656 | 2022-06-22 02:56:43 | items | 3 | 83667 | 1464 | 3.860 | 21675.4 |
1655 | 2022-06-21 06:23:23 | items | 3 | 83667 | 1464 | 4.373 | 19132.6 |
1654 | 2022-06-20 23:55:08 | items | 1 | 28756 | 3 | 0.483 | 59536.2 |
1653 | 2022-06-20 19:33:42 | items | 3 | 83667 | 1464 | 3.940 | 21235.3 |
1652 | 2022-06-19 03:53:52 | items | 3 | 83667 | 1464 | 4.233 | 19765.4 |
1651 | 2022-06-18 11:32:12 | items | 3 | 83667 | 1464 | 3.610 | 23176.5 |
1650 | 2022-06-17 10:53:39 | items | 3 | 83667 | 1464 | 3.686 | 22698.6 |
1649 | 2022-06-15 12:28:06 | items | 3 | 83667 | 1464 | 3.733 | 22412.8 |
1648 | 2022-06-13 21:17:47 | items | 3 | 83667 | 1464 | 4.280 | 19548.4 |
1647 | 2022-06-13 16:20:12 | items | 3 | 83667 | 1464 | 3.360 | 24900.9 |
1646 | 2022-06-12 20:53:42 | items | 3 | 83667 | 1464 | 3.873 | 21602.6 |
1645 | 2022-05-05 22:53:20 | items | 3 | 83667 | 1464 | 3.763 | 22234.1 |