History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
978 | 2024-02-28 10:28:09 | collie | 1 | 48755 | 7 | 1.763 | 27654.6 |
977 | 2024-02-25 18:54:26 | collie | 1 | 48755 | 7 | 0.966 | 50471.0 |
976 | 2024-02-14 21:51:09 | collie | 2 | 82551 | 76 | 2.596 | 31799.3 |
975 | 2024-02-09 22:03:35 | collie | 2 | 82551 | 76 | 8.656 | 9536.9 |
974 | 2024-02-09 17:09:24 | collie | 3 | 112716 | 856 | 6.123 | 18408.6 |
973 | 2024-02-07 17:36:40 | collie | 3 | 112716 | 856 | 13.123 | 8589.2 |
972 | 2024-02-07 05:49:57 | collie | 3 | 112716 | 856 | 9.406 | 11983.4 |
971 | 2024-02-07 05:49:54 | collie | 2 | 82551 | 76 | 5.703 | 14475.0 |
970 | 2024-01-25 10:28:42 | collie | 1 | 48755 | 7 | 0.780 | 62506.4 |
969 | 2024-01-02 07:15:30 | collie | 1 | 48755 | 7 | 0.906 | 53813.5 |
968 | 2023-12-31 14:21:41 | collie | 3 | 112716 | 856 | 5.610 | 20092.0 |
967 | 2023-12-31 14:21:42 | collie | 2 | 82551 | 76 | 2.623 | 31472.0 |
966 | 2023-12-22 18:29:27 | collie | 1 | 48755 | 7 | 0.750 | 65006.7 |
965 | 2023-12-21 20:35:16 | collie | 2 | 82551 | 76 | 2.233 | 36968.7 |
964 | 2023-12-12 15:56:11 | collie | 3 | 112716 | 856 | 4.983 | 22620.1 |
963 | 2023-12-06 06:02:04 | collie | 3 | 112716 | 856 | 6.060 | 18600.0 |
962 | 2023-12-06 06:02:01 | collie | 2 | 82551 | 76 | 2.580 | 31996.5 |
961 | 2023-11-21 11:35:01 | collie | 2 | 82551 | 76 | 2.346 | 35188.0 |
960 | 2023-11-21 11:34:53 | collie | 3 | 112716 | 856 | 4.910 | 22956.4 |
959 | 2023-11-17 22:58:27 | collie | 1 | 48755 | 7 | 0.783 | 62266.9 |
958 | 2023-11-13 17:14:31 | collie | 1 | 48755 | 7 | 0.860 | 56691.9 |
957 | 2023-11-09 12:15:15 | collie | 1 | 48755 | 7 | 0.750 | 65006.7 |
956 | 2023-11-07 07:57:15 | collie | 1 | 48755 | 7 | 0.750 | 65006.7 |
955 | 2023-11-02 06:17:10 | collie | 3 | 112716 | 856 | 5.106 | 22075.2 |
954 | 2023-11-02 06:17:12 | collie | 2 | 82551 | 76 | 2.470 | 33421.5 |
953 | 2023-10-28 03:43:40 | collie | 1 | 48755 | 7 | 0.893 | 54596.9 |
952 | 2023-10-23 18:50:07 | collie | 1 | 48755 | 7 | 0.940 | 51867.0 |
951 | 2023-10-20 22:11:21 | collie | 1 | 48755 | 7 | 0.893 | 54596.9 |
950 | 2023-10-18 02:23:18 | collie | 1 | 48755 | 7 | 0.796 | 61250.0 |
949 | 2023-10-14 03:21:26 | collie | 1 | 48755 | 7 | 0.766 | 63648.8 |
948 | 2023-10-11 22:14:51 | collie | 1 | 48755 | 7 | 0.750 | 65006.7 |
947 | 2023-10-04 14:13:02 | collie | 1 | 48755 | 7 | 0.826 | 59025.4 |
946 | 2023-09-29 22:19:59 | collie | 2 | 82551 | 76 | 2.890 | 28564.4 |
945 | 2023-09-28 15:11:24 | collie | 2 | 82551 | 76 | 2.703 | 30540.5 |
944 | 2023-09-26 13:45:10 | collie | 1 | 48755 | 7 | 0.906 | 53813.5 |
943 | 2023-09-24 21:10:35 | collie | 1 | 48755 | 7 | 0.780 | 62506.4 |
942 | 2023-09-22 11:42:22 | collie | 2 | 82551 | 76 | 2.203 | 37472.1 |
941 | 2023-09-12 17:01:12 | collie | 3 | 112716 | 856 | 5.580 | 20200.0 |
940 | 2023-08-19 06:25:05 | collie | 1 | 48755 | 7 | 0.876 | 55656.4 |
939 | 2023-07-08 09:18:20 | collie | 1 | 48755 | 7 | 0.810 | 60191.4 |
938 | 2023-07-02 03:46:44 | collie | 2 | 82551 | 76 | 2.236 | 36919.1 |
937 | 2023-06-05 22:10:18 | collie | 3 | 112716 | 856 | 4.690 | 24033.3 |
936 | 2023-05-20 03:10:52 | collie | 1 | 48755 | 7 | 0.813 | 59969.2 |
935 | 2023-04-04 14:42:00 | collie | 1 | 48755 | 7 | 0.766 | 63648.8 |
934 | 2023-04-01 23:15:33 | collie | 3 | 112716 | 856 | 4.766 | 23650.0 |
933 | 2023-03-23 00:19:34 | collie | 2 | 82551 | 76 | 2.143 | 38521.2 |
932 | 2023-03-13 09:39:53 | collie | 1 | 48755 | 7 | 0.750 | 65006.7 |
931 | 2023-03-11 07:39:52 | collie | 3 | 112716 | 856 | 4.750 | 23729.7 |
930 | 2023-01-28 15:11:38 | collie | 3 | 112716 | 856 | 4.656 | 24208.8 |
929 | 2023-01-03 03:13:49 | collie | 1 | 48755 | 7 | 0.843 | 57835.1 |
928 | 2022-12-22 10:14:00 | collie | 2 | 82551 | 76 | 2.156 | 38289.0 |
927 | 2022-12-14 21:53:28 | collie | 3 | 112716 | 856 | 4.686 | 24053.8 |
926 | 2022-12-13 19:25:58 | collie | 3 | 112716 | 856 | 5.110 | 22057.9 |
925 | 2022-11-01 14:42:21 | collie | 3 | 112716 | 856 | 4.940 | 22817.0 |
924 | 2022-10-27 07:42:36 | collie | 3 | 112716 | 856 | 6.576 | 17140.5 |
923 | 2022-09-23 03:22:14 | collie | 1 | 48755 | 7 | 0.766 | 63648.8 |
922 | 2022-09-16 17:40:04 | collie | 3 | 112716 | 856 | 5.593 | 20153.0 |
921 | 2022-08-20 02:43:27 | collie | 2 | 82551 | 76 | 2.326 | 35490.5 |
920 | 2022-08-17 17:36:51 | collie | 2 | 82551 | 76 | 2.170 | 38041.9 |
919 | 2022-08-12 10:18:34 | collie | 1 | 48755 | 7 | 0.780 | 62506.4 |
918 | 2022-08-04 17:59:00 | collie | 3 | 112716 | 856 | 5.280 | 21347.7 |
917 | 2022-06-30 02:18:22 | collie | 1 | 48755 | 7 | 0.766 | 63648.8 |
916 | 2022-06-13 08:54:40 | collie | 1 | 48755 | 7 | 0.876 | 55656.4 |
915 | 2022-03-13 17:26:01 | collie | 2 | 82551 | 76 | 2.156 | 38289.0 |
914 | 2022-03-11 11:38:42 | collie | 1 | 48755 | 7 | 0.750 | 65006.7 |
913 | 2022-03-09 07:44:09 | collie | 1 | 48755 | 7 | 0.810 | 60191.4 |
912 | 2022-03-06 04:35:54 | collie | 3 | 112716 | 856 | 4.890 | 23050.3 |
911 | 2022-03-01 16:03:10 | collie | 1 | 48755 | 7 | 1.296 | 37619.6 |
910 | 2021-12-17 15:37:14 | collie | 1 | 48755 | 7 | 0.860 | 56691.9 |
909 | 2021-11-28 01:39:14 | collie | 1 | 48755 | 7 | 0.983 | 49598.2 |
908 | 2021-10-24 18:30:41 | collie | 1 | 48755 | 7 | 0.810 | 60191.4 |
907 | 2021-09-14 22:36:16 | collie | 1 | 48755 | 7 | 0.893 | 54596.9 |
906 | 2021-09-12 18:42:30 | collie | 1 | 48755 | 7 | 0.860 | 56691.9 |
905 | 2021-08-26 05:04:49 | collie | 1 | 48755 | 7 | 0.780 | 62506.4 |
904 | 2021-08-25 05:29:16 | collie | 1 | 48755 | 7 | 0.780 | 62506.4 |
903 | 2021-05-26 22:47:37 | collie | 1 | 48755 | 7 | 0.890 | 54780.9 |
902 | 2021-05-24 09:00:10 | collie | 1 | 48755 | 7 | 0.843 | 57835.1 |
901 | 2021-05-01 04:04:58 | collie | 1 | 48755 | 7 | 0.970 | 50262.9 |
900 | 2021-02-26 17:49:04 | collie | 1 | 48755 | 7 | 0.766 | 63648.8 |
899 | 2021-02-18 18:44:30 | collie | 1 | 48755 | 7 | 0.763 | 63899.1 |
898 | 2021-02-11 08:49:43 | collie | 1 | 48755 | 7 | 0.860 | 56691.9 |
897 | 2021-02-08 05:34:10 | collie | 1 | 48755 | 7 | 0.796 | 61250.0 |
896 | 2021-02-06 12:35:27 | collie | 1 | 48755 | 7 | 0.780 | 62506.4 |
895 | 2021-01-31 20:23:41 | collie | 1 | 48755 | 7 | 0.813 | 59969.2 |
894 | 2021-01-14 01:32:13 | collie | 1 | 48755 | 7 | 0.873 | 55847.7 |
893 | 2020-11-14 06:41:33 | collie | 1 | 48755 | 7 | 0.766 | 63648.8 |
892 | 2020-11-04 11:53:34 | collie | 1 | 48755 | 7 | 0.796 | 61250.0 |
891 | 2020-10-25 22:22:44 | collie | 1 | 48755 | 7 | 0.873 | 55847.7 |
890 | 2020-10-01 07:06:31 | collie | 1 | 48755 | 7 | 0.763 | 63899.1 |
889 | 2020-09-09 12:32:29 | collie | 1 | 48755 | 7 | 0.893 | 54596.9 |
888 | 2020-08-29 14:20:58 | collie | 1 | 48755 | 7 | 0.780 | 62506.4 |
887 | 2020-08-20 17:41:25 | collie | 1 | 48755 | 7 | 0.813 | 59969.2 |
886 | 2020-08-06 07:29:49 | collie | 1 | 48755 | 7 | 1.453 | 33554.7 |
885 | 2020-07-31 21:45:43 | collie | 1 | 48755 | 7 | 0.860 | 56691.9 |
884 | 2020-07-21 08:39:10 | collie | 1 | 48755 | 7 | 0.970 | 50262.9 |
883 | 2020-04-29 10:34:09 | collie | 1 | 48755 | 7 | 0.800 | 60943.8 |
882 | 2020-04-23 21:00:20 | collie | 1 | 48755 | 7 | 0.843 | 57835.1 |
881 | 2020-03-27 16:26:46 | collie | 1 | 48755 | 7 | 0.750 | 65006.7 |
880 | 2020-03-24 23:32:12 | collie | 1 | 48755 | 7 | 0.890 | 54780.9 |
879 | 2020-03-24 15:15:17 | collie | 1 | 48755 | 7 | 0.936 | 52088.7 |