History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substances"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
185 | 2024-04-27 08:45:12 | substances | 1 | 67641 | 2 | 1.483 | 45610.9 |
184 | 2024-04-15 21:12:46 | substances | 1 | 67641 | 2 | 1.216 | 55625.8 |
183 | 2024-04-09 23:53:02 | substances | 3 | 140603 | 34 | 8.796 | 15984.9 |
182 | 2024-04-08 17:24:58 | substances | 3 | 140603 | 34 | 20.300 | 6926.3 |
181 | 2024-04-08 00:41:52 | substances | 4 | 161450 | 229 | 35.626 | 4531.8 |
180 | 2024-04-06 21:08:31 | substances | 4 | 161450 | 229 | 37.876 | 4262.6 |
179 | 2024-04-06 09:13:09 | substances | 4 | 161450 | 229 | 35.206 | 4585.9 |
178 | 2024-04-06 09:13:14 | substances | 3 | 140603 | 34 | 11.736 | 11980.5 |
177 | 2024-04-06 09:13:09 | substances | 2 | 108824 | 5 | 11.626 | 9360.4 |
176 | 2024-04-06 06:55:46 | substances | 1 | 67641 | 2 | 2.186 | 30942.8 |
175 | 2024-03-30 14:54:11 | substances | 1 | 67641 | 2 | 1.280 | 52844.5 |
174 | 2024-03-13 20:16:12 | substances | 3 | 140603 | 34 | 7.750 | 18142.3 |
173 | 2024-03-11 13:14:03 | substances | 2 | 108824 | 5 | 7.423 | 14660.4 |
172 | 2024-03-11 13:09:32 | substances | 1 | 67641 | 2 | 2.610 | 25916.1 |
171 | 2024-03-11 02:07:09 | substances | 1 | 67641 | 2 | 1.186 | 57032.9 |
170 | 2024-03-06 01:40:29 | substances | 3 | 140603 | 34 | 21.640 | 6497.4 |
169 | 2024-03-06 01:40:29 | substances | 2 | 108824 | 5 | 8.813 | 12348.1 |
168 | 2024-03-05 22:40:59 | substances | 3 | 140603 | 34 | 21.000 | 6695.4 |
167 | 2024-03-05 22:40:59 | substances | 2 | 108824 | 5 | 10.936 | 9951.0 |
166 | 2024-03-05 22:40:11 | substances | 1 | 67641 | 2 | 1.343 | 50365.6 |
165 | 2024-03-05 22:15:54 | substances | 4 | 161450 | 229 | 15.626 | 10332.1 |
164 | 2024-02-27 19:11:59 | substances | 4 | 161450 | 229 | 10.970 | 14717.4 |
163 | 2024-02-24 21:40:19 | substances | 3 | 140603 | 34 | 7.296 | 19271.2 |
162 | 2024-02-24 19:43:19 | substances | 4 | 161450 | 229 | 13.343 | 12100.0 |
161 | 2024-02-22 03:53:59 | substances | 4 | 161450 | 229 | 15.826 | 10201.6 |
160 | 2024-02-21 07:43:43 | substances | 4 | 161450 | 229 | 29.173 | 5534.2 |
159 | 2024-02-21 07:43:43 | substances | 3 | 140603 | 34 | 18.050 | 7789.6 |
158 | 2024-02-21 07:43:46 | substances | 2 | 108824 | 5 | 4.423 | 24604.1 |
157 | 2024-02-05 02:34:43 | substances | 1 | 67641 | 2 | 2.500 | 27056.4 |
156 | 2024-02-04 07:13:06 | substances | 1 | 67641 | 2 | 1.046 | 64666.3 |
155 | 2024-02-04 07:13:02 | substances | 1 | 67641 | 2 | 1.203 | 56226.9 |
154 | 2024-01-29 13:18:21 | substances | 1 | 67641 | 2 | 1.186 | 57032.9 |
153 | 2024-01-20 15:14:12 | substances | 1 | 67641 | 2 | 1.156 | 58513.0 |
152 | 2024-01-04 13:50:01 | substances | 1 | 67641 | 2 | 1.046 | 64666.3 |
151 | 2024-01-04 13:23:20 | substances | 2 | 108824 | 5 | 3.110 | 34991.6 |
150 | 2023-12-06 09:57:57 | substances | 1 | 67641 | 2 | 1.033 | 65480.2 |
149 | 2023-11-21 03:28:32 | substances | 4 | 161450 | 229 | 9.346 | 17274.8 |
148 | 2023-11-17 04:51:59 | substances | 1 | 67641 | 2 | 1.140 | 59334.2 |
147 | 2023-10-25 09:35:42 | substances | 1 | 67641 | 2 | 1.080 | 62630.6 |
146 | 2023-10-10 15:03:35 | substances | 2 | 108824 | 5 | 2.593 | 41968.4 |
145 | 2023-10-06 11:33:49 | substances | 1 | 67641 | 2 | 1.046 | 64666.3 |
144 | 2023-09-04 17:11:04 | substances | 1 | 67641 | 2 | 1.013 | 66773.0 |
143 | 2023-08-22 11:45:39 | substances | 4 | 161450 | 229 | 9.203 | 17543.2 |
142 | 2023-08-04 00:39:57 | substances | 4 | 161450 | 229 | 9.266 | 17423.9 |
141 | 2023-07-20 07:29:28 | substances | 2 | 108824 | 5 | 2.983 | 36481.4 |
140 | 2023-06-20 05:50:37 | substances | 4 | 161450 | 229 | 10.046 | 16071.1 |
139 | 2023-05-04 17:30:43 | substances | 4 | 161450 | 229 | 9.266 | 17423.9 |
138 | 2023-04-04 03:22:28 | substances | 2 | 108824 | 5 | 2.563 | 42459.6 |
137 | 2023-03-29 10:02:52 | substances | 1 | 67641 | 2 | 1.013 | 66773.0 |
136 | 2023-02-09 16:07:31 | substances | 4 | 161450 | 229 | 11.313 | 14271.2 |
135 | 2023-01-12 02:45:53 | substances | 1 | 67641 | 2 | 1.140 | 59334.2 |
134 | 2022-12-29 07:18:29 | substances | 2 | 108824 | 5 | 2.923 | 37230.2 |
133 | 2022-11-22 15:31:29 | substances | 4 | 161450 | 229 | 9.390 | 17193.8 |
132 | 2022-10-29 04:21:29 | substances | 1 | 67641 | 2 | 1.033 | 65480.2 |
131 | 2022-09-01 04:51:46 | substances | 2 | 108824 | 5 | 2.626 | 41441.0 |
130 | 2022-06-18 01:17:58 | substances | 1 | 67641 | 2 | 1.123 | 60232.4 |
129 | 2022-06-15 17:58:08 | substances | 1 | 67641 | 2 | 1.156 | 58513.0 |
128 | 2022-05-09 01:41:56 | substances | 4 | 161450 | 229 | 9.283 | 17392.0 |
127 | 2022-05-06 21:41:16 | substances | 4 | 161450 | 229 | 11.126 | 14511.1 |
126 | 2022-02-21 03:02:44 | substances | 1 | 67641 | 2 | 1.046 | 64666.3 |
125 | 2022-01-06 12:41:47 | substances | 4 | 161450 | 229 | 10.940 | 14757.8 |
124 | 2021-12-10 07:43:40 | substances | 1 | 67641 | 2 | 1.236 | 54725.7 |
123 | 2021-11-05 00:18:39 | substances | 1 | 67641 | 2 | 1.046 | 64666.3 |
122 | 2021-11-02 22:39:02 | substances | 1 | 67641 | 2 | 1.186 | 57032.9 |
121 | 2021-04-08 19:21:48 | substances | 1 | 67641 | 2 | 1.170 | 57812.8 |
120 | 2021-02-16 08:58:55 | substances | 1 | 67641 | 2 | 1.046 | 64666.3 |
119 | 2020-10-28 07:29:34 | substances | 1 | 67641 | 2 | 2.233 | 30291.5 |
118 | 2020-08-28 22:44:48 | substances | 1 | 67641 | 2 | 1.156 | 58513.0 |
117 | 2020-05-23 12:46:37 | substances | 1 | 67641 | 2 | 1.080 | 62630.6 |
116 | 2020-03-24 02:34:29 | substances | 1 | 67641 | 2 | 1.156 | 58513.0 |
115 | 2020-03-14 19:49:47 | substances | 1 | 67641 | 2 | 1.060 | 63812.3 |
114 | 2020-03-07 10:02:12 | substances | 1 | 67641 | 2 | 1.170 | 57812.8 |
113 | 2020-02-29 11:46:56 | substances | 1 | 67641 | 2 | 1.236 | 54725.7 |
112 | 2020-02-29 09:16:11 | substances | 1 | 67641 | 2 | 1.173 | 57665.0 |
111 | 2020-02-27 07:06:04 | substances | 1 | 67641 | 2 | 1.220 | 55443.4 |
110 | 2020-02-26 04:33:14 | substances | 1 | 67641 | 2 | 1.140 | 59334.2 |
109 | 2020-02-09 00:53:37 | substances | 1 | 67641 | 2 | 1.346 | 50253.3 |
108 | 2020-02-08 20:50:52 | substances | 1 | 67641 | 2 | 2.436 | 27767.2 |
107 | 2020-02-06 00:33:07 | substances | 1 | 67641 | 2 | 1.203 | 56226.9 |
106 | 2020-01-30 21:19:16 | substances | 1 | 67641 | 2 | 2.110 | 32057.3 |
105 | 2020-01-28 15:47:48 | substances | 1 | 67641 | 2 | 1.236 | 54725.7 |
104 | 2020-01-26 20:09:58 | substances | 1 | 67641 | 2 | 1.123 | 60232.4 |
103 | 2020-01-18 04:40:39 | substances | 1 | 67641 | 2 | 2.563 | 26391.3 |
102 | 2020-01-15 18:59:17 | substances | 1 | 67641 | 2 | 1.233 | 54858.9 |
101 | 2020-01-11 03:42:37 | substances | 1 | 67641 | 2 | 1.406 | 48108.8 |
100 | 2020-01-03 17:30:46 | substances | 1 | 67641 | 2 | 1.016 | 66575.8 |
99 | 2019-12-31 11:34:31 | substances | 1 | 67641 | 2 | 1.203 | 56226.9 |
98 | 2019-12-11 23:25:56 | substances | 1 | 67641 | 2 | 1.016 | 66575.8 |
97 | 2019-09-10 05:35:54 | substances | 1 | 67641 | 2 | 1.096 | 61716.2 |
96 | 2019-07-25 12:22:11 | substances | 1 | 67641 | 2 | 0.973 | 69518.0 |
95 | 2019-06-04 09:24:04 | substances | 1 | 67641 | 2 | 1.123 | 60232.4 |
94 | 2019-02-20 14:42:32 | substances | 1 | 67641 | 2 | 1.000 | 67641.0 |
93 | 2019-02-13 21:29:11 | substances | 1 | 67641 | 2 | 1.013 | 66773.0 |
92 | 2019-02-13 16:05:40 | substances | 1 | 67641 | 2 | 1.780 | 38000.6 |
91 | 2019-01-20 09:36:12 | substances | 1 | 67641 | 2 | 0.996 | 67912.7 |
90 | 2018-11-24 20:06:31 | substances | 1 | 67641 | 2 | 1.106 | 61158.2 |
89 | 2018-10-19 08:35:05 | substances | 1 | 67641 | 2 | 1.120 | 60393.8 |
88 | 2018-10-08 18:11:07 | substances | 1 | 67641 | 2 | 1.243 | 54417.5 |
87 | 2018-10-04 23:40:09 | substances | 1 | 67641 | 2 | 1.133 | 59700.8 |
86 | 2018-09-29 15:02:08 | substances | 1 | 67641 | 2 | 1.033 | 65480.2 |