History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roof"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
864 | 2024-04-20 18:57:01 | roof | 1 | 13983 | 14 | 0.750 | 18644.0 |
863 | 2024-04-19 14:50:08 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
862 | 2024-04-03 00:56:16 | roof | 2 | 29872 | 201 | 2.203 | 13559.7 |
861 | 2024-04-03 00:38:48 | roof | 1 | 13983 | 14 | 0.720 | 19420.8 |
860 | 2024-04-01 17:56:40 | roof | 2 | 29872 | 201 | 1.060 | 28181.1 |
859 | 2024-04-01 16:06:35 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
858 | 2024-03-31 01:07:53 | roof | 1 | 13983 | 14 | 0.280 | 49939.3 |
857 | 2024-03-30 23:31:29 | roof | 2 | 29872 | 201 | 2.110 | 14157.3 |
856 | 2024-03-30 16:05:27 | roof | 2 | 29872 | 201 | 0.940 | 31778.7 |
855 | 2024-03-28 17:46:59 | roof | 1 | 13983 | 14 | 0.263 | 53167.3 |
854 | 2024-03-20 18:22:47 | roof | 1 | 13983 | 14 | 0.640 | 21848.4 |
853 | 2024-03-20 18:22:13 | roof | 2 | 29872 | 201 | 2.466 | 12113.5 |
852 | 2024-03-20 18:21:45 | roof | 1 | 13983 | 14 | 0.263 | 53167.3 |
851 | 2024-03-03 20:26:10 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
850 | 2024-03-02 13:51:36 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
849 | 2024-03-01 02:49:18 | roof | 1 | 13983 | 14 | 0.280 | 49939.3 |
848 | 2024-02-29 19:25:37 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
847 | 2024-02-26 19:39:52 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
846 | 2024-02-02 17:22:19 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
845 | 2024-01-28 16:51:51 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
844 | 2024-01-28 11:58:16 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
843 | 2024-01-27 15:43:09 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
842 | 2024-01-17 04:34:23 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
841 | 2024-01-08 20:35:36 | roof | 1 | 13983 | 14 | 0.203 | 68881.8 |
840 | 2023-12-28 14:37:02 | roof | 2 | 29872 | 201 | 0.843 | 35435.3 |
839 | 2023-12-09 11:37:44 | roof | 1 | 13983 | 14 | 0.263 | 53167.3 |
838 | 2023-11-28 05:31:06 | roof | 2 | 29872 | 201 | 0.830 | 35990.4 |
837 | 2023-11-28 04:06:32 | roof | 2 | 29872 | 201 | 0.780 | 38297.4 |
836 | 2023-11-18 04:41:37 | roof | 1 | 13983 | 14 | 0.283 | 49409.9 |
835 | 2023-11-13 18:42:50 | roof | 2 | 29872 | 201 | 0.783 | 38150.7 |
834 | 2023-11-09 23:01:59 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
833 | 2023-10-26 18:52:12 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
832 | 2023-10-20 06:49:53 | roof | 1 | 13983 | 14 | 0.516 | 27098.8 |
831 | 2023-10-17 07:10:18 | roof | 1 | 13983 | 14 | 0.500 | 27966.0 |
830 | 2023-10-13 19:04:08 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
829 | 2023-10-04 00:42:01 | roof | 1 | 13983 | 14 | 0.266 | 52567.7 |
828 | 2023-09-26 21:27:46 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
827 | 2023-09-25 02:30:37 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
826 | 2023-09-24 06:52:58 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
825 | 2023-09-22 18:30:53 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
824 | 2023-08-27 19:01:43 | roof | 2 | 29872 | 201 | 0.876 | 34100.5 |
823 | 2023-07-22 05:34:32 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
822 | 2023-06-03 07:43:07 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
821 | 2023-05-11 16:17:09 | roof | 2 | 29872 | 201 | 0.783 | 38150.7 |
820 | 2023-04-22 03:45:23 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
819 | 2023-02-18 12:42:06 | roof | 2 | 29872 | 201 | 1.580 | 18906.3 |
818 | 2023-02-13 04:19:46 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
817 | 2023-02-08 00:17:52 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
816 | 2022-12-11 18:07:41 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
815 | 2022-11-30 01:20:10 | roof | 2 | 29872 | 201 | 0.766 | 38997.4 |
814 | 2022-10-10 12:20:12 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
813 | 2022-09-12 05:11:55 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
812 | 2022-09-03 18:48:59 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
811 | 2022-08-16 08:44:49 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
810 | 2022-08-06 21:55:29 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
809 | 2022-07-07 08:41:05 | roof | 2 | 29872 | 201 | 0.796 | 37527.6 |
808 | 2022-07-03 08:38:49 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
807 | 2022-07-02 21:29:54 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
806 | 2022-06-16 09:56:05 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
805 | 2022-06-16 08:37:35 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
804 | 2022-04-07 05:27:16 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
803 | 2022-02-18 11:29:40 | roof | 2 | 29872 | 201 | 0.876 | 34100.5 |
802 | 2022-02-15 09:52:11 | roof | 1 | 13983 | 14 | 0.326 | 42892.6 |
801 | 2022-01-08 19:01:42 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
800 | 2021-11-12 19:14:49 | roof | 2 | 29872 | 201 | 0.876 | 34100.5 |
799 | 2021-11-06 23:21:13 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
798 | 2021-10-25 01:06:40 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
797 | 2021-09-24 09:56:59 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
796 | 2021-08-22 18:58:58 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
795 | 2021-08-20 14:40:44 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
794 | 2021-07-21 17:22:44 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
793 | 2021-06-06 10:51:48 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
792 | 2021-05-12 12:12:57 | roof | 1 | 13983 | 14 | 0.483 | 28950.3 |
791 | 2021-04-28 02:21:12 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
790 | 2021-04-27 15:06:12 | roof | 1 | 13983 | 14 | 0.500 | 27966.0 |
789 | 2021-04-26 21:26:06 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
788 | 2021-04-26 02:31:49 | roof | 1 | 13983 | 14 | 0.436 | 32071.1 |
787 | 2021-04-18 21:35:14 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
786 | 2021-04-11 08:06:26 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
785 | 2021-04-07 16:06:53 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
784 | 2021-01-18 01:40:28 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
783 | 2020-11-30 04:20:14 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
782 | 2020-11-17 03:30:22 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
781 | 2020-11-11 05:29:34 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
780 | 2020-10-24 00:35:54 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
779 | 2020-10-23 02:57:45 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |
778 | 2020-10-20 19:45:41 | roof | 2 | 29872 | 201 | 0.780 | 38297.4 |
777 | 2020-10-19 07:23:40 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
776 | 2020-10-16 06:25:05 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
775 | 2020-10-14 01:08:22 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
774 | 2020-09-18 04:42:35 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
773 | 2020-08-11 09:32:20 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
772 | 2020-07-18 03:44:36 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
771 | 2020-06-21 07:16:31 | roof | 1 | 13983 | 14 | 0.250 | 55932.0 |
770 | 2020-06-20 07:00:43 | roof | 1 | 13983 | 14 | 0.216 | 64736.1 |
769 | 2020-06-15 18:18:01 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
768 | 2020-06-06 10:52:15 | roof | 2 | 29872 | 201 | 0.906 | 32971.3 |
767 | 2020-06-05 14:42:39 | roof | 1 | 13983 | 14 | 0.236 | 59250.0 |
766 | 2020-04-16 07:55:43 | roof | 1 | 13983 | 14 | 0.233 | 60012.9 |
765 | 2020-03-31 23:30:47 | roof | 1 | 13983 | 14 | 0.220 | 63559.1 |