History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"genre"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
840 | 2024-04-28 16:44:53 | genre | 1 | 28756 | 5 | 0.516 | 55728.7 |
839 | 2024-04-25 18:57:16 | genre | 1 | 28756 | 5 | 0.550 | 52283.6 |
838 | 2024-04-24 18:45:31 | genre | 3 | 83667 | 1328 | 3.563 | 23482.2 |
837 | 2024-04-19 12:41:28 | genre | 1 | 28756 | 5 | 0.563 | 51076.4 |
836 | 2024-04-18 22:34:20 | genre | 3 | 83667 | 1328 | 3.486 | 24000.9 |
835 | 2024-04-15 07:32:03 | genre | 3 | 83667 | 1328 | 13.593 | 6155.2 |
834 | 2024-04-15 01:53:48 | genre | 3 | 83667 | 1328 | 10.733 | 7795.3 |
833 | 2024-04-15 01:51:54 | genre | 3 | 83667 | 1328 | 5.343 | 15659.2 |
832 | 2024-04-14 09:31:01 | genre | 3 | 83667 | 1328 | 7.486 | 11176.5 |
831 | 2024-04-14 09:30:58 | genre | 2 | 53800 | 87 | 3.686 | 14595.8 |
830 | 2024-04-14 09:01:08 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
829 | 2024-04-03 05:56:23 | genre | 1 | 28756 | 5 | 0.440 | 65354.5 |
828 | 2024-03-31 14:54:41 | genre | 1 | 28756 | 5 | 0.530 | 54256.6 |
827 | 2024-03-27 08:04:03 | genre | 1 | 28756 | 5 | 0.486 | 59168.7 |
826 | 2024-03-04 01:20:48 | genre | 3 | 83667 | 1328 | 7.686 | 10885.6 |
825 | 2024-03-04 01:20:48 | genre | 2 | 53800 | 87 | 1.813 | 29674.6 |
824 | 2024-03-04 01:20:39 | genre | 1 | 28756 | 5 | 0.486 | 59168.7 |
823 | 2024-03-01 12:15:35 | genre | 1 | 28756 | 5 | 0.440 | 65354.5 |
822 | 2024-03-01 08:18:52 | genre | 1 | 28756 | 5 | 0.516 | 55728.7 |
821 | 2024-02-28 04:57:40 | genre | 2 | 53800 | 87 | 5.920 | 9087.8 |
820 | 2024-02-28 04:57:02 | genre | 3 | 83667 | 1328 | 5.673 | 14748.3 |
819 | 2024-02-27 21:18:49 | genre | 2 | 53800 | 87 | 1.763 | 30516.2 |
818 | 2024-02-27 21:18:28 | genre | 3 | 83667 | 1328 | 4.690 | 17839.4 |
817 | 2024-02-27 20:17:24 | genre | 3 | 83667 | 1328 | 3.986 | 20990.2 |
816 | 2024-02-26 04:06:00 | genre | 1 | 28756 | 5 | 0.530 | 54256.6 |
815 | 2024-02-25 21:53:44 | genre | 3 | 83667 | 1328 | 7.216 | 11594.7 |
814 | 2024-02-25 21:53:42 | genre | 2 | 53800 | 87 | 1.813 | 29674.6 |
813 | 2024-02-24 14:28:58 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
812 | 2024-02-02 21:34:47 | genre | 1 | 28756 | 5 | 1.016 | 28303.1 |
811 | 2024-01-29 04:13:35 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
810 | 2024-01-26 22:56:57 | genre | 1 | 28756 | 5 | 0.513 | 56054.6 |
809 | 2024-01-26 11:34:17 | genre | 3 | 83667 | 1328 | 5.720 | 14627.1 |
808 | 2024-01-26 11:33:21 | genre | 2 | 53800 | 87 | 1.593 | 33772.8 |
807 | 2023-12-29 13:10:35 | genre | 1 | 28756 | 5 | 0.516 | 55728.7 |
806 | 2023-12-09 09:33:57 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
805 | 2023-12-08 16:37:24 | genre | 3 | 83667 | 1328 | 3.343 | 25027.5 |
804 | 2023-12-08 16:37:22 | genre | 2 | 53800 | 87 | 1.420 | 37887.3 |
803 | 2023-12-06 05:17:02 | genre | 3 | 83667 | 1328 | 3.733 | 22412.8 |
802 | 2023-12-06 05:16:57 | genre | 2 | 53800 | 87 | 3.173 | 16955.6 |
801 | 2023-11-25 06:18:03 | genre | 1 | 28756 | 5 | 0.466 | 61708.2 |
800 | 2023-11-22 04:52:32 | genre | 3 | 83667 | 1328 | 3.216 | 26015.9 |
799 | 2023-11-21 21:22:54 | genre | 1 | 28756 | 5 | 1.000 | 28756.0 |
798 | 2023-11-11 02:34:08 | genre | 1 | 28756 | 5 | 0.486 | 59168.7 |
797 | 2023-11-10 18:27:53 | genre | 1 | 28756 | 5 | 0.516 | 55728.7 |
796 | 2023-10-27 20:58:06 | genre | 1 | 28756 | 5 | 0.483 | 59536.2 |
795 | 2023-10-26 09:06:54 | genre | 2 | 53800 | 87 | 1.796 | 29955.5 |
794 | 2023-10-26 09:00:05 | genre | 3 | 83667 | 1328 | 6.546 | 12781.4 |
793 | 2023-10-24 20:28:11 | genre | 3 | 83667 | 1328 | 8.266 | 10121.8 |
792 | 2023-10-24 20:28:12 | genre | 2 | 53800 | 87 | 3.296 | 16322.8 |
791 | 2023-10-19 18:40:56 | genre | 1 | 28756 | 5 | 0.516 | 55728.7 |
790 | 2023-10-17 19:28:38 | genre | 1 | 28756 | 5 | 1.593 | 18051.5 |
789 | 2023-10-11 08:37:48 | genre | 1 | 28756 | 5 | 0.470 | 61183.0 |
788 | 2023-10-11 02:27:16 | genre | 3 | 83667 | 1328 | 4.076 | 20526.7 |
787 | 2023-10-08 21:59:13 | genre | 2 | 53800 | 87 | 3.356 | 16031.0 |
786 | 2023-10-08 21:59:12 | genre | 3 | 83667 | 1328 | 4.140 | 20209.4 |
785 | 2023-10-03 15:05:20 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
784 | 2023-09-24 16:06:17 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
783 | 2023-09-23 16:45:02 | genre | 1 | 28756 | 5 | 0.440 | 65354.5 |
782 | 2023-09-12 08:28:00 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
781 | 2023-08-23 03:37:50 | genre | 3 | 83667 | 1328 | 3.670 | 22797.5 |
780 | 2023-08-09 05:50:16 | genre | 1 | 28756 | 5 | 0.453 | 63479.0 |
779 | 2023-07-22 09:37:46 | genre | 1 | 28756 | 5 | 0.453 | 63479.0 |
778 | 2023-05-07 20:36:37 | genre | 3 | 83667 | 1328 | 3.250 | 25743.7 |
777 | 2023-05-01 16:16:03 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
776 | 2023-04-23 05:35:31 | genre | 1 | 28756 | 5 | 0.440 | 65354.5 |
775 | 2023-02-17 15:42:11 | genre | 1 | 28756 | 5 | 0.440 | 65354.5 |
774 | 2023-02-14 04:13:46 | genre | 3 | 83667 | 1328 | 3.640 | 22985.4 |
773 | 2023-01-23 03:57:28 | genre | 1 | 28756 | 5 | 0.470 | 61183.0 |
772 | 2022-12-16 12:31:31 | genre | 1 | 28756 | 5 | 0.420 | 68466.7 |
771 | 2022-11-26 11:45:15 | genre | 3 | 83667 | 1328 | 3.216 | 26015.9 |
770 | 2022-10-05 06:39:31 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
769 | 2022-09-18 11:21:24 | genre | 1 | 28756 | 5 | 0.466 | 61708.2 |
768 | 2022-09-12 09:56:04 | genre | 1 | 28756 | 5 | 0.483 | 59536.2 |
767 | 2022-09-12 04:46:17 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
766 | 2022-08-25 07:15:40 | genre | 1 | 28756 | 5 | 0.450 | 63902.2 |
765 | 2022-08-22 23:12:03 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
764 | 2022-08-07 00:54:21 | genre | 1 | 28756 | 5 | 0.466 | 61708.2 |
763 | 2022-08-06 05:23:10 | genre | 1 | 28756 | 5 | 0.470 | 61183.0 |
762 | 2022-07-30 02:13:34 | genre | 1 | 28756 | 5 | 0.486 | 59168.7 |
761 | 2022-07-28 18:38:49 | genre | 1 | 28756 | 5 | 0.453 | 63479.0 |
760 | 2022-07-16 15:03:12 | genre | 2 | 53800 | 87 | 1.376 | 39098.8 |
759 | 2022-07-10 15:33:56 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
758 | 2022-07-03 21:57:04 | genre | 3 | 83667 | 1328 | 3.546 | 23594.8 |
757 | 2022-06-25 21:55:00 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
756 | 2022-06-14 15:50:58 | genre | 1 | 28756 | 5 | 0.486 | 59168.7 |
755 | 2022-06-11 00:42:28 | genre | 1 | 28756 | 5 | 0.466 | 61708.2 |
754 | 2022-04-10 05:08:35 | genre | 1 | 28756 | 5 | 0.513 | 56054.6 |
753 | 2022-04-08 18:04:45 | genre | 1 | 28756 | 5 | 0.453 | 63479.0 |
752 | 2022-02-24 01:30:24 | genre | 1 | 28756 | 5 | 0.440 | 65354.5 |
751 | 2022-01-06 01:52:42 | genre | 1 | 28756 | 5 | 0.470 | 61183.0 |
750 | 2021-11-19 04:36:19 | genre | 1 | 28756 | 5 | 0.440 | 65354.5 |
749 | 2021-11-15 20:55:59 | genre | 1 | 28756 | 5 | 0.423 | 67981.1 |
748 | 2021-11-14 06:11:43 | genre | 1 | 28756 | 5 | 0.483 | 59536.2 |
747 | 2021-10-31 04:27:42 | genre | 1 | 28756 | 5 | 0.516 | 55728.7 |
746 | 2021-09-21 18:09:09 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
745 | 2021-08-20 01:00:50 | genre | 1 | 28756 | 5 | 0.500 | 57512.0 |
744 | 2021-08-17 20:00:53 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
743 | 2021-08-13 00:56:20 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
742 | 2021-07-20 22:26:41 | genre | 1 | 28756 | 5 | 0.436 | 65954.1 |
741 | 2021-05-12 07:51:38 | genre | 1 | 28756 | 5 | 0.453 | 63479.0 |