History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cream"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1724 | 2024-04-19 05:07:43 | cream | 1 | 28756 | 9 | 2.076 | 13851.6 |
| 1723 | 2024-04-17 22:52:44 | cream | 2 | 53800 | 100 | 3.846 | 13988.6 |
| 1722 | 2024-04-16 14:54:41 | cream | 3 | 83667 | 1100 | 3.313 | 25254.2 |
| 1721 | 2024-04-03 06:08:30 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1720 | 2024-03-30 22:24:20 | cream | 2 | 53800 | 100 | 3.643 | 14768.0 |
| 1719 | 2024-03-30 22:09:25 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1718 | 2024-03-29 19:58:17 | cream | 3 | 83667 | 1100 | 9.530 | 8779.3 |
| 1717 | 2024-03-28 23:26:05 | cream | 3 | 83667 | 1100 | 4.186 | 19987.3 |
| 1716 | 2024-03-28 23:26:06 | cream | 2 | 53800 | 100 | 1.546 | 34799.5 |
| 1715 | 2024-03-28 23:26:00 | cream | 3 | 83667 | 1100 | 4.623 | 18098.0 |
| 1714 | 2024-03-28 23:26:02 | cream | 1 | 28756 | 9 | 1.000 | 28756.0 |
| 1713 | 2024-03-28 23:25:58 | cream | 2 | 53800 | 100 | 1.860 | 28924.7 |
| 1712 | 2024-03-28 23:25:26 | cream | 1 | 28756 | 9 | 1.080 | 26625.9 |
| 1711 | 2024-03-28 03:54:15 | cream | 1 | 28756 | 9 | 0.450 | 63902.2 |
| 1710 | 2024-03-15 05:01:36 | cream | 1 | 28756 | 9 | 0.720 | 39938.9 |
| 1709 | 2024-03-04 03:35:20 | cream | 3 | 83667 | 1100 | 4.423 | 18916.3 |
| 1708 | 2024-03-04 03:35:19 | cream | 2 | 53800 | 100 | 2.093 | 25704.7 |
| 1707 | 2024-03-04 00:56:49 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1706 | 2024-02-28 05:14:38 | cream | 3 | 83667 | 1100 | 6.360 | 13155.2 |
| 1705 | 2024-02-27 20:32:06 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1704 | 2024-02-27 13:17:01 | cream | 2 | 53800 | 100 | 1.703 | 31591.3 |
| 1703 | 2024-02-27 13:16:36 | cream | 3 | 83667 | 1100 | 4.186 | 19987.3 |
| 1702 | 2024-02-27 12:46:15 | cream | 3 | 83667 | 1100 | 3.610 | 23176.5 |
| 1701 | 2024-02-02 21:09:47 | cream | 1 | 28756 | 9 | 1.063 | 27051.7 |
| 1700 | 2024-01-30 14:45:52 | cream | 1 | 28756 | 9 | 0.470 | 61183.0 |
| 1699 | 2024-01-28 22:27:07 | cream | 1 | 28756 | 9 | 0.876 | 32826.5 |
| 1698 | 2024-01-28 18:52:41 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1697 | 2024-01-12 15:19:49 | cream | 3 | 83667 | 1100 | 3.753 | 22293.4 |
| 1696 | 2024-01-12 15:19:51 | cream | 2 | 53800 | 100 | 1.596 | 33709.3 |
| 1695 | 2023-12-15 19:23:08 | cream | 2 | 53800 | 100 | 1.420 | 37887.3 |
| 1694 | 2023-12-15 05:02:36 | cream | 3 | 83667 | 1100 | 3.906 | 21420.1 |
| 1693 | 2023-12-04 00:51:42 | cream | 1 | 28756 | 9 | 0.563 | 51076.4 |
| 1692 | 2023-12-02 08:19:26 | cream | 1 | 28756 | 9 | 0.560 | 51350.0 |
| 1691 | 2023-11-25 15:51:52 | cream | 3 | 83667 | 1100 | 3.563 | 23482.2 |
| 1690 | 2023-11-25 15:51:54 | cream | 2 | 53800 | 100 | 1.623 | 33148.5 |
| 1689 | 2023-11-25 06:59:50 | cream | 1 | 28756 | 9 | 0.876 | 32826.5 |
| 1688 | 2023-11-16 00:04:51 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1687 | 2023-11-09 21:47:37 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1686 | 2023-11-09 15:58:59 | cream | 1 | 28756 | 9 | 0.546 | 52666.7 |
| 1685 | 2023-10-23 23:57:04 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1684 | 2023-10-20 17:31:26 | cream | 3 | 83667 | 1100 | 4.703 | 17790.1 |
| 1683 | 2023-10-19 22:53:08 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1682 | 2023-10-17 22:23:24 | cream | 3 | 83667 | 1100 | 4.173 | 20049.6 |
| 1681 | 2023-10-14 16:22:26 | cream | 3 | 83667 | 1100 | 3.500 | 23904.9 |
| 1680 | 2023-10-11 14:53:42 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1679 | 2023-10-07 18:46:37 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1678 | 2023-10-05 23:50:01 | cream | 3 | 83667 | 1100 | 3.843 | 21771.3 |
| 1677 | 2023-09-27 18:22:18 | cream | 3 | 83667 | 1100 | 4.376 | 19119.5 |
| 1676 | 2023-09-27 17:19:51 | cream | 3 | 83667 | 1100 | 4.140 | 20209.4 |
| 1675 | 2023-09-25 21:52:38 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1674 | 2023-09-22 18:08:07 | cream | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 1673 | 2023-09-16 02:25:53 | cream | 2 | 53800 | 100 | 1.640 | 32804.9 |
| 1672 | 2023-09-15 11:09:13 | cream | 3 | 83667 | 1100 | 3.826 | 21868.0 |
| 1671 | 2023-09-12 02:31:27 | cream | 1 | 28756 | 9 | 0.486 | 59168.7 |
| 1670 | 2023-08-15 12:10:15 | cream | 3 | 83667 | 1100 | 3.440 | 24321.8 |
| 1669 | 2023-08-13 08:42:16 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1668 | 2023-07-15 18:51:43 | cream | 3 | 83667 | 1100 | 3.500 | 23904.9 |
| 1667 | 2023-06-28 14:21:45 | cream | 1 | 28756 | 9 | 0.470 | 61183.0 |
| 1666 | 2023-06-22 00:05:46 | cream | 3 | 83667 | 1100 | 3.360 | 24900.9 |
| 1665 | 2023-06-15 00:08:56 | cream | 2 | 53800 | 100 | 1.456 | 36950.5 |
| 1664 | 2023-06-13 14:44:05 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1663 | 2023-05-06 14:22:59 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1662 | 2023-05-02 06:46:07 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1661 | 2023-04-28 13:43:50 | cream | 1 | 28756 | 9 | 0.470 | 61183.0 |
| 1660 | 2023-03-30 12:21:10 | cream | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 1659 | 2023-03-27 00:10:08 | cream | 3 | 83667 | 1100 | 3.390 | 24680.5 |
| 1658 | 2023-03-20 04:51:22 | cream | 3 | 83667 | 1100 | 3.296 | 25384.4 |
| 1657 | 2023-03-16 16:04:19 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1656 | 2023-03-13 06:10:15 | cream | 2 | 53800 | 100 | 1.563 | 34421.0 |
| 1655 | 2023-02-21 08:19:29 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1654 | 2023-02-13 11:50:33 | cream | 3 | 83667 | 1100 | 3.360 | 24900.9 |
| 1653 | 2023-01-21 21:28:23 | cream | 1 | 28756 | 9 | 0.440 | 65354.5 |
| 1652 | 2023-01-16 05:45:50 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1651 | 2023-01-14 14:45:16 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1650 | 2023-01-13 04:30:48 | cream | 2 | 53800 | 100 | 1.393 | 38621.7 |
| 1649 | 2023-01-01 04:46:25 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1648 | 2022-12-25 09:53:16 | cream | 3 | 83667 | 1100 | 4.093 | 20441.5 |
| 1647 | 2022-12-20 19:31:26 | cream | 3 | 83667 | 1100 | 3.283 | 25484.9 |
| 1646 | 2022-12-17 11:50:52 | cream | 2 | 53800 | 100 | 1.360 | 39558.8 |
| 1645 | 2022-12-07 18:43:26 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1644 | 2022-11-29 01:02:34 | cream | 2 | 53800 | 100 | 1.656 | 32487.9 |
| 1643 | 2022-11-16 19:04:10 | cream | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 1642 | 2022-11-08 16:32:12 | cream | 3 | 83667 | 1100 | 3.423 | 24442.6 |
| 1641 | 2022-11-08 16:19:21 | cream | 3 | 83667 | 1100 | 3.983 | 21006.0 |
| 1640 | 2022-11-07 22:14:02 | cream | 3 | 83667 | 1100 | 7.186 | 11643.1 |
| 1639 | 2022-11-06 23:20:43 | cream | 2 | 53800 | 100 | 1.656 | 32487.9 |
| 1638 | 2022-11-02 00:28:08 | cream | 3 | 83667 | 1100 | 3.813 | 21942.6 |
| 1637 | 2022-11-01 05:56:43 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1636 | 2022-10-29 14:57:18 | cream | 3 | 83667 | 1100 | 3.406 | 24564.6 |
| 1635 | 2022-10-21 15:57:21 | cream | 1 | 28756 | 9 | 0.470 | 61183.0 |
| 1634 | 2022-10-05 02:27:04 | cream | 2 | 53800 | 100 | 1.610 | 33416.1 |
| 1633 | 2022-10-01 15:19:03 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1632 | 2022-09-28 14:29:28 | cream | 1 | 28756 | 9 | 0.576 | 49923.6 |
| 1631 | 2022-09-27 13:09:10 | cream | 2 | 53800 | 100 | 1.356 | 39675.5 |
| 1630 | 2022-09-24 18:30:42 | cream | 3 | 83667 | 1100 | 3.533 | 23681.6 |
| 1629 | 2022-09-08 04:07:52 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 1628 | 2022-09-02 00:45:47 | cream | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 1627 | 2022-08-19 04:34:03 | cream | 3 | 83667 | 1100 | 3.343 | 25027.5 |
| 1626 | 2022-08-18 05:57:27 | cream | 1 | 28756 | 9 | 0.440 | 65354.5 |
| 1625 | 2022-08-15 18:30:02 | cream | 1 | 28756 | 9 | 0.436 | 65954.1 |