History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shire"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
842 | 2024-05-03 17:08:28 | shire | 1 | 28756 | 13 | 0.543 | 52957.6 |
841 | 2024-04-30 11:10:21 | shire | 1 | 28756 | 13 | 1.110 | 25906.3 |
840 | 2024-04-29 11:23:37 | shire | 1 | 28756 | 13 | 2.080 | 13825.0 |
839 | 2024-04-28 11:58:32 | shire | 2 | 53800 | 215 | 1.706 | 31535.8 |
838 | 2024-04-27 15:26:46 | shire | 2 | 53800 | 215 | 1.936 | 27789.3 |
837 | 2024-04-27 12:01:40 | shire | 1 | 28756 | 13 | 1.016 | 28303.1 |
836 | 2024-04-26 08:37:09 | shire | 1 | 28756 | 13 | 0.563 | 51076.4 |
835 | 2024-04-18 22:24:41 | shire | 1 | 28756 | 13 | 0.563 | 51076.4 |
834 | 2024-04-03 03:24:40 | shire | 1 | 28756 | 13 | 0.906 | 31739.5 |
833 | 2024-03-31 02:47:42 | shire | 1 | 28756 | 13 | 0.673 | 42728.1 |
832 | 2024-03-28 08:06:07 | shire | 1 | 28756 | 13 | 0.530 | 54256.6 |
831 | 2024-03-27 03:04:40 | shire | 1 | 28756 | 13 | 2.313 | 12432.3 |
830 | 2024-03-03 21:23:16 | shire | 1 | 28756 | 13 | 0.530 | 54256.6 |
829 | 2024-02-25 18:08:26 | shire | 1 | 28756 | 13 | 0.580 | 49579.3 |
828 | 2024-02-25 16:45:51 | shire | 1 | 28756 | 13 | 1.190 | 24164.7 |
827 | 2024-02-23 17:06:19 | shire | 1 | 28756 | 13 | 0.483 | 59536.2 |
826 | 2024-02-03 03:52:43 | shire | 1 | 28756 | 13 | 0.516 | 55728.7 |
825 | 2024-01-26 08:37:49 | shire | 1 | 28756 | 13 | 0.516 | 55728.7 |
824 | 2024-01-26 07:55:03 | shire | 1 | 28756 | 13 | 0.516 | 55728.7 |
823 | 2024-01-21 05:24:55 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |
822 | 2024-01-05 17:08:39 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
821 | 2024-01-03 13:53:12 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
820 | 2023-12-18 04:42:04 | shire | 2 | 53800 | 215 | 1.876 | 28678.0 |
819 | 2023-12-12 03:46:19 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
818 | 2023-12-03 17:02:47 | shire | 1 | 28756 | 13 | 0.546 | 52666.7 |
817 | 2023-12-03 17:02:46 | shire | 1 | 28756 | 13 | 0.533 | 53951.2 |
816 | 2023-11-28 11:44:06 | shire | 2 | 53800 | 215 | 1.356 | 39675.5 |
815 | 2023-11-28 03:39:53 | shire | 2 | 53800 | 215 | 1.563 | 34421.0 |
814 | 2023-11-21 14:51:55 | shire | 2 | 53800 | 215 | 1.390 | 38705.0 |
813 | 2023-11-14 23:11:02 | shire | 1 | 28756 | 13 | 0.470 | 61183.0 |
812 | 2023-11-11 22:41:49 | shire | 1 | 28756 | 13 | 0.516 | 55728.7 |
811 | 2023-11-09 13:42:37 | shire | 2 | 53800 | 215 | 1.393 | 38621.7 |
810 | 2023-11-09 06:26:31 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
809 | 2023-11-05 10:25:40 | shire | 2 | 53800 | 215 | 1.576 | 34137.1 |
808 | 2023-10-27 14:53:19 | shire | 1 | 28756 | 13 | 0.470 | 61183.0 |
807 | 2023-10-27 08:06:03 | shire | 1 | 28756 | 13 | 0.516 | 55728.7 |
806 | 2023-10-21 03:42:05 | shire | 1 | 28756 | 13 | 0.563 | 51076.4 |
805 | 2023-10-17 19:54:43 | shire | 1 | 28756 | 13 | 0.483 | 59536.2 |
804 | 2023-10-11 11:56:20 | shire | 1 | 28756 | 13 | 1.126 | 25538.2 |
803 | 2023-10-11 01:30:31 | shire | 2 | 53800 | 215 | 1.716 | 31352.0 |
802 | 2023-10-09 06:52:51 | shire | 2 | 53800 | 215 | 1.390 | 38705.0 |
801 | 2023-10-03 15:28:39 | shire | 1 | 28756 | 13 | 0.890 | 32310.1 |
800 | 2023-09-27 02:27:06 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
799 | 2023-09-20 16:29:25 | shire | 1 | 28756 | 13 | 0.440 | 65354.5 |
798 | 2023-09-19 15:50:38 | shire | 1 | 28756 | 13 | 0.563 | 51076.4 |
797 | 2023-09-19 15:32:42 | shire | 2 | 53800 | 215 | 1.560 | 34487.2 |
796 | 2023-09-17 14:17:18 | shire | 2 | 53800 | 215 | 1.546 | 34799.5 |
795 | 2023-08-22 02:01:24 | shire | 1 | 28756 | 13 | 0.530 | 54256.6 |
794 | 2023-06-17 00:04:21 | shire | 2 | 53800 | 215 | 1.610 | 33416.1 |
793 | 2023-06-10 02:14:04 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
792 | 2023-06-06 19:06:55 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |
791 | 2023-06-02 18:58:33 | shire | 2 | 53800 | 215 | 1.376 | 39098.8 |
790 | 2023-05-25 02:28:07 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
789 | 2023-03-20 00:52:26 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |
788 | 2023-03-17 08:42:09 | shire | 2 | 53800 | 215 | 1.360 | 39558.8 |
787 | 2023-02-22 01:21:51 | shire | 1 | 28756 | 13 | 0.483 | 59536.2 |
786 | 2023-01-07 02:00:24 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |
785 | 2022-12-19 22:08:57 | shire | 2 | 53800 | 215 | 1.376 | 39098.8 |
784 | 2022-11-08 12:29:09 | shire | 1 | 28756 | 13 | 0.483 | 59536.2 |
783 | 2022-11-05 00:52:00 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
782 | 2022-10-28 03:17:49 | shire | 2 | 53800 | 215 | 1.316 | 40881.5 |
781 | 2022-10-04 18:20:45 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |
780 | 2022-08-15 17:41:38 | shire | 2 | 53800 | 215 | 1.406 | 38264.6 |
779 | 2022-08-15 05:32:24 | shire | 1 | 28756 | 13 | 0.483 | 59536.2 |
778 | 2022-08-13 06:05:29 | shire | 2 | 53800 | 215 | 1.596 | 33709.3 |
777 | 2022-07-29 12:51:09 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
776 | 2022-07-29 03:38:18 | shire | 1 | 28756 | 13 | 0.470 | 61183.0 |
775 | 2022-07-19 09:31:44 | shire | 2 | 53800 | 215 | 1.373 | 39184.3 |
774 | 2022-07-19 03:53:12 | shire | 1 | 28756 | 13 | 0.470 | 61183.0 |
773 | 2022-07-17 23:14:52 | shire | 1 | 28756 | 13 | 0.483 | 59536.2 |
772 | 2022-07-03 15:55:06 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
771 | 2022-07-03 03:08:43 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |
770 | 2022-06-08 23:08:54 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
769 | 2022-06-08 12:34:31 | shire | 2 | 53800 | 215 | 2.783 | 19331.7 |
768 | 2022-06-04 21:05:46 | shire | 2 | 53800 | 215 | 1.406 | 38264.6 |
767 | 2022-05-23 04:05:36 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |
766 | 2022-03-25 03:21:57 | shire | 1 | 28756 | 13 | 0.533 | 53951.2 |
765 | 2022-03-11 18:17:38 | shire | 2 | 53800 | 215 | 1.436 | 37465.2 |
764 | 2022-02-04 13:49:04 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
763 | 2021-12-14 06:36:55 | shire | 1 | 28756 | 13 | 0.470 | 61183.0 |
762 | 2021-12-10 07:51:11 | shire | 2 | 53800 | 215 | 1.576 | 34137.1 |
761 | 2021-12-03 06:35:36 | shire | 2 | 53800 | 215 | 1.500 | 35866.7 |
760 | 2021-11-30 12:47:30 | shire | 1 | 28756 | 13 | 0.593 | 48492.4 |
759 | 2021-11-28 11:23:43 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
758 | 2021-10-12 01:58:34 | shire | 1 | 28756 | 13 | 0.450 | 63902.2 |
757 | 2021-10-10 00:54:37 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
756 | 2021-09-06 23:53:50 | shire | 1 | 28756 | 13 | 0.513 | 56054.6 |
755 | 2021-09-05 21:41:13 | shire | 1 | 28756 | 13 | 0.530 | 54256.6 |
754 | 2021-09-03 15:29:26 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
753 | 2021-08-19 06:35:30 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
752 | 2021-07-06 11:05:56 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
751 | 2021-06-06 00:07:44 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
750 | 2021-06-02 19:49:20 | shire | 1 | 28756 | 13 | 0.516 | 55728.7 |
749 | 2021-05-19 19:12:47 | shire | 1 | 28756 | 13 | 0.530 | 54256.6 |
748 | 2021-05-06 10:23:07 | shire | 2 | 53800 | 215 | 1.686 | 31909.8 |
747 | 2021-04-20 22:25:09 | shire | 1 | 28756 | 13 | 0.466 | 61708.2 |
746 | 2021-04-19 18:30:26 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
745 | 2021-03-23 13:15:31 | shire | 1 | 28756 | 13 | 0.500 | 57512.0 |
744 | 2021-02-28 06:43:19 | shire | 1 | 28756 | 13 | 0.453 | 63479.0 |
743 | 2021-02-25 21:22:20 | shire | 1 | 28756 | 13 | 0.436 | 65954.1 |