History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"allele"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
563 | 2024-04-27 05:09:40 | allele | 1 | 48755 | 4 | 3.110 | 15676.8 |
562 | 2024-04-06 14:36:10 | allele | 2 | 82551 | 26 | 2.716 | 30394.3 |
561 | 2024-04-05 19:01:59 | allele | 3 | 112716 | 360 | 13.923 | 8095.7 |
560 | 2024-04-05 13:27:55 | allele | 3 | 112716 | 360 | 10.936 | 10306.9 |
559 | 2024-04-05 13:27:53 | allele | 2 | 82551 | 26 | 7.643 | 10800.9 |
558 | 2024-04-05 13:27:49 | allele | 1 | 48755 | 4 | 1.670 | 29194.6 |
557 | 2024-03-30 20:00:12 | allele | 3 | 112716 | 360 | 19.940 | 5652.8 |
556 | 2024-03-30 17:19:31 | allele | 2 | 82551 | 26 | 6.300 | 13103.3 |
555 | 2024-03-30 02:53:03 | allele | 2 | 82551 | 26 | 2.796 | 29524.7 |
554 | 2024-03-30 02:52:46 | allele | 3 | 112716 | 360 | 5.720 | 19705.6 |
553 | 2024-03-29 04:35:09 | allele | 3 | 112716 | 360 | 11.343 | 9937.1 |
552 | 2024-03-29 02:25:33 | allele | 3 | 112716 | 360 | 10.783 | 10453.1 |
551 | 2024-03-28 18:39:12 | allele | 1 | 48755 | 4 | 2.233 | 21833.9 |
550 | 2024-03-25 18:22:11 | allele | 2 | 82551 | 26 | 8.610 | 9587.8 |
549 | 2024-03-06 23:58:44 | allele | 1 | 48755 | 4 | 3.000 | 16251.7 |
548 | 2024-03-06 11:33:17 | allele | 1 | 48755 | 4 | 2.970 | 16415.8 |
547 | 2024-02-29 00:14:41 | allele | 2 | 82551 | 26 | 2.766 | 29844.9 |
546 | 2024-02-29 00:13:04 | allele | 3 | 112716 | 360 | 7.983 | 14119.5 |
545 | 2024-02-28 19:05:52 | allele | 2 | 82551 | 26 | 2.546 | 32423.8 |
544 | 2024-02-28 19:05:16 | allele | 3 | 112716 | 360 | 5.653 | 19939.1 |
543 | 2024-02-28 18:04:43 | allele | 1 | 48755 | 4 | 0.750 | 65006.7 |
542 | 2024-02-24 19:01:11 | allele | 2 | 82551 | 26 | 2.593 | 31836.1 |
541 | 2024-02-24 19:00:52 | allele | 3 | 112716 | 360 | 5.660 | 19914.5 |
540 | 2024-02-24 12:47:35 | allele | 3 | 112716 | 360 | 4.843 | 23274.0 |
539 | 2024-01-30 21:18:42 | allele | 1 | 48755 | 4 | 0.920 | 52994.6 |
538 | 2024-01-01 06:10:51 | allele | 3 | 112716 | 360 | 5.326 | 21163.3 |
537 | 2024-01-01 06:10:52 | allele | 2 | 82551 | 26 | 2.656 | 31080.9 |
536 | 2023-12-15 16:00:13 | allele | 2 | 82551 | 26 | 2.516 | 32810.4 |
535 | 2023-12-04 04:17:37 | allele | 3 | 112716 | 360 | 5.250 | 21469.7 |
534 | 2023-12-02 12:25:09 | allele | 2 | 82551 | 26 | 2.190 | 37694.5 |
533 | 2023-11-26 00:03:27 | allele | 3 | 112716 | 360 | 5.453 | 20670.5 |
532 | 2023-11-25 16:56:06 | allele | 1 | 48755 | 4 | 0.780 | 62506.4 |
531 | 2023-11-21 08:26:29 | allele | 3 | 112716 | 360 | 4.750 | 23729.7 |
530 | 2023-11-13 20:20:43 | allele | 1 | 48755 | 4 | 0.890 | 54780.9 |
529 | 2023-11-12 04:12:17 | allele | 1 | 48755 | 4 | 0.733 | 66514.3 |
528 | 2023-11-04 09:38:41 | allele | 1 | 48755 | 4 | 0.873 | 55847.7 |
527 | 2023-11-02 11:56:57 | allele | 3 | 112716 | 360 | 5.796 | 19447.2 |
526 | 2023-11-02 11:56:56 | allele | 2 | 82551 | 26 | 2.640 | 31269.3 |
525 | 2023-10-25 19:48:06 | allele | 1 | 48755 | 4 | 0.936 | 52088.7 |
524 | 2023-10-20 22:22:56 | allele | 1 | 48755 | 4 | 0.843 | 57835.1 |
523 | 2023-10-20 17:21:26 | allele | 1 | 48755 | 4 | 0.876 | 55656.4 |
522 | 2023-10-15 01:39:39 | allele | 1 | 48755 | 4 | 0.876 | 55656.4 |
521 | 2023-10-06 08:06:32 | allele | 1 | 48755 | 4 | 0.813 | 59969.2 |
520 | 2023-09-25 03:14:45 | allele | 1 | 48755 | 4 | 0.733 | 66514.3 |
519 | 2023-09-14 07:24:27 | allele | 1 | 48755 | 4 | 0.843 | 57835.1 |
518 | 2023-09-12 12:56:42 | allele | 1 | 48755 | 4 | 0.890 | 54780.9 |
517 | 2023-08-31 16:00:00 | allele | 2 | 82551 | 26 | 2.423 | 34069.7 |
516 | 2023-08-21 10:15:02 | allele | 3 | 112716 | 360 | 4.860 | 23192.6 |
515 | 2023-08-12 07:50:55 | allele | 3 | 112716 | 360 | 5.016 | 22471.3 |
514 | 2023-07-16 18:09:47 | allele | 1 | 48755 | 4 | 1.796 | 27146.4 |
513 | 2023-06-29 08:26:44 | allele | 3 | 112716 | 360 | 5.470 | 20606.2 |
512 | 2023-06-17 12:22:00 | allele | 1 | 48755 | 4 | 0.763 | 63899.1 |
511 | 2023-05-20 07:40:43 | allele | 3 | 112716 | 360 | 5.906 | 19085.0 |
510 | 2023-05-19 15:15:22 | allele | 2 | 82551 | 26 | 2.126 | 38829.3 |
509 | 2023-05-07 06:33:53 | allele | 3 | 112716 | 360 | 4.780 | 23580.8 |
508 | 2023-05-01 14:36:45 | allele | 2 | 82551 | 26 | 2.170 | 38041.9 |
507 | 2023-04-24 16:05:02 | allele | 3 | 112716 | 360 | 4.656 | 24208.8 |
506 | 2023-04-09 01:41:03 | allele | 1 | 48755 | 4 | 0.736 | 66243.2 |
505 | 2023-03-31 22:45:41 | allele | 1 | 48755 | 4 | 0.750 | 65006.7 |
504 | 2023-03-30 18:04:09 | allele | 3 | 112716 | 360 | 4.706 | 23951.6 |
503 | 2023-03-27 05:34:35 | allele | 2 | 82551 | 26 | 2.153 | 38342.3 |
502 | 2023-02-26 18:25:48 | allele | 2 | 82551 | 26 | 2.123 | 38884.1 |
501 | 2023-02-22 15:03:39 | allele | 3 | 112716 | 360 | 4.673 | 24120.7 |
500 | 2023-02-17 15:14:35 | allele | 3 | 112716 | 360 | 4.736 | 23799.8 |
499 | 2023-02-12 21:39:12 | allele | 3 | 112716 | 360 | 4.690 | 24033.3 |
498 | 2023-01-14 02:28:31 | allele | 1 | 48755 | 4 | 0.876 | 55656.4 |
497 | 2022-12-27 09:21:33 | allele | 1 | 48755 | 4 | 0.843 | 57835.1 |
496 | 2022-12-06 03:16:37 | allele | 2 | 82551 | 26 | 2.156 | 38289.0 |
495 | 2022-11-24 15:19:03 | allele | 3 | 112716 | 360 | 4.733 | 23814.9 |
494 | 2022-10-31 15:36:42 | allele | 1 | 48755 | 4 | 0.843 | 57835.1 |
493 | 2022-09-09 10:31:14 | allele | 1 | 48755 | 4 | 0.856 | 56956.8 |
492 | 2022-09-05 21:33:41 | allele | 1 | 48755 | 4 | 0.733 | 66514.3 |
491 | 2022-08-27 21:30:51 | allele | 1 | 48755 | 4 | 0.826 | 59025.4 |
490 | 2022-07-20 08:30:36 | allele | 2 | 82551 | 26 | 2.123 | 38884.1 |
489 | 2022-06-20 20:53:15 | allele | 1 | 48755 | 4 | 0.766 | 63648.8 |
488 | 2022-05-21 06:45:51 | allele | 1 | 48755 | 4 | 0.750 | 65006.7 |
487 | 2022-05-17 20:50:54 | allele | 1 | 48755 | 4 | 0.860 | 56691.9 |
486 | 2022-05-06 22:02:06 | allele | 2 | 82551 | 26 | 2.266 | 36430.3 |
485 | 2022-04-27 22:49:46 | allele | 3 | 112716 | 360 | 5.250 | 21469.7 |
484 | 2022-04-18 12:02:36 | allele | 3 | 112716 | 360 | 5.013 | 22484.7 |
483 | 2022-04-08 14:12:34 | allele | 2 | 82551 | 26 | 3.110 | 26543.7 |
482 | 2022-04-07 16:50:34 | allele | 2 | 82551 | 26 | 2.623 | 31472.0 |
481 | 2022-04-06 14:00:37 | allele | 2 | 82551 | 26 | 2.296 | 35954.3 |
480 | 2022-04-05 19:29:43 | allele | 2 | 82551 | 26 | 2.500 | 33020.4 |
479 | 2022-04-04 23:57:48 | allele | 2 | 82551 | 26 | 2.750 | 30018.5 |
478 | 2022-04-02 23:35:13 | allele | 2 | 82551 | 26 | 2.140 | 38575.2 |
477 | 2022-04-01 14:36:04 | allele | 2 | 82551 | 26 | 2.140 | 38575.2 |
476 | 2022-03-25 16:36:36 | allele | 2 | 82551 | 26 | 2.186 | 37763.5 |
475 | 2022-03-23 13:05:04 | allele | 2 | 82551 | 26 | 2.766 | 29844.9 |
474 | 2022-03-17 18:31:14 | allele | 2 | 82551 | 26 | 2.420 | 34112.0 |
473 | 2022-03-11 02:46:50 | allele | 1 | 48755 | 4 | 0.876 | 55656.4 |
472 | 2022-03-08 22:36:12 | allele | 1 | 48755 | 4 | 0.860 | 56691.9 |
471 | 2022-02-09 13:44:16 | allele | 1 | 48755 | 4 | 1.046 | 46610.9 |
470 | 2021-12-27 07:15:33 | allele | 3 | 112716 | 360 | 5.360 | 21029.1 |
469 | 2021-12-11 17:39:19 | allele | 2 | 82551 | 26 | 2.623 | 31472.0 |
468 | 2021-12-10 14:07:05 | allele | 2 | 82551 | 26 | 2.483 | 33246.5 |
467 | 2021-12-09 14:46:02 | allele | 2 | 82551 | 26 | 2.220 | 37185.1 |
466 | 2021-12-08 15:13:13 | allele | 2 | 82551 | 26 | 2.500 | 33020.4 |
465 | 2021-11-24 14:58:56 | allele | 3 | 112716 | 360 | 8.860 | 12721.9 |
464 | 2021-11-13 14:31:34 | allele | 2 | 82551 | 26 | 2.376 | 34743.7 |