History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rose"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1626 | 2025-10-29 22:40:37 | rose | 2 | 29872 | 467 | 1.953 | 15295.4 |
| 1625 | 2025-10-29 14:35:19 | rose | 2 | 29872 | 467 | 0.906 | 32971.3 |
| 1624 | 2025-10-07 10:25:52 | rose | 1 | 13983 | 29 | 0.263 | 53167.3 |
| 1623 | 2025-10-01 04:10:39 | rose | 2 | 29872 | 467 | 0.796 | 37527.6 |
| 1622 | 2025-09-28 09:53:19 | rose | 2 | 29872 | 467 | 0.813 | 36742.9 |
| 1621 | 2025-09-27 03:51:48 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1620 | 2025-09-26 12:54:20 | rose | 2 | 29872 | 467 | 1.626 | 18371.5 |
| 1619 | 2025-09-25 15:43:44 | rose | 1 | 13983 | 29 | 1.343 | 10411.8 |
| 1618 | 2025-09-20 20:38:15 | rose | 1 | 13983 | 29 | 0.516 | 27098.8 |
| 1617 | 2025-09-08 05:08:45 | rose | 2 | 29872 | 467 | 0.876 | 34100.5 |
| 1616 | 2025-09-07 04:11:49 | rose | 1 | 13983 | 29 | 0.216 | 64736.1 |
| 1615 | 2025-09-06 06:09:24 | rose | 1 | 13983 | 29 | 0.266 | 52567.7 |
| 1614 | 2025-09-03 07:21:56 | rose | 1 | 13983 | 29 | 0.236 | 59250.0 |
| 1613 | 2025-09-01 17:33:54 | rose | 2 | 29872 | 467 | 0.890 | 33564.0 |
| 1612 | 2025-08-31 06:26:33 | rose | 1 | 13983 | 29 | 0.263 | 53167.3 |
| 1611 | 2025-08-29 06:21:30 | rose | 1 | 13983 | 29 | 0.263 | 53167.3 |
| 1610 | 2025-08-19 06:01:06 | rose | 1 | 13983 | 29 | 0.533 | 26234.5 |
| 1609 | 2025-08-13 02:05:21 | rose | 1 | 13983 | 29 | 1.843 | 7587.1 |
| 1608 | 2025-08-11 06:36:48 | rose | 1 | 13983 | 29 | 0.266 | 52567.7 |
| 1607 | 2025-08-09 15:34:03 | rose | 1 | 13983 | 29 | 0.280 | 49939.3 |
| 1606 | 2025-08-01 16:43:38 | rose | 2 | 29872 | 467 | 1.826 | 16359.3 |
| 1605 | 2025-07-31 23:05:15 | rose | 1 | 13983 | 29 | 0.910 | 15365.9 |
| 1604 | 2025-07-31 09:25:40 | rose | 1 | 13983 | 29 | 0.373 | 37487.9 |
| 1603 | 2025-07-27 11:23:07 | rose | 1 | 13983 | 29 | 0.300 | 46610.0 |
| 1602 | 2025-07-27 06:07:39 | rose | 1 | 13983 | 29 | 0.830 | 16847.0 |
| 1601 | 2025-07-26 16:39:17 | rose | 1 | 13983 | 29 | 1.170 | 11951.3 |
| 1600 | 2025-07-24 03:52:10 | rose | 1 | 13983 | 29 | 0.640 | 21848.4 |
| 1599 | 2025-07-23 16:14:30 | rose | 1 | 13983 | 29 | 1.390 | 10059.7 |
| 1598 | 2025-07-23 08:03:14 | rose | 1 | 13983 | 29 | 1.016 | 13762.8 |
| 1597 | 2025-07-22 21:54:14 | rose | 1 | 13983 | 29 | 0.860 | 16259.3 |
| 1596 | 2025-07-20 17:42:49 | rose | 1 | 13983 | 29 | 0.263 | 53167.3 |
| 1595 | 2025-07-17 07:11:40 | rose | 1 | 13983 | 29 | 0.700 | 19975.7 |
| 1594 | 2025-07-13 22:14:30 | rose | 1 | 13983 | 29 | 1.356 | 10311.9 |
| 1593 | 2025-07-08 14:38:26 | rose | 1 | 13983 | 29 | 0.610 | 22923.0 |
| 1592 | 2025-07-07 00:23:42 | rose | 1 | 13983 | 29 | 1.576 | 8872.5 |
| 1591 | 2025-07-02 22:00:36 | rose | 1 | 13983 | 29 | 0.670 | 20870.1 |
| 1590 | 2025-07-02 10:01:40 | rose | 2 | 29872 | 467 | 4.860 | 6146.5 |
| 1589 | 2025-07-01 23:06:16 | rose | 1 | 13983 | 29 | 1.250 | 11186.4 |
| 1588 | 2025-07-01 22:16:10 | rose | 1 | 13983 | 29 | 0.810 | 17263.0 |
| 1587 | 2025-07-01 14:25:00 | rose | 1 | 13983 | 29 | 0.220 | 63559.1 |
| 1586 | 2025-06-30 17:05:23 | rose | 2 | 29872 | 467 | 4.560 | 6550.9 |
| 1585 | 2025-06-29 08:07:19 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1584 | 2025-06-24 23:33:24 | rose | 1 | 13983 | 29 | 1.310 | 10674.0 |
| 1583 | 2025-06-21 01:05:29 | rose | 1 | 13983 | 29 | 0.983 | 14224.8 |
| 1582 | 2025-06-12 16:53:52 | rose | 1 | 13983 | 29 | 1.000 | 13983.0 |
| 1581 | 2025-06-04 11:50:31 | rose | 2 | 29872 | 467 | 2.250 | 13276.4 |
| 1580 | 2025-06-02 08:32:40 | rose | 2 | 29872 | 467 | 2.280 | 13101.8 |
| 1579 | 2025-06-02 07:31:48 | rose | 2 | 29872 | 467 | 2.250 | 13276.4 |
| 1578 | 2025-06-01 13:49:36 | rose | 1 | 13983 | 29 | 0.266 | 52567.7 |
| 1577 | 2025-05-31 01:10:19 | rose | 1 | 13983 | 29 | 0.310 | 45106.5 |
| 1576 | 2025-05-30 21:58:25 | rose | 1 | 13983 | 29 | 1.576 | 8872.5 |
| 1575 | 2025-05-29 07:34:16 | rose | 1 | 13983 | 29 | 1.203 | 11623.4 |
| 1574 | 2025-05-21 01:02:06 | rose | 1 | 13983 | 29 | 0.283 | 49409.9 |
| 1573 | 2025-05-11 17:33:01 | rose | 1 | 13983 | 29 | 0.216 | 64736.1 |
| 1572 | 2025-05-08 17:49:12 | rose | 2 | 29872 | 467 | 7.130 | 4189.6 |
| 1571 | 2025-05-06 20:23:05 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1570 | 2025-05-05 11:52:01 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1569 | 2025-05-02 07:25:05 | rose | 2 | 29872 | 467 | 4.796 | 6228.5 |
| 1568 | 2025-05-01 13:35:20 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1567 | 2025-04-30 16:43:36 | rose | 1 | 13983 | 29 | 0.986 | 14181.5 |
| 1566 | 2025-04-29 22:07:42 | rose | 1 | 13983 | 29 | 1.406 | 9945.2 |
| 1565 | 2025-04-28 07:24:47 | rose | 1 | 13983 | 29 | 0.656 | 21315.5 |
| 1564 | 2025-04-27 08:19:49 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1563 | 2025-04-27 08:14:26 | rose | 1 | 13983 | 29 | 0.670 | 20870.1 |
| 1562 | 2025-04-27 08:10:22 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1561 | 2025-04-23 16:17:19 | rose | 1 | 13983 | 29 | 1.906 | 7336.3 |
| 1560 | 2025-04-16 00:00:08 | rose | 2 | 29872 | 467 | 6.923 | 4314.9 |
| 1559 | 2025-04-15 05:22:30 | rose | 1 | 13983 | 29 | 1.110 | 12597.3 |
| 1558 | 2025-04-12 19:51:09 | rose | 1 | 13983 | 29 | 0.233 | 60012.9 |
| 1557 | 2025-04-06 14:06:51 | rose | 1 | 13983 | 29 | 1.326 | 10545.2 |
| 1556 | 2025-03-23 18:52:27 | rose | 1 | 13983 | 29 | 0.970 | 14415.5 |
| 1555 | 2025-03-21 01:13:24 | rose | 1 | 13983 | 29 | 0.860 | 16259.3 |
| 1554 | 2025-03-19 11:35:04 | rose | 1 | 13983 | 29 | 0.216 | 64736.1 |
| 1553 | 2025-03-14 20:43:43 | rose | 1 | 13983 | 29 | 1.453 | 9623.5 |
| 1552 | 2025-03-09 01:29:12 | rose | 1 | 13983 | 29 | 0.703 | 19890.5 |
| 1551 | 2025-03-06 05:59:07 | rose | 1 | 13983 | 29 | 0.720 | 19420.8 |
| 1550 | 2025-02-26 03:43:05 | rose | 1 | 13983 | 29 | 1.343 | 10411.8 |
| 1549 | 2025-02-24 23:40:17 | rose | 1 | 13983 | 29 | 1.156 | 12096.0 |
| 1548 | 2025-02-24 13:49:36 | rose | 1 | 13983 | 29 | 1.360 | 10281.6 |
| 1547 | 2025-02-23 17:56:34 | rose | 1 | 13983 | 29 | 1.220 | 11461.5 |
| 1546 | 2025-02-18 08:13:04 | rose | 1 | 13983 | 29 | 1.376 | 10162.1 |
| 1545 | 2025-02-14 04:19:39 | rose | 1 | 13983 | 29 | 0.703 | 19890.5 |
| 1544 | 2025-02-04 05:01:41 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1543 | 2025-01-28 20:13:58 | rose | 1 | 13983 | 29 | 0.970 | 14415.5 |
| 1542 | 2025-01-27 22:14:34 | rose | 2 | 29872 | 467 | 2.283 | 13084.5 |
| 1541 | 2025-01-26 12:44:41 | rose | 2 | 29872 | 467 | 4.763 | 6271.7 |
| 1540 | 2025-01-26 12:23:09 | rose | 2 | 29872 | 467 | 4.360 | 6851.4 |
| 1539 | 2025-01-26 11:33:01 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1538 | 2025-01-25 11:57:05 | rose | 1 | 13983 | 29 | 0.216 | 64736.1 |
| 1537 | 2025-01-19 02:14:27 | rose | 1 | 13983 | 29 | 0.670 | 20870.1 |
| 1536 | 2025-01-17 04:31:54 | rose | 1 | 13983 | 29 | 1.346 | 10388.6 |
| 1535 | 2025-01-05 01:13:32 | rose | 1 | 13983 | 29 | 1.596 | 8761.3 |
| 1534 | 2024-12-27 13:11:04 | rose | 1 | 13983 | 29 | 0.640 | 21848.4 |
| 1533 | 2024-12-27 12:10:54 | rose | 2 | 29872 | 467 | 2.156 | 13855.3 |
| 1532 | 2024-12-27 11:56:10 | rose | 2 | 29872 | 467 | 5.080 | 5880.3 |
| 1531 | 2024-12-27 10:13:11 | rose | 2 | 29872 | 467 | 5.393 | 5539.0 |
| 1530 | 2024-12-27 09:02:21 | rose | 1 | 13983 | 29 | 0.250 | 55932.0 |
| 1529 | 2024-12-26 07:31:03 | rose | 1 | 13983 | 29 | 0.983 | 14224.8 |
| 1528 | 2024-12-24 18:15:33 | rose | 1 | 13983 | 29 | 1.203 | 11623.4 |
| 1527 | 2024-12-05 22:34:01 | rose | 1 | 13983 | 29 | 0.673 | 20777.1 |