History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"allelic"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 682 | 2025-09-04 20:27:12 | allelic | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 681 | 2025-08-25 05:21:13 | allelic | 1 | 69583 | 2 | 4.796 | 14508.5 |
| 680 | 2025-08-17 12:06:17 | allelic | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 679 | 2025-08-17 07:12:13 | allelic | 3 | 134027 | 105 | 31.846 | 4208.6 |
| 678 | 2025-08-15 11:47:25 | allelic | 3 | 134027 | 105 | 17.000 | 7883.9 |
| 677 | 2025-08-14 03:50:24 | allelic | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 676 | 2025-08-11 22:49:52 | allelic | 3 | 134027 | 105 | 16.376 | 8184.4 |
| 675 | 2025-08-11 00:00:48 | allelic | 1 | 69583 | 2 | 1.140 | 61037.7 |
| 674 | 2025-08-01 07:07:53 | allelic | 1 | 69583 | 2 | 4.173 | 16674.6 |
| 673 | 2025-07-25 03:07:20 | allelic | 1 | 69583 | 2 | 2.376 | 29285.8 |
| 672 | 2025-07-21 04:41:16 | allelic | 1 | 69583 | 2 | 1.283 | 54234.6 |
| 671 | 2025-07-13 00:17:08 | allelic | 1 | 69583 | 2 | 6.156 | 11303.3 |
| 670 | 2025-07-10 20:09:07 | allelic | 1 | 69583 | 2 | 4.923 | 14134.3 |
| 669 | 2025-07-03 14:43:40 | allelic | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 668 | 2025-07-03 12:47:35 | allelic | 1 | 69583 | 2 | 1.236 | 56296.9 |
| 667 | 2025-07-02 03:52:12 | allelic | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 666 | 2025-06-29 18:31:26 | allelic | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 665 | 2025-06-24 02:00:53 | allelic | 1 | 69583 | 2 | 8.283 | 8400.7 |
| 664 | 2025-06-23 10:05:37 | allelic | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 663 | 2025-06-13 07:11:40 | allelic | 1 | 69583 | 2 | 2.016 | 34515.4 |
| 662 | 2025-06-13 02:18:51 | allelic | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 661 | 2025-06-12 01:49:38 | allelic | 1 | 69583 | 2 | 4.610 | 15093.9 |
| 660 | 2025-06-10 04:18:31 | allelic | 3 | 134027 | 105 | 34.390 | 3897.3 |
| 659 | 2025-06-09 10:07:23 | allelic | 2 | 107671 | 13 | 3.503 | 30736.8 |
| 658 | 2025-06-06 05:35:29 | allelic | 1 | 69583 | 2 | 7.033 | 9893.8 |
| 657 | 2025-06-04 12:47:07 | allelic | 2 | 107671 | 13 | 16.453 | 6544.2 |
| 656 | 2025-06-01 11:35:52 | allelic | 1 | 69583 | 2 | 1.310 | 53116.8 |
| 655 | 2025-05-31 03:49:35 | allelic | 1 | 69583 | 2 | 3.720 | 18705.1 |
| 654 | 2025-05-24 01:22:13 | allelic | 1 | 69583 | 2 | 8.486 | 8199.7 |
| 653 | 2025-05-20 06:09:57 | allelic | 1 | 69583 | 2 | 6.800 | 10232.8 |
| 652 | 2025-05-16 04:26:19 | allelic | 1 | 69583 | 2 | 7.750 | 8978.5 |
| 651 | 2025-05-10 13:12:36 | allelic | 1 | 69583 | 2 | 3.013 | 23094.3 |
| 650 | 2025-05-09 11:37:48 | allelic | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 649 | 2025-05-08 04:30:40 | allelic | 3 | 134027 | 105 | 28.406 | 4718.3 |
| 648 | 2025-05-06 07:13:05 | allelic | 3 | 134027 | 105 | 34.500 | 3884.8 |
| 647 | 2025-05-04 00:39:28 | allelic | 3 | 134027 | 105 | 46.736 | 2867.7 |
| 646 | 2025-04-28 08:40:42 | allelic | 3 | 134027 | 105 | 31.703 | 4227.6 |
| 645 | 2025-04-27 09:12:44 | allelic | 3 | 134027 | 105 | 37.893 | 3537.0 |
| 644 | 2025-04-23 10:31:34 | allelic | 1 | 69583 | 2 | 4.440 | 15671.8 |
| 643 | 2025-04-20 05:23:18 | allelic | 1 | 69583 | 2 | 7.250 | 9597.7 |
| 642 | 2025-04-16 13:36:41 | allelic | 1 | 69583 | 2 | 3.063 | 22717.3 |
| 641 | 2025-04-14 04:06:51 | allelic | 1 | 69583 | 2 | 8.986 | 7743.5 |
| 640 | 2025-04-06 12:10:20 | allelic | 1 | 69583 | 2 | 5.500 | 12651.5 |
| 639 | 2025-04-04 05:31:03 | allelic | 1 | 69583 | 2 | 3.360 | 20709.2 |
| 638 | 2025-03-29 05:17:09 | allelic | 1 | 69583 | 2 | 5.936 | 11722.2 |
| 637 | 2025-03-28 03:53:29 | allelic | 3 | 134027 | 105 | 30.970 | 4327.6 |
| 636 | 2025-03-27 09:08:09 | allelic | 3 | 134027 | 105 | 43.423 | 3086.5 |
| 635 | 2025-03-26 01:01:34 | allelic | 3 | 134027 | 105 | 21.670 | 6184.9 |
| 634 | 2025-03-25 00:51:17 | allelic | 3 | 134027 | 105 | 18.520 | 7236.9 |
| 633 | 2025-03-21 13:52:34 | allelic | 3 | 134027 | 105 | 32.126 | 4171.9 |
| 632 | 2025-03-21 01:29:11 | allelic | 1 | 69583 | 2 | 5.703 | 12201.1 |
| 631 | 2025-03-18 03:05:48 | allelic | 1 | 69583 | 2 | 2.783 | 25002.9 |
| 630 | 2025-03-12 08:37:41 | allelic | 1 | 69583 | 2 | 5.903 | 11787.7 |
| 629 | 2025-03-03 01:23:01 | allelic | 3 | 134027 | 105 | 35.580 | 3766.9 |
| 628 | 2025-02-18 13:38:49 | allelic | 3 | 134027 | 105 | 48.126 | 2784.9 |
| 627 | 2025-02-17 02:19:08 | allelic | 3 | 134027 | 105 | 33.533 | 3996.9 |
| 626 | 2025-02-12 14:49:55 | allelic | 1 | 69583 | 2 | 5.563 | 12508.2 |
| 625 | 2025-02-11 18:54:54 | allelic | 3 | 134027 | 105 | 32.833 | 4082.1 |
| 624 | 2025-02-10 01:05:42 | allelic | 3 | 134027 | 105 | 33.113 | 4047.6 |
| 623 | 2025-02-10 01:05:40 | allelic | 2 | 107671 | 13 | 22.503 | 4784.7 |
| 622 | 2025-02-10 01:04:39 | allelic | 1 | 69583 | 2 | 3.686 | 18877.6 |
| 621 | 2025-02-05 19:20:17 | allelic | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 620 | 2025-01-16 01:21:08 | allelic | 1 | 69583 | 2 | 4.830 | 14406.4 |
| 619 | 2025-01-12 03:42:11 | allelic | 1 | 69583 | 2 | 3.093 | 22496.9 |
| 618 | 2025-01-05 16:38:36 | allelic | 1 | 69583 | 2 | 8.640 | 8053.6 |
| 617 | 2025-01-04 21:35:19 | allelic | 1 | 69583 | 2 | 5.783 | 12032.3 |
| 616 | 2024-12-13 17:08:40 | allelic | 3 | 134027 | 105 | 35.956 | 3727.5 |
| 615 | 2024-12-13 16:18:39 | allelic | 3 | 134027 | 105 | 39.050 | 3432.2 |
| 614 | 2024-12-13 12:08:59 | allelic | 3 | 134027 | 105 | 41.736 | 3211.3 |
| 613 | 2024-12-13 12:09:08 | allelic | 2 | 107671 | 13 | 16.813 | 6404.0 |
| 612 | 2024-12-13 12:06:45 | allelic | 1 | 69583 | 2 | 5.266 | 13213.6 |
| 611 | 2024-12-05 03:26:11 | allelic | 1 | 69583 | 2 | 6.516 | 10678.8 |
| 610 | 2024-11-12 18:41:30 | allelic | 2 | 107671 | 13 | 8.936 | 12049.1 |
| 609 | 2024-11-12 06:05:40 | allelic | 2 | 107671 | 13 | 16.000 | 6729.4 |
| 608 | 2024-11-11 23:17:07 | allelic | 3 | 134027 | 105 | 23.676 | 5660.9 |
| 607 | 2024-11-11 15:23:15 | allelic | 3 | 134027 | 105 | 37.656 | 3559.2 |
| 606 | 2024-11-11 02:27:25 | allelic | 3 | 134027 | 105 | 21.296 | 6293.5 |
| 605 | 2024-11-11 02:27:26 | allelic | 2 | 107671 | 13 | 8.626 | 12482.1 |
| 604 | 2024-11-10 14:40:51 | allelic | 1 | 69583 | 2 | 1.076 | 64668.2 |
| 603 | 2024-11-03 20:56:10 | allelic | 1 | 69583 | 2 | 3.856 | 18045.4 |
| 602 | 2024-10-13 18:58:06 | allelic | 3 | 134027 | 105 | 19.550 | 6855.6 |
| 601 | 2024-10-06 12:25:13 | allelic | 3 | 134027 | 105 | 51.986 | 2578.1 |
| 600 | 2024-10-04 19:26:43 | allelic | 1 | 69583 | 2 | 8.813 | 7895.5 |
| 599 | 2024-10-04 18:05:25 | allelic | 3 | 134027 | 105 | 67.206 | 1994.3 |
| 598 | 2024-10-04 07:56:29 | allelic | 3 | 134027 | 105 | 45.546 | 2942.7 |
| 597 | 2024-10-02 20:07:57 | allelic | 3 | 134027 | 105 | 51.296 | 2612.8 |
| 596 | 2024-10-02 20:07:59 | allelic | 2 | 107671 | 13 | 24.780 | 4345.1 |
| 595 | 2024-10-02 20:07:21 | allelic | 1 | 69583 | 2 | 5.030 | 13833.6 |
| 594 | 2024-10-02 03:41:54 | allelic | 1 | 69583 | 2 | 9.596 | 7251.3 |
| 593 | 2024-09-04 10:32:09 | allelic | 1 | 69583 | 2 | 6.953 | 10007.6 |
| 592 | 2024-08-31 08:50:30 | allelic | 1 | 69583 | 2 | 10.266 | 6778.0 |
| 591 | 2024-08-29 02:07:40 | allelic | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 590 | 2024-08-19 15:03:58 | allelic | 1 | 69583 | 2 | 4.983 | 13964.1 |
| 589 | 2024-08-17 04:09:40 | allelic | 1 | 69583 | 2 | 8.686 | 8010.9 |
| 588 | 2024-08-10 20:47:52 | allelic | 1 | 69583 | 2 | 4.360 | 15959.4 |
| 587 | 2024-08-09 19:49:41 | allelic | 1 | 69583 | 2 | 6.813 | 10213.3 |
| 586 | 2024-08-04 03:28:30 | allelic | 3 | 134027 | 105 | 33.440 | 4008.0 |
| 585 | 2024-08-01 05:39:42 | allelic | 3 | 134027 | 105 | 11.500 | 11654.5 |
| 584 | 2024-08-01 05:39:42 | allelic | 2 | 107671 | 13 | 3.703 | 29076.7 |
| 583 | 2024-07-31 21:36:11 | allelic | 3 | 134027 | 105 | 31.983 | 4190.6 |