History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"keys"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
689 | 2024-04-28 18:42:55 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
688 | 2024-04-05 00:54:04 | keys | 1 | 13983 | 12 | 0.236 | 59250.0 |
687 | 2024-04-03 08:46:39 | keys | 1 | 13983 | 12 | 0.263 | 53167.3 |
686 | 2024-04-03 00:53:31 | keys | 2 | 29872 | 289 | 2.000 | 14936.0 |
685 | 2024-04-03 00:49:30 | keys | 1 | 13983 | 12 | 0.500 | 27966.0 |
684 | 2024-03-30 19:27:50 | keys | 2 | 29872 | 289 | 2.670 | 11188.0 |
683 | 2024-03-30 19:15:28 | keys | 1 | 13983 | 12 | 0.266 | 52567.7 |
682 | 2024-03-28 18:02:43 | keys | 1 | 13983 | 12 | 0.470 | 29751.1 |
681 | 2024-03-20 16:07:22 | keys | 1 | 13983 | 12 | 0.533 | 26234.5 |
680 | 2024-03-05 20:18:50 | keys | 1 | 13983 | 12 | 0.750 | 18644.0 |
679 | 2024-03-03 19:42:59 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
678 | 2024-02-27 21:29:27 | keys | 2 | 29872 | 289 | 0.920 | 32469.6 |
677 | 2024-02-26 19:13:50 | keys | 2 | 29872 | 289 | 2.030 | 14715.3 |
676 | 2024-02-26 19:09:38 | keys | 1 | 13983 | 12 | 0.500 | 27966.0 |
675 | 2024-02-21 12:37:40 | keys | 1 | 13983 | 12 | 0.516 | 27098.8 |
674 | 2024-02-03 01:37:26 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
673 | 2024-02-02 16:05:23 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
672 | 2024-01-27 18:18:45 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
671 | 2024-01-04 15:01:56 | keys | 2 | 29872 | 289 | 0.736 | 40587.0 |
670 | 2023-12-31 11:16:49 | keys | 2 | 29872 | 289 | 0.830 | 35990.4 |
669 | 2023-12-29 15:57:36 | keys | 2 | 29872 | 289 | 0.716 | 41720.7 |
668 | 2023-12-24 11:44:20 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
667 | 2023-12-16 16:48:29 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
666 | 2023-11-30 09:13:12 | keys | 2 | 29872 | 289 | 0.860 | 34734.9 |
665 | 2023-11-23 18:24:38 | keys | 2 | 29872 | 289 | 0.720 | 41488.9 |
664 | 2023-11-19 16:47:21 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
663 | 2023-11-14 08:01:39 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
662 | 2023-11-09 11:05:04 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
661 | 2023-10-30 13:09:26 | keys | 1 | 13983 | 12 | 0.483 | 28950.3 |
660 | 2023-10-22 03:03:34 | keys | 1 | 13983 | 12 | 0.236 | 59250.0 |
659 | 2023-10-17 09:22:52 | keys | 1 | 13983 | 12 | 0.236 | 59250.0 |
658 | 2023-10-14 06:09:43 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
657 | 2023-10-11 16:49:08 | keys | 2 | 29872 | 289 | 0.923 | 32364.0 |
656 | 2023-10-10 18:46:24 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
655 | 2023-10-09 21:39:35 | keys | 2 | 29872 | 289 | 0.860 | 34734.9 |
654 | 2023-10-06 09:42:30 | keys | 2 | 29872 | 289 | 0.920 | 32469.6 |
653 | 2023-10-05 04:41:38 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
652 | 2023-10-03 12:51:03 | keys | 2 | 29872 | 289 | 0.813 | 36742.9 |
651 | 2023-10-03 04:23:42 | keys | 2 | 29872 | 289 | 0.843 | 35435.3 |
650 | 2023-10-01 18:34:02 | keys | 2 | 29872 | 289 | 1.736 | 17207.4 |
649 | 2023-09-29 06:06:06 | keys | 1 | 13983 | 12 | 0.263 | 53167.3 |
648 | 2023-09-28 05:36:56 | keys | 2 | 29872 | 289 | 0.703 | 42492.2 |
647 | 2023-09-22 10:44:39 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
646 | 2023-09-06 10:57:35 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
645 | 2023-08-18 10:11:57 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
644 | 2023-08-07 23:54:23 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
643 | 2023-07-20 14:53:23 | keys | 2 | 29872 | 289 | 0.800 | 37340.0 |
642 | 2023-05-30 13:02:54 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
641 | 2023-05-17 15:00:37 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
640 | 2023-04-30 23:00:52 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
639 | 2023-04-07 09:46:46 | keys | 2 | 29872 | 289 | 0.703 | 42492.2 |
638 | 2023-04-01 16:13:40 | keys | 2 | 29872 | 289 | 0.766 | 38997.4 |
637 | 2023-02-25 15:24:52 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
636 | 2023-02-24 16:09:34 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
635 | 2023-02-13 05:27:39 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
634 | 2022-12-28 20:44:25 | keys | 2 | 29872 | 289 | 0.700 | 42674.3 |
633 | 2022-11-18 12:24:56 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
632 | 2022-11-12 01:16:03 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
631 | 2022-09-19 17:08:03 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
630 | 2022-09-12 08:49:35 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
629 | 2022-09-01 04:45:30 | keys | 2 | 29872 | 289 | 1.610 | 18554.0 |
628 | 2022-08-29 13:57:54 | keys | 2 | 29872 | 289 | 0.750 | 39829.3 |
627 | 2022-08-27 04:06:53 | keys | 2 | 29872 | 289 | 0.666 | 44852.9 |
626 | 2022-08-18 01:18:10 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
625 | 2022-08-15 10:08:51 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
624 | 2022-08-14 17:51:28 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
623 | 2022-08-14 02:57:55 | keys | 1 | 13983 | 12 | 0.236 | 59250.0 |
622 | 2022-08-07 20:17:03 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
621 | 2022-07-29 02:04:40 | keys | 1 | 13983 | 12 | 0.236 | 59250.0 |
620 | 2022-07-07 10:32:29 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
619 | 2022-07-05 06:29:41 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
618 | 2022-07-02 23:51:45 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
617 | 2022-05-15 23:02:52 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
616 | 2022-05-04 00:52:27 | keys | 1 | 13983 | 12 | 0.313 | 44674.1 |
615 | 2022-03-26 12:47:20 | keys | 2 | 29872 | 289 | 0.826 | 36164.6 |
614 | 2022-03-01 10:21:54 | keys | 1 | 13983 | 12 | 0.360 | 38841.7 |
613 | 2022-02-25 02:39:10 | keys | 1 | 13983 | 12 | 0.373 | 37487.9 |
612 | 2022-02-11 05:45:47 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
611 | 2022-01-30 16:01:47 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
610 | 2021-12-29 05:16:06 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
609 | 2021-12-10 20:43:37 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
608 | 2021-11-21 18:57:51 | keys | 1 | 13983 | 12 | 0.263 | 53167.3 |
607 | 2021-11-10 05:55:09 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
606 | 2021-10-30 12:52:15 | keys | 1 | 13983 | 12 | 0.296 | 47239.9 |
605 | 2021-10-29 11:32:09 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
604 | 2021-10-29 06:47:53 | keys | 1 | 13983 | 12 | 0.250 | 55932.0 |
603 | 2021-10-27 20:01:33 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
602 | 2021-10-09 00:28:07 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
601 | 2021-10-06 21:52:51 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
600 | 2021-09-21 17:09:58 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
599 | 2021-09-20 09:26:34 | keys | 1 | 13983 | 12 | 0.486 | 28771.6 |
598 | 2021-09-14 01:32:02 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
597 | 2021-09-04 18:57:49 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |
596 | 2021-08-18 04:57:02 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
595 | 2021-08-07 16:06:29 | keys | 1 | 13983 | 12 | 0.236 | 59250.0 |
594 | 2021-08-07 06:07:33 | keys | 1 | 13983 | 12 | 0.216 | 64736.1 |
593 | 2021-07-26 00:08:42 | keys | 1 | 13983 | 12 | 0.203 | 68881.8 |
592 | 2021-05-31 12:07:22 | keys | 1 | 13983 | 12 | 0.233 | 60012.9 |
591 | 2021-05-26 22:41:51 | keys | 2 | 29872 | 289 | 0.830 | 35990.4 |
590 | 2021-05-06 09:54:01 | keys | 1 | 13983 | 12 | 0.220 | 63559.1 |