History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zappy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
973 | 2024-04-23 12:15:22 | zappy | 1 | 28756 | 7 | 0.783 | 36725.4 |
972 | 2024-04-21 07:19:12 | zappy | 3 | 83667 | 611 | 15.360 | 5447.1 |
971 | 2024-04-16 07:37:03 | zappy | 3 | 83667 | 611 | 3.970 | 21074.8 |
970 | 2024-04-11 03:55:29 | zappy | 1 | 28756 | 7 | 1.076 | 26724.9 |
969 | 2024-04-03 08:15:53 | zappy | 1 | 28756 | 7 | 0.440 | 65354.5 |
968 | 2024-03-31 03:22:47 | zappy | 1 | 28756 | 7 | 1.610 | 17860.9 |
967 | 2024-03-29 01:46:55 | zappy | 3 | 83667 | 611 | 10.110 | 8275.7 |
966 | 2024-03-28 23:42:52 | zappy | 3 | 83667 | 611 | 11.203 | 7468.3 |
965 | 2024-03-28 23:42:55 | zappy | 2 | 53800 | 44 | 4.516 | 11913.2 |
964 | 2024-03-28 23:24:50 | zappy | 1 | 28756 | 7 | 1.110 | 25906.3 |
963 | 2024-03-28 06:19:58 | zappy | 1 | 28756 | 7 | 0.470 | 61183.0 |
962 | 2024-03-03 21:16:04 | zappy | 1 | 28756 | 7 | 0.516 | 55728.7 |
961 | 2024-03-01 10:43:18 | zappy | 1 | 28756 | 7 | 0.513 | 56054.6 |
960 | 2024-03-01 00:04:44 | zappy | 1 | 28756 | 7 | 0.500 | 57512.0 |
959 | 2024-02-27 20:07:53 | zappy | 1 | 28756 | 7 | 0.513 | 56054.6 |
958 | 2024-02-27 15:09:37 | zappy | 2 | 53800 | 44 | 1.593 | 33772.8 |
957 | 2024-02-27 04:49:34 | zappy | 3 | 83667 | 611 | 11.393 | 7343.7 |
956 | 2024-02-26 22:57:22 | zappy | 2 | 53800 | 44 | 2.376 | 22643.1 |
955 | 2024-02-26 22:56:52 | zappy | 3 | 83667 | 611 | 4.126 | 20278.0 |
954 | 2024-02-26 18:55:48 | zappy | 3 | 83667 | 611 | 4.173 | 20049.6 |
953 | 2024-01-28 20:35:59 | zappy | 1 | 28756 | 7 | 0.453 | 63479.0 |
952 | 2024-01-04 15:12:21 | zappy | 3 | 83667 | 611 | 3.656 | 22884.8 |
951 | 2023-12-27 00:13:22 | zappy | 2 | 53800 | 44 | 1.346 | 39970.3 |
950 | 2023-12-25 20:55:08 | zappy | 1 | 28756 | 7 | 0.483 | 59536.2 |
949 | 2023-12-24 04:23:34 | zappy | 2 | 53800 | 44 | 1.610 | 33416.1 |
948 | 2023-12-23 00:25:12 | zappy | 3 | 83667 | 611 | 3.326 | 25155.4 |
947 | 2023-12-21 13:41:58 | zappy | 3 | 83667 | 611 | 3.686 | 22698.6 |
946 | 2023-12-17 04:58:39 | zappy | 3 | 83667 | 611 | 3.296 | 25384.4 |
945 | 2023-12-15 06:08:12 | zappy | 3 | 83667 | 611 | 3.906 | 21420.1 |
944 | 2023-11-21 09:41:06 | zappy | 3 | 83667 | 611 | 3.830 | 21845.2 |
943 | 2023-11-20 06:24:44 | zappy | 1 | 28756 | 7 | 0.423 | 67981.1 |
942 | 2023-11-12 08:33:03 | zappy | 1 | 28756 | 7 | 0.466 | 61708.2 |
941 | 2023-11-11 23:44:40 | zappy | 3 | 83667 | 611 | 4.546 | 18404.5 |
940 | 2023-11-03 06:19:17 | zappy | 1 | 28756 | 7 | 0.440 | 65354.5 |
939 | 2023-10-23 14:17:16 | zappy | 1 | 28756 | 7 | 1.140 | 25224.6 |
938 | 2023-10-23 02:39:24 | zappy | 1 | 28756 | 7 | 0.500 | 57512.0 |
937 | 2023-10-19 21:59:42 | zappy | 1 | 28756 | 7 | 0.420 | 68466.7 |
936 | 2023-10-14 01:52:11 | zappy | 2 | 53800 | 44 | 1.580 | 34050.6 |
935 | 2023-10-14 01:19:28 | zappy | 1 | 28756 | 7 | 0.486 | 59168.7 |
934 | 2023-10-12 16:07:58 | zappy | 1 | 28756 | 7 | 0.440 | 65354.5 |
933 | 2023-10-10 17:11:55 | zappy | 3 | 83667 | 611 | 3.940 | 21235.3 |
932 | 2023-10-08 23:44:22 | zappy | 3 | 83667 | 611 | 3.750 | 22311.2 |
931 | 2023-10-06 02:12:29 | zappy | 1 | 28756 | 7 | 0.470 | 61183.0 |
930 | 2023-10-05 02:39:30 | zappy | 1 | 28756 | 7 | 0.513 | 56054.6 |
929 | 2023-09-30 01:56:10 | zappy | 3 | 83667 | 611 | 7.486 | 11176.5 |
928 | 2023-09-30 00:57:28 | zappy | 2 | 53800 | 44 | 1.470 | 36598.6 |
927 | 2023-09-29 08:35:35 | zappy | 1 | 28756 | 7 | 1.080 | 26625.9 |
926 | 2023-09-23 22:31:33 | zappy | 3 | 83667 | 611 | 3.623 | 23093.3 |
925 | 2023-09-11 07:43:21 | zappy | 3 | 83667 | 611 | 11.906 | 7027.3 |
924 | 2023-09-06 08:01:57 | zappy | 3 | 83667 | 611 | 3.190 | 26227.9 |
923 | 2023-08-25 03:33:15 | zappy | 3 | 83667 | 611 | 3.250 | 25743.7 |
922 | 2023-08-23 20:56:17 | zappy | 3 | 83667 | 611 | 3.593 | 23286.1 |
921 | 2023-08-08 23:39:56 | zappy | 1 | 28756 | 7 | 0.483 | 59536.2 |
920 | 2023-07-19 04:55:57 | zappy | 3 | 83667 | 611 | 3.233 | 25879.1 |
919 | 2023-07-10 16:51:15 | zappy | 2 | 53800 | 44 | 1.343 | 40059.6 |
918 | 2023-07-04 04:18:50 | zappy | 3 | 83667 | 611 | 3.283 | 25484.9 |
917 | 2023-06-28 17:02:32 | zappy | 3 | 83667 | 611 | 3.236 | 25855.1 |
916 | 2023-05-30 12:07:40 | zappy | 1 | 28756 | 7 | 0.436 | 65954.1 |
915 | 2023-05-09 00:18:26 | zappy | 1 | 28756 | 7 | 0.423 | 67981.1 |
914 | 2023-03-31 13:48:43 | zappy | 3 | 83667 | 611 | 6.330 | 13217.5 |
913 | 2023-03-27 08:35:38 | zappy | 2 | 53800 | 44 | 1.313 | 40974.9 |
912 | 2023-03-25 04:50:21 | zappy | 3 | 83667 | 611 | 3.563 | 23482.2 |
911 | 2023-03-03 17:20:55 | zappy | 1 | 28756 | 7 | 0.420 | 68466.7 |
910 | 2023-01-24 05:12:55 | zappy | 1 | 28756 | 7 | 0.466 | 61708.2 |
909 | 2023-01-10 14:22:02 | zappy | 3 | 83667 | 611 | 3.110 | 26902.6 |
908 | 2022-12-27 13:51:52 | zappy | 1 | 28756 | 7 | 0.420 | 68466.7 |
907 | 2022-12-24 01:37:45 | zappy | 2 | 53800 | 44 | 2.796 | 19241.8 |
906 | 2022-12-23 16:38:53 | zappy | 3 | 83667 | 611 | 3.140 | 26645.5 |
905 | 2022-11-26 03:23:01 | zappy | 3 | 83667 | 611 | 3.906 | 21420.1 |
904 | 2022-11-18 19:01:50 | zappy | 3 | 83667 | 611 | 3.216 | 26015.9 |
903 | 2022-11-16 21:49:23 | zappy | 3 | 83667 | 611 | 3.750 | 22311.2 |
902 | 2022-11-11 03:56:09 | zappy | 3 | 83667 | 611 | 3.220 | 25983.5 |
901 | 2022-11-09 10:14:33 | zappy | 3 | 83667 | 611 | 4.156 | 20131.6 |
900 | 2022-11-08 15:41:04 | zappy | 3 | 83667 | 611 | 3.610 | 23176.5 |
899 | 2022-11-07 19:44:06 | zappy | 3 | 83667 | 611 | 3.906 | 21420.1 |
898 | 2022-11-06 13:52:06 | zappy | 3 | 83667 | 611 | 3.626 | 23074.2 |
897 | 2022-11-04 23:46:57 | zappy | 3 | 83667 | 611 | 3.986 | 20990.2 |
896 | 2022-11-04 06:37:21 | zappy | 3 | 83667 | 611 | 3.580 | 23370.7 |
895 | 2022-11-02 13:38:38 | zappy | 3 | 83667 | 611 | 4.220 | 19826.3 |
894 | 2022-11-01 15:26:01 | zappy | 3 | 83667 | 611 | 3.580 | 23370.7 |
893 | 2022-10-31 11:35:23 | zappy | 3 | 83667 | 611 | 4.206 | 19892.3 |
892 | 2022-10-22 11:39:23 | zappy | 3 | 83667 | 611 | 3.343 | 25027.5 |
891 | 2022-10-16 11:38:37 | zappy | 3 | 83667 | 611 | 3.156 | 26510.5 |
890 | 2022-10-09 19:11:56 | zappy | 3 | 83667 | 611 | 3.156 | 26510.5 |
889 | 2022-09-13 19:28:44 | zappy | 1 | 28756 | 7 | 0.486 | 59168.7 |
888 | 2022-09-10 21:58:09 | zappy | 3 | 83667 | 611 | 3.890 | 21508.2 |
887 | 2022-09-07 12:32:10 | zappy | 1 | 28756 | 7 | 0.470 | 61183.0 |
886 | 2022-08-26 08:21:46 | zappy | 2 | 53800 | 44 | 1.330 | 40451.1 |
885 | 2022-08-22 15:53:16 | zappy | 3 | 83667 | 611 | 3.313 | 25254.2 |
884 | 2022-06-25 13:34:14 | zappy | 1 | 28756 | 7 | 0.453 | 63479.0 |
883 | 2022-05-19 01:26:21 | zappy | 3 | 83667 | 611 | 3.686 | 22698.6 |
882 | 2022-05-18 08:43:33 | zappy | 3 | 83667 | 611 | 3.390 | 24680.5 |
881 | 2022-05-17 19:01:51 | zappy | 3 | 83667 | 611 | 3.860 | 21675.4 |
880 | 2022-05-17 08:34:30 | zappy | 3 | 83667 | 611 | 4.263 | 19626.3 |
879 | 2022-05-16 12:42:15 | zappy | 3 | 83667 | 611 | 4.656 | 17969.7 |
878 | 2022-05-15 09:38:30 | zappy | 3 | 83667 | 611 | 3.156 | 26510.5 |
877 | 2022-05-14 10:43:28 | zappy | 3 | 83667 | 611 | 3.470 | 24111.5 |
876 | 2022-05-13 22:31:40 | zappy | 3 | 83667 | 611 | 3.763 | 22234.1 |
875 | 2022-05-13 12:19:29 | zappy | 3 | 83667 | 611 | 4.360 | 19189.7 |
874 | 2022-05-13 03:03:20 | zappy | 3 | 83667 | 611 | 3.390 | 24680.5 |