History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gammy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
776 | 2024-04-22 17:47:31 | gammy | 1 | 28756 | 12 | 1.296 | 22188.3 |
775 | 2024-04-18 18:48:44 | gammy | 1 | 28756 | 12 | 0.546 | 52666.7 |
774 | 2024-04-18 18:48:04 | gammy | 1 | 28756 | 12 | 0.530 | 54256.6 |
773 | 2024-04-13 18:11:30 | gammy | 1 | 28756 | 12 | 0.766 | 37540.5 |
772 | 2024-04-08 22:16:45 | gammy | 1 | 28756 | 12 | 0.546 | 52666.7 |
771 | 2024-04-03 05:49:33 | gammy | 1 | 28756 | 12 | 1.156 | 24875.4 |
770 | 2024-03-31 09:05:03 | gammy | 3 | 83667 | 864 | 13.313 | 6284.6 |
769 | 2024-03-31 05:43:03 | gammy | 2 | 53800 | 89 | 1.906 | 28226.7 |
768 | 2024-03-31 03:54:28 | gammy | 1 | 28756 | 12 | 1.093 | 26309.2 |
767 | 2024-03-30 22:24:44 | gammy | 3 | 83667 | 864 | 5.813 | 14393.1 |
766 | 2024-03-30 19:32:00 | gammy | 3 | 83667 | 864 | 12.703 | 6586.4 |
765 | 2024-03-29 08:25:47 | gammy | 3 | 83667 | 864 | 12.000 | 6972.3 |
764 | 2024-03-29 08:25:45 | gammy | 2 | 53800 | 89 | 4.640 | 11594.8 |
763 | 2024-03-29 08:19:44 | gammy | 1 | 28756 | 12 | 0.576 | 49923.6 |
762 | 2024-03-28 09:28:17 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
761 | 2024-03-13 02:48:13 | gammy | 1 | 28756 | 12 | 0.593 | 48492.4 |
760 | 2024-03-09 00:25:45 | gammy | 1 | 28756 | 12 | 1.140 | 25224.6 |
759 | 2024-03-03 21:07:32 | gammy | 1 | 28756 | 12 | 0.593 | 48492.4 |
758 | 2024-02-28 02:19:22 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
757 | 2024-02-13 21:09:48 | gammy | 1 | 28756 | 12 | 0.580 | 49579.3 |
756 | 2024-02-07 21:44:39 | gammy | 3 | 83667 | 864 | 7.670 | 10908.3 |
755 | 2024-02-07 21:44:35 | gammy | 2 | 53800 | 89 | 2.783 | 19331.7 |
754 | 2024-02-07 21:44:31 | gammy | 1 | 28756 | 12 | 0.533 | 53951.2 |
753 | 2024-01-29 00:51:53 | gammy | 1 | 28756 | 12 | 0.440 | 65354.5 |
752 | 2024-01-08 16:51:41 | gammy | 1 | 28756 | 12 | 0.516 | 55728.7 |
751 | 2023-12-31 06:39:25 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
750 | 2023-12-30 19:16:15 | gammy | 1 | 28756 | 12 | 0.450 | 63902.2 |
749 | 2023-12-29 01:08:37 | gammy | 2 | 53800 | 89 | 1.360 | 39558.8 |
748 | 2023-12-29 01:08:33 | gammy | 3 | 83667 | 864 | 3.280 | 25508.2 |
747 | 2023-12-28 09:18:37 | gammy | 2 | 53800 | 89 | 1.390 | 38705.0 |
746 | 2023-12-27 08:13:21 | gammy | 3 | 83667 | 864 | 3.326 | 25155.4 |
745 | 2023-12-01 15:57:58 | gammy | 3 | 83667 | 864 | 3.326 | 25155.4 |
744 | 2023-12-01 15:57:56 | gammy | 2 | 53800 | 89 | 1.513 | 35558.5 |
743 | 2023-11-18 08:55:38 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
742 | 2023-11-13 22:35:22 | gammy | 1 | 28756 | 12 | 0.450 | 63902.2 |
741 | 2023-11-13 00:35:35 | gammy | 1 | 28756 | 12 | 0.516 | 55728.7 |
740 | 2023-11-04 02:57:58 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
739 | 2023-10-22 05:04:44 | gammy | 1 | 28756 | 12 | 1.203 | 23903.6 |
738 | 2023-10-20 20:14:16 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
737 | 2023-10-17 16:20:40 | gammy | 1 | 28756 | 12 | 0.423 | 67981.1 |
736 | 2023-10-13 18:07:05 | gammy | 1 | 28756 | 12 | 0.516 | 55728.7 |
735 | 2023-10-05 02:30:40 | gammy | 1 | 28756 | 12 | 0.466 | 61708.2 |
734 | 2023-09-28 12:42:04 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
733 | 2023-09-22 18:22:39 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
732 | 2023-08-15 21:45:23 | gammy | 1 | 28756 | 12 | 0.420 | 68466.7 |
731 | 2023-07-17 03:50:29 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
730 | 2023-07-11 15:32:34 | gammy | 1 | 28756 | 12 | 0.486 | 59168.7 |
729 | 2023-05-15 11:14:04 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
728 | 2023-03-31 14:15:39 | gammy | 1 | 28756 | 12 | 0.486 | 59168.7 |
727 | 2023-03-25 12:53:54 | gammy | 1 | 28756 | 12 | 0.423 | 67981.1 |
726 | 2023-03-11 07:58:44 | gammy | 1 | 28756 | 12 | 0.420 | 68466.7 |
725 | 2023-01-01 01:36:15 | gammy | 1 | 28756 | 12 | 0.486 | 59168.7 |
724 | 2022-12-07 08:54:54 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
723 | 2022-09-22 05:09:17 | gammy | 1 | 28756 | 12 | 0.470 | 61183.0 |
722 | 2022-09-18 13:59:39 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
721 | 2022-08-07 03:58:38 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
720 | 2022-08-07 01:49:04 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
719 | 2022-08-03 20:23:16 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
718 | 2022-07-29 15:27:53 | gammy | 1 | 28756 | 12 | 0.440 | 65354.5 |
717 | 2022-07-18 05:33:25 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
716 | 2022-07-10 08:21:59 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
715 | 2022-06-25 22:53:29 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
714 | 2022-06-25 13:25:09 | gammy | 1 | 28756 | 12 | 0.440 | 65354.5 |
713 | 2022-06-01 18:02:10 | gammy | 1 | 28756 | 12 | 0.470 | 61183.0 |
712 | 2022-05-01 21:06:07 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
711 | 2022-04-02 09:53:02 | gammy | 1 | 28756 | 12 | 0.486 | 59168.7 |
710 | 2022-03-29 22:35:43 | gammy | 1 | 28756 | 12 | 0.623 | 46157.3 |
709 | 2022-01-20 21:30:14 | gammy | 1 | 28756 | 12 | 0.516 | 55728.7 |
708 | 2021-12-09 03:09:47 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
707 | 2021-11-23 18:30:56 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
706 | 2021-11-22 16:49:38 | gammy | 1 | 28756 | 12 | 0.513 | 56054.6 |
705 | 2021-11-14 11:16:36 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
704 | 2021-10-06 09:48:08 | gammy | 1 | 28756 | 12 | 0.533 | 53951.2 |
703 | 2021-09-05 01:21:58 | gammy | 1 | 28756 | 12 | 0.440 | 65354.5 |
702 | 2021-09-04 05:04:45 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
701 | 2021-09-01 17:58:10 | gammy | 1 | 28756 | 12 | 0.546 | 52666.7 |
700 | 2021-08-17 15:47:03 | gammy | 1 | 28756 | 12 | 0.483 | 59536.2 |
699 | 2021-08-15 11:15:13 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
698 | 2021-07-26 20:49:13 | gammy | 1 | 28756 | 12 | 0.483 | 59536.2 |
697 | 2021-06-23 18:25:05 | gammy | 3 | 83667 | 864 | 7.966 | 10503.0 |
696 | 2021-05-22 00:45:57 | gammy | 1 | 28756 | 12 | 0.486 | 59168.7 |
695 | 2021-05-19 01:01:33 | gammy | 1 | 28756 | 12 | 0.546 | 52666.7 |
694 | 2021-05-18 17:26:48 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
693 | 2021-05-17 13:31:08 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
692 | 2021-02-15 13:54:20 | gammy | 1 | 28756 | 12 | 0.563 | 51076.4 |
691 | 2021-02-01 17:17:12 | gammy | 3 | 83667 | 864 | 3.453 | 24230.2 |
690 | 2021-01-30 01:10:44 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
689 | 2020-12-21 02:04:45 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
688 | 2020-12-18 06:19:19 | gammy | 1 | 28756 | 12 | 0.500 | 57512.0 |
687 | 2020-12-16 08:08:05 | gammy | 1 | 28756 | 12 | 0.453 | 63479.0 |
686 | 2020-12-11 16:36:49 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
685 | 2020-12-05 09:37:13 | gammy | 1 | 28756 | 12 | 0.436 | 65954.1 |
684 | 2020-11-11 23:29:51 | gammy | 1 | 28756 | 12 | 0.423 | 67981.1 |
683 | 2020-11-11 06:37:23 | gammy | 1 | 28756 | 12 | 0.533 | 53951.2 |
682 | 2020-11-03 18:23:37 | gammy | 3 | 83667 | 864 | 3.546 | 23594.8 |
681 | 2020-10-30 15:15:38 | gammy | 3 | 83667 | 864 | 3.533 | 23681.6 |
680 | 2020-10-23 12:19:44 | gammy | 3 | 83667 | 864 | 3.283 | 25484.9 |
679 | 2020-10-20 21:26:13 | gammy | 3 | 83667 | 864 | 3.390 | 24680.5 |
678 | 2020-10-20 17:52:33 | gammy | 3 | 83667 | 864 | 3.373 | 24804.9 |
677 | 2020-10-18 22:37:06 | gammy | 3 | 83667 | 864 | 3.420 | 24464.0 |