History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cans"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1604 | 2024-04-18 15:03:40 | cans | 2 | 29872 | 670 | 4.156 | 7187.7 |
1603 | 2024-04-18 15:00:29 | cans | 1 | 13983 | 32 | 0.280 | 49939.3 |
1602 | 2024-04-02 23:03:41 | cans | 1 | 13983 | 32 | 0.283 | 49409.9 |
1601 | 2024-04-02 13:46:36 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1600 | 2024-04-01 17:24:47 | cans | 2 | 29872 | 670 | 3.173 | 9414.4 |
1599 | 2024-04-01 16:32:22 | cans | 1 | 13983 | 32 | 0.280 | 49939.3 |
1598 | 2024-03-28 15:43:01 | cans | 2 | 29872 | 670 | 0.780 | 38297.4 |
1597 | 2024-03-28 15:15:45 | cans | 1 | 13983 | 32 | 0.266 | 52567.7 |
1596 | 2024-03-21 02:09:58 | cans | 1 | 13983 | 32 | 0.596 | 23461.4 |
1595 | 2024-03-19 20:51:11 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1594 | 2024-03-19 20:50:50 | cans | 2 | 29872 | 670 | 0.873 | 34217.6 |
1593 | 2024-03-19 13:27:37 | cans | 2 | 29872 | 670 | 1.050 | 28449.5 |
1592 | 2024-03-19 13:23:59 | cans | 1 | 13983 | 32 | 0.563 | 24836.6 |
1591 | 2024-03-14 12:09:03 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1590 | 2024-03-03 19:43:50 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1589 | 2024-03-02 15:17:11 | cans | 2 | 29872 | 670 | 1.326 | 22527.9 |
1588 | 2024-03-02 13:16:16 | cans | 1 | 13983 | 32 | 0.533 | 26234.5 |
1587 | 2024-03-01 09:19:07 | cans | 1 | 13983 | 32 | 0.500 | 27966.0 |
1586 | 2024-02-24 09:06:55 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1585 | 2024-02-17 22:04:04 | cans | 1 | 13983 | 32 | 0.533 | 26234.5 |
1584 | 2024-02-08 17:59:08 | cans | 2 | 29872 | 670 | 0.780 | 38297.4 |
1583 | 2024-01-31 09:40:50 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1582 | 2024-01-29 09:21:03 | cans | 2 | 29872 | 670 | 0.983 | 30388.6 |
1581 | 2024-01-25 19:33:01 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1580 | 2024-01-21 18:41:19 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1579 | 2024-01-18 08:03:31 | cans | 1 | 13983 | 32 | 0.280 | 49939.3 |
1578 | 2024-01-17 19:32:47 | cans | 1 | 13983 | 32 | 0.236 | 59250.0 |
1577 | 2023-12-07 11:54:36 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1576 | 2023-12-04 19:51:29 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1575 | 2023-12-03 04:55:35 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1574 | 2023-12-03 04:55:34 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1573 | 2023-11-27 13:16:14 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1572 | 2023-11-24 16:48:37 | cans | 1 | 13983 | 32 | 0.483 | 28950.3 |
1571 | 2023-11-20 12:38:06 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1570 | 2023-11-15 17:15:35 | cans | 2 | 29872 | 670 | 0.860 | 34734.9 |
1569 | 2023-11-09 19:40:34 | cans | 2 | 29872 | 670 | 1.093 | 27330.3 |
1568 | 2023-11-09 01:19:39 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1567 | 2023-11-09 01:01:37 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1566 | 2023-11-07 23:45:19 | cans | 2 | 29872 | 670 | 0.783 | 38150.7 |
1565 | 2023-10-31 21:48:23 | cans | 2 | 29872 | 670 | 0.920 | 32469.6 |
1564 | 2023-10-26 00:40:07 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1563 | 2023-10-19 23:32:17 | cans | 1 | 13983 | 32 | 0.326 | 42892.6 |
1562 | 2023-10-18 20:46:32 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1561 | 2023-10-17 04:33:06 | cans | 2 | 29872 | 670 | 1.390 | 21490.6 |
1560 | 2023-10-17 00:06:29 | cans | 1 | 13983 | 32 | 0.266 | 52567.7 |
1559 | 2023-10-15 18:38:05 | cans | 2 | 29872 | 670 | 0.843 | 35435.3 |
1558 | 2023-10-10 18:33:30 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1557 | 2023-10-08 06:14:11 | cans | 2 | 29872 | 670 | 0.796 | 37527.6 |
1556 | 2023-10-03 13:56:10 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1555 | 2023-09-28 00:13:49 | cans | 2 | 29872 | 670 | 0.766 | 38997.4 |
1554 | 2023-09-19 18:57:50 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1553 | 2023-09-18 17:58:04 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1552 | 2023-09-17 08:56:28 | cans | 2 | 29872 | 670 | 0.890 | 33564.0 |
1551 | 2023-09-10 17:24:57 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1550 | 2023-08-28 15:20:08 | cans | 1 | 13983 | 32 | 0.500 | 27966.0 |
1549 | 2023-08-13 03:06:09 | cans | 2 | 29872 | 670 | 0.750 | 39829.3 |
1548 | 2023-07-10 09:00:24 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1547 | 2023-07-06 00:11:39 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1546 | 2023-05-28 11:38:58 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1545 | 2023-04-24 18:25:25 | cans | 2 | 29872 | 670 | 0.860 | 34734.9 |
1544 | 2023-04-12 14:01:36 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1543 | 2023-03-23 02:44:42 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1542 | 2023-02-22 12:56:55 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1541 | 2023-01-31 06:16:17 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1540 | 2023-01-29 11:05:15 | cans | 2 | 29872 | 670 | 0.766 | 38997.4 |
1539 | 2022-11-29 02:28:08 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1538 | 2022-11-23 07:26:27 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1537 | 2022-11-19 19:47:19 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1536 | 2022-11-11 04:20:30 | cans | 2 | 29872 | 670 | 0.780 | 38297.4 |
1535 | 2022-11-10 23:59:29 | cans | 1 | 13983 | 32 | 0.236 | 59250.0 |
1534 | 2022-11-09 04:52:35 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1533 | 2022-09-11 21:58:03 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1532 | 2022-09-03 14:25:30 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1531 | 2022-08-25 23:46:13 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1530 | 2022-08-19 08:36:17 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1529 | 2022-08-18 08:14:18 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1528 | 2022-08-16 01:01:16 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1527 | 2022-08-10 13:13:44 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1526 | 2022-08-06 16:44:22 | cans | 1 | 13983 | 32 | 0.203 | 68881.8 |
1525 | 2022-07-29 21:50:24 | cans | 1 | 13983 | 32 | 0.296 | 47239.9 |
1524 | 2022-07-25 01:49:42 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1523 | 2022-07-03 05:04:54 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1522 | 2022-06-26 14:19:11 | cans | 2 | 29872 | 670 | 0.876 | 34100.5 |
1521 | 2022-06-25 15:14:52 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1520 | 2022-06-16 05:11:34 | cans | 1 | 13983 | 32 | 0.233 | 60012.9 |
1519 | 2022-06-09 00:08:53 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1518 | 2022-06-08 19:48:24 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1517 | 2022-06-08 17:06:54 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1516 | 2022-06-03 16:28:29 | cans | 2 | 29872 | 670 | 0.766 | 38997.4 |
1515 | 2022-06-01 19:38:05 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1514 | 2022-05-10 10:20:34 | cans | 1 | 13983 | 32 | 0.360 | 38841.7 |
1513 | 2022-03-22 01:59:33 | cans | 1 | 13983 | 32 | 0.216 | 64736.1 |
1512 | 2022-03-07 01:52:15 | cans | 1 | 13983 | 32 | 0.266 | 52567.7 |
1511 | 2022-02-05 12:53:53 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1510 | 2022-01-20 17:52:30 | cans | 2 | 29872 | 670 | 0.890 | 33564.0 |
1509 | 2021-12-30 04:18:46 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1508 | 2021-11-07 14:00:26 | cans | 1 | 13983 | 32 | 0.263 | 53167.3 |
1507 | 2021-11-04 18:45:54 | cans | 1 | 13983 | 32 | 0.220 | 63559.1 |
1506 | 2021-11-01 18:39:36 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |
1505 | 2021-10-30 11:54:44 | cans | 1 | 13983 | 32 | 0.250 | 55932.0 |