History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cattle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
947 | 2024-04-26 02:25:08 | cattle | 1 | 48755 | 9 | 1.063 | 45865.5 |
946 | 2024-04-06 09:08:50 | cattle | 1 | 48755 | 9 | 2.640 | 18467.8 |
945 | 2024-03-07 16:25:32 | cattle | 2 | 82551 | 76 | 2.610 | 31628.7 |
944 | 2024-03-07 06:52:29 | cattle | 3 | 112716 | 731 | 7.123 | 15824.2 |
943 | 2024-03-05 23:29:33 | cattle | 1 | 48755 | 9 | 3.046 | 16006.2 |
942 | 2024-03-05 19:08:42 | cattle | 3 | 112716 | 731 | 7.173 | 15713.9 |
941 | 2024-03-05 17:07:38 | cattle | 3 | 112716 | 731 | 12.393 | 9095.1 |
940 | 2024-03-05 03:40:23 | cattle | 3 | 112716 | 731 | 20.376 | 5531.8 |
939 | 2024-03-04 20:41:04 | cattle | 3 | 112716 | 731 | 6.220 | 18121.5 |
938 | 2024-03-04 20:41:03 | cattle | 1 | 48755 | 9 | 0.953 | 51159.5 |
937 | 2024-03-04 20:40:54 | cattle | 2 | 82551 | 76 | 2.750 | 30018.5 |
936 | 2024-03-03 09:51:27 | cattle | 2 | 82551 | 76 | 2.483 | 33246.5 |
935 | 2024-02-13 11:06:35 | cattle | 1 | 48755 | 9 | 2.003 | 24341.0 |
934 | 2024-02-01 17:25:45 | cattle | 1 | 48755 | 9 | 0.906 | 53813.5 |
933 | 2023-12-21 22:12:33 | cattle | 2 | 82551 | 76 | 2.673 | 30883.3 |
932 | 2023-12-21 22:12:22 | cattle | 3 | 112716 | 731 | 6.203 | 18171.2 |
931 | 2023-12-15 10:02:20 | cattle | 3 | 112716 | 731 | 5.003 | 22529.7 |
930 | 2023-12-10 17:36:37 | cattle | 3 | 112716 | 731 | 5.783 | 19490.9 |
929 | 2023-12-10 17:36:39 | cattle | 2 | 82551 | 76 | 2.686 | 30733.8 |
928 | 2023-12-06 23:38:34 | cattle | 1 | 48755 | 9 | 0.856 | 56956.8 |
927 | 2023-11-30 18:53:42 | cattle | 1 | 48755 | 9 | 0.873 | 55847.7 |
926 | 2023-11-26 08:27:38 | cattle | 2 | 82551 | 76 | 2.500 | 33020.4 |
925 | 2023-11-24 21:20:10 | cattle | 2 | 82551 | 76 | 2.700 | 30574.4 |
924 | 2023-11-12 02:43:47 | cattle | 1 | 48755 | 9 | 0.876 | 55656.4 |
923 | 2023-11-11 07:13:47 | cattle | 1 | 48755 | 9 | 0.856 | 56956.8 |
922 | 2023-11-06 15:25:15 | cattle | 1 | 48755 | 9 | 0.763 | 63899.1 |
921 | 2023-11-06 13:44:09 | cattle | 1 | 48755 | 9 | 1.796 | 27146.4 |
920 | 2023-11-03 09:07:38 | cattle | 1 | 48755 | 9 | 0.876 | 55656.4 |
919 | 2023-10-28 23:29:22 | cattle | 3 | 112716 | 731 | 12.143 | 9282.4 |
918 | 2023-10-21 22:40:02 | cattle | 1 | 48755 | 9 | 0.953 | 51159.5 |
917 | 2023-10-20 21:29:03 | cattle | 3 | 112716 | 731 | 11.656 | 9670.2 |
916 | 2023-10-19 00:54:51 | cattle | 1 | 48755 | 9 | 0.810 | 60191.4 |
915 | 2023-10-18 00:51:06 | cattle | 3 | 112716 | 731 | 4.940 | 22817.0 |
914 | 2023-10-13 08:36:29 | cattle | 1 | 48755 | 9 | 0.780 | 62506.4 |
913 | 2023-10-08 01:52:49 | cattle | 1 | 48755 | 9 | 0.810 | 60191.4 |
912 | 2023-09-27 15:22:25 | cattle | 1 | 48755 | 9 | 0.826 | 59025.4 |
911 | 2023-09-14 19:53:22 | cattle | 1 | 48755 | 9 | 0.750 | 65006.7 |
910 | 2023-09-11 07:53:32 | cattle | 1 | 48755 | 9 | 0.860 | 56691.9 |
909 | 2023-08-25 05:51:28 | cattle | 3 | 112716 | 731 | 4.783 | 23566.0 |
908 | 2023-08-23 22:38:59 | cattle | 2 | 82551 | 76 | 2.250 | 36689.3 |
907 | 2023-07-22 21:13:52 | cattle | 1 | 48755 | 9 | 0.780 | 62506.4 |
906 | 2023-07-03 08:40:57 | cattle | 1 | 48755 | 9 | 0.860 | 56691.9 |
905 | 2023-05-17 04:58:02 | cattle | 2 | 82551 | 76 | 2.250 | 36689.3 |
904 | 2023-05-09 08:50:19 | cattle | 2 | 82551 | 76 | 2.516 | 32810.4 |
903 | 2023-04-12 00:12:39 | cattle | 1 | 48755 | 9 | 0.750 | 65006.7 |
902 | 2023-04-11 04:13:33 | cattle | 1 | 48755 | 9 | 0.766 | 63648.8 |
901 | 2023-04-02 07:52:59 | cattle | 2 | 82551 | 76 | 2.190 | 37694.5 |
900 | 2023-02-14 22:18:28 | cattle | 2 | 82551 | 76 | 2.236 | 36919.1 |
899 | 2023-02-03 06:49:30 | cattle | 1 | 48755 | 9 | 0.873 | 55847.7 |
898 | 2023-01-02 06:54:21 | cattle | 1 | 48755 | 9 | 0.763 | 63899.1 |
897 | 2022-12-01 09:42:03 | cattle | 1 | 48755 | 9 | 0.750 | 65006.7 |
896 | 2022-11-27 16:28:31 | cattle | 2 | 82551 | 76 | 2.190 | 37694.5 |
895 | 2022-11-25 14:45:05 | cattle | 1 | 48755 | 9 | 0.766 | 63648.8 |
894 | 2022-09-22 08:34:44 | cattle | 1 | 48755 | 9 | 0.780 | 62506.4 |
893 | 2022-09-14 21:16:55 | cattle | 1 | 48755 | 9 | 0.826 | 59025.4 |
892 | 2022-07-27 04:36:24 | cattle | 1 | 48755 | 9 | 0.800 | 60943.8 |
891 | 2022-07-04 07:52:09 | cattle | 2 | 82551 | 76 | 2.186 | 37763.5 |
890 | 2022-06-12 13:34:38 | cattle | 1 | 48755 | 9 | 0.750 | 65006.7 |
889 | 2022-03-21 22:00:16 | cattle | 1 | 48755 | 9 | 0.860 | 56691.9 |
888 | 2022-02-22 01:21:15 | cattle | 1 | 48755 | 9 | 0.843 | 57835.1 |
887 | 2022-02-13 09:13:40 | cattle | 2 | 82551 | 76 | 2.563 | 32208.7 |
886 | 2021-12-27 20:49:28 | cattle | 1 | 48755 | 9 | 0.936 | 52088.7 |
885 | 2021-11-14 00:31:06 | cattle | 1 | 48755 | 9 | 0.783 | 62266.9 |
884 | 2021-10-30 13:30:25 | cattle | 1 | 48755 | 9 | 0.876 | 55656.4 |
883 | 2021-09-23 05:08:52 | cattle | 1 | 48755 | 9 | 0.873 | 55847.7 |
882 | 2021-09-21 02:09:06 | cattle | 1 | 48755 | 9 | 0.890 | 54780.9 |
881 | 2021-08-17 03:43:52 | cattle | 1 | 48755 | 9 | 0.843 | 57835.1 |
880 | 2021-08-14 23:36:20 | cattle | 1 | 48755 | 9 | 0.796 | 61250.0 |
879 | 2021-08-11 01:48:47 | cattle | 1 | 48755 | 9 | 0.766 | 63648.8 |
878 | 2021-08-07 23:33:26 | cattle | 2 | 82551 | 76 | 2.296 | 35954.3 |
877 | 2021-07-28 07:38:19 | cattle | 2 | 82551 | 76 | 2.203 | 37472.1 |
876 | 2021-07-27 05:31:50 | cattle | 2 | 82551 | 76 | 2.436 | 33887.9 |
875 | 2021-07-26 12:58:09 | cattle | 2 | 82551 | 76 | 2.593 | 31836.1 |
874 | 2021-07-25 00:27:33 | cattle | 2 | 82551 | 76 | 2.156 | 38289.0 |
873 | 2021-07-23 03:51:50 | cattle | 2 | 82551 | 76 | 2.220 | 37185.1 |
872 | 2021-07-22 08:39:39 | cattle | 2 | 82551 | 76 | 2.186 | 37763.5 |
871 | 2021-07-20 08:36:24 | cattle | 2 | 82551 | 76 | 2.216 | 37252.3 |
870 | 2021-07-18 17:48:40 | cattle | 2 | 82551 | 76 | 2.530 | 32628.9 |
869 | 2021-07-17 01:35:27 | cattle | 2 | 82551 | 76 | 2.423 | 34069.7 |
868 | 2021-07-14 14:37:33 | cattle | 2 | 82551 | 76 | 2.673 | 30883.3 |
867 | 2021-07-14 08:02:19 | cattle | 2 | 82551 | 76 | 2.533 | 32590.2 |
866 | 2021-07-12 07:09:03 | cattle | 1 | 48755 | 9 | 0.783 | 62266.9 |
865 | 2021-07-11 20:22:33 | cattle | 2 | 82551 | 76 | 2.233 | 36968.7 |
864 | 2021-07-09 14:50:18 | cattle | 2 | 82551 | 76 | 4.780 | 17270.1 |
863 | 2021-07-08 19:17:44 | cattle | 2 | 82551 | 76 | 2.296 | 35954.3 |
862 | 2021-07-07 19:11:55 | cattle | 2 | 82551 | 76 | 2.563 | 32208.7 |
861 | 2021-07-04 07:00:13 | cattle | 2 | 82551 | 76 | 2.283 | 36159.0 |
860 | 2021-07-03 18:07:32 | cattle | 2 | 82551 | 76 | 2.673 | 30883.3 |
859 | 2021-07-02 14:08:04 | cattle | 2 | 82551 | 76 | 2.530 | 32628.9 |
858 | 2021-07-01 21:10:43 | cattle | 2 | 82551 | 76 | 2.533 | 32590.2 |
857 | 2021-06-30 13:12:42 | cattle | 2 | 82551 | 76 | 5.580 | 14794.1 |
856 | 2021-06-26 23:35:09 | cattle | 2 | 82551 | 76 | 2.423 | 34069.7 |
855 | 2021-06-26 11:20:04 | cattle | 2 | 82551 | 76 | 2.736 | 30172.1 |
854 | 2021-06-25 03:53:33 | cattle | 2 | 82551 | 76 | 2.486 | 33206.4 |
853 | 2021-06-24 16:34:13 | cattle | 2 | 82551 | 76 | 2.343 | 35233.0 |
852 | 2021-06-23 22:41:20 | cattle | 2 | 82551 | 76 | 2.470 | 33421.5 |
851 | 2021-06-23 11:54:27 | cattle | 2 | 82551 | 76 | 2.456 | 33612.0 |
850 | 2021-06-22 10:31:01 | cattle | 2 | 82551 | 76 | 2.513 | 32849.6 |
849 | 2021-06-21 04:34:52 | cattle | 2 | 82551 | 76 | 2.656 | 31080.9 |
848 | 2021-06-18 22:54:01 | cattle | 2 | 82551 | 76 | 2.190 | 37694.5 |