History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gally"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
797 | 2024-04-24 02:51:07 | gally | 1 | 28756 | 17 | 1.640 | 17534.1 |
796 | 2024-04-24 02:48:05 | gally | 1 | 28756 | 17 | 1.656 | 17364.7 |
795 | 2024-04-04 23:01:23 | gally | 1 | 28756 | 17 | 0.873 | 32939.3 |
794 | 2024-04-03 04:06:07 | gally | 1 | 28756 | 17 | 1.546 | 18600.3 |
793 | 2024-03-31 18:07:11 | gally | 2 | 53800 | 177 | 6.266 | 8586.0 |
792 | 2024-03-31 10:20:35 | gally | 2 | 53800 | 177 | 5.690 | 9455.2 |
791 | 2024-03-31 08:16:38 | gally | 1 | 28756 | 17 | 0.530 | 54256.6 |
790 | 2024-03-27 01:20:51 | gally | 1 | 28756 | 17 | 0.530 | 54256.6 |
789 | 2024-03-03 21:15:24 | gally | 1 | 28756 | 17 | 0.516 | 55728.7 |
788 | 2024-03-01 02:52:20 | gally | 1 | 28756 | 17 | 0.530 | 54256.6 |
787 | 2024-02-25 17:50:59 | gally | 1 | 28756 | 17 | 0.626 | 45936.1 |
786 | 2024-02-20 10:16:00 | gally | 1 | 28756 | 17 | 1.076 | 26724.9 |
785 | 2024-01-25 21:50:41 | gally | 1 | 28756 | 17 | 0.970 | 29645.4 |
784 | 2024-01-20 03:47:28 | gally | 2 | 53800 | 177 | 1.593 | 33772.8 |
783 | 2024-01-04 19:41:11 | gally | 1 | 28756 | 17 | 0.516 | 55728.7 |
782 | 2023-12-27 16:04:34 | gally | 1 | 28756 | 17 | 0.500 | 57512.0 |
781 | 2023-12-20 00:46:31 | gally | 1 | 28756 | 17 | 0.580 | 49579.3 |
780 | 2023-12-17 23:18:03 | gally | 2 | 53800 | 177 | 1.546 | 34799.5 |
779 | 2023-12-15 13:24:38 | gally | 2 | 53800 | 177 | 1.560 | 34487.2 |
778 | 2023-11-29 19:16:32 | gally | 2 | 53800 | 177 | 1.593 | 33772.8 |
777 | 2023-11-16 09:38:35 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
776 | 2023-11-13 00:35:25 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
775 | 2023-11-12 01:26:14 | gally | 2 | 53800 | 177 | 1.606 | 33499.4 |
774 | 2023-10-31 03:07:21 | gally | 2 | 53800 | 177 | 1.390 | 38705.0 |
773 | 2023-10-27 20:00:57 | gally | 1 | 28756 | 17 | 0.440 | 65354.5 |
772 | 2023-10-26 17:01:54 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
771 | 2023-10-26 04:12:17 | gally | 1 | 28756 | 17 | 0.440 | 65354.5 |
770 | 2023-10-24 10:00:37 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
769 | 2023-10-24 05:51:09 | gally | 1 | 28756 | 17 | 0.486 | 59168.7 |
768 | 2023-10-22 15:48:31 | gally | 1 | 28756 | 17 | 0.576 | 49923.6 |
767 | 2023-10-22 02:43:17 | gally | 2 | 53800 | 177 | 1.610 | 33416.1 |
766 | 2023-10-14 12:10:40 | gally | 2 | 53800 | 177 | 2.923 | 18405.7 |
765 | 2023-10-10 19:35:33 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
764 | 2023-10-03 16:30:24 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
763 | 2023-09-23 11:07:14 | gally | 1 | 28756 | 17 | 0.486 | 59168.7 |
762 | 2023-09-22 01:58:41 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
761 | 2023-08-21 21:03:36 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
760 | 2023-08-05 20:33:01 | gally | 2 | 53800 | 177 | 1.373 | 39184.3 |
759 | 2023-07-13 08:25:08 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
758 | 2023-05-22 08:31:09 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
757 | 2023-04-15 23:32:49 | gally | 2 | 53800 | 177 | 1.703 | 31591.3 |
756 | 2023-04-05 18:44:20 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
755 | 2023-03-31 14:11:52 | gally | 1 | 28756 | 17 | 0.500 | 57512.0 |
754 | 2023-03-17 19:22:17 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
753 | 2023-01-21 18:36:25 | gally | 2 | 53800 | 177 | 1.360 | 39558.8 |
752 | 2023-01-05 21:19:25 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
751 | 2023-01-04 07:08:07 | gally | 1 | 28756 | 17 | 0.470 | 61183.0 |
750 | 2022-11-26 05:24:55 | gally | 1 | 28756 | 17 | 0.420 | 68466.7 |
749 | 2022-11-02 18:12:03 | gally | 2 | 53800 | 177 | 1.403 | 38346.4 |
748 | 2022-09-30 01:13:42 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
747 | 2022-09-24 05:48:07 | gally | 1 | 28756 | 17 | 1.046 | 27491.4 |
746 | 2022-09-12 08:49:56 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
745 | 2022-08-15 23:29:50 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
744 | 2022-07-30 09:20:01 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
743 | 2022-06-25 15:48:31 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
742 | 2022-06-07 06:01:23 | gally | 1 | 28756 | 17 | 0.440 | 65354.5 |
741 | 2022-05-22 21:38:26 | gally | 2 | 53800 | 177 | 1.563 | 34421.0 |
740 | 2022-05-17 10:37:28 | gally | 1 | 28756 | 17 | 0.516 | 55728.7 |
739 | 2022-05-15 06:14:53 | gally | 1 | 28756 | 17 | 0.466 | 61708.2 |
738 | 2022-02-23 21:10:21 | gally | 1 | 28756 | 17 | 0.643 | 44721.6 |
737 | 2022-02-03 05:54:08 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
736 | 2021-12-15 06:13:51 | gally | 1 | 28756 | 17 | 0.500 | 57512.0 |
735 | 2021-11-23 00:02:18 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
734 | 2021-11-19 00:05:44 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
733 | 2021-11-17 06:17:39 | gally | 1 | 28756 | 17 | 0.470 | 61183.0 |
732 | 2021-11-15 16:57:41 | gally | 1 | 28756 | 17 | 0.530 | 54256.6 |
731 | 2021-10-06 16:09:53 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
730 | 2021-08-31 00:03:52 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
729 | 2021-08-15 18:12:29 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
728 | 2021-08-12 20:56:34 | gally | 1 | 28756 | 17 | 0.486 | 59168.7 |
727 | 2021-06-24 02:26:59 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
726 | 2021-05-16 10:30:45 | gally | 1 | 28756 | 17 | 0.516 | 55728.7 |
725 | 2021-05-12 03:57:26 | gally | 1 | 28756 | 17 | 0.560 | 51350.0 |
724 | 2021-05-06 19:15:07 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
723 | 2021-03-29 04:13:55 | gally | 1 | 28756 | 17 | 0.516 | 55728.7 |
722 | 2021-02-27 04:10:28 | gally | 1 | 28756 | 17 | 0.533 | 53951.2 |
721 | 2021-02-25 02:51:46 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
720 | 2021-02-07 20:34:48 | gally | 1 | 28756 | 17 | 0.450 | 63902.2 |
719 | 2021-02-03 16:02:10 | gally | 1 | 28756 | 17 | 0.483 | 59536.2 |
718 | 2021-01-20 09:06:45 | gally | 1 | 28756 | 17 | 0.440 | 65354.5 |
717 | 2020-11-06 02:32:39 | gally | 1 | 28756 | 17 | 0.530 | 54256.6 |
716 | 2020-10-22 11:01:47 | gally | 1 | 28756 | 17 | 0.500 | 57512.0 |
715 | 2020-10-20 13:52:02 | gally | 1 | 28756 | 17 | 0.450 | 63902.2 |
714 | 2020-10-05 15:56:46 | gally | 1 | 28756 | 17 | 0.890 | 32310.1 |
713 | 2020-09-27 08:02:21 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
712 | 2020-09-12 10:41:49 | gally | 1 | 28756 | 17 | 0.440 | 65354.5 |
711 | 2020-08-28 02:15:40 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
710 | 2020-08-05 03:25:49 | gally | 1 | 28756 | 17 | 0.440 | 65354.5 |
709 | 2020-08-02 03:28:38 | gally | 1 | 28756 | 17 | 0.516 | 55728.7 |
708 | 2020-08-01 21:54:28 | gally | 1 | 28756 | 17 | 0.470 | 61183.0 |
707 | 2020-07-22 18:44:48 | gally | 1 | 28756 | 17 | 0.560 | 51350.0 |
706 | 2020-07-20 17:31:04 | gally | 1 | 28756 | 17 | 0.466 | 61708.2 |
705 | 2020-06-19 02:01:05 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
704 | 2020-06-18 01:56:29 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
703 | 2020-06-16 07:42:24 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
702 | 2020-06-15 06:57:10 | gally | 1 | 28756 | 17 | 0.500 | 57512.0 |
701 | 2020-05-29 10:29:31 | gally | 1 | 28756 | 17 | 0.453 | 63479.0 |
700 | 2020-05-28 10:39:57 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
699 | 2020-05-27 22:58:23 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |
698 | 2020-05-27 10:01:31 | gally | 1 | 28756 | 17 | 0.436 | 65954.1 |