History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harms"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
908 | 2024-04-27 16:34:23 | harms | 2 | 53800 | 282 | 1.893 | 28420.5 |
907 | 2024-04-20 08:20:00 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
906 | 2024-04-03 02:47:26 | harms | 1 | 28756 | 19 | 0.610 | 47141.0 |
905 | 2024-03-31 07:37:24 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
904 | 2024-03-28 16:13:47 | harms | 1 | 28756 | 19 | 0.513 | 56054.6 |
903 | 2024-03-27 02:46:26 | harms | 1 | 28756 | 19 | 1.686 | 17055.8 |
902 | 2024-03-03 21:57:35 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
901 | 2024-03-01 03:40:52 | harms | 1 | 28756 | 19 | 0.516 | 55728.7 |
900 | 2024-02-25 17:16:42 | harms | 1 | 28756 | 19 | 0.466 | 61708.2 |
899 | 2024-02-07 06:55:03 | harms | 1 | 28756 | 19 | 0.546 | 52666.7 |
898 | 2024-02-03 18:23:04 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
897 | 2024-02-03 11:41:39 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
896 | 2024-01-28 17:58:59 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
895 | 2023-12-22 04:10:58 | harms | 2 | 53800 | 282 | 1.656 | 32487.9 |
894 | 2023-12-19 13:46:07 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
893 | 2023-11-27 15:35:52 | harms | 1 | 28756 | 19 | 0.440 | 65354.5 |
892 | 2023-11-25 16:12:52 | harms | 2 | 53800 | 282 | 1.640 | 32804.9 |
891 | 2023-11-23 12:18:59 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
890 | 2023-11-22 20:21:09 | harms | 1 | 28756 | 19 | 0.503 | 57169.0 |
889 | 2023-11-22 18:55:19 | harms | 2 | 53800 | 282 | 1.376 | 39098.8 |
888 | 2023-11-12 15:41:43 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
887 | 2023-11-09 02:56:18 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
886 | 2023-11-07 11:01:34 | harms | 1 | 28756 | 19 | 0.543 | 52957.6 |
885 | 2023-11-07 11:01:31 | harms | 1 | 28756 | 19 | 1.923 | 14953.7 |
884 | 2023-11-02 03:30:03 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
883 | 2023-11-01 07:40:29 | harms | 2 | 53800 | 282 | 1.423 | 37807.4 |
882 | 2023-10-27 09:37:13 | harms | 1 | 28756 | 19 | 0.530 | 54256.6 |
881 | 2023-10-26 07:45:19 | harms | 1 | 28756 | 19 | 0.873 | 32939.3 |
880 | 2023-10-20 21:03:13 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
879 | 2023-10-17 16:20:52 | harms | 1 | 28756 | 19 | 0.533 | 53951.2 |
878 | 2023-10-13 03:45:43 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
877 | 2023-10-08 09:28:25 | harms | 1 | 28756 | 19 | 0.513 | 56054.6 |
876 | 2023-10-04 10:29:25 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
875 | 2023-09-22 16:55:04 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
874 | 2023-09-13 21:20:44 | harms | 1 | 28756 | 19 | 0.450 | 63902.2 |
873 | 2023-09-12 11:40:59 | harms | 1 | 28756 | 19 | 0.513 | 56054.6 |
872 | 2023-09-05 00:32:48 | harms | 1 | 28756 | 19 | 0.513 | 56054.6 |
871 | 2023-08-08 15:59:16 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
870 | 2023-07-25 07:04:23 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
869 | 2023-06-22 04:57:52 | harms | 1 | 28756 | 19 | 0.436 | 65954.1 |
868 | 2023-04-13 11:18:18 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
867 | 2023-04-09 20:45:24 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
866 | 2023-04-03 12:38:47 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
865 | 2023-04-02 17:16:48 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
864 | 2023-01-16 00:25:42 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
863 | 2023-01-04 15:46:08 | harms | 1 | 28756 | 19 | 0.436 | 65954.1 |
862 | 2022-11-25 19:19:32 | harms | 1 | 28756 | 19 | 0.486 | 59168.7 |
861 | 2022-11-07 10:53:20 | harms | 1 | 28756 | 19 | 0.466 | 61708.2 |
860 | 2022-09-19 19:41:08 | harms | 1 | 28756 | 19 | 0.436 | 65954.1 |
859 | 2022-09-17 10:09:42 | harms | 1 | 28756 | 19 | 0.486 | 59168.7 |
858 | 2022-08-14 18:59:30 | harms | 1 | 28756 | 19 | 0.436 | 65954.1 |
857 | 2022-07-29 03:12:43 | harms | 1 | 28756 | 19 | 0.436 | 65954.1 |
856 | 2022-06-27 19:15:04 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
855 | 2022-05-31 21:42:14 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
854 | 2022-05-07 06:12:43 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
853 | 2022-05-06 16:32:11 | harms | 1 | 28756 | 19 | 0.580 | 49579.3 |
852 | 2022-05-05 16:26:39 | harms | 1 | 28756 | 19 | 1.093 | 26309.2 |
851 | 2022-05-05 04:42:13 | harms | 1 | 28756 | 19 | 0.466 | 61708.2 |
850 | 2022-05-04 19:29:50 | harms | 1 | 28756 | 19 | 0.513 | 56054.6 |
849 | 2022-05-04 06:49:18 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
848 | 2022-05-03 17:17:40 | harms | 1 | 28756 | 19 | 0.673 | 42728.1 |
847 | 2022-05-03 00:07:03 | harms | 1 | 28756 | 19 | 0.733 | 39230.6 |
846 | 2022-04-15 23:38:12 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
845 | 2022-04-15 05:58:01 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
844 | 2022-04-14 09:03:32 | harms | 1 | 28756 | 19 | 0.533 | 53951.2 |
843 | 2022-04-13 05:39:06 | harms | 1 | 28756 | 19 | 0.516 | 55728.7 |
842 | 2022-04-11 22:32:58 | harms | 1 | 28756 | 19 | 1.123 | 25606.4 |
841 | 2022-04-10 22:41:20 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
840 | 2022-03-19 13:46:17 | harms | 1 | 28756 | 19 | 0.563 | 51076.4 |
839 | 2022-03-18 13:29:27 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
838 | 2022-03-17 08:07:03 | harms | 1 | 28756 | 19 | 0.533 | 53951.2 |
837 | 2022-03-16 09:24:20 | harms | 1 | 28756 | 19 | 0.580 | 49579.3 |
836 | 2022-03-15 11:39:54 | harms | 1 | 28756 | 19 | 0.670 | 42919.4 |
835 | 2022-03-13 18:00:01 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
834 | 2022-03-12 19:04:45 | harms | 1 | 28756 | 19 | 0.450 | 63902.2 |
833 | 2022-02-28 13:11:49 | harms | 1 | 28756 | 19 | 0.626 | 45936.1 |
832 | 2022-02-20 18:58:13 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
831 | 2022-01-10 01:16:59 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
830 | 2022-01-05 21:41:24 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
829 | 2022-01-05 12:15:05 | harms | 1 | 28756 | 19 | 0.563 | 51076.4 |
828 | 2022-01-04 20:40:13 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
827 | 2022-01-03 13:57:16 | harms | 1 | 28756 | 19 | 0.483 | 59536.2 |
826 | 2022-01-03 09:14:54 | harms | 1 | 28756 | 19 | 0.530 | 54256.6 |
825 | 2022-01-02 23:41:44 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
824 | 2022-01-02 18:48:47 | harms | 1 | 28756 | 19 | 0.703 | 40904.7 |
823 | 2022-01-02 09:56:07 | harms | 1 | 28756 | 19 | 1.173 | 24514.9 |
822 | 2022-01-01 15:05:14 | harms | 1 | 28756 | 19 | 0.466 | 61708.2 |
821 | 2021-12-15 09:33:55 | harms | 1 | 28756 | 19 | 0.513 | 56054.6 |
820 | 2021-11-19 08:51:29 | harms | 1 | 28756 | 19 | 1.140 | 25224.6 |
819 | 2021-11-16 01:12:56 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
818 | 2021-11-03 08:56:39 | harms | 1 | 28756 | 19 | 0.530 | 54256.6 |
817 | 2021-11-02 08:53:18 | harms | 1 | 28756 | 19 | 0.470 | 61183.0 |
816 | 2021-11-01 10:27:34 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
815 | 2021-10-31 09:25:01 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
814 | 2021-10-20 13:08:25 | harms | 1 | 28756 | 19 | 0.436 | 65954.1 |
813 | 2021-10-15 00:11:34 | harms | 1 | 28756 | 19 | 0.453 | 63479.0 |
812 | 2021-10-14 12:55:36 | harms | 1 | 28756 | 19 | 0.516 | 55728.7 |
811 | 2021-10-14 00:24:56 | harms | 1 | 28756 | 19 | 0.500 | 57512.0 |
810 | 2021-10-13 15:38:48 | harms | 1 | 28756 | 19 | 0.466 | 61708.2 |
809 | 2021-10-13 03:55:03 | harms | 1 | 28756 | 19 | 0.486 | 59168.7 |