History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doughty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
278 | 2024-05-03 23:51:53 | doughty | 1 | 69583 | 4 | 1.280 | 54361.7 |
277 | 2024-04-30 21:43:25 | doughty | 1 | 69583 | 4 | 1.610 | 43219.3 |
276 | 2024-04-30 21:42:34 | doughty | 1 | 69583 | 4 | 1.606 | 43326.9 |
275 | 2024-04-12 17:59:04 | doughty | 1 | 69583 | 4 | 2.500 | 27833.2 |
274 | 2024-03-29 22:33:09 | doughty | 1 | 69583 | 4 | 3.623 | 19205.9 |
273 | 2024-03-28 22:20:58 | doughty | 1 | 69583 | 4 | 1.423 | 48898.8 |
272 | 2023-12-29 23:10:07 | doughty | 1 | 69583 | 4 | 1.106 | 62914.1 |
271 | 2023-12-28 10:37:15 | doughty | 1 | 69583 | 4 | 1.033 | 67360.1 |
270 | 2023-12-15 09:10:51 | doughty | 1 | 69583 | 4 | 1.080 | 64428.7 |
269 | 2023-12-03 14:00:26 | doughty | 1 | 69583 | 4 | 1.263 | 55093.4 |
268 | 2023-12-03 14:00:24 | doughty | 1 | 69583 | 4 | 1.216 | 57222.9 |
267 | 2023-11-20 16:42:24 | doughty | 1 | 69583 | 4 | 2.533 | 27470.6 |
266 | 2023-11-08 16:56:50 | doughty | 1 | 69583 | 4 | 1.063 | 65459.1 |
265 | 2023-10-22 22:28:10 | doughty | 1 | 69583 | 4 | 2.390 | 29114.2 |
264 | 2023-10-19 21:46:58 | doughty | 1 | 69583 | 4 | 2.140 | 32515.4 |
263 | 2023-10-18 08:47:51 | doughty | 1 | 69583 | 4 | 1.826 | 38106.8 |
262 | 2023-10-11 14:34:12 | doughty | 1 | 69583 | 4 | 1.186 | 58670.3 |
261 | 2023-10-04 09:14:48 | doughty | 1 | 69583 | 4 | 2.516 | 27656.2 |
260 | 2023-09-24 23:19:14 | doughty | 1 | 69583 | 4 | 1.796 | 38743.3 |
259 | 2023-09-20 16:24:13 | doughty | 1 | 69583 | 4 | 1.123 | 61961.7 |
258 | 2023-08-26 03:50:38 | doughty | 1 | 69583 | 4 | 2.343 | 29698.3 |
257 | 2023-08-14 21:25:00 | doughty | 1 | 69583 | 4 | 1.093 | 63662.4 |
256 | 2023-05-13 04:41:44 | doughty | 1 | 69583 | 4 | 1.063 | 65459.1 |
255 | 2023-05-05 08:03:53 | doughty | 1 | 69583 | 4 | 1.236 | 56296.9 |
254 | 2023-03-10 01:04:36 | doughty | 1 | 69583 | 4 | 1.063 | 65459.1 |
253 | 2023-01-11 20:13:26 | doughty | 1 | 69583 | 4 | 1.030 | 67556.3 |
252 | 2022-12-30 09:46:46 | doughty | 1 | 69583 | 4 | 1.063 | 65459.1 |
251 | 2022-09-19 11:11:05 | doughty | 1 | 69583 | 4 | 1.046 | 66522.9 |
250 | 2022-09-06 09:42:07 | doughty | 1 | 69583 | 4 | 1.063 | 65459.1 |
249 | 2022-04-27 23:19:07 | doughty | 1 | 69583 | 4 | 1.076 | 64668.2 |
248 | 2022-04-23 07:30:44 | doughty | 1 | 69583 | 4 | 1.093 | 63662.4 |
247 | 2022-01-19 05:24:35 | doughty | 1 | 69583 | 4 | 1.186 | 58670.3 |
246 | 2022-01-17 01:29:23 | doughty | 1 | 69583 | 4 | 1.156 | 60192.9 |
245 | 2022-01-03 20:07:13 | doughty | 1 | 69583 | 4 | 1.263 | 55093.4 |
244 | 2021-11-10 19:09:43 | doughty | 1 | 69583 | 4 | 1.220 | 57035.2 |
243 | 2021-11-08 18:51:00 | doughty | 1 | 69583 | 4 | 1.216 | 57222.9 |
242 | 2021-09-30 12:19:31 | doughty | 1 | 69583 | 4 | 1.173 | 59320.5 |
241 | 2021-09-28 08:54:32 | doughty | 1 | 69583 | 4 | 1.093 | 63662.4 |
240 | 2021-09-18 03:36:00 | doughty | 1 | 69583 | 4 | 1.250 | 55666.4 |
239 | 2021-08-20 07:14:39 | doughty | 1 | 69583 | 4 | 1.153 | 60349.5 |
238 | 2021-08-18 03:11:07 | doughty | 1 | 69583 | 4 | 1.140 | 61037.7 |
237 | 2021-06-18 07:15:51 | doughty | 1 | 69583 | 4 | 1.153 | 60349.5 |
236 | 2021-06-02 21:17:07 | doughty | 3 | 134027 | 117 | 7.080 | 18930.4 |
235 | 2021-05-08 12:46:28 | doughty | 3 | 134027 | 117 | 5.750 | 23309.0 |
234 | 2021-04-09 06:43:17 | doughty | 3 | 134027 | 117 | 7.186 | 18651.1 |
233 | 2021-04-06 23:27:04 | doughty | 3 | 134027 | 117 | 10.186 | 13158.0 |
232 | 2021-03-21 14:10:32 | doughty | 3 | 134027 | 117 | 5.780 | 23188.1 |
231 | 2021-03-20 14:44:56 | doughty | 3 | 134027 | 117 | 7.796 | 17191.8 |
230 | 2021-03-19 02:20:11 | doughty | 1 | 69583 | 4 | 1.170 | 59472.6 |
229 | 2021-02-17 12:19:36 | doughty | 2 | 107671 | 25 | 3.206 | 33584.2 |
228 | 2021-02-16 18:57:59 | doughty | 3 | 134027 | 117 | 6.846 | 19577.4 |
227 | 2021-01-22 04:01:18 | doughty | 3 | 134027 | 117 | 6.533 | 20515.4 |
226 | 2020-12-16 05:08:04 | doughty | 1 | 69583 | 4 | 1.080 | 64428.7 |
225 | 2020-11-07 00:57:15 | doughty | 1 | 69583 | 4 | 1.310 | 53116.8 |
224 | 2020-11-04 04:23:29 | doughty | 3 | 134027 | 117 | 6.593 | 20328.7 |
223 | 2020-10-17 03:01:07 | doughty | 1 | 69583 | 4 | 1.186 | 58670.3 |
222 | 2020-10-12 19:07:58 | doughty | 2 | 107671 | 25 | 3.046 | 35348.3 |
221 | 2020-10-07 11:18:15 | doughty | 3 | 134027 | 117 | 5.766 | 23244.4 |
220 | 2020-09-15 18:56:30 | doughty | 1 | 69583 | 4 | 1.093 | 63662.4 |
219 | 2020-09-14 23:17:18 | doughty | 2 | 107671 | 25 | 2.876 | 37437.8 |
218 | 2020-08-28 02:14:10 | doughty | 3 | 134027 | 117 | 5.970 | 22450.1 |
217 | 2020-08-22 03:47:39 | doughty | 3 | 134027 | 117 | 6.500 | 20619.5 |
216 | 2020-08-19 19:21:02 | doughty | 1 | 69583 | 4 | 1.140 | 61037.7 |
215 | 2020-07-30 06:32:38 | doughty | 2 | 107671 | 25 | 3.186 | 33795.0 |
214 | 2020-07-19 19:45:06 | doughty | 2 | 107671 | 25 | 3.046 | 35348.3 |
213 | 2020-05-28 08:19:17 | doughty | 1 | 69583 | 4 | 1.033 | 67360.1 |
212 | 2020-05-22 01:42:03 | doughty | 1 | 69583 | 4 | 1.063 | 65459.1 |
211 | 2020-03-28 22:34:44 | doughty | 1 | 69583 | 4 | 1.170 | 59472.6 |
210 | 2020-03-28 19:58:13 | doughty | 1 | 69583 | 4 | 1.143 | 60877.5 |
209 | 2020-03-21 14:49:02 | doughty | 1 | 69583 | 4 | 1.190 | 58473.1 |
208 | 2020-03-05 02:15:42 | doughty | 1 | 69583 | 4 | 1.313 | 52995.4 |
207 | 2020-02-25 16:36:20 | doughty | 1 | 69583 | 4 | 1.313 | 52995.4 |
206 | 2020-02-23 23:51:23 | doughty | 1 | 69583 | 4 | 1.263 | 55093.4 |
205 | 2020-02-19 08:20:33 | doughty | 1 | 69583 | 4 | 1.390 | 50059.7 |
204 | 2020-02-17 19:36:51 | doughty | 1 | 69583 | 4 | 4.533 | 15350.3 |
203 | 2020-02-16 06:26:24 | doughty | 1 | 69583 | 4 | 1.156 | 60192.9 |
202 | 2020-02-04 11:44:20 | doughty | 1 | 69583 | 4 | 2.110 | 32977.7 |
201 | 2020-02-04 05:42:59 | doughty | 1 | 69583 | 4 | 1.186 | 58670.3 |
200 | 2020-01-27 04:09:47 | doughty | 1 | 69583 | 4 | 2.766 | 25156.5 |
199 | 2020-01-23 21:12:49 | doughty | 1 | 69583 | 4 | 3.016 | 23071.3 |
198 | 2020-01-22 23:53:24 | doughty | 1 | 69583 | 4 | 1.983 | 35089.8 |
197 | 2020-01-17 01:40:49 | doughty | 1 | 69583 | 4 | 1.220 | 57035.2 |
196 | 2020-01-10 06:30:52 | doughty | 1 | 69583 | 4 | 1.220 | 57035.2 |
195 | 2020-01-10 05:42:09 | doughty | 1 | 69583 | 4 | 2.653 | 26228.0 |
194 | 2020-01-02 02:44:57 | doughty | 1 | 69583 | 4 | 2.626 | 26497.7 |
193 | 2019-12-31 04:41:04 | doughty | 1 | 69583 | 4 | 2.546 | 27330.3 |
192 | 2019-12-29 20:19:25 | doughty | 1 | 69583 | 4 | 1.203 | 57841.2 |
191 | 2019-12-15 12:44:14 | doughty | 1 | 69583 | 4 | 1.110 | 62687.4 |
190 | 2019-11-16 12:30:13 | doughty | 1 | 69583 | 4 | 1.250 | 55666.4 |
189 | 2019-10-30 13:56:05 | doughty | 1 | 69583 | 4 | 1.280 | 54361.7 |
188 | 2019-08-15 01:28:47 | doughty | 1 | 69583 | 4 | 1.230 | 56571.5 |
187 | 2019-08-03 12:51:33 | doughty | 1 | 69583 | 4 | 1.036 | 67165.1 |
186 | 2019-07-09 03:46:33 | doughty | 2 | 107671 | 25 | 2.783 | 38688.8 |
185 | 2019-05-05 19:28:18 | doughty | 1 | 69583 | 4 | 1.066 | 65274.9 |
184 | 2019-04-06 21:56:38 | doughty | 3 | 134027 | 117 | 5.766 | 23244.4 |
183 | 2019-03-11 14:55:42 | doughty | 3 | 134027 | 117 | 5.823 | 23016.8 |
182 | 2019-03-03 09:29:45 | doughty | 3 | 134027 | 117 | 5.756 | 23284.7 |
181 | 2019-02-17 16:15:44 | doughty | 3 | 134027 | 117 | 6.103 | 21960.8 |
180 | 2019-01-30 09:39:22 | doughty | 3 | 134027 | 117 | 6.456 | 20760.1 |
179 | 2019-01-25 05:26:04 | doughty | 3 | 134027 | 117 | 6.440 | 20811.6 |