History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lake"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1599 | 2024-03-26 21:23:42 | lake | 1 | 13983 | 29 | 0.563 | 24836.6 |
1598 | 2024-03-05 20:18:49 | lake | 1 | 13983 | 29 | 0.280 | 49939.3 |
1597 | 2024-03-03 20:10:48 | lake | 1 | 13983 | 29 | 0.546 | 25609.9 |
1596 | 2024-02-29 20:18:32 | lake | 1 | 13983 | 29 | 0.266 | 52567.7 |
1595 | 2024-02-28 10:32:24 | lake | 1 | 13983 | 29 | 1.356 | 10311.9 |
1594 | 2024-02-25 16:08:16 | lake | 1 | 13983 | 29 | 0.236 | 59250.0 |
1593 | 2024-02-02 15:21:07 | lake | 1 | 13983 | 29 | 0.236 | 59250.0 |
1592 | 2024-01-28 15:02:04 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1591 | 2024-01-28 04:11:48 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1590 | 2024-01-17 10:31:49 | lake | 1 | 13983 | 29 | 0.236 | 59250.0 |
1589 | 2024-01-04 17:05:07 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1588 | 2023-12-26 13:55:29 | lake | 2 | 29872 | 443 | 0.800 | 37340.0 |
1587 | 2023-12-16 07:02:54 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1586 | 2023-12-14 05:47:41 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1585 | 2023-12-07 15:29:58 | lake | 2 | 29872 | 443 | 0.876 | 34100.5 |
1584 | 2023-12-07 15:29:56 | lake | 2 | 29872 | 443 | 0.890 | 33564.0 |
1583 | 2023-12-06 08:21:56 | lake | 2 | 29872 | 443 | 0.860 | 34734.9 |
1582 | 2023-11-21 23:34:14 | lake | 1 | 13983 | 29 | 0.236 | 59250.0 |
1581 | 2023-11-11 17:07:13 | lake | 1 | 13983 | 29 | 0.280 | 49939.3 |
1580 | 2023-11-11 03:55:17 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1579 | 2023-11-10 11:51:03 | lake | 2 | 29872 | 443 | 0.906 | 32971.3 |
1578 | 2023-11-08 00:56:51 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1577 | 2023-10-31 08:00:24 | lake | 2 | 29872 | 443 | 0.873 | 34217.6 |
1576 | 2023-10-25 23:59:37 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1575 | 2023-10-25 07:49:18 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1574 | 2023-10-23 12:41:43 | lake | 1 | 13983 | 29 | 0.296 | 47239.9 |
1573 | 2023-10-20 12:05:14 | lake | 1 | 13983 | 29 | 0.236 | 59250.0 |
1572 | 2023-10-19 21:33:18 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1571 | 2023-10-18 11:18:32 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1570 | 2023-10-13 18:48:54 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1569 | 2023-10-03 16:24:05 | lake | 1 | 13983 | 29 | 0.266 | 52567.7 |
1568 | 2023-09-28 11:09:08 | lake | 2 | 29872 | 443 | 0.796 | 37527.6 |
1567 | 2023-09-25 09:43:06 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1566 | 2023-09-21 07:08:11 | lake | 1 | 13983 | 29 | 0.263 | 53167.3 |
1565 | 2023-08-20 08:12:21 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1564 | 2023-08-12 19:45:58 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1563 | 2023-07-18 18:44:04 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1562 | 2023-07-09 14:32:56 | lake | 2 | 29872 | 443 | 0.763 | 39150.7 |
1561 | 2023-05-19 23:16:53 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1560 | 2023-04-10 23:17:32 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1559 | 2023-04-02 05:52:20 | lake | 2 | 29872 | 443 | 0.766 | 38997.4 |
1558 | 2023-03-14 02:23:32 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1557 | 2023-01-30 06:41:02 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1556 | 2023-01-05 19:53:23 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1555 | 2023-01-02 05:22:58 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1554 | 2023-01-01 13:41:58 | lake | 2 | 29872 | 443 | 0.766 | 38997.4 |
1553 | 2022-12-14 08:04:41 | lake | 1 | 13983 | 29 | 0.266 | 52567.7 |
1552 | 2022-11-21 13:15:04 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1551 | 2022-11-19 02:38:31 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1550 | 2022-11-15 16:26:59 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1549 | 2022-10-30 13:10:51 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1548 | 2022-10-29 11:31:27 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1547 | 2022-10-28 12:08:22 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1546 | 2022-10-27 11:10:52 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1545 | 2022-10-26 22:26:50 | lake | 1 | 13983 | 29 | 0.203 | 68881.8 |
1544 | 2022-10-25 09:37:56 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1543 | 2022-10-24 14:11:58 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1542 | 2022-10-23 13:27:55 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1541 | 2022-10-22 11:13:38 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1540 | 2022-10-21 17:26:02 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1539 | 2022-10-20 16:16:58 | lake | 1 | 13983 | 29 | 0.266 | 52567.7 |
1538 | 2022-10-20 08:16:23 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1537 | 2022-10-19 13:52:59 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1536 | 2022-10-18 21:47:18 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1535 | 2022-10-16 18:36:37 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1534 | 2022-10-15 20:01:40 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1533 | 2022-10-14 20:12:44 | lake | 1 | 13983 | 29 | 0.203 | 68881.8 |
1532 | 2022-10-13 12:45:47 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1531 | 2022-10-12 17:13:40 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1530 | 2022-10-11 14:03:52 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1529 | 2022-10-10 22:28:03 | lake | 1 | 13983 | 29 | 0.346 | 40413.3 |
1528 | 2022-10-09 17:09:57 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1527 | 2022-10-08 14:23:55 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1526 | 2022-10-07 15:58:41 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1525 | 2022-09-25 17:48:14 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1524 | 2022-09-23 09:29:10 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1523 | 2022-09-19 18:03:49 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1522 | 2022-09-18 13:27:16 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1521 | 2022-09-15 08:25:23 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1520 | 2022-09-13 05:03:01 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1519 | 2022-09-06 20:14:25 | lake | 2 | 29872 | 443 | 0.750 | 39829.3 |
1518 | 2022-09-06 14:11:01 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1517 | 2022-09-03 11:27:10 | lake | 1 | 13983 | 29 | 0.263 | 53167.3 |
1516 | 2022-08-26 08:41:51 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1515 | 2022-08-26 02:21:56 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1514 | 2022-08-14 11:31:54 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1513 | 2022-08-09 00:28:54 | lake | 1 | 13983 | 29 | 0.280 | 49939.3 |
1512 | 2022-08-06 23:22:59 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1511 | 2022-07-30 01:00:40 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1510 | 2022-07-17 19:09:42 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1509 | 2022-07-10 04:15:32 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1508 | 2022-07-09 18:30:27 | lake | 1 | 13983 | 29 | 0.233 | 60012.9 |
1507 | 2022-07-03 09:25:49 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1506 | 2022-07-02 15:57:40 | lake | 1 | 13983 | 29 | 0.216 | 64736.1 |
1505 | 2022-06-26 04:38:04 | lake | 2 | 29872 | 443 | 0.750 | 39829.3 |
1504 | 2022-06-25 21:06:28 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1503 | 2022-06-16 09:23:19 | lake | 1 | 13983 | 29 | 0.250 | 55932.0 |
1502 | 2022-06-16 00:48:12 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |
1501 | 2022-06-15 20:52:15 | lake | 1 | 13983 | 29 | 0.236 | 59250.0 |
1500 | 2022-06-08 22:34:34 | lake | 1 | 13983 | 29 | 0.220 | 63559.1 |