History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loam"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
951 | 2024-04-27 11:32:42 | loam | 1 | 13983 | 11 | 0.343 | 40766.8 |
950 | 2024-04-27 03:18:24 | loam | 1 | 13983 | 11 | 0.266 | 52567.7 |
949 | 2024-04-21 20:43:00 | loam | 1 | 13983 | 11 | 0.483 | 28950.3 |
948 | 2024-04-21 20:42:35 | loam | 1 | 13983 | 11 | 0.546 | 25609.9 |
947 | 2024-04-21 10:28:01 | loam | 1 | 13983 | 11 | 0.560 | 24969.6 |
946 | 2024-04-11 06:30:28 | loam | 1 | 13983 | 11 | 0.263 | 53167.3 |
945 | 2024-04-08 22:20:20 | loam | 2 | 29872 | 230 | 1.140 | 26203.5 |
944 | 2024-04-08 22:16:53 | loam | 1 | 13983 | 11 | 0.796 | 17566.6 |
943 | 2024-04-05 00:20:40 | loam | 1 | 13983 | 11 | 0.280 | 49939.3 |
942 | 2024-04-02 20:47:35 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
941 | 2024-03-30 19:26:49 | loam | 2 | 29872 | 230 | 3.140 | 9513.4 |
940 | 2024-03-30 19:17:37 | loam | 1 | 13983 | 11 | 0.516 | 27098.8 |
939 | 2024-03-10 20:01:20 | loam | 1 | 13983 | 11 | 0.530 | 26383.0 |
938 | 2024-03-08 17:49:05 | loam | 1 | 13983 | 11 | 0.580 | 24108.6 |
937 | 2024-03-05 20:05:50 | loam | 1 | 13983 | 11 | 0.826 | 16928.6 |
936 | 2024-03-03 20:24:08 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
935 | 2024-02-17 07:53:06 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
934 | 2024-02-05 01:52:10 | loam | 2 | 29872 | 230 | 0.983 | 30388.6 |
933 | 2024-02-05 01:51:33 | loam | 1 | 13983 | 11 | 0.546 | 25609.9 |
932 | 2024-02-03 01:03:18 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
931 | 2024-02-02 15:33:23 | loam | 1 | 13983 | 11 | 0.266 | 52567.7 |
930 | 2024-01-28 16:14:11 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
929 | 2024-01-25 20:39:41 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
928 | 2024-01-19 08:14:01 | loam | 1 | 13983 | 11 | 0.203 | 68881.8 |
927 | 2024-01-05 21:36:59 | loam | 1 | 13983 | 11 | 0.283 | 49409.9 |
926 | 2023-12-30 17:14:07 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
925 | 2023-11-12 04:53:25 | loam | 2 | 29872 | 230 | 0.970 | 30795.9 |
924 | 2023-11-10 04:44:15 | loam | 2 | 29872 | 230 | 2.046 | 14600.2 |
923 | 2023-11-09 12:23:21 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
922 | 2023-11-09 00:06:44 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
921 | 2023-11-07 10:38:06 | loam | 2 | 29872 | 230 | 0.873 | 34217.6 |
920 | 2023-11-07 10:09:47 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
919 | 2023-11-05 17:19:57 | loam | 2 | 29872 | 230 | 0.906 | 32971.3 |
918 | 2023-11-04 06:41:25 | loam | 1 | 13983 | 11 | 0.546 | 25609.9 |
917 | 2023-11-01 00:20:59 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
916 | 2023-10-29 10:57:33 | loam | 2 | 29872 | 230 | 1.076 | 27762.1 |
915 | 2023-10-26 10:48:56 | loam | 1 | 13983 | 11 | 0.263 | 53167.3 |
914 | 2023-10-24 23:01:22 | loam | 1 | 13983 | 11 | 0.266 | 52567.7 |
913 | 2023-10-19 21:26:57 | loam | 1 | 13983 | 11 | 0.440 | 31779.5 |
912 | 2023-10-19 14:30:31 | loam | 1 | 13983 | 11 | 0.296 | 47239.9 |
911 | 2023-10-17 03:17:24 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
910 | 2023-10-11 17:47:00 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
909 | 2023-10-03 19:27:30 | loam | 1 | 13983 | 11 | 0.266 | 52567.7 |
908 | 2023-09-23 02:29:44 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
907 | 2023-09-12 23:51:35 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
906 | 2023-09-11 00:15:01 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
905 | 2023-08-15 02:25:25 | loam | 1 | 13983 | 11 | 0.500 | 27966.0 |
904 | 2023-07-16 06:13:36 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
903 | 2023-05-16 11:24:35 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
902 | 2023-04-04 20:04:04 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
901 | 2023-03-31 13:50:17 | loam | 1 | 13983 | 11 | 0.533 | 26234.5 |
900 | 2023-03-21 05:57:32 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
899 | 2023-03-08 23:30:55 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
898 | 2022-12-31 02:49:24 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
897 | 2022-12-30 14:35:21 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
896 | 2022-11-26 15:08:52 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
895 | 2022-09-18 18:35:03 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
894 | 2022-09-16 04:25:43 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
893 | 2022-09-12 03:28:53 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
892 | 2022-08-15 06:01:08 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
891 | 2022-08-06 21:34:16 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
890 | 2022-07-29 13:48:41 | loam | 1 | 13983 | 11 | 0.263 | 53167.3 |
889 | 2022-07-09 23:00:15 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
888 | 2022-06-30 20:15:51 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
887 | 2022-06-29 04:03:40 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
886 | 2022-06-25 12:29:33 | loam | 1 | 13983 | 11 | 0.263 | 53167.3 |
885 | 2022-06-25 03:42:48 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
884 | 2022-05-30 19:23:25 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
883 | 2022-04-27 08:19:36 | loam | 1 | 13983 | 11 | 0.280 | 49939.3 |
882 | 2022-02-23 09:39:31 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
881 | 2022-02-12 16:45:49 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
880 | 2022-01-20 18:24:13 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
879 | 2021-11-16 08:25:27 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
878 | 2021-11-08 06:11:31 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
877 | 2021-10-04 02:35:09 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
876 | 2021-09-01 18:37:14 | loam | 1 | 13983 | 11 | 0.483 | 28950.3 |
875 | 2021-08-15 06:43:56 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
874 | 2021-08-05 03:32:00 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
873 | 2021-06-03 20:13:58 | loam | 1 | 13983 | 11 | 0.266 | 52567.7 |
872 | 2021-05-09 14:29:13 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
871 | 2021-04-30 23:18:47 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
870 | 2021-04-08 05:29:13 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
869 | 2021-02-25 20:09:20 | loam | 2 | 29872 | 230 | 0.780 | 38297.4 |
868 | 2021-02-19 01:50:20 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
867 | 2021-02-18 01:49:26 | loam | 1 | 13983 | 11 | 0.266 | 52567.7 |
866 | 2021-01-26 08:49:06 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
865 | 2021-01-23 05:00:31 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
864 | 2021-01-22 16:19:41 | loam | 1 | 13983 | 11 | 0.483 | 28950.3 |
863 | 2020-12-30 00:54:04 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
862 | 2020-10-22 19:42:23 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |
861 | 2020-10-20 12:54:39 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
860 | 2020-10-08 14:17:42 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
859 | 2020-10-04 19:57:55 | loam | 1 | 13983 | 11 | 0.233 | 60012.9 |
858 | 2020-09-07 11:01:27 | loam | 1 | 13983 | 11 | 0.220 | 63559.1 |
857 | 2020-09-02 20:40:19 | loam | 2 | 29872 | 230 | 0.826 | 36164.6 |
856 | 2020-08-21 06:00:39 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
855 | 2020-08-06 09:04:46 | loam | 1 | 13983 | 11 | 0.296 | 47239.9 |
854 | 2020-08-04 16:51:53 | loam | 1 | 13983 | 11 | 0.216 | 64736.1 |
853 | 2020-07-15 18:55:01 | loam | 1 | 13983 | 11 | 0.236 | 59250.0 |
852 | 2020-07-15 02:51:46 | loam | 1 | 13983 | 11 | 0.250 | 55932.0 |