History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"basement"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
842 | 2024-04-05 12:39:19 | basement | 3 | 146162 | 106 | 13.326 | 10968.2 |
841 | 2024-04-05 12:39:20 | basement | 2 | 121059 | 20 | 6.983 | 17336.2 |
840 | 2024-04-05 12:39:18 | basement | 1 | 82945 | 6 | 1.626 | 51011.7 |
839 | 2024-03-30 23:05:28 | basement | 2 | 121059 | 20 | 4.846 | 24981.2 |
838 | 2024-03-30 10:59:19 | basement | 1 | 82945 | 6 | 1.530 | 54212.4 |
837 | 2024-03-30 03:53:31 | basement | 3 | 146162 | 106 | 19.563 | 7471.3 |
836 | 2024-03-30 03:36:13 | basement | 2 | 121059 | 20 | 12.923 | 9367.7 |
835 | 2024-03-30 03:25:05 | basement | 1 | 82945 | 6 | 5.016 | 16536.1 |
834 | 2024-03-27 10:50:31 | basement | 3 | 146162 | 106 | 7.533 | 19402.9 |
833 | 2024-03-08 22:13:52 | basement | 3 | 146162 | 106 | 13.050 | 11200.2 |
832 | 2024-03-07 19:45:36 | basement | 2 | 121059 | 20 | 4.623 | 26186.2 |
831 | 2024-03-07 19:19:45 | basement | 3 | 146162 | 106 | 11.890 | 12292.9 |
830 | 2024-03-07 17:26:12 | basement | 2 | 121059 | 20 | 4.220 | 28687.0 |
829 | 2024-03-07 17:26:00 | basement | 3 | 146162 | 106 | 8.203 | 17818.1 |
828 | 2024-03-07 13:39:33 | basement | 1 | 82945 | 6 | 1.610 | 51518.6 |
827 | 2024-03-06 05:49:47 | basement | 3 | 146162 | 106 | 18.763 | 7789.9 |
826 | 2024-03-06 05:49:45 | basement | 2 | 121059 | 20 | 8.766 | 13810.1 |
825 | 2024-03-06 05:49:33 | basement | 1 | 82945 | 6 | 4.063 | 20414.7 |
824 | 2024-02-04 03:01:27 | basement | 1 | 82945 | 6 | 1.343 | 61761.0 |
823 | 2024-01-02 01:22:41 | basement | 1 | 82945 | 6 | 1.390 | 59672.7 |
822 | 2023-12-28 20:09:35 | basement | 3 | 146162 | 106 | 6.830 | 21400.0 |
821 | 2023-12-16 09:07:49 | basement | 1 | 82945 | 6 | 1.310 | 63316.8 |
820 | 2023-12-02 16:30:27 | basement | 3 | 146162 | 106 | 6.843 | 21359.3 |
819 | 2023-11-30 17:09:57 | basement | 1 | 82945 | 6 | 1.470 | 56425.2 |
818 | 2023-11-25 16:41:15 | basement | 1 | 82945 | 6 | 1.610 | 51518.6 |
817 | 2023-11-23 06:00:48 | basement | 1 | 82945 | 6 | 3.156 | 26281.7 |
816 | 2023-11-06 18:47:18 | basement | 1 | 82945 | 6 | 1.373 | 60411.5 |
815 | 2023-10-29 22:24:18 | basement | 3 | 146162 | 106 | 10.190 | 14343.7 |
814 | 2023-10-29 22:24:18 | basement | 2 | 121059 | 20 | 9.360 | 12933.7 |
813 | 2023-10-22 18:24:08 | basement | 1 | 82945 | 6 | 1.546 | 53651.4 |
812 | 2023-10-21 04:45:37 | basement | 1 | 82945 | 6 | 1.453 | 57085.3 |
811 | 2023-08-31 05:41:14 | basement | 3 | 146162 | 106 | 6.360 | 22981.4 |
810 | 2023-08-27 00:45:54 | basement | 1 | 82945 | 6 | 1.313 | 63172.1 |
809 | 2023-08-17 19:49:41 | basement | 1 | 82945 | 6 | 1.250 | 66356.0 |
808 | 2023-06-14 02:20:34 | basement | 3 | 146162 | 106 | 6.343 | 23043.0 |
807 | 2023-05-21 16:09:00 | basement | 1 | 82945 | 6 | 1.283 | 64649.3 |
806 | 2023-05-17 20:57:42 | basement | 3 | 146162 | 106 | 6.330 | 23090.4 |
805 | 2023-05-13 08:33:40 | basement | 1 | 82945 | 6 | 1.453 | 57085.3 |
804 | 2023-05-09 17:06:10 | basement | 1 | 82945 | 6 | 1.390 | 59672.7 |
803 | 2023-03-17 03:46:03 | basement | 1 | 82945 | 6 | 1.280 | 64800.8 |
802 | 2023-02-24 04:18:34 | basement | 3 | 146162 | 106 | 8.173 | 17883.5 |
801 | 2023-01-20 03:54:32 | basement | 1 | 82945 | 6 | 1.280 | 64800.8 |
800 | 2023-01-05 08:17:56 | basement | 1 | 82945 | 6 | 1.250 | 66356.0 |
799 | 2022-12-06 10:42:17 | basement | 3 | 146162 | 106 | 7.110 | 20557.2 |
798 | 2022-09-30 22:30:07 | basement | 1 | 82945 | 6 | 1.296 | 64000.8 |
797 | 2022-09-28 18:22:15 | basement | 1 | 82945 | 6 | 1.296 | 64000.8 |
796 | 2022-08-27 20:45:38 | basement | 1 | 82945 | 6 | 1.423 | 58288.8 |
795 | 2022-06-15 09:58:31 | basement | 1 | 82945 | 6 | 1.250 | 66356.0 |
794 | 2022-05-14 17:21:31 | basement | 1 | 82945 | 6 | 1.313 | 63172.1 |
793 | 2022-05-12 15:08:21 | basement | 1 | 82945 | 6 | 1.626 | 51011.7 |
792 | 2022-04-08 18:33:51 | basement | 3 | 146162 | 106 | 7.313 | 19986.6 |
791 | 2022-03-03 13:25:43 | basement | 1 | 82945 | 6 | 1.670 | 49667.7 |
790 | 2022-02-05 18:58:20 | basement | 3 | 146162 | 106 | 7.203 | 20291.8 |
789 | 2022-01-25 00:53:00 | basement | 1 | 82945 | 6 | 1.483 | 55930.5 |
788 | 2021-12-20 02:51:49 | basement | 3 | 146162 | 106 | 7.360 | 19859.0 |
787 | 2021-11-23 08:26:22 | basement | 1 | 82945 | 6 | 1.516 | 54713.1 |
786 | 2021-11-22 12:15:26 | basement | 1 | 82945 | 6 | 1.513 | 54821.5 |
785 | 2021-10-10 08:13:25 | basement | 1 | 82945 | 6 | 1.453 | 57085.3 |
784 | 2021-10-06 13:53:27 | basement | 3 | 146162 | 106 | 7.110 | 20557.2 |
783 | 2021-09-06 04:59:50 | basement | 1 | 82945 | 6 | 1.296 | 64000.8 |
782 | 2021-09-03 23:33:17 | basement | 1 | 82945 | 6 | 1.406 | 58993.6 |
781 | 2021-08-20 07:47:59 | basement | 1 | 82945 | 6 | 1.360 | 60989.0 |
780 | 2021-08-17 10:30:45 | basement | 1 | 82945 | 6 | 1.280 | 64800.8 |
779 | 2021-08-15 15:26:31 | basement | 3 | 146162 | 106 | 6.296 | 23215.1 |
778 | 2021-08-14 18:13:59 | basement | 3 | 146162 | 106 | 6.423 | 22756.0 |
777 | 2021-08-12 02:54:27 | basement | 3 | 146162 | 106 | 6.560 | 22280.8 |
776 | 2021-08-11 18:37:24 | basement | 3 | 146162 | 106 | 7.000 | 20880.3 |
775 | 2021-08-08 17:49:10 | basement | 3 | 146162 | 106 | 7.033 | 20782.3 |
774 | 2021-08-07 23:34:12 | basement | 3 | 146162 | 106 | 15.123 | 9664.9 |
773 | 2021-08-05 09:21:51 | basement | 3 | 146162 | 106 | 6.796 | 21507.1 |
772 | 2021-07-29 02:42:26 | basement | 3 | 146162 | 106 | 6.923 | 21112.5 |
771 | 2021-07-28 15:10:18 | basement | 2 | 121059 | 20 | 3.736 | 32403.4 |
770 | 2021-07-14 09:23:51 | basement | 3 | 146162 | 106 | 6.813 | 21453.4 |
769 | 2021-07-11 19:25:52 | basement | 3 | 146162 | 106 | 6.780 | 21557.8 |
768 | 2021-07-08 19:40:09 | basement | 3 | 146162 | 106 | 7.330 | 19940.2 |
767 | 2021-07-07 19:21:01 | basement | 3 | 146162 | 106 | 6.390 | 22873.6 |
766 | 2021-07-05 21:06:19 | basement | 3 | 146162 | 106 | 7.656 | 19091.2 |
765 | 2021-07-04 06:57:47 | basement | 3 | 146162 | 106 | 7.360 | 19859.0 |
764 | 2021-07-03 17:55:46 | basement | 3 | 146162 | 106 | 7.470 | 19566.5 |
763 | 2021-07-02 15:06:03 | basement | 3 | 146162 | 106 | 7.890 | 18525.0 |
762 | 2021-07-02 03:08:40 | basement | 3 | 146162 | 106 | 7.516 | 19446.8 |
761 | 2021-06-30 03:38:29 | basement | 3 | 146162 | 106 | 6.906 | 21164.5 |
760 | 2021-06-29 19:37:52 | basement | 3 | 146162 | 106 | 7.390 | 19778.3 |
759 | 2021-06-29 03:41:02 | basement | 3 | 146162 | 106 | 6.830 | 21400.0 |
758 | 2021-06-28 09:06:36 | basement | 3 | 146162 | 106 | 7.470 | 19566.5 |
757 | 2021-06-27 21:02:52 | basement | 3 | 146162 | 106 | 6.376 | 22923.8 |
756 | 2021-06-26 19:16:38 | basement | 3 | 146162 | 106 | 7.326 | 19951.1 |
755 | 2021-06-24 20:45:58 | basement | 3 | 146162 | 106 | 14.796 | 9878.5 |
754 | 2021-06-23 19:18:12 | basement | 3 | 146162 | 106 | 7.220 | 20244.0 |
753 | 2021-06-21 05:10:14 | basement | 3 | 146162 | 106 | 6.376 | 22923.8 |
752 | 2021-06-16 20:40:04 | basement | 3 | 146162 | 106 | 10.060 | 14529.0 |
751 | 2021-06-15 20:33:53 | basement | 3 | 146162 | 106 | 7.466 | 19577.0 |
750 | 2021-06-14 18:57:06 | basement | 3 | 146162 | 106 | 9.033 | 16180.9 |
749 | 2021-06-13 18:10:45 | basement | 3 | 146162 | 106 | 6.563 | 22270.6 |
748 | 2021-06-12 20:08:44 | basement | 3 | 146162 | 106 | 7.690 | 19006.8 |
747 | 2021-06-11 22:00:32 | basement | 3 | 146162 | 106 | 7.940 | 18408.3 |
746 | 2021-06-11 17:50:22 | basement | 3 | 146162 | 106 | 7.956 | 18371.3 |
745 | 2021-06-10 18:28:11 | basement | 3 | 146162 | 106 | 6.673 | 21903.5 |
744 | 2021-06-09 19:54:44 | basement | 3 | 146162 | 106 | 6.640 | 22012.3 |
743 | 2021-06-09 03:17:28 | basement | 3 | 146162 | 106 | 7.580 | 19282.6 |