History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
844 | 2024-05-01 23:24:22 | scots | 1 | 28756 | 19 | 1.670 | 17219.2 |
843 | 2024-05-01 23:24:18 | scots | 2 | 53800 | 226 | 3.720 | 14462.4 |
842 | 2024-04-29 11:53:34 | scots | 1 | 28756 | 19 | 1.013 | 28387.0 |
841 | 2024-04-02 20:48:31 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
840 | 2024-04-01 17:03:29 | scots | 2 | 53800 | 226 | 3.733 | 14412.0 |
839 | 2024-04-01 17:03:14 | scots | 1 | 28756 | 19 | 1.593 | 18051.5 |
838 | 2024-03-31 02:48:09 | scots | 1 | 28756 | 19 | 1.093 | 26309.2 |
837 | 2024-03-28 23:47:55 | scots | 2 | 53800 | 226 | 5.580 | 9641.6 |
836 | 2024-03-28 23:18:30 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
835 | 2024-03-02 14:42:31 | scots | 1 | 28756 | 19 | 0.623 | 46157.3 |
834 | 2024-02-27 22:26:51 | scots | 2 | 53800 | 226 | 1.843 | 29191.5 |
833 | 2024-02-27 20:56:56 | scots | 1 | 28756 | 19 | 0.530 | 54256.6 |
832 | 2024-02-22 22:47:48 | scots | 2 | 53800 | 226 | 1.813 | 29674.6 |
831 | 2024-01-30 02:19:54 | scots | 1 | 28756 | 19 | 1.016 | 28303.1 |
830 | 2024-01-19 18:16:21 | scots | 2 | 53800 | 226 | 1.373 | 39184.3 |
829 | 2024-01-06 12:51:38 | scots | 1 | 28756 | 19 | 0.546 | 52666.7 |
828 | 2024-01-01 18:46:56 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
827 | 2024-01-01 05:13:58 | scots | 2 | 53800 | 226 | 1.376 | 39098.8 |
826 | 2023-12-08 01:54:52 | scots | 2 | 53800 | 226 | 1.516 | 35488.1 |
825 | 2023-12-07 03:42:15 | scots | 1 | 28756 | 19 | 0.673 | 42728.1 |
824 | 2023-12-07 03:42:14 | scots | 1 | 28756 | 19 | 0.513 | 56054.6 |
823 | 2023-11-25 16:56:20 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
822 | 2023-11-25 06:54:24 | scots | 2 | 53800 | 226 | 1.390 | 38705.0 |
821 | 2023-11-22 09:42:08 | scots | 1 | 28756 | 19 | 0.533 | 53951.2 |
820 | 2023-11-20 21:33:34 | scots | 2 | 53800 | 226 | 1.610 | 33416.1 |
819 | 2023-11-17 15:54:48 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
818 | 2023-11-10 16:42:25 | scots | 1 | 28756 | 19 | 0.513 | 56054.6 |
817 | 2023-10-30 21:25:35 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
816 | 2023-10-22 02:27:07 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
815 | 2023-10-21 17:54:01 | scots | 2 | 53800 | 226 | 1.466 | 36698.5 |
814 | 2023-10-17 00:05:21 | scots | 1 | 28756 | 19 | 0.483 | 59536.2 |
813 | 2023-10-11 11:52:38 | scots | 1 | 28756 | 19 | 1.093 | 26309.2 |
812 | 2023-10-06 02:57:26 | scots | 1 | 28756 | 19 | 0.513 | 56054.6 |
811 | 2023-09-25 02:50:59 | scots | 1 | 28756 | 19 | 1.123 | 25606.4 |
810 | 2023-09-14 03:18:54 | scots | 1 | 28756 | 19 | 0.436 | 65954.1 |
809 | 2023-09-11 11:44:17 | scots | 1 | 28756 | 19 | 0.466 | 61708.2 |
808 | 2023-09-10 20:33:53 | scots | 1 | 28756 | 19 | 0.470 | 61183.0 |
807 | 2023-08-21 04:16:03 | scots | 2 | 53800 | 226 | 1.376 | 39098.8 |
806 | 2023-07-17 05:41:39 | scots | 1 | 28756 | 19 | 0.436 | 65954.1 |
805 | 2023-06-15 01:18:38 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
804 | 2023-05-28 03:38:22 | scots | 1 | 28756 | 19 | 0.466 | 61708.2 |
803 | 2023-05-24 20:30:34 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
802 | 2023-05-03 03:33:32 | scots | 2 | 53800 | 226 | 1.373 | 39184.3 |
801 | 2023-04-22 10:12:50 | scots | 2 | 53800 | 226 | 1.360 | 39558.8 |
800 | 2023-03-27 20:23:29 | scots | 1 | 28756 | 19 | 0.420 | 68466.7 |
799 | 2023-03-24 22:48:03 | scots | 2 | 53800 | 226 | 1.546 | 34799.5 |
798 | 2023-02-11 22:41:29 | scots | 2 | 53800 | 226 | 1.500 | 35866.7 |
797 | 2023-02-04 17:13:13 | scots | 1 | 28756 | 19 | 0.436 | 65954.1 |
796 | 2023-01-11 15:35:09 | scots | 1 | 28756 | 19 | 0.483 | 59536.2 |
795 | 2022-11-25 23:33:14 | scots | 1 | 28756 | 19 | 0.486 | 59168.7 |
794 | 2022-11-24 03:29:34 | scots | 1 | 28756 | 19 | 0.450 | 63902.2 |
793 | 2022-11-23 20:19:11 | scots | 2 | 53800 | 226 | 1.533 | 35094.6 |
792 | 2022-11-22 05:48:35 | scots | 1 | 28756 | 19 | 0.440 | 65354.5 |
791 | 2022-10-26 21:25:55 | scots | 1 | 28756 | 19 | 0.436 | 65954.1 |
790 | 2022-10-21 22:57:32 | scots | 1 | 28756 | 19 | 0.440 | 65354.5 |
789 | 2022-07-05 19:50:16 | scots | 1 | 28756 | 19 | 0.436 | 65954.1 |
788 | 2022-06-30 06:00:32 | scots | 2 | 53800 | 226 | 1.356 | 39675.5 |
787 | 2022-06-28 01:54:29 | scots | 2 | 53800 | 226 | 1.563 | 34421.0 |
786 | 2022-06-17 06:13:01 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
785 | 2022-06-15 00:13:01 | scots | 1 | 28756 | 19 | 0.440 | 65354.5 |
784 | 2022-03-11 16:24:12 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
783 | 2022-03-11 04:54:23 | scots | 1 | 28756 | 19 | 0.533 | 53951.2 |
782 | 2022-03-10 23:29:19 | scots | 1 | 28756 | 19 | 0.690 | 41675.4 |
781 | 2022-03-09 23:48:45 | scots | 1 | 28756 | 19 | 0.483 | 59536.2 |
780 | 2022-03-09 09:12:07 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
779 | 2022-03-08 14:43:31 | scots | 1 | 28756 | 19 | 0.596 | 48248.3 |
778 | 2022-03-08 05:31:03 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
777 | 2022-03-07 23:05:21 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
776 | 2022-03-07 07:25:45 | scots | 1 | 28756 | 19 | 0.436 | 65954.1 |
775 | 2022-03-06 11:57:31 | scots | 1 | 28756 | 19 | 0.530 | 54256.6 |
774 | 2022-03-05 10:37:57 | scots | 1 | 28756 | 19 | 0.516 | 55728.7 |
773 | 2022-03-04 18:08:43 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
772 | 2022-03-04 03:34:46 | scots | 1 | 28756 | 19 | 0.470 | 61183.0 |
771 | 2022-03-03 12:10:30 | scots | 1 | 28756 | 19 | 0.610 | 47141.0 |
770 | 2022-03-02 22:07:48 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
769 | 2022-03-02 10:18:10 | scots | 1 | 28756 | 19 | 0.750 | 38341.3 |
768 | 2022-03-01 13:46:23 | scots | 1 | 28756 | 19 | 0.606 | 47452.1 |
767 | 2022-02-28 11:47:26 | scots | 1 | 28756 | 19 | 0.733 | 39230.6 |
766 | 2022-02-27 18:17:34 | scots | 1 | 28756 | 19 | 0.470 | 61183.0 |
765 | 2022-02-27 06:48:59 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
764 | 2022-02-26 13:32:40 | scots | 1 | 28756 | 19 | 0.466 | 61708.2 |
763 | 2022-02-25 23:45:32 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
762 | 2022-02-25 11:18:34 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
761 | 2022-02-24 16:11:52 | scots | 1 | 28756 | 19 | 0.576 | 49923.6 |
760 | 2022-02-24 03:05:27 | scots | 1 | 28756 | 19 | 0.643 | 44721.6 |
759 | 2022-02-23 15:57:05 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
758 | 2022-02-22 20:48:22 | scots | 1 | 28756 | 19 | 0.516 | 55728.7 |
757 | 2022-02-22 01:55:12 | scots | 1 | 28756 | 19 | 0.733 | 39230.6 |
756 | 2022-02-21 05:46:12 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
755 | 2022-02-20 16:26:03 | scots | 1 | 28756 | 19 | 0.546 | 52666.7 |
754 | 2022-02-20 03:35:50 | scots | 1 | 28756 | 19 | 0.533 | 53951.2 |
753 | 2022-02-19 10:12:32 | scots | 1 | 28756 | 19 | 0.453 | 63479.0 |
752 | 2022-02-18 23:22:20 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
751 | 2022-02-18 11:13:00 | scots | 1 | 28756 | 19 | 0.516 | 55728.7 |
750 | 2022-02-18 05:44:31 | scots | 1 | 28756 | 19 | 0.516 | 55728.7 |
749 | 2022-02-18 00:44:06 | scots | 1 | 28756 | 19 | 0.500 | 57512.0 |
748 | 2022-02-17 12:39:01 | scots | 1 | 28756 | 19 | 0.530 | 54256.6 |
747 | 2022-02-16 21:04:49 | scots | 1 | 28756 | 19 | 0.516 | 55728.7 |
746 | 2022-02-16 03:01:19 | scots | 1 | 28756 | 19 | 0.890 | 32310.1 |
745 | 2022-02-15 06:56:54 | scots | 1 | 28756 | 19 | 0.436 | 65954.1 |