History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cane"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3097 | 2024-03-15 22:39:29 | cane | 2 | 29872 | 522 | 0.953 | 31345.2 |
3096 | 2024-03-09 06:04:43 | cane | 1 | 13983 | 34 | 0.296 | 47239.9 |
3095 | 2024-03-02 13:40:46 | cane | 1 | 13983 | 34 | 0.640 | 21848.4 |
3094 | 2024-03-02 05:28:17 | cane | 1 | 13983 | 34 | 0.283 | 49409.9 |
3093 | 2024-02-26 12:53:06 | cane | 1 | 13983 | 34 | 0.516 | 27098.8 |
3092 | 2024-02-22 13:08:14 | cane | 1 | 13983 | 34 | 0.860 | 16259.3 |
3091 | 2024-02-22 13:07:38 | cane | 1 | 13983 | 34 | 0.266 | 52567.7 |
3090 | 2024-01-31 00:20:43 | cane | 1 | 13983 | 34 | 0.266 | 52567.7 |
3089 | 2024-01-21 23:04:10 | cane | 1 | 13983 | 34 | 0.236 | 59250.0 |
3088 | 2023-12-28 00:33:47 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3087 | 2023-12-18 19:33:08 | cane | 2 | 29872 | 522 | 0.813 | 36742.9 |
3086 | 2023-12-18 04:54:09 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3085 | 2023-12-13 11:27:06 | cane | 2 | 29872 | 522 | 0.766 | 38997.4 |
3084 | 2023-12-11 18:25:00 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3083 | 2023-12-07 22:37:39 | cane | 1 | 13983 | 34 | 0.296 | 47239.9 |
3082 | 2023-12-07 22:37:38 | cane | 1 | 13983 | 34 | 0.266 | 52567.7 |
3081 | 2023-12-05 23:12:21 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3080 | 2023-12-02 13:16:29 | cane | 2 | 29872 | 522 | 0.856 | 34897.2 |
3079 | 2023-11-19 06:46:13 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3078 | 2023-11-19 05:49:37 | cane | 2 | 29872 | 522 | 0.763 | 39150.7 |
3077 | 2023-11-10 01:51:10 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3076 | 2023-11-09 01:19:42 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3075 | 2023-11-02 01:38:21 | cane | 2 | 29872 | 522 | 0.860 | 34734.9 |
3074 | 2023-11-01 10:52:24 | cane | 2 | 29872 | 522 | 0.970 | 30795.9 |
3073 | 2023-10-26 01:16:40 | cane | 1 | 13983 | 34 | 0.266 | 52567.7 |
3072 | 2023-10-25 07:31:52 | cane | 1 | 13983 | 34 | 0.236 | 59250.0 |
3071 | 2023-10-21 10:12:32 | cane | 1 | 13983 | 34 | 0.236 | 59250.0 |
3070 | 2023-10-20 00:11:55 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3069 | 2023-10-19 14:21:30 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3068 | 2023-10-17 08:16:27 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3067 | 2023-10-16 19:48:29 | cane | 2 | 29872 | 522 | 1.016 | 29401.6 |
3066 | 2023-10-16 08:18:32 | cane | 2 | 29872 | 522 | 0.766 | 38997.4 |
3065 | 2023-10-10 20:26:26 | cane | 1 | 13983 | 34 | 0.236 | 59250.0 |
3064 | 2023-10-03 16:20:23 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3063 | 2023-09-22 21:59:55 | cane | 2 | 29872 | 522 | 0.876 | 34100.5 |
3062 | 2023-09-21 03:21:00 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3061 | 2023-09-19 18:57:49 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3060 | 2023-09-17 09:47:42 | cane | 2 | 29872 | 522 | 0.860 | 34734.9 |
3059 | 2023-09-11 17:51:11 | cane | 1 | 13983 | 34 | 0.263 | 53167.3 |
3058 | 2023-09-10 17:25:02 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3057 | 2023-08-25 19:39:06 | cane | 1 | 13983 | 34 | 0.216 | 64736.1 |
3056 | 2023-08-23 23:29:50 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3055 | 2023-08-22 07:04:36 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3054 | 2023-08-22 00:04:06 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3053 | 2023-08-20 18:53:15 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3052 | 2023-08-19 20:25:16 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3051 | 2023-08-18 14:25:04 | cane | 1 | 13983 | 34 | 0.216 | 64736.1 |
3050 | 2023-08-16 18:06:07 | cane | 1 | 13983 | 34 | 0.203 | 68881.8 |
3049 | 2023-08-15 14:33:18 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3048 | 2023-08-14 03:15:13 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3047 | 2023-08-12 02:16:17 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3046 | 2023-08-10 00:06:50 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3045 | 2023-08-08 11:35:58 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3044 | 2023-08-08 11:30:41 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3043 | 2023-08-02 00:31:45 | cane | 1 | 13983 | 34 | 0.236 | 59250.0 |
3042 | 2023-07-31 21:30:11 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3041 | 2023-07-26 10:34:56 | cane | 2 | 29872 | 522 | 0.936 | 31914.5 |
3040 | 2023-07-26 10:04:16 | cane | 2 | 29872 | 522 | 0.766 | 38997.4 |
3039 | 2023-07-23 14:40:04 | cane | 2 | 29872 | 522 | 0.813 | 36742.9 |
3038 | 2023-07-08 22:53:00 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3037 | 2023-06-29 05:13:59 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3036 | 2023-06-11 03:22:03 | cane | 1 | 13983 | 34 | 0.250 | 55932.0 |
3035 | 2023-05-30 20:05:34 | cane | 2 | 29872 | 522 | 0.890 | 33564.0 |
3034 | 2023-04-29 03:52:08 | cane | 2 | 29872 | 522 | 0.750 | 39829.3 |
3033 | 2023-04-20 15:27:27 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
3032 | 2023-04-13 08:41:53 | cane | 2 | 29872 | 522 | 0.873 | 34217.6 |
3031 | 2023-04-12 08:38:55 | cane | 2 | 29872 | 522 | 0.953 | 31345.2 |
3030 | 2023-04-11 08:34:35 | cane | 2 | 29872 | 522 | 0.843 | 35435.3 |
3029 | 2023-04-10 08:31:33 | cane | 2 | 29872 | 522 | 0.860 | 34734.9 |
3028 | 2023-04-09 08:33:28 | cane | 2 | 29872 | 522 | 0.750 | 39829.3 |
3027 | 2023-04-08 08:39:57 | cane | 2 | 29872 | 522 | 0.873 | 34217.6 |
3026 | 2023-04-07 08:28:25 | cane | 2 | 29872 | 522 | 0.846 | 35309.7 |
3025 | 2023-04-06 09:54:10 | cane | 2 | 29872 | 522 | 0.800 | 37340.0 |
3024 | 2023-04-05 09:51:57 | cane | 2 | 29872 | 522 | 0.860 | 34734.9 |
3023 | 2023-04-04 09:15:11 | cane | 2 | 29872 | 522 | 0.783 | 38150.7 |
3022 | 2023-04-03 08:30:14 | cane | 2 | 29872 | 522 | 0.860 | 34734.9 |
3021 | 2023-04-02 08:23:39 | cane | 2 | 29872 | 522 | 0.843 | 35435.3 |
3020 | 2023-04-01 08:23:32 | cane | 2 | 29872 | 522 | 0.750 | 39829.3 |
3019 | 2023-03-31 08:20:49 | cane | 2 | 29872 | 522 | 0.860 | 34734.9 |
3018 | 2023-03-30 08:13:04 | cane | 2 | 29872 | 522 | 0.753 | 39670.7 |
3017 | 2023-03-29 08:17:21 | cane | 2 | 29872 | 522 | 0.750 | 39829.3 |
3016 | 2023-03-28 08:14:26 | cane | 2 | 29872 | 522 | 0.763 | 39150.7 |
3015 | 2023-03-24 16:29:31 | cane | 1 | 13983 | 34 | 0.216 | 64736.1 |
3014 | 2023-03-20 21:47:27 | cane | 2 | 29872 | 522 | 0.936 | 31914.5 |
3013 | 2023-03-20 09:16:26 | cane | 2 | 29872 | 522 | 0.876 | 34100.5 |
3012 | 2023-03-19 09:14:45 | cane | 2 | 29872 | 522 | 0.873 | 34217.6 |
3011 | 2023-03-18 08:04:24 | cane | 2 | 29872 | 522 | 0.876 | 34100.5 |
3010 | 2023-03-17 11:55:02 | cane | 2 | 29872 | 522 | 0.750 | 39829.3 |
3009 | 2023-03-17 08:07:09 | cane | 2 | 29872 | 522 | 0.830 | 35990.4 |
3008 | 2023-03-15 07:50:42 | cane | 2 | 29872 | 522 | 0.906 | 32971.3 |
3007 | 2023-03-15 06:38:28 | cane | 2 | 29872 | 522 | 0.890 | 33564.0 |
3006 | 2023-03-14 08:09:50 | cane | 2 | 29872 | 522 | 0.766 | 38997.4 |
3005 | 2023-03-13 08:03:48 | cane | 2 | 29872 | 522 | 0.780 | 38297.4 |
3004 | 2023-03-12 12:25:48 | cane | 1 | 13983 | 34 | 0.233 | 60012.9 |
3003 | 2023-03-11 09:25:09 | cane | 2 | 29872 | 522 | 0.766 | 38997.4 |
3002 | 2023-03-10 07:54:06 | cane | 2 | 29872 | 522 | 0.876 | 34100.5 |
3001 | 2023-03-09 09:03:27 | cane | 2 | 29872 | 522 | 0.876 | 34100.5 |
3000 | 2023-03-08 17:33:57 | cane | 1 | 13983 | 34 | 0.220 | 63559.1 |
2999 | 2023-03-08 08:29:38 | cane | 2 | 29872 | 522 | 0.750 | 39829.3 |
2998 | 2023-03-07 08:53:04 | cane | 2 | 29872 | 522 | 0.843 | 35435.3 |