History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pickles"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
717 | 2024-05-11 18:44:43 | pickles | 1 | 69583 | 8 | 2.203 | 31585.6 |
716 | 2024-05-09 03:34:06 | pickles | 1 | 69583 | 8 | 2.860 | 24329.7 |
715 | 2024-04-30 09:06:37 | pickles | 3 | 134027 | 608 | 23.906 | 5606.4 |
714 | 2024-04-16 10:21:49 | pickles | 3 | 134027 | 608 | 28.500 | 4702.7 |
713 | 2024-04-16 06:32:56 | pickles | 3 | 134027 | 608 | 9.780 | 13704.2 |
712 | 2024-04-13 00:02:56 | pickles | 3 | 134027 | 608 | 7.313 | 18327.2 |
711 | 2024-04-12 19:00:20 | pickles | 3 | 134027 | 608 | 7.936 | 16888.5 |
710 | 2024-03-18 08:24:39 | pickles | 3 | 134027 | 608 | 24.410 | 5490.7 |
709 | 2024-03-18 02:00:59 | pickles | 3 | 134027 | 608 | 18.233 | 7350.8 |
708 | 2024-03-15 21:13:48 | pickles | 2 | 107671 | 77 | 4.236 | 25418.1 |
707 | 2024-03-15 21:08:26 | pickles | 3 | 134027 | 608 | 8.686 | 15430.2 |
706 | 2024-03-15 12:31:29 | pickles | 2 | 107671 | 77 | 3.516 | 30623.2 |
705 | 2024-03-15 12:31:04 | pickles | 3 | 134027 | 608 | 8.143 | 16459.2 |
704 | 2024-03-14 16:17:15 | pickles | 3 | 134027 | 608 | 16.390 | 8177.4 |
703 | 2024-03-14 14:17:34 | pickles | 3 | 134027 | 608 | 16.250 | 8247.8 |
702 | 2024-02-09 21:42:04 | pickles | 2 | 107671 | 77 | 11.656 | 9237.4 |
701 | 2024-02-09 19:39:49 | pickles | 3 | 134027 | 608 | 7.250 | 18486.5 |
700 | 2024-02-01 17:17:22 | pickles | 1 | 69583 | 8 | 1.080 | 64428.7 |
699 | 2024-01-27 22:15:58 | pickles | 3 | 134027 | 608 | 6.750 | 19855.9 |
698 | 2024-01-27 16:20:11 | pickles | 2 | 107671 | 77 | 2.906 | 37051.3 |
697 | 2024-01-27 16:09:43 | pickles | 3 | 134027 | 608 | 6.530 | 20524.8 |
696 | 2024-01-15 22:43:41 | pickles | 3 | 134027 | 608 | 10.516 | 12745.1 |
695 | 2024-01-15 22:43:38 | pickles | 2 | 107671 | 77 | 3.266 | 32967.2 |
694 | 2023-12-07 15:58:15 | pickles | 1 | 69583 | 8 | 2.783 | 25002.9 |
693 | 2023-12-07 15:58:12 | pickles | 1 | 69583 | 8 | 2.593 | 26834.9 |
692 | 2023-12-04 04:30:27 | pickles | 1 | 69583 | 8 | 1.080 | 64428.7 |
691 | 2023-11-26 15:03:42 | pickles | 1 | 69583 | 8 | 1.140 | 61037.7 |
690 | 2023-11-24 14:05:38 | pickles | 2 | 107671 | 77 | 2.906 | 37051.3 |
689 | 2023-11-22 18:33:32 | pickles | 3 | 134027 | 608 | 5.843 | 22938.0 |
688 | 2023-11-20 18:46:53 | pickles | 1 | 69583 | 8 | 1.110 | 62687.4 |
687 | 2023-11-17 22:10:27 | pickles | 1 | 69583 | 8 | 1.220 | 57035.2 |
686 | 2023-11-03 10:24:26 | pickles | 1 | 69583 | 8 | 1.220 | 57035.2 |
685 | 2023-10-21 20:57:27 | pickles | 1 | 69583 | 8 | 1.203 | 57841.2 |
684 | 2023-10-18 17:16:51 | pickles | 1 | 69583 | 8 | 1.170 | 59472.6 |
683 | 2023-10-05 04:46:34 | pickles | 1 | 69583 | 8 | 1.296 | 53690.6 |
682 | 2023-09-29 18:42:52 | pickles | 1 | 69583 | 8 | 1.063 | 65459.1 |
681 | 2023-09-27 07:11:21 | pickles | 1 | 69583 | 8 | 1.283 | 54234.6 |
680 | 2023-09-12 16:43:46 | pickles | 1 | 69583 | 8 | 1.280 | 54361.7 |
679 | 2023-08-17 09:41:35 | pickles | 3 | 134027 | 608 | 6.046 | 22167.9 |
678 | 2023-07-19 02:54:32 | pickles | 1 | 69583 | 8 | 1.076 | 64668.2 |
677 | 2023-06-25 22:55:57 | pickles | 1 | 69583 | 8 | 1.186 | 58670.3 |
676 | 2023-04-11 06:05:10 | pickles | 1 | 69583 | 8 | 1.173 | 59320.5 |
675 | 2023-04-07 06:18:41 | pickles | 1 | 69583 | 8 | 1.186 | 58670.3 |
674 | 2023-01-20 09:46:55 | pickles | 1 | 69583 | 8 | 1.050 | 66269.5 |
673 | 2023-01-19 19:01:04 | pickles | 1 | 69583 | 8 | 1.063 | 65459.1 |
672 | 2023-01-02 08:46:07 | pickles | 1 | 69583 | 8 | 1.220 | 57035.2 |
671 | 2022-12-26 05:19:21 | pickles | 3 | 134027 | 608 | 6.670 | 20094.0 |
670 | 2022-12-05 18:48:22 | pickles | 1 | 69583 | 8 | 1.220 | 57035.2 |
669 | 2022-11-29 01:18:50 | pickles | 3 | 134027 | 608 | 5.643 | 23751.0 |
668 | 2022-11-16 14:00:09 | pickles | 1 | 69583 | 8 | 1.093 | 63662.4 |
667 | 2022-11-15 21:27:22 | pickles | 3 | 134027 | 608 | 5.706 | 23488.8 |
666 | 2022-11-10 06:32:12 | pickles | 1 | 69583 | 8 | 1.190 | 58473.1 |
665 | 2022-11-09 12:43:52 | pickles | 3 | 134027 | 608 | 6.423 | 20866.7 |
664 | 2022-09-28 21:37:20 | pickles | 3 | 134027 | 608 | 6.236 | 21492.5 |
663 | 2022-09-18 20:09:16 | pickles | 1 | 69583 | 8 | 1.280 | 54361.7 |
662 | 2022-09-05 00:35:35 | pickles | 3 | 134027 | 608 | 6.000 | 22337.8 |
661 | 2022-08-27 20:58:13 | pickles | 3 | 134027 | 608 | 5.670 | 23637.9 |
660 | 2022-08-27 07:31:07 | pickles | 3 | 134027 | 608 | 5.750 | 23309.0 |
659 | 2022-08-26 13:39:15 | pickles | 3 | 134027 | 608 | 6.500 | 20619.5 |
658 | 2022-08-26 00:47:21 | pickles | 3 | 134027 | 608 | 5.703 | 23501.1 |
657 | 2022-08-25 08:31:29 | pickles | 3 | 134027 | 608 | 6.033 | 22215.6 |
656 | 2022-08-24 21:15:14 | pickles | 3 | 134027 | 608 | 6.593 | 20328.7 |
655 | 2022-08-24 09:04:05 | pickles | 3 | 134027 | 608 | 5.716 | 23447.7 |
654 | 2022-08-23 16:53:33 | pickles | 3 | 134027 | 608 | 6.063 | 22105.7 |
653 | 2022-08-23 01:18:28 | pickles | 3 | 134027 | 608 | 6.186 | 21666.2 |
652 | 2022-08-22 07:36:27 | pickles | 3 | 134027 | 608 | 5.733 | 23378.2 |
651 | 2022-08-21 14:30:59 | pickles | 3 | 134027 | 608 | 6.500 | 20619.5 |
650 | 2022-08-20 22:02:15 | pickles | 3 | 134027 | 608 | 5.783 | 23176.0 |
649 | 2022-08-20 02:58:56 | pickles | 3 | 134027 | 608 | 6.486 | 20664.0 |
648 | 2022-08-19 14:00:48 | pickles | 3 | 134027 | 608 | 5.750 | 23309.0 |
647 | 2022-07-20 18:32:14 | pickles | 3 | 134027 | 608 | 5.783 | 23176.0 |
646 | 2022-07-18 20:52:57 | pickles | 1 | 69583 | 8 | 1.250 | 55666.4 |
645 | 2022-07-07 14:15:08 | pickles | 1 | 69583 | 8 | 2.503 | 27799.8 |
644 | 2022-06-09 00:33:38 | pickles | 1 | 69583 | 8 | 1.233 | 56433.9 |
643 | 2022-06-05 09:53:56 | pickles | 1 | 69583 | 8 | 1.236 | 56296.9 |
642 | 2022-03-14 15:58:55 | pickles | 1 | 69583 | 8 | 1.233 | 56433.9 |
641 | 2022-03-11 14:50:57 | pickles | 3 | 134027 | 608 | 6.750 | 19855.9 |
640 | 2022-03-09 22:58:14 | pickles | 3 | 134027 | 608 | 7.253 | 18478.8 |
639 | 2022-03-08 18:58:06 | pickles | 3 | 134027 | 608 | 5.936 | 22578.7 |
638 | 2022-03-07 22:47:12 | pickles | 3 | 134027 | 608 | 6.123 | 21889.1 |
637 | 2022-03-06 21:30:36 | pickles | 3 | 134027 | 608 | 5.906 | 22693.4 |
636 | 2022-03-05 21:20:00 | pickles | 3 | 134027 | 608 | 5.953 | 22514.2 |
635 | 2022-03-04 21:10:10 | pickles | 3 | 134027 | 608 | 6.000 | 22337.8 |
634 | 2022-03-03 14:50:17 | pickles | 3 | 134027 | 608 | 6.500 | 20619.5 |
633 | 2022-02-22 03:07:55 | pickles | 1 | 69583 | 8 | 1.143 | 60877.5 |
632 | 2022-01-13 04:40:49 | pickles | 3 | 134027 | 608 | 6.233 | 21502.8 |
631 | 2022-01-12 13:16:29 | pickles | 3 | 134027 | 608 | 7.140 | 18771.3 |
630 | 2022-01-12 00:56:14 | pickles | 3 | 134027 | 608 | 5.936 | 22578.7 |
629 | 2022-01-11 06:59:46 | pickles | 3 | 134027 | 608 | 6.673 | 20085.0 |
628 | 2022-01-10 17:59:09 | pickles | 3 | 134027 | 608 | 6.173 | 21711.8 |
627 | 2022-01-10 00:22:46 | pickles | 3 | 134027 | 608 | 6.033 | 22215.6 |
626 | 2022-01-09 16:17:07 | pickles | 3 | 134027 | 608 | 6.203 | 21606.8 |
625 | 2022-01-08 09:20:39 | pickles | 3 | 134027 | 608 | 6.170 | 21722.4 |
624 | 2022-01-07 20:53:35 | pickles | 3 | 134027 | 608 | 6.906 | 19407.3 |
623 | 2022-01-07 10:13:23 | pickles | 3 | 134027 | 608 | 6.530 | 20524.8 |
622 | 2022-01-06 17:19:05 | pickles | 3 | 134027 | 608 | 5.860 | 22871.5 |
621 | 2022-01-06 08:34:22 | pickles | 3 | 134027 | 608 | 5.970 | 22450.1 |
620 | 2022-01-05 19:03:23 | pickles | 3 | 134027 | 608 | 6.000 | 22337.8 |
619 | 2022-01-05 08:36:12 | pickles | 3 | 134027 | 608 | 12.063 | 11110.6 |
618 | 2022-01-04 16:03:23 | pickles | 3 | 134027 | 608 | 6.640 | 20184.8 |