History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loca"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2008 | 2024-04-04 23:05:56 | loca | 1 | 13983 | 10 | 0.373 | 37487.9 |
2007 | 2024-03-30 22:03:49 | loca | 1 | 13983 | 10 | 0.266 | 52567.7 |
2006 | 2024-03-26 19:13:16 | loca | 1 | 13983 | 10 | 0.280 | 49939.3 |
2005 | 2024-03-05 20:09:59 | loca | 1 | 13983 | 10 | 0.546 | 25609.9 |
2004 | 2024-03-03 20:12:18 | loca | 2 | 29872 | 208 | 0.846 | 35309.7 |
2003 | 2024-03-02 18:34:13 | loca | 2 | 29872 | 208 | 3.076 | 9711.3 |
2002 | 2024-03-02 16:56:43 | loca | 1 | 13983 | 10 | 0.236 | 59250.0 |
2001 | 2024-02-25 17:07:48 | loca | 1 | 13983 | 10 | 0.236 | 59250.0 |
2000 | 2024-02-15 05:07:39 | loca | 1 | 13983 | 10 | 0.500 | 27966.0 |
1999 | 2024-02-03 00:47:58 | loca | 1 | 13983 | 10 | 0.250 | 55932.0 |
1998 | 2024-01-26 09:42:57 | loca | 1 | 13983 | 10 | 0.453 | 30867.5 |
1997 | 2023-12-27 02:46:41 | loca | 2 | 29872 | 208 | 0.873 | 34217.6 |
1996 | 2023-12-08 10:57:41 | loca | 1 | 13983 | 10 | 0.516 | 27098.8 |
1995 | 2023-12-08 10:57:40 | loca | 1 | 13983 | 10 | 0.530 | 26383.0 |
1994 | 2023-12-01 13:05:30 | loca | 1 | 13983 | 10 | 0.216 | 64736.1 |
1993 | 2023-11-26 19:37:49 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1992 | 2023-11-16 21:30:52 | loca | 2 | 29872 | 208 | 0.873 | 34217.6 |
1991 | 2023-11-15 05:28:51 | loca | 1 | 13983 | 10 | 0.236 | 59250.0 |
1990 | 2023-11-13 23:16:23 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1989 | 2023-11-13 13:33:24 | loca | 2 | 29872 | 208 | 0.920 | 32469.6 |
1988 | 2023-11-09 22:55:46 | loca | 1 | 13983 | 10 | 0.486 | 28771.6 |
1987 | 2023-11-02 08:24:04 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1986 | 2023-11-02 02:49:18 | loca | 2 | 29872 | 208 | 0.843 | 35435.3 |
1985 | 2023-11-02 01:44:08 | loca | 1 | 13983 | 10 | 0.500 | 27966.0 |
1984 | 2023-10-27 06:12:47 | loca | 1 | 13983 | 10 | 0.266 | 52567.7 |
1983 | 2023-10-26 18:46:10 | loca | 1 | 13983 | 10 | 0.250 | 55932.0 |
1982 | 2023-10-19 21:33:59 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1981 | 2023-10-17 07:06:47 | loca | 1 | 13983 | 10 | 0.283 | 49409.9 |
1980 | 2023-10-11 17:24:22 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1979 | 2023-10-04 00:40:24 | loca | 1 | 13983 | 10 | 0.216 | 64736.1 |
1978 | 2023-09-21 00:10:51 | loca | 1 | 13983 | 10 | 0.216 | 64736.1 |
1977 | 2023-09-15 17:07:44 | loca | 1 | 13983 | 10 | 0.236 | 59250.0 |
1976 | 2023-09-14 07:04:06 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1975 | 2023-08-16 09:49:57 | loca | 2 | 29872 | 208 | 0.843 | 35435.3 |
1974 | 2023-07-14 13:26:44 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1973 | 2023-07-05 05:53:46 | loca | 1 | 13983 | 10 | 0.266 | 52567.7 |
1972 | 2023-04-13 17:34:23 | loca | 1 | 13983 | 10 | 0.250 | 55932.0 |
1971 | 2023-04-06 22:23:52 | loca | 1 | 13983 | 10 | 0.220 | 63559.1 |
1970 | 2023-02-04 14:51:29 | loca | 1 | 13983 | 10 | 0.203 | 68881.8 |
1969 | 2022-12-25 06:47:54 | loca | 1 | 13983 | 10 | 0.250 | 55932.0 |
1968 | 2022-12-03 19:38:54 | loca | 1 | 13983 | 10 | 0.220 | 63559.1 |
1967 | 2022-09-19 19:32:31 | loca | 1 | 13983 | 10 | 0.216 | 64736.1 |
1966 | 2022-09-18 14:29:19 | loca | 1 | 13983 | 10 | 0.220 | 63559.1 |
1965 | 2022-09-07 09:47:41 | loca | 1 | 13983 | 10 | 0.216 | 64736.1 |
1964 | 2022-09-04 10:13:01 | loca | 2 | 29872 | 208 | 0.796 | 37527.6 |
1963 | 2022-09-01 13:26:19 | loca | 1 | 13983 | 10 | 0.220 | 63559.1 |
1962 | 2022-08-23 07:14:51 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1961 | 2022-08-06 19:53:00 | loca | 1 | 13983 | 10 | 0.250 | 55932.0 |
1960 | 2022-08-06 06:00:19 | loca | 1 | 13983 | 10 | 0.220 | 63559.1 |
1959 | 2022-07-30 00:51:06 | loca | 1 | 13983 | 10 | 0.216 | 64736.1 |
1958 | 2022-07-29 11:59:50 | loca | 1 | 13983 | 10 | 0.220 | 63559.1 |
1957 | 2022-07-26 08:55:09 | loca | 2 | 29872 | 208 | 0.860 | 34734.9 |
1956 | 2022-07-22 16:56:02 | loca | 2 | 29872 | 208 | 0.736 | 40587.0 |
1955 | 2022-07-17 18:57:55 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1954 | 2022-07-09 21:49:26 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1953 | 2022-07-03 07:25:26 | loca | 1 | 13983 | 10 | 0.236 | 59250.0 |
1952 | 2022-06-25 15:30:22 | loca | 2 | 29872 | 208 | 0.766 | 38997.4 |
1951 | 2022-06-24 19:41:29 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1950 | 2022-06-16 07:26:34 | loca | 1 | 13983 | 10 | 0.236 | 59250.0 |
1949 | 2022-06-15 16:22:15 | loca | 1 | 13983 | 10 | 0.216 | 64736.1 |
1948 | 2022-06-08 14:19:34 | loca | 1 | 13983 | 10 | 0.250 | 55932.0 |
1947 | 2022-05-26 04:06:21 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1946 | 2022-05-26 03:43:35 | loca | 2 | 29872 | 208 | 0.873 | 34217.6 |
1945 | 2022-05-19 06:36:30 | loca | 2 | 29872 | 208 | 0.936 | 31914.5 |
1944 | 2022-05-18 09:50:03 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1943 | 2022-05-17 16:32:47 | loca | 2 | 29872 | 208 | 0.873 | 34217.6 |
1942 | 2022-05-16 04:41:32 | loca | 2 | 29872 | 208 | 0.876 | 34100.5 |
1941 | 2022-05-15 11:41:34 | loca | 2 | 29872 | 208 | 0.950 | 31444.2 |
1940 | 2022-05-14 13:12:12 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1939 | 2022-05-13 22:23:48 | loca | 2 | 29872 | 208 | 0.780 | 38297.4 |
1938 | 2022-05-13 09:05:30 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1937 | 2022-05-12 15:09:44 | loca | 2 | 29872 | 208 | 0.860 | 34734.9 |
1936 | 2022-05-11 21:55:51 | loca | 2 | 29872 | 208 | 1.080 | 27659.3 |
1935 | 2022-05-11 10:13:43 | loca | 2 | 29872 | 208 | 0.966 | 30923.4 |
1934 | 2022-05-10 19:13:19 | loca | 2 | 29872 | 208 | 1.093 | 27330.3 |
1933 | 2022-05-10 08:41:52 | loca | 2 | 29872 | 208 | 1.673 | 17855.3 |
1932 | 2022-05-09 14:50:01 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1931 | 2022-05-08 09:38:44 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1930 | 2022-05-07 20:34:58 | loca | 2 | 29872 | 208 | 0.783 | 38150.7 |
1929 | 2022-05-07 01:28:43 | loca | 2 | 29872 | 208 | 0.873 | 34217.6 |
1928 | 2022-05-06 11:27:51 | loca | 2 | 29872 | 208 | 0.810 | 36879.0 |
1927 | 2022-05-05 18:46:43 | loca | 2 | 29872 | 208 | 0.920 | 32469.6 |
1926 | 2022-05-05 11:04:27 | loca | 2 | 29872 | 208 | 0.920 | 32469.6 |
1925 | 2022-05-04 20:01:52 | loca | 2 | 29872 | 208 | 0.860 | 34734.9 |
1924 | 2022-05-04 08:35:50 | loca | 2 | 29872 | 208 | 0.936 | 31914.5 |
1923 | 2022-05-03 22:30:42 | loca | 2 | 29872 | 208 | 1.343 | 22242.7 |
1922 | 2022-05-03 05:31:12 | loca | 2 | 29872 | 208 | 0.860 | 34734.9 |
1921 | 2022-05-02 19:31:06 | loca | 2 | 29872 | 208 | 1.300 | 22978.5 |
1920 | 2022-05-01 12:40:28 | loca | 2 | 29872 | 208 | 0.856 | 34897.2 |
1919 | 2022-04-30 21:12:38 | loca | 2 | 29872 | 208 | 0.750 | 39829.3 |
1918 | 2022-04-30 04:06:41 | loca | 2 | 29872 | 208 | 1.830 | 16323.5 |
1917 | 2022-04-30 02:45:18 | loca | 2 | 29872 | 208 | 0.766 | 38997.4 |
1916 | 2022-04-29 09:04:31 | loca | 2 | 29872 | 208 | 0.906 | 32971.3 |
1915 | 2022-04-29 08:09:27 | loca | 2 | 29872 | 208 | 0.876 | 34100.5 |
1914 | 2022-04-29 03:04:16 | loca | 1 | 13983 | 10 | 0.263 | 53167.3 |
1913 | 2022-04-28 21:20:36 | loca | 2 | 29872 | 208 | 1.050 | 28449.5 |
1912 | 2022-04-28 05:43:42 | loca | 1 | 13983 | 10 | 0.233 | 60012.9 |
1911 | 2022-04-27 13:59:19 | loca | 1 | 13983 | 10 | 0.263 | 53167.3 |
1910 | 2022-04-26 17:05:39 | loca | 1 | 13983 | 10 | 0.236 | 59250.0 |
1909 | 2022-04-26 05:11:50 | loca | 1 | 13983 | 10 | 0.266 | 52567.7 |