History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"goodie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
736 | 2024-04-09 19:16:14 | goodie | 3 | 112716 | 509 | 11.610 | 9708.5 |
735 | 2024-04-09 18:20:12 | goodie | 3 | 112716 | 509 | 14.766 | 7633.5 |
734 | 2024-04-08 16:35:09 | goodie | 3 | 112716 | 509 | 16.923 | 6660.5 |
733 | 2024-04-08 15:35:35 | goodie | 3 | 112716 | 509 | 6.720 | 16773.2 |
732 | 2024-03-09 04:57:50 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
731 | 2024-02-29 12:16:40 | goodie | 2 | 82551 | 66 | 2.360 | 34979.2 |
730 | 2024-02-29 12:16:15 | goodie | 3 | 112716 | 509 | 7.796 | 14458.2 |
729 | 2024-02-28 04:08:03 | goodie | 3 | 112716 | 509 | 11.796 | 9555.4 |
728 | 2024-02-28 03:57:44 | goodie | 3 | 112716 | 509 | 12.063 | 9343.9 |
727 | 2024-02-28 03:57:45 | goodie | 2 | 82551 | 66 | 5.546 | 14884.8 |
726 | 2024-02-28 03:57:37 | goodie | 1 | 48755 | 6 | 0.876 | 55656.4 |
725 | 2024-02-07 10:58:24 | goodie | 1 | 48755 | 6 | 0.873 | 55847.7 |
724 | 2024-01-21 08:34:36 | goodie | 2 | 82551 | 66 | 2.110 | 39123.7 |
723 | 2024-01-18 23:51:30 | goodie | 3 | 112716 | 509 | 4.610 | 24450.3 |
722 | 2023-12-31 10:25:47 | goodie | 2 | 82551 | 66 | 2.610 | 31628.7 |
721 | 2023-12-28 21:24:54 | goodie | 3 | 112716 | 509 | 5.313 | 21215.1 |
720 | 2023-12-09 16:02:03 | goodie | 1 | 48755 | 6 | 0.736 | 66243.2 |
719 | 2023-12-09 01:45:45 | goodie | 3 | 112716 | 509 | 4.560 | 24718.4 |
718 | 2023-11-28 18:56:00 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
717 | 2023-11-24 08:22:47 | goodie | 3 | 112716 | 509 | 4.593 | 24540.8 |
716 | 2023-11-24 08:22:44 | goodie | 2 | 82551 | 66 | 2.190 | 37694.5 |
715 | 2023-11-17 13:43:30 | goodie | 1 | 48755 | 6 | 0.780 | 62506.4 |
714 | 2023-11-13 10:24:04 | goodie | 1 | 48755 | 6 | 0.843 | 57835.1 |
713 | 2023-11-07 09:27:36 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
712 | 2023-11-03 18:21:39 | goodie | 1 | 48755 | 6 | 0.813 | 59969.2 |
711 | 2023-10-21 21:58:37 | goodie | 1 | 48755 | 6 | 0.733 | 66514.3 |
710 | 2023-10-18 17:42:47 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
709 | 2023-10-13 16:35:57 | goodie | 1 | 48755 | 6 | 0.826 | 59025.4 |
708 | 2023-10-08 20:24:11 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
707 | 2023-09-26 09:15:52 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
706 | 2023-09-13 02:03:03 | goodie | 1 | 48755 | 6 | 0.826 | 59025.4 |
705 | 2023-09-12 04:30:44 | goodie | 1 | 48755 | 6 | 0.736 | 66243.2 |
704 | 2023-09-11 11:25:07 | goodie | 3 | 112716 | 509 | 6.216 | 18133.2 |
703 | 2023-09-07 23:01:29 | goodie | 3 | 112716 | 509 | 4.716 | 23900.8 |
702 | 2023-08-20 09:05:04 | goodie | 1 | 48755 | 6 | 0.813 | 59969.2 |
701 | 2023-07-17 08:27:50 | goodie | 1 | 48755 | 6 | 0.733 | 66514.3 |
700 | 2023-06-29 06:37:00 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
699 | 2023-05-28 00:32:07 | goodie | 3 | 112716 | 509 | 4.483 | 25143.0 |
698 | 2023-05-09 23:30:13 | goodie | 1 | 48755 | 6 | 0.716 | 68093.6 |
697 | 2023-04-25 22:53:35 | goodie | 1 | 48755 | 6 | 0.733 | 66514.3 |
696 | 2023-04-05 18:44:37 | goodie | 1 | 48755 | 6 | 0.720 | 67715.3 |
695 | 2023-03-06 07:54:03 | goodie | 3 | 112716 | 509 | 4.580 | 24610.5 |
694 | 2023-01-31 06:41:45 | goodie | 1 | 48755 | 6 | 1.436 | 33951.9 |
693 | 2023-01-27 18:17:39 | goodie | 1 | 48755 | 6 | 0.826 | 59025.4 |
692 | 2023-01-19 14:57:52 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
691 | 2022-12-13 04:52:33 | goodie | 3 | 112716 | 509 | 8.956 | 12585.5 |
690 | 2022-11-17 08:17:24 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
689 | 2022-10-06 05:02:56 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
688 | 2022-08-15 00:43:59 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
687 | 2022-08-03 08:58:30 | goodie | 3 | 112716 | 509 | 4.530 | 24882.1 |
686 | 2022-07-29 08:50:54 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
685 | 2022-07-09 11:51:52 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
684 | 2022-06-23 04:17:08 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
683 | 2022-05-16 02:07:02 | goodie | 1 | 48755 | 6 | 0.733 | 66514.3 |
682 | 2022-03-09 20:54:03 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
681 | 2022-03-07 18:22:25 | goodie | 1 | 48755 | 6 | 0.796 | 61250.0 |
680 | 2022-03-07 05:23:41 | goodie | 1 | 48755 | 6 | 0.826 | 59025.4 |
679 | 2021-12-22 09:23:10 | goodie | 1 | 48755 | 6 | 0.856 | 56956.8 |
678 | 2021-11-24 18:33:05 | goodie | 1 | 48755 | 6 | 0.810 | 60191.4 |
677 | 2021-11-23 13:47:42 | goodie | 1 | 48755 | 6 | 0.876 | 55656.4 |
676 | 2021-10-27 07:31:47 | goodie | 1 | 48755 | 6 | 0.716 | 68093.6 |
675 | 2021-09-17 16:10:17 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
674 | 2021-09-15 12:05:47 | goodie | 1 | 48755 | 6 | 0.780 | 62506.4 |
673 | 2021-08-26 18:13:54 | goodie | 1 | 48755 | 6 | 0.923 | 52822.3 |
672 | 2021-08-20 13:25:38 | goodie | 1 | 48755 | 6 | 0.813 | 59969.2 |
671 | 2021-07-19 23:37:21 | goodie | 1 | 48755 | 6 | 0.733 | 66514.3 |
670 | 2021-05-19 22:26:41 | goodie | 1 | 48755 | 6 | 0.890 | 54780.9 |
669 | 2021-05-09 06:07:38 | goodie | 1 | 48755 | 6 | 0.800 | 60943.8 |
668 | 2021-04-07 19:42:44 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
667 | 2021-02-22 00:56:55 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
666 | 2021-02-17 02:33:19 | goodie | 1 | 48755 | 6 | 0.826 | 59025.4 |
665 | 2021-02-15 13:24:43 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
664 | 2021-02-09 12:27:08 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
663 | 2021-01-11 22:00:41 | goodie | 1 | 48755 | 6 | 0.813 | 59969.2 |
662 | 2020-11-07 19:37:36 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
661 | 2020-10-17 13:13:35 | goodie | 1 | 48755 | 6 | 0.830 | 58741.0 |
660 | 2020-10-15 20:56:40 | goodie | 1 | 48755 | 6 | 1.716 | 28412.0 |
659 | 2020-08-31 16:59:33 | goodie | 1 | 48755 | 6 | 0.810 | 60191.4 |
658 | 2020-08-28 00:10:56 | goodie | 1 | 48755 | 6 | 0.763 | 63899.1 |
657 | 2020-08-16 18:51:19 | goodie | 1 | 48755 | 6 | 0.763 | 63899.1 |
656 | 2020-08-02 23:44:03 | goodie | 1 | 48755 | 6 | 0.766 | 63648.8 |
655 | 2020-05-04 16:32:04 | goodie | 1 | 48755 | 6 | 0.780 | 62506.4 |
654 | 2020-03-30 03:42:05 | goodie | 1 | 48755 | 6 | 0.893 | 54596.9 |
653 | 2020-03-28 00:56:59 | goodie | 1 | 48755 | 6 | 0.843 | 57835.1 |
652 | 2020-03-24 20:26:16 | goodie | 1 | 48755 | 6 | 1.436 | 33951.9 |
651 | 2020-03-23 16:40:52 | goodie | 1 | 48755 | 6 | 0.733 | 66514.3 |
650 | 2020-03-22 19:57:38 | goodie | 1 | 48755 | 6 | 0.843 | 57835.1 |
649 | 2020-03-22 17:46:32 | goodie | 1 | 48755 | 6 | 0.750 | 65006.7 |
648 | 2020-03-19 22:59:26 | goodie | 1 | 48755 | 6 | 0.860 | 56691.9 |
647 | 2020-02-26 22:43:40 | goodie | 1 | 48755 | 6 | 1.923 | 25353.6 |
646 | 2020-02-22 21:17:35 | goodie | 1 | 48755 | 6 | 1.766 | 27607.6 |
645 | 2020-02-19 13:52:19 | goodie | 1 | 48755 | 6 | 1.013 | 48129.3 |
644 | 2020-02-07 03:30:21 | goodie | 3 | 112716 | 509 | 6.283 | 17939.8 |
643 | 2020-02-07 00:46:21 | goodie | 3 | 112716 | 509 | 6.296 | 17902.8 |
642 | 2020-02-06 14:23:00 | goodie | 3 | 112716 | 509 | 4.796 | 23502.1 |
641 | 2020-02-05 23:36:37 | goodie | 1 | 48755 | 6 | 0.813 | 59969.2 |
640 | 2020-02-05 21:11:39 | goodie | 1 | 48755 | 6 | 1.843 | 26454.2 |
639 | 2020-02-04 16:08:03 | goodie | 1 | 48755 | 6 | 1.670 | 29194.6 |
638 | 2020-02-04 15:25:57 | goodie | 3 | 112716 | 509 | 11.423 | 9867.5 |
637 | 2020-02-04 07:03:46 | goodie | 3 | 112716 | 509 | 12.173 | 9259.5 |