History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"avail"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
854 | 2024-04-07 09:00:15 | avail | 1 | 28756 | 3 | 2.110 | 13628.4 |
853 | 2024-04-06 05:56:30 | avail | 1 | 28756 | 3 | 0.530 | 54256.6 |
852 | 2024-03-30 22:01:52 | avail | 2 | 53800 | 65 | 1.890 | 28465.6 |
851 | 2024-03-30 22:00:55 | avail | 1 | 28756 | 3 | 0.440 | 65354.5 |
850 | 2024-03-29 10:14:10 | avail | 3 | 83667 | 741 | 3.873 | 21602.6 |
849 | 2024-03-29 10:14:03 | avail | 2 | 53800 | 65 | 1.533 | 35094.6 |
848 | 2024-03-29 10:13:57 | avail | 1 | 28756 | 3 | 0.516 | 55728.7 |
847 | 2024-03-27 04:46:07 | avail | 3 | 83667 | 741 | 3.966 | 21096.1 |
846 | 2024-03-13 01:00:39 | avail | 3 | 83667 | 741 | 10.030 | 8341.7 |
845 | 2024-03-10 18:03:41 | avail | 3 | 83667 | 741 | 16.156 | 5178.7 |
844 | 2024-03-10 09:55:29 | avail | 3 | 83667 | 741 | 13.360 | 6262.5 |
843 | 2024-03-08 21:50:13 | avail | 2 | 53800 | 65 | 1.733 | 31044.4 |
842 | 2024-03-08 21:49:44 | avail | 1 | 28756 | 3 | 1.576 | 18246.2 |
841 | 2024-03-08 21:49:36 | avail | 2 | 53800 | 65 | 1.736 | 30990.8 |
840 | 2024-03-08 21:49:07 | avail | 3 | 83667 | 741 | 4.390 | 19058.5 |
839 | 2024-03-08 18:54:53 | avail | 3 | 83667 | 741 | 9.703 | 8622.8 |
838 | 2024-03-07 08:42:32 | avail | 3 | 83667 | 741 | 11.186 | 7479.6 |
837 | 2024-03-07 08:42:33 | avail | 2 | 53800 | 65 | 1.983 | 27130.6 |
836 | 2024-03-07 03:52:41 | avail | 1 | 28756 | 3 | 0.546 | 52666.7 |
835 | 2024-02-28 07:17:37 | avail | 1 | 28756 | 3 | 0.983 | 29253.3 |
834 | 2024-02-03 19:35:55 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
833 | 2024-01-29 03:43:47 | avail | 1 | 28756 | 3 | 0.533 | 53951.2 |
832 | 2024-01-29 02:30:01 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
831 | 2024-01-18 09:52:24 | avail | 1 | 28756 | 3 | 0.516 | 55728.7 |
830 | 2024-01-12 10:15:38 | avail | 2 | 53800 | 65 | 1.406 | 38264.6 |
829 | 2024-01-11 14:39:38 | avail | 3 | 83667 | 741 | 3.500 | 23904.9 |
828 | 2023-12-31 20:31:32 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
827 | 2023-12-19 01:00:15 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
826 | 2023-12-17 01:47:43 | avail | 3 | 83667 | 741 | 4.296 | 19475.6 |
825 | 2023-12-17 01:47:44 | avail | 2 | 53800 | 65 | 1.780 | 30224.7 |
824 | 2023-11-25 03:21:35 | avail | 1 | 28756 | 3 | 0.593 | 48492.4 |
823 | 2023-11-16 22:01:49 | avail | 1 | 28756 | 3 | 0.533 | 53951.2 |
822 | 2023-11-11 22:12:14 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
821 | 2023-11-03 11:22:30 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
820 | 2023-10-20 14:16:39 | avail | 1 | 28756 | 3 | 0.440 | 65354.5 |
819 | 2023-10-20 07:28:39 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
818 | 2023-10-18 19:41:05 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
817 | 2023-10-11 12:42:24 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
816 | 2023-10-07 16:44:48 | avail | 1 | 28756 | 3 | 0.486 | 59168.7 |
815 | 2023-10-04 22:38:51 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
814 | 2023-10-02 07:50:39 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
813 | 2023-09-26 13:36:41 | avail | 1 | 28756 | 3 | 0.530 | 54256.6 |
812 | 2023-09-22 12:24:12 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
811 | 2023-08-15 02:52:42 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
810 | 2023-07-11 17:38:20 | avail | 3 | 83667 | 741 | 3.356 | 24930.6 |
809 | 2023-07-01 09:29:54 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
808 | 2023-05-17 05:11:45 | avail | 1 | 28756 | 3 | 0.486 | 59168.7 |
807 | 2023-03-31 13:11:23 | avail | 3 | 83667 | 741 | 3.423 | 24442.6 |
806 | 2023-03-28 15:26:41 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
805 | 2023-03-26 23:53:27 | avail | 1 | 28756 | 3 | 0.483 | 59536.2 |
804 | 2023-03-12 23:38:06 | avail | 1 | 28756 | 3 | 0.873 | 32939.3 |
803 | 2023-03-02 22:45:53 | avail | 1 | 28756 | 3 | 0.440 | 65354.5 |
802 | 2023-01-02 07:23:55 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
801 | 2022-12-23 10:58:29 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
800 | 2022-12-19 20:29:27 | avail | 1 | 28756 | 3 | 0.486 | 59168.7 |
799 | 2022-09-23 11:26:35 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
798 | 2022-09-05 16:30:04 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
797 | 2022-05-17 16:24:20 | avail | 1 | 28756 | 3 | 0.703 | 40904.7 |
796 | 2022-05-14 03:01:43 | avail | 1 | 28756 | 3 | 0.593 | 48492.4 |
795 | 2022-05-07 20:00:41 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
794 | 2022-02-09 08:36:25 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
793 | 2022-01-24 15:40:59 | avail | 1 | 28756 | 3 | 0.470 | 61183.0 |
792 | 2021-12-15 06:45:02 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
791 | 2021-11-15 23:11:09 | avail | 1 | 28756 | 3 | 0.470 | 61183.0 |
790 | 2021-11-05 03:22:35 | avail | 1 | 28756 | 3 | 1.030 | 27918.4 |
789 | 2021-10-01 16:21:34 | avail | 1 | 28756 | 3 | 0.970 | 29645.4 |
788 | 2021-09-14 13:42:44 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
787 | 2021-08-05 09:23:10 | avail | 1 | 28756 | 3 | 0.546 | 52666.7 |
786 | 2021-05-22 01:59:31 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
785 | 2021-05-01 07:09:18 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
784 | 2021-04-22 21:10:16 | avail | 1 | 28756 | 3 | 0.640 | 44931.3 |
783 | 2021-04-04 02:24:54 | avail | 3 | 83667 | 741 | 3.483 | 24021.5 |
782 | 2021-03-25 02:59:21 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
781 | 2021-03-08 12:21:40 | avail | 3 | 83667 | 741 | 4.126 | 20278.0 |
780 | 2021-02-13 08:15:39 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
779 | 2021-02-04 23:08:12 | avail | 3 | 83667 | 741 | 3.516 | 23796.1 |
778 | 2021-01-28 20:09:00 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
777 | 2021-01-26 16:03:27 | avail | 1 | 28756 | 3 | 0.450 | 63902.2 |
776 | 2021-01-20 14:47:01 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
775 | 2021-01-08 01:24:33 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
774 | 2020-10-26 00:47:52 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
773 | 2020-10-18 10:47:42 | avail | 3 | 83667 | 741 | 3.470 | 24111.5 |
772 | 2020-10-05 19:04:19 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
771 | 2020-09-14 21:09:52 | avail | 1 | 28756 | 3 | 0.436 | 65954.1 |
770 | 2020-09-05 22:26:35 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
769 | 2020-08-31 10:05:52 | avail | 1 | 28756 | 3 | 0.483 | 59536.2 |
768 | 2020-08-22 13:21:19 | avail | 1 | 28756 | 3 | 0.453 | 63479.0 |
767 | 2020-07-30 18:56:51 | avail | 1 | 28756 | 3 | 0.546 | 52666.7 |
766 | 2020-07-22 11:03:15 | avail | 1 | 28756 | 3 | 0.513 | 56054.6 |
765 | 2020-07-20 00:40:12 | avail | 1 | 28756 | 3 | 0.466 | 61708.2 |
764 | 2020-07-12 10:06:58 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
763 | 2020-04-20 12:58:10 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |
762 | 2020-04-18 06:21:27 | avail | 1 | 28756 | 3 | 0.530 | 54256.6 |
761 | 2020-04-17 06:24:48 | avail | 1 | 28756 | 3 | 0.563 | 51076.4 |
760 | 2020-04-17 02:12:45 | avail | 1 | 28756 | 3 | 0.546 | 52666.7 |
759 | 2020-04-16 07:07:03 | avail | 1 | 28756 | 3 | 0.516 | 55728.7 |
758 | 2020-04-15 06:27:39 | avail | 1 | 28756 | 3 | 0.516 | 55728.7 |
757 | 2020-03-29 23:06:25 | avail | 1 | 28756 | 3 | 0.513 | 56054.6 |
756 | 2020-03-29 01:00:49 | avail | 3 | 83667 | 741 | 4.220 | 19826.3 |
755 | 2020-03-26 19:20:48 | avail | 1 | 28756 | 3 | 0.500 | 57512.0 |