History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ear"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 3033 | 2025-10-25 19:46:09 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 3032 | 2025-10-25 18:09:49 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 3031 | 2025-10-25 06:01:50 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3030 | 2025-10-25 04:35:42 | ear | 1 | 5146 | 36 | 0.186 | 27666.7 |
| 3029 | 2025-10-24 18:31:04 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3028 | 2025-10-24 14:43:47 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3027 | 2025-10-24 11:30:22 | ear | 1 | 5146 | 36 | 0.096 | 53604.2 |
| 3026 | 2025-10-24 06:18:21 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3025 | 2025-10-24 06:17:22 | ear | 1 | 5146 | 36 | 0.096 | 53604.2 |
| 3024 | 2025-10-23 04:33:57 | ear | 1 | 5146 | 36 | 0.470 | 10948.9 |
| 3023 | 2025-10-19 21:47:28 | ear | 2 | 14084 | 621 | 2.000 | 7042.0 |
| 3022 | 2025-10-19 21:47:14 | ear | 2 | 14084 | 621 | 3.826 | 3681.1 |
| 3021 | 2025-10-19 21:46:47 | ear | 2 | 14084 | 621 | 1.016 | 13862.2 |
| 3020 | 2025-10-19 21:46:18 | ear | 2 | 14084 | 621 | 3.363 | 4187.9 |
| 3019 | 2025-10-19 09:41:20 | ear | 1 | 5146 | 36 | 0.076 | 67710.5 |
| 3018 | 2025-10-18 03:46:41 | ear | 1 | 5146 | 36 | 0.080 | 64325.0 |
| 3017 | 2025-10-10 07:19:58 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 3016 | 2025-10-05 17:46:55 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3015 | 2025-10-01 19:29:22 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3014 | 2025-09-25 03:55:16 | ear | 1 | 5146 | 36 | 0.656 | 7844.5 |
| 3013 | 2025-09-24 21:52:30 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3012 | 2025-09-24 21:52:25 | ear | 1 | 5146 | 36 | 0.140 | 36757.1 |
| 3011 | 2025-09-24 21:52:18 | ear | 1 | 5146 | 36 | 0.673 | 7646.4 |
| 3010 | 2025-09-24 21:52:14 | ear | 1 | 5146 | 36 | 0.470 | 10948.9 |
| 3009 | 2025-09-24 17:58:10 | ear | 1 | 5146 | 36 | 0.076 | 67710.5 |
| 3008 | 2025-09-20 04:05:42 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3007 | 2025-09-17 00:02:45 | ear | 1 | 5146 | 36 | 0.076 | 67710.5 |
| 3006 | 2025-09-15 00:48:21 | ear | 1 | 5146 | 36 | 0.096 | 53604.2 |
| 3005 | 2025-09-13 12:56:07 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3004 | 2025-09-11 10:32:16 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 3003 | 2025-09-09 12:48:42 | ear | 1 | 5146 | 36 | 0.076 | 67710.5 |
| 3002 | 2025-09-07 20:37:59 | ear | 1 | 5146 | 36 | 0.080 | 64325.0 |
| 3001 | 2025-09-06 16:24:02 | ear | 1 | 5146 | 36 | 0.170 | 30270.6 |
| 3000 | 2025-09-05 17:36:33 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2999 | 2025-09-05 00:08:32 | ear | 2 | 14084 | 621 | 0.406 | 34689.7 |
| 2998 | 2025-09-04 00:22:33 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2997 | 2025-08-31 20:06:24 | ear | 1 | 5146 | 36 | 0.076 | 67710.5 |
| 2996 | 2025-08-31 19:46:16 | ear | 1 | 5146 | 36 | 0.076 | 67710.5 |
| 2995 | 2025-08-28 18:03:34 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2994 | 2025-08-28 07:57:18 | ear | 1 | 5146 | 36 | 0.173 | 29745.7 |
| 2993 | 2025-08-27 13:27:35 | ear | 1 | 5146 | 36 | 0.186 | 27666.7 |
| 2992 | 2025-08-26 04:17:47 | ear | 1 | 5146 | 36 | 0.343 | 15002.9 |
| 2991 | 2025-08-24 20:25:54 | ear | 1 | 5146 | 36 | 0.326 | 15785.3 |
| 2990 | 2025-08-24 06:10:04 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2989 | 2025-08-22 15:42:25 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2988 | 2025-08-11 10:33:29 | ear | 1 | 5146 | 36 | 0.593 | 8677.9 |
| 2987 | 2025-08-09 08:15:52 | ear | 1 | 5146 | 36 | 0.436 | 11802.8 |
| 2986 | 2025-08-07 07:56:16 | ear | 2 | 14084 | 621 | 1.440 | 9780.6 |
| 2985 | 2025-08-05 16:39:55 | ear | 2 | 14084 | 621 | 1.953 | 7211.5 |
| 2984 | 2025-08-03 19:53:16 | ear | 2 | 14084 | 621 | 2.936 | 4797.0 |
| 2983 | 2025-08-02 08:04:51 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2982 | 2025-08-01 13:13:14 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2981 | 2025-07-28 05:56:23 | ear | 2 | 14084 | 621 | 0.876 | 16077.6 |
| 2980 | 2025-07-28 05:56:21 | ear | 2 | 14084 | 621 | 1.280 | 11003.1 |
| 2979 | 2025-07-28 05:24:05 | ear | 2 | 14084 | 621 | 0.813 | 17323.5 |
| 2978 | 2025-07-27 07:22:55 | ear | 2 | 14084 | 621 | 2.970 | 4742.1 |
| 2977 | 2025-07-26 10:34:47 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2976 | 2025-07-26 09:04:22 | ear | 2 | 14084 | 621 | 1.920 | 7335.4 |
| 2975 | 2025-07-24 13:54:46 | ear | 2 | 14084 | 621 | 1.920 | 7335.4 |
| 2974 | 2025-07-24 07:06:41 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2973 | 2025-07-23 23:15:52 | ear | 1 | 5146 | 36 | 0.716 | 7187.2 |
| 2972 | 2025-07-22 11:09:50 | ear | 1 | 5146 | 36 | 0.513 | 10031.2 |
| 2971 | 2025-07-21 11:20:46 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2970 | 2025-07-18 13:29:47 | ear | 1 | 5146 | 36 | 0.716 | 7187.2 |
| 2969 | 2025-07-11 01:54:04 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2968 | 2025-07-07 07:22:02 | ear | 1 | 5146 | 36 | 0.546 | 9424.9 |
| 2967 | 2025-07-03 06:58:38 | ear | 1 | 5146 | 36 | 0.576 | 8934.0 |
| 2966 | 2025-06-29 06:31:57 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2965 | 2025-06-28 12:41:20 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2964 | 2025-06-23 13:58:47 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2963 | 2025-06-23 07:46:59 | ear | 1 | 5146 | 36 | 0.090 | 57177.8 |
| 2962 | 2025-06-20 11:38:51 | ear | 1 | 5146 | 36 | 0.190 | 27084.2 |
| 2961 | 2025-06-20 06:41:06 | ear | 1 | 5146 | 36 | 0.610 | 8436.1 |
| 2960 | 2025-06-18 11:02:29 | ear | 1 | 5146 | 36 | 0.700 | 7351.4 |
| 2959 | 2025-06-17 21:08:44 | ear | 1 | 5146 | 36 | 0.496 | 10375.0 |
| 2958 | 2025-06-16 06:07:25 | ear | 1 | 5146 | 36 | 0.203 | 25349.8 |
| 2957 | 2025-06-15 23:23:12 | ear | 1 | 5146 | 36 | 0.673 | 7646.4 |
| 2956 | 2025-06-12 06:28:20 | ear | 1 | 5146 | 36 | 0.626 | 8220.4 |
| 2955 | 2025-06-11 23:59:10 | ear | 1 | 5146 | 36 | 0.406 | 12674.9 |
| 2954 | 2025-06-11 10:23:38 | ear | 1 | 5146 | 36 | 0.766 | 6718.0 |
| 2953 | 2025-06-06 07:17:39 | ear | 1 | 5146 | 36 | 0.563 | 9140.3 |
| 2952 | 2025-05-31 14:55:47 | ear | 2 | 14084 | 621 | 0.876 | 16077.6 |
| 2951 | 2025-05-30 22:05:29 | ear | 1 | 5146 | 36 | 0.500 | 10292.0 |
| 2950 | 2025-05-30 08:08:27 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2949 | 2025-05-29 00:05:50 | ear | 2 | 14084 | 621 | 1.983 | 7102.4 |
| 2948 | 2025-05-28 08:19:03 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2947 | 2025-05-28 07:30:01 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2946 | 2025-05-28 01:12:41 | ear | 2 | 14084 | 621 | 0.440 | 32009.1 |
| 2945 | 2025-05-27 22:55:41 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2944 | 2025-05-27 21:16:21 | ear | 2 | 14084 | 621 | 0.406 | 34689.7 |
| 2943 | 2025-05-26 10:08:03 | ear | 2 | 14084 | 621 | 0.983 | 14327.6 |
| 2942 | 2025-05-25 18:47:29 | ear | 1 | 5146 | 36 | 0.186 | 27666.7 |
| 2941 | 2025-05-25 01:47:48 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2940 | 2025-05-24 09:22:53 | ear | 1 | 5146 | 36 | 0.110 | 46781.8 |
| 2939 | 2025-05-21 07:06:49 | ear | 1 | 5146 | 36 | 0.593 | 8677.9 |
| 2938 | 2025-05-15 20:50:29 | ear | 1 | 5146 | 36 | 0.220 | 23390.9 |
| 2937 | 2025-05-15 06:24:30 | ear | 1 | 5146 | 36 | 0.096 | 53604.2 |
| 2936 | 2025-05-15 00:02:20 | ear | 1 | 5146 | 36 | 0.216 | 23824.1 |
| 2935 | 2025-05-13 01:18:47 | ear | 1 | 5146 | 36 | 0.093 | 55333.3 |
| 2934 | 2025-05-12 04:14:01 | ear | 1 | 5146 | 36 | 0.673 | 7646.4 |