History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knocker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
264 | 2024-05-01 17:18:13 | knocker | 1 | 69583 | 4 | 2.296 | 30306.2 |
263 | 2024-03-28 10:37:30 | knocker | 1 | 69583 | 4 | 1.233 | 56433.9 |
262 | 2024-02-06 04:58:12 | knocker | 1 | 69583 | 4 | 2.343 | 29698.3 |
261 | 2024-02-02 09:10:32 | knocker | 1 | 69583 | 4 | 1.030 | 67556.3 |
260 | 2024-01-26 02:25:05 | knocker | 1 | 69583 | 4 | 1.173 | 59320.5 |
259 | 2024-01-08 20:07:36 | knocker | 2 | 107671 | 32 | 3.063 | 35152.1 |
258 | 2023-12-08 23:01:57 | knocker | 3 | 134027 | 244 | 8.766 | 15289.4 |
257 | 2023-12-08 23:01:54 | knocker | 2 | 107671 | 32 | 3.203 | 33615.7 |
256 | 2023-11-22 03:16:01 | knocker | 1 | 69583 | 4 | 1.250 | 55666.4 |
255 | 2023-11-21 09:20:10 | knocker | 1 | 69583 | 4 | 1.046 | 66522.9 |
254 | 2023-11-21 08:18:44 | knocker | 1 | 69583 | 4 | 1.013 | 68690.0 |
253 | 2023-11-10 15:34:31 | knocker | 1 | 69583 | 4 | 1.140 | 61037.7 |
252 | 2023-11-05 21:32:10 | knocker | 1 | 69583 | 4 | 1.046 | 66522.9 |
251 | 2023-10-17 03:39:20 | knocker | 2 | 107671 | 32 | 2.766 | 38926.6 |
250 | 2023-09-28 23:15:47 | knocker | 1 | 69583 | 4 | 1.170 | 59472.6 |
249 | 2023-09-24 16:05:12 | knocker | 1 | 69583 | 4 | 1.186 | 58670.3 |
248 | 2023-09-23 23:56:41 | knocker | 1 | 69583 | 4 | 1.016 | 68487.2 |
247 | 2023-09-08 10:24:13 | knocker | 1 | 69583 | 4 | 1.013 | 68690.0 |
246 | 2023-07-28 04:42:37 | knocker | 2 | 107671 | 32 | 2.796 | 38508.9 |
245 | 2023-06-11 10:02:50 | knocker | 1 | 69583 | 4 | 0.986 | 70571.0 |
244 | 2023-05-28 19:04:33 | knocker | 1 | 69583 | 4 | 1.080 | 64428.7 |
243 | 2023-04-05 22:58:39 | knocker | 2 | 107671 | 32 | 4.766 | 22591.5 |
242 | 2023-03-30 19:46:14 | knocker | 1 | 69583 | 4 | 1.033 | 67360.1 |
241 | 2023-02-01 22:40:55 | knocker | 1 | 69583 | 4 | 0.983 | 70786.4 |
240 | 2023-01-13 02:42:32 | knocker | 1 | 69583 | 4 | 1.093 | 63662.4 |
239 | 2023-01-04 10:47:49 | knocker | 2 | 107671 | 32 | 3.190 | 33752.7 |
238 | 2022-10-27 02:45:00 | knocker | 1 | 69583 | 4 | 1.000 | 69583.0 |
237 | 2022-10-04 09:27:25 | knocker | 1 | 69583 | 4 | 1.126 | 61796.6 |
236 | 2022-09-07 20:02:05 | knocker | 2 | 107671 | 32 | 3.126 | 34443.7 |
235 | 2022-08-07 09:10:17 | knocker | 1 | 69583 | 4 | 1.220 | 57035.2 |
234 | 2022-06-14 16:50:45 | knocker | 1 | 69583 | 4 | 1.173 | 59320.5 |
233 | 2022-05-31 00:17:59 | knocker | 1 | 69583 | 4 | 1.046 | 66522.9 |
232 | 2022-05-18 18:20:57 | knocker | 1 | 69583 | 4 | 1.123 | 61961.7 |
231 | 2022-02-22 07:02:45 | knocker | 1 | 69583 | 4 | 1.106 | 62914.1 |
230 | 2022-01-22 20:26:36 | knocker | 1 | 69583 | 4 | 1.000 | 69583.0 |
229 | 2021-12-13 11:49:46 | knocker | 1 | 69583 | 4 | 2.263 | 30748.1 |
228 | 2021-12-11 09:41:34 | knocker | 1 | 69583 | 4 | 1.233 | 56433.9 |
227 | 2021-11-06 02:35:02 | knocker | 1 | 69583 | 4 | 1.200 | 57985.8 |
226 | 2021-09-30 06:13:36 | knocker | 1 | 69583 | 4 | 1.030 | 67556.3 |
225 | 2021-05-12 19:17:57 | knocker | 3 | 134027 | 244 | 6.830 | 19623.3 |
224 | 2021-04-08 13:28:18 | knocker | 1 | 69583 | 4 | 1.123 | 61961.7 |
223 | 2021-03-12 19:27:22 | knocker | 1 | 69583 | 4 | 1.126 | 61796.6 |
222 | 2021-02-18 15:52:21 | knocker | 3 | 134027 | 244 | 6.343 | 21129.9 |
221 | 2021-02-16 03:55:46 | knocker | 1 | 69583 | 4 | 1.063 | 65459.1 |
220 | 2021-01-23 11:14:54 | knocker | 1 | 69583 | 4 | 1.063 | 65459.1 |
219 | 2020-11-01 08:04:16 | knocker | 1 | 69583 | 4 | 1.030 | 67556.3 |
218 | 2020-10-29 07:16:37 | knocker | 1 | 69583 | 4 | 1.000 | 69583.0 |
217 | 2020-10-22 13:00:34 | knocker | 1 | 69583 | 4 | 1.046 | 66522.9 |
216 | 2020-10-09 02:26:34 | knocker | 1 | 69583 | 4 | 1.953 | 35628.8 |
215 | 2020-09-06 23:51:39 | knocker | 1 | 69583 | 4 | 1.063 | 65459.1 |
214 | 2020-08-28 21:59:48 | knocker | 1 | 69583 | 4 | 1.076 | 64668.2 |
213 | 2020-08-12 10:37:59 | knocker | 1 | 69583 | 4 | 1.030 | 67556.3 |
212 | 2020-07-24 04:12:28 | knocker | 1 | 69583 | 4 | 1.156 | 60192.9 |
211 | 2020-06-15 13:31:34 | knocker | 1 | 69583 | 4 | 1.063 | 65459.1 |
210 | 2020-03-22 22:28:25 | knocker | 1 | 69583 | 4 | 1.156 | 60192.9 |
209 | 2020-03-18 14:08:06 | knocker | 1 | 69583 | 4 | 1.216 | 57222.9 |
208 | 2020-03-15 19:20:50 | knocker | 1 | 69583 | 4 | 1.030 | 67556.3 |
207 | 2020-02-29 07:41:42 | knocker | 1 | 69583 | 4 | 1.250 | 55666.4 |
206 | 2020-02-27 02:04:38 | knocker | 3 | 134027 | 244 | 22.983 | 5831.6 |
205 | 2020-02-27 01:07:26 | knocker | 3 | 134027 | 244 | 7.140 | 18771.3 |
204 | 2020-02-26 03:39:19 | knocker | 3 | 134027 | 244 | 7.733 | 17331.8 |
203 | 2020-02-23 08:34:01 | knocker | 1 | 69583 | 4 | 1.280 | 54361.7 |
202 | 2020-02-22 06:46:28 | knocker | 3 | 134027 | 244 | 7.186 | 18651.1 |
201 | 2020-02-22 05:53:06 | knocker | 3 | 134027 | 244 | 7.140 | 18771.3 |
200 | 2020-02-21 07:21:25 | knocker | 3 | 134027 | 244 | 6.470 | 20715.1 |
199 | 2020-02-19 18:07:37 | knocker | 1 | 69583 | 4 | 1.076 | 64668.2 |
198 | 2020-02-18 23:40:36 | knocker | 1 | 69583 | 4 | 2.813 | 24736.2 |
197 | 2020-02-18 17:34:14 | knocker | 1 | 69583 | 4 | 1.300 | 53525.4 |
196 | 2020-02-03 02:51:31 | knocker | 1 | 69583 | 4 | 1.263 | 55093.4 |
195 | 2020-02-02 21:08:54 | knocker | 1 | 69583 | 4 | 3.923 | 17737.2 |
194 | 2020-02-01 13:45:59 | knocker | 1 | 69583 | 4 | 1.810 | 38443.6 |
193 | 2020-01-25 01:00:24 | knocker | 1 | 69583 | 4 | 3.530 | 19711.9 |
192 | 2020-01-24 17:54:00 | knocker | 2 | 107671 | 32 | 8.250 | 13051.0 |
191 | 2020-01-24 17:12:26 | knocker | 1 | 69583 | 4 | 1.250 | 55666.4 |
190 | 2020-01-20 12:44:09 | knocker | 1 | 69583 | 4 | 1.266 | 54962.9 |
189 | 2020-01-17 08:04:46 | knocker | 3 | 134027 | 244 | 7.453 | 17983.0 |
188 | 2020-01-17 01:38:09 | knocker | 3 | 134027 | 244 | 9.890 | 13551.8 |
187 | 2020-01-17 01:37:46 | knocker | 2 | 107671 | 32 | 3.063 | 35152.1 |
186 | 2020-01-16 20:29:25 | knocker | 1 | 69583 | 4 | 2.500 | 27833.2 |
185 | 2020-01-12 05:59:59 | knocker | 1 | 69583 | 4 | 1.453 | 47889.2 |
184 | 2020-01-09 20:51:50 | knocker | 1 | 69583 | 4 | 1.266 | 54962.9 |
183 | 2019-12-30 05:53:15 | knocker | 1 | 69583 | 4 | 2.563 | 27149.0 |
182 | 2019-12-28 23:41:59 | knocker | 1 | 69583 | 4 | 1.203 | 57841.2 |
181 | 2019-12-12 23:51:59 | knocker | 1 | 69583 | 4 | 1.046 | 66522.9 |
180 | 2019-09-11 07:34:21 | knocker | 1 | 69583 | 4 | 1.090 | 63837.6 |
179 | 2019-07-13 11:19:00 | knocker | 1 | 69583 | 4 | 0.990 | 70285.9 |
178 | 2019-06-11 15:08:16 | knocker | 1 | 69583 | 4 | 1.050 | 66269.5 |
177 | 2019-03-30 20:57:07 | knocker | 1 | 69583 | 4 | 0.993 | 70073.5 |
176 | 2019-02-27 06:23:13 | knocker | 1 | 69583 | 4 | 1.153 | 60349.5 |
175 | 2019-01-30 10:19:23 | knocker | 1 | 69583 | 4 | 1.963 | 35447.3 |
174 | 2018-11-16 11:02:54 | knocker | 1 | 69583 | 4 | 0.993 | 70073.5 |
173 | 2018-10-05 01:13:12 | knocker | 1 | 69583 | 4 | 2.306 | 30174.8 |
172 | 2018-08-15 15:08:24 | knocker | 1 | 69583 | 4 | 1.036 | 67165.1 |
171 | 2018-08-01 17:15:39 | knocker | 1 | 69583 | 4 | 1.080 | 64428.7 |
170 | 2018-07-15 21:12:40 | knocker | 1 | 69583 | 4 | 1.006 | 69168.0 |
169 | 2018-05-13 21:31:47 | knocker | 1 | 69583 | 4 | 2.426 | 28682.2 |
168 | 2018-01-27 23:22:32 | knocker | 1 | 69583 | 4 | 1.843 | 37755.3 |
167 | 2017-11-26 18:38:14 | knocker | 1 | 69583 | 4 | 1.420 | 49002.1 |
166 | 2017-11-19 19:47:26 | knocker | 1 | 69583 | 4 | 1.806 | 38528.8 |
165 | 2017-11-03 03:42:36 | knocker | 1 | 69583 | 4 | 1.416 | 49140.5 |