History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prunus"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
474 | 2024-04-27 22:44:50 | prunus | 2 | 82551 | 34 | 5.000 | 16510.2 |
473 | 2024-04-27 16:21:52 | prunus | 3 | 112716 | 614 | 6.623 | 17018.9 |
472 | 2024-04-19 02:11:21 | prunus | 1 | 48755 | 2 | 0.830 | 58741.0 |
471 | 2024-04-11 10:08:36 | prunus | 1 | 48755 | 2 | 0.843 | 57835.1 |
470 | 2024-03-31 20:53:41 | prunus | 1 | 48755 | 2 | 0.966 | 50471.0 |
469 | 2024-03-30 22:30:14 | prunus | 3 | 112716 | 614 | 13.813 | 8160.1 |
468 | 2024-03-29 21:39:30 | prunus | 3 | 112716 | 614 | 20.156 | 5592.2 |
467 | 2024-03-28 19:48:33 | prunus | 2 | 82551 | 34 | 5.966 | 13836.9 |
466 | 2024-03-28 15:58:33 | prunus | 1 | 48755 | 2 | 0.906 | 53813.5 |
465 | 2024-03-28 15:58:27 | prunus | 3 | 112716 | 614 | 5.906 | 19085.0 |
464 | 2024-03-28 15:58:25 | prunus | 2 | 82551 | 34 | 2.590 | 31873.0 |
463 | 2024-03-25 16:23:45 | prunus | 1 | 48755 | 2 | 0.876 | 55656.4 |
462 | 2024-03-14 04:26:29 | prunus | 3 | 112716 | 614 | 7.390 | 15252.5 |
461 | 2024-02-25 21:17:55 | prunus | 1 | 48755 | 2 | 1.906 | 25579.7 |
460 | 2024-01-22 10:11:49 | prunus | 3 | 112716 | 614 | 6.156 | 18309.9 |
459 | 2024-01-17 21:31:04 | prunus | 3 | 112716 | 614 | 5.860 | 19234.8 |
458 | 2024-01-13 20:14:01 | prunus | 2 | 82551 | 34 | 2.546 | 32423.8 |
457 | 2024-01-11 09:03:21 | prunus | 3 | 112716 | 614 | 5.610 | 20092.0 |
456 | 2024-01-10 15:25:30 | prunus | 3 | 112716 | 614 | 8.156 | 13820.0 |
455 | 2023-12-23 06:00:31 | prunus | 1 | 48755 | 2 | 0.826 | 59025.4 |
454 | 2023-12-17 23:55:01 | prunus | 1 | 48755 | 2 | 0.846 | 57630.0 |
453 | 2023-11-26 14:24:39 | prunus | 3 | 112716 | 614 | 4.733 | 23814.9 |
452 | 2023-11-20 21:58:55 | prunus | 1 | 48755 | 2 | 0.813 | 59969.2 |
451 | 2023-11-20 08:37:47 | prunus | 1 | 48755 | 2 | 0.830 | 58741.0 |
450 | 2023-11-17 12:56:14 | prunus | 2 | 82551 | 34 | 2.360 | 34979.2 |
449 | 2023-11-17 12:56:10 | prunus | 3 | 112716 | 614 | 4.906 | 22975.1 |
448 | 2023-10-31 07:47:27 | prunus | 1 | 48755 | 2 | 0.766 | 63648.8 |
447 | 2023-10-26 23:11:07 | prunus | 1 | 48755 | 2 | 1.763 | 27654.6 |
446 | 2023-10-19 21:05:20 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
445 | 2023-10-16 02:33:12 | prunus | 1 | 48755 | 2 | 0.826 | 59025.4 |
444 | 2023-10-07 06:14:59 | prunus | 1 | 48755 | 2 | 0.733 | 66514.3 |
443 | 2023-10-05 16:25:36 | prunus | 1 | 48755 | 2 | 0.826 | 59025.4 |
442 | 2023-09-26 07:25:11 | prunus | 1 | 48755 | 2 | 0.843 | 57835.1 |
441 | 2023-09-14 04:08:55 | prunus | 1 | 48755 | 2 | 0.843 | 57835.1 |
440 | 2023-08-25 22:56:11 | prunus | 3 | 112716 | 614 | 5.453 | 20670.5 |
439 | 2023-08-20 15:03:31 | prunus | 1 | 48755 | 2 | 1.470 | 33166.7 |
438 | 2023-08-07 23:55:36 | prunus | 3 | 112716 | 614 | 4.750 | 23729.7 |
437 | 2023-08-01 15:16:12 | prunus | 1 | 48755 | 2 | 0.830 | 58741.0 |
436 | 2023-07-11 17:16:45 | prunus | 3 | 112716 | 614 | 6.686 | 16858.5 |
435 | 2023-07-08 19:13:10 | prunus | 3 | 112716 | 614 | 9.873 | 11416.6 |
434 | 2023-06-05 09:56:05 | prunus | 3 | 112716 | 614 | 4.690 | 24033.3 |
433 | 2023-05-10 16:16:20 | prunus | 3 | 112716 | 614 | 4.826 | 23356.0 |
432 | 2023-04-27 23:35:14 | prunus | 1 | 48755 | 2 | 0.813 | 59969.2 |
431 | 2023-04-27 14:15:36 | prunus | 1 | 48755 | 2 | 0.766 | 63648.8 |
430 | 2023-04-25 13:24:54 | prunus | 1 | 48755 | 2 | 0.906 | 53813.5 |
429 | 2023-04-21 20:50:35 | prunus | 1 | 48755 | 2 | 0.846 | 57630.0 |
428 | 2023-03-18 16:57:53 | prunus | 1 | 48755 | 2 | 0.733 | 66514.3 |
427 | 2023-02-19 13:18:36 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
426 | 2023-02-17 23:27:55 | prunus | 3 | 112716 | 614 | 5.423 | 20784.8 |
425 | 2022-12-18 09:00:35 | prunus | 1 | 48755 | 2 | 0.733 | 66514.3 |
424 | 2022-12-17 18:42:07 | prunus | 1 | 48755 | 2 | 0.736 | 66243.2 |
423 | 2022-11-29 11:29:21 | prunus | 3 | 112716 | 614 | 4.563 | 24702.2 |
422 | 2022-09-12 09:49:54 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
421 | 2022-08-27 21:18:42 | prunus | 1 | 48755 | 2 | 0.826 | 59025.4 |
420 | 2022-08-08 12:04:02 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
419 | 2022-07-10 02:41:46 | prunus | 1 | 48755 | 2 | 0.763 | 63899.1 |
418 | 2022-07-05 13:28:01 | prunus | 3 | 112716 | 614 | 4.763 | 23664.9 |
417 | 2022-05-19 01:27:41 | prunus | 3 | 112716 | 614 | 4.830 | 23336.6 |
416 | 2022-05-16 06:04:35 | prunus | 1 | 48755 | 2 | 0.843 | 57835.1 |
415 | 2022-04-29 01:01:01 | prunus | 1 | 48755 | 2 | 0.906 | 53813.5 |
414 | 2022-04-12 18:06:02 | prunus | 1 | 48755 | 2 | 0.826 | 59025.4 |
413 | 2022-04-09 00:47:54 | prunus | 1 | 48755 | 2 | 0.783 | 62266.9 |
412 | 2022-03-27 22:13:29 | prunus | 1 | 48755 | 2 | 0.813 | 59969.2 |
411 | 2022-01-06 08:21:16 | prunus | 1 | 48755 | 2 | 0.906 | 53813.5 |
410 | 2022-01-04 05:57:15 | prunus | 1 | 48755 | 2 | 0.890 | 54780.9 |
409 | 2021-11-30 11:56:24 | prunus | 1 | 48755 | 2 | 0.830 | 58741.0 |
408 | 2021-11-08 17:33:16 | prunus | 1 | 48755 | 2 | 0.873 | 55847.7 |
407 | 2021-11-06 15:19:54 | prunus | 1 | 48755 | 2 | 0.830 | 58741.0 |
406 | 2021-09-28 08:39:55 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
405 | 2021-09-26 05:49:32 | prunus | 1 | 48755 | 2 | 0.733 | 66514.3 |
404 | 2021-09-14 11:20:41 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
403 | 2021-08-10 19:20:16 | prunus | 1 | 48755 | 2 | 0.763 | 63899.1 |
402 | 2021-05-06 08:17:35 | prunus | 1 | 48755 | 2 | 1.000 | 48755.0 |
401 | 2021-04-26 01:40:46 | prunus | 1 | 48755 | 2 | 0.873 | 55847.7 |
400 | 2021-04-04 12:26:14 | prunus | 1 | 48755 | 2 | 0.906 | 53813.5 |
399 | 2021-03-08 21:31:05 | prunus | 1 | 48755 | 2 | 0.826 | 59025.4 |
398 | 2021-01-30 21:10:46 | prunus | 1 | 48755 | 2 | 0.766 | 63648.8 |
397 | 2021-01-09 04:28:26 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
396 | 2021-01-02 21:09:24 | prunus | 1 | 48755 | 2 | 0.860 | 56691.9 |
395 | 2020-10-31 15:23:43 | prunus | 1 | 48755 | 2 | 0.766 | 63648.8 |
394 | 2020-10-29 15:42:48 | prunus | 1 | 48755 | 2 | 1.033 | 47197.5 |
393 | 2020-09-29 04:11:09 | prunus | 1 | 48755 | 2 | 0.796 | 61250.0 |
392 | 2020-08-18 10:22:51 | prunus | 1 | 48755 | 2 | 0.826 | 59025.4 |
391 | 2020-06-04 16:04:57 | prunus | 1 | 48755 | 2 | 0.873 | 55847.7 |
390 | 2020-04-18 09:20:13 | prunus | 1 | 48755 | 2 | 0.923 | 52822.3 |
389 | 2020-04-17 10:06:14 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
388 | 2020-04-16 10:06:12 | prunus | 1 | 48755 | 2 | 0.750 | 65006.7 |
387 | 2020-04-15 09:25:10 | prunus | 1 | 48755 | 2 | 0.766 | 63648.8 |
386 | 2020-03-28 21:06:08 | prunus | 1 | 48755 | 2 | 0.873 | 55847.7 |
385 | 2020-03-28 18:56:43 | prunus | 1 | 48755 | 2 | 0.906 | 53813.5 |
384 | 2020-03-24 20:29:39 | prunus | 1 | 48755 | 2 | 0.983 | 49598.2 |
383 | 2020-03-23 13:10:52 | prunus | 1 | 48755 | 2 | 1.780 | 27390.4 |
382 | 2020-03-20 09:35:17 | prunus | 1 | 48755 | 2 | 0.860 | 56691.9 |
381 | 2020-03-03 03:35:26 | prunus | 1 | 48755 | 2 | 0.813 | 59969.2 |
380 | 2020-02-29 16:12:48 | prunus | 1 | 48755 | 2 | 0.860 | 56691.9 |
379 | 2020-02-29 06:02:55 | prunus | 1 | 48755 | 2 | 0.890 | 54780.9 |
378 | 2020-02-23 19:30:05 | prunus | 1 | 48755 | 2 | 0.903 | 53992.2 |
377 | 2020-02-17 05:39:52 | prunus | 1 | 48755 | 2 | 1.686 | 28917.6 |
376 | 2020-02-07 09:28:25 | prunus | 1 | 48755 | 2 | 0.890 | 54780.9 |
375 | 2020-02-05 11:38:47 | prunus | 1 | 48755 | 2 | 0.953 | 51159.5 |