History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oleate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
410 | 2024-04-19 00:23:21 | oleate | 1 | 48755 | 2 | 2.860 | 17047.2 |
409 | 2024-04-16 10:14:42 | oleate | 1 | 48755 | 2 | 0.860 | 56691.9 |
408 | 2024-04-15 21:33:50 | oleate | 1 | 48755 | 2 | 0.936 | 52088.7 |
407 | 2024-04-06 10:00:32 | oleate | 1 | 48755 | 2 | 3.406 | 14314.4 |
406 | 2024-04-05 02:59:02 | oleate | 2 | 82551 | 64 | 3.046 | 27101.4 |
405 | 2024-04-04 07:34:20 | oleate | 2 | 82551 | 64 | 5.860 | 14087.2 |
404 | 2024-04-04 07:32:04 | oleate | 3 | 112716 | 792 | 5.250 | 21469.7 |
403 | 2024-04-02 22:52:01 | oleate | 2 | 82551 | 64 | 7.076 | 11666.3 |
402 | 2024-04-02 17:34:31 | oleate | 3 | 112716 | 792 | 13.453 | 8378.5 |
401 | 2024-04-02 03:03:39 | oleate | 2 | 82551 | 64 | 2.843 | 29036.6 |
400 | 2024-04-02 03:03:35 | oleate | 1 | 48755 | 2 | 0.920 | 52994.6 |
399 | 2024-04-02 03:03:02 | oleate | 3 | 112716 | 792 | 6.470 | 17421.3 |
398 | 2024-04-01 14:36:04 | oleate | 3 | 112716 | 792 | 7.000 | 16102.3 |
397 | 2024-04-01 14:24:26 | oleate | 3 | 112716 | 792 | 10.376 | 10863.1 |
396 | 2024-03-31 18:25:40 | oleate | 1 | 48755 | 2 | 0.953 | 51159.5 |
395 | 2024-03-01 14:03:00 | oleate | 1 | 48755 | 2 | 0.953 | 51159.5 |
394 | 2024-02-26 03:59:09 | oleate | 1 | 48755 | 2 | 2.140 | 22782.7 |
393 | 2024-02-25 21:37:33 | oleate | 3 | 112716 | 792 | 7.923 | 14226.4 |
392 | 2024-02-21 19:36:44 | oleate | 2 | 82551 | 64 | 2.970 | 27794.9 |
391 | 2024-02-21 19:36:04 | oleate | 3 | 112716 | 792 | 5.753 | 19592.6 |
390 | 2024-02-21 16:24:15 | oleate | 3 | 112716 | 792 | 18.266 | 6170.8 |
389 | 2024-02-21 16:24:15 | oleate | 2 | 82551 | 64 | 8.060 | 10242.1 |
388 | 2024-02-21 06:56:38 | oleate | 1 | 48755 | 2 | 0.966 | 50471.0 |
387 | 2024-01-10 03:58:36 | oleate | 1 | 48755 | 2 | 0.750 | 65006.7 |
386 | 2024-01-02 15:13:27 | oleate | 1 | 48755 | 2 | 0.750 | 65006.7 |
385 | 2023-12-16 07:51:07 | oleate | 1 | 48755 | 2 | 0.780 | 62506.4 |
384 | 2023-12-13 08:35:44 | oleate | 3 | 112716 | 792 | 5.686 | 19823.4 |
383 | 2023-12-13 08:35:45 | oleate | 2 | 82551 | 64 | 4.076 | 20252.9 |
382 | 2023-12-08 08:06:23 | oleate | 3 | 112716 | 792 | 5.220 | 21593.1 |
381 | 2023-12-08 08:06:20 | oleate | 2 | 82551 | 64 | 2.186 | 37763.5 |
380 | 2023-12-06 02:45:30 | oleate | 3 | 112716 | 792 | 5.563 | 20261.7 |
379 | 2023-11-25 09:57:26 | oleate | 1 | 48755 | 2 | 0.766 | 63648.8 |
378 | 2023-11-24 15:40:05 | oleate | 1 | 48755 | 2 | 0.763 | 63899.1 |
377 | 2023-11-22 18:43:11 | oleate | 3 | 112716 | 792 | 5.593 | 20153.0 |
376 | 2023-11-22 18:43:13 | oleate | 2 | 82551 | 64 | 2.596 | 31799.3 |
375 | 2023-11-22 03:36:11 | oleate | 1 | 48755 | 2 | 1.673 | 29142.3 |
374 | 2023-11-11 14:06:03 | oleate | 1 | 48755 | 2 | 0.830 | 58741.0 |
373 | 2023-10-28 07:55:47 | oleate | 1 | 48755 | 2 | 0.843 | 57835.1 |
372 | 2023-10-25 13:10:56 | oleate | 1 | 48755 | 2 | 0.873 | 55847.7 |
371 | 2023-10-21 18:26:36 | oleate | 1 | 48755 | 2 | 0.860 | 56691.9 |
370 | 2023-10-18 16:10:09 | oleate | 1 | 48755 | 2 | 0.750 | 65006.7 |
369 | 2023-10-15 01:53:14 | oleate | 1 | 48755 | 2 | 0.856 | 56956.8 |
368 | 2023-10-08 18:53:41 | oleate | 1 | 48755 | 2 | 0.813 | 59969.2 |
367 | 2023-09-26 18:18:59 | oleate | 1 | 48755 | 2 | 0.876 | 55656.4 |
366 | 2023-09-17 12:04:28 | oleate | 1 | 48755 | 2 | 0.893 | 54596.9 |
365 | 2023-09-14 09:10:52 | oleate | 1 | 48755 | 2 | 0.830 | 58741.0 |
364 | 2023-09-04 04:19:45 | oleate | 3 | 112716 | 792 | 4.673 | 24120.7 |
363 | 2023-08-20 16:28:22 | oleate | 1 | 48755 | 2 | 0.873 | 55847.7 |
362 | 2023-06-03 15:02:19 | oleate | 1 | 48755 | 2 | 0.750 | 65006.7 |
361 | 2023-05-21 06:42:33 | oleate | 1 | 48755 | 2 | 0.780 | 62506.4 |
360 | 2023-05-04 13:25:19 | oleate | 1 | 48755 | 2 | 0.716 | 68093.6 |
359 | 2023-04-11 18:53:14 | oleate | 1 | 48755 | 2 | 0.736 | 66243.2 |
358 | 2023-03-29 02:05:46 | oleate | 1 | 48755 | 2 | 0.810 | 60191.4 |
357 | 2023-03-15 17:06:52 | oleate | 1 | 48755 | 2 | 0.736 | 66243.2 |
356 | 2023-02-22 02:56:22 | oleate | 1 | 48755 | 2 | 0.843 | 57835.1 |
355 | 2023-01-24 01:46:09 | oleate | 3 | 112716 | 792 | 5.346 | 21084.2 |
354 | 2023-01-04 18:36:46 | oleate | 1 | 48755 | 2 | 1.596 | 30548.2 |
353 | 2022-12-27 15:52:57 | oleate | 1 | 48755 | 2 | 0.720 | 67715.3 |
352 | 2022-11-19 12:03:08 | oleate | 1 | 48755 | 2 | 0.813 | 59969.2 |
351 | 2022-11-08 14:17:55 | oleate | 1 | 48755 | 2 | 0.890 | 54780.9 |
350 | 2022-11-05 21:42:55 | oleate | 3 | 112716 | 792 | 5.173 | 21789.3 |
349 | 2022-09-27 12:43:22 | oleate | 1 | 48755 | 2 | 0.810 | 60191.4 |
348 | 2022-08-07 12:36:09 | oleate | 1 | 48755 | 2 | 0.736 | 66243.2 |
347 | 2022-07-19 06:02:38 | oleate | 1 | 48755 | 2 | 0.813 | 59969.2 |
346 | 2022-06-07 16:18:36 | oleate | 3 | 112716 | 792 | 4.843 | 23274.0 |
345 | 2022-05-15 08:09:05 | oleate | 1 | 48755 | 2 | 0.826 | 59025.4 |
344 | 2022-05-13 03:22:04 | oleate | 1 | 48755 | 2 | 0.856 | 56956.8 |
343 | 2022-03-25 04:53:04 | oleate | 1 | 48755 | 2 | 0.873 | 55847.7 |
342 | 2022-02-03 08:26:37 | oleate | 1 | 48755 | 2 | 0.826 | 59025.4 |
341 | 2022-01-29 01:18:24 | oleate | 3 | 112716 | 792 | 5.466 | 20621.3 |
340 | 2021-12-14 07:48:45 | oleate | 1 | 48755 | 2 | 0.810 | 60191.4 |
339 | 2021-12-09 19:00:28 | oleate | 1 | 48755 | 2 | 0.733 | 66514.3 |
338 | 2021-09-07 01:36:16 | oleate | 1 | 48755 | 2 | 0.936 | 52088.7 |
337 | 2021-06-14 02:35:14 | oleate | 2 | 82551 | 64 | 2.610 | 31628.7 |
336 | 2021-06-06 01:57:32 | oleate | 1 | 48755 | 2 | 0.830 | 58741.0 |
335 | 2021-05-08 00:30:34 | oleate | 1 | 48755 | 2 | 0.940 | 51867.0 |
334 | 2021-05-07 07:43:13 | oleate | 1 | 48755 | 2 | 0.843 | 57835.1 |
333 | 2021-05-02 22:58:02 | oleate | 1 | 48755 | 2 | 0.766 | 63648.8 |
332 | 2021-05-02 15:35:34 | oleate | 1 | 48755 | 2 | 0.876 | 55656.4 |
331 | 2021-04-23 02:12:26 | oleate | 1 | 48755 | 2 | 0.893 | 54596.9 |
330 | 2021-03-23 17:56:18 | oleate | 2 | 82551 | 64 | 2.436 | 33887.9 |
329 | 2021-03-03 23:55:14 | oleate | 1 | 48755 | 2 | 0.763 | 63899.1 |
328 | 2021-01-07 08:42:38 | oleate | 2 | 82551 | 64 | 2.703 | 30540.5 |
327 | 2021-01-06 01:46:12 | oleate | 2 | 82551 | 64 | 2.406 | 34310.5 |
326 | 2020-12-02 23:11:07 | oleate | 1 | 48755 | 2 | 0.750 | 65006.7 |
325 | 2020-11-01 08:20:41 | oleate | 1 | 48755 | 2 | 0.826 | 59025.4 |
324 | 2020-11-01 02:07:59 | oleate | 1 | 48755 | 2 | 0.873 | 55847.7 |
323 | 2020-10-27 13:54:21 | oleate | 1 | 48755 | 2 | 1.576 | 30935.9 |
322 | 2020-10-21 01:33:14 | oleate | 1 | 48755 | 2 | 0.736 | 66243.2 |
321 | 2020-10-17 11:46:49 | oleate | 1 | 48755 | 2 | 0.813 | 59969.2 |
320 | 2020-10-08 09:01:32 | oleate | 1 | 48755 | 2 | 0.860 | 56691.9 |
319 | 2020-09-11 02:42:01 | oleate | 1 | 48755 | 2 | 1.596 | 30548.2 |
318 | 2020-08-28 16:05:37 | oleate | 2 | 82551 | 64 | 2.343 | 35233.0 |
317 | 2020-08-25 10:00:49 | oleate | 1 | 48755 | 2 | 0.796 | 61250.0 |
316 | 2020-08-08 06:34:00 | oleate | 1 | 48755 | 2 | 0.733 | 66514.3 |
315 | 2020-07-22 04:42:39 | oleate | 2 | 82551 | 64 | 2.296 | 35954.3 |
314 | 2020-07-21 13:50:41 | oleate | 1 | 48755 | 2 | 1.860 | 26212.4 |
313 | 2020-05-24 00:23:52 | oleate | 1 | 48755 | 2 | 0.813 | 59969.2 |
312 | 2020-03-26 06:13:54 | oleate | 1 | 48755 | 2 | 0.813 | 59969.2 |
311 | 2020-03-24 23:53:49 | oleate | 1 | 48755 | 2 | 1.253 | 38910.6 |