History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"alleles"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 944 | 2025-10-27 15:05:11 | alleles | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 943 | 2025-10-25 06:52:46 | alleles | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 942 | 2025-10-24 02:29:59 | alleles | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 941 | 2025-10-23 04:10:15 | alleles | 1 | 69583 | 4 | 6.470 | 10754.7 |
| 940 | 2025-10-23 04:10:04 | alleles | 1 | 69583 | 4 | 7.030 | 9898.0 |
| 939 | 2025-10-08 13:01:16 | alleles | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 938 | 2025-10-08 04:43:40 | alleles | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 937 | 2025-10-07 16:31:47 | alleles | 1 | 69583 | 4 | 1.096 | 63488.1 |
| 936 | 2025-09-27 15:55:33 | alleles | 1 | 69583 | 4 | 1.720 | 40455.2 |
| 935 | 2025-09-22 03:27:08 | alleles | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 934 | 2025-09-21 11:47:20 | alleles | 1 | 69583 | 4 | 1.643 | 42351.2 |
| 933 | 2025-09-13 07:21:18 | alleles | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 932 | 2025-09-04 20:27:07 | alleles | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 931 | 2025-08-27 16:05:59 | alleles | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 930 | 2025-08-25 19:58:27 | alleles | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 929 | 2025-08-25 09:18:47 | alleles | 1 | 69583 | 4 | 7.283 | 9554.2 |
| 928 | 2025-08-17 12:13:44 | alleles | 1 | 69583 | 4 | 2.563 | 27149.0 |
| 927 | 2025-08-06 07:44:37 | alleles | 2 | 107671 | 23 | 16.686 | 6452.8 |
| 926 | 2025-08-04 00:07:30 | alleles | 1 | 69583 | 4 | 3.266 | 21305.3 |
| 925 | 2025-08-01 10:37:12 | alleles | 1 | 69583 | 4 | 7.190 | 9677.7 |
| 924 | 2025-07-28 02:20:05 | alleles | 3 | 134027 | 310 | 19.530 | 6862.6 |
| 923 | 2025-07-27 18:39:48 | alleles | 2 | 107671 | 23 | 16.016 | 6722.7 |
| 922 | 2025-07-27 17:56:47 | alleles | 3 | 134027 | 310 | 27.470 | 4879.0 |
| 921 | 2025-07-26 11:55:28 | alleles | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 920 | 2025-07-25 08:35:53 | alleles | 1 | 69583 | 4 | 3.033 | 22942.0 |
| 919 | 2025-07-25 06:52:29 | alleles | 1 | 69583 | 4 | 7.326 | 9498.1 |
| 918 | 2025-07-24 09:59:51 | alleles | 1 | 69583 | 4 | 5.156 | 13495.5 |
| 917 | 2025-07-24 02:03:44 | alleles | 1 | 69583 | 4 | 5.126 | 13574.5 |
| 916 | 2025-07-22 23:38:56 | alleles | 1 | 69583 | 4 | 6.266 | 11104.9 |
| 915 | 2025-07-22 14:19:09 | alleles | 1 | 69583 | 4 | 4.530 | 15360.5 |
| 914 | 2025-07-14 16:18:10 | alleles | 2 | 107671 | 23 | 23.580 | 4566.2 |
| 913 | 2025-07-11 09:41:07 | alleles | 2 | 107671 | 23 | 32.926 | 3270.1 |
| 912 | 2025-07-10 13:44:05 | alleles | 1 | 69583 | 4 | 2.733 | 25460.3 |
| 911 | 2025-07-02 09:35:15 | alleles | 1 | 69583 | 4 | 5.750 | 12101.4 |
| 910 | 2025-06-29 23:02:57 | alleles | 1 | 69583 | 4 | 5.860 | 11874.2 |
| 909 | 2025-06-26 06:17:20 | alleles | 3 | 134027 | 310 | 34.110 | 3929.3 |
| 908 | 2025-06-24 18:21:58 | alleles | 3 | 134027 | 310 | 25.956 | 5163.6 |
| 907 | 2025-06-24 12:57:42 | alleles | 3 | 134027 | 310 | 36.956 | 3626.7 |
| 906 | 2025-06-22 03:49:13 | alleles | 3 | 134027 | 310 | 35.440 | 3781.8 |
| 905 | 2025-06-21 10:29:45 | alleles | 1 | 69583 | 4 | 5.953 | 11688.7 |
| 904 | 2025-06-17 17:56:21 | alleles | 1 | 69583 | 4 | 1.560 | 44604.5 |
| 903 | 2025-06-10 12:20:15 | alleles | 1 | 69583 | 4 | 8.110 | 8579.9 |
| 902 | 2025-06-04 06:30:32 | alleles | 1 | 69583 | 4 | 3.220 | 21609.6 |
| 901 | 2025-05-20 17:14:13 | alleles | 1 | 69583 | 4 | 6.220 | 11187.0 |
| 900 | 2025-05-18 10:40:31 | alleles | 1 | 69583 | 4 | 3.280 | 21214.3 |
| 899 | 2025-05-18 08:36:54 | alleles | 1 | 69583 | 4 | 3.016 | 23071.3 |
| 898 | 2025-05-10 18:24:05 | alleles | 1 | 69583 | 4 | 8.720 | 7979.7 |
| 897 | 2025-05-10 10:21:13 | alleles | 1 | 69583 | 4 | 6.986 | 9960.3 |
| 896 | 2025-05-06 19:00:26 | alleles | 1 | 69583 | 4 | 9.186 | 7574.9 |
| 895 | 2025-05-05 05:36:02 | alleles | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 894 | 2025-05-02 08:44:42 | alleles | 1 | 69583 | 4 | 4.016 | 17326.4 |
| 893 | 2025-04-20 15:30:13 | alleles | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 892 | 2025-04-17 08:38:03 | alleles | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 891 | 2025-04-08 11:44:59 | alleles | 1 | 69583 | 4 | 6.686 | 10407.3 |
| 890 | 2025-03-31 10:12:48 | alleles | 1 | 69583 | 4 | 4.110 | 16930.2 |
| 889 | 2025-03-21 03:47:47 | alleles | 2 | 107671 | 23 | 16.190 | 6650.5 |
| 888 | 2025-03-21 02:48:29 | alleles | 3 | 134027 | 310 | 36.843 | 3637.8 |
| 887 | 2025-03-19 17:52:37 | alleles | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 886 | 2025-03-17 08:24:07 | alleles | 1 | 69583 | 4 | 3.440 | 20227.6 |
| 885 | 2025-03-16 13:26:11 | alleles | 1 | 69583 | 4 | 3.686 | 18877.6 |
| 884 | 2025-03-04 13:44:43 | alleles | 3 | 134027 | 310 | 36.983 | 3624.0 |
| 883 | 2025-03-04 03:52:37 | alleles | 3 | 134027 | 310 | 21.720 | 6170.7 |
| 882 | 2025-03-04 03:37:27 | alleles | 3 | 134027 | 310 | 49.033 | 2733.4 |
| 881 | 2025-03-03 22:16:39 | alleles | 3 | 134027 | 310 | 35.483 | 3777.2 |
| 880 | 2025-03-03 21:28:34 | alleles | 3 | 134027 | 310 | 31.786 | 4216.5 |
| 879 | 2025-03-03 21:28:33 | alleles | 2 | 107671 | 23 | 16.033 | 6715.6 |
| 878 | 2025-03-03 21:28:26 | alleles | 1 | 69583 | 4 | 4.266 | 16311.1 |
| 877 | 2025-03-02 13:42:49 | alleles | 1 | 69583 | 4 | 5.810 | 11976.4 |
| 876 | 2025-02-26 10:58:58 | alleles | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 875 | 2025-01-29 12:29:39 | alleles | 1 | 69583 | 4 | 6.076 | 11452.1 |
| 874 | 2025-01-26 21:52:46 | alleles | 3 | 134027 | 310 | 24.063 | 5569.8 |
| 873 | 2025-01-25 17:07:04 | alleles | 3 | 134027 | 310 | 22.223 | 6031.0 |
| 872 | 2025-01-25 14:38:26 | alleles | 3 | 134027 | 310 | 28.003 | 4786.2 |
| 871 | 2025-01-25 12:56:49 | alleles | 3 | 134027 | 310 | 34.703 | 3862.1 |
| 870 | 2025-01-25 12:56:38 | alleles | 2 | 107671 | 23 | 16.126 | 6676.9 |
| 869 | 2025-01-25 12:56:23 | alleles | 1 | 69583 | 4 | 2.936 | 23699.9 |
| 868 | 2024-12-29 12:06:20 | alleles | 1 | 69583 | 4 | 6.720 | 10354.6 |
| 867 | 2024-12-28 15:18:41 | alleles | 1 | 69583 | 4 | 8.266 | 8418.0 |
| 866 | 2024-12-21 12:22:03 | alleles | 1 | 69583 | 4 | 5.470 | 12720.8 |
| 865 | 2024-11-29 10:14:10 | alleles | 1 | 69583 | 4 | 2.093 | 33245.6 |
| 864 | 2024-11-25 21:53:26 | alleles | 1 | 69583 | 4 | 5.783 | 12032.3 |
| 863 | 2024-10-21 03:57:59 | alleles | 2 | 107671 | 23 | 14.770 | 7289.8 |
| 862 | 2024-10-21 03:57:06 | alleles | 1 | 69583 | 4 | 4.953 | 14048.7 |
| 861 | 2024-09-29 11:29:34 | alleles | 3 | 134027 | 310 | 52.720 | 2542.2 |
| 860 | 2024-09-28 21:31:25 | alleles | 3 | 134027 | 310 | 76.953 | 1741.7 |
| 859 | 2024-09-24 01:18:45 | alleles | 1 | 69583 | 4 | 5.110 | 13617.0 |
| 858 | 2024-09-23 15:06:17 | alleles | 2 | 107671 | 23 | 26.316 | 4091.5 |
| 857 | 2024-09-23 15:06:24 | alleles | 2 | 107671 | 23 | 17.390 | 6191.5 |
| 856 | 2024-09-22 23:14:15 | alleles | 3 | 134027 | 310 | 57.003 | 2351.2 |
| 855 | 2024-09-22 23:14:18 | alleles | 2 | 107671 | 23 | 29.550 | 3643.7 |
| 854 | 2024-09-22 23:14:06 | alleles | 1 | 69583 | 4 | 5.110 | 13617.0 |
| 853 | 2024-09-18 06:44:53 | alleles | 1 | 69583 | 4 | 4.186 | 16622.8 |
| 852 | 2024-09-05 23:06:59 | alleles | 1 | 69583 | 4 | 12.563 | 5538.7 |
| 851 | 2024-08-24 22:38:30 | alleles | 1 | 69583 | 4 | 10.923 | 6370.3 |
| 850 | 2024-08-17 11:46:45 | alleles | 1 | 69583 | 4 | 5.063 | 13743.4 |
| 849 | 2024-08-14 14:04:26 | alleles | 1 | 69583 | 4 | 7.096 | 9805.9 |
| 848 | 2024-08-09 19:21:47 | alleles | 1 | 69583 | 4 | 3.280 | 21214.3 |
| 847 | 2024-08-08 22:44:40 | alleles | 1 | 69583 | 4 | 6.076 | 11452.1 |
| 846 | 2024-08-07 19:31:42 | alleles | 1 | 69583 | 4 | 3.330 | 20895.8 |
| 845 | 2024-07-23 17:33:30 | alleles | 1 | 69583 | 4 | 3.783 | 18393.6 |