History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subzones"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1990 | 2025-12-26 03:28:02 | subzones | 4 | 161609 | 942 | 12.203 | 13243.4 |
| 1989 | 2025-12-25 16:39:29 | subzones | 4 | 161609 | 942 | 23.436 | 6895.8 |
| 1988 | 2025-12-25 07:13:34 | subzones | 4 | 161609 | 942 | 41.020 | 3939.8 |
| 1987 | 2025-12-25 07:13:44 | subzones | 4 | 161609 | 942 | 30.750 | 5255.6 |
| 1986 | 2025-12-23 16:56:54 | subzones | 4 | 161609 | 942 | 13.720 | 11779.1 |
| 1985 | 2025-12-23 16:55:29 | subzones | 4 | 161609 | 942 | 19.656 | 8221.9 |
| 1984 | 2025-12-20 15:50:29 | subzones | 4 | 161609 | 942 | 21.393 | 7554.3 |
| 1983 | 2025-12-20 13:40:01 | subzones | 2 | 121059 | 8 | 3.843 | 31501.2 |
| 1982 | 2025-12-20 13:28:51 | subzones | 2 | 121059 | 8 | 3.873 | 31257.2 |
| 1981 | 2025-12-20 08:55:33 | subzones | 1 | 82945 | 3 | 1.550 | 53512.9 |
| 1980 | 2025-12-20 08:51:54 | subzones | 1 | 82945 | 3 | 3.046 | 27230.8 |
| 1979 | 2025-12-20 06:20:18 | subzones | 4 | 161609 | 942 | 31.376 | 5150.7 |
| 1978 | 2025-12-20 06:20:07 | subzones | 4 | 161609 | 942 | 35.896 | 4502.1 |
| 1977 | 2025-12-19 17:54:36 | subzones | 4 | 161609 | 942 | 47.720 | 3386.6 |
| 1976 | 2025-12-18 17:13:45 | subzones | 3 | 146162 | 98 | 7.593 | 19249.6 |
| 1975 | 2025-12-18 17:13:18 | subzones | 3 | 146162 | 98 | 8.250 | 17716.6 |
| 1974 | 2025-12-18 14:19:21 | subzones | 4 | 161609 | 942 | 19.986 | 8086.1 |
| 1973 | 2025-12-17 15:08:35 | subzones | 2 | 121059 | 8 | 15.630 | 7745.3 |
| 1972 | 2025-12-17 07:10:59 | subzones | 2 | 121059 | 8 | 3.936 | 30756.9 |
| 1971 | 2025-12-16 05:23:44 | subzones | 3 | 146162 | 98 | 6.813 | 21453.4 |
| 1970 | 2025-12-15 19:37:36 | subzones | 3 | 146162 | 98 | 6.563 | 22270.6 |
| 1969 | 2025-12-14 16:39:38 | subzones | 3 | 146162 | 98 | 6.580 | 22213.1 |
| 1968 | 2025-12-14 08:15:20 | subzones | 2 | 121059 | 8 | 3.466 | 34927.6 |
| 1967 | 2025-12-13 18:40:20 | subzones | 3 | 146162 | 98 | 31.406 | 4654.0 |
| 1966 | 2025-12-12 18:57:14 | subzones | 2 | 121059 | 8 | 13.970 | 8665.6 |
| 1965 | 2025-12-12 13:38:34 | subzones | 4 | 161609 | 942 | 11.970 | 13501.2 |
| 1964 | 2025-12-12 12:05:43 | subzones | 3 | 146162 | 98 | 7.736 | 18893.7 |
| 1963 | 2025-12-12 02:11:40 | subzones | 3 | 146162 | 98 | 39.673 | 3684.2 |
| 1962 | 2025-12-10 03:07:26 | subzones | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 1961 | 2025-12-05 12:53:33 | subzones | 4 | 161609 | 942 | 11.440 | 14126.7 |
| 1960 | 2025-12-01 14:21:20 | subzones | 4 | 161609 | 942 | 21.330 | 7576.6 |
| 1959 | 2025-12-01 02:20:20 | subzones | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 1958 | 2025-11-28 06:14:52 | subzones | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 1957 | 2025-11-27 05:51:08 | subzones | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 1956 | 2025-11-25 02:42:42 | subzones | 1 | 82945 | 3 | 1.720 | 48223.8 |
| 1955 | 2025-11-24 15:51:56 | subzones | 3 | 146162 | 98 | 7.593 | 19249.6 |
| 1954 | 2025-11-17 04:00:33 | subzones | 1 | 82945 | 3 | 1.560 | 53169.9 |
| 1953 | 2025-11-14 21:13:26 | subzones | 1 | 82945 | 3 | 3.420 | 24252.9 |
| 1952 | 2025-11-11 14:02:41 | subzones | 1 | 82945 | 3 | 2.296 | 36125.9 |
| 1951 | 2025-11-10 23:05:30 | subzones | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 1950 | 2025-11-08 02:22:46 | subzones | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 1949 | 2025-11-02 11:24:22 | subzones | 3 | 146162 | 98 | 7.156 | 20425.1 |
| 1948 | 2025-11-01 17:21:31 | subzones | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 1947 | 2025-10-31 03:33:58 | subzones | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 1946 | 2025-10-28 07:03:15 | subzones | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 1945 | 2025-10-27 09:12:28 | subzones | 3 | 146162 | 98 | 6.300 | 23200.3 |
| 1944 | 2025-10-27 06:48:05 | subzones | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 1943 | 2025-10-25 06:41:54 | subzones | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 1942 | 2025-10-25 04:15:06 | subzones | 1 | 82945 | 3 | 2.016 | 41143.4 |
| 1941 | 2025-10-14 22:27:05 | subzones | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 1940 | 2025-10-12 17:27:47 | subzones | 3 | 146162 | 98 | 6.580 | 22213.1 |
| 1939 | 2025-10-11 14:09:09 | subzones | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 1938 | 2025-10-11 00:26:28 | subzones | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 1937 | 2025-10-08 03:24:44 | subzones | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 1936 | 2025-09-30 13:49:30 | subzones | 3 | 146162 | 98 | 6.310 | 23163.5 |
| 1935 | 2025-09-30 04:01:09 | subzones | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 1934 | 2025-09-27 06:47:45 | subzones | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 1933 | 2025-09-26 07:30:28 | subzones | 1 | 82945 | 3 | 1.970 | 42104.1 |
| 1932 | 2025-09-23 03:49:59 | subzones | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 1931 | 2025-09-19 23:45:32 | subzones | 3 | 146162 | 98 | 7.546 | 19369.5 |
| 1930 | 2025-09-10 14:03:31 | subzones | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 1929 | 2025-09-08 23:47:03 | subzones | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 1928 | 2025-09-07 03:08:49 | subzones | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 1927 | 2025-09-06 22:35:58 | subzones | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 1926 | 2025-09-06 16:57:20 | subzones | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 1925 | 2025-09-04 01:48:53 | subzones | 3 | 146162 | 98 | 6.843 | 21359.3 |
| 1924 | 2025-08-29 03:47:31 | subzones | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 1923 | 2025-08-27 19:14:18 | subzones | 3 | 146162 | 98 | 9.530 | 15337.0 |
| 1922 | 2025-08-27 07:04:48 | subzones | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 1921 | 2025-08-27 00:37:45 | subzones | 1 | 82945 | 3 | 1.860 | 44594.1 |
| 1920 | 2025-08-26 06:30:28 | subzones | 1 | 82945 | 3 | 5.173 | 16034.2 |
| 1919 | 2025-08-09 16:01:28 | subzones | 1 | 82945 | 3 | 6.986 | 11873.0 |
| 1918 | 2025-08-09 01:58:17 | subzones | 1 | 82945 | 3 | 5.623 | 14751.0 |
| 1917 | 2025-08-01 04:10:48 | subzones | 1 | 82945 | 3 | 9.326 | 8894.0 |
| 1916 | 2025-07-31 22:49:18 | subzones | 1 | 82945 | 3 | 3.283 | 25265.0 |
| 1915 | 2025-07-27 07:07:50 | subzones | 1 | 82945 | 3 | 6.690 | 12398.4 |
| 1914 | 2025-07-26 11:59:15 | subzones | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 1913 | 2025-07-04 07:40:23 | subzones | 1 | 82945 | 3 | 7.076 | 11722.0 |
| 1912 | 2025-06-28 01:08:50 | subzones | 1 | 82945 | 3 | 10.610 | 7817.6 |
| 1911 | 2025-06-22 04:51:31 | subzones | 1 | 82945 | 3 | 7.173 | 11563.5 |
| 1910 | 2025-06-07 07:17:44 | subzones | 3 | 146162 | 98 | 21.146 | 6912.0 |
| 1909 | 2025-05-27 07:36:15 | subzones | 3 | 146162 | 98 | 37.770 | 3869.8 |
| 1908 | 2025-05-26 01:37:55 | subzones | 1 | 82945 | 3 | 5.296 | 15661.8 |
| 1907 | 2025-05-25 17:13:07 | subzones | 3 | 146162 | 98 | 6.313 | 23152.5 |
| 1906 | 2025-05-21 20:46:32 | subzones | 3 | 146162 | 98 | 31.516 | 4637.7 |
| 1905 | 2025-05-21 08:15:15 | subzones | 2 | 121059 | 8 | 28.016 | 4321.1 |
| 1904 | 2025-05-20 15:24:06 | subzones | 4 | 161609 | 942 | 57.313 | 2819.8 |
| 1903 | 2025-05-20 10:29:09 | subzones | 4 | 161609 | 942 | 51.250 | 3153.3 |
| 1902 | 2025-05-19 17:11:03 | subzones | 3 | 146162 | 98 | 6.986 | 20922.1 |
| 1901 | 2025-05-19 13:41:10 | subzones | 3 | 146162 | 98 | 31.203 | 4684.2 |
| 1900 | 2025-05-18 02:57:02 | subzones | 3 | 146162 | 98 | 38.016 | 3844.7 |
| 1899 | 2025-05-17 14:28:08 | subzones | 4 | 161609 | 942 | 80.536 | 2006.7 |
| 1898 | 2025-05-16 22:40:19 | subzones | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 1897 | 2025-05-16 20:26:24 | subzones | 2 | 121059 | 8 | 3.563 | 33976.7 |
| 1896 | 2025-05-15 20:21:53 | subzones | 3 | 146162 | 98 | 7.016 | 20832.7 |
| 1895 | 2025-05-13 19:49:23 | subzones | 3 | 146162 | 98 | 7.016 | 20832.7 |
| 1894 | 2025-05-13 06:04:24 | subzones | 1 | 82945 | 3 | 1.596 | 51970.6 |
| 1893 | 2025-05-13 01:55:46 | subzones | 3 | 146162 | 98 | 7.516 | 19446.8 |
| 1892 | 2025-05-10 05:26:19 | subzones | 1 | 82945 | 3 | 4.470 | 18555.9 |
| 1891 | 2025-05-06 07:35:42 | subzones | 1 | 82945 | 3 | 3.783 | 21925.7 |