History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thuja"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
312 | 2024-04-19 22:39:00 | thuja | 1 | 28756 | 3 | 0.580 | 49579.3 |
311 | 2024-04-07 16:21:11 | thuja | 3 | 83667 | 375 | 4.453 | 18788.9 |
310 | 2024-04-07 16:21:09 | thuja | 2 | 53800 | 23 | 3.486 | 15433.2 |
309 | 2024-04-07 16:21:06 | thuja | 1 | 28756 | 3 | 1.220 | 23570.5 |
308 | 2024-04-04 19:59:40 | thuja | 3 | 83667 | 375 | 8.516 | 9824.7 |
307 | 2024-04-04 07:15:03 | thuja | 2 | 53800 | 23 | 5.296 | 10158.6 |
306 | 2024-04-04 07:15:01 | thuja | 3 | 83667 | 375 | 6.063 | 13799.6 |
305 | 2024-04-04 07:14:49 | thuja | 1 | 28756 | 3 | 1.110 | 25906.3 |
304 | 2024-04-04 07:14:33 | thuja | 2 | 53800 | 23 | 5.156 | 10434.4 |
303 | 2024-04-04 07:14:27 | thuja | 3 | 83667 | 375 | 8.906 | 9394.5 |
302 | 2024-04-04 07:14:16 | thuja | 1 | 28756 | 3 | 0.563 | 51076.4 |
301 | 2024-03-29 09:11:06 | thuja | 1 | 28756 | 3 | 1.126 | 25538.2 |
300 | 2024-03-29 02:03:28 | thuja | 1 | 28756 | 3 | 0.843 | 34111.5 |
299 | 2024-03-07 09:25:07 | thuja | 2 | 53800 | 23 | 7.203 | 7469.1 |
298 | 2024-03-07 09:25:06 | thuja | 3 | 83667 | 375 | 4.453 | 18788.9 |
297 | 2024-03-07 05:49:32 | thuja | 1 | 28756 | 3 | 0.500 | 57512.0 |
296 | 2024-03-04 01:58:55 | thuja | 1 | 28756 | 3 | 0.440 | 65354.5 |
295 | 2024-03-01 12:18:01 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
294 | 2024-02-28 07:44:13 | thuja | 1 | 28756 | 3 | 0.983 | 29253.3 |
293 | 2024-02-03 22:46:07 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
292 | 2024-01-29 08:43:47 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
291 | 2024-01-29 04:04:17 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
290 | 2024-01-15 23:25:44 | thuja | 2 | 53800 | 23 | 3.250 | 16553.8 |
289 | 2024-01-15 23:25:43 | thuja | 3 | 83667 | 375 | 4.096 | 20426.5 |
288 | 2023-12-30 18:51:27 | thuja | 2 | 53800 | 23 | 1.516 | 35488.1 |
287 | 2023-12-10 20:18:24 | thuja | 1 | 28756 | 3 | 0.550 | 52283.6 |
286 | 2023-12-04 09:39:08 | thuja | 3 | 83667 | 375 | 3.110 | 26902.6 |
285 | 2023-12-04 09:39:02 | thuja | 2 | 53800 | 23 | 1.516 | 35488.1 |
284 | 2023-11-19 19:54:01 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
283 | 2023-11-16 11:56:40 | thuja | 1 | 28756 | 3 | 0.530 | 54256.6 |
282 | 2023-11-05 15:06:33 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
281 | 2023-10-30 07:47:02 | thuja | 3 | 83667 | 375 | 3.736 | 22394.8 |
280 | 2023-10-30 07:47:00 | thuja | 2 | 53800 | 23 | 1.563 | 34421.0 |
279 | 2023-10-28 00:32:10 | thuja | 1 | 28756 | 3 | 0.983 | 29253.3 |
278 | 2023-10-20 19:21:38 | thuja | 1 | 28756 | 3 | 0.420 | 68466.7 |
277 | 2023-10-16 09:35:05 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
276 | 2023-10-04 11:51:38 | thuja | 1 | 28756 | 3 | 0.453 | 63479.0 |
275 | 2023-10-02 17:12:11 | thuja | 2 | 53800 | 23 | 1.310 | 41068.7 |
274 | 2023-09-26 02:11:12 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
273 | 2023-09-24 18:32:49 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
272 | 2023-07-23 16:12:02 | thuja | 3 | 83667 | 375 | 3.393 | 24658.7 |
271 | 2023-07-23 16:12:00 | thuja | 2 | 53800 | 23 | 1.343 | 40059.6 |
270 | 2023-07-23 15:46:35 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
269 | 2023-07-22 06:38:55 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
268 | 2023-07-15 00:38:44 | thuja | 2 | 53800 | 23 | 1.343 | 40059.6 |
267 | 2023-04-20 08:35:48 | thuja | 1 | 28756 | 3 | 0.470 | 61183.0 |
266 | 2023-03-30 09:56:48 | thuja | 2 | 53800 | 23 | 1.330 | 40451.1 |
265 | 2023-02-07 07:19:20 | thuja | 1 | 28756 | 3 | 0.420 | 68466.7 |
264 | 2022-12-26 05:25:03 | thuja | 2 | 53800 | 23 | 1.533 | 35094.6 |
263 | 2022-08-27 05:48:31 | thuja | 2 | 53800 | 23 | 1.483 | 36277.8 |
262 | 2022-07-28 14:05:57 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
261 | 2022-03-12 11:58:21 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
260 | 2022-03-10 07:27:27 | thuja | 1 | 28756 | 3 | 0.453 | 63479.0 |
259 | 2021-12-18 18:07:33 | thuja | 1 | 28756 | 3 | 0.500 | 57512.0 |
258 | 2021-10-25 16:34:24 | thuja | 1 | 28756 | 3 | 0.530 | 54256.6 |
257 | 2021-09-13 19:05:17 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
256 | 2021-09-11 15:29:14 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
255 | 2021-08-22 20:05:08 | thuja | 1 | 28756 | 3 | 0.420 | 68466.7 |
254 | 2021-05-28 07:13:33 | thuja | 1 | 28756 | 3 | 0.470 | 61183.0 |
253 | 2021-05-02 11:53:02 | thuja | 1 | 28756 | 3 | 0.500 | 57512.0 |
252 | 2021-03-31 19:08:58 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
251 | 2021-01-15 09:57:33 | thuja | 1 | 28756 | 3 | 0.453 | 63479.0 |
250 | 2020-12-16 16:29:05 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
249 | 2020-11-15 12:01:33 | thuja | 1 | 28756 | 3 | 0.470 | 61183.0 |
248 | 2020-11-01 13:49:19 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
247 | 2020-09-16 14:21:11 | thuja | 1 | 28756 | 3 | 0.436 | 65954.1 |
246 | 2020-09-04 06:38:04 | thuja | 1 | 28756 | 3 | 0.500 | 57512.0 |
245 | 2020-08-30 01:41:02 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
244 | 2020-08-29 06:37:42 | thuja | 1 | 28756 | 3 | 0.470 | 61183.0 |
243 | 2020-08-26 11:22:03 | thuja | 1 | 28756 | 3 | 0.593 | 48492.4 |
242 | 2020-04-02 07:36:20 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
241 | 2020-03-29 22:49:38 | thuja | 1 | 28756 | 3 | 1.093 | 26309.2 |
240 | 2020-03-28 15:15:32 | thuja | 1 | 28756 | 3 | 0.500 | 57512.0 |
239 | 2020-03-26 23:07:13 | thuja | 1 | 28756 | 3 | 0.500 | 57512.0 |
238 | 2020-03-23 07:00:12 | thuja | 1 | 28756 | 3 | 0.550 | 52283.6 |
237 | 2020-03-22 00:28:45 | thuja | 1 | 28756 | 3 | 0.546 | 52666.7 |
236 | 2020-03-21 07:01:26 | thuja | 1 | 28756 | 3 | 0.483 | 59536.2 |
235 | 2020-03-18 03:07:05 | thuja | 1 | 28756 | 3 | 0.486 | 59168.7 |
234 | 2020-02-29 01:51:49 | thuja | 1 | 28756 | 3 | 0.513 | 56054.6 |
233 | 2020-02-26 04:53:25 | thuja | 1 | 28756 | 3 | 1.060 | 27128.3 |
232 | 2020-02-15 04:27:04 | thuja | 1 | 28756 | 3 | 0.533 | 53951.2 |
231 | 2020-02-11 23:50:05 | thuja | 3 | 83667 | 375 | 13.203 | 6337.0 |
230 | 2020-02-10 16:51:17 | thuja | 3 | 83667 | 375 | 5.956 | 14047.5 |
229 | 2020-02-10 02:22:05 | thuja | 3 | 83667 | 375 | 9.686 | 8637.9 |
228 | 2020-02-09 22:29:34 | thuja | 1 | 28756 | 3 | 0.420 | 68466.7 |
227 | 2020-02-09 21:10:46 | thuja | 3 | 83667 | 375 | 3.920 | 21343.6 |
226 | 2020-02-09 16:29:34 | thuja | 3 | 83667 | 375 | 13.313 | 6284.6 |
225 | 2020-02-06 09:32:35 | thuja | 1 | 28756 | 3 | 1.080 | 26625.9 |
224 | 2020-02-05 11:07:02 | thuja | 1 | 28756 | 3 | 0.546 | 52666.7 |
223 | 2020-02-03 10:23:00 | thuja | 1 | 28756 | 3 | 0.860 | 33437.2 |
222 | 2020-01-27 00:38:27 | thuja | 1 | 28756 | 3 | 0.623 | 46157.3 |
221 | 2020-01-21 20:57:10 | thuja | 1 | 28756 | 3 | 1.576 | 18246.2 |
220 | 2020-01-15 17:59:40 | thuja | 1 | 28756 | 3 | 1.173 | 24514.9 |
219 | 2020-01-15 00:50:20 | thuja | 1 | 28756 | 3 | 0.530 | 54256.6 |
218 | 2020-01-12 20:52:59 | thuja | 3 | 83667 | 375 | 4.860 | 17215.4 |
217 | 2020-01-12 18:41:24 | thuja | 3 | 83667 | 375 | 3.393 | 24658.7 |
216 | 2020-01-12 12:21:54 | thuja | 2 | 53800 | 23 | 1.670 | 32215.6 |
215 | 2020-01-12 12:21:47 | thuja | 3 | 83667 | 375 | 3.970 | 21074.8 |
214 | 2020-01-12 08:23:13 | thuja | 1 | 28756 | 3 | 1.640 | 17534.1 |
213 | 2020-01-04 18:34:39 | thuja | 1 | 28756 | 3 | 0.516 | 55728.7 |