History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sweets"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
964 | 2024-05-06 03:59:10 | sweets | 1 | 48755 | 9 | 2.783 | 17518.9 |
963 | 2024-05-02 01:13:48 | sweets | 2 | 82551 | 100 | 8.610 | 9587.8 |
962 | 2024-05-01 23:01:31 | sweets | 3 | 112716 | 975 | 11.716 | 9620.7 |
961 | 2024-05-01 07:46:44 | sweets | 3 | 112716 | 975 | 12.486 | 9027.4 |
960 | 2024-05-01 07:46:47 | sweets | 2 | 82551 | 100 | 6.080 | 13577.5 |
959 | 2024-05-01 07:46:40 | sweets | 1 | 48755 | 9 | 0.970 | 50262.9 |
958 | 2024-05-01 07:46:35 | sweets | 1 | 48755 | 9 | 0.936 | 52088.7 |
957 | 2024-05-01 07:46:31 | sweets | 2 | 82551 | 100 | 2.923 | 28241.9 |
956 | 2024-05-01 07:46:27 | sweets | 3 | 112716 | 975 | 6.033 | 18683.2 |
955 | 2024-04-21 02:29:33 | sweets | 1 | 48755 | 9 | 1.686 | 28917.6 |
954 | 2024-04-21 02:11:05 | sweets | 1 | 48755 | 9 | 0.876 | 55656.4 |
953 | 2024-04-21 02:10:30 | sweets | 1 | 48755 | 9 | 1.453 | 33554.7 |
952 | 2024-04-05 01:10:05 | sweets | 1 | 48755 | 9 | 0.763 | 63899.1 |
951 | 2024-04-03 05:46:29 | sweets | 1 | 48755 | 9 | 2.626 | 18566.3 |
950 | 2024-03-04 03:39:27 | sweets | 1 | 48755 | 9 | 0.766 | 63648.8 |
949 | 2024-03-01 16:19:56 | sweets | 2 | 82551 | 100 | 2.830 | 29170.0 |
948 | 2024-03-01 08:01:04 | sweets | 2 | 82551 | 100 | 2.563 | 32208.7 |
947 | 2024-03-01 08:00:52 | sweets | 3 | 112716 | 975 | 7.673 | 14690.0 |
946 | 2024-02-28 23:11:10 | sweets | 2 | 82551 | 100 | 2.626 | 31436.0 |
945 | 2024-02-28 18:10:02 | sweets | 3 | 112716 | 975 | 9.580 | 11765.8 |
944 | 2024-02-27 15:03:56 | sweets | 2 | 82551 | 100 | 2.623 | 31472.0 |
943 | 2024-02-27 15:03:33 | sweets | 3 | 112716 | 975 | 5.780 | 19501.0 |
942 | 2024-02-26 14:48:48 | sweets | 3 | 112716 | 975 | 6.156 | 18309.9 |
941 | 2024-02-09 20:48:25 | sweets | 2 | 82551 | 100 | 2.843 | 29036.6 |
940 | 2024-02-09 20:22:45 | sweets | 3 | 112716 | 975 | 6.466 | 17432.1 |
939 | 2024-02-06 15:18:18 | sweets | 2 | 82551 | 100 | 2.673 | 30883.3 |
938 | 2024-01-31 22:43:49 | sweets | 1 | 48755 | 9 | 0.936 | 52088.7 |
937 | 2024-01-29 17:23:22 | sweets | 3 | 112716 | 975 | 11.330 | 9948.5 |
936 | 2024-01-28 11:25:31 | sweets | 2 | 82551 | 100 | 2.080 | 39688.0 |
935 | 2024-01-28 11:24:55 | sweets | 3 | 112716 | 975 | 4.813 | 23419.1 |
934 | 2024-01-27 05:33:13 | sweets | 1 | 48755 | 9 | 0.936 | 52088.7 |
933 | 2024-01-26 17:14:50 | sweets | 3 | 112716 | 975 | 5.300 | 21267.2 |
932 | 2023-12-24 01:40:14 | sweets | 1 | 48755 | 9 | 0.750 | 65006.7 |
931 | 2023-12-20 20:47:46 | sweets | 1 | 48755 | 9 | 0.860 | 56691.9 |
930 | 2023-12-18 13:10:19 | sweets | 3 | 112716 | 975 | 5.346 | 21084.2 |
929 | 2023-12-12 10:06:22 | sweets | 2 | 82551 | 100 | 2.296 | 35954.3 |
928 | 2023-12-09 22:37:13 | sweets | 2 | 82551 | 100 | 2.593 | 31836.1 |
927 | 2023-12-07 13:41:59 | sweets | 2 | 82551 | 100 | 2.470 | 33421.5 |
926 | 2023-11-26 23:01:02 | sweets | 1 | 48755 | 9 | 0.750 | 65006.7 |
925 | 2023-11-19 17:42:48 | sweets | 1 | 48755 | 9 | 1.640 | 29728.7 |
924 | 2023-11-11 12:56:37 | sweets | 2 | 82551 | 100 | 2.470 | 33421.5 |
923 | 2023-11-11 04:10:19 | sweets | 3 | 112716 | 975 | 4.673 | 24120.7 |
922 | 2023-11-10 11:26:13 | sweets | 1 | 48755 | 9 | 1.656 | 29441.4 |
921 | 2023-11-09 11:34:03 | sweets | 3 | 112716 | 975 | 4.783 | 23566.0 |
920 | 2023-11-07 14:42:39 | sweets | 3 | 112716 | 975 | 4.623 | 24381.6 |
919 | 2023-11-07 01:32:20 | sweets | 3 | 112716 | 975 | 4.966 | 22697.5 |
918 | 2023-11-06 15:16:18 | sweets | 3 | 112716 | 975 | 5.533 | 20371.6 |
917 | 2023-11-06 08:15:59 | sweets | 3 | 112716 | 975 | 4.533 | 24865.7 |
916 | 2023-11-06 01:53:30 | sweets | 3 | 112716 | 975 | 5.000 | 22543.2 |
915 | 2023-11-05 15:21:48 | sweets | 3 | 112716 | 975 | 4.533 | 24865.7 |
914 | 2023-11-05 01:57:30 | sweets | 3 | 112716 | 975 | 4.610 | 24450.3 |
913 | 2023-11-04 15:00:30 | sweets | 3 | 112716 | 975 | 5.530 | 20382.6 |
912 | 2023-11-03 14:57:52 | sweets | 3 | 112716 | 975 | 5.140 | 21929.2 |
911 | 2023-11-02 14:56:26 | sweets | 3 | 112716 | 975 | 4.750 | 23729.7 |
910 | 2023-11-02 03:19:25 | sweets | 1 | 48755 | 9 | 0.920 | 52994.6 |
909 | 2023-11-01 12:45:21 | sweets | 3 | 112716 | 975 | 5.110 | 22057.9 |
908 | 2023-10-31 23:59:02 | sweets | 3 | 112716 | 975 | 7.826 | 14402.8 |
907 | 2023-10-31 12:37:49 | sweets | 3 | 112716 | 975 | 9.440 | 11940.3 |
906 | 2023-10-30 12:12:48 | sweets | 3 | 112716 | 975 | 5.233 | 21539.5 |
905 | 2023-10-29 12:44:45 | sweets | 3 | 112716 | 975 | 4.690 | 24033.3 |
904 | 2023-10-29 02:29:42 | sweets | 1 | 48755 | 9 | 1.096 | 44484.5 |
903 | 2023-10-28 14:51:27 | sweets | 1 | 48755 | 9 | 0.766 | 63648.8 |
902 | 2023-10-28 12:31:41 | sweets | 3 | 112716 | 975 | 5.390 | 20912.1 |
901 | 2023-10-27 12:56:18 | sweets | 3 | 112716 | 975 | 5.610 | 20092.0 |
900 | 2023-10-27 09:18:00 | sweets | 3 | 112716 | 975 | 5.423 | 20784.8 |
899 | 2023-10-26 12:42:25 | sweets | 3 | 112716 | 975 | 5.766 | 19548.4 |
898 | 2023-10-25 09:37:25 | sweets | 3 | 112716 | 975 | 4.720 | 23880.5 |
897 | 2023-10-24 09:49:40 | sweets | 3 | 112716 | 975 | 4.906 | 22975.1 |
896 | 2023-10-23 22:58:03 | sweets | 1 | 48755 | 9 | 0.750 | 65006.7 |
895 | 2023-10-23 10:22:20 | sweets | 3 | 112716 | 975 | 10.280 | 10964.6 |
894 | 2023-10-22 23:01:38 | sweets | 3 | 112716 | 975 | 5.296 | 21283.2 |
893 | 2023-10-22 10:17:19 | sweets | 3 | 112716 | 975 | 10.486 | 10749.2 |
892 | 2023-10-21 10:31:28 | sweets | 3 | 112716 | 975 | 5.313 | 21215.1 |
891 | 2023-10-20 19:48:03 | sweets | 3 | 112716 | 975 | 5.236 | 21527.1 |
890 | 2023-10-20 10:18:18 | sweets | 3 | 112716 | 975 | 7.530 | 14968.9 |
889 | 2023-10-19 17:59:58 | sweets | 3 | 112716 | 975 | 5.250 | 21469.7 |
888 | 2023-10-19 13:08:13 | sweets | 3 | 112716 | 975 | 5.813 | 19390.3 |
887 | 2023-10-19 00:45:48 | sweets | 3 | 112716 | 975 | 4.563 | 24702.2 |
886 | 2023-10-18 13:45:31 | sweets | 3 | 112716 | 975 | 5.346 | 21084.2 |
885 | 2023-10-17 23:49:27 | sweets | 3 | 112716 | 975 | 5.076 | 22205.7 |
884 | 2023-10-17 18:11:39 | sweets | 3 | 112716 | 975 | 4.843 | 23274.0 |
883 | 2023-10-17 13:32:31 | sweets | 3 | 112716 | 975 | 4.686 | 24053.8 |
882 | 2023-10-16 20:20:46 | sweets | 3 | 112716 | 975 | 4.576 | 24632.0 |
881 | 2023-10-16 10:05:33 | sweets | 3 | 112716 | 975 | 6.516 | 17298.3 |
880 | 2023-10-15 19:33:32 | sweets | 3 | 112716 | 975 | 4.656 | 24208.8 |
879 | 2023-10-15 12:30:20 | sweets | 1 | 48755 | 9 | 0.860 | 56691.9 |
878 | 2023-10-15 10:38:07 | sweets | 3 | 112716 | 975 | 5.626 | 20034.8 |
877 | 2023-10-14 19:23:42 | sweets | 3 | 112716 | 975 | 5.406 | 20850.2 |
876 | 2023-10-13 23:32:28 | sweets | 3 | 112716 | 975 | 4.860 | 23192.6 |
875 | 2023-10-13 12:38:48 | sweets | 3 | 112716 | 975 | 5.203 | 21663.7 |
874 | 2023-10-12 23:39:05 | sweets | 3 | 112716 | 975 | 4.610 | 24450.3 |
873 | 2023-10-11 23:42:40 | sweets | 3 | 112716 | 975 | 4.843 | 23274.0 |
872 | 2023-10-11 13:34:39 | sweets | 3 | 112716 | 975 | 5.376 | 20966.5 |
871 | 2023-10-11 00:53:20 | sweets | 3 | 112716 | 975 | 12.983 | 8681.8 |
870 | 2023-10-10 15:39:48 | sweets | 3 | 112716 | 975 | 4.580 | 24610.5 |
869 | 2023-10-10 00:44:24 | sweets | 3 | 112716 | 975 | 4.516 | 24959.3 |
868 | 2023-10-09 14:45:34 | sweets | 3 | 112716 | 975 | 5.186 | 21734.7 |
867 | 2023-10-09 00:53:37 | sweets | 3 | 112716 | 975 | 6.296 | 17902.8 |
866 | 2023-10-08 16:03:15 | sweets | 3 | 112716 | 975 | 4.750 | 23729.7 |
865 | 2023-10-08 06:31:20 | sweets | 3 | 112716 | 975 | 4.500 | 25048.0 |