History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doe"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3643 | 2025-05-22 20:36:08 | doe | 2 | 14084 | 602 | 0.376 | 37457.4 |
3642 | 2025-05-20 19:17:00 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
3641 | 2025-05-19 11:50:42 | doe | 2 | 14084 | 602 | 0.360 | 39122.2 |
3640 | 2025-05-18 20:41:09 | doe | 2 | 14084 | 602 | 0.423 | 33295.5 |
3639 | 2025-05-17 17:52:02 | doe | 2 | 14084 | 602 | 0.343 | 41061.2 |
3638 | 2025-05-16 12:52:33 | doe | 2 | 14084 | 602 | 1.690 | 8333.7 |
3637 | 2025-05-15 12:55:27 | doe | 2 | 14084 | 602 | 1.936 | 7274.8 |
3636 | 2025-05-15 10:40:15 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
3635 | 2025-05-13 03:34:24 | doe | 2 | 14084 | 602 | 1.920 | 7335.4 |
3634 | 2025-05-13 03:23:28 | doe | 1 | 5146 | 37 | 0.190 | 27084.2 |
3633 | 2025-05-12 22:15:03 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
3632 | 2025-05-12 21:03:42 | doe | 2 | 14084 | 602 | 0.810 | 17387.7 |
3631 | 2025-05-12 08:26:55 | doe | 2 | 14084 | 602 | 2.203 | 6393.1 |
3630 | 2025-05-11 21:03:47 | doe | 2 | 14084 | 602 | 1.970 | 7149.2 |
3629 | 2025-05-09 20:49:25 | doe | 2 | 14084 | 602 | 3.000 | 4694.7 |
3628 | 2025-05-09 18:39:20 | doe | 2 | 14084 | 602 | 0.346 | 40705.2 |
3627 | 2025-05-09 14:05:58 | doe | 2 | 14084 | 602 | 1.873 | 7519.5 |
3626 | 2025-05-09 02:26:04 | doe | 1 | 5146 | 37 | 0.156 | 32987.2 |
3625 | 2025-05-08 19:41:55 | doe | 2 | 14084 | 602 | 0.843 | 16707.0 |
3624 | 2025-05-08 14:13:47 | doe | 2 | 14084 | 602 | 0.830 | 16968.7 |
3623 | 2025-05-08 11:37:11 | doe | 2 | 14084 | 602 | 1.716 | 8207.5 |
3622 | 2025-05-08 10:13:37 | doe | 2 | 14084 | 602 | 2.393 | 5885.5 |
3621 | 2025-05-07 19:43:55 | doe | 2 | 14084 | 602 | 0.403 | 34947.9 |
3620 | 2025-05-07 14:19:43 | doe | 2 | 14084 | 602 | 0.420 | 33533.3 |
3619 | 2025-05-07 06:32:28 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
3618 | 2025-05-06 19:36:22 | doe | 2 | 14084 | 602 | 0.346 | 40705.2 |
3617 | 2025-05-06 14:27:00 | doe | 2 | 14084 | 602 | 1.546 | 9110.0 |
3616 | 2025-05-06 00:18:19 | doe | 1 | 5146 | 37 | 0.096 | 53604.2 |
3615 | 2025-05-05 15:15:18 | doe | 2 | 14084 | 602 | 0.360 | 39122.2 |
3614 | 2025-05-05 14:03:45 | doe | 2 | 14084 | 602 | 1.453 | 9693.0 |
3613 | 2025-05-04 19:15:32 | doe | 2 | 14084 | 602 | 0.373 | 37758.7 |
3612 | 2025-05-04 14:19:55 | doe | 2 | 14084 | 602 | 2.170 | 6490.3 |
3611 | 2025-05-03 19:20:30 | doe | 2 | 14084 | 602 | 0.373 | 37758.7 |
3610 | 2025-05-03 13:50:41 | doe | 2 | 14084 | 602 | 0.373 | 37758.7 |
3609 | 2025-05-03 10:29:38 | doe | 1 | 5146 | 37 | 0.500 | 10292.0 |
3608 | 2025-05-03 01:14:01 | doe | 1 | 5146 | 37 | 0.186 | 27666.7 |
3607 | 2025-05-02 00:42:54 | doe | 1 | 5146 | 37 | 0.563 | 9140.3 |
3606 | 2025-05-01 10:01:52 | doe | 1 | 5146 | 37 | 0.500 | 10292.0 |
3605 | 2025-05-01 09:41:37 | doe | 2 | 14084 | 602 | 2.093 | 6729.1 |
3604 | 2025-04-30 17:56:48 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
3603 | 2025-04-30 06:25:41 | doe | 2 | 14084 | 602 | 1.030 | 13673.8 |
3602 | 2025-04-30 02:04:07 | doe | 2 | 14084 | 602 | 2.733 | 5153.3 |
3601 | 2025-04-29 04:10:05 | doe | 1 | 5146 | 37 | 0.076 | 67710.5 |
3600 | 2025-04-29 01:35:03 | doe | 2 | 14084 | 602 | 0.403 | 34947.9 |
3599 | 2025-04-28 03:12:31 | doe | 2 | 14084 | 602 | 2.046 | 6883.7 |
3598 | 2025-04-28 03:00:58 | doe | 2 | 14084 | 602 | 0.860 | 16376.7 |
3597 | 2025-04-28 01:37:22 | doe | 2 | 14084 | 602 | 1.796 | 7841.9 |
3596 | 2025-04-27 06:43:30 | doe | 1 | 5146 | 37 | 0.200 | 25730.0 |
3595 | 2025-04-27 06:25:10 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
3594 | 2025-04-26 05:33:22 | doe | 1 | 5146 | 37 | 0.110 | 46781.8 |
3593 | 2025-04-26 03:26:07 | doe | 2 | 14084 | 602 | 3.046 | 4623.8 |
3592 | 2025-04-25 19:17:19 | doe | 1 | 5146 | 37 | 0.076 | 67710.5 |
3591 | 2025-04-25 04:51:50 | doe | 1 | 5146 | 37 | 0.500 | 10292.0 |
3590 | 2025-04-24 10:17:25 | doe | 2 | 14084 | 602 | 2.923 | 4818.3 |
3589 | 2025-04-23 10:07:09 | doe | 2 | 14084 | 602 | 0.873 | 16132.9 |
3588 | 2025-04-22 19:02:59 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
3587 | 2025-04-22 09:57:17 | doe | 2 | 14084 | 602 | 0.830 | 16968.7 |
3586 | 2025-04-22 00:07:13 | doe | 2 | 14084 | 602 | 0.843 | 16707.0 |
3585 | 2025-04-20 04:30:08 | doe | 2 | 14084 | 602 | 2.673 | 5269.0 |
3584 | 2025-04-20 02:36:26 | doe | 2 | 14084 | 602 | 1.970 | 7149.2 |
3583 | 2025-04-19 23:56:56 | doe | 2 | 14084 | 602 | 2.906 | 4846.5 |
3582 | 2025-04-19 16:41:21 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
3581 | 2025-04-19 10:46:11 | doe | 1 | 5146 | 37 | 0.076 | 67710.5 |
3580 | 2025-04-19 05:21:04 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
3579 | 2025-04-18 23:47:09 | doe | 2 | 14084 | 602 | 0.326 | 43202.5 |
3578 | 2025-04-18 05:28:16 | doe | 2 | 14084 | 602 | 0.860 | 16376.7 |
3577 | 2025-04-18 00:26:40 | doe | 2 | 14084 | 602 | 0.830 | 16968.7 |
3576 | 2025-04-16 23:53:57 | doe | 2 | 14084 | 602 | 0.376 | 37457.4 |
3575 | 2025-04-16 06:42:52 | doe | 1 | 5146 | 37 | 0.203 | 25349.8 |
3574 | 2025-04-15 17:17:32 | doe | 1 | 5146 | 37 | 0.076 | 67710.5 |
3573 | 2025-04-15 12:38:28 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
3572 | 2025-04-15 04:33:15 | doe | 2 | 14084 | 602 | 2.296 | 6134.1 |
3571 | 2025-04-15 04:25:50 | doe | 1 | 5146 | 37 | 0.593 | 8677.9 |
3570 | 2025-04-15 02:20:22 | doe | 1 | 5146 | 37 | 0.186 | 27666.7 |
3569 | 2025-04-14 23:55:46 | doe | 2 | 14084 | 602 | 1.920 | 7335.4 |
3568 | 2025-04-14 00:28:55 | doe | 2 | 14084 | 602 | 2.110 | 6674.9 |
3567 | 2025-04-13 20:27:12 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
3566 | 2025-04-13 04:20:07 | doe | 2 | 14084 | 602 | 0.326 | 43202.5 |
3565 | 2025-04-12 23:43:23 | doe | 2 | 14084 | 602 | 0.390 | 36112.8 |
3564 | 2025-04-12 09:20:44 | doe | 1 | 5146 | 37 | 0.516 | 9972.9 |
3563 | 2025-04-12 05:45:43 | doe | 2 | 14084 | 602 | 3.236 | 4352.3 |
3562 | 2025-04-12 02:44:36 | doe | 1 | 5146 | 37 | 0.406 | 12674.9 |
3561 | 2025-04-11 23:25:19 | doe | 2 | 14084 | 602 | 1.920 | 7335.4 |
3560 | 2025-04-10 06:12:07 | doe | 2 | 14084 | 602 | 0.783 | 17987.2 |
3559 | 2025-04-09 23:04:05 | doe | 2 | 14084 | 602 | 0.403 | 34947.9 |
3558 | 2025-04-09 22:32:04 | doe | 1 | 5146 | 37 | 0.190 | 27084.2 |
3557 | 2025-04-08 16:12:23 | doe | 2 | 14084 | 602 | 0.423 | 33295.5 |
3556 | 2025-04-08 07:26:46 | doe | 1 | 5146 | 37 | 0.093 | 55333.3 |
3555 | 2025-04-07 16:04:49 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
3554 | 2025-04-07 05:00:09 | doe | 2 | 14084 | 602 | 1.656 | 8504.8 |
3553 | 2025-04-06 23:19:14 | doe | 2 | 14084 | 602 | 1.686 | 8353.5 |
3552 | 2025-04-06 16:06:53 | doe | 2 | 14084 | 602 | 0.860 | 16376.7 |
3551 | 2025-04-06 07:25:02 | doe | 1 | 5146 | 37 | 0.576 | 8934.0 |
3550 | 2025-04-05 23:45:30 | doe | 1 | 5146 | 37 | 0.576 | 8934.0 |
3549 | 2025-04-05 23:12:11 | doe | 2 | 14084 | 602 | 2.580 | 5458.9 |
3548 | 2025-04-05 16:01:28 | doe | 2 | 14084 | 602 | 0.406 | 34689.7 |
3547 | 2025-04-05 04:28:48 | doe | 1 | 5146 | 37 | 0.076 | 67710.5 |
3546 | 2025-04-02 22:03:39 | doe | 1 | 5146 | 37 | 0.140 | 36757.1 |
3545 | 2025-04-01 17:01:48 | doe | 2 | 14084 | 602 | 0.343 | 41061.2 |
3544 | 2025-03-31 12:11:34 | doe | 1 | 5146 | 37 | 0.643 | 8003.1 |