History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fare"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1984 | 2026-02-02 09:01:19 | fare | 1 | 13983 | 36 | 0.516 | 27098.8 |
| 1983 | 2026-01-29 21:34:47 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1982 | 2026-01-29 10:46:07 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1981 | 2026-01-29 06:23:43 | fare | 1 | 13983 | 36 | 0.280 | 49939.3 |
| 1980 | 2026-01-28 02:03:00 | fare | 1 | 13983 | 36 | 0.530 | 26383.0 |
| 1979 | 2026-01-27 00:24:00 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1978 | 2026-01-26 16:26:52 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1977 | 2026-01-20 19:03:00 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1976 | 2026-01-18 06:03:03 | fare | 1 | 13983 | 36 | 0.236 | 59250.0 |
| 1975 | 2026-01-16 03:20:19 | fare | 1 | 13983 | 36 | 1.626 | 8599.6 |
| 1974 | 2026-01-15 19:29:23 | fare | 2 | 29872 | 546 | 0.906 | 32971.3 |
| 1973 | 2026-01-15 19:22:31 | fare | 2 | 29872 | 546 | 0.843 | 35435.3 |
| 1972 | 2026-01-15 00:33:27 | fare | 1 | 13983 | 36 | 0.220 | 63559.1 |
| 1971 | 2026-01-14 19:32:37 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1970 | 2026-01-08 07:19:34 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1969 | 2026-01-08 06:27:20 | fare | 1 | 13983 | 36 | 0.220 | 63559.1 |
| 1968 | 2026-01-08 03:19:16 | fare | 1 | 13983 | 36 | 0.236 | 59250.0 |
| 1967 | 2026-01-07 17:08:19 | fare | 2 | 29872 | 546 | 0.800 | 37340.0 |
| 1966 | 2026-01-06 21:57:17 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1965 | 2026-01-06 04:12:04 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1964 | 2026-01-06 02:52:20 | fare | 1 | 13983 | 36 | 0.263 | 53167.3 |
| 1963 | 2026-01-05 22:41:40 | fare | 1 | 13983 | 36 | 0.453 | 30867.5 |
| 1962 | 2026-01-04 19:10:42 | fare | 1 | 13983 | 36 | 0.263 | 53167.3 |
| 1961 | 2026-01-04 17:57:47 | fare | 1 | 13983 | 36 | 0.236 | 59250.0 |
| 1960 | 2026-01-04 15:06:46 | fare | 1 | 13983 | 36 | 0.280 | 49939.3 |
| 1959 | 2026-01-03 02:37:20 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1958 | 2026-01-03 00:04:20 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1957 | 2026-01-01 02:25:28 | fare | 2 | 29872 | 546 | 0.906 | 32971.3 |
| 1956 | 2025-12-29 22:31:46 | fare | 2 | 29872 | 546 | 1.046 | 28558.3 |
| 1955 | 2025-12-29 22:31:31 | fare | 2 | 29872 | 546 | 0.893 | 33451.3 |
| 1954 | 2025-12-29 13:55:24 | fare | 1 | 13983 | 36 | 0.296 | 47239.9 |
| 1953 | 2025-12-28 22:48:24 | fare | 2 | 29872 | 546 | 0.876 | 34100.5 |
| 1952 | 2025-12-28 06:08:47 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1951 | 2025-12-26 10:18:40 | fare | 2 | 29872 | 546 | 0.860 | 34734.9 |
| 1950 | 2025-12-26 06:35:16 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1949 | 2025-12-26 02:17:49 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1948 | 2025-12-25 07:57:34 | fare | 2 | 29872 | 546 | 1.406 | 21246.1 |
| 1947 | 2025-12-24 23:46:58 | fare | 1 | 13983 | 36 | 0.263 | 53167.3 |
| 1946 | 2025-12-18 09:49:33 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1945 | 2025-12-16 02:51:47 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1944 | 2025-12-10 03:08:06 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1943 | 2025-12-09 23:02:51 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1942 | 2025-11-29 19:58:57 | fare | 2 | 29872 | 546 | 0.766 | 38997.4 |
| 1941 | 2025-11-29 18:08:57 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1940 | 2025-11-29 12:40:04 | fare | 2 | 29872 | 546 | 0.940 | 31778.7 |
| 1939 | 2025-11-29 09:21:08 | fare | 1 | 13983 | 36 | 0.280 | 49939.3 |
| 1938 | 2025-11-28 17:27:39 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1937 | 2025-11-27 19:05:24 | fare | 1 | 13983 | 36 | 0.826 | 16928.6 |
| 1936 | 2025-11-27 15:28:38 | fare | 1 | 13983 | 36 | 0.296 | 47239.9 |
| 1935 | 2025-11-25 16:10:07 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1934 | 2025-11-25 07:02:03 | fare | 1 | 13983 | 36 | 0.220 | 63559.1 |
| 1933 | 2025-11-24 17:18:52 | fare | 1 | 13983 | 36 | 0.673 | 20777.1 |
| 1932 | 2025-11-23 23:54:41 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1931 | 2025-11-22 04:29:13 | fare | 1 | 13983 | 36 | 0.546 | 25609.9 |
| 1930 | 2025-11-22 01:45:59 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1929 | 2025-11-22 01:45:19 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1928 | 2025-11-21 19:00:16 | fare | 2 | 29872 | 546 | 0.890 | 33564.0 |
| 1927 | 2025-11-19 09:59:28 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1926 | 2025-11-19 08:20:53 | fare | 1 | 13983 | 36 | 0.560 | 24969.6 |
| 1925 | 2025-11-18 22:37:23 | fare | 1 | 13983 | 36 | 0.560 | 24969.6 |
| 1924 | 2025-11-18 00:37:22 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1923 | 2025-11-17 22:54:45 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1922 | 2025-11-17 00:25:45 | fare | 1 | 13983 | 36 | 0.513 | 27257.3 |
| 1921 | 2025-11-16 07:56:09 | fare | 1 | 13983 | 36 | 0.236 | 59250.0 |
| 1920 | 2025-11-14 19:22:03 | fare | 1 | 13983 | 36 | 0.280 | 49939.3 |
| 1919 | 2025-11-14 12:18:12 | fare | 1 | 13983 | 36 | 0.580 | 24108.6 |
| 1918 | 2025-11-13 17:11:31 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1917 | 2025-11-12 13:45:08 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1916 | 2025-11-11 07:23:47 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1915 | 2025-11-10 21:06:41 | fare | 1 | 13983 | 36 | 0.483 | 28950.3 |
| 1914 | 2025-11-10 05:39:42 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1913 | 2025-11-04 11:15:50 | fare | 2 | 29872 | 546 | 1.000 | 29872.0 |
| 1912 | 2025-10-31 01:18:16 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1911 | 2025-10-29 18:55:24 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1910 | 2025-10-28 22:40:05 | fare | 1 | 13983 | 36 | 0.283 | 49409.9 |
| 1909 | 2025-10-27 20:00:00 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1908 | 2025-10-26 13:45:08 | fare | 1 | 13983 | 36 | 0.263 | 53167.3 |
| 1907 | 2025-10-25 16:08:39 | fare | 1 | 13983 | 36 | 0.220 | 63559.1 |
| 1906 | 2025-10-25 07:54:23 | fare | 1 | 13983 | 36 | 0.266 | 52567.7 |
| 1905 | 2025-10-24 21:50:24 | fare | 1 | 13983 | 36 | 0.216 | 64736.1 |
| 1904 | 2025-10-23 21:53:01 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1903 | 2025-10-19 17:26:18 | fare | 2 | 29872 | 546 | 4.110 | 7268.1 |
| 1902 | 2025-10-19 17:25:32 | fare | 2 | 29872 | 546 | 4.610 | 6479.8 |
| 1901 | 2025-10-19 17:24:54 | fare | 2 | 29872 | 546 | 6.550 | 4560.6 |
| 1900 | 2025-10-19 17:24:11 | fare | 2 | 29872 | 546 | 2.033 | 14693.6 |
| 1899 | 2025-10-19 10:03:29 | fare | 1 | 13983 | 36 | 0.500 | 27966.0 |
| 1898 | 2025-10-19 10:03:23 | fare | 1 | 13983 | 36 | 0.500 | 27966.0 |
| 1897 | 2025-10-19 10:03:17 | fare | 1 | 13983 | 36 | 2.000 | 6991.5 |
| 1896 | 2025-10-19 10:03:12 | fare | 1 | 13983 | 36 | 0.670 | 20870.1 |
| 1895 | 2025-10-18 01:31:07 | fare | 1 | 13983 | 36 | 0.280 | 49939.3 |
| 1894 | 2025-10-16 02:28:20 | fare | 2 | 29872 | 546 | 0.893 | 33451.3 |
| 1893 | 2025-10-08 00:16:48 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1892 | 2025-10-06 06:05:33 | fare | 1 | 13983 | 36 | 0.236 | 59250.0 |
| 1891 | 2025-09-27 18:59:44 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1890 | 2025-09-27 02:32:52 | fare | 1 | 13983 | 36 | 0.233 | 60012.9 |
| 1889 | 2025-09-26 20:05:41 | fare | 1 | 13983 | 36 | 0.250 | 55932.0 |
| 1888 | 2025-09-25 05:09:42 | fare | 1 | 13983 | 36 | 1.220 | 11461.5 |
| 1887 | 2025-09-24 23:31:21 | fare | 1 | 13983 | 36 | 1.593 | 8777.8 |
| 1886 | 2025-09-24 23:31:13 | fare | 1 | 13983 | 36 | 0.830 | 16847.0 |
| 1885 | 2025-09-24 23:31:09 | fare | 1 | 13983 | 36 | 1.703 | 8210.8 |