History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"valerate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
271 | 2024-04-01 01:25:28 | valerate | 3 | 146162 | 158 | 22.986 | 6358.7 |
270 | 2024-04-01 01:25:31 | valerate | 2 | 121059 | 15 | 8.063 | 15014.1 |
269 | 2024-03-30 07:43:00 | valerate | 3 | 146162 | 158 | 10.826 | 13501.0 |
268 | 2024-03-30 07:42:55 | valerate | 2 | 121059 | 15 | 4.360 | 27765.8 |
267 | 2024-03-30 07:22:56 | valerate | 1 | 82945 | 2 | 1.800 | 46080.6 |
266 | 2024-03-28 13:56:22 | valerate | 1 | 82945 | 2 | 1.330 | 62364.7 |
265 | 2024-03-10 15:57:30 | valerate | 3 | 146162 | 158 | 15.876 | 9206.5 |
264 | 2024-03-10 15:57:30 | valerate | 2 | 121059 | 15 | 7.923 | 15279.4 |
263 | 2024-03-10 15:57:28 | valerate | 1 | 82945 | 2 | 2.343 | 35401.2 |
262 | 2024-03-07 14:14:05 | valerate | 2 | 121059 | 15 | 3.813 | 31749.0 |
261 | 2024-03-07 13:13:51 | valerate | 3 | 146162 | 158 | 8.156 | 17920.8 |
260 | 2024-03-07 12:43:21 | valerate | 1 | 82945 | 2 | 1.266 | 65517.4 |
259 | 2024-03-06 02:26:45 | valerate | 3 | 146162 | 158 | 29.080 | 5026.2 |
258 | 2024-03-04 11:00:54 | valerate | 2 | 121059 | 15 | 7.236 | 16730.1 |
257 | 2024-03-04 11:00:49 | valerate | 1 | 82945 | 2 | 1.530 | 54212.4 |
256 | 2024-03-04 11:00:35 | valerate | 3 | 146162 | 158 | 7.610 | 19206.6 |
255 | 2024-03-01 23:13:19 | valerate | 3 | 146162 | 158 | 8.076 | 18098.3 |
254 | 2024-03-01 23:13:18 | valerate | 2 | 121059 | 15 | 3.656 | 33112.4 |
253 | 2024-03-01 23:13:16 | valerate | 1 | 82945 | 2 | 1.406 | 58993.6 |
252 | 2024-02-29 00:34:15 | valerate | 1 | 82945 | 2 | 1.436 | 57761.1 |
251 | 2024-02-09 16:46:36 | valerate | 1 | 82945 | 2 | 1.516 | 54713.1 |
250 | 2024-02-09 09:00:35 | valerate | 3 | 146162 | 158 | 9.580 | 15257.0 |
249 | 2024-02-09 09:00:34 | valerate | 2 | 121059 | 15 | 5.720 | 21164.2 |
248 | 2024-02-09 09:00:31 | valerate | 1 | 82945 | 2 | 1.406 | 58993.6 |
247 | 2024-01-29 23:43:34 | valerate | 1 | 82945 | 2 | 1.516 | 54713.1 |
246 | 2024-01-18 20:36:31 | valerate | 1 | 82945 | 2 | 1.453 | 57085.3 |
245 | 2024-01-09 18:26:09 | valerate | 1 | 82945 | 2 | 1.440 | 57600.7 |
244 | 2023-12-05 11:19:18 | valerate | 3 | 146162 | 158 | 6.673 | 21903.5 |
243 | 2023-12-05 11:19:10 | valerate | 2 | 121059 | 15 | 3.483 | 34757.1 |
242 | 2023-11-29 00:47:20 | valerate | 1 | 82945 | 2 | 1.280 | 64800.8 |
241 | 2023-11-24 10:57:53 | valerate | 1 | 82945 | 2 | 1.360 | 60989.0 |
240 | 2023-11-24 08:27:45 | valerate | 1 | 82945 | 2 | 1.266 | 65517.4 |
239 | 2023-11-11 04:04:16 | valerate | 1 | 82945 | 2 | 1.436 | 57761.1 |
238 | 2023-10-16 00:59:38 | valerate | 3 | 146162 | 158 | 6.920 | 21121.7 |
237 | 2023-10-16 00:59:39 | valerate | 2 | 121059 | 15 | 3.546 | 34139.6 |
236 | 2023-10-10 19:48:36 | valerate | 1 | 82945 | 2 | 1.296 | 64000.8 |
235 | 2023-09-13 08:37:48 | valerate | 1 | 82945 | 2 | 1.233 | 67270.9 |
234 | 2023-09-01 17:25:36 | valerate | 1 | 82945 | 2 | 1.266 | 65517.4 |
233 | 2023-06-29 19:57:09 | valerate | 1 | 82945 | 2 | 1.266 | 65517.4 |
232 | 2023-05-01 06:47:44 | valerate | 1 | 82945 | 2 | 1.406 | 58993.6 |
231 | 2023-04-07 17:40:56 | valerate | 1 | 82945 | 2 | 1.220 | 67987.7 |
230 | 2023-01-20 16:19:53 | valerate | 1 | 82945 | 2 | 1.233 | 67270.9 |
229 | 2023-01-07 20:54:13 | valerate | 1 | 82945 | 2 | 1.360 | 60989.0 |
228 | 2022-11-17 05:43:49 | valerate | 1 | 82945 | 2 | 1.233 | 67270.9 |
227 | 2022-09-20 11:23:01 | valerate | 1 | 82945 | 2 | 1.340 | 61899.3 |
226 | 2022-07-07 19:03:27 | valerate | 1 | 82945 | 2 | 1.250 | 66356.0 |
225 | 2022-05-16 02:29:26 | valerate | 1 | 82945 | 2 | 1.263 | 65673.0 |
224 | 2022-05-03 23:35:15 | valerate | 1 | 82945 | 2 | 2.156 | 38471.7 |
223 | 2022-03-23 06:10:46 | valerate | 1 | 82945 | 2 | 1.313 | 63172.1 |
222 | 2022-03-21 02:48:45 | valerate | 1 | 82945 | 2 | 1.280 | 64800.8 |
221 | 2022-01-03 15:04:19 | valerate | 1 | 82945 | 2 | 1.326 | 62552.8 |
220 | 2021-10-14 14:50:34 | valerate | 1 | 82945 | 2 | 2.703 | 30686.3 |
219 | 2021-10-13 18:06:01 | valerate | 1 | 82945 | 2 | 1.500 | 55296.7 |
218 | 2021-10-12 10:36:56 | valerate | 1 | 82945 | 2 | 1.236 | 67107.6 |
217 | 2021-10-11 13:26:38 | valerate | 1 | 82945 | 2 | 1.373 | 60411.5 |
216 | 2021-10-10 10:28:58 | valerate | 1 | 82945 | 2 | 1.453 | 57085.3 |
215 | 2021-09-22 09:14:44 | valerate | 1 | 82945 | 2 | 1.376 | 60279.8 |
214 | 2021-09-21 09:58:25 | valerate | 1 | 82945 | 2 | 1.296 | 64000.8 |
213 | 2021-09-15 01:37:47 | valerate | 1 | 82945 | 2 | 1.236 | 67107.6 |
212 | 2021-09-14 16:55:47 | valerate | 1 | 82945 | 2 | 2.810 | 29517.8 |
211 | 2021-06-14 13:59:07 | valerate | 1 | 82945 | 2 | 1.406 | 58993.6 |
210 | 2021-05-20 10:22:01 | valerate | 2 | 121059 | 15 | 3.266 | 37066.4 |
209 | 2021-04-30 09:35:51 | valerate | 1 | 82945 | 2 | 1.500 | 55296.7 |
208 | 2021-04-20 14:40:33 | valerate | 2 | 121059 | 15 | 3.156 | 38358.4 |
207 | 2021-03-23 07:56:15 | valerate | 2 | 121059 | 15 | 3.220 | 37596.0 |
206 | 2021-03-15 05:36:50 | valerate | 1 | 82945 | 2 | 1.410 | 58826.2 |
205 | 2021-03-11 17:15:51 | valerate | 1 | 82945 | 2 | 1.376 | 60279.8 |
204 | 2021-01-05 07:20:05 | valerate | 2 | 121059 | 15 | 3.140 | 38553.8 |
203 | 2020-12-08 13:39:01 | valerate | 1 | 82945 | 2 | 1.280 | 64800.8 |
202 | 2020-11-10 00:48:17 | valerate | 2 | 121059 | 15 | 3.326 | 36397.8 |
201 | 2020-10-18 15:17:15 | valerate | 1 | 82945 | 2 | 1.420 | 58412.0 |
200 | 2020-09-05 11:45:34 | valerate | 1 | 82945 | 2 | 1.296 | 64000.8 |
199 | 2020-09-04 17:43:31 | valerate | 2 | 121059 | 15 | 3.376 | 35858.7 |
198 | 2020-07-26 12:47:45 | valerate | 2 | 121059 | 15 | 3.343 | 36212.7 |
197 | 2020-05-25 03:55:59 | valerate | 1 | 82945 | 2 | 1.250 | 66356.0 |
196 | 2020-05-22 02:56:58 | valerate | 1 | 82945 | 2 | 1.390 | 59672.7 |
195 | 2020-03-25 14:25:11 | valerate | 1 | 82945 | 2 | 1.626 | 51011.7 |
194 | 2020-03-21 05:46:21 | valerate | 1 | 82945 | 2 | 1.250 | 66356.0 |
193 | 2020-02-27 01:54:31 | valerate | 1 | 82945 | 2 | 1.483 | 55930.5 |
192 | 2020-02-26 23:41:54 | valerate | 1 | 82945 | 2 | 1.533 | 54106.3 |
191 | 2020-02-23 00:29:52 | valerate | 1 | 82945 | 2 | 1.453 | 57085.3 |
190 | 2020-02-12 03:01:49 | valerate | 1 | 82945 | 2 | 3.096 | 26791.0 |
189 | 2020-02-12 00:15:20 | valerate | 1 | 82945 | 2 | 3.200 | 25920.3 |
188 | 2020-02-11 13:40:14 | valerate | 1 | 82945 | 2 | 2.890 | 28700.7 |
187 | 2020-02-07 05:37:10 | valerate | 1 | 82945 | 2 | 1.436 | 57761.1 |
186 | 2020-02-05 00:13:22 | valerate | 1 | 82945 | 2 | 3.153 | 26306.7 |
185 | 2020-02-02 02:49:13 | valerate | 1 | 82945 | 2 | 1.563 | 53067.8 |
184 | 2020-01-29 09:07:16 | valerate | 1 | 82945 | 2 | 1.673 | 49578.6 |
183 | 2020-01-27 11:28:00 | valerate | 1 | 82945 | 2 | 1.450 | 57203.4 |
182 | 2020-01-22 16:29:33 | valerate | 1 | 82945 | 2 | 1.640 | 50576.2 |
181 | 2020-01-19 08:52:41 | valerate | 1 | 82945 | 2 | 1.623 | 51106.0 |
180 | 2020-01-14 12:20:53 | valerate | 2 | 121059 | 15 | 4.093 | 29577.1 |
179 | 2020-01-14 04:30:37 | valerate | 1 | 82945 | 2 | 2.170 | 38223.5 |
178 | 2020-01-11 05:41:48 | valerate | 1 | 82945 | 2 | 1.533 | 54106.3 |
177 | 2020-01-03 01:50:03 | valerate | 1 | 82945 | 2 | 1.800 | 46080.6 |
176 | 2019-12-29 12:56:02 | valerate | 1 | 82945 | 2 | 1.356 | 61168.9 |
175 | 2019-12-29 00:46:17 | valerate | 1 | 82945 | 2 | 2.000 | 41472.5 |
174 | 2019-11-26 08:39:35 | valerate | 3 | 146162 | 158 | 7.656 | 19091.2 |
173 | 2019-11-06 16:45:31 | valerate | 1 | 82945 | 2 | 1.266 | 65517.4 |
172 | 2019-08-08 14:37:21 | valerate | 1 | 82945 | 2 | 1.350 | 61440.7 |