History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bilbo"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
765 | 2024-03-15 23:35:42 | bilbo | 1 | 28756 | 5 | 1.716 | 16757.6 |
764 | 2024-03-07 13:24:24 | bilbo | 3 | 83667 | 689 | 4.906 | 17054.0 |
763 | 2024-03-06 11:50:29 | bilbo | 1 | 28756 | 5 | 1.750 | 16432.0 |
762 | 2024-03-06 11:50:09 | bilbo | 2 | 53800 | 44 | 5.783 | 9303.1 |
761 | 2024-03-06 11:49:58 | bilbo | 3 | 83667 | 689 | 9.313 | 8983.9 |
760 | 2024-03-06 11:49:51 | bilbo | 1 | 28756 | 5 | 1.153 | 24940.2 |
759 | 2024-03-03 21:42:23 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
758 | 2024-03-01 05:53:52 | bilbo | 1 | 28756 | 5 | 0.546 | 52666.7 |
757 | 2024-02-27 23:05:14 | bilbo | 2 | 53800 | 44 | 1.763 | 30516.2 |
756 | 2024-02-27 23:04:56 | bilbo | 3 | 83667 | 689 | 4.970 | 16834.4 |
755 | 2024-02-27 22:29:29 | bilbo | 3 | 83667 | 689 | 4.313 | 19398.8 |
754 | 2024-02-27 22:29:23 | bilbo | 2 | 53800 | 44 | 1.826 | 29463.3 |
753 | 2024-02-27 20:55:42 | bilbo | 1 | 28756 | 5 | 0.470 | 61183.0 |
752 | 2024-02-18 00:23:27 | bilbo | 1 | 28756 | 5 | 0.546 | 52666.7 |
751 | 2024-02-02 19:19:03 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
750 | 2024-01-29 01:22:27 | bilbo | 1 | 28756 | 5 | 0.466 | 61708.2 |
749 | 2024-01-28 20:45:01 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
748 | 2024-01-08 03:46:46 | bilbo | 3 | 83667 | 689 | 3.703 | 22594.4 |
747 | 2023-12-30 05:43:06 | bilbo | 3 | 83667 | 689 | 3.813 | 21942.6 |
746 | 2023-12-30 05:43:07 | bilbo | 2 | 53800 | 44 | 1.796 | 29955.5 |
745 | 2023-12-28 23:53:03 | bilbo | 3 | 83667 | 689 | 3.483 | 24021.5 |
744 | 2023-12-28 23:53:05 | bilbo | 2 | 53800 | 44 | 1.546 | 34799.5 |
743 | 2023-12-28 07:11:45 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
742 | 2023-11-25 13:52:12 | bilbo | 3 | 83667 | 689 | 4.030 | 20761.0 |
741 | 2023-11-15 22:46:32 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
740 | 2023-11-14 20:43:31 | bilbo | 3 | 83667 | 689 | 4.000 | 20916.8 |
739 | 2023-11-14 20:43:28 | bilbo | 2 | 53800 | 44 | 1.626 | 33087.3 |
738 | 2023-11-13 22:32:44 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
737 | 2023-11-13 00:42:27 | bilbo | 1 | 28756 | 5 | 0.516 | 55728.7 |
736 | 2023-11-04 05:19:23 | bilbo | 1 | 28756 | 5 | 0.483 | 59536.2 |
735 | 2023-10-21 10:10:47 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
734 | 2023-10-18 15:42:29 | bilbo | 1 | 28756 | 5 | 0.546 | 52666.7 |
733 | 2023-10-18 05:16:20 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
732 | 2023-10-13 14:37:03 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
731 | 2023-10-05 02:45:38 | bilbo | 1 | 28756 | 5 | 0.440 | 65354.5 |
730 | 2023-09-30 09:10:43 | bilbo | 3 | 83667 | 689 | 3.203 | 26121.4 |
729 | 2023-09-30 09:10:40 | bilbo | 2 | 53800 | 44 | 1.513 | 35558.5 |
728 | 2023-09-28 10:46:10 | bilbo | 3 | 83667 | 689 | 3.376 | 24782.9 |
727 | 2023-09-28 10:46:09 | bilbo | 2 | 53800 | 44 | 1.423 | 37807.4 |
726 | 2023-09-24 21:56:42 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
725 | 2023-09-22 08:32:10 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
724 | 2023-08-25 15:32:22 | bilbo | 3 | 83667 | 689 | 3.250 | 25743.7 |
723 | 2023-08-23 06:23:16 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
722 | 2023-08-14 17:39:30 | bilbo | 1 | 28756 | 5 | 0.546 | 52666.7 |
721 | 2023-08-02 11:05:10 | bilbo | 1 | 28756 | 5 | 0.530 | 54256.6 |
720 | 2023-06-15 18:15:02 | bilbo | 3 | 83667 | 689 | 3.796 | 22040.8 |
719 | 2023-05-25 11:48:35 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
718 | 2023-05-17 23:23:06 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
717 | 2023-05-08 04:52:14 | bilbo | 3 | 83667 | 689 | 3.173 | 26368.4 |
716 | 2023-04-25 01:21:09 | bilbo | 1 | 28756 | 5 | 0.420 | 68466.7 |
715 | 2023-03-31 14:20:12 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
714 | 2023-03-19 05:35:18 | bilbo | 1 | 28756 | 5 | 0.440 | 65354.5 |
713 | 2023-03-15 23:16:23 | bilbo | 1 | 28756 | 5 | 0.873 | 32939.3 |
712 | 2023-02-14 04:56:40 | bilbo | 3 | 83667 | 689 | 3.423 | 24442.6 |
711 | 2023-01-08 23:01:10 | bilbo | 1 | 28756 | 5 | 0.483 | 59536.2 |
710 | 2023-01-04 07:16:42 | bilbo | 1 | 28756 | 5 | 0.440 | 65354.5 |
709 | 2023-01-02 14:18:45 | bilbo | 3 | 83667 | 689 | 3.640 | 22985.4 |
708 | 2022-11-25 04:57:01 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
707 | 2022-11-24 06:25:33 | bilbo | 3 | 83667 | 689 | 6.580 | 12715.3 |
706 | 2022-09-26 19:02:38 | bilbo | 1 | 28756 | 5 | 0.440 | 65354.5 |
705 | 2022-09-21 13:29:26 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
704 | 2022-09-18 23:21:29 | bilbo | 1 | 28756 | 5 | 0.513 | 56054.6 |
703 | 2022-07-10 07:03:01 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
702 | 2022-07-02 17:29:56 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
701 | 2022-06-15 21:18:26 | bilbo | 1 | 28756 | 5 | 0.466 | 61708.2 |
700 | 2022-06-08 03:45:41 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
699 | 2022-05-11 19:14:56 | bilbo | 1 | 28756 | 5 | 0.513 | 56054.6 |
698 | 2022-04-30 23:10:54 | bilbo | 3 | 83667 | 689 | 3.736 | 22394.8 |
697 | 2022-02-28 03:47:58 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
696 | 2022-01-30 19:58:08 | bilbo | 1 | 28756 | 5 | 0.546 | 52666.7 |
695 | 2021-12-31 16:51:55 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
694 | 2021-12-29 14:28:52 | bilbo | 3 | 83667 | 689 | 4.266 | 19612.5 |
693 | 2021-12-03 20:42:25 | bilbo | 1 | 28756 | 5 | 0.470 | 61183.0 |
692 | 2021-11-23 21:16:32 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
691 | 2021-11-23 08:15:26 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
690 | 2021-10-13 19:42:08 | bilbo | 3 | 83667 | 689 | 3.500 | 23904.9 |
689 | 2021-10-07 13:29:25 | bilbo | 1 | 28756 | 5 | 0.533 | 53951.2 |
688 | 2021-09-05 10:46:21 | bilbo | 1 | 28756 | 5 | 0.470 | 61183.0 |
687 | 2021-08-20 07:47:07 | bilbo | 1 | 28756 | 5 | 0.483 | 59536.2 |
686 | 2021-08-18 20:32:02 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
685 | 2021-05-19 15:04:03 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
684 | 2021-04-19 23:31:06 | bilbo | 1 | 28756 | 5 | 0.500 | 57512.0 |
683 | 2021-04-18 20:06:57 | bilbo | 1 | 28756 | 5 | 0.483 | 59536.2 |
682 | 2021-04-17 18:30:31 | bilbo | 1 | 28756 | 5 | 1.033 | 27837.4 |
681 | 2021-02-16 17:51:42 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
680 | 2020-11-12 11:56:09 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
679 | 2020-10-30 10:30:21 | bilbo | 1 | 28756 | 5 | 0.906 | 31739.5 |
678 | 2020-10-26 00:00:32 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
677 | 2020-09-10 09:13:40 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
676 | 2020-08-21 12:25:29 | bilbo | 1 | 28756 | 5 | 0.466 | 61708.2 |
675 | 2020-08-08 22:54:06 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
674 | 2020-06-12 19:02:57 | bilbo | 1 | 28756 | 5 | 0.453 | 63479.0 |
673 | 2020-05-07 17:27:06 | bilbo | 1 | 28756 | 5 | 0.436 | 65954.1 |
672 | 2020-03-28 05:34:50 | bilbo | 3 | 83667 | 689 | 6.186 | 13525.2 |
671 | 2020-03-26 02:39:00 | bilbo | 1 | 28756 | 5 | 0.483 | 59536.2 |
670 | 2020-03-24 16:03:40 | bilbo | 1 | 28756 | 5 | 0.533 | 53951.2 |
669 | 2020-03-24 05:41:07 | bilbo | 3 | 83667 | 689 | 4.046 | 20678.9 |
668 | 2020-03-22 12:06:22 | bilbo | 1 | 28756 | 5 | 0.950 | 30269.5 |
667 | 2020-03-22 09:08:14 | bilbo | 3 | 83667 | 689 | 4.140 | 20209.4 |
666 | 2020-03-21 21:09:56 | bilbo | 1 | 28756 | 5 | 0.513 | 56054.6 |