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 |
| 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 |
| 890 | 2023-09-26 03:15:11 | habitat | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 889 | 2023-09-17 03:40:37 | habitat | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 888 | 2023-09-13 22:19:02 | habitat | 4 | 151207 | 1128 | 21.016 | 7194.9 |
| 887 | 2023-08-24 15:05:01 | habitat | 4 | 151207 | 1128 | 10.720 | 14105.1 |
| 886 | 2023-08-13 13:55:16 | habitat | 4 | 151207 | 1128 | 10.110 | 14956.2 |
| 885 | 2023-08-09 02:44:03 | habitat | 4 | 151207 | 1128 | 11.483 | 13167.9 |
| 884 | 2023-08-05 11:05:34 | habitat | 3 | 134027 | 80 | 6.530 | 20524.8 |
| 883 | 2023-07-23 18:32:30 | habitat | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 882 | 2023-07-21 16:50:34 | habitat | 2 | 107671 | 13 | 3.310 | 32529.0 |
| 881 | 2023-07-18 11:29:52 | habitat | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 880 | 2023-07-15 22:59:52 | habitat | 4 | 151207 | 1128 | 9.843 | 15361.9 |
| 879 | 2023-07-09 23:58:50 | habitat | 4 | 151207 | 1128 | 10.733 | 14088.0 |
| 878 | 2023-06-12 21:16:01 | habitat | 4 | 151207 | 1128 | 20.000 | 7560.4 |
| 877 | 2023-04-23 17:09:19 | habitat | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 876 | 2023-04-19 11:58:19 | habitat | 3 | 134027 | 80 | 5.673 | 23625.4 |
| 875 | 2023-04-04 06:36:27 | habitat | 2 | 107671 | 13 | 2.766 | 38926.6 |
| 874 | 2023-04-03 06:37:42 | habitat | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 873 | 2023-03-31 12:51:13 | habitat | 4 | 151207 | 1128 | 13.016 | 11617.0 |
| 872 | 2023-03-13 06:42:29 | habitat | 4 | 151207 | 1128 | 9.873 | 15315.2 |
| 871 | 2023-02-16 02:59:08 | habitat | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 870 | 2023-01-22 07:51:13 | habitat | 3 | 134027 | 80 | 5.640 | 23763.7 |
| 869 | 2023-01-01 18:33:33 | habitat | 2 | 107671 | 13 | 2.766 | 38926.6 |
| 868 | 2022-12-19 20:00:41 | habitat | 4 | 151207 | 1128 | 11.736 | 12884.0 |
| 867 | 2022-12-18 11:55:26 | habitat | 4 | 151207 | 1128 | 14.126 | 10704.2 |
| 866 | 2022-12-17 16:45:27 | habitat | 4 | 151207 | 1128 | 11.876 | 12732.1 |
| 865 | 2022-12-17 08:24:48 | habitat | 4 | 151207 | 1128 | 10.610 | 14251.4 |
| 864 | 2022-12-16 19:45:12 | habitat | 4 | 151207 | 1128 | 17.420 | 8680.1 |
| 863 | 2022-12-14 23:23:41 | habitat | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 862 | 2022-12-13 21:07:29 | habitat | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 861 | 2022-12-13 11:53:23 | habitat | 4 | 151207 | 1128 | 10.986 | 13763.6 |
| 860 | 2022-12-12 15:23:13 | habitat | 4 | 151207 | 1128 | 10.623 | 14233.9 |
| 859 | 2022-12-09 14:02:05 | habitat | 4 | 151207 | 1128 | 12.516 | 12081.1 |
| 858 | 2022-12-08 19:47:57 | habitat | 4 | 151207 | 1128 | 19.550 | 7734.4 |
| 857 | 2022-11-03 16:23:31 | habitat | 3 | 134027 | 80 | 5.953 | 22514.2 |
| 856 | 2022-10-21 21:13:00 | habitat | 4 | 151207 | 1128 | 9.893 | 15284.2 |
| 855 | 2022-10-15 19:18:18 | habitat | 4 | 151207 | 1128 | 9.906 | 15264.2 |
| 854 | 2022-09-18 10:40:17 | habitat | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 853 | 2022-09-17 20:10:17 | habitat | 4 | 151207 | 1128 | 10.253 | 14747.6 |
| 852 | 2022-09-09 10:38:16 | habitat | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 851 | 2022-09-06 16:42:35 | habitat | 4 | 151207 | 1128 | 10.800 | 14000.6 |
| 850 | 2022-09-02 12:06:42 | habitat | 2 | 107671 | 13 | 3.203 | 33615.7 |
| 849 | 2022-08-31 07:11:57 | habitat | 2 | 107671 | 13 | 2.843 | 37872.3 |
| 848 | 2022-08-18 13:00:43 | habitat | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 847 | 2022-08-17 23:48:25 | habitat | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 846 | 2022-08-16 03:59:34 | habitat | 1 | 69583 | 4 | 1.160 | 59985.3 |
| 845 | 2022-08-15 10:25:58 | habitat | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 844 | 2022-08-09 11:39:28 | habitat | 4 | 151207 | 1128 | 10.046 | 15051.5 |
| 843 | 2022-08-06 04:57:11 | habitat | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 842 | 2022-07-17 18:21:03 | habitat | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 841 | 2022-07-10 02:26:57 | habitat | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 840 | 2022-07-02 14:32:16 | habitat | 1 | 69583 | 4 | 1.046 | 66522.9 |