History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clean"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
849 | 2024-05-04 11:46:47 | clean | 1 | 28756 | 7 | 0.626 | 45936.1 |
848 | 2024-04-26 07:02:09 | clean | 1 | 28756 | 7 | 1.093 | 26309.2 |
847 | 2024-04-25 03:34:30 | clean | 1 | 28756 | 7 | 1.310 | 21951.1 |
846 | 2024-04-22 16:37:36 | clean | 1 | 28756 | 7 | 0.736 | 39070.7 |
845 | 2024-04-20 18:52:59 | clean | 1 | 28756 | 7 | 1.673 | 17188.3 |
844 | 2024-04-13 04:38:51 | clean | 2 | 53800 | 98 | 1.670 | 32215.6 |
843 | 2024-04-13 04:38:31 | clean | 3 | 83667 | 1200 | 4.046 | 20678.9 |
842 | 2024-04-10 19:35:21 | clean | 3 | 83667 | 1200 | 4.750 | 17614.1 |
841 | 2024-04-02 22:15:06 | clean | 3 | 83667 | 1200 | 7.373 | 11347.8 |
840 | 2024-04-02 21:47:59 | clean | 2 | 53800 | 98 | 1.563 | 34421.0 |
839 | 2024-04-02 21:47:54 | clean | 1 | 28756 | 7 | 0.470 | 61183.0 |
838 | 2024-03-30 22:03:17 | clean | 1 | 28756 | 7 | 0.546 | 52666.7 |
837 | 2024-03-29 02:24:55 | clean | 1 | 28756 | 7 | 0.440 | 65354.5 |
836 | 2024-03-17 14:08:14 | clean | 3 | 83667 | 1200 | 8.813 | 9493.6 |
835 | 2024-03-17 14:08:22 | clean | 1 | 28756 | 7 | 0.546 | 52666.7 |
834 | 2024-03-17 14:08:14 | clean | 2 | 53800 | 98 | 2.250 | 23911.1 |
833 | 2024-03-17 14:08:07 | clean | 1 | 28756 | 7 | 0.513 | 56054.6 |
832 | 2024-03-06 00:06:38 | clean | 1 | 28756 | 7 | 1.500 | 19170.7 |
831 | 2024-03-05 18:27:17 | clean | 3 | 83667 | 1200 | 9.330 | 8967.5 |
830 | 2024-03-04 16:42:35 | clean | 3 | 83667 | 1200 | 9.500 | 8807.1 |
829 | 2024-03-03 13:41:39 | clean | 2 | 53800 | 98 | 1.623 | 33148.5 |
828 | 2024-03-03 13:41:03 | clean | 3 | 83667 | 1200 | 5.110 | 16373.2 |
827 | 2024-03-03 13:27:08 | clean | 3 | 83667 | 1200 | 3.500 | 23904.9 |
826 | 2024-02-27 20:31:33 | clean | 1 | 28756 | 7 | 0.423 | 67981.1 |
825 | 2024-02-13 13:02:44 | clean | 1 | 28756 | 7 | 1.046 | 27491.4 |
824 | 2024-02-08 07:52:35 | clean | 3 | 83667 | 1200 | 4.893 | 17099.3 |
823 | 2024-02-07 14:54:57 | clean | 3 | 83667 | 1200 | 4.283 | 19534.7 |
822 | 2024-02-07 14:54:53 | clean | 2 | 53800 | 98 | 1.673 | 32157.8 |
821 | 2024-01-28 23:48:57 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
820 | 2024-01-15 13:39:38 | clean | 1 | 28756 | 7 | 0.470 | 61183.0 |
819 | 2024-01-10 08:23:56 | clean | 1 | 28756 | 7 | 0.500 | 57512.0 |
818 | 2024-01-02 11:54:55 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
817 | 2023-12-15 22:39:30 | clean | 1 | 28756 | 7 | 0.513 | 56054.6 |
816 | 2023-12-15 11:05:20 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
815 | 2023-11-28 01:00:06 | clean | 3 | 83667 | 1200 | 3.596 | 23266.7 |
814 | 2023-11-25 16:51:38 | clean | 3 | 83667 | 1200 | 3.910 | 21398.2 |
813 | 2023-11-22 17:05:02 | clean | 2 | 53800 | 98 | 1.423 | 37807.4 |
812 | 2023-11-12 04:43:47 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
811 | 2023-11-10 20:37:22 | clean | 3 | 83667 | 1200 | 3.843 | 21771.3 |
810 | 2023-11-09 18:46:28 | clean | 3 | 83667 | 1200 | 3.406 | 24564.6 |
809 | 2023-11-09 15:45:08 | clean | 1 | 28756 | 7 | 0.440 | 65354.5 |
808 | 2023-11-09 13:24:59 | clean | 2 | 53800 | 98 | 1.360 | 39558.8 |
807 | 2023-11-07 13:47:22 | clean | 3 | 83667 | 1200 | 3.953 | 21165.4 |
806 | 2023-11-07 09:20:10 | clean | 3 | 83667 | 1200 | 4.060 | 20607.6 |
805 | 2023-11-06 22:15:46 | clean | 3 | 83667 | 1200 | 3.750 | 22311.2 |
804 | 2023-11-06 22:15:37 | clean | 2 | 53800 | 98 | 1.390 | 38705.0 |
803 | 2023-11-03 13:54:27 | clean | 1 | 28756 | 7 | 0.486 | 59168.7 |
802 | 2023-10-24 13:02:27 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
801 | 2023-10-21 07:49:15 | clean | 1 | 28756 | 7 | 0.920 | 31256.5 |
800 | 2023-10-18 16:20:51 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
799 | 2023-10-11 07:34:53 | clean | 1 | 28756 | 7 | 0.503 | 57169.0 |
798 | 2023-10-08 09:53:14 | clean | 1 | 28756 | 7 | 0.466 | 61708.2 |
797 | 2023-10-07 10:32:48 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
796 | 2023-10-04 08:40:06 | clean | 3 | 83667 | 1200 | 5.170 | 16183.2 |
795 | 2023-10-01 01:45:34 | clean | 3 | 83667 | 1200 | 4.280 | 19548.4 |
794 | 2023-09-28 00:38:08 | clean | 3 | 83667 | 1200 | 3.846 | 21754.3 |
793 | 2023-09-28 00:38:09 | clean | 2 | 53800 | 98 | 1.653 | 32546.9 |
792 | 2023-09-25 08:59:08 | clean | 1 | 28756 | 7 | 0.500 | 57512.0 |
791 | 2023-09-21 19:31:15 | clean | 1 | 28756 | 7 | 0.486 | 59168.7 |
790 | 2023-08-29 16:50:30 | clean | 1 | 28756 | 7 | 0.450 | 63902.2 |
789 | 2023-08-25 04:31:24 | clean | 3 | 83667 | 1200 | 3.310 | 25277.0 |
788 | 2023-08-20 02:28:40 | clean | 1 | 28756 | 7 | 0.470 | 61183.0 |
787 | 2023-07-02 04:47:18 | clean | 1 | 28756 | 7 | 0.516 | 55728.7 |
786 | 2023-05-17 19:46:53 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
785 | 2023-05-11 06:12:19 | clean | 3 | 83667 | 1200 | 3.483 | 24021.5 |
784 | 2023-05-01 02:55:18 | clean | 3 | 83667 | 1200 | 3.266 | 25617.6 |
783 | 2023-04-24 01:11:39 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
782 | 2023-04-20 10:33:46 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
781 | 2023-03-31 12:27:16 | clean | 1 | 28756 | 7 | 0.500 | 57512.0 |
780 | 2023-03-22 08:29:43 | clean | 1 | 28756 | 7 | 0.483 | 59536.2 |
779 | 2023-03-13 09:46:28 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
778 | 2023-02-16 08:48:30 | clean | 3 | 83667 | 1200 | 3.220 | 25983.5 |
777 | 2023-01-04 01:14:31 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
776 | 2022-12-17 05:59:03 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
775 | 2022-11-27 05:32:52 | clean | 3 | 83667 | 1200 | 3.750 | 22311.2 |
774 | 2022-10-03 21:25:52 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
773 | 2022-09-28 06:20:59 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
772 | 2022-09-23 06:01:22 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
771 | 2022-09-03 03:03:18 | clean | 1 | 28756 | 7 | 0.516 | 55728.7 |
770 | 2022-09-02 00:38:16 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
769 | 2022-08-30 21:21:03 | clean | 1 | 28756 | 7 | 0.453 | 63479.0 |
768 | 2022-08-15 18:24:15 | clean | 1 | 28756 | 7 | 0.483 | 59536.2 |
767 | 2022-08-15 05:14:39 | clean | 1 | 28756 | 7 | 0.440 | 65354.5 |
766 | 2022-07-29 12:33:57 | clean | 1 | 28756 | 7 | 0.486 | 59168.7 |
765 | 2022-07-29 01:09:50 | clean | 1 | 28756 | 7 | 0.466 | 61708.2 |
764 | 2022-07-06 00:05:26 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
763 | 2022-07-05 01:47:36 | clean | 3 | 83667 | 1200 | 3.266 | 25617.6 |
762 | 2022-05-18 19:03:42 | clean | 1 | 28756 | 7 | 0.530 | 54256.6 |
761 | 2022-05-14 22:50:56 | clean | 1 | 28756 | 7 | 0.466 | 61708.2 |
760 | 2022-05-07 12:14:27 | clean | 3 | 83667 | 1200 | 3.423 | 24442.6 |
759 | 2022-05-05 11:05:42 | clean | 1 | 28756 | 7 | 0.546 | 52666.7 |
758 | 2022-03-03 11:16:44 | clean | 3 | 83667 | 1200 | 3.890 | 21508.2 |
757 | 2022-02-06 17:12:51 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
756 | 2022-01-24 10:20:06 | clean | 1 | 28756 | 7 | 0.513 | 56054.6 |
755 | 2021-11-21 23:15:11 | clean | 1 | 28756 | 7 | 0.436 | 65954.1 |
754 | 2021-11-08 09:57:04 | clean | 1 | 28756 | 7 | 0.483 | 59536.2 |
753 | 2021-11-07 11:23:02 | clean | 1 | 28756 | 7 | 1.000 | 28756.0 |
752 | 2021-11-07 09:51:48 | clean | 1 | 28756 | 7 | 0.456 | 63061.4 |
751 | 2021-11-07 00:34:14 | clean | 1 | 28756 | 7 | 0.423 | 67981.1 |
750 | 2021-11-06 16:26:27 | clean | 1 | 28756 | 7 | 0.516 | 55728.7 |