History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"middle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
993 | 2024-04-27 09:08:24 | middle | 1 | 48755 | 11 | 0.890 | 54780.9 |
992 | 2024-04-10 07:03:47 | middle | 2 | 82551 | 83 | 2.953 | 27955.0 |
991 | 2024-03-30 22:24:41 | middle | 3 | 112716 | 532 | 14.576 | 7733.0 |
990 | 2024-03-29 21:19:31 | middle | 3 | 112716 | 532 | 10.860 | 10379.0 |
989 | 2024-03-29 06:45:50 | middle | 1 | 48755 | 11 | 2.903 | 16794.7 |
988 | 2024-03-29 06:40:41 | middle | 1 | 48755 | 11 | 0.936 | 52088.7 |
987 | 2024-03-29 06:40:22 | middle | 3 | 112716 | 532 | 8.530 | 13214.1 |
986 | 2024-03-29 06:40:23 | middle | 2 | 82551 | 83 | 5.206 | 15856.9 |
985 | 2024-02-28 08:10:52 | middle | 2 | 82551 | 83 | 5.263 | 15685.2 |
984 | 2024-02-28 08:10:32 | middle | 3 | 112716 | 532 | 6.733 | 16740.8 |
983 | 2024-02-28 01:56:35 | middle | 2 | 82551 | 83 | 3.326 | 24819.9 |
982 | 2024-02-28 01:56:25 | middle | 3 | 112716 | 532 | 9.406 | 11983.4 |
981 | 2024-02-28 01:54:15 | middle | 3 | 112716 | 532 | 7.800 | 14450.8 |
980 | 2024-02-28 01:54:13 | middle | 2 | 82551 | 83 | 4.670 | 17676.9 |
979 | 2024-02-28 01:54:13 | middle | 1 | 48755 | 11 | 1.610 | 30282.6 |
978 | 2024-01-09 00:28:06 | middle | 3 | 112716 | 532 | 5.423 | 20784.8 |
977 | 2024-01-08 15:34:06 | middle | 3 | 112716 | 532 | 5.923 | 19030.2 |
976 | 2024-01-08 15:33:59 | middle | 2 | 82551 | 83 | 3.936 | 20973.3 |
975 | 2024-01-05 09:52:10 | middle | 3 | 112716 | 532 | 4.830 | 23336.6 |
974 | 2024-01-05 09:52:07 | middle | 2 | 82551 | 83 | 2.296 | 35954.3 |
973 | 2024-01-01 01:03:02 | middle | 1 | 48755 | 11 | 0.810 | 60191.4 |
972 | 2023-12-11 11:10:52 | middle | 2 | 82551 | 83 | 4.576 | 18040.0 |
971 | 2023-11-21 23:42:01 | middle | 3 | 112716 | 532 | 5.080 | 22188.2 |
970 | 2023-11-16 22:21:13 | middle | 1 | 48755 | 11 | 0.796 | 61250.0 |
969 | 2023-11-16 00:54:44 | middle | 2 | 82551 | 83 | 2.500 | 33020.4 |
968 | 2023-11-16 00:54:41 | middle | 3 | 112716 | 532 | 5.376 | 20966.5 |
967 | 2023-11-14 04:13:45 | middle | 1 | 48755 | 11 | 0.813 | 59969.2 |
966 | 2023-11-10 07:45:25 | middle | 1 | 48755 | 11 | 1.626 | 29984.6 |
965 | 2023-11-06 15:27:22 | middle | 1 | 48755 | 11 | 0.860 | 56691.9 |
964 | 2023-10-21 11:00:22 | middle | 1 | 48755 | 11 | 0.826 | 59025.4 |
963 | 2023-10-20 05:22:41 | middle | 1 | 48755 | 11 | 0.843 | 57835.1 |
962 | 2023-10-19 00:33:05 | middle | 1 | 48755 | 11 | 0.813 | 59969.2 |
961 | 2023-10-13 16:56:37 | middle | 1 | 48755 | 11 | 0.813 | 59969.2 |
960 | 2023-10-05 05:13:13 | middle | 1 | 48755 | 11 | 0.736 | 66243.2 |
959 | 2023-09-26 00:51:37 | middle | 1 | 48755 | 11 | 1.690 | 28849.1 |
958 | 2023-09-12 19:43:16 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
957 | 2023-09-12 07:55:30 | middle | 2 | 82551 | 83 | 2.436 | 33887.9 |
956 | 2023-09-10 07:53:21 | middle | 2 | 82551 | 83 | 2.093 | 39441.5 |
955 | 2023-08-16 00:59:43 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
954 | 2023-07-15 12:55:30 | middle | 1 | 48755 | 11 | 0.720 | 67715.3 |
953 | 2023-07-11 17:14:04 | middle | 1 | 48755 | 11 | 0.890 | 54780.9 |
952 | 2023-06-02 06:52:25 | middle | 2 | 82551 | 83 | 2.060 | 40073.3 |
951 | 2023-05-15 05:15:10 | middle | 1 | 48755 | 11 | 0.736 | 66243.2 |
950 | 2023-05-03 05:10:38 | middle | 2 | 82551 | 83 | 2.453 | 33653.1 |
949 | 2023-04-02 23:27:22 | middle | 2 | 82551 | 83 | 2.153 | 38342.3 |
948 | 2023-03-24 03:43:37 | middle | 1 | 48755 | 11 | 0.736 | 66243.2 |
947 | 2023-03-08 19:55:41 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
946 | 2023-03-08 03:55:47 | middle | 2 | 82551 | 83 | 2.360 | 34979.2 |
945 | 2022-12-30 05:18:32 | middle | 1 | 48755 | 11 | 0.720 | 67715.3 |
944 | 2022-12-14 13:04:09 | middle | 2 | 82551 | 83 | 2.343 | 35233.0 |
943 | 2022-12-02 16:31:37 | middle | 1 | 48755 | 11 | 0.720 | 67715.3 |
942 | 2022-11-29 09:58:35 | middle | 1 | 48755 | 11 | 0.830 | 58741.0 |
941 | 2022-09-19 14:36:46 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
940 | 2022-09-18 11:04:00 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
939 | 2022-09-16 12:12:36 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
938 | 2022-09-12 01:08:36 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
937 | 2022-09-10 09:46:01 | middle | 1 | 48755 | 11 | 0.846 | 57630.0 |
936 | 2022-09-09 10:56:54 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
935 | 2022-09-01 17:54:38 | middle | 3 | 112716 | 532 | 4.563 | 24702.2 |
934 | 2022-09-01 11:20:30 | middle | 1 | 48755 | 11 | 0.846 | 57630.0 |
933 | 2022-08-31 01:04:09 | middle | 1 | 48755 | 11 | 0.720 | 67715.3 |
932 | 2022-08-26 01:30:58 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
931 | 2022-08-22 23:08:55 | middle | 1 | 48755 | 11 | 0.830 | 58741.0 |
930 | 2022-08-15 02:49:51 | middle | 2 | 82551 | 83 | 2.360 | 34979.2 |
929 | 2022-08-14 23:11:48 | middle | 1 | 48755 | 11 | 0.780 | 62506.4 |
928 | 2022-08-06 18:32:20 | middle | 2 | 82551 | 83 | 2.203 | 37472.1 |
927 | 2022-08-06 18:08:50 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
926 | 2022-08-06 11:37:50 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
925 | 2022-08-06 05:12:33 | middle | 1 | 48755 | 11 | 0.830 | 58741.0 |
924 | 2022-08-04 11:23:17 | middle | 2 | 82551 | 83 | 2.186 | 37763.5 |
923 | 2022-08-02 12:20:52 | middle | 1 | 48755 | 11 | 0.813 | 59969.2 |
922 | 2022-07-29 23:11:00 | middle | 1 | 48755 | 11 | 0.846 | 57630.0 |
921 | 2022-07-29 11:15:52 | middle | 2 | 82551 | 83 | 2.190 | 37694.5 |
920 | 2022-07-28 18:37:27 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
919 | 2022-07-24 16:17:26 | middle | 3 | 112716 | 532 | 4.563 | 24702.2 |
918 | 2022-07-17 17:18:40 | middle | 1 | 48755 | 11 | 0.843 | 57835.1 |
917 | 2022-07-15 12:00:27 | middle | 3 | 112716 | 532 | 4.593 | 24540.8 |
916 | 2022-07-09 21:15:35 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
915 | 2022-07-03 06:15:58 | middle | 1 | 48755 | 11 | 0.736 | 66243.2 |
914 | 2022-07-02 07:04:53 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
913 | 2022-07-02 06:16:46 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
912 | 2022-06-16 06:19:54 | middle | 1 | 48755 | 11 | 0.733 | 66514.3 |
911 | 2022-06-15 16:01:45 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
910 | 2022-04-01 00:28:41 | middle | 1 | 48755 | 11 | 0.766 | 63648.8 |
909 | 2022-03-02 20:15:47 | middle | 1 | 48755 | 11 | 0.736 | 66243.2 |
908 | 2022-01-15 06:19:07 | middle | 1 | 48755 | 11 | 0.906 | 53813.5 |
907 | 2021-12-19 17:37:12 | middle | 1 | 48755 | 11 | 1.766 | 27607.6 |
906 | 2021-12-17 15:00:26 | middle | 1 | 48755 | 11 | 0.796 | 61250.0 |
905 | 2021-12-17 11:18:19 | middle | 1 | 48755 | 11 | 1.826 | 26700.4 |
904 | 2021-12-13 22:13:33 | middle | 1 | 48755 | 11 | 0.873 | 55847.7 |
903 | 2021-10-24 17:16:19 | middle | 1 | 48755 | 11 | 0.873 | 55847.7 |
902 | 2021-09-10 14:54:07 | middle | 1 | 48755 | 11 | 0.843 | 57835.1 |
901 | 2021-09-06 23:57:06 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
900 | 2021-08-26 03:28:41 | middle | 1 | 48755 | 11 | 0.750 | 65006.7 |
899 | 2021-07-03 00:39:46 | middle | 1 | 48755 | 11 | 0.826 | 59025.4 |
898 | 2021-06-06 00:08:14 | middle | 1 | 48755 | 11 | 0.813 | 59969.2 |
897 | 2021-06-02 19:50:03 | middle | 1 | 48755 | 11 | 0.843 | 57835.1 |
896 | 2021-05-25 18:58:13 | middle | 1 | 48755 | 11 | 0.843 | 57835.1 |
895 | 2021-04-29 14:20:27 | middle | 1 | 48755 | 11 | 0.906 | 53813.5 |
894 | 2021-02-28 06:44:20 | middle | 1 | 48755 | 11 | 1.470 | 33166.7 |