History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pickets"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
556 | 2024-04-04 15:52:06 | pickets | 1 | 69583 | 9 | 1.420 | 49002.1 |
555 | 2024-03-28 11:27:37 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
554 | 2024-03-12 04:47:01 | pickets | 3 | 134027 | 486 | 13.500 | 9927.9 |
553 | 2024-03-10 18:01:28 | pickets | 3 | 134027 | 486 | 14.970 | 8953.0 |
552 | 2024-03-10 16:04:12 | pickets | 2 | 107671 | 72 | 7.563 | 14236.5 |
551 | 2024-03-10 16:03:27 | pickets | 3 | 134027 | 486 | 7.373 | 18178.1 |
550 | 2024-03-09 07:08:12 | pickets | 3 | 134027 | 486 | 26.266 | 5102.7 |
549 | 2024-03-09 00:19:34 | pickets | 3 | 134027 | 486 | 12.920 | 10373.6 |
548 | 2024-03-07 14:30:47 | pickets | 3 | 134027 | 486 | 7.343 | 18252.3 |
547 | 2024-03-07 14:30:43 | pickets | 2 | 107671 | 72 | 3.563 | 30219.2 |
546 | 2024-03-07 12:47:27 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
545 | 2024-01-30 01:08:46 | pickets | 1 | 69583 | 9 | 1.173 | 59320.5 |
544 | 2024-01-21 10:51:38 | pickets | 1 | 69583 | 9 | 1.126 | 61796.6 |
543 | 2023-12-27 19:52:17 | pickets | 3 | 134027 | 486 | 6.296 | 21287.6 |
542 | 2023-12-27 19:52:19 | pickets | 2 | 107671 | 72 | 3.296 | 32667.2 |
541 | 2023-12-19 07:58:52 | pickets | 1 | 69583 | 9 | 1.233 | 56433.9 |
540 | 2023-11-21 19:33:37 | pickets | 1 | 69583 | 9 | 1.110 | 62687.4 |
539 | 2023-11-17 16:58:51 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
538 | 2023-11-13 16:48:21 | pickets | 1 | 69583 | 9 | 1.046 | 66522.9 |
537 | 2023-10-20 16:49:35 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
536 | 2023-10-11 10:55:28 | pickets | 1 | 69583 | 9 | 2.393 | 29077.7 |
535 | 2023-09-04 18:49:55 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
534 | 2023-06-20 23:12:23 | pickets | 1 | 69583 | 9 | 1.123 | 61961.7 |
533 | 2023-06-17 18:44:31 | pickets | 1 | 69583 | 9 | 1.250 | 55666.4 |
532 | 2023-03-26 06:13:24 | pickets | 1 | 69583 | 9 | 1.030 | 67556.3 |
531 | 2023-03-12 03:54:56 | pickets | 1 | 69583 | 9 | 1.546 | 45008.4 |
530 | 2023-01-30 08:34:02 | pickets | 1 | 69583 | 9 | 1.283 | 54234.6 |
529 | 2023-01-09 22:14:23 | pickets | 1 | 69583 | 9 | 1.156 | 60192.9 |
528 | 2022-12-15 15:56:45 | pickets | 1 | 69583 | 9 | 1.220 | 57035.2 |
527 | 2022-11-24 01:16:40 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
526 | 2022-11-05 06:25:36 | pickets | 1 | 69583 | 9 | 1.060 | 65644.3 |
525 | 2022-10-14 23:38:14 | pickets | 1 | 69583 | 9 | 1.063 | 65459.1 |
524 | 2022-07-31 04:52:37 | pickets | 1 | 69583 | 9 | 1.156 | 60192.9 |
523 | 2022-06-06 02:44:55 | pickets | 1 | 69583 | 9 | 1.423 | 48898.8 |
522 | 2022-04-05 16:26:34 | pickets | 1 | 69583 | 9 | 1.563 | 44518.9 |
521 | 2022-02-15 22:19:23 | pickets | 1 | 69583 | 9 | 1.080 | 64428.7 |
520 | 2022-02-13 18:01:52 | pickets | 1 | 69583 | 9 | 1.283 | 54234.6 |
519 | 2021-12-24 23:22:09 | pickets | 1 | 69583 | 9 | 1.143 | 60877.5 |
518 | 2021-12-21 18:31:16 | pickets | 1 | 69583 | 9 | 2.343 | 29698.3 |
517 | 2021-11-29 00:57:19 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
516 | 2021-11-26 22:36:51 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
515 | 2021-11-13 11:14:58 | pickets | 1 | 69583 | 9 | 1.233 | 56433.9 |
514 | 2021-10-12 15:30:38 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
513 | 2021-10-10 14:11:56 | pickets | 1 | 69583 | 9 | 1.280 | 54361.7 |
512 | 2021-09-21 13:49:16 | pickets | 1 | 69583 | 9 | 1.216 | 57222.9 |
511 | 2021-09-19 10:41:47 | pickets | 1 | 69583 | 9 | 1.220 | 57035.2 |
510 | 2021-09-17 19:28:26 | pickets | 1 | 69583 | 9 | 1.173 | 59320.5 |
509 | 2021-06-17 23:11:11 | pickets | 1 | 69583 | 9 | 1.263 | 55093.4 |
508 | 2021-05-24 16:56:32 | pickets | 1 | 69583 | 9 | 1.296 | 53690.6 |
507 | 2021-04-28 01:26:04 | pickets | 1 | 69583 | 9 | 1.123 | 61961.7 |
506 | 2021-03-27 23:49:21 | pickets | 1 | 69583 | 9 | 1.236 | 56296.9 |
505 | 2021-03-18 16:45:25 | pickets | 1 | 69583 | 9 | 1.093 | 63662.4 |
504 | 2021-03-15 16:49:18 | pickets | 2 | 107671 | 72 | 3.423 | 31455.2 |
503 | 2021-02-18 18:35:39 | pickets | 2 | 107671 | 72 | 3.123 | 34476.8 |
502 | 2021-01-29 15:14:37 | pickets | 3 | 134027 | 486 | 5.873 | 22820.9 |
501 | 2021-01-23 10:01:10 | pickets | 3 | 134027 | 486 | 5.936 | 22578.7 |
500 | 2021-01-11 07:14:11 | pickets | 1 | 69583 | 9 | 1.406 | 49490.0 |
499 | 2020-12-24 22:28:24 | pickets | 3 | 134027 | 486 | 5.940 | 22563.5 |
498 | 2020-12-15 18:07:00 | pickets | 1 | 69583 | 9 | 1.140 | 61037.7 |
497 | 2020-11-08 12:14:25 | pickets | 3 | 134027 | 486 | 7.140 | 18771.3 |
496 | 2020-11-01 02:03:40 | pickets | 1 | 69583 | 9 | 1.096 | 63488.1 |
495 | 2020-09-29 10:36:50 | pickets | 1 | 69583 | 9 | 1.123 | 61961.7 |
494 | 2020-09-15 10:13:02 | pickets | 1 | 69583 | 9 | 1.063 | 65459.1 |
493 | 2020-08-03 19:51:08 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
492 | 2020-06-12 02:01:19 | pickets | 1 | 69583 | 9 | 1.296 | 53690.6 |
491 | 2020-06-09 02:22:19 | pickets | 1 | 69583 | 9 | 1.170 | 59472.6 |
490 | 2020-04-30 00:05:47 | pickets | 1 | 69583 | 9 | 1.076 | 64668.2 |
489 | 2020-03-29 01:38:56 | pickets | 1 | 69583 | 9 | 1.186 | 58670.3 |
488 | 2020-03-24 13:45:31 | pickets | 1 | 69583 | 9 | 1.220 | 57035.2 |
487 | 2020-03-23 18:08:58 | pickets | 1 | 69583 | 9 | 1.250 | 55666.4 |
486 | 2020-03-20 20:21:30 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
485 | 2020-03-01 18:44:13 | pickets | 1 | 69583 | 9 | 1.233 | 56433.9 |
484 | 2020-02-28 15:33:30 | pickets | 1 | 69583 | 9 | 2.156 | 32274.1 |
483 | 2020-02-26 20:12:44 | pickets | 1 | 69583 | 9 | 3.720 | 18705.1 |
482 | 2020-02-26 17:13:20 | pickets | 1 | 69583 | 9 | 1.296 | 53690.6 |
481 | 2020-02-25 06:19:21 | pickets | 1 | 69583 | 9 | 1.390 | 50059.7 |
480 | 2020-02-21 10:22:12 | pickets | 1 | 69583 | 9 | 1.356 | 51314.9 |
479 | 2020-02-12 18:47:47 | pickets | 3 | 134027 | 486 | 10.266 | 13055.4 |
478 | 2020-02-11 05:02:59 | pickets | 3 | 134027 | 486 | 10.346 | 12954.5 |
477 | 2020-02-11 01:29:42 | pickets | 3 | 134027 | 486 | 7.766 | 17258.2 |
476 | 2020-02-10 18:59:48 | pickets | 3 | 134027 | 486 | 7.313 | 18327.2 |
475 | 2020-02-10 18:46:19 | pickets | 3 | 134027 | 486 | 7.453 | 17983.0 |
474 | 2020-02-10 14:58:34 | pickets | 3 | 134027 | 486 | 18.906 | 7089.1 |
473 | 2020-02-09 14:31:50 | pickets | 1 | 69583 | 9 | 2.640 | 26357.2 |
472 | 2020-02-08 00:48:08 | pickets | 1 | 69583 | 9 | 2.673 | 26031.8 |
471 | 2020-02-07 18:09:08 | pickets | 1 | 69583 | 9 | 1.300 | 53525.4 |
470 | 2020-02-05 05:38:32 | pickets | 1 | 69583 | 9 | 2.596 | 26803.9 |
469 | 2020-02-03 09:18:00 | pickets | 1 | 69583 | 9 | 1.733 | 40151.8 |
468 | 2020-01-31 01:12:52 | pickets | 1 | 69583 | 9 | 1.156 | 60192.9 |
467 | 2020-01-30 04:41:26 | pickets | 1 | 69583 | 9 | 3.550 | 19600.8 |
466 | 2020-01-17 12:35:53 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
465 | 2020-01-16 10:59:08 | pickets | 1 | 69583 | 9 | 1.266 | 54962.9 |
464 | 2020-01-13 17:05:58 | pickets | 3 | 134027 | 486 | 7.423 | 18055.6 |
463 | 2020-01-13 14:10:17 | pickets | 3 | 134027 | 486 | 8.576 | 15628.1 |
462 | 2020-01-13 09:30:51 | pickets | 3 | 134027 | 486 | 6.173 | 21711.8 |
461 | 2020-01-13 04:50:06 | pickets | 1 | 69583 | 9 | 4.126 | 16864.5 |
460 | 2020-01-08 05:09:30 | pickets | 1 | 69583 | 9 | 3.373 | 20629.4 |
459 | 2020-01-05 22:34:40 | pickets | 1 | 69583 | 9 | 1.233 | 56433.9 |
458 | 2019-12-31 10:55:19 | pickets | 1 | 69583 | 9 | 1.263 | 55093.4 |
457 | 2019-12-28 02:35:55 | pickets | 1 | 69583 | 9 | 1.106 | 62914.1 |