History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"closest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
307 | 2024-04-18 11:53:55 | closest | 3 | 134027 | 350 | 8.623 | 15543.0 |
306 | 2024-04-16 07:31:02 | closest | 2 | 107671 | 28 | 5.453 | 19745.3 |
305 | 2024-04-16 06:35:39 | closest | 3 | 134027 | 350 | 6.936 | 19323.4 |
304 | 2024-04-15 19:41:21 | closest | 3 | 134027 | 350 | 14.546 | 9214.0 |
303 | 2024-04-14 09:33:12 | closest | 3 | 134027 | 350 | 18.813 | 7124.2 |
302 | 2024-04-14 09:33:11 | closest | 2 | 107671 | 28 | 6.266 | 17183.4 |
301 | 2024-04-14 09:02:42 | closest | 1 | 69583 | 4 | 1.170 | 59472.6 |
300 | 2024-03-29 22:50:14 | closest | 1 | 69583 | 4 | 4.203 | 16555.6 |
299 | 2024-03-28 19:15:33 | closest | 1 | 69583 | 4 | 4.170 | 16686.6 |
298 | 2024-03-18 04:19:39 | closest | 1 | 69583 | 4 | 1.313 | 52995.4 |
297 | 2024-03-11 18:50:19 | closest | 3 | 134027 | 350 | 8.563 | 15651.9 |
296 | 2024-02-28 17:16:51 | closest | 1 | 69583 | 4 | 1.076 | 64668.2 |
295 | 2024-02-23 03:25:34 | closest | 3 | 134027 | 350 | 8.203 | 16338.8 |
294 | 2024-02-18 13:08:53 | closest | 2 | 107671 | 28 | 3.000 | 35890.3 |
293 | 2024-02-18 12:47:58 | closest | 3 | 134027 | 350 | 6.716 | 19956.4 |
292 | 2024-02-18 03:23:11 | closest | 3 | 134027 | 350 | 19.970 | 6711.4 |
291 | 2024-01-17 14:47:34 | closest | 3 | 134027 | 350 | 5.846 | 22926.3 |
290 | 2024-01-17 14:47:31 | closest | 2 | 107671 | 28 | 3.406 | 31612.2 |
289 | 2024-01-15 14:29:14 | closest | 3 | 134027 | 350 | 11.483 | 11671.8 |
288 | 2024-01-15 14:29:17 | closest | 2 | 107671 | 28 | 3.530 | 30501.7 |
287 | 2023-12-23 12:06:02 | closest | 1 | 69583 | 4 | 1.200 | 57985.8 |
286 | 2023-12-17 08:15:23 | closest | 1 | 69583 | 4 | 1.156 | 60192.9 |
285 | 2023-11-20 05:30:16 | closest | 1 | 69583 | 4 | 1.190 | 58473.1 |
284 | 2023-11-16 23:48:42 | closest | 1 | 69583 | 4 | 1.063 | 65459.1 |
283 | 2023-11-01 23:30:50 | closest | 1 | 69583 | 4 | 1.093 | 63662.4 |
282 | 2023-10-23 00:12:22 | closest | 1 | 69583 | 4 | 1.236 | 56296.9 |
281 | 2023-10-19 17:40:38 | closest | 1 | 69583 | 4 | 1.170 | 59472.6 |
280 | 2023-10-15 00:00:49 | closest | 1 | 69583 | 4 | 1.093 | 63662.4 |
279 | 2023-10-03 10:17:20 | closest | 1 | 69583 | 4 | 1.080 | 64428.7 |
278 | 2023-09-29 11:42:37 | closest | 1 | 69583 | 4 | 1.140 | 61037.7 |
277 | 2023-09-03 08:57:06 | closest | 1 | 69583 | 4 | 1.203 | 57841.2 |
276 | 2023-07-31 07:41:57 | closest | 1 | 69583 | 4 | 1.063 | 65459.1 |
275 | 2023-07-20 20:03:50 | closest | 1 | 69583 | 4 | 1.063 | 65459.1 |
274 | 2023-05-17 15:55:15 | closest | 1 | 69583 | 4 | 1.143 | 60877.5 |
273 | 2023-04-29 03:38:20 | closest | 1 | 69583 | 4 | 1.076 | 64668.2 |
272 | 2023-02-20 06:19:23 | closest | 1 | 69583 | 4 | 1.060 | 65644.3 |
271 | 2023-01-31 19:57:21 | closest | 1 | 69583 | 4 | 2.126 | 32729.5 |
270 | 2022-12-16 20:27:00 | closest | 1 | 69583 | 4 | 1.110 | 62687.4 |
269 | 2022-10-14 01:53:35 | closest | 1 | 69583 | 4 | 1.110 | 62687.4 |
268 | 2022-08-24 08:49:45 | closest | 1 | 69583 | 4 | 2.186 | 31831.2 |
267 | 2022-07-01 10:14:09 | closest | 1 | 69583 | 4 | 1.216 | 57222.9 |
266 | 2022-04-07 23:03:04 | closest | 1 | 69583 | 4 | 1.500 | 46388.7 |
265 | 2022-04-05 18:59:15 | closest | 1 | 69583 | 4 | 1.203 | 57841.2 |
264 | 2022-03-11 02:15:16 | closest | 1 | 69583 | 4 | 1.093 | 63662.4 |
263 | 2022-01-03 03:31:27 | closest | 1 | 69583 | 4 | 1.170 | 59472.6 |
262 | 2021-11-27 07:52:51 | closest | 1 | 69583 | 4 | 1.266 | 54962.9 |
261 | 2021-11-05 14:30:29 | closest | 1 | 69583 | 4 | 1.063 | 65459.1 |
260 | 2021-11-03 13:07:19 | closest | 1 | 69583 | 4 | 1.186 | 58670.3 |
259 | 2021-09-16 14:53:01 | closest | 1 | 69583 | 4 | 1.283 | 54234.6 |
258 | 2021-09-14 11:13:37 | closest | 1 | 69583 | 4 | 1.170 | 59472.6 |
257 | 2021-08-27 21:09:12 | closest | 1 | 69583 | 4 | 1.173 | 59320.5 |
256 | 2021-08-21 01:23:20 | closest | 1 | 69583 | 4 | 1.763 | 39468.5 |
255 | 2021-08-17 17:44:23 | closest | 1 | 69583 | 4 | 1.173 | 59320.5 |
254 | 2021-07-24 14:08:38 | closest | 2 | 107671 | 28 | 2.796 | 38508.9 |
253 | 2021-05-20 16:11:59 | closest | 1 | 69583 | 4 | 1.123 | 61961.7 |
252 | 2021-05-17 03:22:44 | closest | 1 | 69583 | 4 | 1.280 | 54361.7 |
251 | 2021-05-14 15:51:06 | closest | 2 | 107671 | 28 | 3.186 | 33795.0 |
250 | 2021-04-13 16:39:15 | closest | 2 | 107671 | 28 | 6.063 | 17758.7 |
249 | 2021-03-20 19:06:08 | closest | 1 | 69583 | 4 | 1.063 | 65459.1 |
248 | 2021-02-23 11:36:50 | closest | 1 | 69583 | 4 | 1.063 | 65459.1 |
247 | 2021-02-20 09:16:46 | closest | 2 | 107671 | 28 | 2.876 | 37437.8 |
246 | 2021-02-11 16:36:23 | closest | 3 | 134027 | 350 | 5.966 | 22465.1 |
245 | 2021-02-10 04:18:35 | closest | 1 | 69583 | 4 | 1.080 | 64428.7 |
244 | 2021-02-05 12:43:35 | closest | 1 | 69583 | 4 | 1.220 | 57035.2 |
243 | 2021-01-15 09:22:40 | closest | 3 | 134027 | 350 | 5.860 | 22871.5 |
242 | 2021-01-15 09:22:37 | closest | 2 | 107671 | 28 | 2.843 | 37872.3 |
241 | 2021-01-15 09:22:36 | closest | 1 | 69583 | 4 | 1.080 | 64428.7 |
240 | 2020-11-03 10:12:46 | closest | 1 | 69583 | 4 | 1.140 | 61037.7 |
239 | 2020-11-03 07:44:11 | closest | 1 | 69583 | 4 | 1.186 | 58670.3 |
238 | 2020-10-17 01:03:01 | closest | 1 | 69583 | 4 | 1.216 | 57222.9 |
237 | 2020-08-09 07:14:18 | closest | 1 | 69583 | 4 | 1.093 | 63662.4 |
236 | 2020-08-06 01:24:31 | closest | 1 | 69583 | 4 | 1.076 | 64668.2 |
235 | 2020-07-27 23:10:29 | closest | 1 | 69583 | 4 | 1.126 | 61796.6 |
234 | 2020-04-22 11:53:30 | closest | 1 | 69583 | 4 | 1.216 | 57222.9 |
233 | 2020-03-30 09:21:14 | closest | 1 | 69583 | 4 | 1.250 | 55666.4 |
232 | 2020-03-27 08:09:05 | closest | 1 | 69583 | 4 | 1.203 | 57841.2 |
231 | 2020-03-25 12:28:47 | closest | 1 | 69583 | 4 | 1.233 | 56433.9 |
230 | 2020-03-24 21:47:37 | closest | 1 | 69583 | 4 | 1.643 | 42351.2 |
229 | 2020-03-21 06:55:44 | closest | 1 | 69583 | 4 | 1.200 | 57985.8 |
228 | 2020-03-04 12:41:53 | closest | 1 | 69583 | 4 | 1.173 | 59320.5 |
227 | 2020-02-21 09:29:42 | closest | 1 | 69583 | 4 | 1.373 | 50679.5 |
226 | 2020-02-15 13:43:02 | closest | 1 | 69583 | 4 | 2.876 | 24194.4 |
225 | 2020-02-12 03:00:10 | closest | 1 | 69583 | 4 | 1.326 | 52475.9 |
224 | 2020-02-10 15:32:13 | closest | 1 | 69583 | 4 | 1.500 | 46388.7 |
223 | 2020-02-06 23:57:02 | closest | 1 | 69583 | 4 | 1.203 | 57841.2 |
222 | 2020-01-30 10:14:13 | closest | 1 | 69583 | 4 | 1.326 | 52475.9 |
221 | 2020-01-25 03:26:43 | closest | 1 | 69583 | 4 | 1.330 | 52318.0 |
220 | 2020-01-24 15:25:43 | closest | 1 | 69583 | 4 | 1.406 | 49490.0 |
219 | 2020-01-22 00:16:24 | closest | 1 | 69583 | 4 | 2.343 | 29698.3 |
218 | 2020-01-21 19:13:26 | closest | 1 | 69583 | 4 | 1.360 | 51164.0 |
217 | 2020-01-19 19:00:30 | closest | 1 | 69583 | 4 | 2.466 | 28217.0 |
216 | 2020-01-15 09:49:14 | closest | 1 | 69583 | 4 | 1.263 | 55093.4 |
215 | 2020-01-11 02:11:40 | closest | 1 | 69583 | 4 | 1.263 | 55093.4 |
214 | 2020-01-08 01:05:07 | closest | 1 | 69583 | 4 | 1.343 | 51811.6 |
213 | 2019-12-29 15:09:51 | closest | 1 | 69583 | 4 | 1.123 | 61961.7 |
212 | 2019-12-28 20:35:41 | closest | 1 | 69583 | 4 | 1.186 | 58670.3 |
211 | 2019-12-09 18:32:21 | closest | 1 | 69583 | 4 | 1.093 | 63662.4 |
210 | 2019-11-02 12:13:15 | closest | 1 | 69583 | 4 | 1.063 | 65459.1 |
209 | 2019-10-23 09:22:35 | closest | 1 | 69583 | 4 | 1.110 | 62687.4 |
208 | 2019-10-07 05:14:02 | closest | 1 | 69583 | 4 | 1.190 | 58473.1 |