History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jesse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1555 | 2024-04-28 05:12:04 | jesse | 1 | 28756 | 5 | 0.546 | 52666.7 |
1554 | 2024-04-27 15:54:07 | jesse | 1 | 28756 | 5 | 1.233 | 23322.0 |
1553 | 2024-04-20 23:19:23 | jesse | 1 | 28756 | 5 | 0.873 | 32939.3 |
1552 | 2024-04-03 06:27:28 | jesse | 1 | 28756 | 5 | 0.546 | 52666.7 |
1551 | 2024-03-28 07:26:56 | jesse | 3 | 83667 | 1114 | 3.950 | 21181.5 |
1550 | 2024-03-27 06:57:11 | jesse | 1 | 28756 | 5 | 1.063 | 27051.7 |
1549 | 2024-03-20 18:18:45 | jesse | 1 | 28756 | 5 | 0.533 | 53951.2 |
1548 | 2024-03-04 01:02:56 | jesse | 1 | 28756 | 5 | 0.420 | 68466.7 |
1547 | 2024-03-02 18:27:39 | jesse | 2 | 53800 | 75 | 5.483 | 9812.1 |
1546 | 2024-03-01 22:08:22 | jesse | 3 | 83667 | 1114 | 8.826 | 9479.6 |
1545 | 2024-03-01 22:08:17 | jesse | 2 | 53800 | 75 | 4.830 | 11138.7 |
1544 | 2024-03-01 13:08:34 | jesse | 3 | 83667 | 1114 | 3.686 | 22698.6 |
1543 | 2024-03-01 13:08:35 | jesse | 2 | 53800 | 75 | 1.593 | 33772.8 |
1542 | 2024-02-25 22:00:08 | jesse | 2 | 53800 | 75 | 1.813 | 29674.6 |
1541 | 2024-02-25 19:26:24 | jesse | 1 | 28756 | 5 | 0.483 | 59536.2 |
1540 | 2024-02-18 20:16:24 | jesse | 1 | 28756 | 5 | 1.046 | 27491.4 |
1539 | 2024-01-28 22:49:59 | jesse | 1 | 28756 | 5 | 0.486 | 59168.7 |
1538 | 2024-01-26 20:42:37 | jesse | 1 | 28756 | 5 | 0.483 | 59536.2 |
1537 | 2024-01-21 20:30:45 | jesse | 1 | 28756 | 5 | 0.406 | 70827.6 |
1536 | 2024-01-17 23:58:26 | jesse | 1 | 28756 | 5 | 0.516 | 55728.7 |
1535 | 2024-01-16 22:54:35 | jesse | 1 | 28756 | 5 | 0.500 | 57512.0 |
1534 | 2024-01-14 18:50:06 | jesse | 2 | 53800 | 75 | 1.330 | 40451.1 |
1533 | 2024-01-14 00:12:44 | jesse | 1 | 28756 | 5 | 0.453 | 63479.0 |
1532 | 2024-01-07 21:33:33 | jesse | 3 | 83667 | 1114 | 3.300 | 25353.6 |
1531 | 2024-01-03 23:40:38 | jesse | 2 | 53800 | 75 | 1.423 | 37807.4 |
1530 | 2023-12-12 19:45:52 | jesse | 2 | 53800 | 75 | 1.390 | 38705.0 |
1529 | 2023-11-24 09:43:10 | jesse | 1 | 28756 | 5 | 0.436 | 65954.1 |
1528 | 2023-11-21 21:29:20 | jesse | 2 | 53800 | 75 | 1.313 | 40974.9 |
1527 | 2023-11-18 23:52:02 | jesse | 1 | 28756 | 5 | 0.420 | 68466.7 |
1526 | 2023-11-15 10:58:19 | jesse | 3 | 83667 | 1114 | 3.826 | 21868.0 |
1525 | 2023-11-14 01:32:06 | jesse | 1 | 28756 | 5 | 0.486 | 59168.7 |
1524 | 2023-11-09 08:41:02 | jesse | 3 | 83667 | 1114 | 3.893 | 21491.7 |
1523 | 2023-11-07 23:36:01 | jesse | 3 | 83667 | 1114 | 3.593 | 23286.1 |
1522 | 2023-11-07 12:59:13 | jesse | 3 | 83667 | 1114 | 3.376 | 24782.9 |
1521 | 2023-11-07 09:21:21 | jesse | 3 | 83667 | 1114 | 7.753 | 10791.6 |
1520 | 2023-11-07 09:21:04 | jesse | 3 | 83667 | 1114 | 12.813 | 6529.9 |
1519 | 2023-11-06 23:45:37 | jesse | 3 | 83667 | 1114 | 3.280 | 25508.2 |
1518 | 2023-11-06 12:04:19 | jesse | 3 | 83667 | 1114 | 3.660 | 22859.8 |
1517 | 2023-11-05 12:09:52 | jesse | 3 | 83667 | 1114 | 3.763 | 22234.1 |
1516 | 2023-11-04 12:23:25 | jesse | 3 | 83667 | 1114 | 3.266 | 25617.6 |
1515 | 2023-11-04 02:28:19 | jesse | 3 | 83667 | 1114 | 3.390 | 24680.5 |
1514 | 2023-11-03 13:12:48 | jesse | 3 | 83667 | 1114 | 3.203 | 26121.4 |
1513 | 2023-11-02 12:34:20 | jesse | 3 | 83667 | 1114 | 3.763 | 22234.1 |
1512 | 2023-11-02 05:54:42 | jesse | 3 | 83667 | 1114 | 3.563 | 23482.2 |
1511 | 2023-11-01 05:44:56 | jesse | 3 | 83667 | 1114 | 3.233 | 25879.1 |
1510 | 2023-10-31 19:19:36 | jesse | 3 | 83667 | 1114 | 4.090 | 20456.5 |
1509 | 2023-10-31 19:06:23 | jesse | 3 | 83667 | 1114 | 4.063 | 20592.4 |
1508 | 2023-10-31 05:42:30 | jesse | 3 | 83667 | 1114 | 3.220 | 25983.5 |
1507 | 2023-10-30 19:15:36 | jesse | 3 | 83667 | 1114 | 3.643 | 22966.5 |
1506 | 2023-10-30 19:12:27 | jesse | 3 | 83667 | 1114 | 3.860 | 21675.4 |
1505 | 2023-10-30 05:36:36 | jesse | 3 | 83667 | 1114 | 3.300 | 25353.6 |
1504 | 2023-10-29 18:37:10 | jesse | 3 | 83667 | 1114 | 3.610 | 23176.5 |
1503 | 2023-10-29 05:33:33 | jesse | 3 | 83667 | 1114 | 3.610 | 23176.5 |
1502 | 2023-10-28 19:05:54 | jesse | 3 | 83667 | 1114 | 3.313 | 25254.2 |
1501 | 2023-10-28 15:35:48 | jesse | 1 | 28756 | 5 | 0.470 | 61183.0 |
1500 | 2023-10-28 05:46:39 | jesse | 3 | 83667 | 1114 | 3.343 | 25027.5 |
1499 | 2023-10-27 20:11:33 | jesse | 3 | 83667 | 1114 | 3.720 | 22491.1 |
1498 | 2023-10-27 05:31:52 | jesse | 3 | 83667 | 1114 | 3.173 | 26368.4 |
1497 | 2023-10-27 05:02:57 | jesse | 3 | 83667 | 1114 | 3.966 | 21096.1 |
1496 | 2023-10-26 19:48:17 | jesse | 3 | 83667 | 1114 | 4.063 | 20592.4 |
1495 | 2023-10-26 06:02:56 | jesse | 3 | 83667 | 1114 | 3.203 | 26121.4 |
1494 | 2023-10-25 18:58:41 | jesse | 3 | 83667 | 1114 | 3.733 | 22412.8 |
1493 | 2023-10-25 12:30:47 | jesse | 3 | 83667 | 1114 | 3.656 | 22884.8 |
1492 | 2023-10-24 20:16:29 | jesse | 3 | 83667 | 1114 | 4.000 | 20916.8 |
1491 | 2023-10-24 18:54:19 | jesse | 3 | 83667 | 1114 | 3.626 | 23074.2 |
1490 | 2023-10-24 12:29:41 | jesse | 3 | 83667 | 1114 | 3.516 | 23796.1 |
1489 | 2023-10-23 18:51:29 | jesse | 3 | 83667 | 1114 | 6.016 | 13907.4 |
1488 | 2023-10-23 13:39:20 | jesse | 2 | 53800 | 75 | 1.470 | 36598.6 |
1487 | 2023-10-23 13:23:00 | jesse | 3 | 83667 | 1114 | 3.750 | 22311.2 |
1486 | 2023-10-22 18:36:47 | jesse | 3 | 83667 | 1114 | 3.890 | 21508.2 |
1485 | 2023-10-22 13:13:37 | jesse | 3 | 83667 | 1114 | 4.673 | 17904.3 |
1484 | 2023-10-21 21:47:29 | jesse | 3 | 83667 | 1114 | 6.373 | 13128.4 |
1483 | 2023-10-21 20:18:00 | jesse | 3 | 83667 | 1114 | 3.156 | 26510.5 |
1482 | 2023-10-21 15:48:04 | jesse | 1 | 28756 | 5 | 0.436 | 65954.1 |
1481 | 2023-10-21 13:23:48 | jesse | 3 | 83667 | 1114 | 3.140 | 26645.5 |
1480 | 2023-10-20 20:55:43 | jesse | 3 | 83667 | 1114 | 6.423 | 13026.2 |
1479 | 2023-10-20 13:13:14 | jesse | 3 | 83667 | 1114 | 3.296 | 25384.4 |
1478 | 2023-10-20 06:53:06 | jesse | 1 | 28756 | 5 | 0.453 | 63479.0 |
1477 | 2023-10-19 17:41:30 | jesse | 3 | 83667 | 1114 | 4.596 | 18204.3 |
1476 | 2023-10-19 14:50:52 | jesse | 3 | 83667 | 1114 | 3.576 | 23396.8 |
1475 | 2023-10-19 03:56:46 | jesse | 1 | 28756 | 5 | 0.500 | 57512.0 |
1474 | 2023-10-18 14:41:31 | jesse | 3 | 83667 | 1114 | 3.546 | 23594.8 |
1473 | 2023-10-18 00:21:56 | jesse | 3 | 83667 | 1114 | 3.466 | 24139.4 |
1472 | 2023-10-17 14:18:25 | jesse | 3 | 83667 | 1114 | 3.313 | 25254.2 |
1471 | 2023-10-17 00:56:09 | jesse | 3 | 83667 | 1114 | 3.470 | 24111.5 |
1470 | 2023-10-16 20:03:27 | jesse | 3 | 83667 | 1114 | 7.640 | 10951.2 |
1469 | 2023-10-16 12:21:49 | jesse | 3 | 83667 | 1114 | 3.420 | 24464.0 |
1468 | 2023-10-16 02:31:57 | jesse | 3 | 83667 | 1114 | 3.390 | 24680.5 |
1467 | 2023-10-16 01:44:41 | jesse | 3 | 83667 | 1114 | 3.686 | 22698.6 |
1466 | 2023-10-15 13:32:52 | jesse | 3 | 83667 | 1114 | 3.393 | 24658.7 |
1465 | 2023-10-15 01:09:11 | jesse | 3 | 83667 | 1114 | 3.343 | 25027.5 |
1464 | 2023-10-14 14:29:37 | jesse | 3 | 83667 | 1114 | 6.826 | 12257.1 |
1463 | 2023-10-14 14:10:17 | jesse | 1 | 28756 | 5 | 0.470 | 61183.0 |
1462 | 2023-10-14 05:57:00 | jesse | 3 | 83667 | 1114 | 3.533 | 23681.6 |
1461 | 2023-10-13 07:03:46 | jesse | 3 | 83667 | 1114 | 3.483 | 24021.5 |
1460 | 2023-10-13 06:02:10 | jesse | 3 | 83667 | 1114 | 3.216 | 26015.9 |
1459 | 2023-10-12 05:59:16 | jesse | 3 | 83667 | 1114 | 3.843 | 21771.3 |
1458 | 2023-10-11 16:45:06 | jesse | 3 | 83667 | 1114 | 3.890 | 21508.2 |
1457 | 2023-10-11 04:07:41 | jesse | 3 | 83667 | 1114 | 3.373 | 24804.9 |
1456 | 2023-10-10 04:36:27 | jesse | 3 | 83667 | 1114 | 3.703 | 22594.4 |