History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"media"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1750 | 2024-04-30 11:51:35 | media | 1 | 28756 | 10 | 0.530 | 54256.6 |
1749 | 2024-04-29 14:45:57 | media | 1 | 28756 | 10 | 0.500 | 57512.0 |
1748 | 2024-04-28 14:20:48 | media | 1 | 28756 | 10 | 0.500 | 57512.0 |
1747 | 2024-04-27 17:07:00 | media | 1 | 28756 | 10 | 0.563 | 51076.4 |
1746 | 2024-04-19 15:31:48 | media | 3 | 83667 | 880 | 3.450 | 24251.3 |
1745 | 2024-04-08 12:12:53 | media | 3 | 83667 | 880 | 3.453 | 24230.2 |
1744 | 2024-04-05 21:20:22 | media | 3 | 83667 | 880 | 5.800 | 14425.3 |
1743 | 2024-04-05 18:49:48 | media | 3 | 83667 | 880 | 4.453 | 18788.9 |
1742 | 2024-04-02 20:42:13 | media | 1 | 28756 | 10 | 0.453 | 63479.0 |
1741 | 2024-04-02 18:52:39 | media | 2 | 53800 | 74 | 3.970 | 13551.6 |
1740 | 2024-04-01 12:58:52 | media | 2 | 53800 | 74 | 1.703 | 31591.3 |
1739 | 2024-03-31 18:04:00 | media | 3 | 83667 | 880 | 27.640 | 3027.0 |
1738 | 2024-03-31 09:54:09 | media | 3 | 83667 | 880 | 13.453 | 6219.2 |
1737 | 2024-03-31 06:48:53 | media | 3 | 83667 | 880 | 11.750 | 7120.6 |
1736 | 2024-03-31 06:48:52 | media | 2 | 53800 | 74 | 4.860 | 11070.0 |
1735 | 2024-03-31 06:44:07 | media | 1 | 28756 | 10 | 1.733 | 16593.2 |
1734 | 2024-03-29 08:51:35 | media | 1 | 28756 | 10 | 1.000 | 28756.0 |
1733 | 2024-03-02 18:20:40 | media | 3 | 83667 | 880 | 11.003 | 7604.0 |
1732 | 2024-03-02 18:20:43 | media | 2 | 53800 | 74 | 5.593 | 9619.2 |
1731 | 2024-03-02 18:20:34 | media | 1 | 28756 | 10 | 1.373 | 20943.9 |
1730 | 2024-03-01 05:00:49 | media | 1 | 28756 | 10 | 0.516 | 55728.7 |
1729 | 2024-02-28 13:25:20 | media | 2 | 53800 | 74 | 1.563 | 34421.0 |
1728 | 2024-02-28 13:25:00 | media | 3 | 83667 | 880 | 5.313 | 15747.6 |
1727 | 2024-02-28 07:15:24 | media | 3 | 83667 | 880 | 6.373 | 13128.4 |
1726 | 2024-02-28 07:15:22 | media | 2 | 53800 | 74 | 1.936 | 27789.3 |
1725 | 2024-02-28 07:15:19 | media | 1 | 28756 | 10 | 0.576 | 49923.6 |
1724 | 2024-02-18 12:32:47 | media | 3 | 83667 | 880 | 8.606 | 9721.9 |
1723 | 2024-02-16 09:23:59 | media | 3 | 83667 | 880 | 3.906 | 21420.1 |
1722 | 2024-01-29 06:53:37 | media | 1 | 28756 | 10 | 0.436 | 65954.1 |
1721 | 2024-01-29 03:40:23 | media | 1 | 28756 | 10 | 0.483 | 59536.2 |
1720 | 2024-01-16 03:46:32 | media | 3 | 83667 | 880 | 5.250 | 15936.6 |
1719 | 2024-01-14 06:01:09 | media | 2 | 53800 | 74 | 1.656 | 32487.9 |
1718 | 2024-01-12 10:35:06 | media | 3 | 83667 | 880 | 3.296 | 25384.4 |
1717 | 2024-01-07 09:38:37 | media | 1 | 28756 | 10 | 0.453 | 63479.0 |
1716 | 2023-12-22 23:38:47 | media | 1 | 28756 | 10 | 0.436 | 65954.1 |
1715 | 2023-12-18 13:07:53 | media | 3 | 83667 | 880 | 3.906 | 21420.1 |
1714 | 2023-12-18 13:07:54 | media | 2 | 53800 | 74 | 1.720 | 31279.1 |
1713 | 2023-12-18 08:07:02 | media | 1 | 28756 | 10 | 0.436 | 65954.1 |
1712 | 2023-12-04 19:39:27 | media | 2 | 53800 | 74 | 1.423 | 37807.4 |
1711 | 2023-11-30 07:40:22 | media | 3 | 83667 | 880 | 3.296 | 25384.4 |
1710 | 2023-11-26 03:56:47 | media | 1 | 28756 | 10 | 0.466 | 61708.2 |
1709 | 2023-11-19 22:55:33 | media | 1 | 28756 | 10 | 0.420 | 68466.7 |
1708 | 2023-11-18 10:15:55 | media | 1 | 28756 | 10 | 0.986 | 29164.3 |
1707 | 2023-11-18 03:09:59 | media | 2 | 53800 | 74 | 1.623 | 33148.5 |
1706 | 2023-11-18 03:09:55 | media | 3 | 83667 | 880 | 3.546 | 23594.8 |
1705 | 2023-11-18 02:14:25 | media | 3 | 83667 | 880 | 6.516 | 12840.2 |
1704 | 2023-11-14 18:42:49 | media | 1 | 28756 | 10 | 0.533 | 53951.2 |
1703 | 2023-11-11 22:07:00 | media | 1 | 28756 | 10 | 0.500 | 57512.0 |
1702 | 2023-11-03 18:18:03 | media | 1 | 28756 | 10 | 0.530 | 54256.6 |
1701 | 2023-10-31 19:25:19 | media | 1 | 28756 | 10 | 0.513 | 56054.6 |
1700 | 2023-10-21 14:41:41 | media | 1 | 28756 | 10 | 0.500 | 57512.0 |
1699 | 2023-10-18 19:58:27 | media | 1 | 28756 | 10 | 0.500 | 57512.0 |
1698 | 2023-10-14 06:02:15 | media | 1 | 28756 | 10 | 0.486 | 59168.7 |
1697 | 2023-10-05 01:35:21 | media | 1 | 28756 | 10 | 0.440 | 65354.5 |
1696 | 2023-10-02 15:59:26 | media | 1 | 28756 | 10 | 0.466 | 61708.2 |
1695 | 2023-09-29 07:12:46 | media | 1 | 28756 | 10 | 0.516 | 55728.7 |
1694 | 2023-09-26 07:06:36 | media | 1 | 28756 | 10 | 0.420 | 68466.7 |
1693 | 2023-09-01 14:35:10 | media | 2 | 53800 | 74 | 1.373 | 39184.3 |
1692 | 2023-08-26 09:49:43 | media | 1 | 28756 | 10 | 0.420 | 68466.7 |
1691 | 2023-08-24 13:19:19 | media | 1 | 28756 | 10 | 0.483 | 59536.2 |
1690 | 2023-08-19 14:17:08 | media | 3 | 83667 | 880 | 3.280 | 25508.2 |
1689 | 2023-08-15 07:16:15 | media | 3 | 83667 | 880 | 4.126 | 20278.0 |
1688 | 2023-08-03 05:55:37 | media | 1 | 28756 | 10 | 1.063 | 27051.7 |
1687 | 2023-06-23 07:21:29 | media | 3 | 83667 | 880 | 3.326 | 25155.4 |
1686 | 2023-06-20 00:27:19 | media | 3 | 83667 | 880 | 3.296 | 25384.4 |
1685 | 2023-06-16 15:32:04 | media | 3 | 83667 | 880 | 3.716 | 22515.3 |
1684 | 2023-05-26 20:36:43 | media | 1 | 28756 | 10 | 0.466 | 61708.2 |
1683 | 2023-05-15 22:11:40 | media | 2 | 53800 | 74 | 1.343 | 40059.6 |
1682 | 2023-05-13 04:42:01 | media | 3 | 83667 | 880 | 3.596 | 23266.7 |
1681 | 2023-05-06 07:55:39 | media | 3 | 83667 | 880 | 3.250 | 25743.7 |
1680 | 2023-05-01 12:25:10 | media | 3 | 83667 | 880 | 3.326 | 25155.4 |
1679 | 2023-04-25 18:59:40 | media | 1 | 28756 | 10 | 0.436 | 65954.1 |
1678 | 2023-04-02 21:37:48 | media | 3 | 83667 | 880 | 3.500 | 23904.9 |
1677 | 2023-03-21 08:59:49 | media | 1 | 28756 | 10 | 0.436 | 65954.1 |
1676 | 2023-03-10 23:49:24 | media | 3 | 83667 | 880 | 3.453 | 24230.2 |
1675 | 2023-02-25 16:33:22 | media | 2 | 53800 | 74 | 1.356 | 39675.5 |
1674 | 2023-02-10 08:11:46 | media | 3 | 83667 | 880 | 3.940 | 21235.3 |
1673 | 2023-02-09 16:36:23 | media | 3 | 83667 | 880 | 3.750 | 22311.2 |
1672 | 2023-01-17 03:54:23 | media | 3 | 83667 | 880 | 4.093 | 20441.5 |
1671 | 2023-01-13 10:32:29 | media | 1 | 28756 | 10 | 0.486 | 59168.7 |
1670 | 2023-01-09 16:27:31 | media | 1 | 28756 | 10 | 0.423 | 67981.1 |
1669 | 2023-01-08 01:13:16 | media | 1 | 28756 | 10 | 0.483 | 59536.2 |
1668 | 2022-12-22 05:13:39 | media | 3 | 83667 | 880 | 3.470 | 24111.5 |
1667 | 2022-12-05 01:47:15 | media | 2 | 53800 | 74 | 1.626 | 33087.3 |
1666 | 2022-12-03 05:12:58 | media | 3 | 83667 | 880 | 7.373 | 11347.8 |
1665 | 2022-11-26 13:35:38 | media | 3 | 83667 | 880 | 3.686 | 22698.6 |
1664 | 2022-11-22 14:50:29 | media | 3 | 83667 | 880 | 3.876 | 21585.9 |
1663 | 2022-11-05 06:06:34 | media | 3 | 83667 | 880 | 3.200 | 26145.9 |
1662 | 2022-10-27 14:37:54 | media | 3 | 83667 | 880 | 3.843 | 21771.3 |
1661 | 2022-10-24 01:05:34 | media | 3 | 83667 | 880 | 3.216 | 26015.9 |
1660 | 2022-10-17 07:39:24 | media | 3 | 83667 | 880 | 3.656 | 22884.8 |
1659 | 2022-10-05 20:04:26 | media | 1 | 28756 | 10 | 0.546 | 52666.7 |
1658 | 2022-09-25 21:38:13 | media | 1 | 28756 | 10 | 0.453 | 63479.0 |
1657 | 2022-09-21 11:50:50 | media | 3 | 83667 | 880 | 3.220 | 25983.5 |
1656 | 2022-09-18 11:50:11 | media | 1 | 28756 | 10 | 0.436 | 65954.1 |
1655 | 2022-09-17 19:50:17 | media | 1 | 28756 | 10 | 0.423 | 67981.1 |
1654 | 2022-09-09 11:29:06 | media | 1 | 28756 | 10 | 0.436 | 65954.1 |
1653 | 2022-09-03 06:53:12 | media | 3 | 83667 | 880 | 3.643 | 22966.5 |
1652 | 2022-09-01 20:47:01 | media | 2 | 53800 | 74 | 1.546 | 34799.5 |
1651 | 2022-08-22 23:16:23 | media | 1 | 28756 | 10 | 0.500 | 57512.0 |