History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pale"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1744 | 2024-04-19 00:41:42 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1743 | 2024-04-05 00:22:32 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1742 | 2024-03-31 00:26:15 | pale | 1 | 13983 | 38 | 1.126 | 12418.3 |
| 1741 | 2024-03-29 05:34:45 | pale | 1 | 13983 | 38 | 0.280 | 49939.3 |
| 1740 | 2024-03-05 20:42:26 | pale | 1 | 13983 | 38 | 0.843 | 16587.2 |
| 1739 | 2024-02-28 02:05:39 | pale | 1 | 13983 | 38 | 0.263 | 53167.3 |
| 1738 | 2024-02-25 17:03:35 | pale | 1 | 13983 | 38 | 0.563 | 24836.6 |
| 1737 | 2024-02-07 14:24:01 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1736 | 2024-02-02 12:20:29 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1735 | 2024-01-29 17:05:06 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1734 | 2024-01-27 05:29:14 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1733 | 2024-01-25 19:20:45 | pale | 1 | 13983 | 38 | 0.516 | 27098.8 |
| 1732 | 2024-01-12 05:52:19 | pale | 1 | 13983 | 38 | 0.236 | 59250.0 |
| 1731 | 2023-12-20 22:48:06 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1730 | 2023-12-07 10:51:26 | pale | 2 | 29872 | 521 | 0.876 | 34100.5 |
| 1729 | 2023-11-11 17:19:26 | pale | 2 | 29872 | 521 | 0.750 | 39829.3 |
| 1728 | 2023-11-11 04:47:38 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1727 | 2023-11-10 15:39:13 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1726 | 2023-11-07 12:36:43 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1725 | 2023-11-02 02:57:42 | pale | 2 | 29872 | 521 | 0.860 | 34734.9 |
| 1724 | 2023-11-01 21:39:51 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1723 | 2023-11-01 16:00:45 | pale | 2 | 29872 | 521 | 0.763 | 39150.7 |
| 1722 | 2023-10-28 15:07:46 | pale | 2 | 29872 | 521 | 0.766 | 38997.4 |
| 1721 | 2023-10-26 16:29:45 | pale | 1 | 13983 | 38 | 0.296 | 47239.9 |
| 1720 | 2023-10-26 01:29:16 | pale | 1 | 13983 | 38 | 0.563 | 24836.6 |
| 1719 | 2023-10-20 20:23:52 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1718 | 2023-10-19 20:54:24 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1717 | 2023-10-18 07:07:32 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1716 | 2023-10-17 15:08:00 | pale | 1 | 13983 | 38 | 0.530 | 26383.0 |
| 1715 | 2023-10-12 00:03:56 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1714 | 2023-10-03 16:25:02 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1713 | 2023-09-24 02:20:22 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1712 | 2023-09-22 03:40:07 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1711 | 2023-09-02 03:51:50 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1710 | 2023-08-28 17:46:13 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1709 | 2023-08-13 09:53:29 | pale | 2 | 29872 | 521 | 0.906 | 32971.3 |
| 1708 | 2023-08-07 19:57:25 | pale | 2 | 29872 | 521 | 0.856 | 34897.2 |
| 1707 | 2023-07-12 16:15:34 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1706 | 2023-05-25 09:24:25 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1705 | 2023-04-08 21:10:23 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1704 | 2023-03-20 06:49:03 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1703 | 2023-01-07 09:48:54 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1702 | 2023-01-07 07:53:45 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1701 | 2023-01-03 16:01:56 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1700 | 2022-12-29 16:07:15 | pale | 1 | 13983 | 38 | 0.263 | 53167.3 |
| 1699 | 2022-12-27 03:31:55 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1698 | 2022-12-24 22:54:39 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1697 | 2022-11-09 12:08:19 | pale | 1 | 13983 | 38 | 0.296 | 47239.9 |
| 1696 | 2022-10-06 03:49:53 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1695 | 2022-10-05 09:45:27 | pale | 1 | 13983 | 38 | 0.203 | 68881.8 |
| 1694 | 2022-10-04 19:42:07 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1693 | 2022-10-03 08:41:20 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1692 | 2022-10-02 03:13:53 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1691 | 2022-10-01 05:57:54 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1690 | 2022-09-30 14:45:19 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1689 | 2022-09-29 16:58:06 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1688 | 2022-09-29 08:18:25 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1687 | 2022-09-28 05:29:31 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1686 | 2022-09-27 06:36:34 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1685 | 2022-09-26 14:07:09 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1684 | 2022-09-25 10:02:02 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1683 | 2022-09-24 05:52:28 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1682 | 2022-09-23 15:03:04 | pale | 1 | 13983 | 38 | 0.236 | 59250.0 |
| 1681 | 2022-09-23 06:23:10 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1680 | 2022-09-22 05:57:59 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1679 | 2022-09-21 22:27:09 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1678 | 2022-09-20 06:30:53 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1677 | 2022-09-19 07:40:00 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1676 | 2022-09-18 23:26:44 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1675 | 2022-09-17 03:38:52 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1674 | 2022-08-14 06:42:41 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1673 | 2022-08-05 23:10:38 | pale | 1 | 13983 | 38 | 0.280 | 49939.3 |
| 1672 | 2022-07-30 06:37:26 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1671 | 2022-07-29 10:41:33 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1670 | 2022-07-03 12:54:55 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1669 | 2022-06-16 12:54:29 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1668 | 2022-06-08 18:23:43 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1667 | 2022-06-06 15:51:13 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1666 | 2022-06-01 14:36:32 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1665 | 2022-05-25 18:19:32 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1664 | 2022-05-15 14:34:25 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1663 | 2022-02-26 17:18:01 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1662 | 2022-01-28 01:37:53 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1661 | 2022-01-03 17:16:38 | pale | 1 | 13983 | 38 | 0.283 | 49409.9 |
| 1660 | 2021-12-02 20:43:18 | pale | 1 | 13983 | 38 | 0.313 | 44674.1 |
| 1659 | 2021-12-01 19:59:41 | pale | 1 | 13983 | 38 | 0.266 | 52567.7 |
| 1658 | 2021-11-29 18:47:08 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1657 | 2021-11-29 14:17:35 | pale | 1 | 13983 | 38 | 0.233 | 60012.9 |
| 1656 | 2021-11-27 12:00:46 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1655 | 2021-11-25 06:06:42 | pale | 1 | 13983 | 38 | 0.236 | 59250.0 |
| 1654 | 2021-11-21 19:23:34 | pale | 1 | 13983 | 38 | 0.516 | 27098.8 |
| 1653 | 2021-10-09 02:44:32 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1652 | 2021-09-22 16:04:50 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1651 | 2021-09-21 08:04:38 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1650 | 2021-09-20 14:42:07 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |
| 1649 | 2021-09-19 11:52:55 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1648 | 2021-09-07 01:50:19 | pale | 1 | 13983 | 38 | 0.250 | 55932.0 |
| 1647 | 2021-09-04 20:43:35 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1646 | 2021-08-18 22:41:59 | pale | 1 | 13983 | 38 | 0.220 | 63559.1 |
| 1645 | 2021-08-18 07:10:56 | pale | 1 | 13983 | 38 | 0.216 | 64736.1 |