History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"valve"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
900 | 2024-04-30 11:45:44 | valve | 1 | 28756 | 10 | 0.970 | 29645.4 |
899 | 2024-04-30 11:36:12 | valve | 1 | 28756 | 10 | 0.513 | 56054.6 |
898 | 2024-04-29 21:07:13 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
897 | 2024-04-26 23:14:38 | valve | 1 | 28756 | 10 | 0.736 | 39070.7 |
896 | 2024-04-03 04:58:53 | valve | 1 | 28756 | 10 | 1.140 | 25224.6 |
895 | 2024-03-31 06:58:42 | valve | 1 | 28756 | 10 | 1.423 | 20208.0 |
894 | 2024-03-29 02:59:31 | valve | 1 | 28756 | 10 | 0.500 | 57512.0 |
893 | 2024-03-03 21:17:07 | valve | 1 | 28756 | 10 | 0.906 | 31739.5 |
892 | 2024-03-01 09:40:13 | valve | 2 | 53800 | 93 | 1.860 | 28924.7 |
891 | 2024-03-01 09:40:05 | valve | 3 | 83667 | 1117 | 7.216 | 11594.7 |
890 | 2024-03-01 09:25:13 | valve | 1 | 28756 | 10 | 0.560 | 51350.0 |
889 | 2024-02-27 19:46:43 | valve | 1 | 28756 | 10 | 0.860 | 33437.2 |
888 | 2024-01-23 13:58:46 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
887 | 2023-12-21 17:34:22 | valve | 3 | 83667 | 1117 | 3.766 | 22216.4 |
886 | 2023-12-21 17:34:07 | valve | 2 | 53800 | 93 | 1.563 | 34421.0 |
885 | 2023-12-08 07:17:54 | valve | 1 | 28756 | 10 | 0.466 | 61708.2 |
884 | 2023-12-08 07:17:53 | valve | 1 | 28756 | 10 | 0.470 | 61183.0 |
883 | 2023-12-05 10:48:18 | valve | 3 | 83667 | 1117 | 3.546 | 23594.8 |
882 | 2023-12-05 10:48:17 | valve | 2 | 53800 | 93 | 1.563 | 34421.0 |
881 | 2023-11-21 20:48:13 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
880 | 2023-11-20 21:43:46 | valve | 1 | 28756 | 10 | 0.626 | 45936.1 |
879 | 2023-11-17 13:09:31 | valve | 3 | 83667 | 1117 | 3.326 | 25155.4 |
878 | 2023-11-17 13:09:26 | valve | 2 | 53800 | 93 | 1.483 | 36277.8 |
877 | 2023-11-12 04:32:47 | valve | 1 | 28756 | 10 | 0.486 | 59168.7 |
876 | 2023-11-11 04:39:47 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
875 | 2023-11-03 17:51:37 | valve | 1 | 28756 | 10 | 0.466 | 61708.2 |
874 | 2023-10-21 12:09:25 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
873 | 2023-10-21 02:04:00 | valve | 1 | 28756 | 10 | 1.203 | 23903.6 |
872 | 2023-10-15 04:31:26 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
871 | 2023-10-06 17:26:42 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
870 | 2023-09-26 15:05:27 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
869 | 2023-09-15 09:32:23 | valve | 3 | 83667 | 1117 | 3.360 | 24900.9 |
868 | 2023-09-15 09:32:20 | valve | 2 | 53800 | 93 | 1.376 | 39098.8 |
867 | 2023-09-10 15:19:05 | valve | 1 | 28756 | 10 | 0.440 | 65354.5 |
866 | 2023-09-06 14:41:57 | valve | 1 | 28756 | 10 | 0.486 | 59168.7 |
865 | 2023-07-09 15:07:09 | valve | 1 | 28756 | 10 | 0.500 | 57512.0 |
864 | 2023-06-12 23:27:35 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
863 | 2023-03-30 01:57:46 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
862 | 2023-03-05 21:11:57 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
861 | 2023-01-12 21:12:17 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
860 | 2022-10-25 21:53:17 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
859 | 2022-10-23 09:04:38 | valve | 1 | 28756 | 10 | 0.500 | 57512.0 |
858 | 2022-09-19 23:49:00 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
857 | 2022-09-12 04:08:00 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
856 | 2022-09-01 08:39:03 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
855 | 2022-08-15 09:34:42 | valve | 1 | 28756 | 10 | 0.440 | 65354.5 |
854 | 2022-08-14 02:17:53 | valve | 1 | 28756 | 10 | 0.440 | 65354.5 |
853 | 2022-06-16 10:15:40 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
852 | 2022-06-14 04:51:23 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
851 | 2022-06-03 19:41:49 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
850 | 2022-02-17 10:38:22 | valve | 1 | 28756 | 10 | 0.500 | 57512.0 |
849 | 2022-01-30 13:55:55 | valve | 1 | 28756 | 10 | 0.500 | 57512.0 |
848 | 2021-12-19 13:14:42 | valve | 1 | 28756 | 10 | 0.516 | 55728.7 |
847 | 2021-12-08 19:37:28 | valve | 1 | 28756 | 10 | 0.450 | 63902.2 |
846 | 2021-11-18 05:22:20 | valve | 1 | 28756 | 10 | 0.530 | 54256.6 |
845 | 2021-10-14 02:48:45 | valve | 1 | 28756 | 10 | 0.486 | 59168.7 |
844 | 2021-09-30 22:13:41 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
843 | 2021-09-10 05:28:25 | valve | 1 | 28756 | 10 | 0.470 | 61183.0 |
842 | 2021-09-08 00:32:05 | valve | 1 | 28756 | 10 | 0.530 | 54256.6 |
841 | 2021-08-23 14:17:58 | valve | 1 | 28756 | 10 | 0.440 | 65354.5 |
840 | 2021-08-21 09:35:51 | valve | 1 | 28756 | 10 | 0.500 | 57512.0 |
839 | 2021-07-01 12:47:26 | valve | 1 | 28756 | 10 | 0.516 | 55728.7 |
838 | 2021-05-21 15:38:22 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
837 | 2021-04-22 06:01:24 | valve | 1 | 28756 | 10 | 0.513 | 56054.6 |
836 | 2021-04-12 09:12:11 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
835 | 2021-03-31 15:37:42 | valve | 1 | 28756 | 10 | 0.453 | 63479.0 |
834 | 2021-03-24 14:32:30 | valve | 1 | 28756 | 10 | 0.513 | 56054.6 |
833 | 2021-02-23 17:21:06 | valve | 1 | 28756 | 10 | 0.453 | 63479.0 |
832 | 2021-02-02 23:08:19 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
831 | 2020-12-27 02:25:47 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
830 | 2020-12-09 09:49:49 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
829 | 2020-11-01 17:41:31 | valve | 1 | 28756 | 10 | 0.530 | 54256.6 |
828 | 2020-10-18 00:58:12 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
827 | 2020-10-17 21:11:01 | valve | 1 | 28756 | 10 | 0.453 | 63479.0 |
826 | 2020-10-10 19:33:57 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
825 | 2020-09-23 11:12:51 | valve | 1 | 28756 | 10 | 0.453 | 63479.0 |
824 | 2020-09-16 10:24:38 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
823 | 2020-08-23 22:07:58 | valve | 1 | 28756 | 10 | 0.580 | 49579.3 |
822 | 2020-06-09 09:29:53 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
821 | 2020-06-06 11:21:26 | valve | 1 | 28756 | 10 | 1.030 | 27918.4 |
820 | 2020-06-02 05:10:10 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
819 | 2020-06-01 05:07:02 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
818 | 2020-05-25 08:28:56 | valve | 1 | 28756 | 10 | 0.420 | 68466.7 |
817 | 2020-05-16 14:25:12 | valve | 1 | 28756 | 10 | 0.420 | 68466.7 |
816 | 2020-05-14 11:53:00 | valve | 1 | 28756 | 10 | 0.483 | 59536.2 |
815 | 2020-05-11 05:49:43 | valve | 1 | 28756 | 10 | 0.453 | 63479.0 |
814 | 2020-05-10 05:11:17 | valve | 1 | 28756 | 10 | 0.423 | 67981.1 |
813 | 2020-05-09 05:06:33 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
812 | 2020-05-08 05:11:47 | valve | 1 | 28756 | 10 | 0.440 | 65354.5 |
811 | 2020-05-07 04:32:17 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
810 | 2020-05-06 05:12:38 | valve | 1 | 28756 | 10 | 0.470 | 61183.0 |
809 | 2020-05-05 04:32:30 | valve | 1 | 28756 | 10 | 0.453 | 63479.0 |
808 | 2020-05-03 04:38:55 | valve | 1 | 28756 | 10 | 0.470 | 61183.0 |
807 | 2020-05-02 05:11:06 | valve | 1 | 28756 | 10 | 0.500 | 57512.0 |
806 | 2020-05-01 04:30:52 | valve | 1 | 28756 | 10 | 0.440 | 65354.5 |
805 | 2020-04-30 04:34:06 | valve | 1 | 28756 | 10 | 0.470 | 61183.0 |
804 | 2020-04-29 04:44:17 | valve | 1 | 28756 | 10 | 0.436 | 65954.1 |
803 | 2020-04-22 10:10:21 | valve | 1 | 28756 | 10 | 0.440 | 65354.5 |
802 | 2020-04-18 08:35:08 | valve | 1 | 28756 | 10 | 0.453 | 63479.0 |
801 | 2020-04-17 09:19:28 | valve | 1 | 28756 | 10 | 0.486 | 59168.7 |