History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collects"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
438 | 2024-05-09 21:34:48 | collects | 2 | 121059 | 18 | 8.283 | 14615.4 |
437 | 2024-05-09 21:34:43 | collects | 3 | 146162 | 188 | 10.000 | 14616.2 |
436 | 2024-05-08 02:20:05 | collects | 3 | 146162 | 188 | 21.486 | 6802.7 |
435 | 2024-05-08 02:20:07 | collects | 2 | 121059 | 18 | 8.330 | 14532.9 |
434 | 2024-05-06 23:00:56 | collects | 2 | 121059 | 18 | 4.110 | 29454.7 |
433 | 2024-05-06 23:00:40 | collects | 3 | 146162 | 188 | 8.580 | 17035.2 |
432 | 2024-05-06 23:00:32 | collects | 1 | 82945 | 3 | 3.126 | 26533.9 |
431 | 2024-05-06 23:00:19 | collects | 3 | 146162 | 188 | 8.110 | 18022.4 |
430 | 2024-05-04 16:18:44 | collects | 3 | 146162 | 188 | 7.923 | 18447.8 |
429 | 2024-05-02 02:14:58 | collects | 1 | 82945 | 3 | 3.186 | 26034.2 |
428 | 2024-04-30 03:01:56 | collects | 1 | 82945 | 3 | 5.470 | 15163.6 |
427 | 2024-04-19 05:26:01 | collects | 1 | 82945 | 3 | 1.546 | 53651.4 |
426 | 2024-04-11 03:46:36 | collects | 3 | 146162 | 188 | 7.656 | 19091.2 |
425 | 2024-04-09 11:32:07 | collects | 2 | 121059 | 18 | 11.360 | 10656.6 |
424 | 2024-04-09 10:13:46 | collects | 1 | 82945 | 3 | 1.326 | 62552.8 |
423 | 2024-04-08 03:50:37 | collects | 2 | 121059 | 18 | 3.983 | 30393.9 |
422 | 2024-04-08 03:47:53 | collects | 3 | 146162 | 188 | 6.983 | 20931.1 |
421 | 2024-04-07 20:36:45 | collects | 3 | 146162 | 188 | 16.783 | 8708.9 |
420 | 2024-04-07 05:06:10 | collects | 3 | 146162 | 188 | 32.456 | 4503.4 |
419 | 2024-04-07 05:06:14 | collects | 2 | 121059 | 18 | 12.080 | 10021.4 |
418 | 2024-04-06 17:27:47 | collects | 2 | 121059 | 18 | 7.826 | 15468.8 |
417 | 2024-04-06 17:27:45 | collects | 3 | 146162 | 188 | 8.000 | 18270.3 |
416 | 2024-04-06 17:27:42 | collects | 1 | 82945 | 3 | 1.546 | 53651.4 |
415 | 2024-04-06 17:27:30 | collects | 3 | 146162 | 188 | 8.966 | 16301.8 |
414 | 2024-04-06 17:27:32 | collects | 2 | 121059 | 18 | 4.750 | 25486.1 |
413 | 2024-04-06 17:27:26 | collects | 1 | 82945 | 3 | 3.250 | 25521.5 |
412 | 2024-04-02 19:55:11 | collects | 1 | 82945 | 3 | 3.483 | 23814.2 |
411 | 2024-03-31 00:09:29 | collects | 1 | 82945 | 3 | 5.000 | 16589.0 |
410 | 2024-03-07 13:43:41 | collects | 1 | 82945 | 3 | 1.423 | 58288.8 |
409 | 2024-03-06 01:21:15 | collects | 1 | 82945 | 3 | 3.376 | 24569.0 |
408 | 2024-03-04 07:20:45 | collects | 2 | 121059 | 18 | 9.360 | 12933.7 |
407 | 2024-03-03 17:07:40 | collects | 2 | 121059 | 18 | 3.843 | 31501.2 |
406 | 2024-03-01 17:08:13 | collects | 3 | 146162 | 188 | 10.546 | 13859.5 |
405 | 2024-02-29 22:57:28 | collects | 2 | 121059 | 18 | 4.033 | 30017.1 |
404 | 2024-02-29 22:56:52 | collects | 3 | 146162 | 188 | 7.736 | 18893.7 |
403 | 2024-02-29 12:38:36 | collects | 3 | 146162 | 188 | 8.296 | 17618.4 |
402 | 2024-02-29 12:38:31 | collects | 2 | 121059 | 18 | 4.033 | 30017.1 |
401 | 2024-01-30 20:43:00 | collects | 1 | 82945 | 3 | 3.093 | 26817.0 |
400 | 2024-01-26 05:17:23 | collects | 3 | 146162 | 188 | 15.486 | 9438.3 |
399 | 2024-01-11 04:10:41 | collects | 1 | 82945 | 3 | 1.360 | 60989.0 |
398 | 2024-01-04 11:45:36 | collects | 3 | 146162 | 188 | 6.500 | 22486.5 |
397 | 2024-01-04 11:45:34 | collects | 2 | 121059 | 18 | 3.563 | 33976.7 |
396 | 2024-01-03 12:48:10 | collects | 1 | 82945 | 3 | 1.346 | 61623.3 |
395 | 2023-12-25 01:44:12 | collects | 3 | 146162 | 188 | 6.626 | 22058.9 |
394 | 2023-12-06 02:45:39 | collects | 1 | 82945 | 3 | 1.546 | 53651.4 |
393 | 2023-12-03 00:22:58 | collects | 3 | 146162 | 188 | 7.250 | 20160.3 |
392 | 2023-12-03 00:23:01 | collects | 2 | 121059 | 18 | 3.733 | 32429.4 |
391 | 2023-11-18 17:10:56 | collects | 1 | 82945 | 3 | 1.470 | 56425.2 |
390 | 2023-11-14 03:50:52 | collects | 1 | 82945 | 3 | 1.296 | 64000.8 |
389 | 2023-10-25 18:10:47 | collects | 1 | 82945 | 3 | 1.313 | 63172.1 |
388 | 2023-10-22 06:33:28 | collects | 1 | 82945 | 3 | 1.470 | 56425.2 |
387 | 2023-10-19 00:59:28 | collects | 1 | 82945 | 3 | 1.390 | 59672.7 |
386 | 2023-10-13 13:54:14 | collects | 1 | 82945 | 3 | 1.533 | 54106.3 |
385 | 2023-09-29 23:53:03 | collects | 3 | 146162 | 188 | 7.860 | 18595.7 |
384 | 2023-09-29 06:06:28 | collects | 1 | 82945 | 3 | 1.283 | 64649.3 |
383 | 2023-09-24 17:39:07 | collects | 3 | 146162 | 188 | 6.940 | 21060.8 |
382 | 2023-09-15 01:24:51 | collects | 1 | 82945 | 3 | 1.470 | 56425.2 |
381 | 2023-08-19 22:31:04 | collects | 1 | 82945 | 3 | 1.296 | 64000.8 |
380 | 2023-07-04 06:48:44 | collects | 3 | 146162 | 188 | 7.390 | 19778.3 |
379 | 2023-06-01 05:48:35 | collects | 1 | 82945 | 3 | 1.313 | 63172.1 |
378 | 2023-05-22 07:30:12 | collects | 1 | 82945 | 3 | 1.300 | 63803.8 |
377 | 2023-03-25 01:26:26 | collects | 3 | 146162 | 188 | 6.563 | 22270.6 |
376 | 2023-03-20 00:39:50 | collects | 1 | 82945 | 3 | 1.310 | 63316.8 |
375 | 2023-02-16 05:33:43 | collects | 1 | 82945 | 3 | 1.470 | 56425.2 |
374 | 2023-01-05 13:39:29 | collects | 1 | 82945 | 3 | 1.280 | 64800.8 |
373 | 2022-12-23 16:45:04 | collects | 3 | 146162 | 188 | 6.186 | 23627.9 |
372 | 2022-10-22 20:08:23 | collects | 1 | 82945 | 3 | 1.296 | 64000.8 |
371 | 2022-10-02 16:31:01 | collects | 1 | 82945 | 3 | 1.313 | 63172.1 |
370 | 2022-08-23 20:08:31 | collects | 3 | 146162 | 188 | 7.186 | 20339.8 |
369 | 2022-07-14 02:02:29 | collects | 2 | 121059 | 18 | 3.216 | 37642.7 |
368 | 2022-07-02 23:16:22 | collects | 1 | 82945 | 3 | 1.280 | 64800.8 |
367 | 2022-05-16 15:22:36 | collects | 1 | 82945 | 3 | 1.560 | 53169.9 |
366 | 2022-05-14 10:38:53 | collects | 1 | 82945 | 3 | 1.313 | 63172.1 |
365 | 2022-03-19 07:10:58 | collects | 1 | 82945 | 3 | 1.390 | 59672.7 |
364 | 2022-01-29 02:44:30 | collects | 1 | 82945 | 3 | 1.296 | 64000.8 |
363 | 2022-01-26 20:27:57 | collects | 1 | 82945 | 3 | 1.440 | 57600.7 |
362 | 2021-12-05 12:37:40 | collects | 1 | 82945 | 3 | 1.563 | 53067.8 |
361 | 2021-11-18 02:50:40 | collects | 1 | 82945 | 3 | 2.686 | 30880.5 |
360 | 2021-10-05 22:21:27 | collects | 1 | 82945 | 3 | 1.423 | 58288.8 |
359 | 2021-09-27 08:13:08 | collects | 1 | 82945 | 3 | 1.470 | 56425.2 |
358 | 2021-09-26 20:52:18 | collects | 1 | 82945 | 3 | 1.296 | 64000.8 |
357 | 2021-09-22 05:32:22 | collects | 1 | 82945 | 3 | 1.486 | 55817.6 |
356 | 2021-09-16 18:48:47 | collects | 1 | 82945 | 3 | 1.453 | 57085.3 |
355 | 2021-08-29 02:50:31 | collects | 1 | 82945 | 3 | 1.343 | 61761.0 |
354 | 2021-05-28 08:51:54 | collects | 1 | 82945 | 3 | 1.500 | 55296.7 |
353 | 2021-05-24 23:07:46 | collects | 1 | 82945 | 3 | 1.546 | 53651.4 |
352 | 2021-05-23 07:30:12 | collects | 1 | 82945 | 3 | 1.546 | 53651.4 |
351 | 2021-04-24 12:38:35 | collects | 1 | 82945 | 3 | 1.326 | 62552.8 |
350 | 2021-02-28 14:32:52 | collects | 1 | 82945 | 3 | 1.500 | 55296.7 |
349 | 2021-02-19 10:04:01 | collects | 1 | 82945 | 3 | 1.313 | 63172.1 |
348 | 2021-02-04 15:16:25 | collects | 1 | 82945 | 3 | 1.373 | 60411.5 |
347 | 2020-11-15 17:10:05 | collects | 1 | 82945 | 3 | 1.296 | 64000.8 |
346 | 2020-11-13 12:08:38 | collects | 1 | 82945 | 3 | 1.343 | 61761.0 |
345 | 2020-08-15 12:17:03 | collects | 1 | 82945 | 3 | 1.390 | 59672.7 |
344 | 2020-08-13 17:01:20 | collects | 1 | 82945 | 3 | 1.390 | 59672.7 |
343 | 2020-08-10 18:13:24 | collects | 1 | 82945 | 3 | 1.343 | 61761.0 |
342 | 2020-05-18 06:37:51 | collects | 1 | 82945 | 3 | 1.486 | 55817.6 |
341 | 2020-05-09 13:01:15 | collects | 1 | 82945 | 3 | 1.436 | 57761.1 |
340 | 2020-03-22 11:36:22 | collects | 1 | 82945 | 3 | 1.440 | 57600.7 |
339 | 2020-02-29 20:10:53 | collects | 1 | 82945 | 3 | 1.606 | 51646.9 |