History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"amylase"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 819 | 2024-05-02 08:37:49 | amylase | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 818 | 2024-04-29 08:02:45 | amylase | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 817 | 2024-04-26 15:44:46 | amylase | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 816 | 2024-04-26 04:47:53 | amylase | 2 | 107671 | 9 | 3.000 | 35890.3 |
| 815 | 2024-04-26 04:47:43 | amylase | 3 | 134027 | 111 | 6.890 | 19452.4 |
| 814 | 2024-04-26 01:21:22 | amylase | 3 | 134027 | 111 | 14.626 | 9163.6 |
| 813 | 2024-04-25 20:39:22 | amylase | 2 | 107671 | 9 | 8.673 | 12414.5 |
| 812 | 2024-04-25 18:38:56 | amylase | 3 | 134027 | 111 | 7.846 | 17082.2 |
| 811 | 2024-04-25 10:10:18 | amylase | 3 | 134027 | 111 | 22.330 | 6002.1 |
| 810 | 2024-04-25 05:20:45 | amylase | 3 | 134027 | 111 | 10.110 | 13256.9 |
| 809 | 2024-04-25 00:21:01 | amylase | 3 | 134027 | 111 | 19.906 | 6733.0 |
| 808 | 2024-04-24 19:16:20 | amylase | 3 | 134027 | 111 | 14.626 | 9163.6 |
| 807 | 2024-04-21 20:38:24 | amylase | 3 | 134027 | 111 | 23.626 | 5672.9 |
| 806 | 2024-04-20 07:21:42 | amylase | 3 | 134027 | 111 | 11.283 | 11878.7 |
| 805 | 2024-03-30 01:46:16 | amylase | 1 | 69583 | 3 | 3.203 | 21724.3 |
| 804 | 2024-03-29 08:23:10 | amylase | 1 | 69583 | 3 | 2.530 | 27503.2 |
| 803 | 2024-03-06 12:58:08 | amylase | 3 | 134027 | 111 | 18.906 | 7089.1 |
| 802 | 2024-03-04 09:43:29 | amylase | 3 | 134027 | 111 | 12.610 | 10628.6 |
| 801 | 2024-03-01 22:52:33 | amylase | 3 | 134027 | 111 | 23.360 | 5737.5 |
| 800 | 2024-02-28 08:39:10 | amylase | 3 | 134027 | 111 | 17.206 | 7789.6 |
| 799 | 2024-02-28 05:43:38 | amylase | 2 | 107671 | 9 | 15.096 | 7132.4 |
| 798 | 2024-02-28 05:05:32 | amylase | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 797 | 2024-02-26 23:55:14 | amylase | 2 | 107671 | 9 | 5.250 | 20508.8 |
| 796 | 2024-02-26 23:55:10 | amylase | 3 | 134027 | 111 | 7.563 | 17721.4 |
| 795 | 2024-02-26 23:55:00 | amylase | 1 | 69583 | 3 | 2.640 | 26357.2 |
| 794 | 2024-01-27 08:03:07 | amylase | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 793 | 2024-01-08 21:08:49 | amylase | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 792 | 2024-01-04 19:28:44 | amylase | 2 | 107671 | 9 | 3.156 | 34116.3 |
| 791 | 2023-12-15 08:04:02 | amylase | 3 | 134027 | 111 | 5.733 | 23378.2 |
| 790 | 2023-12-08 07:20:35 | amylase | 3 | 134027 | 111 | 5.873 | 22820.9 |
| 789 | 2023-12-08 07:20:30 | amylase | 2 | 107671 | 9 | 3.123 | 34476.8 |
| 788 | 2023-12-06 00:58:53 | amylase | 3 | 134027 | 111 | 6.110 | 21935.7 |
| 787 | 2023-12-04 10:26:28 | amylase | 1 | 69583 | 3 | 1.656 | 42018.7 |
| 786 | 2023-12-03 09:15:55 | amylase | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 785 | 2023-12-03 09:15:54 | amylase | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 784 | 2023-11-30 19:43:42 | amylase | 3 | 134027 | 111 | 5.593 | 23963.3 |
| 783 | 2023-11-30 19:43:35 | amylase | 2 | 107671 | 9 | 2.750 | 39153.1 |
| 782 | 2023-11-12 17:00:19 | amylase | 3 | 134027 | 111 | 7.720 | 17361.0 |
| 781 | 2023-11-12 17:00:18 | amylase | 2 | 107671 | 9 | 3.406 | 31612.2 |
| 780 | 2023-11-11 06:29:03 | amylase | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 779 | 2023-11-10 01:19:23 | amylase | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 778 | 2023-11-02 13:18:06 | amylase | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 777 | 2023-10-26 17:52:13 | amylase | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 776 | 2023-10-20 12:54:49 | amylase | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 775 | 2023-10-17 10:26:28 | amylase | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 774 | 2023-10-15 22:28:07 | amylase | 2 | 107671 | 9 | 3.250 | 33129.5 |
| 773 | 2023-10-14 10:59:40 | amylase | 3 | 134027 | 111 | 12.656 | 10590.0 |
| 772 | 2023-10-13 16:35:44 | amylase | 2 | 107671 | 9 | 2.923 | 36835.8 |
| 771 | 2023-10-10 19:24:00 | amylase | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 770 | 2023-10-05 14:38:51 | amylase | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 769 | 2023-10-04 00:55:28 | amylase | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 768 | 2023-09-23 08:54:34 | amylase | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 767 | 2023-09-13 14:08:43 | amylase | 3 | 134027 | 111 | 5.733 | 23378.2 |
| 766 | 2023-09-11 03:17:14 | amylase | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 765 | 2023-08-24 20:12:09 | amylase | 1 | 69583 | 3 | 1.890 | 36816.4 |
| 764 | 2023-07-24 15:07:42 | amylase | 2 | 107671 | 9 | 2.733 | 39396.6 |
| 763 | 2023-06-18 15:36:17 | amylase | 1 | 69583 | 3 | 2.156 | 32274.1 |
| 762 | 2023-06-09 23:33:24 | amylase | 3 | 134027 | 111 | 5.436 | 24655.4 |
| 761 | 2023-05-27 18:59:03 | amylase | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 760 | 2023-04-08 16:01:57 | amylase | 2 | 107671 | 9 | 3.110 | 34620.9 |
| 759 | 2023-04-06 05:48:00 | amylase | 3 | 134027 | 111 | 5.753 | 23296.9 |
| 758 | 2023-03-24 13:30:22 | amylase | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 757 | 2023-03-14 12:15:23 | amylase | 3 | 134027 | 111 | 5.563 | 24092.6 |
| 756 | 2023-02-27 13:00:04 | amylase | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 755 | 2023-02-17 17:26:13 | amylase | 3 | 134027 | 111 | 5.483 | 24444.1 |
| 754 | 2023-01-12 17:46:51 | amylase | 2 | 107671 | 9 | 2.843 | 37872.3 |
| 753 | 2023-01-08 15:58:21 | amylase | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 752 | 2022-12-23 17:37:11 | amylase | 3 | 134027 | 111 | 6.280 | 21341.9 |
| 751 | 2022-12-16 20:56:52 | amylase | 3 | 134027 | 111 | 6.373 | 21030.4 |
| 750 | 2022-12-10 15:31:31 | amylase | 3 | 134027 | 111 | 6.703 | 19995.1 |
| 749 | 2022-12-10 15:31:21 | amylase | 3 | 134027 | 111 | 5.736 | 23365.9 |
| 748 | 2022-11-12 11:34:14 | amylase | 3 | 134027 | 111 | 6.390 | 20974.5 |
| 747 | 2022-11-03 17:52:35 | amylase | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 746 | 2022-10-15 19:21:10 | amylase | 3 | 134027 | 111 | 5.533 | 24223.2 |
| 745 | 2022-10-14 16:13:20 | amylase | 2 | 107671 | 9 | 2.750 | 39153.1 |
| 744 | 2022-10-09 18:29:16 | amylase | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 743 | 2022-09-14 03:18:58 | amylase | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 742 | 2022-09-10 23:15:30 | amylase | 3 | 134027 | 111 | 5.513 | 24311.1 |
| 741 | 2022-09-03 12:32:09 | amylase | 3 | 134027 | 111 | 5.750 | 23309.0 |
| 740 | 2022-09-01 18:26:15 | amylase | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 739 | 2022-08-28 02:15:36 | amylase | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 738 | 2022-08-06 18:44:40 | amylase | 3 | 134027 | 111 | 5.500 | 24368.5 |
| 737 | 2022-07-13 23:17:09 | amylase | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 736 | 2022-07-03 22:51:23 | amylase | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 735 | 2022-05-31 13:48:09 | amylase | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 734 | 2022-05-16 09:10:36 | amylase | 2 | 107671 | 9 | 3.080 | 34958.1 |
| 733 | 2022-05-11 23:56:30 | amylase | 2 | 107671 | 9 | 2.876 | 37437.8 |
| 732 | 2022-03-20 10:12:12 | amylase | 1 | 69583 | 3 | 1.486 | 46825.7 |
| 731 | 2022-03-16 23:30:27 | amylase | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 730 | 2022-02-08 09:09:06 | amylase | 1 | 69583 | 3 | 2.250 | 30925.8 |
| 729 | 2022-01-11 14:30:01 | amylase | 2 | 107671 | 9 | 3.250 | 33129.5 |
| 728 | 2021-11-30 01:40:25 | amylase | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 727 | 2021-11-29 19:14:16 | amylase | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 726 | 2021-11-01 08:41:47 | amylase | 2 | 107671 | 9 | 3.500 | 30763.1 |
| 725 | 2021-10-07 11:34:08 | amylase | 1 | 69583 | 3 | 2.360 | 29484.3 |
| 724 | 2021-10-05 08:58:28 | amylase | 1 | 69583 | 3 | 2.143 | 32469.9 |
| 723 | 2021-09-14 02:07:51 | amylase | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 722 | 2021-09-02 21:47:59 | amylase | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 721 | 2021-08-23 13:36:39 | amylase | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 720 | 2021-07-28 21:22:48 | amylase | 1 | 69583 | 3 | 1.266 | 54962.9 |