History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"join"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1561 | 2024-04-17 09:04:27 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1560 | 2024-04-13 05:44:57 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1559 | 2024-04-13 05:44:45 | join | 2 | 29872 | 205 | 2.533 | 11793.1 |
1558 | 2024-04-13 01:10:54 | join | 1 | 13983 | 8 | 0.360 | 38841.7 |
1557 | 2024-04-12 09:01:05 | join | 2 | 29872 | 205 | 0.736 | 40587.0 |
1556 | 2024-04-11 18:05:37 | join | 2 | 29872 | 205 | 0.940 | 31778.7 |
1555 | 2024-04-10 11:13:54 | join | 2 | 29872 | 205 | 0.826 | 36164.6 |
1554 | 2024-04-09 15:07:57 | join | 2 | 29872 | 205 | 2.106 | 14184.2 |
1553 | 2024-04-08 14:23:26 | join | 2 | 29872 | 205 | 1.030 | 29001.9 |
1552 | 2024-04-05 01:30:49 | join | 1 | 13983 | 8 | 0.203 | 68881.8 |
1551 | 2024-04-02 22:50:55 | join | 2 | 29872 | 205 | 2.983 | 10014.1 |
1550 | 2024-04-02 20:57:03 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1549 | 2024-03-31 10:38:52 | join | 2 | 29872 | 205 | 1.970 | 15163.5 |
1548 | 2024-03-31 08:03:39 | join | 1 | 13983 | 8 | 0.500 | 27966.0 |
1547 | 2024-03-27 07:23:43 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1546 | 2024-03-23 10:27:45 | join | 2 | 29872 | 205 | 0.953 | 31345.2 |
1545 | 2024-03-22 21:11:52 | join | 2 | 29872 | 205 | 1.923 | 15534.1 |
1544 | 2024-03-21 08:44:32 | join | 2 | 29872 | 205 | 1.186 | 25187.2 |
1543 | 2024-03-20 19:09:30 | join | 2 | 29872 | 205 | 2.063 | 14479.9 |
1542 | 2024-03-11 20:39:36 | join | 2 | 29872 | 205 | 2.080 | 14361.5 |
1541 | 2024-03-10 23:07:48 | join | 2 | 29872 | 205 | 1.970 | 15163.5 |
1540 | 2024-03-09 20:39:12 | join | 2 | 29872 | 205 | 0.950 | 31444.2 |
1539 | 2024-03-05 21:28:11 | join | 1 | 13983 | 8 | 0.203 | 68881.8 |
1538 | 2024-03-03 19:38:39 | join | 1 | 13983 | 8 | 0.216 | 64736.1 |
1537 | 2024-02-29 23:04:16 | join | 1 | 13983 | 8 | 0.843 | 16587.2 |
1536 | 2024-02-27 11:43:15 | join | 2 | 29872 | 205 | 0.903 | 33080.8 |
1535 | 2024-02-26 04:09:03 | join | 2 | 29872 | 205 | 0.953 | 31345.2 |
1534 | 2024-02-26 04:08:11 | join | 1 | 13983 | 8 | 0.266 | 52567.7 |
1533 | 2024-02-17 15:44:57 | join | 2 | 29872 | 205 | 0.876 | 34100.5 |
1532 | 2024-02-16 16:47:47 | join | 2 | 29872 | 205 | 2.810 | 10630.6 |
1531 | 2024-02-15 20:22:22 | join | 2 | 29872 | 205 | 0.813 | 36742.9 |
1530 | 2024-02-03 14:52:29 | join | 2 | 29872 | 205 | 0.720 | 41488.9 |
1529 | 2024-02-02 21:10:04 | join | 2 | 29872 | 205 | 0.890 | 33564.0 |
1528 | 2024-02-02 18:07:39 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1527 | 2024-02-01 11:58:57 | join | 2 | 29872 | 205 | 0.703 | 42492.2 |
1526 | 2024-01-31 19:01:36 | join | 2 | 29872 | 205 | 0.890 | 33564.0 |
1525 | 2024-01-27 00:07:13 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1524 | 2023-12-31 08:37:59 | join | 2 | 29872 | 205 | 0.783 | 38150.7 |
1523 | 2023-12-30 18:12:08 | join | 1 | 13983 | 8 | 0.216 | 64736.1 |
1522 | 2023-12-28 06:43:51 | join | 2 | 29872 | 205 | 0.750 | 39829.3 |
1521 | 2023-12-27 13:32:05 | join | 2 | 29872 | 205 | 0.766 | 38997.4 |
1520 | 2023-11-30 00:22:37 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1519 | 2023-11-28 06:23:11 | join | 2 | 29872 | 205 | 0.860 | 34734.9 |
1518 | 2023-11-26 18:07:43 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1517 | 2023-11-26 14:24:43 | join | 2 | 29872 | 205 | 0.843 | 35435.3 |
1516 | 2023-11-18 19:12:18 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1515 | 2023-11-13 12:57:44 | join | 2 | 29872 | 205 | 0.766 | 38997.4 |
1514 | 2023-11-09 22:54:24 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1513 | 2023-10-26 18:45:09 | join | 1 | 13983 | 8 | 0.236 | 59250.0 |
1512 | 2023-10-19 21:53:12 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1511 | 2023-10-19 06:11:38 | join | 1 | 13983 | 8 | 0.216 | 64736.1 |
1510 | 2023-10-17 07:06:20 | join | 1 | 13983 | 8 | 0.236 | 59250.0 |
1509 | 2023-10-17 02:31:13 | join | 2 | 29872 | 205 | 0.890 | 33564.0 |
1508 | 2023-10-15 23:54:01 | join | 2 | 29872 | 205 | 0.986 | 30296.1 |
1507 | 2023-10-13 05:20:23 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1506 | 2023-10-10 18:28:48 | join | 2 | 29872 | 205 | 1.470 | 20321.1 |
1505 | 2023-10-04 00:39:49 | join | 1 | 13983 | 8 | 0.220 | 63559.1 |
1504 | 2023-09-28 13:43:47 | join | 2 | 29872 | 205 | 0.813 | 36742.9 |
1503 | 2023-09-25 07:24:54 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1502 | 2023-09-22 16:30:22 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1501 | 2023-09-14 18:38:11 | join | 2 | 29872 | 205 | 1.593 | 18752.0 |
1500 | 2023-09-03 14:28:03 | join | 2 | 29872 | 205 | 0.813 | 36742.9 |
1499 | 2023-09-01 21:13:31 | join | 2 | 29872 | 205 | 0.780 | 38297.4 |
1498 | 2023-08-30 22:53:39 | join | 2 | 29872 | 205 | 0.736 | 40587.0 |
1497 | 2023-08-30 14:05:58 | join | 2 | 29872 | 205 | 0.750 | 39829.3 |
1496 | 2023-08-29 08:10:35 | join | 2 | 29872 | 205 | 1.640 | 18214.6 |
1495 | 2023-08-14 08:11:49 | join | 1 | 13983 | 8 | 0.236 | 59250.0 |
1494 | 2023-08-14 05:40:07 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1493 | 2023-08-13 17:50:47 | join | 2 | 29872 | 205 | 0.830 | 35990.4 |
1492 | 2023-08-10 21:51:04 | join | 1 | 13983 | 8 | 0.216 | 64736.1 |
1491 | 2023-07-31 02:17:40 | join | 2 | 29872 | 205 | 0.826 | 36164.6 |
1490 | 2023-07-28 19:41:19 | join | 2 | 29872 | 205 | 0.720 | 41488.9 |
1489 | 2023-07-27 07:35:16 | join | 2 | 29872 | 205 | 0.750 | 39829.3 |
1488 | 2023-07-26 11:57:17 | join | 2 | 29872 | 205 | 0.750 | 39829.3 |
1487 | 2023-07-24 23:51:20 | join | 2 | 29872 | 205 | 0.843 | 35435.3 |
1486 | 2023-07-23 04:17:20 | join | 2 | 29872 | 205 | 0.733 | 40753.1 |
1485 | 2023-07-21 01:42:46 | join | 2 | 29872 | 205 | 0.826 | 36164.6 |
1484 | 2023-07-19 00:52:59 | join | 2 | 29872 | 205 | 0.873 | 34217.6 |
1483 | 2023-07-12 23:16:25 | join | 2 | 29872 | 205 | 0.813 | 36742.9 |
1482 | 2023-07-11 20:49:55 | join | 2 | 29872 | 205 | 0.903 | 33080.8 |
1481 | 2023-07-10 18:45:13 | join | 2 | 29872 | 205 | 0.856 | 34897.2 |
1480 | 2023-06-10 12:17:41 | join | 1 | 13983 | 8 | 0.203 | 68881.8 |
1479 | 2023-06-09 22:28:57 | join | 2 | 29872 | 205 | 0.780 | 38297.4 |
1478 | 2023-06-09 00:54:56 | join | 2 | 29872 | 205 | 0.733 | 40753.1 |
1477 | 2023-06-08 01:57:04 | join | 2 | 29872 | 205 | 0.716 | 41720.7 |
1476 | 2023-06-07 19:32:58 | join | 1 | 13983 | 8 | 0.233 | 60012.9 |
1475 | 2023-06-06 14:02:22 | join | 2 | 29872 | 205 | 0.780 | 38297.4 |
1474 | 2023-06-05 18:34:53 | join | 2 | 29872 | 205 | 0.813 | 36742.9 |
1473 | 2023-06-05 04:41:38 | join | 2 | 29872 | 205 | 0.813 | 36742.9 |
1472 | 2023-06-04 09:55:27 | join | 2 | 29872 | 205 | 0.843 | 35435.3 |
1471 | 2023-06-03 03:54:27 | join | 2 | 29872 | 205 | 0.720 | 41488.9 |
1470 | 2023-06-01 17:24:31 | join | 2 | 29872 | 205 | 0.813 | 36742.9 |
1469 | 2023-05-31 23:58:40 | join | 2 | 29872 | 205 | 0.843 | 35435.3 |
1468 | 2023-05-30 19:34:46 | join | 2 | 29872 | 205 | 1.610 | 18554.0 |
1467 | 2023-05-16 06:33:24 | join | 1 | 13983 | 8 | 0.203 | 68881.8 |
1466 | 2023-05-03 09:19:59 | join | 1 | 13983 | 8 | 0.250 | 55932.0 |
1465 | 2023-04-02 10:59:17 | join | 2 | 29872 | 205 | 0.830 | 35990.4 |
1464 | 2023-04-01 12:39:31 | join | 2 | 29872 | 205 | 0.800 | 37340.0 |
1463 | 2023-03-31 12:38:04 | join | 2 | 29872 | 205 | 1.593 | 18752.0 |
1462 | 2023-03-30 13:08:30 | join | 2 | 29872 | 205 | 0.736 | 40587.0 |