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 |
| 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 |
| 1890 | 2025-04-23 18:34:47 | subzones | 3 | 146162 | 98 | 6.890 | 21213.6 |
| 1889 | 2025-04-23 04:53:40 | subzones | 3 | 146162 | 98 | 24.330 | 6007.5 |
| 1888 | 2025-04-23 04:10:53 | subzones | 3 | 146162 | 98 | 23.203 | 6299.3 |
| 1887 | 2025-04-20 19:05:58 | subzones | 3 | 146162 | 98 | 44.550 | 3280.9 |
| 1886 | 2025-04-18 15:17:30 | subzones | 2 | 121059 | 8 | 9.373 | 12915.7 |
| 1885 | 2025-04-16 07:19:59 | subzones | 2 | 121059 | 8 | 10.593 | 11428.2 |
| 1884 | 2025-04-15 19:25:58 | subzones | 3 | 146162 | 98 | 18.516 | 7893.8 |
| 1883 | 2025-04-15 13:48:09 | subzones | 4 | 161609 | 942 | 50.753 | 3184.2 |
| 1882 | 2025-04-15 02:52:35 | subzones | 3 | 146162 | 98 | 21.660 | 6748.0 |
| 1881 | 2025-04-14 17:42:01 | subzones | 4 | 161609 | 942 | 55.346 | 2920.0 |
| 1880 | 2025-04-14 14:54:58 | subzones | 4 | 161609 | 942 | 58.610 | 2757.4 |
| 1879 | 2025-04-14 09:53:48 | subzones | 4 | 161609 | 942 | 64.596 | 2501.8 |
| 1878 | 2025-04-12 03:35:47 | subzones | 4 | 161609 | 942 | 56.356 | 2867.6 |
| 1877 | 2025-04-11 20:39:06 | subzones | 3 | 146162 | 98 | 26.970 | 5419.4 |
| 1876 | 2025-04-10 22:43:48 | subzones | 1 | 82945 | 3 | 3.703 | 22399.4 |
| 1875 | 2025-04-10 08:03:35 | subzones | 3 | 146162 | 98 | 6.640 | 22012.3 |
| 1874 | 2025-04-06 06:53:02 | subzones | 1 | 82945 | 3 | 7.203 | 11515.3 |
| 1873 | 2025-04-02 06:52:16 | subzones | 1 | 82945 | 3 | 6.750 | 12288.1 |
| 1872 | 2025-03-29 16:18:59 | subzones | 3 | 146162 | 98 | 38.516 | 3794.8 |
| 1871 | 2025-03-23 08:20:46 | subzones | 3 | 146162 | 98 | 36.816 | 3970.1 |
| 1870 | 2025-03-21 01:27:45 | subzones | 1 | 82945 | 3 | 6.876 | 12063.0 |
| 1869 | 2025-03-18 23:16:13 | subzones | 3 | 146162 | 98 | 8.013 | 18240.6 |
| 1868 | 2025-03-17 05:39:13 | subzones | 1 | 82945 | 3 | 9.173 | 9042.3 |
| 1867 | 2025-03-12 11:55:33 | subzones | 3 | 146162 | 98 | 30.210 | 4838.2 |
| 1866 | 2025-03-08 14:15:36 | subzones | 1 | 82945 | 3 | 8.813 | 9411.7 |
| 1865 | 2025-03-06 14:47:03 | subzones | 3 | 146162 | 98 | 37.250 | 3923.8 |
| 1864 | 2025-03-05 21:08:55 | subzones | 1 | 82945 | 3 | 7.156 | 11591.0 |
| 1863 | 2025-03-05 20:43:16 | subzones | 3 | 146162 | 98 | 8.313 | 17582.3 |
| 1862 | 2025-03-05 20:43:15 | subzones | 2 | 121059 | 8 | 5.046 | 23991.1 |
| 1861 | 2025-03-05 18:05:14 | subzones | 1 | 82945 | 3 | 5.093 | 16286.1 |
| 1860 | 2025-03-01 15:16:42 | subzones | 3 | 146162 | 98 | 36.876 | 3963.6 |
| 1859 | 2025-02-27 12:47:58 | subzones | 3 | 146162 | 98 | 35.503 | 4116.9 |
| 1858 | 2025-02-27 12:47:54 | subzones | 2 | 121059 | 8 | 11.503 | 10524.1 |
| 1857 | 2025-02-27 12:45:47 | subzones | 1 | 82945 | 3 | 6.876 | 12063.0 |
| 1856 | 2025-02-26 00:58:38 | subzones | 4 | 161609 | 942 | 38.783 | 4167.0 |
| 1855 | 2025-02-19 11:50:03 | subzones | 3 | 146162 | 98 | 13.936 | 10488.1 |