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 |
| 1017 | 2025-10-17 03:13:02 | smith | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 1016 | 2025-09-30 18:16:01 | smith | 2 | 53800 | 83 | 1.593 | 33772.8 |
| 1015 | 2025-09-25 02:03:25 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1014 | 2025-09-12 07:00:49 | smith | 3 | 83667 | 947 | 3.986 | 20990.2 |
| 1013 | 2025-09-11 09:28:10 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1012 | 2025-09-09 18:06:34 | smith | 3 | 83667 | 947 | 3.516 | 23796.1 |
| 1011 | 2025-09-09 18:04:55 | smith | 2 | 53800 | 83 | 1.500 | 35866.7 |
| 1010 | 2025-09-08 20:49:01 | smith | 3 | 83667 | 947 | 3.673 | 22778.9 |
| 1009 | 2025-09-08 20:48:55 | smith | 2 | 53800 | 83 | 1.516 | 35488.1 |
| 1008 | 2025-09-01 00:33:27 | smith | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 1007 | 2025-08-30 14:19:57 | smith | 1 | 28756 | 8 | 1.000 | 28756.0 |
| 1006 | 2025-08-20 07:50:01 | smith | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 1005 | 2025-08-11 19:08:03 | smith | 1 | 28756 | 8 | 0.970 | 29645.4 |
| 1004 | 2025-08-10 01:11:54 | smith | 1 | 28756 | 8 | 1.483 | 19390.4 |
| 1003 | 2025-08-05 17:39:59 | smith | 2 | 53800 | 83 | 5.593 | 9619.2 |
| 1002 | 2025-08-05 14:39:28 | smith | 2 | 53800 | 83 | 4.673 | 11512.9 |
| 1001 | 2025-08-03 09:25:41 | smith | 2 | 53800 | 83 | 3.830 | 14047.0 |
| 1000 | 2025-08-01 02:34:53 | smith | 2 | 53800 | 83 | 4.420 | 12171.9 |
| 999 | 2025-07-31 15:11:32 | smith | 1 | 28756 | 8 | 1.390 | 20687.8 |
| 998 | 2025-07-31 08:17:32 | smith | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 997 | 2025-07-31 01:00:33 | smith | 3 | 83667 | 947 | 3.483 | 24021.5 |
| 996 | 2025-07-30 02:35:47 | smith | 3 | 83667 | 947 | 15.393 | 5435.4 |
| 995 | 2025-07-28 03:38:10 | smith | 2 | 53800 | 83 | 2.936 | 18324.3 |
| 994 | 2025-07-24 09:27:59 | smith | 2 | 53800 | 83 | 5.140 | 10466.9 |
| 993 | 2025-07-22 03:22:55 | smith | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 992 | 2025-07-21 02:45:57 | smith | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 991 | 2025-07-21 02:45:56 | smith | 1 | 28756 | 8 | 0.513 | 56054.6 |
| 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 |