History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lams"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1557 | 2024-04-11 14:18:25 | lams | 1 | 13983 | 40 | 0.873 | 16017.2 |
1556 | 2024-04-04 23:00:59 | lams | 2 | 29872 | 569 | 2.343 | 12749.5 |
1555 | 2024-04-03 00:52:56 | lams | 2 | 29872 | 569 | 3.096 | 9648.6 |
1554 | 2024-04-03 00:50:48 | lams | 1 | 13983 | 40 | 0.813 | 17199.3 |
1553 | 2024-04-01 15:21:28 | lams | 1 | 13983 | 40 | 0.390 | 35853.8 |
1552 | 2024-03-30 19:26:48 | lams | 2 | 29872 | 569 | 2.953 | 10115.8 |
1551 | 2024-03-30 19:17:39 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1550 | 2024-03-25 22:19:10 | lams | 1 | 13983 | 40 | 0.280 | 49939.3 |
1549 | 2024-03-23 18:29:34 | lams | 1 | 13983 | 40 | 0.563 | 24836.6 |
1548 | 2024-03-08 06:52:24 | lams | 2 | 29872 | 569 | 1.673 | 17855.3 |
1547 | 2024-03-07 21:53:34 | lams | 2 | 29872 | 569 | 1.953 | 15295.4 |
1546 | 2024-03-03 20:37:21 | lams | 1 | 13983 | 40 | 0.516 | 27098.8 |
1545 | 2024-03-02 13:00:43 | lams | 1 | 13983 | 40 | 0.813 | 17199.3 |
1544 | 2024-02-06 13:43:14 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1543 | 2024-02-02 18:22:15 | lams | 1 | 13983 | 40 | 0.436 | 32071.1 |
1542 | 2024-01-28 14:08:19 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1541 | 2024-01-24 13:17:49 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1540 | 2023-12-20 06:52:44 | lams | 1 | 13983 | 40 | 0.220 | 63559.1 |
1539 | 2023-12-16 14:11:20 | lams | 2 | 29872 | 569 | 0.826 | 36164.6 |
1538 | 2023-12-07 00:24:03 | lams | 1 | 13983 | 40 | 0.236 | 59250.0 |
1537 | 2023-12-07 00:24:03 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1536 | 2023-12-03 13:11:18 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1535 | 2023-12-03 13:11:17 | lams | 1 | 13983 | 40 | 0.263 | 53167.3 |
1534 | 2023-11-26 10:27:51 | lams | 2 | 29872 | 569 | 0.766 | 38997.4 |
1533 | 2023-11-25 17:22:29 | lams | 1 | 13983 | 40 | 0.216 | 64736.1 |
1532 | 2023-11-19 17:55:50 | lams | 2 | 29872 | 569 | 0.766 | 38997.4 |
1531 | 2023-11-12 01:39:35 | lams | 1 | 13983 | 40 | 0.466 | 30006.4 |
1530 | 2023-11-09 01:30:57 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1529 | 2023-11-03 03:59:59 | lams | 2 | 29872 | 569 | 0.813 | 36742.9 |
1528 | 2023-10-26 03:21:10 | lams | 1 | 13983 | 40 | 0.263 | 53167.3 |
1527 | 2023-10-24 23:00:07 | lams | 1 | 13983 | 40 | 0.483 | 28950.3 |
1526 | 2023-10-19 22:31:59 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1525 | 2023-10-18 15:01:06 | lams | 1 | 13983 | 40 | 0.453 | 30867.5 |
1524 | 2023-10-17 03:17:02 | lams | 1 | 13983 | 40 | 0.360 | 38841.7 |
1523 | 2023-10-11 03:19:19 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1522 | 2023-10-07 19:31:54 | lams | 2 | 29872 | 569 | 0.843 | 35435.3 |
1521 | 2023-10-07 19:16:36 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1520 | 2023-10-03 12:53:51 | lams | 1 | 13983 | 40 | 0.216 | 64736.1 |
1519 | 2023-09-28 07:25:00 | lams | 2 | 29872 | 569 | 0.906 | 32971.3 |
1518 | 2023-09-22 19:48:53 | lams | 1 | 13983 | 40 | 0.220 | 63559.1 |
1517 | 2023-09-22 02:35:32 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1516 | 2023-09-17 03:14:19 | lams | 1 | 13983 | 40 | 0.236 | 59250.0 |
1515 | 2023-08-25 12:17:05 | lams | 2 | 29872 | 569 | 0.780 | 38297.4 |
1514 | 2023-08-05 14:58:12 | lams | 1 | 13983 | 40 | 0.216 | 64736.1 |
1513 | 2023-07-09 04:54:30 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1512 | 2023-06-27 17:24:44 | lams | 2 | 29872 | 569 | 0.876 | 34100.5 |
1511 | 2023-06-26 03:19:24 | lams | 1 | 13983 | 40 | 0.220 | 63559.1 |
1510 | 2023-06-05 16:59:15 | lams | 1 | 13983 | 40 | 0.220 | 63559.1 |
1509 | 2023-05-10 00:31:27 | lams | 2 | 29872 | 569 | 0.766 | 38997.4 |
1508 | 2023-05-04 09:08:31 | lams | 1 | 13983 | 40 | 0.236 | 59250.0 |
1507 | 2023-05-02 10:26:28 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1506 | 2023-04-17 05:31:33 | lams | 1 | 13983 | 40 | 0.483 | 28950.3 |
1505 | 2023-04-01 16:22:17 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1504 | 2023-03-31 12:37:47 | lams | 2 | 29872 | 569 | 1.376 | 21709.3 |
1503 | 2023-03-26 20:59:43 | lams | 1 | 13983 | 40 | 0.236 | 59250.0 |
1502 | 2023-03-13 18:51:49 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1501 | 2023-02-25 20:16:38 | lams | 1 | 13983 | 40 | 0.420 | 33292.9 |
1500 | 2023-02-23 06:50:06 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1499 | 2023-02-15 06:08:42 | lams | 2 | 29872 | 569 | 0.783 | 38150.7 |
1498 | 2023-01-30 06:41:19 | lams | 1 | 13983 | 40 | 0.203 | 68881.8 |
1497 | 2023-01-19 20:59:24 | lams | 1 | 13983 | 40 | 0.236 | 59250.0 |
1496 | 2023-01-02 19:47:47 | lams | 1 | 13983 | 40 | 0.203 | 68881.8 |
1495 | 2022-12-27 12:12:35 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1494 | 2022-12-23 12:31:17 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1493 | 2022-12-05 21:21:27 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1492 | 2022-11-27 17:23:11 | lams | 2 | 29872 | 569 | 0.920 | 32469.6 |
1491 | 2022-11-26 15:08:04 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1490 | 2022-11-18 21:27:03 | lams | 1 | 13983 | 40 | 0.216 | 64736.1 |
1489 | 2022-10-19 22:33:23 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1488 | 2022-10-03 07:34:42 | lams | 1 | 13983 | 40 | 0.220 | 63559.1 |
1487 | 2022-09-27 06:47:44 | lams | 2 | 29872 | 569 | 0.890 | 33564.0 |
1486 | 2022-09-16 03:38:59 | lams | 2 | 29872 | 569 | 0.783 | 38150.7 |
1485 | 2022-09-13 03:19:20 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1484 | 2022-09-07 19:55:53 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1483 | 2022-09-06 06:54:35 | lams | 1 | 13983 | 40 | 0.236 | 59250.0 |
1482 | 2022-09-04 05:40:33 | lams | 1 | 13983 | 40 | 0.220 | 63559.1 |
1481 | 2022-08-20 10:36:20 | lams | 1 | 13983 | 40 | 0.216 | 64736.1 |
1480 | 2022-08-15 06:33:06 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1479 | 2022-08-06 22:06:39 | lams | 1 | 13983 | 40 | 0.216 | 64736.1 |
1478 | 2022-08-02 06:00:51 | lams | 2 | 29872 | 569 | 0.763 | 39150.7 |
1477 | 2022-07-29 14:10:24 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1476 | 2022-07-16 10:40:15 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1475 | 2022-07-05 09:41:50 | lams | 2 | 29872 | 569 | 0.766 | 38997.4 |
1474 | 2022-07-03 03:13:06 | lams | 2 | 29872 | 569 | 0.766 | 38997.4 |
1473 | 2022-06-29 17:04:34 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1472 | 2022-05-29 09:46:37 | lams | 1 | 13983 | 40 | 0.250 | 55932.0 |
1471 | 2022-05-24 19:07:18 | lams | 1 | 13983 | 40 | 0.220 | 63559.1 |
1470 | 2022-05-12 07:40:01 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1469 | 2022-04-21 01:54:49 | lams | 1 | 13983 | 40 | 0.233 | 60012.9 |
1468 | 2022-04-18 22:46:33 | lams | 1 | 13983 | 40 | 0.280 | 49939.3 |
1467 | 2022-04-10 20:40:48 | lams | 1 | 13983 | 40 | 0.216 | 64736.1 |
1466 | 2022-03-24 13:52:47 | lams | 1 | 13983 | 40 | 0.313 | 44674.1 |
1465 | 2022-03-17 19:12:38 | lams | 2 | 29872 | 569 | 0.780 | 38297.4 |
1464 | 2022-03-16 23:45:34 | lams | 2 | 29872 | 569 | 0.780 | 38297.4 |
1463 | 2022-03-15 22:34:44 | lams | 2 | 29872 | 569 | 0.876 | 34100.5 |
1462 | 2022-03-10 00:52:46 | lams | 1 | 13983 | 40 | 0.266 | 52567.7 |
1461 | 2022-03-01 13:27:21 | lams | 2 | 29872 | 569 | 1.143 | 26134.7 |
1460 | 2022-02-28 23:38:53 | lams | 2 | 29872 | 569 | 1.013 | 29488.6 |
1459 | 2022-02-28 10:09:46 | lams | 2 | 29872 | 569 | 0.940 | 31778.7 |
1458 | 2022-02-27 14:22:43 | lams | 2 | 29872 | 569 | 1.280 | 23337.5 |