History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bean"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1662 | 2024-12-27 06:11:49 | bean | 1 | 13983 | 21 | 0.220 | 63559.1 |
| 1661 | 2024-12-26 21:25:02 | bean | 2 | 29872 | 333 | 4.530 | 6594.3 |
| 1660 | 2024-12-26 20:12:33 | bean | 2 | 29872 | 333 | 2.186 | 13665.1 |
| 1659 | 2024-12-26 20:09:53 | bean | 1 | 13983 | 21 | 1.110 | 12597.3 |
| 1658 | 2024-12-24 18:05:17 | bean | 1 | 13983 | 21 | 0.780 | 17926.9 |
| 1657 | 2024-12-19 21:50:01 | bean | 1 | 13983 | 21 | 0.233 | 60012.9 |
| 1656 | 2024-12-06 07:35:32 | bean | 2 | 29872 | 333 | 3.983 | 7499.9 |
| 1655 | 2024-12-06 07:17:40 | bean | 1 | 13983 | 21 | 0.216 | 64736.1 |
| 1654 | 2024-11-27 03:14:47 | bean | 1 | 13983 | 21 | 0.233 | 60012.9 |
| 1653 | 2024-11-26 22:08:01 | bean | 2 | 29872 | 333 | 2.296 | 13010.5 |
| 1652 | 2024-11-26 20:15:07 | bean | 2 | 29872 | 333 | 1.890 | 15805.3 |
| 1651 | 2024-11-26 19:48:23 | bean | 1 | 13983 | 21 | 1.063 | 13154.3 |
| 1650 | 2024-11-24 17:29:27 | bean | 1 | 13983 | 21 | 0.906 | 15433.8 |
| 1649 | 2024-11-08 07:14:41 | bean | 2 | 29872 | 333 | 2.453 | 12177.7 |
| 1648 | 2024-11-06 07:16:09 | bean | 2 | 29872 | 333 | 6.483 | 4607.7 |
| 1647 | 2024-11-06 07:10:26 | bean | 1 | 13983 | 21 | 1.733 | 8068.7 |
| 1646 | 2024-10-29 09:49:41 | bean | 1 | 13983 | 21 | 0.656 | 21315.5 |
| 1645 | 2024-10-27 23:52:52 | bean | 1 | 13983 | 21 | 0.266 | 52567.7 |
| 1644 | 2024-10-27 22:48:18 | bean | 2 | 29872 | 333 | 6.720 | 4445.2 |
| 1643 | 2024-10-27 20:29:12 | bean | 2 | 29872 | 333 | 3.310 | 9024.8 |
| 1642 | 2024-10-27 20:21:05 | bean | 1 | 13983 | 21 | 1.063 | 13154.3 |
| 1641 | 2024-10-26 07:38:39 | bean | 1 | 13983 | 21 | 0.800 | 17478.8 |
| 1640 | 2024-10-25 16:43:55 | bean | 1 | 13983 | 21 | 2.516 | 5557.6 |
| 1639 | 2024-10-24 02:25:50 | bean | 1 | 13983 | 21 | 1.233 | 11340.6 |
| 1638 | 2024-10-07 07:07:46 | bean | 1 | 13983 | 21 | 1.393 | 10038.0 |
| 1637 | 2024-09-28 09:09:00 | bean | 2 | 29872 | 333 | 6.983 | 4277.8 |
| 1636 | 2024-09-27 23:49:45 | bean | 1 | 13983 | 21 | 0.220 | 63559.1 |
| 1635 | 2024-09-27 18:58:00 | bean | 2 | 29872 | 333 | 3.720 | 8030.1 |
| 1634 | 2024-09-27 16:54:23 | bean | 2 | 29872 | 333 | 3.750 | 7965.9 |
| 1633 | 2024-09-27 16:08:56 | bean | 1 | 13983 | 21 | 0.220 | 63559.1 |
| 1632 | 2024-09-25 13:39:32 | bean | 1 | 13983 | 21 | 1.860 | 7517.7 |
| 1631 | 2024-09-15 08:58:42 | bean | 1 | 13983 | 21 | 2.720 | 5140.8 |
| 1630 | 2024-09-10 01:34:32 | bean | 1 | 13983 | 21 | 0.703 | 19890.5 |
| 1629 | 2024-09-07 06:18:03 | bean | 1 | 13983 | 21 | 1.343 | 10411.8 |
| 1628 | 2024-08-30 01:18:47 | bean | 1 | 13983 | 21 | 2.673 | 5231.2 |
| 1627 | 2024-08-28 11:33:13 | bean | 1 | 13983 | 21 | 0.876 | 15962.3 |
| 1626 | 2024-08-28 10:37:20 | bean | 2 | 29872 | 333 | 7.796 | 3831.7 |
| 1625 | 2024-08-28 08:36:53 | bean | 2 | 29872 | 333 | 2.986 | 10004.0 |
| 1624 | 2024-08-28 08:28:28 | bean | 1 | 13983 | 21 | 1.906 | 7336.3 |
| 1623 | 2024-08-27 05:51:59 | bean | 1 | 13983 | 21 | 1.766 | 7917.9 |
| 1622 | 2024-08-09 03:41:59 | bean | 2 | 29872 | 333 | 2.063 | 14479.9 |
| 1621 | 2024-08-08 03:26:38 | bean | 2 | 29872 | 333 | 3.940 | 7581.7 |
| 1620 | 2024-08-08 03:09:03 | bean | 1 | 13983 | 21 | 0.280 | 49939.3 |
| 1619 | 2024-08-02 03:01:12 | bean | 1 | 13983 | 21 | 0.720 | 19420.8 |
| 1618 | 2024-07-30 03:46:45 | bean | 1 | 13983 | 21 | 0.266 | 52567.7 |
| 1617 | 2024-07-30 03:46:37 | bean | 1 | 13983 | 21 | 1.046 | 13368.1 |
| 1616 | 2024-07-29 18:54:18 | bean | 2 | 29872 | 333 | 3.500 | 8534.9 |
| 1615 | 2024-07-29 17:06:30 | bean | 1 | 13983 | 21 | 0.296 | 47239.9 |
| 1614 | 2024-07-29 14:16:46 | bean | 2 | 29872 | 333 | 3.436 | 8693.8 |
| 1613 | 2024-07-29 10:44:38 | bean | 2 | 29872 | 333 | 2.733 | 10930.1 |
| 1612 | 2024-07-29 09:38:27 | bean | 1 | 13983 | 21 | 0.233 | 60012.9 |
| 1611 | 2024-07-29 06:39:54 | bean | 2 | 29872 | 333 | 4.296 | 6953.4 |
| 1610 | 2024-07-29 06:16:11 | bean | 1 | 13983 | 21 | 0.250 | 55932.0 |
| 1609 | 2024-07-27 10:04:56 | bean | 1 | 13983 | 21 | 1.423 | 9826.4 |
| 1608 | 2024-07-27 00:50:17 | bean | 1 | 13983 | 21 | 0.310 | 45106.5 |
| 1607 | 2024-07-25 04:04:19 | bean | 2 | 29872 | 333 | 2.190 | 13640.2 |
| 1606 | 2024-07-16 23:10:05 | bean | 1 | 13983 | 21 | 1.220 | 11461.5 |
| 1605 | 2024-07-16 23:06:01 | bean | 1 | 13983 | 21 | 0.940 | 14875.5 |
| 1604 | 2024-07-07 01:43:12 | bean | 1 | 13983 | 21 | 0.860 | 16259.3 |
| 1603 | 2024-07-07 00:10:19 | bean | 1 | 13983 | 21 | 1.436 | 9737.5 |
| 1602 | 2024-07-03 15:57:49 | bean | 1 | 13983 | 21 | 0.936 | 14939.1 |
| 1601 | 2024-07-03 15:57:07 | bean | 1 | 13983 | 21 | 0.373 | 37487.9 |
| 1600 | 2024-07-03 15:18:13 | bean | 1 | 13983 | 21 | 0.280 | 49939.3 |
| 1599 | 2024-07-03 00:31:26 | bean | 1 | 13983 | 21 | 0.280 | 49939.3 |
| 1598 | 2024-07-01 05:35:57 | bean | 1 | 13983 | 21 | 0.436 | 32071.1 |
| 1597 | 2024-06-29 05:07:43 | bean | 1 | 13983 | 21 | 0.830 | 16847.0 |
| 1596 | 2024-06-28 21:54:46 | bean | 1 | 13983 | 21 | 0.750 | 18644.0 |
| 1595 | 2024-06-27 09:46:01 | bean | 1 | 13983 | 21 | 1.080 | 12947.2 |
| 1594 | 2024-06-20 22:16:15 | bean | 1 | 13983 | 21 | 0.420 | 33292.9 |
| 1593 | 2024-06-10 02:29:04 | bean | 1 | 13983 | 21 | 1.016 | 13762.8 |
| 1592 | 2024-06-04 02:14:00 | bean | 2 | 29872 | 333 | 1.500 | 19914.7 |
| 1591 | 2024-06-04 00:34:17 | bean | 2 | 29872 | 333 | 1.970 | 15163.5 |
| 1590 | 2024-06-03 21:56:20 | bean | 1 | 13983 | 21 | 0.233 | 60012.9 |
| 1589 | 2024-05-30 02:29:04 | bean | 1 | 13983 | 21 | 0.923 | 15149.5 |
| 1588 | 2024-05-29 19:36:18 | bean | 1 | 13983 | 21 | 0.813 | 17199.3 |
| 1587 | 2024-05-29 01:26:06 | bean | 1 | 13983 | 21 | 0.546 | 25609.9 |
| 1586 | 2024-05-17 23:15:20 | bean | 2 | 29872 | 333 | 2.063 | 14479.9 |
| 1585 | 2024-05-17 00:30:02 | bean | 2 | 29872 | 333 | 0.763 | 39150.7 |
| 1584 | 2024-05-12 18:14:06 | bean | 1 | 13983 | 21 | 0.280 | 49939.3 |
| 1583 | 2024-05-10 08:42:34 | bean | 1 | 13983 | 21 | 0.280 | 49939.3 |
| 1582 | 2024-05-04 21:00:15 | bean | 2 | 29872 | 333 | 2.983 | 10014.1 |
| 1581 | 2024-05-04 21:00:06 | bean | 1 | 13983 | 21 | 0.936 | 14939.1 |
| 1580 | 2024-05-04 20:59:47 | bean | 2 | 29872 | 333 | 1.966 | 15194.3 |
| 1579 | 2024-05-04 20:59:45 | bean | 1 | 13983 | 21 | 0.280 | 49939.3 |
| 1578 | 2024-04-30 01:25:49 | bean | 1 | 13983 | 21 | 0.266 | 52567.7 |
| 1577 | 2024-04-29 07:17:15 | bean | 1 | 13983 | 21 | 0.483 | 28950.3 |
| 1576 | 2024-04-28 02:38:35 | bean | 1 | 13983 | 21 | 0.500 | 27966.0 |
| 1575 | 2024-04-27 10:34:25 | bean | 1 | 13983 | 21 | 0.546 | 25609.9 |
| 1574 | 2024-04-25 22:28:01 | bean | 1 | 13983 | 21 | 0.563 | 24836.6 |
| 1573 | 2024-04-23 16:30:38 | bean | 1 | 13983 | 21 | 0.703 | 19890.5 |
| 1572 | 2024-04-23 13:23:36 | bean | 1 | 13983 | 21 | 0.986 | 14181.5 |
| 1571 | 2024-04-19 12:56:41 | bean | 1 | 13983 | 21 | 1.156 | 12096.0 |
| 1570 | 2024-04-04 19:34:14 | bean | 1 | 13983 | 21 | 0.813 | 17199.3 |
| 1569 | 2024-03-31 00:48:54 | bean | 2 | 29872 | 333 | 3.046 | 9807.0 |
| 1568 | 2024-03-30 23:18:01 | bean | 1 | 13983 | 21 | 0.500 | 27966.0 |
| 1567 | 2024-03-28 17:49:59 | bean | 1 | 13983 | 21 | 0.266 | 52567.7 |
| 1566 | 2024-03-06 14:43:57 | bean | 1 | 13983 | 21 | 0.266 | 52567.7 |
| 1565 | 2024-03-05 17:34:39 | bean | 1 | 13983 | 21 | 1.013 | 13803.6 |
| 1564 | 2024-03-01 10:43:53 | bean | 1 | 13983 | 21 | 0.343 | 40766.8 |
| 1563 | 2024-02-27 15:42:03 | bean | 1 | 13983 | 21 | 0.250 | 55932.0 |