History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bracken"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
354 | 2024-04-15 11:07:11 | bracken | 1 | 69583 | 4 | 1.706 | 40787.2 |
353 | 2024-04-15 11:06:30 | bracken | 1 | 69583 | 4 | 3.516 | 19790.4 |
352 | 2024-03-24 17:09:08 | bracken | 1 | 69583 | 4 | 1.250 | 55666.4 |
351 | 2024-03-05 21:42:28 | bracken | 3 | 134027 | 382 | 14.703 | 9115.6 |
350 | 2024-03-05 03:28:37 | bracken | 3 | 134027 | 382 | 17.156 | 7812.3 |
349 | 2024-03-04 22:02:23 | bracken | 3 | 134027 | 382 | 18.156 | 7382.0 |
348 | 2024-03-04 04:10:30 | bracken | 3 | 134027 | 382 | 22.313 | 6006.7 |
347 | 2024-03-04 04:10:34 | bracken | 2 | 107671 | 35 | 8.096 | 13299.3 |
346 | 2024-03-03 23:31:41 | bracken | 2 | 107671 | 35 | 7.656 | 14063.6 |
345 | 2024-03-03 05:27:17 | bracken | 3 | 134027 | 382 | 23.813 | 5628.3 |
344 | 2024-03-03 05:27:19 | bracken | 2 | 107671 | 35 | 13.406 | 8031.6 |
343 | 2024-03-03 04:48:39 | bracken | 1 | 69583 | 4 | 1.076 | 64668.2 |
342 | 2024-01-11 06:11:20 | bracken | 2 | 107671 | 35 | 3.390 | 31761.4 |
341 | 2023-12-29 23:03:57 | bracken | 1 | 69583 | 4 | 1.140 | 61037.7 |
340 | 2023-12-16 17:10:56 | bracken | 1 | 69583 | 4 | 1.126 | 61796.6 |
339 | 2023-11-28 01:05:09 | bracken | 1 | 69583 | 4 | 1.140 | 61037.7 |
338 | 2023-11-21 22:21:50 | bracken | 1 | 69583 | 4 | 1.076 | 64668.2 |
337 | 2023-11-19 02:37:26 | bracken | 1 | 69583 | 4 | 1.060 | 65644.3 |
336 | 2023-11-09 20:30:21 | bracken | 1 | 69583 | 4 | 1.063 | 65459.1 |
335 | 2023-11-01 06:12:34 | bracken | 3 | 134027 | 382 | 8.766 | 15289.4 |
334 | 2023-10-24 10:21:49 | bracken | 3 | 134027 | 382 | 8.436 | 15887.5 |
333 | 2023-10-20 07:32:41 | bracken | 3 | 134027 | 382 | 7.220 | 18563.3 |
332 | 2023-10-20 07:32:42 | bracken | 2 | 107671 | 35 | 3.466 | 31064.9 |
331 | 2023-10-19 14:37:31 | bracken | 1 | 69583 | 4 | 2.656 | 26198.4 |
330 | 2023-10-19 14:05:02 | bracken | 1 | 69583 | 4 | 1.220 | 57035.2 |
329 | 2023-09-27 04:51:28 | bracken | 1 | 69583 | 4 | 2.390 | 29114.2 |
328 | 2023-09-25 08:03:39 | bracken | 1 | 69583 | 4 | 1.203 | 57841.2 |
327 | 2023-08-23 20:03:59 | bracken | 1 | 69583 | 4 | 1.110 | 62687.4 |
326 | 2023-08-14 11:26:30 | bracken | 1 | 69583 | 4 | 1.060 | 65644.3 |
325 | 2023-05-13 18:49:11 | bracken | 1 | 69583 | 4 | 1.110 | 62687.4 |
324 | 2023-05-13 14:30:56 | bracken | 1 | 69583 | 4 | 1.090 | 63837.6 |
323 | 2023-03-09 11:01:41 | bracken | 1 | 69583 | 4 | 1.063 | 65459.1 |
322 | 2023-01-31 10:31:31 | bracken | 1 | 69583 | 4 | 1.076 | 64668.2 |
321 | 2023-01-27 22:09:56 | bracken | 1 | 69583 | 4 | 1.063 | 65459.1 |
320 | 2022-12-30 17:17:23 | bracken | 1 | 69583 | 4 | 1.106 | 62914.1 |
319 | 2022-10-09 22:50:41 | bracken | 1 | 69583 | 4 | 1.080 | 64428.7 |
318 | 2022-09-17 03:21:54 | bracken | 1 | 69583 | 4 | 2.483 | 28023.8 |
317 | 2022-06-27 03:13:29 | bracken | 1 | 69583 | 4 | 1.186 | 58670.3 |
316 | 2022-04-25 06:26:53 | bracken | 1 | 69583 | 4 | 1.076 | 64668.2 |
315 | 2022-03-10 17:06:37 | bracken | 1 | 69583 | 4 | 1.500 | 46388.7 |
314 | 2022-01-16 13:38:08 | bracken | 1 | 69583 | 4 | 1.233 | 56433.9 |
313 | 2021-11-23 17:10:13 | bracken | 1 | 69583 | 4 | 1.123 | 61961.7 |
312 | 2021-11-16 12:32:27 | bracken | 1 | 69583 | 4 | 1.080 | 64428.7 |
311 | 2021-10-02 04:13:54 | bracken | 1 | 69583 | 4 | 1.296 | 53690.6 |
310 | 2021-09-30 01:43:37 | bracken | 1 | 69583 | 4 | 1.186 | 58670.3 |
309 | 2021-09-08 15:27:55 | bracken | 1 | 69583 | 4 | 1.436 | 48456.1 |
308 | 2021-08-20 16:21:23 | bracken | 1 | 69583 | 4 | 1.203 | 57841.2 |
307 | 2021-05-20 01:43:21 | bracken | 1 | 69583 | 4 | 1.076 | 64668.2 |
306 | 2021-05-14 08:04:06 | bracken | 1 | 69583 | 4 | 1.220 | 57035.2 |
305 | 2021-05-05 04:12:10 | bracken | 1 | 69583 | 4 | 2.436 | 28564.4 |
304 | 2021-04-03 06:36:36 | bracken | 1 | 69583 | 4 | 1.063 | 65459.1 |
303 | 2021-02-24 17:16:22 | bracken | 1 | 69583 | 4 | 1.250 | 55666.4 |
302 | 2021-02-17 07:18:19 | bracken | 1 | 69583 | 4 | 1.093 | 63662.4 |
301 | 2021-02-11 16:23:59 | bracken | 1 | 69583 | 4 | 1.093 | 63662.4 |
300 | 2020-12-19 02:33:21 | bracken | 1 | 69583 | 4 | 1.233 | 56433.9 |
299 | 2020-11-13 01:07:32 | bracken | 1 | 69583 | 4 | 1.156 | 60192.9 |
298 | 2020-11-12 08:47:38 | bracken | 1 | 69583 | 4 | 1.093 | 63662.4 |
297 | 2020-11-12 05:53:08 | bracken | 1 | 69583 | 4 | 1.173 | 59320.5 |
296 | 2020-10-30 23:33:34 | bracken | 3 | 134027 | 382 | 6.343 | 21129.9 |
295 | 2020-08-09 06:27:15 | bracken | 1 | 69583 | 4 | 1.076 | 64668.2 |
294 | 2020-08-06 02:38:37 | bracken | 1 | 69583 | 4 | 1.093 | 63662.4 |
293 | 2020-06-21 21:46:36 | bracken | 1 | 69583 | 4 | 1.373 | 50679.5 |
292 | 2020-05-08 01:12:14 | bracken | 1 | 69583 | 4 | 1.093 | 63662.4 |
291 | 2020-03-28 03:51:15 | bracken | 1 | 69583 | 4 | 2.516 | 27656.2 |
290 | 2020-03-24 12:37:48 | bracken | 1 | 69583 | 4 | 1.253 | 55533.1 |
289 | 2020-03-21 19:01:25 | bracken | 1 | 69583 | 4 | 1.233 | 56433.9 |
288 | 2020-02-26 20:50:06 | bracken | 1 | 69583 | 4 | 1.190 | 58473.1 |
287 | 2020-02-26 17:33:39 | bracken | 1 | 69583 | 4 | 4.156 | 16742.8 |
286 | 2020-02-21 01:47:06 | bracken | 1 | 69583 | 4 | 2.576 | 27012.0 |
285 | 2020-02-18 09:03:43 | bracken | 3 | 134027 | 382 | 8.500 | 15767.9 |
284 | 2020-02-17 17:35:20 | bracken | 1 | 69583 | 4 | 4.110 | 16930.2 |
283 | 2020-02-10 17:09:53 | bracken | 3 | 134027 | 382 | 10.530 | 12728.1 |
282 | 2020-02-10 02:51:42 | bracken | 1 | 69583 | 4 | 1.346 | 51696.1 |
281 | 2020-02-08 22:24:55 | bracken | 3 | 134027 | 382 | 15.690 | 8542.2 |
280 | 2020-02-08 18:11:59 | bracken | 3 | 134027 | 382 | 10.280 | 13037.6 |
279 | 2020-02-08 15:14:54 | bracken | 3 | 134027 | 382 | 16.470 | 8137.6 |
278 | 2020-02-08 09:25:06 | bracken | 3 | 134027 | 382 | 8.016 | 16719.9 |
277 | 2020-02-06 20:34:00 | bracken | 1 | 69583 | 4 | 2.766 | 25156.5 |
276 | 2020-02-05 11:31:33 | bracken | 1 | 69583 | 4 | 1.296 | 53690.6 |
275 | 2020-02-04 15:54:28 | bracken | 1 | 69583 | 4 | 1.283 | 54234.6 |
274 | 2020-01-29 09:59:20 | bracken | 1 | 69583 | 4 | 1.343 | 51811.6 |
273 | 2020-01-24 00:27:50 | bracken | 1 | 69583 | 4 | 2.610 | 26660.2 |
272 | 2020-01-20 16:40:59 | bracken | 1 | 69583 | 4 | 2.546 | 27330.3 |
271 | 2020-01-19 18:40:33 | bracken | 1 | 69583 | 4 | 1.300 | 53525.4 |
270 | 2020-01-19 02:43:46 | bracken | 3 | 134027 | 382 | 6.673 | 20085.0 |
269 | 2020-01-15 13:52:17 | bracken | 3 | 134027 | 382 | 6.940 | 19312.2 |
268 | 2020-01-15 07:17:07 | bracken | 2 | 107671 | 35 | 6.453 | 16685.4 |
267 | 2020-01-15 05:14:35 | bracken | 3 | 134027 | 382 | 8.000 | 16753.4 |
266 | 2020-01-15 00:23:21 | bracken | 3 | 134027 | 382 | 7.343 | 18252.3 |
265 | 2020-01-15 00:23:05 | bracken | 2 | 107671 | 35 | 3.593 | 29966.9 |
264 | 2020-01-14 21:16:12 | bracken | 1 | 69583 | 4 | 2.673 | 26031.8 |
263 | 2020-01-14 07:54:13 | bracken | 1 | 69583 | 4 | 1.406 | 49490.0 |
262 | 2019-12-29 15:29:33 | bracken | 1 | 69583 | 4 | 1.360 | 51164.0 |
261 | 2019-12-29 11:17:48 | bracken | 1 | 69583 | 4 | 1.233 | 56433.9 |
260 | 2019-12-29 07:19:31 | bracken | 1 | 69583 | 4 | 1.063 | 65459.1 |
259 | 2019-11-04 19:25:26 | bracken | 1 | 69583 | 4 | 1.093 | 63662.4 |
258 | 2019-08-03 15:32:47 | bracken | 1 | 69583 | 4 | 1.033 | 67360.1 |
257 | 2019-05-03 17:29:49 | bracken | 1 | 69583 | 4 | 1.333 | 52200.3 |
256 | 2019-04-12 07:51:25 | bracken | 1 | 69583 | 4 | 1.156 | 60192.9 |
255 | 2019-02-09 16:50:15 | bracken | 1 | 69583 | 4 | 1.136 | 61252.6 |