History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"topsoil"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 954 | 2026-01-16 00:12:47 | topsoil | 4 | 151207 | 724 | 59.516 | 2540.6 |
| 953 | 2026-01-14 18:12:20 | topsoil | 2 | 107671 | 8 | 3.203 | 33615.7 |
| 952 | 2026-01-14 15:36:05 | topsoil | 2 | 107671 | 8 | 4.640 | 23205.0 |
| 951 | 2026-01-14 15:13:34 | topsoil | 2 | 107671 | 8 | 3.220 | 33438.2 |
| 950 | 2026-01-12 00:11:34 | topsoil | 4 | 151207 | 724 | 10.376 | 14572.8 |
| 949 | 2026-01-10 16:19:41 | topsoil | 1 | 69583 | 3 | 3.533 | 19695.2 |
| 948 | 2026-01-10 16:12:29 | topsoil | 1 | 69583 | 3 | 5.280 | 13178.6 |
| 947 | 2026-01-09 13:08:32 | topsoil | 4 | 151207 | 724 | 40.990 | 3688.9 |
| 946 | 2026-01-09 13:08:37 | topsoil | 4 | 151207 | 724 | 33.236 | 4549.5 |
| 945 | 2026-01-08 00:09:09 | topsoil | 4 | 151207 | 724 | 12.486 | 12110.1 |
| 944 | 2026-01-04 02:12:37 | topsoil | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 943 | 2026-01-04 00:37:34 | topsoil | 4 | 151207 | 724 | 10.330 | 14637.7 |
| 942 | 2026-01-01 15:20:25 | topsoil | 1 | 69583 | 3 | 6.016 | 11566.3 |
| 941 | 2025-12-31 06:38:25 | topsoil | 4 | 151207 | 724 | 10.830 | 13961.9 |
| 940 | 2025-12-31 00:36:59 | topsoil | 4 | 151207 | 724 | 15.703 | 9629.2 |
| 939 | 2025-12-30 19:17:14 | topsoil | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 938 | 2025-12-29 07:18:06 | topsoil | 1 | 69583 | 3 | 2.453 | 28366.5 |
| 937 | 2025-12-29 07:17:52 | topsoil | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 936 | 2025-12-27 21:34:07 | topsoil | 2 | 107671 | 8 | 3.250 | 33129.5 |
| 935 | 2025-12-27 12:09:33 | topsoil | 3 | 134027 | 66 | 6.016 | 22278.4 |
| 934 | 2025-12-27 05:11:06 | topsoil | 4 | 151207 | 724 | 12.390 | 12204.0 |
| 933 | 2025-12-27 05:10:55 | topsoil | 4 | 151207 | 724 | 14.203 | 10646.1 |
| 932 | 2025-12-26 00:34:05 | topsoil | 3 | 134027 | 66 | 7.373 | 18178.1 |
| 931 | 2025-12-23 07:03:26 | topsoil | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 930 | 2025-12-23 06:49:35 | topsoil | 4 | 151207 | 724 | 22.580 | 6696.5 |
| 929 | 2025-12-23 06:49:25 | topsoil | 4 | 151207 | 724 | 22.096 | 6843.2 |
| 928 | 2025-12-22 22:21:57 | topsoil | 4 | 151207 | 724 | 19.406 | 7791.8 |
| 927 | 2025-12-22 15:20:47 | topsoil | 4 | 151207 | 724 | 42.613 | 3548.4 |
| 926 | 2025-12-20 12:05:34 | topsoil | 4 | 151207 | 724 | 10.406 | 14530.8 |
| 925 | 2025-12-19 11:40:29 | topsoil | 4 | 151207 | 724 | 50.846 | 2973.8 |
| 924 | 2025-12-17 17:21:15 | topsoil | 4 | 151207 | 724 | 13.046 | 11590.3 |
| 923 | 2025-12-14 06:38:31 | topsoil | 4 | 151207 | 724 | 56.050 | 2697.7 |
| 922 | 2025-12-14 05:06:49 | topsoil | 4 | 151207 | 724 | 12.143 | 12452.2 |
| 921 | 2025-12-14 03:53:06 | topsoil | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 920 | 2025-12-13 04:12:09 | topsoil | 4 | 151207 | 724 | 11.080 | 13646.8 |
| 919 | 2025-12-11 03:31:03 | topsoil | 4 | 151207 | 724 | 10.923 | 13843.0 |
| 918 | 2025-12-10 02:02:59 | topsoil | 4 | 151207 | 724 | 30.690 | 4926.9 |
| 917 | 2025-12-09 01:31:42 | topsoil | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 916 | 2025-12-06 23:50:39 | topsoil | 4 | 151207 | 724 | 22.656 | 6674.0 |
| 915 | 2025-11-25 18:30:06 | topsoil | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 914 | 2025-11-24 04:57:45 | topsoil | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 913 | 2025-11-22 18:46:35 | topsoil | 4 | 151207 | 724 | 12.346 | 12247.4 |
| 912 | 2025-11-21 18:23:52 | topsoil | 4 | 151207 | 724 | 21.330 | 7088.9 |
| 911 | 2025-10-25 16:12:19 | topsoil | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 910 | 2025-10-25 08:17:59 | topsoil | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 909 | 2025-10-25 01:10:20 | topsoil | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 908 | 2025-10-24 03:12:00 | topsoil | 1 | 69583 | 3 | 1.090 | 63837.6 |
| 907 | 2025-10-24 02:19:13 | topsoil | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 906 | 2025-10-22 06:26:19 | topsoil | 1 | 69583 | 3 | 4.436 | 15686.0 |
| 905 | 2025-10-17 01:01:55 | topsoil | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 904 | 2025-10-15 19:41:53 | topsoil | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 903 | 2025-10-12 17:35:15 | topsoil | 4 | 151207 | 724 | 10.890 | 13884.9 |
| 902 | 2025-09-30 14:04:15 | topsoil | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 901 | 2025-09-14 17:47:54 | topsoil | 4 | 151207 | 724 | 34.786 | 4346.8 |
| 900 | 2025-09-14 08:31:44 | topsoil | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 899 | 2025-09-13 21:01:59 | topsoil | 4 | 151207 | 724 | 12.050 | 12548.3 |
| 898 | 2025-09-12 04:17:04 | topsoil | 4 | 151207 | 724 | 11.986 | 12615.3 |
| 897 | 2025-09-10 20:49:42 | topsoil | 3 | 134027 | 66 | 7.563 | 17721.4 |
| 896 | 2025-09-09 16:41:49 | topsoil | 1 | 69583 | 3 | 1.300 | 53525.4 |
| 895 | 2025-09-08 20:02:33 | topsoil | 3 | 134027 | 66 | 6.220 | 21547.7 |
| 894 | 2025-09-07 22:00:39 | topsoil | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 893 | 2025-09-06 23:58:01 | topsoil | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 892 | 2025-09-03 04:04:13 | topsoil | 1 | 69583 | 3 | 2.876 | 24194.4 |
| 891 | 2025-09-01 01:13:34 | topsoil | 1 | 69583 | 3 | 2.486 | 27989.9 |
| 890 | 2025-08-27 02:13:18 | topsoil | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 889 | 2025-08-25 17:11:51 | topsoil | 1 | 69583 | 3 | 5.140 | 13537.5 |
| 888 | 2025-08-24 19:54:16 | topsoil | 3 | 134027 | 66 | 32.640 | 4106.2 |
| 887 | 2025-08-22 20:19:37 | topsoil | 3 | 134027 | 66 | 29.876 | 4486.1 |
| 886 | 2025-08-22 18:07:17 | topsoil | 2 | 107671 | 8 | 2.876 | 37437.8 |
| 885 | 2025-08-09 11:41:22 | topsoil | 1 | 69583 | 3 | 8.606 | 8085.4 |
| 884 | 2025-08-04 22:22:25 | topsoil | 3 | 134027 | 66 | 29.720 | 4509.7 |
| 883 | 2025-08-04 14:24:47 | topsoil | 2 | 107671 | 8 | 2.970 | 36252.9 |
| 882 | 2025-08-04 08:34:38 | topsoil | 3 | 134027 | 66 | 29.250 | 4582.1 |
| 881 | 2025-08-03 16:23:51 | topsoil | 1 | 69583 | 3 | 2.466 | 28217.0 |
| 880 | 2025-08-03 06:36:30 | topsoil | 1 | 69583 | 3 | 6.016 | 11566.3 |
| 879 | 2025-08-03 00:17:27 | topsoil | 4 | 151207 | 724 | 28.016 | 5397.2 |
| 878 | 2025-08-02 04:01:12 | topsoil | 1 | 69583 | 3 | 2.596 | 26803.9 |
| 877 | 2025-08-01 09:58:12 | topsoil | 3 | 134027 | 66 | 18.063 | 7420.0 |
| 876 | 2025-08-01 07:24:52 | topsoil | 2 | 107671 | 8 | 8.626 | 12482.1 |
| 875 | 2025-08-01 02:33:24 | topsoil | 3 | 134027 | 66 | 48.050 | 2789.3 |
| 874 | 2025-07-31 21:13:28 | topsoil | 1 | 69583 | 3 | 3.156 | 22047.8 |
| 873 | 2025-07-31 02:40:08 | topsoil | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 872 | 2025-07-27 21:54:23 | topsoil | 4 | 151207 | 724 | 35.623 | 4244.6 |
| 871 | 2025-07-27 06:03:18 | topsoil | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 870 | 2025-07-25 01:40:43 | topsoil | 4 | 151207 | 724 | 42.666 | 3544.0 |
| 869 | 2025-07-24 11:21:52 | topsoil | 1 | 69583 | 3 | 5.813 | 11970.2 |
| 868 | 2025-07-22 11:10:36 | topsoil | 1 | 69583 | 3 | 5.593 | 12441.1 |
| 867 | 2025-07-21 15:08:51 | topsoil | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 866 | 2025-07-18 17:00:48 | topsoil | 4 | 151207 | 724 | 51.906 | 2913.1 |
| 865 | 2025-07-18 03:12:41 | topsoil | 4 | 151207 | 724 | 45.610 | 3315.2 |
| 864 | 2025-07-17 23:01:24 | topsoil | 4 | 151207 | 724 | 51.833 | 2917.2 |
| 863 | 2025-07-17 04:20:46 | topsoil | 4 | 151207 | 724 | 29.280 | 5164.2 |
| 862 | 2025-07-16 15:03:07 | topsoil | 4 | 151207 | 724 | 11.483 | 13167.9 |
| 861 | 2025-07-16 10:08:33 | topsoil | 1 | 69583 | 3 | 1.813 | 38380.0 |
| 860 | 2025-07-15 15:00:12 | topsoil | 1 | 69583 | 3 | 8.720 | 7979.7 |
| 859 | 2025-07-14 05:10:16 | topsoil | 1 | 69583 | 3 | 2.970 | 23428.6 |
| 858 | 2025-07-07 20:09:42 | topsoil | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 857 | 2025-06-29 20:03:44 | topsoil | 1 | 69583 | 3 | 4.360 | 15959.4 |
| 856 | 2025-06-26 05:46:13 | topsoil | 1 | 69583 | 3 | 5.486 | 12683.7 |
| 855 | 2025-06-20 07:21:37 | topsoil | 1 | 69583 | 3 | 6.220 | 11187.0 |