History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
812 | 2024-12-27 14:36:00 | perks | 1 | 28756 | 18 | 0.500 | 57512.0 |
811 | 2024-12-27 03:56:19 | perks | 1 | 28756 | 18 | 0.560 | 51350.0 |
810 | 2024-12-23 04:39:19 | perks | 1 | 28756 | 18 | 1.656 | 17364.7 |
809 | 2024-12-21 00:56:33 | perks | 2 | 53800 | 222 | 11.313 | 4755.6 |
808 | 2024-12-20 04:51:56 | perks | 2 | 53800 | 222 | 3.313 | 16239.1 |
807 | 2024-11-27 06:36:54 | perks | 2 | 53800 | 222 | 7.376 | 7293.9 |
806 | 2024-11-27 06:16:39 | perks | 2 | 53800 | 222 | 6.736 | 7986.9 |
805 | 2024-11-27 03:54:09 | perks | 1 | 28756 | 18 | 1.360 | 21144.1 |
804 | 2024-11-27 03:46:14 | perks | 2 | 53800 | 222 | 4.326 | 12436.4 |
803 | 2024-11-27 03:39:45 | perks | 1 | 28756 | 18 | 0.453 | 63479.0 |
802 | 2024-11-07 06:29:13 | perks | 1 | 28756 | 18 | 2.326 | 12362.9 |
801 | 2024-10-30 04:57:14 | perks | 1 | 28756 | 18 | 0.530 | 54256.6 |
800 | 2024-10-28 05:57:31 | perks | 2 | 53800 | 222 | 8.076 | 6661.7 |
799 | 2024-10-28 00:23:23 | perks | 1 | 28756 | 18 | 1.733 | 16593.2 |
798 | 2024-10-27 23:59:59 | perks | 2 | 53800 | 222 | 9.657 | 5571.1 |
797 | 2024-10-27 22:22:29 | perks | 2 | 53800 | 222 | 3.843 | 13999.5 |
796 | 2024-10-27 21:10:01 | perks | 1 | 28756 | 18 | 0.496 | 57975.8 |
795 | 2024-10-27 04:27:53 | perks | 1 | 28756 | 18 | 1.280 | 22465.6 |
794 | 2024-10-07 14:33:56 | perks | 1 | 28756 | 18 | 1.390 | 20687.8 |
793 | 2024-09-28 00:10:41 | perks | 1 | 28756 | 18 | 0.530 | 54256.6 |
792 | 2024-09-27 14:59:24 | perks | 2 | 53800 | 222 | 13.080 | 4113.1 |
791 | 2024-09-27 13:34:17 | perks | 2 | 53800 | 222 | 18.076 | 2976.3 |
790 | 2024-09-27 11:39:06 | perks | 2 | 53800 | 222 | 8.263 | 6511.0 |
789 | 2024-09-27 11:24:15 | perks | 1 | 28756 | 18 | 0.513 | 56054.6 |
788 | 2024-09-27 02:16:10 | perks | 1 | 28756 | 18 | 1.796 | 16011.1 |
787 | 2024-09-09 06:42:01 | perks | 1 | 28756 | 18 | 3.953 | 7274.5 |
786 | 2024-08-29 21:37:53 | perks | 1 | 28756 | 18 | 1.983 | 14501.3 |
785 | 2024-08-28 18:10:07 | perks | 1 | 28756 | 18 | 1.563 | 18398.0 |
784 | 2024-08-28 03:44:05 | perks | 1 | 28756 | 18 | 4.373 | 6575.8 |
783 | 2024-08-27 05:19:06 | perks | 1 | 28756 | 18 | 3.766 | 7635.7 |
782 | 2024-08-10 01:49:02 | perks | 2 | 53800 | 222 | 7.000 | 7685.7 |
781 | 2024-08-10 01:34:53 | perks | 1 | 28756 | 18 | 1.093 | 26309.2 |
780 | 2024-08-08 01:34:56 | perks | 1 | 28756 | 18 | 2.690 | 10690.0 |
779 | 2024-07-29 16:08:38 | perks | 1 | 28756 | 18 | 2.046 | 14054.7 |
778 | 2024-07-29 07:42:02 | perks | 1 | 28756 | 18 | 2.076 | 13851.6 |
777 | 2024-07-29 00:53:48 | perks | 1 | 28756 | 18 | 1.203 | 23903.6 |
776 | 2024-07-28 00:20:39 | perks | 1 | 28756 | 18 | 1.376 | 20898.3 |
775 | 2024-07-21 11:49:56 | perks | 1 | 28756 | 18 | 1.686 | 17055.8 |
774 | 2024-07-21 11:49:47 | perks | 1 | 28756 | 18 | 1.970 | 14597.0 |
773 | 2024-07-10 12:00:29 | perks | 1 | 28756 | 18 | 2.780 | 10343.9 |
772 | 2024-07-05 20:38:45 | perks | 1 | 28756 | 18 | 1.280 | 22465.6 |
771 | 2024-07-05 10:11:23 | perks | 1 | 28756 | 18 | 2.200 | 13070.9 |
770 | 2024-07-05 09:32:21 | perks | 1 | 28756 | 18 | 1.580 | 18200.0 |
769 | 2024-07-05 09:32:18 | perks | 1 | 28756 | 18 | 1.936 | 14853.3 |
768 | 2024-07-05 09:16:09 | perks | 1 | 28756 | 18 | 1.610 | 17860.9 |
767 | 2024-06-29 14:01:26 | perks | 1 | 28756 | 18 | 0.593 | 48492.4 |
766 | 2024-06-29 00:52:31 | perks | 1 | 28756 | 18 | 2.733 | 10521.8 |
765 | 2024-06-28 03:45:25 | perks | 2 | 53800 | 222 | 6.033 | 8917.6 |
764 | 2024-06-28 03:37:01 | perks | 2 | 53800 | 222 | 8.063 | 6672.5 |
763 | 2024-06-28 01:51:22 | perks | 2 | 53800 | 222 | 7.516 | 7158.1 |
762 | 2024-06-28 00:05:36 | perks | 2 | 53800 | 222 | 6.706 | 8022.7 |
761 | 2024-06-28 00:05:24 | perks | 1 | 28756 | 18 | 1.936 | 14853.3 |
760 | 2024-06-27 14:07:43 | perks | 1 | 28756 | 18 | 1.576 | 18246.2 |
759 | 2024-06-25 22:58:04 | perks | 1 | 28756 | 18 | 1.016 | 28303.1 |
758 | 2024-06-20 02:00:10 | perks | 1 | 28756 | 18 | 2.173 | 13233.3 |
757 | 2024-05-30 09:00:15 | perks | 1 | 28756 | 18 | 1.500 | 19170.7 |
756 | 2024-05-29 22:22:24 | perks | 1 | 28756 | 18 | 0.623 | 46157.3 |
755 | 2024-05-28 22:54:54 | perks | 1 | 28756 | 18 | 1.640 | 17534.1 |
754 | 2024-05-28 07:36:13 | perks | 1 | 28756 | 18 | 1.063 | 27051.7 |
753 | 2024-05-16 17:45:15 | perks | 1 | 28756 | 18 | 0.563 | 51076.4 |
752 | 2024-05-16 15:22:27 | perks | 1 | 28756 | 18 | 0.516 | 55728.7 |
751 | 2024-05-11 15:35:34 | perks | 2 | 53800 | 222 | 1.860 | 28924.7 |
750 | 2024-05-04 04:38:31 | perks | 1 | 28756 | 18 | 0.483 | 59536.2 |
749 | 2024-04-25 22:53:54 | perks | 1 | 28756 | 18 | 0.610 | 47141.0 |
748 | 2024-04-03 02:50:38 | perks | 1 | 28756 | 18 | 1.156 | 24875.4 |
747 | 2024-03-30 20:55:26 | perks | 2 | 53800 | 222 | 1.906 | 28226.7 |
746 | 2024-03-30 20:45:52 | perks | 1 | 28756 | 18 | 1.030 | 27918.4 |
745 | 2024-03-29 04:29:23 | perks | 1 | 28756 | 18 | 0.546 | 52666.7 |
744 | 2024-03-26 22:00:35 | perks | 1 | 28756 | 18 | 1.360 | 21144.1 |
743 | 2024-03-10 10:44:52 | perks | 1 | 28756 | 18 | 0.593 | 48492.4 |
742 | 2024-03-10 01:45:08 | perks | 1 | 28756 | 18 | 0.576 | 49923.6 |
741 | 2024-03-01 05:56:31 | perks | 1 | 28756 | 18 | 0.500 | 57512.0 |
740 | 2024-02-28 10:32:27 | perks | 1 | 28756 | 18 | 1.236 | 23265.4 |
739 | 2024-02-24 08:55:56 | perks | 1 | 28756 | 18 | 0.436 | 65954.1 |
738 | 2024-01-27 21:38:28 | perks | 1 | 28756 | 18 | 0.486 | 59168.7 |
737 | 2024-01-26 13:12:41 | perks | 1 | 28756 | 18 | 0.546 | 52666.7 |
736 | 2024-01-16 09:55:42 | perks | 2 | 53800 | 222 | 1.390 | 38705.0 |
735 | 2024-01-07 08:01:57 | perks | 2 | 53800 | 222 | 1.640 | 32804.9 |
734 | 2023-12-24 17:52:50 | perks | 1 | 28756 | 18 | 0.453 | 63479.0 |
733 | 2023-12-14 03:23:27 | perks | 1 | 28756 | 18 | 0.453 | 63479.0 |
732 | 2023-11-24 08:30:24 | perks | 2 | 53800 | 222 | 1.763 | 30516.2 |
731 | 2023-11-21 20:33:11 | perks | 1 | 28756 | 18 | 0.453 | 63479.0 |
730 | 2023-11-18 04:53:55 | perks | 1 | 28756 | 18 | 0.513 | 56054.6 |
729 | 2023-11-14 09:06:57 | perks | 1 | 28756 | 18 | 1.030 | 27918.4 |
728 | 2023-11-09 14:46:47 | perks | 1 | 28756 | 18 | 0.436 | 65954.1 |
727 | 2023-10-27 08:11:53 | perks | 1 | 28756 | 18 | 0.500 | 57512.0 |
726 | 2023-10-24 03:09:22 | perks | 1 | 28756 | 18 | 0.500 | 57512.0 |
725 | 2023-10-19 18:52:21 | perks | 1 | 28756 | 18 | 0.500 | 57512.0 |
724 | 2023-10-16 14:39:15 | perks | 1 | 28756 | 18 | 0.453 | 63479.0 |
723 | 2023-10-05 21:50:31 | perks | 1 | 28756 | 18 | 1.016 | 28303.1 |
722 | 2023-09-29 09:37:36 | perks | 1 | 28756 | 18 | 0.436 | 65954.1 |
721 | 2023-09-27 17:33:00 | perks | 1 | 28756 | 18 | 0.466 | 61708.2 |
720 | 2023-09-22 07:10:41 | perks | 1 | 28756 | 18 | 0.436 | 65954.1 |
719 | 2023-07-27 03:16:38 | perks | 1 | 28756 | 18 | 0.453 | 63479.0 |
718 | 2023-07-24 23:25:04 | perks | 1 | 28756 | 18 | 0.453 | 63479.0 |
717 | 2023-04-24 17:35:43 | perks | 1 | 28756 | 18 | 1.000 | 28756.0 |
716 | 2023-04-05 20:58:49 | perks | 1 | 28756 | 18 | 0.466 | 61708.2 |
715 | 2023-02-12 18:55:27 | perks | 1 | 28756 | 18 | 0.483 | 59536.2 |
714 | 2022-12-20 13:46:42 | perks | 1 | 28756 | 18 | 0.483 | 59536.2 |
713 | 2022-12-11 05:50:34 | perks | 1 | 28756 | 18 | 0.483 | 59536.2 |