History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stale"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
803 | 2024-03-04 01:57:42 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
802 | 2024-02-29 23:20:24 | stale | 1 | 28756 | 25 | 0.580 | 49579.3 |
801 | 2024-02-29 17:33:38 | stale | 1 | 28756 | 25 | 0.576 | 49923.6 |
800 | 2024-02-27 20:40:00 | stale | 1 | 28756 | 25 | 1.080 | 26625.9 |
799 | 2024-02-24 12:36:00 | stale | 2 | 53800 | 247 | 1.393 | 38621.7 |
798 | 2024-02-03 03:43:51 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
797 | 2024-01-28 22:58:37 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
796 | 2024-01-27 08:07:01 | stale | 1 | 28756 | 25 | 0.516 | 55728.7 |
795 | 2024-01-21 03:58:59 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
794 | 2024-01-06 16:31:04 | stale | 2 | 53800 | 247 | 1.373 | 39184.3 |
793 | 2024-01-05 18:03:58 | stale | 2 | 53800 | 247 | 1.470 | 36598.6 |
792 | 2024-01-01 10:39:04 | stale | 2 | 53800 | 247 | 1.783 | 30173.9 |
791 | 2023-12-08 10:31:14 | stale | 1 | 28756 | 25 | 0.906 | 31739.5 |
790 | 2023-12-08 10:31:12 | stale | 1 | 28756 | 25 | 0.873 | 32939.3 |
789 | 2023-12-07 15:16:41 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
788 | 2023-12-07 15:16:40 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
787 | 2023-11-18 10:18:23 | stale | 2 | 53800 | 247 | 3.686 | 14595.8 |
786 | 2023-11-18 07:59:20 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
785 | 2023-11-18 05:17:33 | stale | 1 | 28756 | 25 | 0.436 | 65954.1 |
784 | 2023-11-15 19:46:58 | stale | 2 | 53800 | 247 | 1.783 | 30173.9 |
783 | 2023-11-14 20:46:49 | stale | 1 | 28756 | 25 | 0.470 | 61183.0 |
782 | 2023-11-14 04:44:27 | stale | 1 | 28756 | 25 | 0.470 | 61183.0 |
781 | 2023-10-30 22:06:22 | stale | 1 | 28756 | 25 | 0.440 | 65354.5 |
780 | 2023-10-23 16:32:03 | stale | 1 | 28756 | 25 | 0.436 | 65954.1 |
779 | 2023-10-21 10:53:42 | stale | 1 | 28756 | 25 | 0.470 | 61183.0 |
778 | 2023-10-17 22:39:56 | stale | 1 | 28756 | 25 | 0.513 | 56054.6 |
777 | 2023-10-14 22:18:27 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
776 | 2023-10-06 04:33:45 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
775 | 2023-09-27 08:45:13 | stale | 1 | 28756 | 25 | 0.563 | 51076.4 |
774 | 2023-09-23 13:42:06 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
773 | 2023-08-19 22:25:05 | stale | 2 | 53800 | 247 | 1.420 | 37887.3 |
772 | 2023-08-01 06:39:31 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
771 | 2023-05-03 09:12:42 | stale | 2 | 53800 | 247 | 1.356 | 39675.5 |
770 | 2023-04-23 21:01:26 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
769 | 2023-03-04 06:26:39 | stale | 2 | 53800 | 247 | 1.590 | 33836.5 |
768 | 2023-02-10 00:31:54 | stale | 2 | 53800 | 247 | 1.470 | 36598.6 |
767 | 2023-01-15 05:14:34 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
766 | 2022-11-21 04:23:29 | stale | 2 | 53800 | 247 | 1.533 | 35094.6 |
765 | 2022-09-27 14:46:47 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
764 | 2022-09-23 23:51:31 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
763 | 2022-09-15 21:27:31 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
762 | 2022-07-29 05:52:13 | stale | 1 | 28756 | 25 | 0.436 | 65954.1 |
761 | 2022-07-19 05:04:05 | stale | 2 | 53800 | 247 | 1.373 | 39184.3 |
760 | 2022-07-18 19:00:12 | stale | 1 | 28756 | 25 | 0.436 | 65954.1 |
759 | 2022-06-29 20:23:00 | stale | 1 | 28756 | 25 | 0.470 | 61183.0 |
758 | 2022-06-25 15:57:07 | stale | 2 | 53800 | 247 | 1.406 | 38264.6 |
757 | 2022-06-17 02:49:40 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
756 | 2022-06-09 00:32:18 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
755 | 2022-06-08 18:14:18 | stale | 1 | 28756 | 25 | 0.486 | 59168.7 |
754 | 2022-06-07 19:38:29 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
753 | 2022-06-07 00:58:35 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
752 | 2022-06-03 12:01:33 | stale | 1 | 28756 | 25 | 0.450 | 63902.2 |
751 | 2022-06-01 14:28:24 | stale | 1 | 28756 | 25 | 0.450 | 63902.2 |
750 | 2022-05-25 18:09:02 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
749 | 2022-05-04 17:36:01 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
748 | 2022-03-06 22:32:56 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
747 | 2022-02-25 23:14:03 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
746 | 2022-02-20 04:21:59 | stale | 1 | 28756 | 25 | 0.513 | 56054.6 |
745 | 2022-02-16 20:02:58 | stale | 1 | 28756 | 25 | 0.486 | 59168.7 |
744 | 2022-02-09 20:33:42 | stale | 2 | 53800 | 247 | 1.690 | 31834.3 |
743 | 2022-02-08 12:47:19 | stale | 1 | 28756 | 25 | 0.593 | 48492.4 |
742 | 2022-02-07 00:36:14 | stale | 2 | 53800 | 247 | 1.640 | 32804.9 |
741 | 2021-12-22 13:21:49 | stale | 1 | 28756 | 25 | 0.546 | 52666.7 |
740 | 2021-12-21 14:36:47 | stale | 1 | 28756 | 25 | 0.546 | 52666.7 |
739 | 2021-12-19 12:28:48 | stale | 1 | 28756 | 25 | 0.483 | 59536.2 |
738 | 2021-11-18 11:06:28 | stale | 1 | 28756 | 25 | 0.546 | 52666.7 |
737 | 2021-11-10 03:34:33 | stale | 2 | 53800 | 247 | 1.420 | 37887.3 |
736 | 2021-11-08 20:30:51 | stale | 1 | 28756 | 25 | 0.440 | 65354.5 |
735 | 2021-10-22 12:11:08 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
734 | 2021-09-10 10:19:36 | stale | 1 | 28756 | 25 | 0.533 | 53951.2 |
733 | 2021-08-25 23:01:26 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
732 | 2021-08-13 03:39:30 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
731 | 2021-08-12 02:33:52 | stale | 1 | 28756 | 25 | 0.513 | 56054.6 |
730 | 2021-08-09 05:38:56 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
729 | 2021-08-08 06:58:04 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
728 | 2021-08-06 10:39:38 | stale | 1 | 28756 | 25 | 0.513 | 56054.6 |
727 | 2021-08-05 18:39:08 | stale | 1 | 28756 | 25 | 0.470 | 61183.0 |
726 | 2021-08-01 11:31:19 | stale | 1 | 28756 | 25 | 0.436 | 65954.1 |
725 | 2021-07-12 01:14:50 | stale | 1 | 28756 | 25 | 0.466 | 61708.2 |
724 | 2021-07-10 20:23:25 | stale | 1 | 28756 | 25 | 0.530 | 54256.6 |
723 | 2021-07-09 14:47:18 | stale | 1 | 28756 | 25 | 0.516 | 55728.7 |
722 | 2021-07-06 17:32:55 | stale | 1 | 28756 | 25 | 0.596 | 48248.3 |
721 | 2021-07-05 22:38:20 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
720 | 2021-07-02 21:01:22 | stale | 1 | 28756 | 25 | 0.546 | 52666.7 |
719 | 2021-06-29 08:59:59 | stale | 1 | 28756 | 25 | 0.593 | 48492.4 |
718 | 2021-06-28 21:41:29 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
717 | 2021-06-28 01:12:10 | stale | 1 | 28756 | 25 | 0.530 | 54256.6 |
716 | 2021-06-25 10:00:15 | stale | 1 | 28756 | 25 | 0.513 | 56054.6 |
715 | 2021-06-24 05:32:06 | stale | 1 | 28756 | 25 | 0.533 | 53951.2 |
714 | 2021-06-23 00:40:36 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
713 | 2021-06-21 20:04:29 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
712 | 2021-06-20 16:55:21 | stale | 1 | 28756 | 25 | 0.483 | 59536.2 |
711 | 2021-06-19 11:55:01 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
710 | 2021-06-18 07:28:26 | stale | 1 | 28756 | 25 | 0.436 | 65954.1 |
709 | 2021-06-17 02:53:46 | stale | 1 | 28756 | 25 | 0.533 | 53951.2 |
708 | 2021-06-16 20:20:25 | stale | 1 | 28756 | 25 | 0.530 | 54256.6 |
707 | 2021-06-15 20:27:15 | stale | 1 | 28756 | 25 | 0.440 | 65354.5 |
706 | 2021-06-14 18:38:30 | stale | 1 | 28756 | 25 | 0.500 | 57512.0 |
705 | 2021-06-13 20:11:33 | stale | 1 | 28756 | 25 | 0.453 | 63479.0 |
704 | 2021-06-13 15:32:28 | stale | 1 | 28756 | 25 | 0.513 | 56054.6 |