History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"swats"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
905 | 2024-04-17 22:00:08 | swats | 1 | 28756 | 19 | 1.453 | 19790.8 |
904 | 2024-04-17 21:53:04 | swats | 1 | 28756 | 19 | 1.123 | 25606.4 |
903 | 2024-04-02 20:48:38 | swats | 1 | 28756 | 19 | 0.483 | 59536.2 |
902 | 2024-03-31 02:39:03 | swats | 1 | 28756 | 19 | 0.970 | 29645.4 |
901 | 2024-03-27 01:38:47 | swats | 1 | 28756 | 19 | 0.533 | 53951.2 |
900 | 2024-03-23 15:10:47 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
899 | 2024-02-25 17:44:32 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
898 | 2024-02-23 02:18:45 | swats | 1 | 28756 | 19 | 0.486 | 59168.7 |
897 | 2024-02-03 17:18:34 | swats | 2 | 53800 | 263 | 1.560 | 34487.2 |
896 | 2024-02-03 04:30:50 | swats | 2 | 53800 | 263 | 1.593 | 33772.8 |
895 | 2024-02-03 04:30:46 | swats | 1 | 28756 | 19 | 1.046 | 27491.4 |
894 | 2024-01-26 17:14:33 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
893 | 2024-01-26 17:14:17 | swats | 1 | 28756 | 19 | 0.516 | 55728.7 |
892 | 2024-01-26 11:39:17 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
891 | 2024-01-22 22:57:41 | swats | 2 | 53800 | 263 | 1.360 | 39558.8 |
890 | 2024-01-22 10:49:41 | swats | 1 | 28756 | 19 | 0.530 | 54256.6 |
889 | 2023-12-20 01:37:25 | swats | 1 | 28756 | 19 | 0.470 | 61183.0 |
888 | 2023-12-19 15:52:34 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
887 | 2023-12-16 04:00:30 | swats | 2 | 53800 | 263 | 1.716 | 31352.0 |
886 | 2023-12-14 19:49:46 | swats | 1 | 28756 | 19 | 0.486 | 59168.7 |
885 | 2023-12-08 12:09:51 | swats | 1 | 28756 | 19 | 0.513 | 56054.6 |
884 | 2023-12-08 12:09:50 | swats | 1 | 28756 | 19 | 0.563 | 51076.4 |
883 | 2023-12-02 06:28:26 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
882 | 2023-11-21 00:38:29 | swats | 1 | 28756 | 19 | 0.436 | 65954.1 |
881 | 2023-11-20 16:27:53 | swats | 2 | 53800 | 263 | 1.406 | 38264.6 |
880 | 2023-11-12 00:58:10 | swats | 1 | 28756 | 19 | 0.456 | 63061.4 |
879 | 2023-11-03 10:52:34 | swats | 2 | 53800 | 263 | 1.373 | 39184.3 |
878 | 2023-10-27 03:12:02 | swats | 1 | 28756 | 19 | 0.470 | 61183.0 |
877 | 2023-10-19 23:48:05 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
876 | 2023-10-17 18:44:21 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
875 | 2023-10-17 13:45:13 | swats | 2 | 53800 | 263 | 1.796 | 29955.5 |
874 | 2023-10-13 03:47:37 | swats | 1 | 28756 | 19 | 0.420 | 68466.7 |
873 | 2023-10-08 09:55:09 | swats | 2 | 53800 | 263 | 1.640 | 32804.9 |
872 | 2023-10-07 01:35:14 | swats | 1 | 28756 | 19 | 0.563 | 51076.4 |
871 | 2023-10-03 14:16:41 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
870 | 2023-09-22 16:35:06 | swats | 1 | 28756 | 19 | 0.530 | 54256.6 |
869 | 2023-09-12 09:10:03 | swats | 1 | 28756 | 19 | 0.440 | 65354.5 |
868 | 2023-08-09 15:12:34 | swats | 2 | 53800 | 263 | 1.376 | 39098.8 |
867 | 2023-08-02 09:50:40 | swats | 1 | 28756 | 19 | 0.470 | 61183.0 |
866 | 2023-08-02 05:51:38 | swats | 1 | 28756 | 19 | 0.470 | 61183.0 |
865 | 2023-07-23 16:48:54 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
864 | 2023-05-26 18:33:12 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
863 | 2023-04-29 07:03:56 | swats | 1 | 28756 | 19 | 0.470 | 61183.0 |
862 | 2023-04-21 16:28:57 | swats | 2 | 53800 | 263 | 1.563 | 34421.0 |
861 | 2023-04-13 19:29:10 | swats | 1 | 28756 | 19 | 0.970 | 29645.4 |
860 | 2023-02-18 10:18:37 | swats | 1 | 28756 | 19 | 0.436 | 65954.1 |
859 | 2023-01-25 00:24:04 | swats | 2 | 53800 | 263 | 1.516 | 35488.1 |
858 | 2022-12-24 20:31:51 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
857 | 2022-12-15 12:16:09 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
856 | 2022-11-05 04:02:13 | swats | 2 | 53800 | 263 | 1.326 | 40573.2 |
855 | 2022-08-22 00:04:17 | swats | 1 | 28756 | 19 | 0.440 | 65354.5 |
854 | 2022-08-21 00:30:28 | swats | 1 | 28756 | 19 | 0.513 | 56054.6 |
853 | 2022-06-06 09:29:48 | swats | 2 | 53800 | 263 | 1.393 | 38621.7 |
852 | 2022-04-20 10:52:30 | swats | 1 | 28756 | 19 | 0.766 | 37540.5 |
851 | 2022-04-17 01:26:06 | swats | 1 | 28756 | 19 | 0.516 | 55728.7 |
850 | 2022-04-11 14:57:03 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
849 | 2022-02-24 09:59:37 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
848 | 2022-02-23 20:29:07 | swats | 1 | 28756 | 19 | 0.546 | 52666.7 |
847 | 2022-02-22 20:31:39 | swats | 1 | 28756 | 19 | 0.546 | 52666.7 |
846 | 2022-02-21 11:36:54 | swats | 1 | 28756 | 19 | 0.826 | 34813.6 |
845 | 2022-02-20 15:52:44 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
844 | 2022-02-19 12:23:53 | swats | 1 | 28756 | 19 | 0.516 | 55728.7 |
843 | 2022-02-18 11:01:28 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
842 | 2022-02-17 15:00:41 | swats | 1 | 28756 | 19 | 0.436 | 65954.1 |
841 | 2022-02-16 20:23:42 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
840 | 2022-02-15 16:44:00 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
839 | 2022-02-14 19:09:20 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
838 | 2022-02-13 19:51:18 | swats | 1 | 28756 | 19 | 0.516 | 55728.7 |
837 | 2022-01-05 07:41:02 | swats | 1 | 28756 | 19 | 0.516 | 55728.7 |
836 | 2022-01-01 01:45:58 | swats | 1 | 28756 | 19 | 0.623 | 46157.3 |
835 | 2021-12-31 15:02:48 | swats | 1 | 28756 | 19 | 0.516 | 55728.7 |
834 | 2021-12-30 21:05:24 | swats | 1 | 28756 | 19 | 0.546 | 52666.7 |
833 | 2021-12-30 02:55:20 | swats | 1 | 28756 | 19 | 0.483 | 59536.2 |
832 | 2021-12-29 17:22:36 | swats | 1 | 28756 | 19 | 0.483 | 59536.2 |
831 | 2021-12-29 07:57:42 | swats | 1 | 28756 | 19 | 0.470 | 61183.0 |
830 | 2021-12-28 16:42:57 | swats | 1 | 28756 | 19 | 0.516 | 55728.7 |
829 | 2021-12-28 00:31:34 | swats | 1 | 28756 | 19 | 0.470 | 61183.0 |
828 | 2021-12-27 13:17:20 | swats | 1 | 28756 | 19 | 0.530 | 54256.6 |
827 | 2021-12-26 13:18:11 | swats | 1 | 28756 | 19 | 1.076 | 26724.9 |
826 | 2021-12-26 04:49:43 | swats | 1 | 28756 | 19 | 0.580 | 49579.3 |
825 | 2021-12-25 20:47:53 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
824 | 2021-12-25 04:17:33 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
823 | 2021-12-24 16:13:24 | swats | 1 | 28756 | 19 | 0.513 | 56054.6 |
822 | 2021-12-24 04:48:29 | swats | 1 | 28756 | 19 | 0.466 | 61708.2 |
821 | 2021-12-16 02:36:09 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
820 | 2021-12-15 00:28:24 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
819 | 2021-12-14 00:38:16 | swats | 1 | 28756 | 19 | 0.503 | 57169.0 |
818 | 2021-12-09 21:34:34 | swats | 1 | 28756 | 19 | 0.533 | 53951.2 |
817 | 2021-11-26 16:22:32 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
816 | 2021-11-26 05:49:52 | swats | 1 | 28756 | 19 | 1.030 | 27918.4 |
815 | 2021-11-25 13:03:04 | swats | 1 | 28756 | 19 | 0.533 | 53951.2 |
814 | 2021-11-18 21:00:59 | swats | 1 | 28756 | 19 | 0.486 | 59168.7 |
813 | 2021-11-18 08:47:27 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
812 | 2021-11-17 19:52:16 | swats | 1 | 28756 | 19 | 0.513 | 56054.6 |
811 | 2021-11-17 12:11:57 | swats | 1 | 28756 | 19 | 0.453 | 63479.0 |
810 | 2021-11-01 12:25:25 | swats | 1 | 28756 | 19 | 0.483 | 59536.2 |
809 | 2021-09-27 08:00:45 | swats | 1 | 28756 | 19 | 0.500 | 57512.0 |
808 | 2021-09-25 04:52:33 | swats | 1 | 28756 | 19 | 0.486 | 59168.7 |
807 | 2021-09-12 06:17:15 | swats | 1 | 28756 | 19 | 0.436 | 65954.1 |
806 | 2021-09-05 20:38:49 | swats | 1 | 28756 | 19 | 0.893 | 32201.6 |