History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"correct"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
279 | 2024-05-02 04:53:57 | correct | 1 | 69583 | 4 | 1.280 | 54361.7 |
278 | 2024-04-28 06:27:49 | correct | 1 | 69583 | 4 | 1.233 | 56433.9 |
277 | 2024-04-02 22:52:08 | correct | 3 | 134027 | 213 | 20.203 | 6634.0 |
276 | 2024-04-02 05:02:37 | correct | 3 | 134027 | 213 | 27.940 | 4797.0 |
275 | 2024-04-01 09:02:53 | correct | 2 | 107671 | 22 | 7.986 | 13482.5 |
274 | 2024-03-31 21:19:44 | correct | 3 | 134027 | 213 | 13.763 | 9738.2 |
273 | 2024-03-31 05:58:33 | correct | 1 | 69583 | 4 | 2.393 | 29077.7 |
272 | 2024-03-30 22:54:37 | correct | 2 | 107671 | 22 | 4.923 | 21871.0 |
271 | 2024-03-30 06:53:33 | correct | 3 | 134027 | 213 | 23.783 | 5635.4 |
270 | 2024-03-29 22:37:27 | correct | 3 | 134027 | 213 | 17.453 | 7679.3 |
269 | 2024-03-29 13:51:46 | correct | 3 | 134027 | 213 | 25.940 | 5166.8 |
268 | 2024-03-29 13:51:46 | correct | 2 | 107671 | 22 | 9.126 | 11798.3 |
267 | 2024-03-29 13:46:53 | correct | 1 | 69583 | 4 | 1.376 | 50569.0 |
266 | 2024-03-02 06:56:32 | correct | 2 | 107671 | 22 | 3.470 | 31029.1 |
265 | 2024-03-01 09:37:40 | correct | 2 | 107671 | 22 | 11.720 | 9186.9 |
264 | 2024-02-28 22:34:38 | correct | 3 | 134027 | 213 | 7.173 | 18684.9 |
263 | 2024-02-28 14:53:58 | correct | 3 | 134027 | 213 | 11.123 | 12049.5 |
262 | 2024-02-28 09:02:12 | correct | 3 | 134027 | 213 | 23.686 | 5658.5 |
261 | 2024-02-28 09:02:13 | correct | 2 | 107671 | 22 | 11.593 | 9287.6 |
260 | 2024-02-28 06:21:25 | correct | 1 | 69583 | 4 | 1.843 | 37755.3 |
259 | 2024-02-27 11:10:40 | correct | 1 | 69583 | 4 | 1.283 | 54234.6 |
258 | 2023-12-26 08:21:11 | correct | 1 | 69583 | 4 | 1.143 | 60877.5 |
257 | 2023-12-23 12:55:11 | correct | 2 | 107671 | 22 | 3.093 | 34811.2 |
256 | 2023-12-07 21:47:37 | correct | 1 | 69583 | 4 | 1.110 | 62687.4 |
255 | 2023-11-19 16:20:14 | correct | 1 | 69583 | 4 | 1.110 | 62687.4 |
254 | 2023-11-15 08:58:44 | correct | 1 | 69583 | 4 | 1.106 | 62914.1 |
253 | 2023-10-30 16:27:11 | correct | 1 | 69583 | 4 | 1.220 | 57035.2 |
252 | 2023-10-21 00:51:07 | correct | 1 | 69583 | 4 | 1.093 | 63662.4 |
251 | 2023-10-12 10:42:55 | correct | 1 | 69583 | 4 | 1.296 | 53690.6 |
250 | 2023-10-08 13:49:41 | correct | 1 | 69583 | 4 | 1.250 | 55666.4 |
249 | 2023-09-23 12:55:01 | correct | 1 | 69583 | 4 | 1.080 | 64428.7 |
248 | 2023-09-22 20:35:32 | correct | 2 | 107671 | 22 | 2.906 | 37051.3 |
247 | 2023-07-17 10:06:11 | correct | 1 | 69583 | 4 | 1.110 | 62687.4 |
246 | 2023-07-04 03:46:47 | correct | 1 | 69583 | 4 | 1.093 | 63662.4 |
245 | 2023-06-30 17:13:52 | correct | 2 | 107671 | 22 | 2.893 | 37217.8 |
244 | 2023-04-20 06:08:30 | correct | 1 | 69583 | 4 | 1.106 | 62914.1 |
243 | 2023-03-23 23:29:41 | correct | 2 | 107671 | 22 | 2.830 | 38046.3 |
242 | 2023-03-17 12:46:25 | correct | 1 | 69583 | 4 | 1.080 | 64428.7 |
241 | 2023-02-07 19:19:42 | correct | 1 | 69583 | 4 | 1.076 | 64668.2 |
240 | 2022-12-22 19:01:00 | correct | 2 | 107671 | 22 | 2.830 | 38046.3 |
239 | 2022-12-06 03:01:28 | correct | 1 | 69583 | 4 | 1.063 | 65459.1 |
238 | 2022-11-26 02:25:35 | correct | 1 | 69583 | 4 | 1.110 | 62687.4 |
237 | 2022-11-22 17:05:36 | correct | 1 | 69583 | 4 | 1.093 | 63662.4 |
236 | 2022-08-18 22:11:40 | correct | 2 | 107671 | 22 | 3.236 | 33272.9 |
235 | 2022-08-03 09:58:31 | correct | 1 | 69583 | 4 | 1.076 | 64668.2 |
234 | 2022-08-01 02:55:54 | correct | 1 | 69583 | 4 | 1.093 | 63662.4 |
233 | 2022-07-26 11:41:40 | correct | 1 | 69583 | 4 | 1.216 | 57222.9 |
232 | 2022-04-03 01:42:09 | correct | 2 | 107671 | 22 | 2.876 | 37437.8 |
231 | 2022-03-28 12:44:28 | correct | 1 | 69583 | 4 | 1.266 | 54962.9 |
230 | 2022-03-26 10:29:07 | correct | 1 | 69583 | 4 | 1.263 | 55093.4 |
229 | 2022-01-01 09:14:00 | correct | 1 | 69583 | 4 | 1.220 | 57035.2 |
228 | 2021-12-14 06:01:37 | correct | 1 | 69583 | 4 | 1.236 | 56296.9 |
227 | 2021-11-01 19:00:06 | correct | 1 | 69583 | 4 | 1.140 | 61037.7 |
226 | 2021-09-21 06:58:42 | correct | 1 | 69583 | 4 | 1.186 | 58670.3 |
225 | 2021-09-06 23:08:43 | correct | 1 | 69583 | 4 | 1.266 | 54962.9 |
224 | 2021-08-28 05:42:53 | correct | 1 | 69583 | 4 | 1.090 | 63837.6 |
223 | 2021-06-05 23:21:51 | correct | 1 | 69583 | 4 | 1.110 | 62687.4 |
222 | 2021-06-02 19:06:05 | correct | 1 | 69583 | 4 | 1.233 | 56433.9 |
221 | 2021-05-09 02:44:35 | correct | 1 | 69583 | 4 | 1.453 | 47889.2 |
220 | 2021-04-20 09:29:42 | correct | 1 | 69583 | 4 | 1.220 | 57035.2 |
219 | 2021-02-28 05:43:58 | correct | 1 | 69583 | 4 | 1.156 | 60192.9 |
218 | 2021-02-23 16:52:11 | correct | 1 | 69583 | 4 | 1.220 | 57035.2 |
217 | 2021-01-30 13:39:23 | correct | 1 | 69583 | 4 | 1.110 | 62687.4 |
216 | 2021-01-30 08:41:22 | correct | 1 | 69583 | 4 | 1.216 | 57222.9 |
215 | 2020-11-23 15:55:53 | correct | 1 | 69583 | 4 | 1.220 | 57035.2 |
214 | 2020-10-18 05:56:23 | correct | 1 | 69583 | 4 | 1.173 | 59320.5 |
213 | 2020-08-12 18:15:53 | correct | 1 | 69583 | 4 | 1.546 | 45008.4 |
212 | 2020-05-11 15:56:55 | correct | 1 | 69583 | 4 | 1.126 | 61796.6 |
211 | 2020-03-29 17:10:00 | correct | 1 | 69583 | 4 | 1.093 | 63662.4 |
210 | 2020-03-27 04:05:46 | correct | 1 | 69583 | 4 | 1.360 | 51164.0 |
209 | 2020-03-22 00:59:02 | correct | 1 | 69583 | 4 | 1.233 | 56433.9 |
208 | 2020-03-01 18:33:33 | correct | 3 | 134027 | 213 | 6.110 | 21935.7 |
207 | 2020-02-29 06:07:33 | correct | 3 | 134027 | 213 | 18.813 | 7124.2 |
206 | 2020-02-28 20:21:11 | correct | 3 | 134027 | 213 | 15.453 | 8673.2 |
205 | 2020-02-28 19:48:13 | correct | 3 | 134027 | 213 | 18.330 | 7311.9 |
204 | 2020-02-28 16:19:30 | correct | 3 | 134027 | 213 | 12.720 | 10536.7 |
203 | 2020-02-28 11:38:10 | correct | 1 | 69583 | 4 | 1.126 | 61796.6 |
202 | 2020-02-28 06:55:11 | correct | 3 | 134027 | 213 | 18.360 | 7299.9 |
201 | 2020-02-21 09:19:54 | correct | 1 | 69583 | 4 | 2.733 | 25460.3 |
200 | 2020-02-21 04:40:29 | correct | 1 | 69583 | 4 | 1.343 | 51811.6 |
199 | 2020-02-16 18:59:34 | correct | 1 | 69583 | 4 | 1.406 | 49490.0 |
198 | 2020-02-11 13:22:40 | correct | 1 | 69583 | 4 | 1.220 | 57035.2 |
197 | 2020-02-09 01:13:26 | correct | 1 | 69583 | 4 | 2.403 | 28956.7 |
196 | 2020-02-06 01:38:16 | correct | 1 | 69583 | 4 | 3.546 | 19623.0 |
195 | 2020-01-30 21:34:53 | correct | 1 | 69583 | 4 | 3.170 | 21950.5 |
194 | 2020-01-25 07:05:03 | correct | 1 | 69583 | 4 | 1.360 | 51164.0 |
193 | 2020-01-25 03:21:33 | correct | 1 | 69583 | 4 | 2.733 | 25460.3 |
192 | 2020-01-20 18:40:08 | correct | 1 | 69583 | 4 | 2.110 | 32977.7 |
191 | 2020-01-20 11:11:14 | correct | 1 | 69583 | 4 | 1.346 | 51696.1 |
190 | 2020-01-14 20:39:15 | correct | 3 | 134027 | 213 | 11.813 | 11345.7 |
189 | 2020-01-14 19:24:46 | correct | 3 | 134027 | 213 | 10.816 | 12391.5 |
188 | 2020-01-14 15:08:09 | correct | 3 | 134027 | 213 | 7.576 | 17691.0 |
187 | 2020-01-14 15:07:35 | correct | 2 | 107671 | 22 | 2.923 | 36835.8 |
186 | 2020-01-14 11:56:15 | correct | 1 | 69583 | 4 | 1.250 | 55666.4 |
185 | 2020-01-06 17:58:09 | correct | 1 | 69583 | 4 | 1.640 | 42428.7 |
184 | 2019-12-30 09:36:26 | correct | 1 | 69583 | 4 | 2.046 | 34009.3 |
183 | 2019-12-29 23:36:13 | correct | 1 | 69583 | 4 | 1.280 | 54361.7 |
182 | 2019-12-28 20:05:52 | correct | 1 | 69583 | 4 | 1.326 | 52475.9 |
181 | 2019-11-08 14:54:18 | correct | 1 | 69583 | 4 | 1.093 | 63662.4 |
180 | 2019-08-10 12:02:15 | correct | 1 | 69583 | 4 | 1.053 | 66080.7 |