History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canna"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1639 | 2025-10-31 04:19:10 | canna | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1638 | 2025-10-27 13:37:39 | canna | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 1637 | 2025-10-26 18:28:33 | canna | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1636 | 2025-10-24 12:55:51 | canna | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1635 | 2025-10-24 12:55:51 | canna | 1 | 28756 | 5 | 0.580 | 49579.3 |
| 1634 | 2025-10-24 08:40:28 | canna | 1 | 28756 | 5 | 1.013 | 28387.0 |
| 1633 | 2025-10-22 00:03:05 | canna | 1 | 28756 | 5 | 1.000 | 28756.0 |
| 1632 | 2025-10-11 23:20:02 | canna | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1631 | 2025-10-01 09:30:00 | canna | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1630 | 2025-09-25 16:43:45 | canna | 1 | 28756 | 5 | 0.560 | 51350.0 |
| 1629 | 2025-09-25 00:35:50 | canna | 1 | 28756 | 5 | 3.046 | 9440.6 |
| 1628 | 2025-09-22 13:03:07 | canna | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1627 | 2025-09-19 18:16:41 | canna | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1626 | 2025-09-14 03:27:22 | canna | 1 | 28756 | 5 | 1.046 | 27491.4 |
| 1625 | 2025-08-29 09:11:01 | canna | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1624 | 2025-08-28 23:54:45 | canna | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1623 | 2025-08-27 10:20:14 | canna | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1622 | 2025-08-27 01:11:16 | canna | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1621 | 2025-08-21 13:24:44 | canna | 1 | 28756 | 5 | 2.186 | 13154.6 |
| 1620 | 2025-08-16 01:38:26 | canna | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1619 | 2025-08-11 17:32:16 | canna | 1 | 28756 | 5 | 1.280 | 22465.6 |
| 1618 | 2025-08-09 04:06:24 | canna | 1 | 28756 | 5 | 3.766 | 7635.7 |
| 1617 | 2025-08-08 13:52:09 | canna | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1616 | 2025-08-07 18:09:35 | canna | 2 | 53800 | 105 | 4.580 | 11746.7 |
| 1615 | 2025-08-05 15:40:51 | canna | 2 | 53800 | 105 | 3.486 | 15433.2 |
| 1614 | 2025-08-04 04:22:47 | canna | 1 | 28756 | 5 | 1.360 | 21144.1 |
| 1613 | 2025-08-01 19:04:28 | canna | 1 | 28756 | 5 | 1.330 | 21621.1 |
| 1612 | 2025-07-31 06:02:51 | canna | 1 | 28756 | 5 | 1.500 | 19170.7 |
| 1611 | 2025-07-27 11:35:01 | canna | 2 | 53800 | 105 | 4.470 | 12035.8 |
| 1610 | 2025-07-26 14:43:06 | canna | 1 | 28756 | 5 | 1.156 | 24875.4 |
| 1609 | 2025-07-25 20:38:02 | canna | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1608 | 2025-07-23 18:53:05 | canna | 1 | 28756 | 5 | 1.233 | 23322.0 |
| 1607 | 2025-07-22 21:45:44 | canna | 1 | 28756 | 5 | 3.126 | 9199.0 |
| 1606 | 2025-07-22 20:31:19 | canna | 1 | 28756 | 5 | 2.953 | 9737.9 |
| 1605 | 2025-07-22 07:15:13 | canna | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1604 | 2025-07-17 14:53:42 | canna | 1 | 28756 | 5 | 1.313 | 21901.0 |
| 1603 | 2025-07-16 21:18:52 | canna | 1 | 28756 | 5 | 0.550 | 52283.6 |
| 1602 | 2025-07-10 19:08:40 | canna | 2 | 53800 | 105 | 12.563 | 4282.4 |
| 1601 | 2025-07-10 17:55:43 | canna | 1 | 28756 | 5 | 2.483 | 11581.2 |
| 1600 | 2025-07-09 02:45:07 | canna | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1599 | 2025-07-04 04:13:09 | canna | 1 | 28756 | 5 | 1.703 | 16885.5 |
| 1598 | 2025-07-02 18:01:06 | canna | 1 | 28756 | 5 | 1.983 | 14501.3 |
| 1597 | 2025-07-02 11:57:15 | canna | 1 | 28756 | 5 | 1.876 | 15328.4 |
| 1596 | 2025-06-29 21:33:25 | canna | 1 | 28756 | 5 | 1.653 | 17396.2 |
| 1595 | 2025-06-27 17:02:20 | canna | 1 | 28756 | 5 | 3.890 | 7392.3 |
| 1594 | 2025-06-20 18:09:43 | canna | 1 | 28756 | 5 | 1.140 | 25224.6 |
| 1593 | 2025-06-20 15:39:20 | canna | 1 | 28756 | 5 | 4.030 | 7135.5 |
| 1592 | 2025-06-19 22:40:34 | canna | 1 | 28756 | 5 | 0.983 | 29253.3 |
| 1591 | 2025-06-19 05:48:47 | canna | 1 | 28756 | 5 | 1.093 | 26309.2 |
| 1590 | 2025-06-13 20:16:28 | canna | 1 | 28756 | 5 | 3.813 | 7541.6 |
| 1589 | 2025-06-13 20:16:00 | canna | 2 | 53800 | 105 | 10.623 | 5064.5 |
| 1588 | 2025-06-02 17:02:02 | canna | 1 | 28756 | 5 | 2.843 | 10114.7 |
| 1587 | 2025-06-02 11:18:20 | canna | 1 | 28756 | 5 | 1.376 | 20898.3 |
| 1586 | 2025-05-31 21:35:10 | canna | 1 | 28756 | 5 | 3.296 | 8724.5 |
| 1585 | 2025-05-28 00:42:00 | canna | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1584 | 2025-05-27 09:06:25 | canna | 1 | 28756 | 5 | 2.440 | 11785.2 |
| 1583 | 2025-05-25 02:31:29 | canna | 1 | 28756 | 5 | 2.610 | 11017.6 |
| 1582 | 2025-05-20 12:56:20 | canna | 1 | 28756 | 5 | 1.050 | 27386.7 |
| 1581 | 2025-05-18 13:58:02 | canna | 1 | 28756 | 5 | 3.720 | 7730.1 |
| 1580 | 2025-05-18 10:27:17 | canna | 1 | 28756 | 5 | 2.610 | 11017.6 |
| 1579 | 2025-05-17 10:15:54 | canna | 1 | 28756 | 5 | 3.953 | 7274.5 |
| 1578 | 2025-05-17 02:52:36 | canna | 1 | 28756 | 5 | 2.156 | 13337.7 |
| 1577 | 2025-05-11 17:31:36 | canna | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1576 | 2025-05-08 17:18:02 | canna | 1 | 28756 | 5 | 2.483 | 11581.2 |
| 1575 | 2025-05-05 17:33:26 | canna | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 1574 | 2025-05-04 08:27:33 | canna | 1 | 28756 | 5 | 1.330 | 21621.1 |
| 1573 | 2025-05-02 17:11:12 | canna | 1 | 28756 | 5 | 2.250 | 12780.4 |
| 1572 | 2025-05-01 11:07:30 | canna | 1 | 28756 | 5 | 1.376 | 20898.3 |
| 1571 | 2025-04-20 12:08:21 | canna | 1 | 28756 | 5 | 2.766 | 10396.2 |
| 1570 | 2025-04-13 08:31:09 | canna | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 1569 | 2025-04-07 02:13:56 | canna | 1 | 28756 | 5 | 2.470 | 11642.1 |
| 1568 | 2025-04-05 20:46:11 | canna | 2 | 53800 | 105 | 7.140 | 7535.0 |
| 1567 | 2025-04-04 14:07:20 | canna | 2 | 53800 | 105 | 6.656 | 8082.9 |
| 1566 | 2025-04-04 01:44:26 | canna | 1 | 28756 | 5 | 1.923 | 14953.7 |
| 1565 | 2025-04-02 03:38:48 | canna | 1 | 28756 | 5 | 1.203 | 23903.6 |
| 1564 | 2025-03-31 18:36:44 | canna | 1 | 28756 | 5 | 1.486 | 19351.3 |
| 1563 | 2025-03-31 12:58:45 | canna | 1 | 28756 | 5 | 1.470 | 19561.9 |
| 1562 | 2025-03-20 14:51:04 | canna | 1 | 28756 | 5 | 2.406 | 11951.8 |
| 1561 | 2025-03-13 14:52:39 | canna | 1 | 28756 | 5 | 2.126 | 13525.9 |
| 1560 | 2025-03-07 19:52:23 | canna | 1 | 28756 | 5 | 2.623 | 10963.0 |
| 1559 | 2025-03-03 00:27:51 | canna | 1 | 28756 | 5 | 1.750 | 16432.0 |
| 1558 | 2025-03-02 18:53:37 | canna | 1 | 28756 | 5 | 2.766 | 10396.2 |
| 1557 | 2025-02-27 22:11:05 | canna | 2 | 53800 | 105 | 12.236 | 4396.9 |
| 1556 | 2025-02-27 21:46:00 | canna | 1 | 28756 | 5 | 1.653 | 17396.2 |
| 1555 | 2025-02-27 20:29:20 | canna | 2 | 53800 | 105 | 11.050 | 4868.8 |
| 1554 | 2025-02-27 20:27:47 | canna | 1 | 28756 | 5 | 2.966 | 9695.2 |
| 1553 | 2025-02-10 06:35:35 | canna | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 1552 | 2025-02-10 01:04:12 | canna | 1 | 28756 | 5 | 1.110 | 25906.3 |
| 1551 | 2025-02-05 14:58:30 | canna | 1 | 28756 | 5 | 0.983 | 29253.3 |
| 1550 | 2025-01-30 01:03:09 | canna | 1 | 28756 | 5 | 2.720 | 10572.1 |
| 1549 | 2025-01-28 09:54:57 | canna | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1548 | 2025-01-28 09:37:19 | canna | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1547 | 2025-01-18 20:44:37 | canna | 1 | 28756 | 5 | 3.203 | 8977.8 |
| 1546 | 2025-01-06 11:55:47 | canna | 1 | 28756 | 5 | 1.203 | 23903.6 |
| 1545 | 2025-01-03 22:26:44 | canna | 1 | 28756 | 5 | 3.000 | 9585.3 |
| 1544 | 2024-12-29 08:08:26 | canna | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1543 | 2024-12-29 07:26:04 | canna | 2 | 53800 | 105 | 4.773 | 11271.7 |
| 1542 | 2024-12-29 02:21:44 | canna | 2 | 53800 | 105 | 7.500 | 7173.3 |
| 1541 | 2024-12-28 20:50:09 | canna | 1 | 28756 | 5 | 1.310 | 21951.1 |
| 1540 | 2024-12-28 11:19:40 | canna | 2 | 53800 | 105 | 9.626 | 5589.0 |