History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2009 | 2024-04-12 14:43:18 | aper | 1 | 13983 | 18 | 0.483 | 28950.3 |
2008 | 2024-04-12 14:39:10 | aper | 1 | 13983 | 18 | 0.700 | 19975.7 |
2007 | 2024-04-11 10:28:16 | aper | 1 | 13983 | 18 | 0.250 | 55932.0 |
2006 | 2024-04-07 07:16:37 | aper | 1 | 13983 | 18 | 0.376 | 37188.8 |
2005 | 2024-04-05 17:21:50 | aper | 2 | 29872 | 357 | 3.593 | 8313.9 |
2004 | 2024-04-05 00:38:25 | aper | 2 | 29872 | 357 | 0.890 | 33564.0 |
2003 | 2024-04-05 00:38:22 | aper | 1 | 13983 | 18 | 0.250 | 55932.0 |
2002 | 2024-04-05 00:38:11 | aper | 2 | 29872 | 357 | 0.953 | 31345.2 |
2001 | 2024-04-05 00:38:06 | aper | 1 | 13983 | 18 | 0.296 | 47239.9 |
2000 | 2024-04-02 18:31:32 | aper | 1 | 13983 | 18 | 1.156 | 12096.0 |
1999 | 2024-03-31 01:29:41 | aper | 2 | 29872 | 357 | 2.106 | 14184.2 |
1998 | 2024-03-31 00:57:56 | aper | 1 | 13983 | 18 | 0.283 | 49409.9 |
1997 | 2024-03-27 00:19:39 | aper | 1 | 13983 | 18 | 0.220 | 63559.1 |
1996 | 2024-03-05 19:41:37 | aper | 1 | 13983 | 18 | 0.233 | 60012.9 |
1995 | 2024-03-05 11:20:22 | aper | 1 | 13983 | 18 | 0.263 | 53167.3 |
1994 | 2024-03-02 18:16:50 | aper | 2 | 29872 | 357 | 2.390 | 12498.7 |
1993 | 2024-03-02 03:55:48 | aper | 1 | 13983 | 18 | 0.233 | 60012.9 |
1992 | 2024-02-25 17:01:50 | aper | 1 | 13983 | 18 | 0.843 | 16587.2 |
1991 | 2024-02-22 00:40:12 | aper | 1 | 13983 | 18 | 0.296 | 47239.9 |
1990 | 2024-02-17 15:02:44 | aper | 1 | 13983 | 18 | 0.203 | 68881.8 |
1989 | 2024-02-11 23:24:04 | aper | 2 | 29872 | 357 | 2.063 | 14479.9 |
1988 | 2024-02-08 00:59:52 | aper | 1 | 13983 | 18 | 2.716 | 5148.4 |
1987 | 2024-02-03 01:28:18 | aper | 1 | 13983 | 18 | 0.513 | 27257.3 |
1986 | 2023-12-30 02:08:08 | aper | 2 | 29872 | 357 | 0.783 | 38150.7 |
1985 | 2023-12-28 08:20:18 | aper | 1 | 13983 | 18 | 0.250 | 55932.0 |
1984 | 2023-12-23 10:11:40 | aper | 1 | 13983 | 18 | 0.250 | 55932.0 |
1983 | 2023-12-09 23:14:24 | aper | 2 | 29872 | 357 | 0.796 | 37527.6 |
1982 | 2023-11-26 01:07:32 | aper | 1 | 13983 | 18 | 0.250 | 55932.0 |
1981 | 2023-11-19 01:15:23 | aper | 1 | 13983 | 18 | 0.220 | 63559.1 |
1980 | 2023-11-17 14:55:29 | aper | 1 | 13983 | 18 | 0.300 | 46610.0 |
1979 | 2023-11-11 20:40:58 | aper | 1 | 13983 | 18 | 0.233 | 60012.9 |
1978 | 2023-11-11 04:13:50 | aper | 2 | 29872 | 357 | 0.936 | 31914.5 |
1977 | 2023-11-09 18:28:33 | aper | 2 | 29872 | 357 | 0.783 | 38150.7 |
1976 | 2023-11-09 11:35:50 | aper | 1 | 13983 | 18 | 0.326 | 42892.6 |
1975 | 2023-11-07 12:56:25 | aper | 2 | 29872 | 357 | 0.906 | 32971.3 |
1974 | 2023-11-07 03:39:30 | aper | 2 | 29872 | 357 | 0.860 | 34734.9 |
1973 | 2023-11-06 22:13:22 | aper | 2 | 29872 | 357 | 0.906 | 32971.3 |
1972 | 2023-11-06 09:15:45 | aper | 2 | 29872 | 357 | 0.906 | 32971.3 |
1971 | 2023-11-05 22:20:23 | aper | 2 | 29872 | 357 | 0.873 | 34217.6 |
1970 | 2023-11-05 19:52:09 | aper | 2 | 29872 | 357 | 0.780 | 38297.4 |
1969 | 2023-11-05 03:55:54 | aper | 2 | 29872 | 357 | 1.030 | 29001.9 |
1968 | 2023-11-04 21:51:40 | aper | 2 | 29872 | 357 | 0.766 | 38997.4 |
1967 | 2023-11-04 19:35:22 | aper | 2 | 29872 | 357 | 1.013 | 29488.6 |
1966 | 2023-11-03 21:26:06 | aper | 2 | 29872 | 357 | 0.783 | 38150.7 |
1965 | 2023-11-03 19:41:31 | aper | 2 | 29872 | 357 | 0.763 | 39150.7 |
1964 | 2023-11-02 21:36:41 | aper | 2 | 29872 | 357 | 0.843 | 35435.3 |
1963 | 2023-11-02 19:34:19 | aper | 2 | 29872 | 357 | 0.966 | 30923.4 |
1962 | 2023-11-02 01:09:11 | aper | 2 | 29872 | 357 | 0.923 | 32364.0 |
1961 | 2023-11-01 20:57:58 | aper | 2 | 29872 | 357 | 0.860 | 34734.9 |
1960 | 2023-11-01 13:23:43 | aper | 2 | 29872 | 357 | 0.890 | 33564.0 |
1959 | 2023-11-01 00:17:38 | aper | 2 | 29872 | 357 | 0.856 | 34897.2 |
1958 | 2023-10-31 13:22:49 | aper | 2 | 29872 | 357 | 0.783 | 38150.7 |
1957 | 2023-10-30 23:58:55 | aper | 2 | 29872 | 357 | 0.890 | 33564.0 |
1956 | 2023-10-30 13:15:48 | aper | 2 | 29872 | 357 | 0.890 | 33564.0 |
1955 | 2023-10-29 22:28:46 | aper | 2 | 29872 | 357 | 0.966 | 30923.4 |
1954 | 2023-10-29 13:15:54 | aper | 2 | 29872 | 357 | 0.953 | 31345.2 |
1953 | 2023-10-28 22:35:40 | aper | 2 | 29872 | 357 | 0.906 | 32971.3 |
1952 | 2023-10-28 13:14:20 | aper | 2 | 29872 | 357 | 3.423 | 8726.8 |
1951 | 2023-10-27 23:06:41 | aper | 2 | 29872 | 357 | 0.796 | 37527.6 |
1950 | 2023-10-27 14:29:51 | aper | 2 | 29872 | 357 | 0.953 | 31345.2 |
1949 | 2023-10-26 13:25:12 | aper | 2 | 29872 | 357 | 0.876 | 34100.5 |
1948 | 2023-10-26 11:38:37 | aper | 1 | 13983 | 18 | 0.236 | 59250.0 |
1947 | 2023-10-26 05:44:02 | aper | 2 | 29872 | 357 | 0.966 | 30923.4 |
1946 | 2023-10-26 01:13:55 | aper | 1 | 13983 | 18 | 0.546 | 25609.9 |
1945 | 2023-10-25 02:57:45 | aper | 2 | 29872 | 357 | 0.936 | 31914.5 |
1944 | 2023-10-24 03:33:18 | aper | 2 | 29872 | 357 | 0.813 | 36742.9 |
1943 | 2023-10-23 16:20:14 | aper | 2 | 29872 | 357 | 0.843 | 35435.3 |
1942 | 2023-10-22 15:17:10 | aper | 2 | 29872 | 357 | 0.796 | 37527.6 |
1941 | 2023-10-21 22:55:04 | aper | 2 | 29872 | 357 | 0.873 | 34217.6 |
1940 | 2023-10-21 15:50:52 | aper | 2 | 29872 | 357 | 0.780 | 38297.4 |
1939 | 2023-10-20 23:13:06 | aper | 1 | 13983 | 18 | 0.220 | 63559.1 |
1938 | 2023-10-20 22:14:47 | aper | 2 | 29872 | 357 | 0.906 | 32971.3 |
1937 | 2023-10-20 16:26:04 | aper | 2 | 29872 | 357 | 0.903 | 33080.8 |
1936 | 2023-10-19 22:55:29 | aper | 2 | 29872 | 357 | 0.783 | 38150.7 |
1935 | 2023-10-19 18:19:12 | aper | 2 | 29872 | 357 | 2.046 | 14600.2 |
1934 | 2023-10-19 10:18:18 | aper | 2 | 29872 | 357 | 0.890 | 33564.0 |
1933 | 2023-10-18 22:37:27 | aper | 2 | 29872 | 357 | 0.763 | 39150.7 |
1932 | 2023-10-18 10:21:28 | aper | 2 | 29872 | 357 | 0.890 | 33564.0 |
1931 | 2023-10-17 15:18:51 | aper | 1 | 13983 | 18 | 0.266 | 52567.7 |
1930 | 2023-10-17 10:01:19 | aper | 2 | 29872 | 357 | 0.783 | 38150.7 |
1929 | 2023-10-16 23:35:52 | aper | 1 | 13983 | 18 | 0.483 | 28950.3 |
1928 | 2023-10-16 21:46:48 | aper | 2 | 29872 | 357 | 0.906 | 32971.3 |
1927 | 2023-10-16 13:33:33 | aper | 2 | 29872 | 357 | 0.923 | 32364.0 |
1926 | 2023-10-16 04:57:24 | aper | 2 | 29872 | 357 | 0.860 | 34734.9 |
1925 | 2023-10-15 04:36:44 | aper | 2 | 29872 | 357 | 0.876 | 34100.5 |
1924 | 2023-10-15 03:52:12 | aper | 2 | 29872 | 357 | 0.953 | 31345.2 |
1923 | 2023-10-14 08:33:17 | aper | 2 | 29872 | 357 | 0.923 | 32364.0 |
1922 | 2023-10-13 18:43:01 | aper | 2 | 29872 | 357 | 0.780 | 38297.4 |
1921 | 2023-10-13 09:01:35 | aper | 2 | 29872 | 357 | 0.780 | 38297.4 |
1920 | 2023-10-12 18:05:32 | aper | 2 | 29872 | 357 | 0.860 | 34734.9 |
1919 | 2023-10-12 07:54:05 | aper | 2 | 29872 | 357 | 0.906 | 32971.3 |
1918 | 2023-10-11 23:17:01 | aper | 1 | 13983 | 18 | 0.250 | 55932.0 |
1917 | 2023-10-11 18:02:36 | aper | 2 | 29872 | 357 | 0.953 | 31345.2 |
1916 | 2023-10-11 14:36:26 | aper | 2 | 29872 | 357 | 0.890 | 33564.0 |
1915 | 2023-10-11 02:51:38 | aper | 2 | 29872 | 357 | 0.796 | 37527.6 |
1914 | 2023-10-10 23:36:07 | aper | 2 | 29872 | 357 | 0.950 | 31444.2 |
1913 | 2023-10-10 14:51:41 | aper | 2 | 29872 | 357 | 0.796 | 37527.6 |
1912 | 2023-10-10 00:05:01 | aper | 2 | 29872 | 357 | 0.796 | 37527.6 |
1911 | 2023-10-08 23:45:21 | aper | 2 | 29872 | 357 | 0.813 | 36742.9 |
1910 | 2023-10-08 17:56:19 | aper | 2 | 29872 | 357 | 1.890 | 15805.3 |