History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smith"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
990 | 2025-07-18 09:20:44 | smith | 1 | 28756 | 8 | 1.186 | 24246.2 |
989 | 2025-07-16 22:01:55 | smith | 3 | 83667 | 947 | 9.470 | 8835.0 |
988 | 2025-07-16 07:38:07 | smith | 3 | 83667 | 947 | 4.220 | 19826.3 |
987 | 2025-07-13 22:34:11 | smith | 1 | 28756 | 8 | 4.156 | 6919.2 |
986 | 2025-07-11 16:56:31 | smith | 3 | 83667 | 947 | 19.720 | 4242.7 |
985 | 2025-07-10 14:07:27 | smith | 1 | 28756 | 8 | 2.563 | 11219.7 |
984 | 2025-07-10 00:48:48 | smith | 1 | 28756 | 8 | 1.186 | 24246.2 |
983 | 2025-07-08 21:59:19 | smith | 1 | 28756 | 8 | 0.563 | 51076.4 |
982 | 2025-07-07 15:27:41 | smith | 3 | 83667 | 947 | 21.063 | 3972.2 |
981 | 2025-07-07 04:11:38 | smith | 3 | 83667 | 947 | 20.640 | 4053.6 |
980 | 2025-07-07 02:55:57 | smith | 3 | 83667 | 947 | 10.330 | 8099.4 |
979 | 2025-07-06 05:01:28 | smith | 3 | 83667 | 947 | 3.826 | 21868.0 |
978 | 2025-07-05 00:11:22 | smith | 3 | 83667 | 947 | 29.093 | 2875.8 |
977 | 2025-07-02 16:42:20 | smith | 1 | 28756 | 8 | 2.560 | 11232.8 |
976 | 2025-07-02 13:53:05 | smith | 2 | 53800 | 83 | 5.533 | 9723.5 |
975 | 2025-07-02 06:51:16 | smith | 2 | 53800 | 83 | 8.110 | 6633.8 |
974 | 2025-07-02 03:25:46 | smith | 2 | 53800 | 83 | 7.296 | 7373.9 |
973 | 2025-07-01 09:06:50 | smith | 1 | 28756 | 8 | 0.530 | 54256.6 |
972 | 2025-06-30 02:20:42 | smith | 2 | 53800 | 83 | 8.500 | 6329.4 |
971 | 2025-06-29 07:10:58 | smith | 1 | 28756 | 8 | 1.453 | 19790.8 |
970 | 2025-06-27 11:42:35 | smith | 3 | 83667 | 947 | 20.016 | 4180.0 |
969 | 2025-06-13 22:48:58 | smith | 2 | 53800 | 83 | 11.923 | 4512.3 |
968 | 2025-06-11 05:25:17 | smith | 2 | 53800 | 83 | 4.263 | 12620.2 |
967 | 2025-06-09 23:24:07 | smith | 1 | 28756 | 8 | 3.750 | 7668.3 |
966 | 2025-06-07 21:06:39 | smith | 3 | 83667 | 947 | 20.763 | 4029.6 |
965 | 2025-06-05 21:29:27 | smith | 1 | 28756 | 8 | 1.396 | 20598.9 |
964 | 2025-06-04 14:50:35 | smith | 3 | 83667 | 947 | 13.796 | 6064.6 |
963 | 2025-06-04 11:12:02 | smith | 3 | 83667 | 947 | 25.656 | 3261.1 |
962 | 2025-06-04 01:46:43 | smith | 3 | 83667 | 947 | 15.830 | 5285.3 |
961 | 2025-06-02 14:15:26 | smith | 3 | 83667 | 947 | 19.893 | 4205.9 |
960 | 2025-06-01 08:01:26 | smith | 1 | 28756 | 8 | 1.623 | 17717.8 |
959 | 2025-05-31 19:06:59 | smith | 1 | 28756 | 8 | 1.563 | 18398.0 |
958 | 2025-05-31 14:59:38 | smith | 1 | 28756 | 8 | 2.703 | 10638.5 |
957 | 2025-05-29 09:01:48 | smith | 1 | 28756 | 8 | 3.610 | 7965.7 |
956 | 2025-05-29 01:06:08 | smith | 2 | 53800 | 83 | 6.826 | 7881.6 |
955 | 2025-05-28 07:30:08 | smith | 1 | 28756 | 8 | 1.126 | 25538.2 |
954 | 2025-05-17 14:45:54 | smith | 1 | 28756 | 8 | 2.623 | 10963.0 |
953 | 2025-05-16 13:35:00 | smith | 1 | 28756 | 8 | 3.766 | 7635.7 |
952 | 2025-05-16 12:18:37 | smith | 1 | 28756 | 8 | 3.436 | 8369.0 |
951 | 2025-05-09 00:15:33 | smith | 1 | 28756 | 8 | 0.483 | 59536.2 |
950 | 2025-05-06 08:09:16 | smith | 1 | 28756 | 8 | 2.313 | 12432.3 |
949 | 2025-05-04 11:16:23 | smith | 3 | 83667 | 947 | 19.550 | 4279.6 |
948 | 2025-05-04 01:04:18 | smith | 3 | 83667 | 947 | 20.580 | 4065.5 |
947 | 2025-05-02 14:18:28 | smith | 3 | 83667 | 947 | 20.173 | 4147.5 |
946 | 2025-05-02 05:53:46 | smith | 2 | 53800 | 83 | 8.436 | 6377.4 |
945 | 2025-05-01 08:17:03 | smith | 1 | 28756 | 8 | 1.093 | 26309.2 |
944 | 2025-04-30 15:16:32 | smith | 1 | 28756 | 8 | 1.390 | 20687.8 |
943 | 2025-04-28 07:10:05 | smith | 1 | 28756 | 8 | 1.016 | 28303.1 |
942 | 2025-04-14 13:40:42 | smith | 1 | 28756 | 8 | 0.970 | 29645.4 |
941 | 2025-04-06 07:38:56 | smith | 1 | 28756 | 8 | 2.483 | 11581.2 |
940 | 2025-04-02 13:58:34 | smith | 3 | 83667 | 947 | 22.050 | 3794.4 |
939 | 2025-04-02 10:43:52 | smith | 3 | 83667 | 947 | 19.816 | 4222.2 |
938 | 2025-03-31 05:45:08 | smith | 3 | 83667 | 947 | 17.736 | 4717.4 |
937 | 2025-03-29 17:13:56 | smith | 1 | 28756 | 8 | 2.500 | 11502.4 |
936 | 2025-03-29 09:57:47 | smith | 1 | 28756 | 8 | 3.863 | 7444.0 |
935 | 2025-03-27 14:38:52 | smith | 1 | 28756 | 8 | 1.173 | 24514.9 |
934 | 2025-03-27 08:42:18 | smith | 1 | 28756 | 8 | 2.483 | 11581.2 |
933 | 2025-03-24 21:33:21 | smith | 1 | 28756 | 8 | 0.736 | 39070.7 |
932 | 2025-03-14 22:56:33 | smith | 1 | 28756 | 8 | 2.046 | 14054.7 |
931 | 2025-03-07 03:03:29 | smith | 2 | 53800 | 83 | 8.076 | 6661.7 |
930 | 2025-03-07 02:16:12 | smith | 3 | 83667 | 947 | 17.876 | 4680.4 |
929 | 2025-03-07 02:16:05 | smith | 2 | 53800 | 83 | 10.063 | 5346.3 |
928 | 2025-03-07 02:15:43 | smith | 1 | 28756 | 8 | 0.966 | 29768.1 |
927 | 2025-02-27 09:35:10 | smith | 3 | 83667 | 947 | 18.546 | 4511.3 |
926 | 2025-02-26 17:22:11 | smith | 3 | 83667 | 947 | 23.610 | 3543.7 |
925 | 2025-02-26 17:22:08 | smith | 2 | 53800 | 83 | 3.953 | 13609.9 |
924 | 2025-02-26 11:15:40 | smith | 3 | 83667 | 947 | 22.626 | 3697.8 |
923 | 2025-02-26 11:15:39 | smith | 2 | 53800 | 83 | 6.563 | 8197.5 |
922 | 2025-02-26 11:13:09 | smith | 1 | 28756 | 8 | 3.406 | 8442.7 |
921 | 2025-02-26 00:48:50 | smith | 1 | 28756 | 8 | 3.343 | 8601.9 |
920 | 2025-02-24 23:05:56 | smith | 1 | 28756 | 8 | 1.890 | 15214.8 |
919 | 2025-02-17 16:12:14 | smith | 3 | 83667 | 947 | 26.220 | 3191.0 |
918 | 2025-02-16 17:07:32 | smith | 1 | 28756 | 8 | 0.970 | 29645.4 |
917 | 2025-02-13 06:23:39 | smith | 1 | 28756 | 8 | 1.016 | 28303.1 |
916 | 2025-02-05 02:39:48 | smith | 2 | 53800 | 83 | 7.780 | 6915.2 |
915 | 2025-02-05 00:38:27 | smith | 2 | 53800 | 83 | 12.173 | 4419.6 |
914 | 2025-02-05 00:38:26 | smith | 3 | 83667 | 947 | 9.566 | 8746.3 |
913 | 2025-02-05 00:38:22 | smith | 1 | 28756 | 8 | 0.750 | 38341.3 |
912 | 2025-01-27 16:36:57 | smith | 2 | 53800 | 83 | 4.030 | 13349.9 |
911 | 2025-01-27 14:32:08 | smith | 3 | 83667 | 947 | 19.500 | 4290.6 |
910 | 2025-01-27 13:42:40 | smith | 3 | 83667 | 947 | 25.376 | 3297.1 |
909 | 2025-01-27 11:19:17 | smith | 3 | 83667 | 947 | 9.690 | 8634.4 |
908 | 2025-01-27 11:19:19 | smith | 2 | 53800 | 83 | 6.123 | 8786.5 |
907 | 2025-01-27 10:29:04 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
906 | 2025-01-25 00:33:44 | smith | 1 | 28756 | 8 | 1.330 | 21621.1 |
905 | 2025-01-05 14:34:18 | smith | 2 | 53800 | 83 | 8.516 | 6317.5 |
904 | 2025-01-05 14:22:40 | smith | 3 | 83667 | 947 | 3.673 | 22778.9 |
903 | 2025-01-05 14:22:41 | smith | 2 | 53800 | 83 | 1.576 | 34137.1 |
902 | 2025-01-05 14:22:38 | smith | 1 | 28756 | 8 | 0.486 | 59168.7 |
901 | 2024-12-28 02:25:42 | smith | 2 | 53800 | 83 | 8.830 | 6092.9 |
900 | 2024-12-28 02:24:22 | smith | 1 | 28756 | 8 | 2.343 | 12273.2 |
899 | 2024-12-27 13:22:33 | smith | 3 | 83667 | 947 | 11.313 | 7395.7 |
898 | 2024-12-26 19:52:27 | smith | 3 | 83667 | 947 | 17.140 | 4881.4 |
897 | 2024-12-26 19:50:46 | smith | 2 | 53800 | 83 | 3.173 | 16955.6 |
896 | 2024-12-26 19:50:44 | smith | 1 | 28756 | 8 | 1.123 | 25606.4 |
895 | 2024-12-24 22:49:57 | smith | 1 | 28756 | 8 | 1.050 | 27386.7 |
894 | 2024-12-11 01:49:51 | smith | 3 | 83667 | 947 | 29.216 | 2863.7 |
893 | 2024-12-11 00:05:25 | smith | 3 | 83667 | 947 | 19.140 | 4371.3 |
892 | 2024-12-10 18:33:00 | smith | 3 | 83667 | 947 | 19.500 | 4290.6 |
891 | 2024-12-10 17:25:34 | smith | 3 | 83667 | 947 | 15.076 | 5549.7 |