History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"acorns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
958 | 2024-04-27 15:51:13 | acorns | 1 | 48755 | 5 | 1.123 | 43415.0 |
957 | 2024-04-27 14:10:27 | acorns | 1 | 48755 | 5 | 2.720 | 17924.6 |
956 | 2024-04-27 13:43:33 | acorns | 1 | 48755 | 5 | 2.220 | 21961.7 |
955 | 2024-04-25 13:38:51 | acorns | 1 | 48755 | 5 | 0.970 | 50262.9 |
954 | 2024-04-21 19:29:43 | acorns | 1 | 48755 | 5 | 1.690 | 28849.1 |
953 | 2024-04-02 18:49:07 | acorns | 3 | 112716 | 809 | 11.986 | 9404.0 |
952 | 2024-04-01 16:12:38 | acorns | 2 | 82551 | 56 | 6.626 | 12458.6 |
951 | 2024-04-01 16:07:38 | acorns | 3 | 112716 | 809 | 10.330 | 10911.5 |
950 | 2024-04-01 16:07:38 | acorns | 2 | 82551 | 56 | 2.860 | 28864.0 |
949 | 2024-04-01 16:07:33 | acorns | 1 | 48755 | 5 | 0.906 | 53813.5 |
948 | 2024-04-01 16:07:02 | acorns | 3 | 112716 | 809 | 6.470 | 17421.3 |
947 | 2024-04-01 10:29:29 | acorns | 3 | 112716 | 809 | 16.610 | 6786.0 |
946 | 2024-03-22 05:07:07 | acorns | 1 | 48755 | 5 | 0.936 | 52088.7 |
945 | 2024-03-18 00:59:57 | acorns | 1 | 48755 | 5 | 2.970 | 16415.8 |
944 | 2024-01-17 18:52:11 | acorns | 3 | 112716 | 809 | 5.486 | 20546.1 |
943 | 2024-01-17 18:52:13 | acorns | 2 | 82551 | 56 | 2.500 | 33020.4 |
942 | 2024-01-15 22:16:41 | acorns | 1 | 48755 | 5 | 0.890 | 54780.9 |
941 | 2024-01-13 21:20:48 | acorns | 1 | 48755 | 5 | 0.923 | 52822.3 |
940 | 2024-01-05 04:35:11 | acorns | 2 | 82551 | 56 | 2.330 | 35429.6 |
939 | 2023-12-31 19:19:33 | acorns | 1 | 48755 | 5 | 0.766 | 63648.8 |
938 | 2023-12-20 09:12:32 | acorns | 3 | 112716 | 809 | 5.046 | 22337.7 |
937 | 2023-12-20 09:12:28 | acorns | 2 | 82551 | 56 | 2.606 | 31677.3 |
936 | 2023-12-07 13:36:44 | acorns | 1 | 48755 | 5 | 0.780 | 62506.4 |
935 | 2023-12-07 13:36:42 | acorns | 1 | 48755 | 5 | 0.873 | 55847.7 |
934 | 2023-12-05 20:01:20 | acorns | 3 | 112716 | 809 | 4.766 | 23650.0 |
933 | 2023-11-20 19:02:07 | acorns | 2 | 82551 | 56 | 2.250 | 36689.3 |
932 | 2023-11-20 19:02:01 | acorns | 3 | 112716 | 809 | 5.486 | 20546.1 |
931 | 2023-11-12 09:55:50 | acorns | 1 | 48755 | 5 | 1.643 | 29674.4 |
930 | 2023-11-12 05:55:50 | acorns | 1 | 48755 | 5 | 0.783 | 62266.9 |
929 | 2023-11-09 00:14:46 | acorns | 1 | 48755 | 5 | 0.830 | 58741.0 |
928 | 2023-11-02 09:22:19 | acorns | 1 | 48755 | 5 | 0.843 | 57835.1 |
927 | 2023-10-28 08:51:10 | acorns | 1 | 48755 | 5 | 1.766 | 27607.6 |
926 | 2023-10-25 07:33:31 | acorns | 1 | 48755 | 5 | 0.843 | 57835.1 |
925 | 2023-10-19 18:58:57 | acorns | 1 | 48755 | 5 | 0.923 | 52822.3 |
924 | 2023-10-14 09:13:43 | acorns | 2 | 82551 | 56 | 2.596 | 31799.3 |
923 | 2023-10-12 09:52:20 | acorns | 1 | 48755 | 5 | 0.843 | 57835.1 |
922 | 2023-10-10 23:51:21 | acorns | 2 | 82551 | 56 | 2.173 | 37989.4 |
921 | 2023-10-10 13:04:19 | acorns | 3 | 112716 | 809 | 5.670 | 19879.4 |
920 | 2023-10-10 05:25:11 | acorns | 3 | 112716 | 809 | 4.706 | 23951.6 |
919 | 2023-10-06 21:40:14 | acorns | 3 | 112716 | 809 | 4.936 | 22835.5 |
918 | 2023-10-06 02:56:03 | acorns | 3 | 112716 | 809 | 12.780 | 8819.7 |
917 | 2023-10-05 19:22:06 | acorns | 1 | 48755 | 5 | 0.780 | 62506.4 |
916 | 2023-10-05 11:23:28 | acorns | 1 | 48755 | 5 | 0.830 | 58741.0 |
915 | 2023-09-30 16:35:20 | acorns | 3 | 112716 | 809 | 4.763 | 23664.9 |
914 | 2023-09-30 16:35:17 | acorns | 2 | 82551 | 56 | 2.156 | 38289.0 |
913 | 2023-09-24 22:15:50 | acorns | 1 | 48755 | 5 | 1.576 | 30935.9 |
912 | 2023-09-14 04:19:22 | acorns | 1 | 48755 | 5 | 0.843 | 57835.1 |
911 | 2023-09-03 00:21:03 | acorns | 3 | 112716 | 809 | 5.203 | 21663.7 |
910 | 2023-07-21 02:11:37 | acorns | 2 | 82551 | 56 | 2.563 | 32208.7 |
909 | 2023-07-02 14:45:16 | acorns | 1 | 48755 | 5 | 0.906 | 53813.5 |
908 | 2023-05-19 18:13:14 | acorns | 3 | 112716 | 809 | 5.106 | 22075.2 |
907 | 2023-04-01 15:21:56 | acorns | 2 | 82551 | 56 | 2.153 | 38342.3 |
906 | 2023-03-31 14:54:31 | acorns | 1 | 48755 | 5 | 0.826 | 59025.4 |
905 | 2023-03-26 04:04:13 | acorns | 1 | 48755 | 5 | 0.846 | 57630.0 |
904 | 2023-02-24 08:10:27 | acorns | 3 | 112716 | 809 | 4.923 | 22895.8 |
903 | 2023-02-22 03:10:26 | acorns | 3 | 112716 | 809 | 4.783 | 23566.0 |
902 | 2023-02-09 13:29:17 | acorns | 3 | 112716 | 809 | 5.733 | 19660.9 |
901 | 2023-01-17 08:46:59 | acorns | 1 | 48755 | 5 | 0.810 | 60191.4 |
900 | 2023-01-05 08:55:30 | acorns | 3 | 112716 | 809 | 9.423 | 11961.8 |
899 | 2022-12-30 11:56:51 | acorns | 2 | 82551 | 56 | 2.140 | 38575.2 |
898 | 2022-12-21 00:53:53 | acorns | 1 | 48755 | 5 | 0.830 | 58741.0 |
897 | 2022-12-05 12:57:39 | acorns | 3 | 112716 | 809 | 4.703 | 23966.8 |
896 | 2022-09-14 01:36:24 | acorns | 1 | 48755 | 5 | 0.766 | 63648.8 |
895 | 2022-09-10 10:00:38 | acorns | 1 | 48755 | 5 | 1.110 | 43923.4 |
894 | 2022-08-29 23:22:56 | acorns | 2 | 82551 | 56 | 2.216 | 37252.3 |
893 | 2022-08-29 05:50:13 | acorns | 3 | 112716 | 809 | 5.203 | 21663.7 |
892 | 2022-08-28 01:16:21 | acorns | 1 | 48755 | 5 | 0.750 | 65006.7 |
891 | 2022-08-11 15:36:22 | acorns | 1 | 48755 | 5 | 0.763 | 63899.1 |
890 | 2022-08-06 11:37:19 | acorns | 1 | 48755 | 5 | 0.750 | 65006.7 |
889 | 2022-07-28 09:35:42 | acorns | 3 | 112716 | 809 | 5.466 | 20621.3 |
888 | 2022-07-14 06:55:30 | acorns | 3 | 112716 | 809 | 4.736 | 23799.8 |
887 | 2022-06-26 18:22:59 | acorns | 3 | 112716 | 809 | 5.313 | 21215.1 |
886 | 2022-06-20 10:24:30 | acorns | 3 | 112716 | 809 | 4.890 | 23050.3 |
885 | 2022-06-13 20:26:20 | acorns | 3 | 112716 | 809 | 4.753 | 23714.7 |
884 | 2022-05-25 15:48:58 | acorns | 1 | 48755 | 5 | 1.733 | 28133.3 |
883 | 2022-05-15 22:35:54 | acorns | 3 | 112716 | 809 | 5.423 | 20784.8 |
882 | 2022-04-14 14:33:28 | acorns | 3 | 112716 | 809 | 5.783 | 19490.9 |
881 | 2022-04-02 22:50:52 | acorns | 1 | 48755 | 5 | 0.783 | 62266.9 |
880 | 2022-02-17 14:24:42 | acorns | 1 | 48755 | 5 | 1.610 | 30282.6 |
879 | 2022-01-02 10:34:55 | acorns | 1 | 48755 | 5 | 0.766 | 63648.8 |
878 | 2021-11-16 05:20:15 | acorns | 1 | 48755 | 5 | 0.796 | 61250.0 |
877 | 2021-11-04 23:04:58 | acorns | 1 | 48755 | 5 | 0.860 | 56691.9 |
876 | 2021-10-12 22:39:48 | acorns | 1 | 48755 | 5 | 0.860 | 56691.9 |
875 | 2021-10-10 22:34:02 | acorns | 1 | 48755 | 5 | 0.763 | 63899.1 |
874 | 2021-09-27 17:07:37 | acorns | 1 | 48755 | 5 | 0.843 | 57835.1 |
873 | 2021-09-24 11:54:58 | acorns | 1 | 48755 | 5 | 0.783 | 62266.9 |
872 | 2021-09-20 08:43:45 | acorns | 1 | 48755 | 5 | 0.906 | 53813.5 |
871 | 2021-09-20 00:38:22 | acorns | 1 | 48755 | 5 | 0.766 | 63648.8 |
870 | 2021-09-19 23:15:31 | acorns | 3 | 112716 | 809 | 5.593 | 20153.0 |
869 | 2021-09-16 17:43:23 | acorns | 3 | 112716 | 809 | 5.343 | 21096.0 |
868 | 2021-09-13 12:50:20 | acorns | 1 | 48755 | 5 | 0.923 | 52822.3 |
867 | 2021-08-25 01:19:23 | acorns | 1 | 48755 | 5 | 0.766 | 63648.8 |
866 | 2021-08-22 20:13:46 | acorns | 1 | 48755 | 5 | 1.516 | 32160.3 |
865 | 2021-08-13 09:03:31 | acorns | 1 | 48755 | 5 | 0.780 | 62506.4 |
864 | 2021-08-04 17:58:43 | acorns | 3 | 112716 | 809 | 4.953 | 22757.1 |
863 | 2021-07-09 17:57:59 | acorns | 3 | 112716 | 809 | 4.890 | 23050.3 |
862 | 2021-06-23 23:21:42 | acorns | 2 | 82551 | 56 | 2.720 | 30349.6 |
861 | 2021-06-19 20:35:10 | acorns | 3 | 112716 | 809 | 5.423 | 20784.8 |
860 | 2021-05-29 10:42:57 | acorns | 2 | 82551 | 56 | 2.660 | 31034.2 |
859 | 2021-05-24 01:59:03 | acorns | 3 | 112716 | 809 | 5.423 | 20784.8 |