History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harp"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
947 | 2024-03-10 23:35:11 | harp | 2 | 29872 | 306 | 2.796 | 10683.8 |
946 | 2024-03-09 12:55:37 | harp | 2 | 29872 | 306 | 0.750 | 39829.3 |
945 | 2024-03-05 21:04:14 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
944 | 2024-03-02 18:31:15 | harp | 2 | 29872 | 306 | 1.936 | 15429.8 |
943 | 2024-03-02 17:06:14 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
942 | 2024-02-25 16:52:51 | harp | 1 | 13983 | 15 | 0.733 | 19076.4 |
941 | 2024-02-02 23:15:01 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
940 | 2024-01-25 19:39:17 | harp | 1 | 13983 | 15 | 0.283 | 49409.9 |
939 | 2024-01-24 13:09:42 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
938 | 2024-01-18 23:21:34 | harp | 1 | 13983 | 15 | 0.500 | 27966.0 |
937 | 2023-12-01 13:47:18 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
936 | 2023-11-27 22:38:46 | harp | 2 | 29872 | 306 | 0.843 | 35435.3 |
935 | 2023-11-27 19:09:13 | harp | 2 | 29872 | 306 | 0.860 | 34734.9 |
934 | 2023-11-27 01:44:31 | harp | 2 | 29872 | 306 | 0.763 | 39150.7 |
933 | 2023-11-22 15:42:12 | harp | 2 | 29872 | 306 | 0.766 | 38997.4 |
932 | 2023-11-19 15:40:34 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
931 | 2023-11-10 07:40:12 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
930 | 2023-11-09 02:51:38 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
929 | 2023-10-27 14:01:52 | harp | 1 | 13983 | 15 | 0.513 | 27257.3 |
928 | 2023-10-24 15:26:41 | harp | 2 | 29872 | 306 | 0.876 | 34100.5 |
927 | 2023-10-23 02:16:28 | harp | 2 | 29872 | 306 | 0.906 | 32971.3 |
926 | 2023-10-20 01:07:46 | harp | 1 | 13983 | 15 | 0.216 | 64736.1 |
925 | 2023-10-17 17:14:21 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
924 | 2023-10-17 00:45:17 | harp | 2 | 29872 | 306 | 1.560 | 19148.7 |
923 | 2023-10-11 01:04:57 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
922 | 2023-10-04 08:31:18 | harp | 1 | 13983 | 15 | 0.216 | 64736.1 |
921 | 2023-09-27 23:39:27 | harp | 2 | 29872 | 306 | 0.860 | 34734.9 |
920 | 2023-09-21 23:44:45 | harp | 1 | 13983 | 15 | 0.436 | 32071.1 |
919 | 2023-09-19 18:56:07 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
918 | 2023-09-18 18:03:11 | harp | 1 | 13983 | 15 | 0.200 | 69915.0 |
917 | 2023-09-17 03:17:26 | harp | 2 | 29872 | 306 | 0.750 | 39829.3 |
916 | 2023-09-17 00:42:24 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
915 | 2023-09-10 17:12:34 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
914 | 2023-09-06 12:01:45 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
913 | 2023-08-26 03:06:07 | harp | 2 | 29872 | 306 | 0.906 | 32971.3 |
912 | 2023-06-10 06:11:05 | harp | 1 | 13983 | 15 | 0.203 | 68881.8 |
911 | 2023-05-26 01:59:07 | harp | 1 | 13983 | 15 | 0.203 | 68881.8 |
910 | 2023-05-11 04:18:36 | harp | 2 | 29872 | 306 | 0.733 | 40753.1 |
909 | 2023-03-29 23:02:29 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
908 | 2023-03-26 21:09:49 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
907 | 2023-02-18 22:10:41 | harp | 2 | 29872 | 306 | 0.750 | 39829.3 |
906 | 2023-02-09 17:58:35 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
905 | 2023-01-12 13:22:52 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
904 | 2022-12-01 07:38:22 | harp | 2 | 29872 | 306 | 0.750 | 39829.3 |
903 | 2022-10-23 13:17:53 | harp | 1 | 13983 | 15 | 0.203 | 68881.8 |
902 | 2022-10-23 05:37:15 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
901 | 2022-09-19 04:45:15 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
900 | 2022-09-12 05:31:50 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
899 | 2022-08-06 22:05:38 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
898 | 2022-07-08 13:06:04 | harp | 2 | 29872 | 306 | 0.766 | 38997.4 |
897 | 2022-07-03 08:43:50 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
896 | 2022-07-02 21:31:14 | harp | 1 | 13983 | 15 | 0.216 | 64736.1 |
895 | 2022-06-29 12:55:49 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
894 | 2022-06-16 08:42:26 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
893 | 2022-06-12 12:44:00 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
892 | 2022-06-10 08:09:53 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
891 | 2022-05-11 04:55:45 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
890 | 2022-03-09 10:19:46 | harp | 1 | 13983 | 15 | 0.420 | 33292.9 |
889 | 2022-02-13 15:08:59 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
888 | 2022-02-07 10:38:31 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
887 | 2022-02-06 09:31:45 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
886 | 2022-02-05 08:14:19 | harp | 1 | 13983 | 15 | 0.216 | 64736.1 |
885 | 2022-02-04 08:25:08 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
884 | 2022-02-03 02:48:56 | harp | 1 | 13983 | 15 | 0.516 | 27098.8 |
883 | 2022-02-02 08:12:59 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
882 | 2022-02-01 06:05:37 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
881 | 2022-01-31 04:03:08 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
880 | 2022-01-30 09:47:20 | harp | 1 | 13983 | 15 | 0.236 | 59250.0 |
879 | 2022-01-29 09:00:34 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
878 | 2022-01-28 10:33:17 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
877 | 2022-01-27 20:30:52 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
876 | 2022-01-27 03:02:21 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
875 | 2022-01-26 18:04:44 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
874 | 2022-01-26 09:03:02 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
873 | 2022-01-25 23:57:49 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
872 | 2022-01-25 09:19:25 | harp | 1 | 13983 | 15 | 0.423 | 33056.7 |
871 | 2022-01-25 02:34:16 | harp | 1 | 13983 | 15 | 0.236 | 59250.0 |
870 | 2022-01-24 10:04:49 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
869 | 2022-01-23 21:08:37 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
868 | 2022-01-21 20:35:20 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
867 | 2022-01-21 10:13:11 | harp | 1 | 13983 | 15 | 0.360 | 38841.7 |
866 | 2022-01-20 23:30:49 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
865 | 2022-01-20 14:02:32 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
864 | 2022-01-20 05:00:36 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
863 | 2022-01-19 21:53:25 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
862 | 2022-01-19 11:04:41 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
861 | 2022-01-18 20:36:40 | harp | 1 | 13983 | 15 | 0.216 | 64736.1 |
860 | 2022-01-18 06:12:34 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
859 | 2022-01-17 20:22:45 | harp | 1 | 13983 | 15 | 0.220 | 63559.1 |
858 | 2021-12-23 23:25:20 | harp | 1 | 13983 | 15 | 0.263 | 53167.3 |
857 | 2021-12-22 22:26:42 | harp | 1 | 13983 | 15 | 0.263 | 53167.3 |
856 | 2021-12-22 15:26:21 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
855 | 2021-12-21 23:19:43 | harp | 1 | 13983 | 15 | 0.216 | 64736.1 |
854 | 2021-12-20 21:22:03 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
853 | 2021-12-17 15:53:16 | harp | 1 | 13983 | 15 | 0.233 | 60012.9 |
852 | 2021-12-16 19:02:06 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
851 | 2021-12-15 21:42:26 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |
850 | 2021-12-05 02:37:54 | harp | 1 | 13983 | 15 | 0.253 | 55268.8 |
849 | 2021-12-03 01:12:46 | harp | 1 | 13983 | 15 | 0.266 | 52567.7 |
848 | 2021-11-25 18:35:03 | harp | 1 | 13983 | 15 | 0.250 | 55932.0 |