History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rice"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1693 | 2024-04-20 18:36:09 | rice | 1 | 13983 | 27 | 0.423 | 33056.7 |
1692 | 2024-04-20 18:35:53 | rice | 2 | 29872 | 350 | 3.376 | 8848.3 |
1691 | 2024-04-20 18:35:46 | rice | 1 | 13983 | 27 | 0.953 | 14672.6 |
1690 | 2024-04-19 08:54:09 | rice | 1 | 13983 | 27 | 0.236 | 59250.0 |
1689 | 2024-04-18 17:12:19 | rice | 2 | 29872 | 350 | 2.093 | 14272.3 |
1688 | 2024-04-12 15:51:31 | rice | 1 | 13983 | 27 | 0.266 | 52567.7 |
1687 | 2024-04-12 15:18:40 | rice | 1 | 13983 | 27 | 0.846 | 16528.4 |
1686 | 2024-04-08 19:57:08 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1685 | 2024-04-04 22:51:48 | rice | 1 | 13983 | 27 | 0.563 | 24836.6 |
1684 | 2024-03-31 00:49:51 | rice | 2 | 29872 | 350 | 1.046 | 28558.3 |
1683 | 2024-03-30 23:12:13 | rice | 1 | 13983 | 27 | 0.500 | 27966.0 |
1682 | 2024-03-20 02:24:24 | rice | 1 | 13983 | 27 | 0.263 | 53167.3 |
1681 | 2024-03-11 14:54:21 | rice | 1 | 13983 | 27 | 0.280 | 49939.3 |
1680 | 2024-03-05 20:31:44 | rice | 1 | 13983 | 27 | 0.856 | 16335.3 |
1679 | 2024-03-05 10:31:00 | rice | 1 | 13983 | 27 | 0.263 | 53167.3 |
1678 | 2024-03-02 18:11:01 | rice | 2 | 29872 | 350 | 3.280 | 9107.3 |
1677 | 2024-03-02 17:36:39 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1676 | 2024-02-25 16:24:59 | rice | 1 | 13983 | 27 | 0.266 | 52567.7 |
1675 | 2024-02-18 20:23:18 | rice | 1 | 13983 | 27 | 0.550 | 25423.6 |
1674 | 2024-02-10 22:57:53 | rice | 1 | 13983 | 27 | 0.876 | 15962.3 |
1673 | 2024-01-28 15:52:51 | rice | 1 | 13983 | 27 | 0.233 | 60012.9 |
1672 | 2024-01-26 20:09:37 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1671 | 2024-01-18 11:13:53 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1670 | 2024-01-03 10:05:51 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1669 | 2023-12-27 01:28:40 | rice | 1 | 13983 | 27 | 0.203 | 68881.8 |
1668 | 2023-12-16 04:03:34 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1667 | 2023-11-26 18:04:15 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1666 | 2023-11-25 05:26:08 | rice | 1 | 13983 | 27 | 0.236 | 59250.0 |
1665 | 2023-11-24 01:21:47 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1664 | 2023-11-20 18:18:03 | rice | 1 | 13983 | 27 | 0.236 | 59250.0 |
1663 | 2023-11-20 13:46:40 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1662 | 2023-11-16 07:20:48 | rice | 2 | 29872 | 350 | 0.970 | 30795.9 |
1661 | 2023-11-09 04:50:58 | rice | 2 | 29872 | 350 | 0.813 | 36742.9 |
1660 | 2023-11-08 12:06:39 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1659 | 2023-11-08 00:27:30 | rice | 2 | 29872 | 350 | 0.780 | 38297.4 |
1658 | 2023-11-07 23:14:40 | rice | 1 | 13983 | 27 | 0.233 | 60012.9 |
1657 | 2023-11-07 07:37:12 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1656 | 2023-11-06 15:29:58 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1655 | 2023-10-27 05:12:29 | rice | 2 | 29872 | 350 | 1.000 | 29872.0 |
1654 | 2023-10-25 20:06:45 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1653 | 2023-10-24 21:46:54 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1652 | 2023-10-19 16:36:03 | rice | 2 | 29872 | 350 | 0.860 | 34734.9 |
1651 | 2023-10-19 14:11:52 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1650 | 2023-10-16 20:11:30 | rice | 2 | 29872 | 350 | 0.856 | 34897.2 |
1649 | 2023-10-16 18:11:20 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1648 | 2023-10-11 04:34:15 | rice | 2 | 29872 | 350 | 0.810 | 36879.0 |
1647 | 2023-10-10 09:58:41 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1646 | 2023-10-04 07:09:51 | rice | 2 | 29872 | 350 | 0.893 | 33451.3 |
1645 | 2023-10-03 08:49:20 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1644 | 2023-09-25 13:57:18 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1643 | 2023-09-23 15:39:27 | rice | 2 | 29872 | 350 | 0.936 | 31914.5 |
1642 | 2023-09-18 23:08:43 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1641 | 2023-09-12 08:12:52 | rice | 2 | 29872 | 350 | 0.780 | 38297.4 |
1640 | 2023-09-10 12:47:22 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1639 | 2023-08-19 11:07:38 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1638 | 2023-08-04 03:52:07 | rice | 1 | 13983 | 27 | 0.203 | 68881.8 |
1637 | 2023-07-23 10:11:21 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1636 | 2023-07-16 19:47:41 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1635 | 2023-07-04 21:04:55 | rice | 2 | 29872 | 350 | 0.953 | 31345.2 |
1634 | 2023-07-03 23:43:36 | rice | 2 | 29872 | 350 | 0.906 | 32971.3 |
1633 | 2023-07-02 20:17:21 | rice | 2 | 29872 | 350 | 0.860 | 34734.9 |
1632 | 2023-07-01 19:50:16 | rice | 2 | 29872 | 350 | 0.876 | 34100.5 |
1631 | 2023-06-27 19:46:42 | rice | 2 | 29872 | 350 | 0.936 | 31914.5 |
1630 | 2023-06-25 20:13:00 | rice | 2 | 29872 | 350 | 0.903 | 33080.8 |
1629 | 2023-06-24 19:28:42 | rice | 2 | 29872 | 350 | 0.890 | 33564.0 |
1628 | 2023-06-22 19:40:08 | rice | 2 | 29872 | 350 | 0.860 | 34734.9 |
1627 | 2023-06-21 19:03:14 | rice | 2 | 29872 | 350 | 0.966 | 30923.4 |
1626 | 2023-06-20 20:41:39 | rice | 2 | 29872 | 350 | 0.860 | 34734.9 |
1625 | 2023-06-19 20:07:06 | rice | 2 | 29872 | 350 | 0.860 | 34734.9 |
1624 | 2023-06-18 19:59:37 | rice | 2 | 29872 | 350 | 0.763 | 39150.7 |
1623 | 2023-06-16 20:41:48 | rice | 2 | 29872 | 350 | 0.796 | 37527.6 |
1622 | 2023-06-15 10:52:00 | rice | 2 | 29872 | 350 | 0.936 | 31914.5 |
1621 | 2023-06-14 14:17:12 | rice | 2 | 29872 | 350 | 0.876 | 34100.5 |
1620 | 2023-06-13 21:39:31 | rice | 2 | 29872 | 350 | 0.920 | 32469.6 |
1619 | 2023-06-09 20:31:46 | rice | 2 | 29872 | 350 | 0.750 | 39829.3 |
1618 | 2023-06-08 23:36:31 | rice | 2 | 29872 | 350 | 0.860 | 34734.9 |
1617 | 2023-05-20 09:40:54 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1616 | 2023-04-26 16:29:19 | rice | 1 | 13983 | 27 | 0.236 | 59250.0 |
1615 | 2023-03-15 22:18:50 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1614 | 2023-03-12 12:07:50 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1613 | 2023-01-17 08:35:34 | rice | 1 | 13983 | 27 | 0.216 | 64736.1 |
1612 | 2023-01-14 08:00:03 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1611 | 2022-12-02 00:06:17 | rice | 2 | 29872 | 350 | 0.920 | 32469.6 |
1610 | 2022-11-27 20:41:10 | rice | 2 | 29872 | 350 | 0.766 | 38997.4 |
1609 | 2022-11-24 19:09:02 | rice | 1 | 13983 | 27 | 0.236 | 59250.0 |
1608 | 2022-10-25 21:00:28 | rice | 2 | 29872 | 350 | 0.923 | 32364.0 |
1607 | 2022-10-21 20:23:41 | rice | 2 | 29872 | 350 | 0.830 | 35990.4 |
1606 | 2022-09-30 08:35:07 | rice | 1 | 13983 | 27 | 0.436 | 32071.1 |
1605 | 2022-09-19 17:48:46 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1604 | 2022-09-19 14:51:54 | rice | 2 | 29872 | 350 | 0.766 | 38997.4 |
1603 | 2022-09-18 13:16:06 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1602 | 2022-09-16 05:12:06 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1601 | 2022-09-09 11:51:04 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1600 | 2022-09-03 19:49:36 | rice | 1 | 13983 | 27 | 0.203 | 68881.8 |
1599 | 2022-09-03 12:13:21 | rice | 1 | 13983 | 27 | 0.220 | 63559.1 |
1598 | 2022-09-02 09:34:04 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1597 | 2022-09-01 21:57:43 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |
1596 | 2022-08-31 12:09:09 | rice | 1 | 13983 | 27 | 0.233 | 60012.9 |
1595 | 2022-08-22 11:20:58 | rice | 2 | 29872 | 350 | 0.796 | 37527.6 |
1594 | 2022-08-10 14:29:18 | rice | 1 | 13983 | 27 | 0.250 | 55932.0 |