History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
409 | 2024-04-25 09:28:29 | collect | 1 | 69583 | 3 | 2.813 | 24736.2 |
408 | 2024-03-28 21:38:08 | collect | 1 | 69583 | 3 | 2.843 | 24475.2 |
407 | 2024-02-14 23:03:16 | collect | 1 | 69583 | 3 | 3.766 | 18476.6 |
406 | 2024-01-11 11:40:16 | collect | 2 | 107671 | 19 | 2.940 | 36622.8 |
405 | 2024-01-07 22:15:31 | collect | 3 | 134027 | 253 | 6.953 | 19276.1 |
404 | 2024-01-04 22:07:17 | collect | 1 | 69583 | 3 | 1.140 | 61037.7 |
403 | 2023-12-22 08:31:55 | collect | 1 | 69583 | 3 | 1.063 | 65459.1 |
402 | 2023-12-06 00:36:47 | collect | 1 | 69583 | 3 | 1.093 | 63662.4 |
401 | 2023-12-02 16:33:44 | collect | 1 | 69583 | 3 | 1.216 | 57222.9 |
400 | 2023-12-02 16:17:44 | collect | 1 | 69583 | 3 | 1.250 | 55666.4 |
399 | 2023-11-27 19:47:49 | collect | 1 | 69583 | 3 | 1.236 | 56296.9 |
398 | 2023-11-19 15:50:08 | collect | 1 | 69583 | 3 | 1.140 | 61037.7 |
397 | 2023-11-02 11:34:27 | collect | 1 | 69583 | 3 | 1.283 | 54234.6 |
396 | 2023-11-02 06:11:04 | collect | 2 | 107671 | 19 | 3.406 | 31612.2 |
395 | 2023-11-02 06:08:46 | collect | 1 | 69583 | 3 | 1.313 | 52995.4 |
394 | 2023-10-23 18:28:41 | collect | 3 | 134027 | 253 | 9.016 | 14865.5 |
393 | 2023-10-20 03:42:45 | collect | 2 | 107671 | 19 | 3.170 | 33965.6 |
392 | 2023-10-16 23:02:18 | collect | 3 | 134027 | 253 | 5.936 | 22578.7 |
391 | 2023-10-16 03:10:13 | collect | 1 | 69583 | 3 | 1.156 | 60192.9 |
390 | 2023-10-08 19:58:54 | collect | 1 | 69583 | 3 | 1.236 | 56296.9 |
389 | 2023-09-29 08:53:31 | collect | 1 | 69583 | 3 | 1.216 | 57222.9 |
388 | 2023-08-13 15:39:50 | collect | 1 | 69583 | 3 | 1.173 | 59320.5 |
387 | 2023-08-05 20:56:28 | collect | 1 | 69583 | 3 | 1.076 | 64668.2 |
386 | 2023-07-30 19:40:46 | collect | 2 | 107671 | 19 | 2.830 | 38046.3 |
385 | 2023-07-27 19:05:47 | collect | 3 | 134027 | 253 | 6.013 | 22289.5 |
384 | 2023-05-06 09:27:29 | collect | 1 | 69583 | 3 | 1.106 | 62914.1 |
383 | 2023-05-02 18:09:47 | collect | 1 | 69583 | 3 | 1.080 | 64428.7 |
382 | 2023-04-09 15:09:19 | collect | 3 | 134027 | 253 | 5.716 | 23447.7 |
381 | 2023-04-06 22:40:11 | collect | 2 | 107671 | 19 | 3.000 | 35890.3 |
380 | 2023-02-24 02:31:45 | collect | 1 | 69583 | 3 | 1.080 | 64428.7 |
379 | 2023-01-24 01:42:41 | collect | 1 | 69583 | 3 | 1.203 | 57841.2 |
378 | 2023-01-15 14:42:33 | collect | 3 | 134027 | 253 | 5.766 | 23244.4 |
377 | 2023-01-04 21:44:23 | collect | 2 | 107671 | 19 | 2.906 | 37051.3 |
376 | 2022-12-23 17:18:04 | collect | 1 | 69583 | 3 | 1.076 | 64668.2 |
375 | 2022-10-28 02:30:26 | collect | 3 | 134027 | 253 | 5.766 | 23244.4 |
374 | 2022-10-09 17:13:24 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
373 | 2022-09-19 00:50:02 | collect | 1 | 69583 | 3 | 1.093 | 63662.4 |
372 | 2022-09-08 16:06:13 | collect | 2 | 107671 | 19 | 2.843 | 37872.3 |
371 | 2022-09-06 11:13:44 | collect | 1 | 69583 | 3 | 1.153 | 60349.5 |
370 | 2022-08-23 14:52:36 | collect | 1 | 69583 | 3 | 1.093 | 63662.4 |
369 | 2022-07-28 19:24:23 | collect | 1 | 69583 | 3 | 1.236 | 56296.9 |
368 | 2022-07-10 07:28:04 | collect | 1 | 69583 | 3 | 1.093 | 63662.4 |
367 | 2022-07-02 17:42:33 | collect | 1 | 69583 | 3 | 2.453 | 28366.5 |
366 | 2022-06-26 21:26:41 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
365 | 2022-06-15 21:23:40 | collect | 1 | 69583 | 3 | 1.156 | 60192.9 |
364 | 2022-05-26 08:21:41 | collect | 3 | 134027 | 253 | 5.923 | 22628.2 |
363 | 2022-04-21 21:38:27 | collect | 1 | 69583 | 3 | 1.280 | 54361.7 |
362 | 2022-03-10 12:19:29 | collect | 1 | 69583 | 3 | 1.156 | 60192.9 |
361 | 2022-01-21 06:22:34 | collect | 3 | 134027 | 253 | 7.046 | 19021.7 |
360 | 2022-01-13 07:12:05 | collect | 1 | 69583 | 3 | 1.250 | 55666.4 |
359 | 2022-01-11 04:26:39 | collect | 1 | 69583 | 3 | 1.343 | 51811.6 |
358 | 2021-11-26 18:50:08 | collect | 1 | 69583 | 3 | 1.373 | 50679.5 |
357 | 2021-11-11 07:54:12 | collect | 1 | 69583 | 3 | 1.236 | 56296.9 |
356 | 2021-10-31 05:49:25 | collect | 1 | 69583 | 3 | 1.173 | 59320.5 |
355 | 2021-10-23 06:12:56 | collect | 3 | 134027 | 253 | 7.080 | 18930.4 |
354 | 2021-10-03 05:47:56 | collect | 1 | 69583 | 3 | 1.080 | 64428.7 |
353 | 2021-09-13 23:27:34 | collect | 1 | 69583 | 3 | 1.220 | 57035.2 |
352 | 2021-09-11 20:33:41 | collect | 1 | 69583 | 3 | 1.266 | 54962.9 |
351 | 2021-08-20 11:46:12 | collect | 1 | 69583 | 3 | 1.093 | 63662.4 |
350 | 2021-06-12 14:41:15 | collect | 2 | 107671 | 19 | 2.893 | 37217.8 |
349 | 2021-06-05 06:42:55 | collect | 1 | 69583 | 3 | 1.313 | 52995.4 |
348 | 2021-05-19 20:34:46 | collect | 1 | 69583 | 3 | 1.313 | 52995.4 |
347 | 2021-05-11 05:49:28 | collect | 1 | 69583 | 3 | 1.186 | 58670.3 |
346 | 2021-04-09 22:03:03 | collect | 1 | 69583 | 3 | 2.533 | 27470.6 |
345 | 2021-03-22 02:41:28 | collect | 2 | 107671 | 19 | 3.546 | 30364.1 |
344 | 2021-02-24 14:36:44 | collect | 2 | 107671 | 19 | 2.830 | 38046.3 |
343 | 2021-02-17 04:13:50 | collect | 3 | 134027 | 253 | 5.906 | 22693.4 |
342 | 2021-02-17 00:03:35 | collect | 1 | 69583 | 3 | 1.220 | 57035.2 |
341 | 2021-02-09 10:42:46 | collect | 1 | 69583 | 3 | 1.123 | 61961.7 |
340 | 2021-02-09 10:25:53 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
339 | 2021-02-09 10:09:50 | collect | 1 | 69583 | 3 | 1.216 | 57222.9 |
338 | 2021-02-09 09:53:49 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
337 | 2021-01-24 11:36:21 | collect | 1 | 69583 | 3 | 1.106 | 62914.1 |
336 | 2020-12-26 05:55:26 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
335 | 2020-12-26 01:56:24 | collect | 3 | 134027 | 253 | 7.406 | 18097.1 |
334 | 2020-11-12 11:21:48 | collect | 1 | 69583 | 3 | 1.156 | 60192.9 |
333 | 2020-11-07 16:52:41 | collect | 1 | 69583 | 3 | 1.126 | 61796.6 |
332 | 2020-11-01 12:39:29 | collect | 3 | 134027 | 253 | 6.920 | 19368.1 |
331 | 2020-10-30 17:53:16 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
330 | 2020-09-18 17:08:24 | collect | 1 | 69583 | 3 | 1.216 | 57222.9 |
329 | 2020-08-28 19:32:47 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
328 | 2020-08-27 23:49:20 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
327 | 2020-08-08 14:53:51 | collect | 1 | 69583 | 3 | 1.720 | 40455.2 |
326 | 2020-08-02 22:09:40 | collect | 1 | 69583 | 3 | 1.203 | 57841.2 |
325 | 2020-07-29 08:23:42 | collect | 1 | 69583 | 3 | 1.203 | 57841.2 |
324 | 2020-05-04 15:00:07 | collect | 1 | 69583 | 3 | 1.123 | 61961.7 |
323 | 2020-04-26 23:05:55 | collect | 1 | 69583 | 3 | 1.123 | 61961.7 |
322 | 2020-03-29 23:56:48 | collect | 1 | 69583 | 3 | 1.110 | 62687.4 |
321 | 2020-03-26 03:32:12 | collect | 1 | 69583 | 3 | 1.313 | 52995.4 |
320 | 2020-03-24 21:28:35 | collect | 1 | 69583 | 3 | 2.516 | 27656.2 |
319 | 2020-03-21 06:55:48 | collect | 1 | 69583 | 3 | 1.313 | 52995.4 |
318 | 2020-02-28 10:15:59 | collect | 1 | 69583 | 3 | 1.423 | 48898.8 |
317 | 2020-02-27 05:44:11 | collect | 1 | 69583 | 3 | 2.360 | 29484.3 |
316 | 2020-02-25 19:45:46 | collect | 3 | 134027 | 253 | 12.076 | 11098.6 |
315 | 2020-02-25 09:55:51 | collect | 3 | 134027 | 253 | 6.563 | 20421.6 |
314 | 2020-02-24 17:11:45 | collect | 3 | 134027 | 253 | 7.360 | 18210.2 |
313 | 2020-02-23 14:14:54 | collect | 1 | 69583 | 3 | 1.406 | 49490.0 |
312 | 2020-02-22 10:06:31 | collect | 1 | 69583 | 3 | 1.283 | 54234.6 |
311 | 2020-02-19 11:00:06 | collect | 3 | 134027 | 253 | 8.376 | 16001.3 |
310 | 2020-02-14 13:19:17 | collect | 3 | 134027 | 253 | 7.186 | 18651.1 |