History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"raids"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
891 | 2024-03-27 04:33:11 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |
890 | 2024-03-18 02:58:15 | raids | 1 | 28756 | 17 | 1.140 | 25224.6 |
889 | 2024-03-17 01:33:11 | raids | 1 | 28756 | 17 | 0.546 | 52666.7 |
888 | 2024-03-01 08:00:28 | raids | 1 | 28756 | 17 | 0.533 | 53951.2 |
887 | 2024-03-01 02:46:33 | raids | 1 | 28756 | 17 | 0.546 | 52666.7 |
886 | 2024-02-25 22:50:54 | raids | 2 | 53800 | 264 | 5.406 | 9951.9 |
885 | 2024-02-25 22:41:37 | raids | 1 | 28756 | 17 | 1.733 | 16593.2 |
884 | 2024-01-30 01:46:43 | raids | 1 | 28756 | 17 | 0.560 | 51350.0 |
883 | 2024-01-28 18:32:11 | raids | 1 | 28756 | 17 | 0.500 | 57512.0 |
882 | 2024-01-26 21:01:09 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
881 | 2024-01-14 04:48:39 | raids | 1 | 28756 | 17 | 0.513 | 56054.6 |
880 | 2024-01-08 08:00:01 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |
879 | 2024-01-01 13:49:27 | raids | 2 | 53800 | 264 | 1.563 | 34421.0 |
878 | 2023-12-20 22:07:52 | raids | 2 | 53800 | 264 | 1.563 | 34421.0 |
877 | 2023-11-27 03:25:26 | raids | 1 | 28756 | 17 | 0.500 | 57512.0 |
876 | 2023-11-18 22:42:36 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
875 | 2023-11-14 06:11:39 | raids | 2 | 53800 | 264 | 1.736 | 30990.8 |
874 | 2023-11-12 03:38:24 | raids | 1 | 28756 | 17 | 0.516 | 55728.7 |
873 | 2023-11-01 09:19:54 | raids | 1 | 28756 | 17 | 0.516 | 55728.7 |
872 | 2023-10-31 21:42:56 | raids | 2 | 53800 | 264 | 1.610 | 33416.1 |
871 | 2023-10-28 18:08:54 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
870 | 2023-10-26 00:28:01 | raids | 2 | 53800 | 264 | 1.533 | 35094.6 |
869 | 2023-10-23 05:58:21 | raids | 2 | 53800 | 264 | 1.673 | 32157.8 |
868 | 2023-10-21 09:48:16 | raids | 1 | 28756 | 17 | 0.516 | 55728.7 |
867 | 2023-10-17 01:23:46 | raids | 1 | 28756 | 17 | 0.546 | 52666.7 |
866 | 2023-10-11 09:32:26 | raids | 1 | 28756 | 17 | 0.500 | 57512.0 |
865 | 2023-10-04 01:24:54 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
864 | 2023-09-24 05:12:24 | raids | 1 | 28756 | 17 | 0.500 | 57512.0 |
863 | 2023-09-22 23:55:55 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
862 | 2023-09-17 19:14:55 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
861 | 2023-08-25 02:16:17 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
860 | 2023-07-26 13:42:45 | raids | 1 | 28756 | 17 | 0.516 | 55728.7 |
859 | 2023-06-23 05:33:37 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
858 | 2023-06-15 15:00:41 | raids | 1 | 28756 | 17 | 0.500 | 57512.0 |
857 | 2023-06-14 18:18:45 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |
856 | 2023-06-13 13:58:32 | raids | 1 | 28756 | 17 | 0.516 | 55728.7 |
855 | 2023-06-11 18:26:22 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |
854 | 2023-06-07 04:09:22 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
853 | 2023-05-29 12:03:33 | raids | 1 | 28756 | 17 | 0.436 | 65954.1 |
852 | 2023-03-31 13:00:26 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
851 | 2023-03-25 20:57:40 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
850 | 2023-02-25 17:08:09 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
849 | 2023-02-02 12:55:23 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
848 | 2023-01-09 18:39:42 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
847 | 2022-12-17 16:52:55 | raids | 1 | 28756 | 17 | 0.500 | 57512.0 |
846 | 2022-11-29 04:19:57 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
845 | 2022-11-18 06:04:02 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
844 | 2022-11-16 20:59:57 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |
843 | 2022-11-08 21:12:07 | raids | 1 | 28756 | 17 | 0.513 | 56054.6 |
842 | 2022-10-13 14:53:52 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
841 | 2022-09-19 21:21:11 | raids | 1 | 28756 | 17 | 0.436 | 65954.1 |
840 | 2022-09-06 13:50:14 | raids | 1 | 28756 | 17 | 0.436 | 65954.1 |
839 | 2022-09-01 18:18:37 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |
838 | 2022-08-16 00:21:13 | raids | 1 | 28756 | 17 | 0.440 | 65354.5 |
837 | 2022-08-14 19:43:55 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
836 | 2022-07-30 10:00:35 | raids | 1 | 28756 | 17 | 0.483 | 59536.2 |
835 | 2022-07-29 03:55:27 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |
834 | 2022-07-19 13:25:37 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
833 | 2022-06-04 07:34:39 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
832 | 2022-05-18 11:03:31 | raids | 1 | 28756 | 17 | 0.486 | 59168.7 |
831 | 2022-04-15 10:37:00 | raids | 1 | 28756 | 17 | 0.550 | 52283.6 |
830 | 2022-04-14 16:13:45 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
829 | 2022-04-13 23:20:02 | raids | 1 | 28756 | 17 | 0.626 | 45936.1 |
828 | 2022-03-25 23:53:33 | raids | 1 | 28756 | 17 | 0.660 | 43569.7 |
827 | 2022-03-25 11:59:43 | raids | 1 | 28756 | 17 | 0.750 | 38341.3 |
826 | 2022-03-23 20:14:00 | raids | 1 | 28756 | 17 | 0.593 | 48492.4 |
825 | 2022-02-14 03:52:29 | raids | 1 | 28756 | 17 | 0.456 | 63061.4 |
824 | 2022-01-13 14:18:28 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
823 | 2022-01-12 14:28:55 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
822 | 2022-01-11 18:04:00 | raids | 1 | 28756 | 17 | 0.466 | 61708.2 |
821 | 2022-01-10 19:39:22 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
820 | 2021-12-11 20:51:44 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
819 | 2021-12-11 10:53:47 | raids | 1 | 28756 | 17 | 0.513 | 56054.6 |
818 | 2021-12-11 09:47:57 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
817 | 2021-12-11 02:36:30 | raids | 1 | 28756 | 17 | 0.563 | 51076.4 |
816 | 2021-12-10 19:36:49 | raids | 1 | 28756 | 17 | 0.466 | 61708.2 |
815 | 2021-12-10 08:53:07 | raids | 1 | 28756 | 17 | 0.533 | 53951.2 |
814 | 2021-12-09 23:58:07 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
813 | 2021-12-09 10:17:06 | raids | 1 | 28756 | 17 | 0.456 | 63061.4 |
812 | 2021-12-09 00:59:54 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
811 | 2021-12-08 15:15:20 | raids | 1 | 28756 | 17 | 0.516 | 55728.7 |
810 | 2021-12-05 00:17:08 | raids | 1 | 28756 | 17 | 0.736 | 39070.7 |
809 | 2021-12-04 12:42:50 | raids | 1 | 28756 | 17 | 0.466 | 61708.2 |
808 | 2021-12-03 12:04:06 | raids | 1 | 28756 | 17 | 0.500 | 57512.0 |
807 | 2021-12-03 02:36:31 | raids | 1 | 28756 | 17 | 0.466 | 61708.2 |
806 | 2021-12-02 15:00:10 | raids | 1 | 28756 | 17 | 0.563 | 51076.4 |
805 | 2021-12-01 13:09:13 | raids | 1 | 28756 | 17 | 0.533 | 53951.2 |
804 | 2021-12-01 01:42:17 | raids | 1 | 28756 | 17 | 0.576 | 49923.6 |
803 | 2021-11-25 00:23:10 | raids | 1 | 28756 | 17 | 0.546 | 52666.7 |
802 | 2021-11-18 19:33:30 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
801 | 2021-11-18 07:44:21 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
800 | 2021-11-17 23:08:10 | raids | 1 | 28756 | 17 | 0.546 | 52666.7 |
799 | 2021-11-17 10:14:56 | raids | 1 | 28756 | 17 | 1.076 | 26724.9 |
798 | 2021-11-15 03:54:20 | raids | 1 | 28756 | 17 | 0.530 | 54256.6 |
797 | 2021-11-10 23:16:32 | raids | 1 | 28756 | 17 | 0.550 | 52283.6 |
796 | 2021-11-01 06:19:11 | raids | 1 | 28756 | 17 | 0.563 | 51076.4 |
795 | 2021-10-31 10:43:54 | raids | 1 | 28756 | 17 | 0.563 | 51076.4 |
794 | 2021-10-22 03:25:04 | raids | 1 | 28756 | 17 | 0.453 | 63479.0 |
793 | 2021-10-21 10:54:55 | raids | 1 | 28756 | 17 | 0.440 | 65354.5 |
792 | 2021-10-21 01:22:30 | raids | 1 | 28756 | 17 | 0.470 | 61183.0 |