History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piano"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2050 | 2025-11-23 03:26:30 | piano | 3 | 83667 | 1132 | 3.923 | 21327.3 |
| 2049 | 2025-11-23 03:07:32 | piano | 2 | 53800 | 83 | 1.580 | 34050.6 |
| 2048 | 2025-11-23 02:01:08 | piano | 3 | 83667 | 1132 | 4.846 | 17265.2 |
| 2047 | 2025-11-23 01:58:32 | piano | 2 | 53800 | 83 | 2.576 | 20885.1 |
| 2046 | 2025-11-23 00:12:50 | piano | 3 | 83667 | 1132 | 5.046 | 16580.9 |
| 2045 | 2025-11-21 05:42:55 | piano | 1 | 28756 | 4 | 0.563 | 51076.4 |
| 2044 | 2025-11-20 06:47:32 | piano | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 2043 | 2025-11-19 05:46:28 | piano | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 2042 | 2025-11-19 00:11:51 | piano | 3 | 83667 | 1132 | 3.736 | 22394.8 |
| 2041 | 2025-11-17 00:18:09 | piano | 3 | 83667 | 1132 | 4.153 | 20146.2 |
| 2040 | 2025-11-15 10:44:41 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2039 | 2025-11-15 03:31:07 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2038 | 2025-11-15 02:45:12 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 2037 | 2025-11-15 00:29:34 | piano | 3 | 83667 | 1132 | 3.876 | 21585.9 |
| 2036 | 2025-11-14 08:16:05 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 2035 | 2025-11-11 19:00:13 | piano | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 2034 | 2025-11-11 14:18:49 | piano | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 2033 | 2025-11-06 20:41:19 | piano | 1 | 28756 | 4 | 0.546 | 52666.7 |
| 2032 | 2025-11-03 14:02:50 | piano | 3 | 83667 | 1132 | 4.423 | 18916.3 |
| 2031 | 2025-11-03 00:35:32 | piano | 3 | 83667 | 1132 | 3.763 | 22234.1 |
| 2030 | 2025-11-02 15:50:42 | piano | 2 | 53800 | 83 | 1.406 | 38264.6 |
| 2029 | 2025-11-01 21:26:00 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 2028 | 2025-11-01 08:36:26 | piano | 3 | 83667 | 1132 | 3.393 | 24658.7 |
| 2027 | 2025-10-26 16:17:41 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2026 | 2025-10-26 09:23:41 | piano | 3 | 83667 | 1132 | 4.093 | 20441.5 |
| 2025 | 2025-10-26 02:22:54 | piano | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 2024 | 2025-10-24 17:18:08 | piano | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 2023 | 2025-10-24 08:10:30 | piano | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 2022 | 2025-10-24 03:53:24 | piano | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 2021 | 2025-10-24 03:53:12 | piano | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 2020 | 2025-10-23 23:31:03 | piano | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 2019 | 2025-10-23 23:30:59 | piano | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 2018 | 2025-10-23 17:36:00 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2017 | 2025-10-20 12:36:19 | piano | 1 | 28756 | 4 | 1.013 | 28387.0 |
| 2016 | 2025-10-17 08:21:18 | piano | 1 | 28756 | 4 | 0.563 | 51076.4 |
| 2015 | 2025-10-17 05:27:30 | piano | 2 | 53800 | 83 | 1.623 | 33148.5 |
| 2014 | 2025-10-09 19:59:45 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2013 | 2025-10-05 14:56:31 | piano | 3 | 83667 | 1132 | 4.046 | 20678.9 |
| 2012 | 2025-10-05 02:59:09 | piano | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 2011 | 2025-09-29 08:00:26 | piano | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 2010 | 2025-09-23 08:06:43 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2009 | 2025-09-20 16:49:36 | piano | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 2008 | 2025-09-15 19:09:39 | piano | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 2007 | 2025-09-15 01:14:42 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 2006 | 2025-09-13 15:35:52 | piano | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 2005 | 2025-09-08 14:36:08 | piano | 3 | 83667 | 1132 | 3.423 | 24442.6 |
| 2004 | 2025-09-07 09:26:43 | piano | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 2003 | 2025-09-03 15:36:55 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2002 | 2025-08-30 05:57:33 | piano | 3 | 83667 | 1132 | 3.716 | 22515.3 |
| 2001 | 2025-08-29 01:07:28 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 2000 | 2025-08-22 22:22:11 | piano | 3 | 83667 | 1132 | 19.403 | 4312.1 |
| 1999 | 2025-08-21 08:15:40 | piano | 3 | 83667 | 1132 | 10.360 | 8076.0 |
| 1998 | 2025-08-21 05:29:31 | piano | 3 | 83667 | 1132 | 10.080 | 8300.3 |
| 1997 | 2025-08-18 23:11:29 | piano | 1 | 28756 | 4 | 1.343 | 21411.8 |
| 1996 | 2025-08-18 22:51:36 | piano | 3 | 83667 | 1132 | 14.800 | 5653.2 |
| 1995 | 2025-08-16 23:32:30 | piano | 1 | 28756 | 4 | 1.250 | 23004.8 |
| 1994 | 2025-08-16 23:17:16 | piano | 3 | 83667 | 1132 | 8.923 | 9376.6 |
| 1993 | 2025-08-16 10:16:45 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1992 | 2025-08-09 12:08:15 | piano | 1 | 28756 | 4 | 1.843 | 15602.8 |
| 1991 | 2025-08-08 10:02:22 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1990 | 2025-08-07 10:18:02 | piano | 2 | 53800 | 83 | 4.203 | 12800.4 |
| 1989 | 2025-08-05 03:26:57 | piano | 2 | 53800 | 83 | 5.436 | 9897.0 |
| 1988 | 2025-08-04 13:43:18 | piano | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1987 | 2025-07-31 14:17:22 | piano | 1 | 28756 | 4 | 2.123 | 13545.0 |
| 1986 | 2025-07-31 11:12:54 | piano | 1 | 28756 | 4 | 1.580 | 18200.0 |
| 1985 | 2025-07-31 09:31:19 | piano | 1 | 28756 | 4 | 2.706 | 10626.8 |
| 1984 | 2025-07-22 03:11:30 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1983 | 2025-07-21 20:18:01 | piano | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 1982 | 2025-07-19 00:20:48 | piano | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 1981 | 2025-07-18 00:33:00 | piano | 1 | 28756 | 4 | 1.013 | 28387.0 |
| 1980 | 2025-07-17 16:05:35 | piano | 2 | 53800 | 83 | 9.190 | 5854.2 |
| 1979 | 2025-07-17 13:03:12 | piano | 1 | 28756 | 4 | 1.190 | 24164.7 |
| 1978 | 2025-07-15 13:18:41 | piano | 2 | 53800 | 83 | 13.360 | 4026.9 |
| 1977 | 2025-07-15 11:03:54 | piano | 2 | 53800 | 83 | 8.953 | 6009.2 |
| 1976 | 2025-07-14 16:03:19 | piano | 2 | 53800 | 83 | 7.843 | 6859.6 |
| 1975 | 2025-07-11 23:07:21 | piano | 2 | 53800 | 83 | 1.593 | 33772.8 |
| 1974 | 2025-07-09 02:03:38 | piano | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 1973 | 2025-07-08 13:44:58 | piano | 1 | 28756 | 4 | 4.500 | 6390.2 |
| 1972 | 2025-07-08 11:14:03 | piano | 1 | 28756 | 4 | 1.486 | 19351.3 |
| 1971 | 2025-07-08 00:07:58 | piano | 1 | 28756 | 4 | 2.576 | 11163.0 |
| 1970 | 2025-07-07 10:26:49 | piano | 1 | 28756 | 4 | 1.016 | 28303.1 |
| 1969 | 2025-07-05 13:35:24 | piano | 1 | 28756 | 4 | 2.313 | 12432.3 |
| 1968 | 2025-07-03 11:50:07 | piano | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1967 | 2025-07-02 13:56:19 | piano | 1 | 28756 | 4 | 2.703 | 10638.5 |
| 1966 | 2025-06-17 23:53:52 | piano | 1 | 28756 | 4 | 3.330 | 8635.4 |
| 1965 | 2025-06-06 10:22:51 | piano | 1 | 28756 | 4 | 3.406 | 8442.7 |
| 1964 | 2025-06-05 23:20:24 | piano | 1 | 28756 | 4 | 1.936 | 14853.3 |
| 1963 | 2025-06-02 00:31:49 | piano | 2 | 53800 | 83 | 5.966 | 9017.8 |
| 1962 | 2025-06-01 13:36:55 | piano | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1961 | 2025-05-29 14:18:45 | piano | 1 | 28756 | 4 | 3.420 | 8408.2 |
| 1960 | 2025-05-29 02:32:24 | piano | 1 | 28756 | 4 | 2.780 | 10343.9 |
| 1959 | 2025-05-21 17:26:55 | piano | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1958 | 2025-05-16 00:25:49 | piano | 1 | 28756 | 4 | 3.286 | 8751.1 |
| 1957 | 2025-05-14 06:36:52 | piano | 3 | 83667 | 1132 | 26.690 | 3134.8 |
| 1956 | 2025-05-13 02:03:07 | piano | 3 | 83667 | 1132 | 3.906 | 21420.1 |
| 1955 | 2025-05-12 12:46:45 | piano | 3 | 83667 | 1132 | 27.406 | 3052.9 |
| 1954 | 2025-05-10 20:17:59 | piano | 2 | 53800 | 83 | 8.500 | 6329.4 |
| 1953 | 2025-05-09 09:53:03 | piano | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1952 | 2025-05-08 13:30:29 | piano | 2 | 53800 | 83 | 4.420 | 12171.9 |
| 1951 | 2025-05-08 07:44:32 | piano | 2 | 53800 | 83 | 8.483 | 6342.1 |