History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1554 | 2024-04-26 14:25:17 | cole | 1 | 13983 | 29 | 0.216 | 64736.1 |
1553 | 2024-04-20 00:31:01 | cole | 1 | 13983 | 29 | 0.280 | 49939.3 |
1552 | 2024-04-09 18:02:57 | cole | 2 | 29872 | 517 | 1.013 | 29488.6 |
1551 | 2024-04-04 23:06:48 | cole | 1 | 13983 | 29 | 0.250 | 55932.0 |
1550 | 2024-03-31 00:29:24 | cole | 1 | 13983 | 29 | 0.873 | 16017.2 |
1549 | 2024-03-24 08:07:11 | cole | 1 | 13983 | 29 | 0.860 | 16259.3 |
1548 | 2024-03-06 04:32:36 | cole | 1 | 13983 | 29 | 0.923 | 15149.5 |
1547 | 2024-03-05 21:11:13 | cole | 1 | 13983 | 29 | 0.216 | 64736.1 |
1546 | 2024-02-29 22:25:37 | cole | 1 | 13983 | 29 | 0.233 | 60012.9 |
1545 | 2024-02-25 17:09:05 | cole | 1 | 13983 | 29 | 0.250 | 55932.0 |
1544 | 2024-02-03 00:44:54 | cole | 1 | 13983 | 29 | 0.483 | 28950.3 |
1543 | 2024-01-26 15:22:25 | cole | 1 | 13983 | 29 | 0.220 | 63559.1 |
1542 | 2024-01-10 07:45:34 | cole | 1 | 13983 | 29 | 0.220 | 63559.1 |
1541 | 2023-12-29 04:30:25 | cole | 1 | 13983 | 29 | 0.250 | 55932.0 |
1540 | 2023-12-29 04:20:26 | cole | 1 | 13983 | 29 | 0.233 | 60012.9 |
1539 | 2023-12-10 22:36:41 | cole | 2 | 29872 | 517 | 0.906 | 32971.3 |
1538 | 2023-12-07 01:24:55 | cole | 1 | 13983 | 29 | 0.216 | 64736.1 |
1537 | 2023-12-07 01:24:54 | cole | 1 | 13983 | 29 | 0.216 | 64736.1 |
1536 | 2023-12-03 07:18:32 | cole | 1 | 13983 | 29 | 0.466 | 30006.4 |
1535 | 2023-11-29 21:32:20 | cole | 1 | 13983 | 29 | 0.250 | 55932.0 |
1534 | 2023-11-19 16:41:06 | cole | 1 | 13983 | 29 | 0.266 | 52567.7 |
1533 | 2023-11-14 10:38:24 | cole | 1 | 13983 | 29 | 0.220 | 63559.1 |
1532 | 2023-11-12 04:21:50 | cole | 1 | 13983 | 29 | 0.220 | 63559.1 |
1531 | 2023-11-11 02:14:11 | cole | 1 | 13983 | 29 | 0.250 | 55932.0 |
1530 | 2023-11-09 10:50:40 | cole | 1 | 13983 | 29 | 0.233 | 60012.9 |
1529 | 2023-11-09 04:28:46 | cole | 2 | 29872 | 517 | 0.813 | 36742.9 |
1528 | 2023-11-08 11:57:52 | cole | 1 | 13983 | 29 | 0.220 | 63559.1 |
1527 | 2023-11-07 23:04:06 | cole | 2 | 29872 | 517 | 0.860 | 34734.9 |
1526 | 2023-11-07 15:41:19 | cole | 2 | 29872 | 517 | 0.860 | 34734.9 |
1525 | 2023-11-07 09:25:41 | cole | 2 | 29872 | 517 | 0.906 | 32971.3 |
1524 | 2023-11-06 16:16:43 | cole | 2 | 29872 | 517 | 0.860 | 34734.9 |
1523 | 2023-11-05 15:32:23 | cole | 2 | 29872 | 517 | 0.796 | 37527.6 |
1522 | 2023-11-04 16:24:19 | cole | 2 | 29872 | 517 | 0.766 | 38997.4 |
1521 | 2023-11-04 04:53:28 | cole | 2 | 29872 | 517 | 0.750 | 39829.3 |
1520 | 2023-11-03 16:21:52 | cole | 2 | 29872 | 517 | 0.843 | 35435.3 |
1519 | 2023-11-03 09:43:15 | cole | 1 | 13983 | 29 | 0.236 | 59250.0 |
1518 | 2023-11-02 15:32:09 | cole | 2 | 29872 | 517 | 0.796 | 37527.6 |
1517 | 2023-11-02 06:47:10 | cole | 2 | 29872 | 517 | 0.923 | 32364.0 |
1516 | 2023-11-01 06:27:55 | cole | 2 | 29872 | 517 | 0.920 | 32469.6 |
1515 | 2023-10-31 22:43:47 | cole | 2 | 29872 | 517 | 0.826 | 36164.6 |
1514 | 2023-10-31 20:02:32 | cole | 2 | 29872 | 517 | 0.783 | 38150.7 |
1513 | 2023-10-31 06:39:35 | cole | 2 | 29872 | 517 | 1.220 | 24485.2 |
1512 | 2023-10-30 20:08:57 | cole | 2 | 29872 | 517 | 1.203 | 24831.3 |
1511 | 2023-10-30 06:40:09 | cole | 2 | 29872 | 517 | 0.826 | 36164.6 |
1510 | 2023-10-29 06:07:21 | cole | 2 | 29872 | 517 | 0.860 | 34734.9 |
1509 | 2023-10-28 06:29:23 | cole | 2 | 29872 | 517 | 1.140 | 26203.5 |
1508 | 2023-10-27 22:26:31 | cole | 1 | 13983 | 29 | 0.220 | 63559.1 |
1507 | 2023-10-27 06:13:06 | cole | 2 | 29872 | 517 | 0.873 | 34217.6 |
1506 | 2023-10-27 02:57:29 | cole | 2 | 29872 | 517 | 0.873 | 34217.6 |
1505 | 2023-10-26 10:10:24 | cole | 2 | 29872 | 517 | 0.953 | 31345.2 |
1504 | 2023-10-26 06:03:26 | cole | 2 | 29872 | 517 | 0.750 | 39829.3 |
1503 | 2023-10-25 19:52:30 | cole | 2 | 29872 | 517 | 0.906 | 32971.3 |
1502 | 2023-10-25 05:38:30 | cole | 2 | 29872 | 517 | 1.016 | 29401.6 |
1501 | 2023-10-25 05:38:23 | cole | 2 | 29872 | 517 | 1.030 | 29001.9 |
1500 | 2023-10-25 02:52:53 | cole | 2 | 29872 | 517 | 0.750 | 39829.3 |
1499 | 2023-10-24 19:50:25 | cole | 2 | 29872 | 517 | 1.533 | 19486.0 |
1498 | 2023-10-24 03:23:01 | cole | 2 | 29872 | 517 | 0.873 | 34217.6 |
1497 | 2023-10-23 19:49:06 | cole | 2 | 29872 | 517 | 1.016 | 29401.6 |
1496 | 2023-10-23 12:33:38 | cole | 2 | 29872 | 517 | 0.906 | 32971.3 |
1495 | 2023-10-22 11:54:56 | cole | 2 | 29872 | 517 | 0.843 | 35435.3 |
1494 | 2023-10-22 10:16:26 | cole | 1 | 13983 | 29 | 0.516 | 27098.8 |
1493 | 2023-10-21 21:18:42 | cole | 2 | 29872 | 517 | 0.906 | 32971.3 |
1492 | 2023-10-21 12:07:45 | cole | 2 | 29872 | 517 | 0.783 | 38150.7 |
1491 | 2023-10-20 12:47:57 | cole | 2 | 29872 | 517 | 0.843 | 35435.3 |
1490 | 2023-10-19 23:26:52 | cole | 2 | 29872 | 517 | 0.983 | 30388.6 |
1489 | 2023-10-19 20:01:17 | cole | 1 | 13983 | 29 | 0.266 | 52567.7 |
1488 | 2023-10-19 16:13:05 | cole | 2 | 29872 | 517 | 0.906 | 32971.3 |
1487 | 2023-10-19 10:43:42 | cole | 2 | 29872 | 517 | 0.763 | 39150.7 |
1486 | 2023-10-18 22:35:54 | cole | 2 | 29872 | 517 | 0.873 | 34217.6 |
1485 | 2023-10-18 10:28:24 | cole | 2 | 29872 | 517 | 0.876 | 34100.5 |
1484 | 2023-10-17 22:29:22 | cole | 2 | 29872 | 517 | 0.830 | 35990.4 |
1483 | 2023-10-17 10:03:53 | cole | 2 | 29872 | 517 | 1.033 | 28917.7 |
1482 | 2023-10-17 08:17:08 | cole | 1 | 13983 | 29 | 0.266 | 52567.7 |
1481 | 2023-10-16 19:56:44 | cole | 2 | 29872 | 517 | 1.080 | 27659.3 |
1480 | 2023-10-16 12:49:04 | cole | 2 | 29872 | 517 | 0.780 | 38297.4 |
1479 | 2023-10-16 03:05:38 | cole | 2 | 29872 | 517 | 0.763 | 39150.7 |
1478 | 2023-10-15 02:38:30 | cole | 2 | 29872 | 517 | 0.860 | 34734.9 |
1477 | 2023-10-14 10:47:32 | cole | 2 | 29872 | 517 | 0.766 | 38997.4 |
1476 | 2023-10-13 22:47:57 | cole | 2 | 29872 | 517 | 0.766 | 38997.4 |
1475 | 2023-10-13 11:47:47 | cole | 2 | 29872 | 517 | 0.920 | 32469.6 |
1474 | 2023-10-12 22:29:18 | cole | 2 | 29872 | 517 | 0.810 | 36879.0 |
1473 | 2023-10-11 22:24:05 | cole | 2 | 29872 | 517 | 0.860 | 34734.9 |
1472 | 2023-10-11 21:37:32 | cole | 1 | 13983 | 29 | 0.233 | 60012.9 |
1471 | 2023-10-10 23:50:42 | cole | 2 | 29872 | 517 | 0.923 | 32364.0 |
1470 | 2023-10-10 22:55:21 | cole | 2 | 29872 | 517 | 0.796 | 37527.6 |
1469 | 2023-10-10 14:23:12 | cole | 2 | 29872 | 517 | 0.736 | 40587.0 |
1468 | 2023-10-09 23:07:48 | cole | 2 | 29872 | 517 | 0.796 | 37527.6 |
1467 | 2023-10-09 14:16:55 | cole | 2 | 29872 | 517 | 0.843 | 35435.3 |
1466 | 2023-10-08 23:00:35 | cole | 2 | 29872 | 517 | 0.923 | 32364.0 |
1465 | 2023-10-08 11:15:23 | cole | 2 | 29872 | 517 | 0.950 | 31444.2 |
1464 | 2023-10-08 02:01:54 | cole | 2 | 29872 | 517 | 0.766 | 38997.4 |
1463 | 2023-10-07 02:33:49 | cole | 2 | 29872 | 517 | 0.766 | 38997.4 |
1462 | 2023-10-06 04:21:04 | cole | 2 | 29872 | 517 | 3.110 | 9605.1 |
1461 | 2023-10-05 04:28:45 | cole | 2 | 29872 | 517 | 0.766 | 38997.4 |
1460 | 2023-10-04 13:18:47 | cole | 2 | 29872 | 517 | 0.830 | 35990.4 |
1459 | 2023-10-03 17:03:27 | cole | 1 | 13983 | 29 | 0.296 | 47239.9 |
1458 | 2023-10-03 14:33:03 | cole | 2 | 29872 | 517 | 0.953 | 31345.2 |
1457 | 2023-10-03 13:38:14 | cole | 2 | 29872 | 517 | 0.750 | 39829.3 |
1456 | 2023-10-02 13:36:17 | cole | 2 | 29872 | 517 | 0.873 | 34217.6 |
1455 | 2023-09-30 01:37:51 | cole | 2 | 29872 | 517 | 0.796 | 37527.6 |