History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mice"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3212 | 2024-04-17 08:37:13 | mice | 1 | 13983 | 26 | 0.390 | 35853.8 |
3211 | 2024-04-17 00:39:10 | mice | 1 | 13983 | 26 | 0.550 | 25423.6 |
3210 | 2024-04-16 21:12:45 | mice | 1 | 13983 | 26 | 0.346 | 40413.3 |
3209 | 2024-04-16 21:11:39 | mice | 1 | 13983 | 26 | 0.266 | 52567.7 |
3208 | 2024-04-13 14:06:42 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3207 | 2024-04-11 05:42:34 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3206 | 2024-04-05 01:06:56 | mice | 1 | 13983 | 26 | 0.236 | 59250.0 |
3205 | 2024-04-01 05:05:49 | mice | 1 | 13983 | 26 | 0.263 | 53167.3 |
3204 | 2024-03-19 20:51:27 | mice | 2 | 29872 | 335 | 0.906 | 32971.3 |
3203 | 2024-03-19 20:51:23 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3202 | 2024-03-18 20:49:06 | mice | 1 | 13983 | 26 | 0.280 | 49939.3 |
3201 | 2024-03-13 01:00:48 | mice | 1 | 13983 | 26 | 0.610 | 22923.0 |
3200 | 2024-03-08 10:46:54 | mice | 1 | 13983 | 26 | 0.873 | 16017.2 |
3199 | 2024-03-05 20:32:04 | mice | 1 | 13983 | 26 | 0.830 | 16847.0 |
3198 | 2024-03-05 16:54:49 | mice | 2 | 29872 | 335 | 1.923 | 15534.1 |
3197 | 2024-03-05 10:30:16 | mice | 2 | 29872 | 335 | 0.860 | 34734.9 |
3196 | 2024-03-05 08:48:44 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3195 | 2024-03-05 02:42:50 | mice | 1 | 13983 | 26 | 0.813 | 17199.3 |
3194 | 2024-03-02 18:10:57 | mice | 2 | 29872 | 335 | 2.046 | 14600.2 |
3193 | 2024-03-02 17:36:42 | mice | 1 | 13983 | 26 | 0.236 | 59250.0 |
3192 | 2024-03-02 00:30:52 | mice | 1 | 13983 | 26 | 0.280 | 49939.3 |
3191 | 2024-03-01 06:39:42 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3190 | 2024-02-25 17:15:38 | mice | 1 | 13983 | 26 | 0.263 | 53167.3 |
3189 | 2024-02-25 16:24:06 | mice | 2 | 29872 | 335 | 0.750 | 39829.3 |
3188 | 2024-02-25 15:48:12 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3187 | 2024-02-21 07:12:17 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3186 | 2024-02-18 13:49:42 | mice | 1 | 13983 | 26 | 0.216 | 64736.1 |
3185 | 2024-01-31 22:56:08 | mice | 2 | 29872 | 335 | 0.893 | 33451.3 |
3184 | 2024-01-31 19:55:20 | mice | 2 | 29872 | 335 | 0.813 | 36742.9 |
3183 | 2024-01-31 19:54:59 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3182 | 2024-01-26 13:11:38 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3181 | 2024-01-24 00:03:50 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3180 | 2024-01-22 10:36:00 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3179 | 2024-01-16 10:17:50 | mice | 1 | 13983 | 26 | 0.283 | 49409.9 |
3178 | 2024-01-14 04:13:28 | mice | 1 | 13983 | 26 | 0.263 | 53167.3 |
3177 | 2024-01-14 04:12:17 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3176 | 2024-01-07 17:19:57 | mice | 1 | 13983 | 26 | 0.216 | 64736.1 |
3175 | 2024-01-06 13:51:52 | mice | 2 | 29872 | 335 | 0.890 | 33564.0 |
3174 | 2024-01-01 17:40:37 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3173 | 2023-12-29 04:25:14 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3172 | 2023-12-16 04:35:41 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3171 | 2023-12-15 09:47:28 | mice | 1 | 13983 | 26 | 0.216 | 64736.1 |
3170 | 2023-12-14 21:09:45 | mice | 1 | 13983 | 26 | 0.440 | 31779.5 |
3169 | 2023-12-09 14:16:49 | mice | 1 | 13983 | 26 | 0.236 | 59250.0 |
3168 | 2023-12-09 12:56:37 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3167 | 2023-12-03 14:04:28 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3166 | 2023-12-03 14:04:27 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3165 | 2023-12-02 16:27:26 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3164 | 2023-11-24 07:25:35 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3163 | 2023-11-21 00:54:07 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3162 | 2023-11-21 00:38:05 | mice | 1 | 13983 | 26 | 0.436 | 32071.1 |
3161 | 2023-11-19 19:06:27 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3160 | 2023-11-16 20:51:47 | mice | 1 | 13983 | 26 | 0.263 | 53167.3 |
3159 | 2023-11-08 11:34:20 | mice | 2 | 29872 | 335 | 0.893 | 33451.3 |
3158 | 2023-11-08 08:10:50 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3157 | 2023-11-08 02:05:19 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3156 | 2023-11-07 23:14:26 | mice | 1 | 13983 | 26 | 0.216 | 64736.1 |
3155 | 2023-11-07 23:07:07 | mice | 2 | 29872 | 335 | 0.733 | 40753.1 |
3154 | 2023-11-07 21:45:39 | mice | 1 | 13983 | 26 | 0.216 | 64736.1 |
3153 | 2023-11-07 18:56:29 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3152 | 2023-11-07 11:02:08 | mice | 1 | 13983 | 26 | 0.970 | 14415.5 |
3151 | 2023-11-07 11:02:05 | mice | 1 | 13983 | 26 | 0.780 | 17926.9 |
3150 | 2023-11-07 07:38:11 | mice | 2 | 29872 | 335 | 0.846 | 35309.7 |
3149 | 2023-11-07 07:04:47 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3148 | 2023-11-07 04:45:14 | mice | 1 | 13983 | 26 | 0.206 | 67878.6 |
3147 | 2023-11-06 15:32:17 | mice | 2 | 29872 | 335 | 0.720 | 41488.9 |
3146 | 2023-11-06 12:45:01 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3145 | 2023-11-06 10:07:20 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3144 | 2023-11-05 17:21:01 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3143 | 2023-11-05 12:23:33 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3142 | 2023-11-04 02:08:11 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3141 | 2023-11-04 00:13:21 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3140 | 2023-11-02 11:15:03 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3139 | 2023-11-01 13:02:52 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3138 | 2023-10-31 19:38:10 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3137 | 2023-10-30 11:56:25 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3136 | 2023-10-29 23:22:31 | mice | 1 | 13983 | 26 | 0.343 | 40766.8 |
3135 | 2023-10-25 20:07:08 | mice | 2 | 29872 | 335 | 1.626 | 18371.5 |
3134 | 2023-10-25 19:09:14 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3133 | 2023-10-23 15:04:27 | mice | 1 | 13983 | 26 | 0.533 | 26234.5 |
3132 | 2023-10-19 14:12:20 | mice | 2 | 29872 | 335 | 0.856 | 34897.2 |
3131 | 2023-10-19 14:05:33 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3130 | 2023-10-16 18:11:45 | mice | 2 | 29872 | 335 | 0.860 | 34734.9 |
3129 | 2023-10-16 18:05:21 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3128 | 2023-10-13 09:39:38 | mice | 2 | 29872 | 335 | 0.720 | 41488.9 |
3127 | 2023-10-11 06:48:48 | mice | 2 | 29872 | 335 | 0.766 | 38997.4 |
3126 | 2023-10-10 09:55:58 | mice | 2 | 29872 | 335 | 0.830 | 35990.4 |
3125 | 2023-10-09 20:52:02 | mice | 1 | 13983 | 26 | 0.220 | 63559.1 |
3124 | 2023-10-03 08:49:41 | mice | 2 | 29872 | 335 | 0.830 | 35990.4 |
3123 | 2023-10-03 08:04:51 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3122 | 2023-09-25 13:52:33 | mice | 2 | 29872 | 335 | 0.903 | 33080.8 |
3121 | 2023-09-25 09:35:25 | mice | 1 | 13983 | 26 | 0.233 | 60012.9 |
3120 | 2023-09-24 21:15:16 | mice | 1 | 13983 | 26 | 0.250 | 55932.0 |
3119 | 2023-09-18 23:06:44 | mice | 2 | 29872 | 335 | 0.906 | 32971.3 |
3118 | 2023-09-18 19:13:07 | mice | 1 | 13983 | 26 | 0.500 | 27966.0 |
3117 | 2023-09-15 18:27:01 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3116 | 2023-09-15 09:59:06 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3115 | 2023-09-10 12:46:11 | mice | 2 | 29872 | 335 | 0.733 | 40753.1 |
3114 | 2023-09-10 11:06:54 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |
3113 | 2023-08-29 01:45:21 | mice | 1 | 13983 | 26 | 0.203 | 68881.8 |