History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pilar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2091 | 2024-05-04 10:18:15 | pilar | 1 | 28756 | 8 | 1.063 | 27051.7 |
2090 | 2024-05-04 05:10:06 | pilar | 1 | 28756 | 8 | 0.750 | 38341.3 |
2089 | 2024-05-04 05:09:40 | pilar | 1 | 28756 | 8 | 0.533 | 53951.2 |
2088 | 2024-05-01 11:03:11 | pilar | 3 | 83667 | 1341 | 11.216 | 7459.6 |
2087 | 2024-05-01 11:03:07 | pilar | 1 | 28756 | 8 | 0.830 | 34645.8 |
2086 | 2024-05-01 11:02:45 | pilar | 2 | 53800 | 97 | 3.686 | 14595.8 |
2085 | 2024-04-30 19:34:42 | pilar | 2 | 53800 | 97 | 1.766 | 30464.3 |
2084 | 2024-04-30 19:33:50 | pilar | 2 | 53800 | 97 | 1.656 | 32487.9 |
2083 | 2024-04-30 15:45:15 | pilar | 1 | 28756 | 8 | 0.483 | 59536.2 |
2082 | 2024-04-29 21:43:05 | pilar | 1 | 28756 | 8 | 1.000 | 28756.0 |
2081 | 2024-04-25 21:20:01 | pilar | 3 | 83667 | 1341 | 8.890 | 9411.4 |
2080 | 2024-04-24 12:03:52 | pilar | 1 | 28756 | 8 | 0.576 | 49923.6 |
2079 | 2024-04-23 14:26:37 | pilar | 1 | 28756 | 8 | 1.500 | 19170.7 |
2078 | 2024-04-23 14:12:28 | pilar | 1 | 28756 | 8 | 2.766 | 10396.2 |
2077 | 2024-04-23 13:52:16 | pilar | 1 | 28756 | 8 | 1.626 | 17685.1 |
2076 | 2024-04-22 22:41:54 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2075 | 2024-04-22 16:31:31 | pilar | 1 | 28756 | 8 | 0.623 | 46157.3 |
2074 | 2024-04-21 14:10:40 | pilar | 3 | 83667 | 1341 | 10.406 | 8040.3 |
2073 | 2024-04-19 14:30:26 | pilar | 3 | 83667 | 1341 | 5.626 | 14871.5 |
2072 | 2024-04-16 12:55:03 | pilar | 3 | 83667 | 1341 | 4.140 | 20209.4 |
2071 | 2024-04-10 05:51:19 | pilar | 2 | 53800 | 97 | 1.906 | 28226.7 |
2070 | 2024-04-03 08:10:24 | pilar | 2 | 53800 | 97 | 2.000 | 26900.0 |
2069 | 2024-04-03 08:03:18 | pilar | 1 | 28756 | 8 | 0.750 | 38341.3 |
2068 | 2024-04-02 23:54:28 | pilar | 3 | 83667 | 1341 | 7.593 | 11019.0 |
2067 | 2024-04-01 18:01:12 | pilar | 3 | 83667 | 1341 | 13.143 | 6365.9 |
2066 | 2024-03-31 10:27:38 | pilar | 2 | 53800 | 97 | 3.000 | 17933.3 |
2065 | 2024-03-31 08:12:24 | pilar | 1 | 28756 | 8 | 0.516 | 55728.7 |
2064 | 2024-03-31 06:28:17 | pilar | 3 | 83667 | 1341 | 11.423 | 7324.4 |
2063 | 2024-03-30 23:40:03 | pilar | 3 | 83667 | 1341 | 9.516 | 8792.2 |
2062 | 2024-03-30 12:14:19 | pilar | 3 | 83667 | 1341 | 8.796 | 9511.9 |
2061 | 2024-03-30 11:53:44 | pilar | 3 | 83667 | 1341 | 3.843 | 21771.3 |
2060 | 2024-03-29 09:29:43 | pilar | 1 | 28756 | 8 | 0.533 | 53951.2 |
2059 | 2024-03-09 14:27:32 | pilar | 3 | 83667 | 1341 | 3.360 | 24900.9 |
2058 | 2024-03-06 00:00:00 | pilar | 1 | 28756 | 8 | 1.220 | 23570.5 |
2057 | 2024-03-03 21:39:40 | pilar | 1 | 28756 | 8 | 0.453 | 63479.0 |
2056 | 2024-03-02 23:26:19 | pilar | 1 | 28756 | 8 | 1.343 | 21411.8 |
2055 | 2024-03-01 03:08:16 | pilar | 1 | 28756 | 8 | 0.516 | 55728.7 |
2054 | 2024-02-28 02:52:19 | pilar | 1 | 28756 | 8 | 0.500 | 57512.0 |
2053 | 2024-02-24 19:01:57 | pilar | 2 | 53800 | 97 | 1.906 | 28226.7 |
2052 | 2024-02-24 19:01:15 | pilar | 3 | 83667 | 1341 | 4.453 | 18788.9 |
2051 | 2024-02-24 01:50:27 | pilar | 3 | 83667 | 1341 | 3.593 | 23286.1 |
2050 | 2024-02-02 19:51:03 | pilar | 1 | 28756 | 8 | 0.530 | 54256.6 |
2049 | 2024-01-30 08:08:38 | pilar | 2 | 53800 | 97 | 2.266 | 23742.3 |
2048 | 2024-01-30 08:08:10 | pilar | 3 | 83667 | 1341 | 4.250 | 19686.4 |
2047 | 2024-01-29 18:57:46 | pilar | 3 | 83667 | 1341 | 4.093 | 20441.5 |
2046 | 2024-01-29 05:30:39 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2045 | 2024-01-29 01:17:53 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2044 | 2024-01-24 19:45:45 | pilar | 1 | 28756 | 8 | 0.470 | 61183.0 |
2043 | 2024-01-16 04:34:56 | pilar | 3 | 83667 | 1341 | 3.376 | 24782.9 |
2042 | 2024-01-13 08:16:49 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2041 | 2024-01-05 22:23:24 | pilar | 1 | 28756 | 8 | 0.486 | 59168.7 |
2040 | 2024-01-03 02:46:18 | pilar | 3 | 83667 | 1341 | 3.486 | 24000.9 |
2039 | 2023-12-14 06:03:34 | pilar | 3 | 83667 | 1341 | 3.690 | 22674.0 |
2038 | 2023-12-12 18:50:37 | pilar | 2 | 53800 | 97 | 1.406 | 38264.6 |
2037 | 2023-12-11 19:53:25 | pilar | 2 | 53800 | 97 | 1.623 | 33148.5 |
2036 | 2023-12-10 04:10:17 | pilar | 2 | 53800 | 97 | 1.546 | 34799.5 |
2035 | 2023-12-08 01:10:25 | pilar | 2 | 53800 | 97 | 1.360 | 39558.8 |
2034 | 2023-12-08 01:10:22 | pilar | 2 | 53800 | 97 | 1.563 | 34421.0 |
2033 | 2023-12-08 00:36:53 | pilar | 3 | 83667 | 1341 | 3.656 | 22884.8 |
2032 | 2023-12-08 00:36:48 | pilar | 3 | 83667 | 1341 | 3.546 | 23594.8 |
2031 | 2023-12-07 23:01:40 | pilar | 3 | 83667 | 1341 | 3.956 | 21149.4 |
2030 | 2023-12-07 23:01:35 | pilar | 3 | 83667 | 1341 | 4.123 | 20292.7 |
2029 | 2023-12-07 09:10:23 | pilar | 3 | 83667 | 1341 | 4.283 | 19534.7 |
2028 | 2023-12-05 10:57:25 | pilar | 3 | 83667 | 1341 | 3.580 | 23370.7 |
2027 | 2023-12-03 16:18:56 | pilar | 3 | 83667 | 1341 | 4.513 | 18539.1 |
2026 | 2023-11-28 10:49:50 | pilar | 3 | 83667 | 1341 | 3.923 | 21327.3 |
2025 | 2023-11-16 23:54:33 | pilar | 3 | 83667 | 1341 | 3.623 | 23093.3 |
2024 | 2023-11-14 18:46:30 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2023 | 2023-11-13 22:49:48 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2022 | 2023-11-12 12:47:54 | pilar | 3 | 83667 | 1341 | 3.263 | 25641.1 |
2021 | 2023-11-11 03:58:34 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2020 | 2023-11-10 18:52:18 | pilar | 3 | 83667 | 1341 | 3.296 | 25384.4 |
2019 | 2023-11-10 18:52:13 | pilar | 2 | 53800 | 97 | 1.483 | 36277.8 |
2018 | 2023-11-07 06:28:46 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2017 | 2023-11-03 05:13:43 | pilar | 1 | 28756 | 8 | 0.483 | 59536.2 |
2016 | 2023-10-30 07:30:32 | pilar | 1 | 28756 | 8 | 0.546 | 52666.7 |
2015 | 2023-10-21 07:40:12 | pilar | 1 | 28756 | 8 | 0.516 | 55728.7 |
2014 | 2023-10-20 19:51:02 | pilar | 1 | 28756 | 8 | 0.453 | 63479.0 |
2013 | 2023-10-18 11:34:21 | pilar | 1 | 28756 | 8 | 0.483 | 59536.2 |
2012 | 2023-10-11 07:37:30 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2011 | 2023-10-05 04:20:30 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
2010 | 2023-10-03 10:07:58 | pilar | 3 | 83667 | 1341 | 4.690 | 17839.4 |
2009 | 2023-09-27 05:16:08 | pilar | 3 | 83667 | 1341 | 3.623 | 23093.3 |
2008 | 2023-09-26 17:00:57 | pilar | 1 | 28756 | 8 | 0.516 | 55728.7 |
2007 | 2023-09-25 06:50:50 | pilar | 1 | 28756 | 8 | 0.483 | 59536.2 |
2006 | 2023-09-19 17:19:34 | pilar | 3 | 83667 | 1341 | 3.720 | 22491.1 |
2005 | 2023-09-12 18:45:46 | pilar | 2 | 53800 | 97 | 1.546 | 34799.5 |
2004 | 2023-09-12 18:20:15 | pilar | 1 | 28756 | 8 | 0.516 | 55728.7 |
2003 | 2023-09-10 13:43:09 | pilar | 2 | 53800 | 97 | 1.360 | 39558.8 |
2002 | 2023-09-10 13:14:36 | pilar | 3 | 83667 | 1341 | 4.720 | 17726.1 |
2001 | 2023-09-02 12:45:07 | pilar | 3 | 83667 | 1341 | 3.283 | 25484.9 |
2000 | 2023-08-23 02:29:19 | pilar | 1 | 28756 | 8 | 0.546 | 52666.7 |
1999 | 2023-06-12 23:22:22 | pilar | 1 | 28756 | 8 | 0.436 | 65954.1 |
1998 | 2023-06-08 19:35:15 | pilar | 2 | 53800 | 97 | 1.500 | 35866.7 |
1997 | 2023-05-26 14:09:55 | pilar | 1 | 28756 | 8 | 0.453 | 63479.0 |
1996 | 2023-05-20 10:19:40 | pilar | 3 | 83667 | 1341 | 3.373 | 24804.9 |
1995 | 2023-05-03 14:06:09 | pilar | 3 | 83667 | 1341 | 3.330 | 25125.2 |
1994 | 2023-04-28 16:29:03 | pilar | 2 | 53800 | 97 | 1.530 | 35163.4 |
1993 | 2023-03-29 05:17:39 | pilar | 2 | 53800 | 97 | 1.576 | 34137.1 |
1992 | 2023-03-23 08:32:18 | pilar | 1 | 28756 | 8 | 0.483 | 59536.2 |