History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knife"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3709 | 2024-04-26 02:59:38 | knife | 3 | 83667 | 712 | 3.296 | 25384.4 |
3708 | 2024-04-24 23:27:36 | knife | 2 | 53800 | 39 | 2.110 | 25497.6 |
3707 | 2024-04-23 04:45:16 | knife | 3 | 83667 | 712 | 13.313 | 6284.6 |
3706 | 2024-04-22 23:15:45 | knife | 1 | 28756 | 4 | 0.593 | 48492.4 |
3705 | 2024-04-21 06:40:19 | knife | 1 | 28756 | 4 | 0.483 | 59536.2 |
3704 | 2024-04-19 19:55:36 | knife | 1 | 28756 | 4 | 0.546 | 52666.7 |
3703 | 2024-04-18 21:46:45 | knife | 1 | 28756 | 4 | 0.436 | 65954.1 |
3702 | 2024-04-17 21:34:42 | knife | 3 | 83667 | 712 | 9.703 | 8622.8 |
3701 | 2024-04-17 08:37:39 | knife | 1 | 28756 | 4 | 0.423 | 67981.1 |
3700 | 2024-04-16 00:32:50 | knife | 1 | 28756 | 4 | 0.423 | 67981.1 |
3699 | 2024-04-13 14:07:06 | knife | 1 | 28756 | 4 | 0.483 | 59536.2 |
3698 | 2024-04-12 21:22:13 | knife | 2 | 53800 | 39 | 1.736 | 30990.8 |
3697 | 2024-04-12 12:33:55 | knife | 1 | 28756 | 4 | 0.940 | 30591.5 |
3696 | 2024-04-12 11:28:34 | knife | 1 | 28756 | 4 | 1.063 | 27051.7 |
3695 | 2024-04-12 10:51:04 | knife | 3 | 83667 | 712 | 12.593 | 6643.9 |
3694 | 2024-04-12 10:41:41 | knife | 1 | 28756 | 4 | 1.423 | 20208.0 |
3693 | 2024-04-12 10:21:32 | knife | 3 | 83667 | 712 | 7.140 | 11718.1 |
3692 | 2024-04-12 10:10:07 | knife | 1 | 28756 | 4 | 0.686 | 41918.4 |
3691 | 2024-04-12 10:06:38 | knife | 1 | 28756 | 4 | 1.670 | 17219.2 |
3690 | 2024-04-12 01:54:38 | knife | 2 | 53800 | 39 | 3.703 | 14528.8 |
3689 | 2024-04-11 05:43:26 | knife | 1 | 28756 | 4 | 1.080 | 26625.9 |
3688 | 2024-04-09 17:25:21 | knife | 1 | 28756 | 4 | 0.516 | 55728.7 |
3687 | 2024-04-08 22:16:44 | knife | 1 | 28756 | 4 | 2.563 | 11219.7 |
3686 | 2024-04-06 00:32:45 | knife | 1 | 28756 | 4 | 0.483 | 59536.2 |
3685 | 2024-04-05 17:33:47 | knife | 3 | 83667 | 712 | 13.906 | 6016.6 |
3684 | 2024-04-04 19:54:58 | knife | 3 | 83667 | 712 | 17.110 | 4889.9 |
3683 | 2024-04-04 06:54:45 | knife | 3 | 83667 | 712 | 5.296 | 15798.1 |
3682 | 2024-04-04 06:54:46 | knife | 2 | 53800 | 39 | 3.406 | 15795.7 |
3681 | 2024-04-04 06:54:38 | knife | 1 | 28756 | 4 | 0.626 | 45936.1 |
3680 | 2024-04-04 06:54:31 | knife | 3 | 83667 | 712 | 7.110 | 11767.5 |
3679 | 2024-04-04 06:54:31 | knife | 2 | 53800 | 39 | 1.673 | 32157.8 |
3678 | 2024-04-04 06:54:13 | knife | 1 | 28756 | 4 | 0.516 | 55728.7 |
3677 | 2024-03-27 08:17:37 | knife | 1 | 28756 | 4 | 1.063 | 27051.7 |
3676 | 2024-03-26 17:48:10 | knife | 2 | 53800 | 39 | 1.530 | 35163.4 |
3675 | 2024-03-09 00:26:44 | knife | 1 | 28756 | 4 | 1.063 | 27051.7 |
3674 | 2024-03-08 10:54:56 | knife | 1 | 28756 | 4 | 0.593 | 48492.4 |
3673 | 2024-03-06 21:26:36 | knife | 1 | 28756 | 4 | 1.733 | 16593.2 |
3672 | 2024-03-05 18:35:40 | knife | 3 | 83667 | 712 | 13.483 | 6205.4 |
3671 | 2024-03-05 11:09:17 | knife | 3 | 83667 | 712 | 3.890 | 21508.2 |
3670 | 2024-03-05 08:49:08 | knife | 1 | 28756 | 4 | 1.106 | 26000.0 |
3669 | 2024-03-04 23:54:24 | knife | 2 | 53800 | 39 | 1.373 | 39184.3 |
3668 | 2024-03-04 23:54:22 | knife | 1 | 28756 | 4 | 0.466 | 61708.2 |
3667 | 2024-03-04 23:54:02 | knife | 3 | 83667 | 712 | 3.796 | 22040.8 |
3666 | 2024-03-04 18:37:12 | knife | 2 | 53800 | 39 | 1.766 | 30464.3 |
3665 | 2024-03-04 04:20:17 | knife | 1 | 28756 | 4 | 1.060 | 27128.3 |
3664 | 2024-03-03 20:45:21 | knife | 2 | 53800 | 39 | 3.106 | 17321.3 |
3663 | 2024-03-03 20:44:24 | knife | 3 | 83667 | 712 | 3.703 | 22594.4 |
3662 | 2024-03-03 19:47:37 | knife | 3 | 83667 | 712 | 3.216 | 26015.9 |
3661 | 2024-02-25 19:23:01 | knife | 2 | 53800 | 39 | 1.530 | 35163.4 |
3660 | 2024-02-25 19:22:58 | knife | 1 | 28756 | 4 | 0.483 | 59536.2 |
3659 | 2024-02-25 15:48:33 | knife | 1 | 28756 | 4 | 0.486 | 59168.7 |
3658 | 2024-02-22 14:18:37 | knife | 3 | 83667 | 712 | 4.436 | 18860.9 |
3657 | 2024-02-22 14:18:06 | knife | 3 | 83667 | 712 | 11.436 | 7316.1 |
3656 | 2024-02-21 07:16:31 | knife | 1 | 28756 | 4 | 0.533 | 53951.2 |
3655 | 2024-02-21 06:19:41 | knife | 1 | 28756 | 4 | 0.530 | 54256.6 |
3654 | 2024-02-05 22:17:22 | knife | 1 | 28756 | 4 | 0.500 | 57512.0 |
3653 | 2024-02-03 17:31:11 | knife | 1 | 28756 | 4 | 0.500 | 57512.0 |
3652 | 2024-02-03 17:05:54 | knife | 1 | 28756 | 4 | 0.500 | 57512.0 |
3651 | 2024-02-02 21:42:08 | knife | 1 | 28756 | 4 | 0.423 | 67981.1 |
3650 | 2024-01-31 00:36:53 | knife | 1 | 28756 | 4 | 0.486 | 59168.7 |
3649 | 2024-01-30 21:36:43 | knife | 2 | 53800 | 39 | 1.563 | 34421.0 |
3648 | 2024-01-30 21:36:15 | knife | 3 | 83667 | 712 | 3.186 | 26260.8 |
3647 | 2024-01-28 23:15:58 | knife | 3 | 83667 | 712 | 3.766 | 22216.4 |
3646 | 2024-01-27 00:44:53 | knife | 1 | 28756 | 4 | 0.483 | 59536.2 |
3645 | 2024-01-26 15:24:53 | knife | 1 | 28756 | 4 | 0.500 | 57512.0 |
3644 | 2024-01-26 13:12:01 | knife | 1 | 28756 | 4 | 0.466 | 61708.2 |
3643 | 2024-01-24 00:04:12 | knife | 1 | 28756 | 4 | 0.406 | 70827.6 |
3642 | 2024-01-23 03:51:26 | knife | 3 | 83667 | 712 | 4.403 | 19002.3 |
3641 | 2024-01-23 01:05:49 | knife | 1 | 28756 | 4 | 0.436 | 65954.1 |
3640 | 2024-01-12 09:57:10 | knife | 1 | 28756 | 4 | 0.466 | 61708.2 |
3639 | 2024-01-12 07:52:25 | knife | 3 | 83667 | 712 | 3.720 | 22491.1 |
3638 | 2024-01-07 17:21:50 | knife | 1 | 28756 | 4 | 0.470 | 61183.0 |
3637 | 2024-01-06 21:12:11 | knife | 1 | 28756 | 4 | 0.470 | 61183.0 |
3636 | 2024-01-03 09:44:29 | knife | 1 | 28756 | 4 | 0.546 | 52666.7 |
3635 | 2023-12-29 04:25:34 | knife | 1 | 28756 | 4 | 0.453 | 63479.0 |
3634 | 2023-12-15 09:47:54 | knife | 1 | 28756 | 4 | 0.483 | 59536.2 |
3633 | 2023-12-09 10:51:48 | knife | 1 | 28756 | 4 | 0.410 | 70136.6 |
3632 | 2023-12-02 16:29:10 | knife | 1 | 28756 | 4 | 0.423 | 67981.1 |
3631 | 2023-11-30 23:42:40 | knife | 2 | 53800 | 39 | 1.516 | 35488.1 |
3630 | 2023-11-28 14:35:22 | knife | 1 | 28756 | 4 | 0.470 | 61183.0 |
3629 | 2023-11-24 20:37:11 | knife | 3 | 83667 | 712 | 3.610 | 23176.5 |
3628 | 2023-11-24 04:34:06 | knife | 1 | 28756 | 4 | 0.406 | 70827.6 |
3627 | 2023-11-23 18:51:20 | knife | 1 | 28756 | 4 | 0.466 | 61708.2 |
3626 | 2023-11-22 23:33:53 | knife | 3 | 83667 | 712 | 3.593 | 23286.1 |
3625 | 2023-11-19 21:03:09 | knife | 3 | 83667 | 712 | 4.233 | 19765.4 |
3624 | 2023-11-08 11:37:33 | knife | 2 | 53800 | 39 | 1.313 | 40974.9 |
3623 | 2023-11-08 11:37:19 | knife | 3 | 83667 | 712 | 3.890 | 21508.2 |
3622 | 2023-11-08 08:14:02 | knife | 1 | 28756 | 4 | 0.406 | 70827.6 |
3621 | 2023-11-08 02:05:50 | knife | 1 | 28756 | 4 | 0.466 | 61708.2 |
3620 | 2023-11-07 23:36:25 | knife | 2 | 53800 | 39 | 1.310 | 41068.7 |
3619 | 2023-11-07 23:36:22 | knife | 3 | 83667 | 712 | 3.156 | 26510.5 |
3618 | 2023-11-07 21:47:04 | knife | 1 | 28756 | 4 | 0.513 | 56054.6 |
3617 | 2023-11-07 18:57:08 | knife | 1 | 28756 | 4 | 0.420 | 68466.7 |
3616 | 2023-11-07 10:05:22 | knife | 3 | 83667 | 712 | 3.626 | 23074.2 |
3615 | 2023-11-07 10:05:17 | knife | 2 | 53800 | 39 | 1.546 | 34799.5 |
3614 | 2023-11-07 07:12:00 | knife | 1 | 28756 | 4 | 0.436 | 65954.1 |
3613 | 2023-11-07 04:43:22 | knife | 1 | 28756 | 4 | 0.533 | 53951.2 |
3612 | 2023-11-06 20:20:26 | knife | 3 | 83667 | 712 | 4.390 | 19058.5 |
3611 | 2023-11-06 20:20:19 | knife | 2 | 53800 | 39 | 2.203 | 24421.2 |
3610 | 2023-11-06 15:47:30 | knife | 3 | 83667 | 712 | 3.903 | 21436.6 |