History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hello"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1549 | 2024-04-30 14:43:19 | hello | 1 | 28756 | 12 | 1.656 | 17364.7 |
1548 | 2024-04-30 07:49:03 | hello | 1 | 28756 | 12 | 0.546 | 52666.7 |
1547 | 2024-04-30 07:48:11 | hello | 1 | 28756 | 12 | 0.530 | 54256.6 |
1546 | 2024-04-26 11:17:26 | hello | 1 | 28756 | 12 | 0.546 | 52666.7 |
1545 | 2024-04-26 08:50:09 | hello | 1 | 28756 | 12 | 0.530 | 54256.6 |
1544 | 2024-04-22 06:21:22 | hello | 1 | 28756 | 12 | 2.016 | 14263.9 |
1543 | 2024-04-20 21:40:57 | hello | 2 | 53800 | 111 | 5.236 | 10275.0 |
1542 | 2024-04-20 21:40:39 | hello | 1 | 28756 | 12 | 1.966 | 14626.7 |
1541 | 2024-04-20 21:40:26 | hello | 2 | 53800 | 111 | 4.203 | 12800.4 |
1540 | 2024-04-16 20:13:17 | hello | 2 | 53800 | 111 | 3.376 | 15936.0 |
1539 | 2024-04-11 12:54:19 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1538 | 2024-04-10 14:53:38 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |
1537 | 2024-04-02 22:18:08 | hello | 2 | 53800 | 111 | 3.720 | 14462.4 |
1536 | 2024-04-02 21:43:08 | hello | 1 | 28756 | 12 | 0.530 | 54256.6 |
1535 | 2024-03-30 22:31:39 | hello | 1 | 28756 | 12 | 1.390 | 20687.8 |
1534 | 2024-03-30 05:38:01 | hello | 1 | 28756 | 12 | 0.513 | 56054.6 |
1533 | 2024-03-29 08:13:33 | hello | 1 | 28756 | 12 | 1.030 | 27918.4 |
1532 | 2024-03-23 02:38:31 | hello | 1 | 28756 | 12 | 1.733 | 16593.2 |
1531 | 2024-03-20 18:56:18 | hello | 1 | 28756 | 12 | 0.546 | 52666.7 |
1530 | 2024-03-20 18:55:48 | hello | 2 | 53800 | 111 | 3.310 | 16253.8 |
1529 | 2024-03-11 23:43:50 | hello | 1 | 28756 | 12 | 0.546 | 52666.7 |
1528 | 2024-03-02 17:55:59 | hello | 1 | 28756 | 12 | 0.596 | 48248.3 |
1527 | 2024-02-28 01:25:26 | hello | 2 | 53800 | 111 | 2.216 | 24278.0 |
1526 | 2024-02-28 01:20:31 | hello | 1 | 28756 | 12 | 1.093 | 26309.2 |
1525 | 2024-02-27 13:50:37 | hello | 2 | 53800 | 111 | 1.766 | 30464.3 |
1524 | 2024-02-25 05:16:31 | hello | 2 | 53800 | 111 | 1.406 | 38264.6 |
1523 | 2024-02-21 21:14:04 | hello | 1 | 28756 | 12 | 0.533 | 53951.2 |
1522 | 2024-02-18 07:30:39 | hello | 2 | 53800 | 111 | 5.513 | 9758.8 |
1521 | 2024-01-28 23:07:45 | hello | 1 | 28756 | 12 | 0.516 | 55728.7 |
1520 | 2024-01-20 11:47:29 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1519 | 2024-01-20 07:05:53 | hello | 2 | 53800 | 111 | 1.656 | 32487.9 |
1518 | 2023-12-23 22:12:25 | hello | 2 | 53800 | 111 | 1.483 | 36277.8 |
1517 | 2023-12-21 23:25:49 | hello | 1 | 28756 | 12 | 0.420 | 68466.7 |
1516 | 2023-12-12 03:35:06 | hello | 2 | 53800 | 111 | 1.673 | 32157.8 |
1515 | 2023-11-25 06:42:41 | hello | 1 | 28756 | 12 | 1.000 | 28756.0 |
1514 | 2023-11-18 10:26:52 | hello | 2 | 53800 | 111 | 1.546 | 34799.5 |
1513 | 2023-11-17 22:55:13 | hello | 1 | 28756 | 12 | 0.653 | 44036.8 |
1512 | 2023-11-11 04:42:43 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1511 | 2023-10-31 01:57:24 | hello | 2 | 53800 | 111 | 1.360 | 39558.8 |
1510 | 2023-10-29 22:25:45 | hello | 1 | 28756 | 12 | 0.533 | 53951.2 |
1509 | 2023-10-23 23:02:55 | hello | 2 | 53800 | 111 | 1.360 | 39558.8 |
1508 | 2023-10-20 20:02:45 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1507 | 2023-10-20 19:37:00 | hello | 1 | 28756 | 12 | 0.486 | 59168.7 |
1506 | 2023-10-13 03:15:26 | hello | 2 | 53800 | 111 | 1.606 | 33499.4 |
1505 | 2023-10-10 14:11:32 | hello | 1 | 28756 | 12 | 0.470 | 61183.0 |
1504 | 2023-10-09 14:25:24 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1503 | 2023-10-05 01:34:29 | hello | 1 | 28756 | 12 | 0.450 | 63902.2 |
1502 | 2023-09-26 14:18:18 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1501 | 2023-09-23 14:27:59 | hello | 1 | 28756 | 12 | 0.466 | 61708.2 |
1500 | 2023-08-20 14:03:30 | hello | 2 | 53800 | 111 | 1.360 | 39558.8 |
1499 | 2023-08-09 06:05:25 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1498 | 2023-08-05 11:49:22 | hello | 1 | 28756 | 12 | 0.466 | 61708.2 |
1497 | 2023-05-04 13:50:13 | hello | 2 | 53800 | 111 | 1.373 | 39184.3 |
1496 | 2023-05-02 09:26:39 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |
1495 | 2023-05-01 16:01:49 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1494 | 2023-02-23 22:02:36 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |
1493 | 2023-02-07 13:04:37 | hello | 2 | 53800 | 111 | 1.500 | 35866.7 |
1492 | 2023-01-19 09:14:13 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1491 | 2023-01-17 00:21:18 | hello | 2 | 53800 | 111 | 1.390 | 38705.0 |
1490 | 2023-01-15 15:52:24 | hello | 1 | 28756 | 12 | 0.466 | 61708.2 |
1489 | 2022-12-23 09:21:07 | hello | 2 | 53800 | 111 | 1.313 | 40974.9 |
1488 | 2022-12-20 13:46:46 | hello | 1 | 28756 | 12 | 0.420 | 68466.7 |
1487 | 2022-11-25 19:29:57 | hello | 1 | 28756 | 12 | 0.500 | 57512.0 |
1486 | 2022-11-21 01:55:25 | hello | 2 | 53800 | 111 | 1.360 | 39558.8 |
1485 | 2022-09-28 01:09:40 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1484 | 2022-09-18 11:21:03 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |
1483 | 2022-09-17 19:45:59 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |
1482 | 2022-09-09 11:09:40 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |
1481 | 2022-09-01 13:02:15 | hello | 1 | 28756 | 12 | 0.470 | 61183.0 |
1480 | 2022-08-26 04:07:59 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1479 | 2022-08-17 15:14:43 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1478 | 2022-08-15 11:17:44 | hello | 1 | 28756 | 12 | 0.470 | 61183.0 |
1477 | 2022-08-14 04:46:17 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1476 | 2022-08-06 05:22:54 | hello | 1 | 28756 | 12 | 0.440 | 65354.5 |
1475 | 2022-07-10 03:00:54 | hello | 1 | 28756 | 12 | 0.420 | 68466.7 |
1474 | 2022-05-31 18:22:34 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |
1473 | 2022-05-07 02:34:15 | hello | 2 | 53800 | 111 | 1.356 | 39675.5 |
1472 | 2022-04-14 18:11:57 | hello | 1 | 28756 | 12 | 0.690 | 41675.4 |
1471 | 2022-04-12 14:36:27 | hello | 1 | 28756 | 12 | 0.483 | 59536.2 |
1470 | 2022-02-13 17:38:07 | hello | 1 | 28756 | 12 | 0.546 | 52666.7 |
1469 | 2022-01-12 14:33:59 | hello | 1 | 28756 | 12 | 0.440 | 65354.5 |
1468 | 2021-11-08 13:47:10 | hello | 1 | 28756 | 12 | 0.500 | 57512.0 |
1467 | 2021-11-05 21:41:41 | hello | 1 | 28756 | 12 | 0.530 | 54256.6 |
1466 | 2021-10-25 08:26:22 | hello | 1 | 28756 | 12 | 0.546 | 52666.7 |
1465 | 2021-09-19 17:51:15 | hello | 1 | 28756 | 12 | 0.533 | 53951.2 |
1464 | 2021-08-31 01:20:48 | hello | 1 | 28756 | 12 | 0.440 | 65354.5 |
1463 | 2021-08-22 02:54:10 | hello | 1 | 28756 | 12 | 0.513 | 56054.6 |
1462 | 2021-08-06 04:30:29 | hello | 1 | 28756 | 12 | 0.440 | 65354.5 |
1461 | 2021-08-02 16:48:45 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1460 | 2021-07-23 01:14:00 | hello | 2 | 53800 | 111 | 1.466 | 36698.5 |
1459 | 2021-07-23 00:57:14 | hello | 2 | 53800 | 111 | 1.483 | 36277.8 |
1458 | 2021-06-28 05:39:29 | hello | 1 | 28756 | 12 | 0.500 | 57512.0 |
1457 | 2021-04-24 16:01:30 | hello | 1 | 28756 | 12 | 1.000 | 28756.0 |
1456 | 2021-03-21 19:53:45 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1455 | 2021-03-15 11:09:46 | hello | 2 | 53800 | 111 | 1.373 | 39184.3 |
1454 | 2021-01-24 14:12:39 | hello | 1 | 28756 | 12 | 0.440 | 65354.5 |
1453 | 2021-01-23 19:27:51 | hello | 1 | 28756 | 12 | 0.450 | 63902.2 |
1452 | 2020-11-30 11:34:59 | hello | 2 | 53800 | 111 | 1.420 | 37887.3 |
1451 | 2020-11-29 07:02:06 | hello | 1 | 28756 | 12 | 0.453 | 63479.0 |
1450 | 2020-11-14 09:03:09 | hello | 1 | 28756 | 12 | 0.436 | 65954.1 |