History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"habitat"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 990 | 2024-11-28 15:11:05 | habitat | 1 | 69583 | 4 | 5.906 | 11781.7 |
| 989 | 2024-11-23 21:10:08 | habitat | 1 | 69583 | 4 | 3.000 | 23194.3 |
| 988 | 2024-11-07 21:39:21 | habitat | 1 | 69583 | 4 | 3.266 | 21305.3 |
| 987 | 2024-11-05 08:30:48 | habitat | 1 | 69583 | 4 | 5.890 | 11813.8 |
| 986 | 2024-11-03 05:30:25 | habitat | 1 | 69583 | 4 | 3.093 | 22496.9 |
| 985 | 2024-10-21 05:25:15 | habitat | 2 | 107671 | 13 | 11.140 | 9665.3 |
| 984 | 2024-10-21 05:25:02 | habitat | 1 | 69583 | 4 | 5.610 | 12403.4 |
| 983 | 2024-10-15 18:58:18 | habitat | 3 | 134027 | 80 | 34.343 | 3902.6 |
| 982 | 2024-10-13 13:39:54 | habitat | 3 | 134027 | 80 | 16.860 | 7949.4 |
| 981 | 2024-10-12 10:42:35 | habitat | 3 | 134027 | 80 | 52.110 | 2572.0 |
| 980 | 2024-10-10 20:10:58 | habitat | 3 | 134027 | 80 | 15.830 | 8466.6 |
| 979 | 2024-10-10 03:49:36 | habitat | 2 | 107671 | 13 | 12.686 | 8487.4 |
| 978 | 2024-10-08 11:17:57 | habitat | 1 | 69583 | 4 | 4.953 | 14048.7 |
| 977 | 2024-09-30 12:17:02 | habitat | 2 | 107671 | 13 | 29.173 | 3690.8 |
| 976 | 2024-09-30 01:34:17 | habitat | 2 | 107671 | 13 | 23.470 | 4587.6 |
| 975 | 2024-09-29 10:50:32 | habitat | 2 | 107671 | 13 | 17.263 | 6237.1 |
| 974 | 2024-09-25 01:29:46 | habitat | 1 | 69583 | 4 | 4.393 | 15839.5 |
| 973 | 2024-09-16 00:24:26 | habitat | 2 | 107671 | 13 | 34.496 | 3121.3 |
| 972 | 2024-09-16 00:21:23 | habitat | 1 | 69583 | 4 | 2.376 | 29285.8 |
| 971 | 2024-09-02 09:35:58 | habitat | 1 | 69583 | 4 | 9.860 | 7057.1 |
| 970 | 2024-08-31 02:34:26 | habitat | 1 | 69583 | 4 | 4.986 | 13955.7 |
| 969 | 2024-08-22 23:53:52 | habitat | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 968 | 2024-08-17 15:16:44 | habitat | 3 | 134027 | 80 | 54.783 | 2446.5 |
| 967 | 2024-08-15 17:55:37 | habitat | 3 | 134027 | 80 | 44.633 | 3002.9 |
| 966 | 2024-08-15 09:10:44 | habitat | 3 | 134027 | 80 | 80.803 | 1658.7 |
| 965 | 2024-08-15 05:33:48 | habitat | 3 | 134027 | 80 | 56.706 | 2363.5 |
| 964 | 2024-08-15 02:01:58 | habitat | 3 | 134027 | 80 | 45.676 | 2934.3 |
| 963 | 2024-08-14 23:55:13 | habitat | 3 | 134027 | 80 | 95.443 | 1404.3 |
| 962 | 2024-08-14 23:55:21 | habitat | 3 | 134027 | 80 | 32.330 | 4145.6 |
| 961 | 2024-08-14 23:55:02 | habitat | 2 | 107671 | 13 | 11.126 | 9677.4 |
| 960 | 2024-08-14 21:59:22 | habitat | 3 | 134027 | 80 | 56.470 | 2373.4 |
| 959 | 2024-08-14 21:57:36 | habitat | 4 | 151207 | 1128 | 98.866 | 1529.4 |
| 958 | 2024-08-14 21:57:34 | habitat | 2 | 107671 | 13 | 23.566 | 4568.9 |
| 957 | 2024-08-14 21:57:17 | habitat | 1 | 69583 | 4 | 9.766 | 7125.0 |
| 956 | 2024-08-07 05:38:24 | habitat | 1 | 69583 | 4 | 7.220 | 9637.5 |
| 955 | 2024-07-31 07:29:50 | habitat | 1 | 69583 | 4 | 4.266 | 16311.1 |
| 954 | 2024-07-24 09:15:48 | habitat | 1 | 69583 | 4 | 4.550 | 15293.0 |
| 953 | 2024-07-22 21:36:18 | habitat | 1 | 69583 | 4 | 5.470 | 12720.8 |
| 952 | 2024-07-16 02:38:05 | habitat | 1 | 69583 | 4 | 2.096 | 33198.0 |
| 951 | 2024-06-20 00:53:04 | habitat | 1 | 69583 | 4 | 5.686 | 12237.6 |
| 950 | 2024-06-17 04:25:13 | habitat | 1 | 69583 | 4 | 3.326 | 20920.9 |
| 949 | 2024-06-16 08:45:06 | habitat | 1 | 69583 | 4 | 3.483 | 19977.9 |
| 948 | 2024-06-15 14:03:18 | habitat | 3 | 134027 | 80 | 15.280 | 8771.4 |
| 947 | 2024-06-14 15:24:10 | habitat | 3 | 134027 | 80 | 15.206 | 8814.1 |
| 946 | 2024-06-07 15:11:53 | habitat | 3 | 134027 | 80 | 31.500 | 4254.8 |
| 945 | 2024-06-07 03:30:35 | habitat | 1 | 69583 | 4 | 6.923 | 10051.0 |
| 944 | 2024-06-07 03:26:11 | habitat | 3 | 134027 | 80 | 22.316 | 6005.9 |
| 943 | 2024-06-03 00:59:29 | habitat | 3 | 134027 | 80 | 6.703 | 19995.1 |
| 942 | 2024-06-02 20:26:35 | habitat | 1 | 69583 | 4 | 4.033 | 17253.4 |
| 941 | 2024-05-15 04:48:29 | habitat | 4 | 151207 | 1128 | 34.330 | 4404.5 |
| 940 | 2024-05-14 10:32:32 | habitat | 4 | 151207 | 1128 | 40.236 | 3758.0 |
| 939 | 2024-05-08 01:11:02 | habitat | 2 | 107671 | 13 | 3.860 | 27894.0 |
| 938 | 2024-04-29 02:53:34 | habitat | 4 | 151207 | 1128 | 37.143 | 4070.9 |
| 937 | 2024-04-28 15:34:23 | habitat | 4 | 151207 | 1128 | 18.733 | 8071.7 |
| 936 | 2024-04-28 15:08:42 | habitat | 4 | 151207 | 1128 | 20.546 | 7359.4 |
| 935 | 2024-04-28 11:26:58 | habitat | 4 | 151207 | 1128 | 14.440 | 10471.4 |
| 934 | 2024-04-28 10:56:37 | habitat | 4 | 151207 | 1128 | 13.890 | 10886.0 |
| 933 | 2024-04-28 04:59:18 | habitat | 1 | 69583 | 4 | 2.096 | 33198.0 |
| 932 | 2024-04-02 17:39:56 | habitat | 1 | 69583 | 4 | 4.220 | 16488.9 |
| 931 | 2024-03-31 05:54:05 | habitat | 1 | 69583 | 4 | 4.233 | 16438.2 |
| 930 | 2024-03-20 11:18:55 | habitat | 4 | 151207 | 1128 | 11.046 | 13688.8 |
| 929 | 2024-03-18 21:20:15 | habitat | 4 | 151207 | 1128 | 12.970 | 11658.2 |
| 928 | 2024-03-15 21:10:44 | habitat | 4 | 151207 | 1128 | 11.686 | 12939.2 |
| 927 | 2024-03-15 02:28:04 | habitat | 4 | 151207 | 1128 | 14.173 | 10668.7 |
| 926 | 2024-03-14 23:45:47 | habitat | 4 | 151207 | 1128 | 16.233 | 9314.8 |
| 925 | 2024-03-14 14:11:45 | habitat | 4 | 151207 | 1128 | 39.470 | 3830.9 |
| 924 | 2024-03-14 10:25:01 | habitat | 4 | 151207 | 1128 | 18.906 | 7997.8 |
| 923 | 2024-03-14 10:23:12 | habitat | 4 | 151207 | 1128 | 16.190 | 9339.5 |
| 922 | 2024-03-04 09:43:20 | habitat | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 921 | 2024-02-27 23:20:03 | habitat | 1 | 69583 | 4 | 1.360 | 51164.0 |
| 920 | 2024-02-04 07:21:55 | habitat | 4 | 151207 | 1128 | 37.656 | 4015.5 |
| 919 | 2024-01-31 02:47:16 | habitat | 4 | 151207 | 1128 | 14.016 | 10788.2 |
| 918 | 2024-01-27 12:02:07 | habitat | 4 | 151207 | 1128 | 15.766 | 9590.7 |
| 917 | 2024-01-27 10:50:25 | habitat | 4 | 151207 | 1128 | 11.346 | 13326.9 |
| 916 | 2024-01-17 09:33:46 | habitat | 3 | 134027 | 80 | 6.280 | 21341.9 |
| 915 | 2024-01-05 14:30:12 | habitat | 4 | 151207 | 1128 | 9.860 | 15335.4 |
| 914 | 2024-01-04 08:03:13 | habitat | 2 | 107671 | 13 | 3.250 | 33129.5 |
| 913 | 2023-12-31 17:13:57 | habitat | 4 | 151207 | 1128 | 11.280 | 13404.9 |
| 912 | 2023-12-24 12:36:14 | habitat | 1 | 69583 | 4 | 1.300 | 53525.4 |
| 911 | 2023-12-23 16:21:34 | habitat | 4 | 151207 | 1128 | 10.080 | 15000.7 |
| 910 | 2023-12-18 09:54:51 | habitat | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 909 | 2023-12-17 01:49:29 | habitat | 3 | 134027 | 80 | 7.703 | 17399.3 |
| 908 | 2023-12-13 21:34:15 | habitat | 4 | 151207 | 1128 | 10.060 | 15030.5 |
| 907 | 2023-12-10 10:26:46 | habitat | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 906 | 2023-12-01 18:25:58 | habitat | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 905 | 2023-11-30 20:02:20 | habitat | 4 | 151207 | 1128 | 22.186 | 6815.4 |
| 904 | 2023-11-18 14:16:25 | habitat | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 903 | 2023-11-14 14:43:35 | habitat | 4 | 151207 | 1128 | 14.300 | 10573.9 |
| 902 | 2023-11-12 22:06:54 | habitat | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 901 | 2023-11-04 01:45:28 | habitat | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 900 | 2023-10-30 18:45:35 | habitat | 4 | 151207 | 1128 | 11.843 | 12767.6 |
| 899 | 2023-10-29 02:47:19 | habitat | 3 | 134027 | 80 | 6.593 | 20328.7 |
| 898 | 2023-10-24 03:04:12 | habitat | 4 | 151207 | 1128 | 26.406 | 5726.2 |
| 897 | 2023-10-17 15:56:09 | habitat | 4 | 151207 | 1128 | 21.673 | 6976.7 |
| 896 | 2023-10-10 03:25:04 | habitat | 2 | 107671 | 13 | 6.296 | 17101.5 |
| 895 | 2023-10-09 20:14:25 | habitat | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 894 | 2023-10-07 08:05:16 | habitat | 4 | 151207 | 1128 | 20.516 | 7370.2 |
| 893 | 2023-09-30 21:55:21 | habitat | 4 | 151207 | 1128 | 26.376 | 5732.7 |
| 892 | 2023-09-27 17:06:51 | habitat | 4 | 151207 | 1128 | 11.486 | 13164.5 |
| 891 | 2023-09-26 12:33:58 | habitat | 1 | 69583 | 4 | 1.093 | 63662.4 |