History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chare"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
817 | 2024-04-10 11:53:14 | chare | 1 | 28756 | 19 | 0.953 | 30174.2 |
816 | 2024-04-04 05:46:35 | chare | 2 | 53800 | 237 | 5.580 | 9641.6 |
815 | 2024-04-04 05:46:27 | chare | 1 | 28756 | 19 | 2.280 | 12612.3 |
814 | 2024-04-04 05:46:17 | chare | 2 | 53800 | 237 | 3.626 | 14837.3 |
813 | 2024-04-03 03:36:07 | chare | 2 | 53800 | 237 | 3.813 | 14109.6 |
812 | 2024-04-03 03:24:37 | chare | 1 | 28756 | 19 | 0.893 | 32201.6 |
811 | 2024-03-31 07:43:01 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
810 | 2024-03-27 01:53:40 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
809 | 2024-03-23 03:16:43 | chare | 1 | 28756 | 19 | 1.736 | 16564.5 |
808 | 2024-03-09 15:56:05 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
807 | 2024-03-07 12:17:50 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
806 | 2024-03-01 07:41:32 | chare | 1 | 28756 | 19 | 1.076 | 26724.9 |
805 | 2024-02-25 17:47:12 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
804 | 2024-01-29 17:16:24 | chare | 1 | 28756 | 19 | 0.513 | 56054.6 |
803 | 2024-01-26 01:22:17 | chare | 1 | 28756 | 19 | 0.550 | 52283.6 |
802 | 2024-01-08 11:17:39 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
801 | 2024-01-04 18:20:48 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
800 | 2023-12-24 16:41:21 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
799 | 2023-12-13 14:55:49 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
798 | 2023-11-27 20:34:47 | chare | 2 | 53800 | 237 | 1.563 | 34421.0 |
797 | 2023-11-25 02:16:48 | chare | 2 | 53800 | 237 | 1.390 | 38705.0 |
796 | 2023-11-17 14:13:45 | chare | 2 | 53800 | 237 | 1.470 | 36598.6 |
795 | 2023-11-14 09:08:31 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
794 | 2023-11-14 08:36:46 | chare | 1 | 28756 | 19 | 0.470 | 61183.0 |
793 | 2023-11-09 15:03:07 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
792 | 2023-11-08 10:20:04 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
791 | 2023-10-28 23:07:40 | chare | 1 | 28756 | 19 | 0.546 | 52666.7 |
790 | 2023-10-28 01:10:13 | chare | 2 | 53800 | 237 | 1.356 | 39675.5 |
789 | 2023-10-27 13:51:17 | chare | 1 | 28756 | 19 | 1.000 | 28756.0 |
788 | 2023-10-26 08:43:12 | chare | 1 | 28756 | 19 | 0.516 | 55728.7 |
787 | 2023-10-19 20:35:45 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
786 | 2023-10-17 22:33:50 | chare | 1 | 28756 | 19 | 0.513 | 56054.6 |
785 | 2023-10-13 19:22:26 | chare | 2 | 53800 | 237 | 1.550 | 34709.7 |
784 | 2023-10-10 16:08:27 | chare | 1 | 28756 | 19 | 0.893 | 32201.6 |
783 | 2023-10-04 08:23:54 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
782 | 2023-09-28 14:16:01 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
781 | 2023-09-27 19:33:57 | chare | 2 | 53800 | 237 | 1.373 | 39184.3 |
780 | 2023-09-25 17:38:15 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
779 | 2023-09-21 15:02:29 | chare | 1 | 28756 | 19 | 0.640 | 44931.3 |
778 | 2023-09-19 18:43:30 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
777 | 2023-07-26 19:48:38 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
776 | 2023-06-18 11:49:31 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
775 | 2023-04-24 10:11:27 | chare | 1 | 28756 | 19 | 0.423 | 67981.1 |
774 | 2023-03-29 19:07:36 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
773 | 2023-03-29 17:37:36 | chare | 1 | 28756 | 19 | 0.440 | 65354.5 |
772 | 2023-03-26 22:44:22 | chare | 1 | 28756 | 19 | 0.450 | 63902.2 |
771 | 2023-03-12 20:25:16 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
770 | 2023-03-12 12:26:07 | chare | 1 | 28756 | 19 | 0.440 | 65354.5 |
769 | 2023-02-16 11:39:15 | chare | 1 | 28756 | 19 | 0.423 | 67981.1 |
768 | 2023-01-17 08:49:55 | chare | 1 | 28756 | 19 | 0.513 | 56054.6 |
767 | 2022-12-14 02:02:11 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
766 | 2022-12-01 07:08:17 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
765 | 2022-11-28 00:12:08 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
764 | 2022-11-25 10:29:53 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
763 | 2022-09-12 09:49:00 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
762 | 2022-09-02 23:39:09 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
761 | 2022-08-20 16:52:32 | chare | 1 | 28756 | 19 | 0.486 | 59168.7 |
760 | 2022-08-17 09:28:25 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
759 | 2022-06-07 14:55:08 | chare | 1 | 28756 | 19 | 0.516 | 55728.7 |
758 | 2022-05-08 09:47:38 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
757 | 2022-04-06 19:41:27 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
756 | 2022-02-03 12:29:58 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
755 | 2022-01-06 06:44:50 | chare | 1 | 28756 | 19 | 0.470 | 61183.0 |
754 | 2021-12-16 19:29:22 | chare | 1 | 28756 | 19 | 1.000 | 28756.0 |
753 | 2021-11-04 13:08:48 | chare | 1 | 28756 | 19 | 0.486 | 59168.7 |
752 | 2021-10-30 08:41:38 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
751 | 2021-09-19 19:52:04 | chare | 1 | 28756 | 19 | 0.533 | 53951.2 |
750 | 2021-08-20 05:24:17 | chare | 1 | 28756 | 19 | 0.470 | 61183.0 |
749 | 2021-08-18 01:16:49 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
748 | 2021-07-30 12:53:23 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
747 | 2021-05-20 10:15:24 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
746 | 2021-04-25 03:29:02 | chare | 1 | 28756 | 19 | 0.513 | 56054.6 |
745 | 2021-02-26 04:17:07 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
744 | 2021-01-24 04:27:32 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
743 | 2021-01-18 01:24:58 | chare | 2 | 53800 | 237 | 1.390 | 38705.0 |
742 | 2020-11-13 19:51:59 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
741 | 2020-11-09 06:22:29 | chare | 1 | 28756 | 19 | 0.610 | 47141.0 |
740 | 2020-10-29 08:34:34 | chare | 2 | 53800 | 237 | 1.376 | 39098.8 |
739 | 2020-10-29 01:34:38 | chare | 1 | 28756 | 19 | 0.466 | 61708.2 |
738 | 2020-10-27 04:13:11 | chare | 1 | 28756 | 19 | 0.486 | 59168.7 |
737 | 2020-10-22 12:17:26 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
736 | 2020-10-20 00:40:27 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
735 | 2020-10-04 21:28:54 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
734 | 2020-09-26 20:29:03 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
733 | 2020-09-25 22:51:19 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
732 | 2020-08-24 00:56:45 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
731 | 2020-07-20 06:24:07 | chare | 1 | 28756 | 19 | 0.533 | 53951.2 |
730 | 2020-06-14 02:48:04 | chare | 1 | 28756 | 19 | 0.546 | 52666.7 |
729 | 2020-06-13 02:08:01 | chare | 1 | 28756 | 19 | 0.513 | 56054.6 |
728 | 2020-06-07 09:55:56 | chare | 1 | 28756 | 19 | 0.533 | 53951.2 |
727 | 2020-06-06 09:50:57 | chare | 1 | 28756 | 19 | 0.450 | 63902.2 |
726 | 2020-06-05 10:00:08 | chare | 1 | 28756 | 19 | 0.500 | 57512.0 |
725 | 2020-06-04 09:53:18 | chare | 1 | 28756 | 19 | 0.486 | 59168.7 |
724 | 2020-06-03 15:42:54 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
723 | 2020-06-03 09:53:57 | chare | 1 | 28756 | 19 | 0.533 | 53951.2 |
722 | 2020-05-31 07:34:23 | chare | 1 | 28756 | 19 | 0.456 | 63061.4 |
721 | 2020-05-30 06:55:14 | chare | 1 | 28756 | 19 | 0.483 | 59536.2 |
720 | 2020-05-26 14:54:00 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |
719 | 2020-05-25 20:05:03 | chare | 1 | 28756 | 19 | 0.453 | 63479.0 |
718 | 2020-05-22 11:27:41 | chare | 1 | 28756 | 19 | 0.436 | 65954.1 |