History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"punch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
710 | 2024-05-04 06:09:55 | punch | 1 | 28756 | 9 | 0.686 | 41918.4 |
709 | 2024-05-03 05:24:06 | punch | 1 | 28756 | 9 | 0.966 | 29768.1 |
708 | 2024-04-29 14:32:10 | punch | 1 | 28756 | 9 | 0.796 | 36125.6 |
707 | 2024-04-25 15:07:27 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
706 | 2024-04-05 05:48:47 | punch | 1 | 28756 | 9 | 1.673 | 17188.3 |
705 | 2024-04-03 02:55:54 | punch | 1 | 28756 | 9 | 1.250 | 23004.8 |
704 | 2024-03-31 07:48:48 | punch | 1 | 28756 | 9 | 1.076 | 26724.9 |
703 | 2024-03-29 19:17:46 | punch | 3 | 83667 | 770 | 11.923 | 7017.3 |
702 | 2024-03-29 09:05:10 | punch | 1 | 28756 | 9 | 0.533 | 53951.2 |
701 | 2024-03-29 06:32:54 | punch | 3 | 83667 | 770 | 11.310 | 7397.6 |
700 | 2024-03-29 03:51:31 | punch | 2 | 53800 | 99 | 1.610 | 33416.1 |
699 | 2024-03-28 08:24:31 | punch | 2 | 53800 | 99 | 1.390 | 38705.0 |
698 | 2024-03-28 08:24:30 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
697 | 2024-03-28 08:24:09 | punch | 3 | 83667 | 770 | 3.346 | 25005.1 |
696 | 2024-03-28 07:52:18 | punch | 3 | 83667 | 770 | 4.000 | 20916.8 |
695 | 2024-03-03 21:30:35 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
694 | 2024-03-01 04:06:33 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
693 | 2024-02-28 02:35:38 | punch | 1 | 28756 | 9 | 1.046 | 27491.4 |
692 | 2024-02-04 16:34:54 | punch | 2 | 53800 | 99 | 1.733 | 31044.4 |
691 | 2024-02-04 16:34:26 | punch | 3 | 83667 | 770 | 5.436 | 15391.3 |
690 | 2024-02-02 20:39:03 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
689 | 2024-01-28 22:18:33 | punch | 1 | 28756 | 9 | 0.486 | 59168.7 |
688 | 2024-01-28 17:38:11 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
687 | 2024-01-17 12:15:15 | punch | 2 | 53800 | 99 | 1.420 | 37887.3 |
686 | 2024-01-17 12:15:12 | punch | 3 | 83667 | 770 | 3.373 | 24804.9 |
685 | 2024-01-12 19:02:02 | punch | 3 | 83667 | 770 | 3.876 | 21585.9 |
684 | 2024-01-07 08:31:08 | punch | 2 | 53800 | 99 | 1.550 | 34709.7 |
683 | 2024-01-05 00:41:32 | punch | 3 | 83667 | 770 | 3.266 | 25617.6 |
682 | 2024-01-03 22:19:07 | punch | 1 | 28756 | 9 | 0.516 | 55728.7 |
681 | 2024-01-03 10:56:48 | punch | 3 | 83667 | 770 | 3.280 | 25508.2 |
680 | 2024-01-02 21:49:36 | punch | 2 | 53800 | 99 | 1.876 | 28678.0 |
679 | 2024-01-01 14:40:03 | punch | 3 | 83667 | 770 | 3.343 | 25027.5 |
678 | 2023-12-02 09:30:32 | punch | 3 | 83667 | 770 | 3.296 | 25384.4 |
677 | 2023-11-25 16:47:42 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
676 | 2023-11-17 14:05:04 | punch | 1 | 28756 | 9 | 1.013 | 28387.0 |
675 | 2023-11-14 21:01:29 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
674 | 2023-11-14 13:14:08 | punch | 3 | 83667 | 770 | 3.986 | 20990.2 |
673 | 2023-11-14 13:13:58 | punch | 2 | 53800 | 99 | 1.576 | 34137.1 |
672 | 2023-11-02 08:26:48 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
671 | 2023-10-27 16:29:13 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
670 | 2023-10-21 09:58:42 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
669 | 2023-10-19 09:07:11 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
668 | 2023-10-05 06:45:15 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
667 | 2023-09-27 15:05:10 | punch | 1 | 28756 | 9 | 0.533 | 53951.2 |
666 | 2023-09-24 07:12:36 | punch | 1 | 28756 | 9 | 0.466 | 61708.2 |
665 | 2023-08-31 16:43:04 | punch | 3 | 83667 | 770 | 3.563 | 23482.2 |
664 | 2023-08-21 13:03:41 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
663 | 2023-08-02 04:30:38 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
662 | 2023-05-24 04:39:35 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
661 | 2023-05-18 15:34:30 | punch | 3 | 83667 | 770 | 3.220 | 25983.5 |
660 | 2023-04-13 18:37:29 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
659 | 2023-03-18 23:56:42 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
658 | 2023-02-25 23:28:08 | punch | 3 | 83667 | 770 | 3.656 | 22884.8 |
657 | 2023-01-30 07:26:01 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
656 | 2023-01-06 04:33:56 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
655 | 2022-12-28 12:13:46 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
654 | 2022-12-06 17:40:24 | punch | 3 | 83667 | 770 | 3.576 | 23396.8 |
653 | 2022-11-25 08:46:13 | punch | 1 | 28756 | 9 | 0.486 | 59168.7 |
652 | 2022-09-29 16:53:49 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
651 | 2022-09-08 04:53:29 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
650 | 2022-09-05 09:15:27 | punch | 1 | 28756 | 9 | 0.453 | 63479.0 |
649 | 2022-09-01 11:29:17 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
648 | 2022-09-01 08:48:50 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
647 | 2022-08-20 23:56:52 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
646 | 2022-05-11 15:50:34 | punch | 1 | 28756 | 9 | 0.576 | 49923.6 |
645 | 2022-04-20 10:07:40 | punch | 1 | 28756 | 9 | 0.576 | 49923.6 |
644 | 2022-04-17 00:42:56 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
643 | 2022-04-08 12:02:28 | punch | 3 | 83667 | 770 | 4.610 | 18149.0 |
642 | 2022-01-28 13:15:28 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
641 | 2022-01-26 07:04:42 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
640 | 2021-12-25 20:30:50 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
639 | 2021-12-19 19:26:27 | punch | 3 | 83667 | 770 | 3.766 | 22216.4 |
638 | 2021-12-06 05:58:53 | punch | 1 | 28756 | 9 | 0.453 | 63479.0 |
637 | 2021-10-23 08:43:49 | punch | 1 | 28756 | 9 | 0.486 | 59168.7 |
636 | 2021-10-03 04:55:39 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
635 | 2021-10-01 02:42:08 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
634 | 2021-09-12 05:25:24 | punch | 1 | 28756 | 9 | 0.503 | 57169.0 |
633 | 2021-09-11 21:08:08 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
632 | 2021-07-23 05:07:47 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
631 | 2021-07-01 19:25:40 | punch | 1 | 28756 | 9 | 0.593 | 48492.4 |
630 | 2021-06-11 22:40:25 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
629 | 2021-06-09 05:47:48 | punch | 1 | 28756 | 9 | 0.470 | 61183.0 |
628 | 2021-06-02 15:57:46 | punch | 1 | 28756 | 9 | 0.563 | 51076.4 |
627 | 2021-05-19 05:42:16 | punch | 1 | 28756 | 9 | 0.440 | 65354.5 |
626 | 2021-05-08 11:52:35 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
625 | 2021-04-29 00:42:25 | punch | 1 | 28756 | 9 | 0.453 | 63479.0 |
624 | 2021-04-06 22:22:13 | punch | 1 | 28756 | 9 | 0.486 | 59168.7 |
623 | 2021-03-08 21:43:20 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
622 | 2021-01-22 02:01:49 | punch | 1 | 28756 | 9 | 0.453 | 63479.0 |
621 | 2020-12-01 04:07:58 | punch | 1 | 28756 | 9 | 0.453 | 63479.0 |
620 | 2020-10-30 16:07:40 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
619 | 2020-10-19 11:08:05 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
618 | 2020-10-18 19:54:07 | punch | 1 | 28756 | 9 | 0.466 | 61708.2 |
617 | 2020-10-15 06:28:44 | punch | 1 | 28756 | 9 | 0.483 | 59536.2 |
616 | 2020-10-07 09:41:29 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |
615 | 2020-08-14 18:13:12 | punch | 1 | 28756 | 9 | 0.470 | 61183.0 |
614 | 2020-08-14 16:06:02 | punch | 1 | 28756 | 9 | 0.563 | 51076.4 |
613 | 2020-05-16 10:22:02 | punch | 1 | 28756 | 9 | 0.436 | 65954.1 |
612 | 2020-05-07 11:36:21 | punch | 1 | 28756 | 9 | 0.610 | 47141.0 |
611 | 2020-03-26 12:05:39 | punch | 1 | 28756 | 9 | 0.500 | 57512.0 |