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 |
355 | 2025-08-24 05:07:17 | substances | 1 | 67641 | 2 | 1.233 | 54858.9 |
354 | 2025-08-12 11:29:40 | substances | 4 | 161450 | 229 | 23.643 | 6828.7 |
353 | 2025-08-12 02:06:26 | substances | 4 | 161450 | 229 | 26.440 | 6106.3 |
352 | 2025-08-11 07:08:47 | substances | 2 | 108824 | 5 | 3.030 | 35915.5 |
351 | 2025-08-11 06:13:05 | substances | 3 | 140603 | 34 | 5.843 | 24063.5 |
350 | 2025-08-09 17:22:16 | substances | 1 | 67641 | 2 | 1.190 | 56841.2 |
349 | 2025-08-06 02:45:15 | substances | 4 | 161450 | 229 | 25.240 | 6396.6 |
348 | 2025-08-06 02:45:09 | substances | 4 | 161450 | 229 | 26.316 | 6135.1 |
347 | 2025-08-05 11:09:19 | substances | 4 | 161450 | 229 | 39.973 | 4039.0 |
346 | 2025-08-04 22:11:45 | substances | 3 | 140603 | 34 | 28.186 | 4988.4 |
345 | 2025-08-03 15:15:52 | substances | 3 | 140603 | 34 | 6.346 | 22156.2 |
344 | 2025-08-03 14:23:38 | substances | 2 | 108824 | 5 | 3.030 | 35915.5 |
343 | 2025-08-03 08:06:32 | substances | 4 | 161450 | 229 | 11.326 | 14254.8 |
342 | 2025-08-03 03:08:32 | substances | 1 | 67641 | 2 | 3.063 | 22083.3 |
341 | 2025-07-30 19:27:43 | substances | 2 | 108824 | 5 | 2.906 | 37448.0 |
340 | 2025-07-25 08:23:26 | substances | 1 | 67641 | 2 | 4.576 | 14781.7 |
339 | 2025-07-24 22:35:38 | substances | 1 | 67641 | 2 | 4.280 | 15804.0 |
338 | 2025-07-24 17:43:36 | substances | 1 | 67641 | 2 | 6.173 | 10957.6 |
337 | 2025-07-24 06:23:50 | substances | 1 | 67641 | 2 | 4.483 | 15088.3 |
336 | 2025-07-23 16:16:22 | substances | 1 | 67641 | 2 | 2.970 | 22774.7 |
335 | 2025-07-22 23:27:08 | substances | 1 | 67641 | 2 | 2.310 | 29281.8 |
334 | 2025-07-22 14:59:36 | substances | 1 | 67641 | 2 | 2.593 | 26086.0 |
333 | 2025-07-21 10:48:51 | substances | 1 | 67641 | 2 | 1.186 | 57032.9 |
332 | 2025-07-09 14:40:30 | substances | 4 | 161450 | 229 | 33.270 | 4852.7 |
331 | 2025-07-08 05:58:37 | substances | 4 | 161450 | 229 | 64.156 | 2516.5 |
330 | 2025-07-07 21:16:44 | substances | 4 | 161450 | 229 | 51.986 | 3105.6 |
329 | 2025-07-05 15:18:06 | substances | 4 | 161450 | 229 | 70.410 | 2293.0 |
328 | 2025-07-02 14:49:22 | substances | 4 | 161450 | 229 | 44.733 | 3609.2 |
327 | 2025-06-26 16:29:04 | substances | 1 | 67641 | 2 | 3.813 | 17739.6 |
326 | 2025-06-22 06:13:09 | substances | 1 | 67641 | 2 | 5.670 | 11929.6 |
325 | 2025-06-18 12:42:28 | substances | 1 | 67641 | 2 | 6.436 | 10509.8 |
324 | 2025-06-16 13:58:12 | substances | 1 | 67641 | 2 | 8.233 | 8215.8 |
323 | 2025-06-10 05:53:20 | substances | 1 | 67641 | 2 | 3.016 | 22427.4 |
322 | 2025-06-09 19:26:41 | substances | 2 | 108824 | 5 | 2.626 | 41441.0 |
321 | 2025-06-06 06:17:40 | substances | 1 | 67641 | 2 | 6.046 | 11187.7 |
320 | 2025-06-04 15:36:58 | substances | 4 | 161450 | 229 | 47.736 | 3382.1 |
319 | 2025-05-30 07:05:52 | substances | 2 | 108824 | 5 | 13.670 | 7960.8 |
318 | 2025-05-26 16:40:55 | substances | 1 | 67641 | 2 | 7.716 | 8766.3 |
317 | 2025-05-26 13:57:44 | substances | 4 | 161450 | 229 | 49.600 | 3255.0 |
316 | 2025-05-26 05:24:01 | substances | 3 | 140603 | 34 | 18.750 | 7498.8 |
315 | 2025-05-26 04:57:47 | substances | 3 | 140603 | 34 | 31.860 | 4413.2 |
314 | 2025-05-25 16:05:08 | substances | 1 | 67641 | 2 | 1.453 | 46552.6 |
313 | 2025-05-24 09:34:35 | substances | 3 | 140603 | 34 | 32.216 | 4364.4 |
312 | 2025-05-23 15:14:08 | substances | 4 | 161450 | 229 | 52.503 | 3075.1 |
311 | 2025-05-23 14:52:12 | substances | 4 | 161450 | 229 | 12.813 | 12600.5 |
310 | 2025-05-23 06:54:25 | substances | 3 | 140603 | 34 | 26.983 | 5210.8 |
309 | 2025-05-22 23:16:11 | substances | 2 | 108824 | 5 | 2.766 | 39343.5 |
308 | 2025-05-20 01:15:24 | substances | 3 | 140603 | 34 | 20.266 | 6937.9 |
307 | 2025-05-20 01:04:20 | substances | 2 | 108824 | 5 | 12.530 | 8685.1 |
306 | 2025-05-19 05:42:41 | substances | 1 | 67641 | 2 | 2.313 | 29243.8 |
305 | 2025-05-15 11:55:30 | substances | 1 | 67641 | 2 | 1.233 | 54858.9 |
304 | 2025-05-15 04:03:14 | substances | 1 | 67641 | 2 | 5.563 | 12159.1 |
303 | 2025-04-26 15:27:31 | substances | 1 | 67641 | 2 | 4.123 | 16405.8 |
302 | 2025-04-16 12:17:40 | substances | 1 | 67641 | 2 | 5.750 | 11763.7 |
301 | 2025-04-02 05:41:03 | substances | 1 | 67641 | 2 | 5.736 | 11792.4 |
300 | 2025-03-29 00:38:51 | substances | 3 | 140603 | 34 | 31.123 | 4517.7 |
299 | 2025-03-23 05:48:09 | substances | 3 | 140603 | 34 | 28.343 | 4960.8 |
298 | 2025-03-21 10:07:59 | substances | 3 | 140603 | 34 | 27.863 | 5046.2 |
297 | 2025-03-20 12:28:39 | substances | 3 | 140603 | 34 | 23.816 | 5903.7 |
296 | 2025-03-20 00:38:06 | substances | 3 | 140603 | 34 | 20.533 | 6847.7 |
295 | 2025-03-18 10:31:39 | substances | 3 | 140603 | 34 | 36.093 | 3895.6 |
294 | 2025-03-18 10:31:39 | substances | 2 | 108824 | 5 | 14.030 | 7756.5 |
293 | 2025-03-18 10:31:31 | substances | 3 | 140603 | 34 | 16.423 | 8561.3 |
292 | 2025-03-18 10:30:20 | substances | 1 | 67641 | 2 | 3.250 | 20812.6 |
291 | 2025-02-25 14:07:19 | substances | 1 | 67641 | 2 | 1.030 | 65670.9 |
290 | 2025-02-20 10:39:32 | substances | 2 | 108824 | 5 | 16.063 | 6774.8 |
289 | 2025-02-20 10:37:43 | substances | 1 | 67641 | 2 | 5.440 | 12434.0 |
288 | 2025-02-14 22:08:45 | substances | 3 | 140603 | 34 | 32.006 | 4393.0 |
287 | 2025-02-14 22:08:00 | substances | 1 | 67641 | 2 | 2.746 | 24632.6 |
286 | 2025-02-14 10:18:38 | substances | 3 | 140603 | 34 | 30.376 | 4628.8 |
285 | 2025-02-13 13:57:36 | substances | 2 | 108824 | 5 | 12.173 | 8939.8 |
284 | 2025-02-13 05:41:01 | substances | 3 | 140603 | 34 | 32.326 | 4349.5 |
283 | 2025-02-12 11:22:49 | substances | 2 | 108824 | 5 | 16.656 | 6533.6 |
282 | 2025-02-12 05:45:01 | substances | 3 | 140603 | 34 | 31.143 | 4514.8 |
281 | 2025-02-11 05:06:05 | substances | 3 | 140603 | 34 | 30.016 | 4684.3 |
280 | 2025-02-10 23:52:39 | substances | 3 | 140603 | 34 | 35.410 | 3970.7 |
279 | 2025-02-10 23:52:56 | substances | 2 | 108824 | 5 | 8.750 | 12437.0 |
278 | 2025-02-10 23:52:02 | substances | 3 | 140603 | 34 | 38.096 | 3690.8 |
277 | 2025-02-10 23:46:17 | substances | 1 | 67641 | 2 | 4.360 | 15514.0 |
276 | 2025-01-18 04:27:22 | substances | 2 | 108824 | 5 | 8.110 | 13418.5 |
275 | 2025-01-18 04:17:49 | substances | 1 | 67641 | 2 | 1.623 | 41676.5 |
274 | 2025-01-03 19:10:01 | substances | 2 | 108824 | 5 | 15.013 | 7248.7 |
273 | 2025-01-03 19:06:58 | substances | 1 | 67641 | 2 | 2.593 | 26086.0 |
272 | 2025-01-03 15:33:53 | substances | 3 | 140603 | 34 | 35.766 | 3931.2 |
271 | 2025-01-03 14:52:28 | substances | 1 | 67641 | 2 | 1.030 | 65670.9 |
270 | 2025-01-03 06:40:49 | substances | 2 | 108824 | 5 | 23.346 | 4661.4 |
269 | 2025-01-03 06:40:38 | substances | 3 | 140603 | 34 | 33.236 | 4230.4 |
268 | 2025-01-03 06:37:01 | substances | 1 | 67641 | 2 | 4.720 | 14330.7 |
267 | 2025-01-03 06:35:34 | substances | 4 | 161450 | 229 | 64.156 | 2516.5 |
266 | 2025-01-02 06:12:27 | substances | 3 | 140603 | 34 | 28.846 | 4874.3 |
265 | 2025-01-01 17:52:14 | substances | 3 | 140603 | 34 | 39.436 | 3565.3 |
264 | 2025-01-01 17:52:11 | substances | 3 | 140603 | 34 | 32.470 | 4330.2 |
263 | 2024-12-31 17:16:58 | substances | 4 | 161450 | 229 | 59.486 | 2714.1 |
262 | 2024-12-31 17:17:02 | substances | 3 | 140603 | 34 | 43.503 | 3232.0 |
261 | 2024-12-18 11:25:15 | substances | 1 | 67641 | 2 | 3.203 | 21118.0 |
260 | 2024-12-02 15:28:51 | substances | 1 | 67641 | 2 | 5.546 | 12196.4 |
259 | 2024-12-02 12:46:42 | substances | 3 | 140603 | 34 | 22.626 | 6214.2 |
258 | 2024-12-02 04:40:52 | substances | 3 | 140603 | 34 | 38.876 | 3616.7 |
257 | 2024-12-02 01:51:11 | substances | 4 | 161450 | 229 | 52.270 | 3088.8 |
256 | 2024-12-02 01:51:14 | substances | 3 | 140603 | 34 | 42.973 | 3271.9 |