History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prong"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
706 | 2024-04-27 06:29:50 | prong | 1 | 28756 | 7 | 1.076 | 26724.9 |
705 | 2024-04-03 04:32:37 | prong | 1 | 28756 | 7 | 1.690 | 17015.4 |
704 | 2024-03-31 07:40:28 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
703 | 2024-03-28 22:35:58 | prong | 2 | 53800 | 138 | 2.796 | 19241.8 |
702 | 2024-03-28 18:40:26 | prong | 2 | 53800 | 138 | 5.563 | 9671.0 |
701 | 2024-03-28 18:24:59 | prong | 1 | 28756 | 7 | 0.530 | 54256.6 |
700 | 2024-03-25 01:35:21 | prong | 1 | 28756 | 7 | 0.530 | 54256.6 |
699 | 2024-02-26 22:43:59 | prong | 2 | 53800 | 138 | 2.720 | 19779.4 |
698 | 2024-02-26 19:36:55 | prong | 1 | 28756 | 7 | 1.046 | 27491.4 |
697 | 2024-02-13 03:35:47 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
696 | 2024-01-16 19:27:47 | prong | 2 | 53800 | 138 | 1.576 | 34137.1 |
695 | 2024-01-01 10:20:48 | prong | 2 | 53800 | 138 | 1.436 | 37465.2 |
694 | 2023-12-24 21:42:46 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
693 | 2023-12-10 03:39:25 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
692 | 2023-11-29 22:52:22 | prong | 1 | 28756 | 7 | 0.420 | 68466.7 |
691 | 2023-11-26 00:16:46 | prong | 2 | 53800 | 138 | 2.766 | 19450.5 |
690 | 2023-11-23 06:14:14 | prong | 2 | 53800 | 138 | 1.500 | 35866.7 |
689 | 2023-11-21 22:51:33 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
688 | 2023-11-13 14:03:32 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
687 | 2023-11-09 09:08:44 | prong | 2 | 53800 | 138 | 1.423 | 37807.4 |
686 | 2023-11-07 23:41:20 | prong | 1 | 28756 | 7 | 0.440 | 65354.5 |
685 | 2023-11-07 08:10:39 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
684 | 2023-11-02 05:01:07 | prong | 1 | 28756 | 7 | 0.470 | 61183.0 |
683 | 2023-10-21 09:16:31 | prong | 1 | 28756 | 7 | 0.466 | 61708.2 |
682 | 2023-10-18 07:41:28 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
681 | 2023-10-13 10:50:33 | prong | 1 | 28756 | 7 | 0.466 | 61708.2 |
680 | 2023-10-05 17:36:01 | prong | 2 | 53800 | 138 | 1.406 | 38264.6 |
679 | 2023-10-05 04:30:17 | prong | 1 | 28756 | 7 | 0.563 | 51076.4 |
678 | 2023-09-29 03:58:44 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
677 | 2023-09-14 23:01:38 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
676 | 2023-09-14 01:35:47 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
675 | 2023-08-10 16:36:33 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
674 | 2023-07-16 12:16:47 | prong | 2 | 53800 | 138 | 1.393 | 38621.7 |
673 | 2023-07-01 22:10:57 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
672 | 2023-06-30 07:39:49 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
671 | 2023-04-22 02:00:20 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
670 | 2023-04-08 07:55:30 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
669 | 2023-04-02 09:10:21 | prong | 2 | 53800 | 138 | 1.390 | 38705.0 |
668 | 2023-01-23 03:15:43 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
667 | 2022-12-31 04:41:52 | prong | 2 | 53800 | 138 | 1.356 | 39675.5 |
666 | 2022-12-22 03:07:31 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
665 | 2022-12-05 09:15:10 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
664 | 2022-11-19 21:51:21 | prong | 1 | 28756 | 7 | 0.530 | 54256.6 |
663 | 2022-09-03 03:36:05 | prong | 2 | 53800 | 138 | 1.373 | 39184.3 |
662 | 2022-08-25 14:28:21 | prong | 1 | 28756 | 7 | 0.470 | 61183.0 |
661 | 2022-08-21 22:40:24 | prong | 1 | 28756 | 7 | 0.440 | 65354.5 |
660 | 2022-07-29 13:34:44 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
659 | 2022-07-13 04:26:07 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
658 | 2022-07-10 20:21:56 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
657 | 2022-05-16 03:36:29 | prong | 1 | 28756 | 7 | 0.486 | 59168.7 |
656 | 2022-04-21 08:03:23 | prong | 1 | 28756 | 7 | 0.470 | 61183.0 |
655 | 2022-03-09 03:11:42 | prong | 1 | 28756 | 7 | 0.670 | 42919.4 |
654 | 2022-01-02 00:17:57 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
653 | 2022-01-01 18:56:59 | prong | 1 | 28756 | 7 | 0.546 | 52666.7 |
652 | 2021-12-23 17:41:48 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
651 | 2021-11-18 09:56:57 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
650 | 2021-10-28 14:47:54 | prong | 1 | 28756 | 7 | 0.703 | 40904.7 |
649 | 2021-09-19 12:12:17 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
648 | 2021-09-18 23:55:36 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
647 | 2021-08-30 07:39:17 | prong | 1 | 28756 | 7 | 0.486 | 59168.7 |
646 | 2021-08-28 03:04:02 | prong | 1 | 28756 | 7 | 0.486 | 59168.7 |
645 | 2021-06-19 14:39:40 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
644 | 2021-03-17 01:15:38 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
643 | 2021-03-08 06:34:57 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
642 | 2021-03-06 04:07:45 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
641 | 2021-02-23 10:52:53 | prong | 2 | 53800 | 138 | 1.376 | 39098.8 |
640 | 2021-02-08 14:50:06 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
639 | 2021-02-07 23:08:37 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
638 | 2021-02-06 17:58:19 | prong | 1 | 28756 | 7 | 0.440 | 65354.5 |
637 | 2021-02-02 21:09:07 | prong | 1 | 28756 | 7 | 0.486 | 59168.7 |
636 | 2021-02-02 04:04:44 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
635 | 2021-01-29 00:36:10 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
634 | 2021-01-28 11:22:39 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
633 | 2021-01-27 19:26:34 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
632 | 2021-01-27 09:27:38 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
631 | 2021-01-18 04:45:19 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
630 | 2021-01-03 13:19:47 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
629 | 2020-12-10 11:15:37 | prong | 1 | 28756 | 7 | 0.466 | 61708.2 |
628 | 2020-11-08 02:35:13 | prong | 1 | 28756 | 7 | 0.470 | 61183.0 |
627 | 2020-10-31 02:06:25 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
626 | 2020-10-17 08:09:14 | prong | 1 | 28756 | 7 | 0.466 | 61708.2 |
625 | 2020-10-15 11:43:20 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
624 | 2020-10-09 05:14:21 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
623 | 2020-09-03 17:17:05 | prong | 1 | 28756 | 7 | 0.513 | 56054.6 |
622 | 2020-08-23 16:43:37 | prong | 1 | 28756 | 7 | 0.453 | 63479.0 |
621 | 2020-08-09 03:24:03 | prong | 1 | 28756 | 7 | 0.516 | 55728.7 |
620 | 2020-07-28 22:02:18 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
619 | 2020-05-26 14:12:41 | prong | 1 | 28756 | 7 | 0.436 | 65954.1 |
618 | 2020-03-25 15:47:06 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
617 | 2020-03-25 12:56:53 | prong | 1 | 28756 | 7 | 0.516 | 55728.7 |
616 | 2020-03-23 06:06:03 | prong | 1 | 28756 | 7 | 0.516 | 55728.7 |
615 | 2020-03-23 05:36:17 | prong | 1 | 28756 | 7 | 0.483 | 59536.2 |
614 | 2020-03-21 12:05:52 | prong | 1 | 28756 | 7 | 0.486 | 59168.7 |
613 | 2020-03-18 07:51:45 | prong | 1 | 28756 | 7 | 0.593 | 48492.4 |
612 | 2020-02-27 05:30:27 | prong | 1 | 28756 | 7 | 1.080 | 26625.9 |
611 | 2020-02-24 21:39:21 | prong | 1 | 28756 | 7 | 1.096 | 26237.2 |
610 | 2020-02-23 09:04:45 | prong | 1 | 28756 | 7 | 0.500 | 57512.0 |
609 | 2020-02-22 09:33:48 | prong | 1 | 28756 | 7 | 0.580 | 49579.3 |
608 | 2020-02-21 14:24:01 | prong | 1 | 28756 | 7 | 1.093 | 26309.2 |
607 | 2020-02-17 18:50:54 | prong | 1 | 28756 | 7 | 0.546 | 52666.7 |