History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pecs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
706 | 2024-04-28 16:14:17 | pecs | 1 | 13983 | 21 | 0.263 | 53167.3 |
705 | 2024-04-28 00:51:10 | pecs | 2 | 29872 | 369 | 2.690 | 11104.8 |
704 | 2024-04-27 17:54:37 | pecs | 1 | 13983 | 21 | 0.266 | 52567.7 |
703 | 2024-04-03 01:41:30 | pecs | 2 | 29872 | 369 | 2.126 | 14050.8 |
702 | 2024-04-03 00:42:04 | pecs | 1 | 13983 | 21 | 0.846 | 16528.4 |
701 | 2024-04-01 17:32:57 | pecs | 2 | 29872 | 369 | 2.080 | 14361.5 |
700 | 2024-04-01 16:27:24 | pecs | 1 | 13983 | 21 | 1.106 | 12642.9 |
699 | 2024-03-31 00:31:46 | pecs | 1 | 13983 | 21 | 0.546 | 25609.9 |
698 | 2024-03-28 19:03:32 | pecs | 2 | 29872 | 369 | 2.046 | 14600.2 |
697 | 2024-03-28 18:01:36 | pecs | 1 | 13983 | 21 | 0.610 | 22923.0 |
696 | 2024-03-03 20:28:00 | pecs | 1 | 13983 | 21 | 0.296 | 47239.9 |
695 | 2024-03-02 15:42:18 | pecs | 2 | 29872 | 369 | 2.190 | 13640.2 |
694 | 2024-03-02 14:57:33 | pecs | 2 | 29872 | 369 | 1.986 | 15041.3 |
693 | 2024-03-02 13:27:14 | pecs | 1 | 13983 | 21 | 0.813 | 17199.3 |
692 | 2024-02-26 07:40:00 | pecs | 2 | 29872 | 369 | 0.953 | 31345.2 |
691 | 2024-02-26 07:39:52 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
690 | 2024-02-21 04:17:23 | pecs | 1 | 13983 | 21 | 0.546 | 25609.9 |
689 | 2024-02-02 16:54:03 | pecs | 1 | 13983 | 21 | 0.203 | 68881.8 |
688 | 2024-01-27 07:14:37 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
687 | 2024-01-22 22:27:51 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
686 | 2024-01-19 09:31:35 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
685 | 2024-01-15 21:29:06 | pecs | 1 | 13983 | 21 | 0.266 | 52567.7 |
684 | 2024-01-13 22:44:52 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
683 | 2023-12-29 04:43:27 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
682 | 2023-12-11 22:49:40 | pecs | 2 | 29872 | 369 | 0.906 | 32971.3 |
681 | 2023-12-05 13:07:28 | pecs | 2 | 29872 | 369 | 0.766 | 38997.4 |
680 | 2023-11-22 00:28:10 | pecs | 2 | 29872 | 369 | 0.750 | 39829.3 |
679 | 2023-11-21 00:26:10 | pecs | 1 | 13983 | 21 | 0.216 | 64736.1 |
678 | 2023-11-11 20:01:33 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
677 | 2023-11-09 09:49:30 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
676 | 2023-11-09 02:57:23 | pecs | 1 | 13983 | 21 | 0.200 | 69915.0 |
675 | 2023-10-29 06:18:13 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
674 | 2023-10-28 01:36:52 | pecs | 2 | 29872 | 369 | 0.780 | 38297.4 |
673 | 2023-10-24 18:44:53 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
672 | 2023-10-20 23:38:45 | pecs | 2 | 29872 | 369 | 0.890 | 33564.0 |
671 | 2023-10-19 15:11:01 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
670 | 2023-10-18 05:55:36 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
669 | 2023-10-14 06:08:08 | pecs | 1 | 13983 | 21 | 0.296 | 47239.9 |
668 | 2023-10-04 01:58:01 | pecs | 1 | 13983 | 21 | 0.530 | 26383.0 |
667 | 2023-09-23 22:18:54 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
666 | 2023-09-22 13:48:27 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
665 | 2023-09-19 06:37:11 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
664 | 2023-09-15 22:25:26 | pecs | 1 | 13983 | 21 | 0.500 | 27966.0 |
663 | 2023-08-30 03:11:43 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
662 | 2023-08-17 16:01:56 | pecs | 2 | 29872 | 369 | 0.750 | 39829.3 |
661 | 2023-08-13 13:25:17 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
660 | 2023-08-11 20:13:14 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
659 | 2023-08-10 07:30:18 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
658 | 2023-08-08 19:05:40 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
657 | 2023-08-07 00:09:04 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
656 | 2023-07-12 17:51:07 | pecs | 2 | 29872 | 369 | 0.766 | 38997.4 |
655 | 2023-07-09 07:09:07 | pecs | 2 | 29872 | 369 | 0.750 | 39829.3 |
654 | 2023-07-09 00:45:29 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
653 | 2023-06-05 17:53:17 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
652 | 2023-06-03 02:19:53 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
651 | 2023-06-01 17:47:19 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
650 | 2023-05-26 14:15:54 | pecs | 1 | 13983 | 21 | 0.203 | 68881.8 |
649 | 2023-03-27 07:44:31 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
648 | 2023-02-06 15:00:41 | pecs | 1 | 13983 | 21 | 0.203 | 68881.8 |
647 | 2023-01-23 03:35:31 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
646 | 2023-01-12 04:56:26 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
645 | 2022-12-08 23:23:43 | pecs | 1 | 13983 | 21 | 0.200 | 69915.0 |
644 | 2022-11-27 07:22:24 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
643 | 2022-11-18 14:55:04 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
642 | 2022-11-09 01:49:44 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
641 | 2022-10-20 22:10:04 | pecs | 1 | 13983 | 21 | 0.203 | 68881.8 |
640 | 2022-10-16 14:19:58 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
639 | 2022-08-07 03:54:00 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
638 | 2022-07-18 06:43:10 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
637 | 2022-07-10 09:24:59 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
636 | 2022-07-04 03:19:05 | pecs | 1 | 13983 | 21 | 0.216 | 64736.1 |
635 | 2022-06-25 14:30:59 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
634 | 2022-06-22 12:12:55 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
633 | 2022-06-12 08:31:07 | pecs | 1 | 13983 | 21 | 0.266 | 52567.7 |
632 | 2022-06-01 18:44:12 | pecs | 1 | 13983 | 21 | 0.263 | 53167.3 |
631 | 2022-03-29 00:22:47 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
630 | 2022-03-06 14:59:29 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
629 | 2022-02-25 20:55:51 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
628 | 2022-02-19 22:56:00 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
627 | 2022-02-17 18:14:24 | pecs | 1 | 13983 | 21 | 0.236 | 59250.0 |
626 | 2022-01-28 15:47:00 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
625 | 2022-01-27 10:49:30 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
624 | 2022-01-26 14:22:04 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
623 | 2022-01-25 15:27:19 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
622 | 2022-01-24 16:46:58 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
621 | 2021-12-19 16:24:52 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
620 | 2021-12-13 08:04:16 | pecs | 1 | 13983 | 21 | 0.203 | 68881.8 |
619 | 2021-11-22 23:06:49 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
618 | 2021-11-15 18:38:34 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
617 | 2021-11-14 17:35:04 | pecs | 1 | 13983 | 21 | 0.233 | 60012.9 |
616 | 2021-11-14 14:08:15 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
615 | 2021-11-13 19:28:02 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |
614 | 2021-11-12 21:43:25 | pecs | 1 | 13983 | 21 | 0.516 | 27098.8 |
613 | 2021-11-11 14:29:45 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
612 | 2021-11-01 18:38:52 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
611 | 2021-10-30 21:37:38 | pecs | 1 | 13983 | 21 | 0.266 | 52567.7 |
610 | 2021-10-30 16:10:10 | pecs | 1 | 13983 | 21 | 0.250 | 55932.0 |
609 | 2021-10-29 20:18:44 | pecs | 1 | 13983 | 21 | 0.216 | 64736.1 |
608 | 2021-10-24 15:30:19 | pecs | 1 | 13983 | 21 | 0.266 | 52567.7 |
607 | 2021-10-22 14:44:41 | pecs | 1 | 13983 | 21 | 0.220 | 63559.1 |