History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prune"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
502 | 2024-02-28 02:05:57 | prune | 2 | 53800 | 113 | 1.673 | 32157.8 |
501 | 2024-02-28 02:05:56 | prune | 1 | 28756 | 7 | 0.530 | 54256.6 |
500 | 2024-01-28 21:17:09 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
499 | 2024-01-12 11:12:46 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
498 | 2024-01-04 03:38:17 | prune | 2 | 53800 | 113 | 3.096 | 17377.3 |
497 | 2023-12-16 06:53:19 | prune | 2 | 53800 | 113 | 1.406 | 38264.6 |
496 | 2023-12-03 20:32:46 | prune | 1 | 28756 | 7 | 0.826 | 34813.6 |
495 | 2023-12-03 20:32:45 | prune | 1 | 28756 | 7 | 0.843 | 34111.5 |
494 | 2023-11-14 18:11:56 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
493 | 2023-11-11 10:51:16 | prune | 1 | 28756 | 7 | 0.440 | 65354.5 |
492 | 2023-11-06 19:55:37 | prune | 1 | 28756 | 7 | 0.450 | 63902.2 |
491 | 2023-11-05 14:30:12 | prune | 2 | 53800 | 113 | 1.830 | 29398.9 |
490 | 2023-11-05 04:23:40 | prune | 1 | 28756 | 7 | 0.530 | 54256.6 |
489 | 2023-10-26 10:20:33 | prune | 2 | 53800 | 113 | 1.406 | 38264.6 |
488 | 2023-10-19 19:35:19 | prune | 1 | 28756 | 7 | 0.470 | 61183.0 |
487 | 2023-10-19 09:06:42 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
486 | 2023-10-16 21:42:31 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
485 | 2023-10-15 15:55:35 | prune | 1 | 28756 | 7 | 0.466 | 61708.2 |
484 | 2023-10-05 06:11:33 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
483 | 2023-09-29 06:55:10 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
482 | 2023-09-24 16:07:54 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
481 | 2023-08-28 01:14:31 | prune | 1 | 28756 | 7 | 0.440 | 65354.5 |
480 | 2023-06-29 22:45:42 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
479 | 2023-05-30 18:20:55 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
478 | 2023-03-23 12:59:26 | prune | 1 | 28756 | 7 | 0.440 | 65354.5 |
477 | 2023-03-10 12:20:17 | prune | 1 | 28756 | 7 | 0.420 | 68466.7 |
476 | 2023-01-08 15:27:35 | prune | 1 | 28756 | 7 | 0.856 | 33593.5 |
475 | 2023-01-01 06:55:49 | prune | 1 | 28756 | 7 | 1.030 | 27918.4 |
474 | 2022-11-16 20:19:52 | prune | 1 | 28756 | 7 | 0.513 | 56054.6 |
473 | 2022-11-15 06:08:02 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
472 | 2022-10-12 19:08:35 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
471 | 2022-08-15 19:31:29 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
470 | 2022-08-14 17:09:57 | prune | 1 | 28756 | 7 | 0.486 | 59168.7 |
469 | 2022-08-06 07:00:23 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
468 | 2022-07-29 13:30:51 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
467 | 2022-07-22 09:27:16 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
466 | 2022-07-18 12:05:06 | prune | 1 | 28756 | 7 | 0.516 | 55728.7 |
465 | 2022-07-17 18:46:58 | prune | 1 | 28756 | 7 | 0.420 | 68466.7 |
464 | 2022-07-03 01:36:56 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
463 | 2022-05-26 07:24:06 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
462 | 2022-05-24 01:15:41 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
461 | 2022-03-31 13:32:14 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
460 | 2022-02-05 10:21:22 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
459 | 2021-12-17 08:10:24 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
458 | 2021-12-17 01:34:26 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
457 | 2021-11-29 07:30:01 | prune | 1 | 28756 | 7 | 0.610 | 47141.0 |
456 | 2021-11-23 08:41:48 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
455 | 2021-10-12 21:59:46 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
454 | 2021-10-10 20:32:11 | prune | 1 | 28756 | 7 | 0.516 | 55728.7 |
453 | 2021-09-14 00:59:31 | prune | 1 | 28756 | 7 | 0.440 | 65354.5 |
452 | 2021-09-09 19:34:11 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
451 | 2021-09-04 13:03:45 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
450 | 2021-09-02 07:10:56 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
449 | 2021-06-08 21:12:01 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
448 | 2021-03-06 14:37:12 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
447 | 2021-03-03 10:02:22 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
446 | 2020-12-02 07:28:45 | prune | 1 | 28756 | 7 | 0.530 | 54256.6 |
445 | 2020-11-20 02:31:55 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
444 | 2020-11-13 00:40:24 | prune | 1 | 28756 | 7 | 0.576 | 49923.6 |
443 | 2020-10-25 23:43:33 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
442 | 2020-10-08 23:21:02 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
441 | 2020-08-28 02:57:24 | prune | 1 | 28756 | 7 | 0.470 | 61183.0 |
440 | 2020-08-09 03:25:55 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
439 | 2020-06-10 01:40:56 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
438 | 2020-05-26 13:19:58 | prune | 1 | 28756 | 7 | 0.466 | 61708.2 |
437 | 2020-03-25 14:17:57 | prune | 1 | 28756 | 7 | 0.470 | 61183.0 |
436 | 2020-03-25 06:21:11 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
435 | 2020-03-24 01:52:37 | prune | 1 | 28756 | 7 | 0.610 | 47141.0 |
434 | 2020-03-23 04:43:20 | prune | 1 | 28756 | 7 | 0.563 | 51076.4 |
433 | 2020-03-21 12:26:43 | prune | 1 | 28756 | 7 | 0.530 | 54256.6 |
432 | 2020-03-18 03:32:04 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
431 | 2020-03-13 19:06:44 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
430 | 2020-02-24 01:47:55 | prune | 1 | 28756 | 7 | 0.546 | 52666.7 |
429 | 2020-02-23 21:24:07 | prune | 1 | 28756 | 7 | 0.970 | 29645.4 |
428 | 2020-02-23 08:17:39 | prune | 1 | 28756 | 7 | 1.110 | 25906.3 |
427 | 2020-02-23 05:14:08 | prune | 1 | 28756 | 7 | 1.140 | 25224.6 |
426 | 2020-02-17 03:07:59 | prune | 1 | 28756 | 7 | 0.653 | 44036.8 |
425 | 2020-02-10 15:51:03 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
424 | 2020-02-10 05:10:04 | prune | 1 | 28756 | 7 | 1.766 | 16283.1 |
423 | 2020-02-02 01:26:21 | prune | 1 | 28756 | 7 | 0.640 | 44931.3 |
422 | 2020-01-29 05:08:15 | prune | 1 | 28756 | 7 | 0.436 | 65954.1 |
421 | 2020-01-29 04:59:53 | prune | 1 | 28756 | 7 | 0.580 | 49579.3 |
420 | 2020-01-22 23:06:10 | prune | 2 | 53800 | 113 | 3.140 | 17133.8 |
419 | 2020-01-22 18:10:38 | prune | 1 | 28756 | 7 | 0.563 | 51076.4 |
418 | 2020-01-22 04:33:50 | prune | 1 | 28756 | 7 | 0.546 | 52666.7 |
417 | 2020-01-21 16:47:30 | prune | 1 | 28756 | 7 | 0.530 | 54256.6 |
416 | 2020-01-11 06:05:44 | prune | 1 | 28756 | 7 | 1.750 | 16432.0 |
415 | 2020-01-10 04:24:42 | prune | 1 | 28756 | 7 | 1.016 | 28303.1 |
414 | 2020-01-07 06:00:32 | prune | 1 | 28756 | 7 | 0.550 | 52283.6 |
413 | 2020-01-06 20:04:59 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
412 | 2020-01-03 18:33:48 | prune | 1 | 28756 | 7 | 0.470 | 61183.0 |
411 | 2019-12-24 04:59:14 | prune | 1 | 28756 | 7 | 0.453 | 63479.0 |
410 | 2019-12-24 03:07:45 | prune | 1 | 28756 | 7 | 0.560 | 51350.0 |
409 | 2019-12-23 16:11:12 | prune | 1 | 28756 | 7 | 0.483 | 59536.2 |
408 | 2019-12-23 14:10:40 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
407 | 2019-11-27 11:18:18 | prune | 2 | 53800 | 113 | 1.920 | 28020.8 |
406 | 2019-11-21 08:39:54 | prune | 1 | 28756 | 7 | 0.516 | 55728.7 |
405 | 2019-11-15 21:20:55 | prune | 1 | 28756 | 7 | 0.623 | 46157.3 |
404 | 2019-10-11 06:20:24 | prune | 1 | 28756 | 7 | 0.500 | 57512.0 |
403 | 2019-09-03 19:08:13 | prune | 1 | 28756 | 7 | 0.886 | 32456.0 |