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 |
| 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 |
| 3609 | 2023-11-06 14:47:22 | knife | 2 | 53800 | 39 | 1.390 | 38705.0 |
| 3608 | 2023-11-06 12:51:27 | knife | 1 | 28756 | 4 | 0.423 | 67981.1 |