History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vent"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
902 | 2024-04-27 06:26:32 | vent | 1 | 13983 | 21 | 0.453 | 30867.5 |
901 | 2024-04-24 16:54:32 | vent | 1 | 13983 | 21 | 0.263 | 53167.3 |
900 | 2024-04-23 02:34:55 | vent | 1 | 13983 | 21 | 0.296 | 47239.9 |
899 | 2024-04-23 02:25:53 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
898 | 2024-04-03 00:55:25 | vent | 2 | 29872 | 258 | 2.216 | 13480.1 |
897 | 2024-04-03 00:38:55 | vent | 1 | 13983 | 21 | 0.483 | 28950.3 |
896 | 2024-04-01 16:00:32 | vent | 1 | 13983 | 21 | 1.063 | 13154.3 |
895 | 2024-03-31 00:47:17 | vent | 2 | 29872 | 258 | 1.593 | 18752.0 |
894 | 2024-03-30 23:39:16 | vent | 1 | 13983 | 21 | 0.563 | 24836.6 |
893 | 2024-03-26 19:04:23 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
892 | 2024-03-16 04:07:47 | vent | 1 | 13983 | 21 | 0.296 | 47239.9 |
891 | 2024-03-03 19:41:27 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
890 | 2024-03-02 14:24:43 | vent | 2 | 29872 | 258 | 1.953 | 15295.4 |
889 | 2024-03-02 13:53:15 | vent | 1 | 13983 | 21 | 0.266 | 52567.7 |
888 | 2024-02-25 16:13:08 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
887 | 2024-02-15 10:46:21 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
886 | 2024-02-03 17:18:06 | vent | 2 | 29872 | 258 | 0.796 | 37527.6 |
885 | 2024-01-28 15:49:19 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
884 | 2024-01-25 23:15:17 | vent | 1 | 13983 | 21 | 0.483 | 28950.3 |
883 | 2023-12-25 03:28:05 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
882 | 2023-12-24 18:00:49 | vent | 2 | 29872 | 258 | 0.720 | 41488.9 |
881 | 2023-12-20 08:22:45 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
880 | 2023-12-08 06:13:13 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
879 | 2023-12-08 06:13:12 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
878 | 2023-12-02 05:56:28 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
877 | 2023-12-01 19:11:52 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
876 | 2023-11-29 11:36:21 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
875 | 2023-11-26 13:40:46 | vent | 2 | 29872 | 258 | 0.736 | 40587.0 |
874 | 2023-11-24 15:09:56 | vent | 2 | 29872 | 258 | 0.720 | 41488.9 |
873 | 2023-11-12 16:30:37 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
872 | 2023-11-09 19:47:33 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
871 | 2023-11-02 06:10:13 | vent | 2 | 29872 | 258 | 0.846 | 35309.7 |
870 | 2023-10-26 02:05:39 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
869 | 2023-10-21 20:07:15 | vent | 2 | 29872 | 258 | 0.876 | 34100.5 |
868 | 2023-10-20 02:08:57 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
867 | 2023-10-17 04:38:19 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
866 | 2023-10-17 00:08:34 | vent | 2 | 29872 | 258 | 0.716 | 41720.7 |
865 | 2023-10-10 22:27:03 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
864 | 2023-10-03 22:01:30 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
863 | 2023-09-22 20:36:48 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
862 | 2023-09-22 19:36:39 | vent | 1 | 13983 | 21 | 0.266 | 52567.7 |
861 | 2023-09-16 18:15:27 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
860 | 2023-08-20 22:12:10 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
859 | 2023-07-02 02:53:39 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
858 | 2023-04-25 21:49:55 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
857 | 2023-04-08 07:02:24 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
856 | 2023-01-22 15:59:52 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
855 | 2022-12-29 15:12:46 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
854 | 2022-11-18 00:46:16 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
853 | 2022-09-19 21:06:50 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
852 | 2022-09-18 15:39:08 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
851 | 2022-09-17 18:04:19 | vent | 1 | 13983 | 21 | 0.200 | 69915.0 |
850 | 2022-09-04 13:23:00 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
849 | 2022-08-14 04:25:18 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
848 | 2022-08-07 03:23:36 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
847 | 2022-07-30 04:09:37 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
846 | 2022-07-17 19:19:31 | vent | 1 | 13983 | 21 | 0.466 | 30006.4 |
845 | 2022-07-10 15:42:54 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
844 | 2022-07-10 05:06:22 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
843 | 2022-06-25 22:55:21 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
842 | 2022-05-09 15:34:54 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
841 | 2022-03-19 05:19:45 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
840 | 2022-03-17 04:31:12 | vent | 1 | 13983 | 21 | 0.263 | 53167.3 |
839 | 2022-02-24 23:32:43 | vent | 1 | 13983 | 21 | 0.343 | 40766.8 |
838 | 2022-02-21 23:02:30 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
837 | 2022-02-19 23:43:44 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
836 | 2022-02-18 22:33:17 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
835 | 2022-02-10 14:34:00 | vent | 1 | 13983 | 21 | 0.280 | 49939.3 |
834 | 2022-02-09 23:29:04 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
833 | 2022-02-08 23:28:51 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
832 | 2022-01-21 14:36:45 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
831 | 2022-01-18 08:13:12 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
830 | 2022-01-15 01:21:47 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
829 | 2022-01-11 18:56:40 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
828 | 2021-12-27 07:35:35 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
827 | 2021-11-28 17:13:08 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
826 | 2021-11-22 18:07:40 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
825 | 2021-11-15 03:39:57 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
824 | 2021-11-15 03:38:07 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
823 | 2021-11-14 04:37:57 | vent | 1 | 13983 | 21 | 0.266 | 52567.7 |
822 | 2021-11-13 04:04:54 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
821 | 2021-11-12 07:57:58 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
820 | 2021-11-11 06:23:57 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
819 | 2021-10-25 22:51:07 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
818 | 2021-10-02 09:34:33 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
817 | 2021-09-29 04:21:52 | vent | 1 | 13983 | 21 | 0.203 | 68881.8 |
816 | 2021-09-11 22:04:59 | vent | 1 | 13983 | 21 | 0.216 | 64736.1 |
815 | 2021-08-23 03:05:11 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
814 | 2021-06-26 03:35:05 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
813 | 2021-06-22 21:15:05 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
812 | 2021-06-16 21:48:10 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
811 | 2021-06-15 03:39:52 | vent | 1 | 13983 | 21 | 0.236 | 59250.0 |
810 | 2021-06-14 04:13:40 | vent | 1 | 13983 | 21 | 0.220 | 63559.1 |
809 | 2021-05-23 10:59:00 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
808 | 2021-05-22 17:00:59 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
807 | 2021-05-21 20:03:41 | vent | 1 | 13983 | 21 | 0.250 | 55932.0 |
806 | 2021-04-06 15:09:58 | vent | 1 | 13983 | 21 | 0.300 | 46610.0 |
805 | 2021-04-05 11:10:01 | vent | 1 | 13983 | 21 | 0.280 | 49939.3 |
804 | 2021-04-04 12:36:25 | vent | 1 | 13983 | 21 | 0.233 | 60012.9 |
803 | 2021-03-20 17:18:09 | vent | 1 | 13983 | 21 | 0.486 | 28771.6 |