History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collated"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
387 | 2024-04-08 10:38:13 | collated | 3 | 146162 | 349 | 33.830 | 4320.5 |
386 | 2024-04-07 05:06:00 | collated | 2 | 121059 | 38 | 14.313 | 8458.0 |
385 | 2024-04-07 05:05:14 | collated | 3 | 146162 | 349 | 38.783 | 3768.7 |
384 | 2024-04-06 07:33:46 | collated | 2 | 121059 | 38 | 4.936 | 24525.7 |
383 | 2024-04-06 02:04:05 | collated | 3 | 146162 | 349 | 27.486 | 5317.7 |
382 | 2024-04-05 19:43:30 | collated | 2 | 121059 | 38 | 10.203 | 11865.0 |
381 | 2024-04-05 19:39:57 | collated | 3 | 146162 | 349 | 17.656 | 8278.3 |
380 | 2024-04-05 13:19:59 | collated | 2 | 121059 | 38 | 10.643 | 11374.5 |
379 | 2024-04-05 13:19:58 | collated | 3 | 146162 | 349 | 9.923 | 14729.6 |
378 | 2024-04-05 13:19:37 | collated | 3 | 146162 | 349 | 17.080 | 8557.5 |
377 | 2024-04-05 13:19:49 | collated | 1 | 82945 | 6 | 3.030 | 27374.6 |
376 | 2024-04-05 13:19:36 | collated | 2 | 121059 | 38 | 9.266 | 13064.9 |
375 | 2024-04-05 13:19:32 | collated | 1 | 82945 | 6 | 3.140 | 26415.6 |
374 | 2024-03-29 19:39:27 | collated | 1 | 82945 | 6 | 3.406 | 24352.6 |
373 | 2024-02-28 12:14:51 | collated | 1 | 82945 | 6 | 1.546 | 53651.4 |
372 | 2024-02-23 04:59:00 | collated | 2 | 121059 | 38 | 3.233 | 37444.8 |
371 | 2024-02-18 03:34:18 | collated | 1 | 82945 | 6 | 1.296 | 64000.8 |
370 | 2024-02-14 22:20:53 | collated | 2 | 121059 | 38 | 3.846 | 31476.6 |
369 | 2024-02-14 19:43:27 | collated | 3 | 146162 | 349 | 8.516 | 17163.2 |
368 | 2024-02-08 07:35:06 | collated | 3 | 146162 | 349 | 18.016 | 8112.9 |
367 | 2024-02-07 13:35:22 | collated | 3 | 146162 | 349 | 13.266 | 11017.8 |
366 | 2024-02-07 13:35:14 | collated | 2 | 121059 | 38 | 4.263 | 28397.6 |
365 | 2024-02-07 00:15:33 | collated | 2 | 121059 | 38 | 3.563 | 33976.7 |
364 | 2024-02-05 22:56:33 | collated | 2 | 121059 | 38 | 4.203 | 28803.0 |
363 | 2024-02-05 22:56:05 | collated | 3 | 146162 | 349 | 7.936 | 18417.6 |
362 | 2024-02-05 02:52:22 | collated | 3 | 146162 | 349 | 10.500 | 13920.2 |
361 | 2024-02-05 02:51:46 | collated | 3 | 146162 | 349 | 7.563 | 19325.9 |
360 | 2024-02-05 01:52:26 | collated | 3 | 146162 | 349 | 8.703 | 16794.4 |
359 | 2024-01-14 21:21:11 | collated | 1 | 82945 | 6 | 1.500 | 55296.7 |
358 | 2024-01-09 08:04:53 | collated | 2 | 121059 | 38 | 3.686 | 32842.9 |
357 | 2024-01-02 19:53:04 | collated | 3 | 146162 | 349 | 7.296 | 20033.2 |
356 | 2024-01-02 13:35:44 | collated | 3 | 146162 | 349 | 8.423 | 17352.7 |
355 | 2023-12-10 21:12:57 | collated | 1 | 82945 | 6 | 1.516 | 54713.1 |
354 | 2023-12-05 23:55:03 | collated | 3 | 146162 | 349 | 7.736 | 18893.7 |
353 | 2023-12-05 23:55:00 | collated | 2 | 121059 | 38 | 8.033 | 15070.2 |
352 | 2023-11-23 18:19:55 | collated | 1 | 82945 | 6 | 1.390 | 59672.7 |
351 | 2023-11-14 23:46:02 | collated | 2 | 121059 | 38 | 4.030 | 30039.5 |
350 | 2023-11-12 14:30:22 | collated | 3 | 146162 | 349 | 9.563 | 15284.1 |
349 | 2023-11-12 08:04:43 | collated | 3 | 146162 | 349 | 6.343 | 23043.0 |
348 | 2023-11-11 05:09:44 | collated | 1 | 82945 | 6 | 1.750 | 47397.1 |
347 | 2023-11-07 17:56:25 | collated | 1 | 82945 | 6 | 1.296 | 64000.8 |
346 | 2023-11-01 19:57:33 | collated | 1 | 82945 | 6 | 1.390 | 59672.7 |
345 | 2023-11-01 05:35:05 | collated | 3 | 146162 | 349 | 7.956 | 18371.3 |
344 | 2023-10-26 16:39:01 | collated | 3 | 146162 | 349 | 9.220 | 15852.7 |
343 | 2023-10-23 19:52:45 | collated | 1 | 82945 | 6 | 1.516 | 54713.1 |
342 | 2023-10-19 18:03:03 | collated | 3 | 146162 | 349 | 6.703 | 21805.5 |
341 | 2023-10-06 14:22:21 | collated | 1 | 82945 | 6 | 1.330 | 62364.7 |
340 | 2023-08-28 18:50:51 | collated | 1 | 82945 | 6 | 1.406 | 58993.6 |
339 | 2023-08-16 04:03:32 | collated | 2 | 121059 | 38 | 3.250 | 37248.9 |
338 | 2023-08-15 10:31:08 | collated | 3 | 146162 | 349 | 6.233 | 23449.7 |
337 | 2023-07-14 12:19:05 | collated | 1 | 82945 | 6 | 1.390 | 59672.7 |
336 | 2023-05-30 19:22:29 | collated | 1 | 82945 | 6 | 1.266 | 65517.4 |
335 | 2023-05-16 18:41:39 | collated | 3 | 146162 | 349 | 6.346 | 23032.1 |
334 | 2023-05-03 00:51:54 | collated | 2 | 121059 | 38 | 3.343 | 36212.7 |
333 | 2023-05-01 09:25:46 | collated | 3 | 146162 | 349 | 6.406 | 22816.4 |
332 | 2023-04-03 03:59:42 | collated | 1 | 82945 | 6 | 1.390 | 59672.7 |
331 | 2023-03-24 09:00:11 | collated | 1 | 82945 | 6 | 1.436 | 57761.1 |
330 | 2023-02-11 20:45:47 | collated | 2 | 121059 | 38 | 3.173 | 38152.9 |
329 | 2023-02-08 14:40:50 | collated | 3 | 146162 | 349 | 6.250 | 23385.9 |
328 | 2023-01-08 16:27:45 | collated | 1 | 82945 | 6 | 1.420 | 58412.0 |
327 | 2022-12-25 06:09:05 | collated | 1 | 82945 | 6 | 1.420 | 58412.0 |
326 | 2022-12-17 19:00:19 | collated | 3 | 146162 | 349 | 8.190 | 17846.4 |
325 | 2022-11-22 16:42:18 | collated | 2 | 121059 | 38 | 3.186 | 37997.2 |
324 | 2022-11-21 17:11:26 | collated | 3 | 146162 | 349 | 6.533 | 22372.9 |
323 | 2022-10-08 07:37:41 | collated | 1 | 82945 | 6 | 1.283 | 64649.3 |
322 | 2022-09-14 12:55:12 | collated | 1 | 82945 | 6 | 1.296 | 64000.8 |
321 | 2022-06-30 10:01:19 | collated | 3 | 146162 | 349 | 6.266 | 23326.2 |
320 | 2022-06-24 12:40:58 | collated | 3 | 146162 | 349 | 6.266 | 23326.2 |
319 | 2022-05-29 08:33:42 | collated | 1 | 82945 | 6 | 1.326 | 62552.8 |
318 | 2022-05-28 15:35:52 | collated | 1 | 82945 | 6 | 1.346 | 61623.3 |
317 | 2022-05-17 05:40:12 | collated | 3 | 146162 | 349 | 6.406 | 22816.4 |
316 | 2022-05-05 08:45:46 | collated | 2 | 121059 | 38 | 3.516 | 34430.9 |
315 | 2022-04-29 12:58:46 | collated | 3 | 146162 | 349 | 7.343 | 19904.9 |
314 | 2022-04-27 23:23:30 | collated | 1 | 82945 | 6 | 1.686 | 49196.3 |
313 | 2022-03-20 03:06:33 | collated | 3 | 146162 | 349 | 6.313 | 23152.5 |
312 | 2022-02-18 03:19:23 | collated | 1 | 82945 | 6 | 1.500 | 55296.7 |
311 | 2022-02-14 06:46:48 | collated | 3 | 146162 | 349 | 7.720 | 18932.9 |
310 | 2022-02-10 17:05:07 | collated | 3 | 146162 | 349 | 6.626 | 22058.9 |
309 | 2022-02-05 22:00:17 | collated | 3 | 146162 | 349 | 6.813 | 21453.4 |
308 | 2022-02-02 16:43:18 | collated | 1 | 82945 | 6 | 1.293 | 64149.3 |
307 | 2022-01-19 05:10:46 | collated | 1 | 82945 | 6 | 1.343 | 61761.0 |
306 | 2022-01-17 01:16:02 | collated | 1 | 82945 | 6 | 1.736 | 47779.4 |
305 | 2021-12-18 04:58:08 | collated | 1 | 82945 | 6 | 1.563 | 53067.8 |
304 | 2021-11-28 21:33:04 | collated | 1 | 82945 | 6 | 1.453 | 57085.3 |
303 | 2021-11-28 09:42:58 | collated | 1 | 82945 | 6 | 1.343 | 61761.0 |
302 | 2021-11-27 17:20:00 | collated | 1 | 82945 | 6 | 1.330 | 62364.7 |
301 | 2021-11-27 06:19:15 | collated | 1 | 82945 | 6 | 1.376 | 60279.8 |
300 | 2021-11-26 17:23:23 | collated | 1 | 82945 | 6 | 1.373 | 60411.5 |
299 | 2021-11-26 04:34:45 | collated | 1 | 82945 | 6 | 1.690 | 49079.9 |
298 | 2021-11-25 10:46:44 | collated | 1 | 82945 | 6 | 1.393 | 59544.1 |
297 | 2021-11-12 20:38:47 | collated | 1 | 82945 | 6 | 1.406 | 58993.6 |
296 | 2021-11-10 21:00:38 | collated | 1 | 82945 | 6 | 1.500 | 55296.7 |
295 | 2021-11-10 01:29:59 | collated | 1 | 82945 | 6 | 1.470 | 56425.2 |
294 | 2021-10-23 22:08:55 | collated | 1 | 82945 | 6 | 1.466 | 56579.1 |
293 | 2021-09-28 08:35:02 | collated | 1 | 82945 | 6 | 2.596 | 31951.1 |
292 | 2021-09-27 08:39:15 | collated | 1 | 82945 | 6 | 1.533 | 54106.3 |
291 | 2021-09-26 16:17:26 | collated | 1 | 82945 | 6 | 1.436 | 57761.1 |
290 | 2021-09-26 06:23:37 | collated | 1 | 82945 | 6 | 1.296 | 64000.8 |
289 | 2021-09-22 04:08:38 | collated | 1 | 82945 | 6 | 1.390 | 59672.7 |
288 | 2021-08-20 07:03:09 | collated | 1 | 82945 | 6 | 1.293 | 64149.3 |