History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefires"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
872 | 2024-04-23 00:52:06 | prefires | 1 | 82945 | 7 | 1.483 | 55930.5 |
871 | 2024-04-13 08:57:25 | prefires | 2 | 121059 | 41 | 6.046 | 20023.0 |
870 | 2024-03-31 20:16:20 | prefires | 2 | 121059 | 41 | 13.423 | 9018.8 |
869 | 2024-03-31 20:16:13 | prefires | 1 | 82945 | 7 | 1.720 | 48223.8 |
868 | 2024-03-31 20:15:57 | prefires | 2 | 121059 | 41 | 4.610 | 26260.1 |
867 | 2024-03-31 19:59:04 | prefires | 3 | 146162 | 335 | 17.750 | 8234.5 |
866 | 2024-03-31 11:35:40 | prefires | 3 | 146162 | 335 | 16.970 | 8613.0 |
865 | 2024-03-31 03:44:13 | prefires | 3 | 146162 | 335 | 14.300 | 10221.1 |
864 | 2024-03-31 00:27:34 | prefires | 3 | 146162 | 335 | 17.873 | 8177.8 |
863 | 2024-03-31 00:27:30 | prefires | 2 | 121059 | 41 | 15.780 | 7671.7 |
862 | 2024-03-30 23:46:58 | prefires | 1 | 82945 | 7 | 3.216 | 25791.4 |
861 | 2024-03-25 22:58:24 | prefires | 1 | 82945 | 7 | 2.986 | 27778.0 |
860 | 2024-03-22 10:32:30 | prefires | 1 | 82945 | 7 | 2.920 | 28405.8 |
859 | 2024-03-07 16:57:52 | prefires | 3 | 146162 | 335 | 7.200 | 20300.3 |
858 | 2024-03-06 05:49:50 | prefires | 3 | 146162 | 335 | 35.673 | 4097.3 |
857 | 2024-02-29 14:46:11 | prefires | 1 | 82945 | 7 | 1.423 | 58288.8 |
856 | 2024-02-28 20:52:08 | prefires | 3 | 146162 | 335 | 12.126 | 12053.6 |
855 | 2024-02-27 05:13:01 | prefires | 3 | 146162 | 335 | 15.873 | 9208.2 |
854 | 2024-02-27 05:12:50 | prefires | 2 | 121059 | 41 | 4.156 | 29128.7 |
853 | 2024-02-25 22:38:38 | prefires | 2 | 121059 | 41 | 4.326 | 27984.0 |
852 | 2024-02-25 22:38:35 | prefires | 1 | 82945 | 7 | 1.626 | 51011.7 |
851 | 2024-02-16 21:20:42 | prefires | 3 | 146162 | 335 | 8.360 | 17483.5 |
850 | 2024-01-29 12:53:39 | prefires | 1 | 82945 | 7 | 1.500 | 55296.7 |
849 | 2024-01-29 01:49:41 | prefires | 3 | 146162 | 335 | 11.483 | 12728.6 |
848 | 2024-01-27 18:59:43 | prefires | 3 | 146162 | 335 | 6.500 | 22486.5 |
847 | 2024-01-21 22:49:48 | prefires | 3 | 146162 | 335 | 7.450 | 19619.1 |
846 | 2024-01-20 03:51:37 | prefires | 3 | 146162 | 335 | 6.466 | 22604.7 |
845 | 2024-01-19 06:44:21 | prefires | 3 | 146162 | 335 | 6.966 | 20982.2 |
844 | 2024-01-18 18:16:03 | prefires | 3 | 146162 | 335 | 7.533 | 19402.9 |
843 | 2024-01-18 13:45:30 | prefires | 3 | 146162 | 335 | 7.156 | 20425.1 |
842 | 2024-01-17 16:39:38 | prefires | 3 | 146162 | 335 | 6.750 | 21653.6 |
841 | 2024-01-12 20:34:48 | prefires | 3 | 146162 | 335 | 6.393 | 22862.8 |
840 | 2024-01-09 02:14:15 | prefires | 3 | 146162 | 335 | 6.826 | 21412.5 |
839 | 2024-01-06 21:54:09 | prefires | 2 | 121059 | 41 | 3.390 | 35710.6 |
838 | 2023-12-21 08:31:54 | prefires | 1 | 82945 | 7 | 1.483 | 55930.5 |
837 | 2023-12-20 02:00:14 | prefires | 3 | 146162 | 335 | 7.233 | 20207.7 |
836 | 2023-12-18 05:43:53 | prefires | 1 | 82945 | 7 | 1.296 | 64000.8 |
835 | 2023-12-18 03:15:35 | prefires | 1 | 82945 | 7 | 2.453 | 33813.7 |
834 | 2023-12-14 05:15:31 | prefires | 2 | 121059 | 41 | 3.330 | 36354.1 |
833 | 2023-12-13 07:31:54 | prefires | 3 | 146162 | 335 | 7.643 | 19123.6 |
832 | 2023-12-09 09:49:20 | prefires | 3 | 146162 | 335 | 6.736 | 21698.6 |
831 | 2023-11-19 00:57:21 | prefires | 1 | 82945 | 7 | 1.516 | 54713.1 |
830 | 2023-11-14 08:05:18 | prefires | 1 | 82945 | 7 | 1.296 | 64000.8 |
829 | 2023-11-11 00:00:44 | prefires | 3 | 146162 | 335 | 15.470 | 9448.1 |
828 | 2023-11-03 07:47:30 | prefires | 3 | 146162 | 335 | 6.766 | 21602.4 |
827 | 2023-10-31 19:00:53 | prefires | 1 | 82945 | 7 | 4.966 | 16702.6 |
826 | 2023-10-23 05:24:49 | prefires | 1 | 82945 | 7 | 1.436 | 57761.1 |
825 | 2023-10-20 15:16:47 | prefires | 3 | 146162 | 335 | 6.703 | 21805.5 |
824 | 2023-10-17 09:37:03 | prefires | 1 | 82945 | 7 | 2.983 | 27805.9 |
823 | 2023-10-08 19:57:16 | prefires | 1 | 82945 | 7 | 1.373 | 60411.5 |
822 | 2023-10-05 16:07:34 | prefires | 1 | 82945 | 7 | 1.296 | 64000.8 |
821 | 2023-09-25 19:26:38 | prefires | 1 | 82945 | 7 | 1.423 | 58288.8 |
820 | 2023-09-14 21:23:57 | prefires | 1 | 82945 | 7 | 1.326 | 62552.8 |
819 | 2023-09-10 13:36:00 | prefires | 2 | 121059 | 41 | 6.983 | 17336.2 |
818 | 2023-09-04 00:34:29 | prefires | 3 | 146162 | 335 | 6.843 | 21359.3 |
817 | 2023-09-02 22:21:39 | prefires | 3 | 146162 | 335 | 6.720 | 21750.3 |
816 | 2023-09-01 06:02:06 | prefires | 3 | 146162 | 335 | 6.330 | 23090.4 |
815 | 2023-08-30 03:12:33 | prefires | 3 | 146162 | 335 | 14.280 | 10235.4 |
814 | 2023-08-28 08:29:01 | prefires | 3 | 146162 | 335 | 6.966 | 20982.2 |
813 | 2023-08-25 07:11:10 | prefires | 1 | 82945 | 7 | 1.453 | 57085.3 |
812 | 2023-08-23 14:47:30 | prefires | 3 | 146162 | 335 | 7.763 | 18828.0 |
811 | 2023-08-20 11:21:59 | prefires | 3 | 146162 | 335 | 7.656 | 19091.2 |
810 | 2023-08-18 14:37:35 | prefires | 3 | 146162 | 335 | 6.376 | 22923.8 |
809 | 2023-08-14 03:25:33 | prefires | 3 | 146162 | 335 | 7.190 | 20328.5 |
808 | 2023-08-12 13:28:55 | prefires | 3 | 146162 | 335 | 7.360 | 19859.0 |
807 | 2023-08-11 08:34:24 | prefires | 3 | 146162 | 335 | 6.403 | 22827.1 |
806 | 2023-08-01 03:18:21 | prefires | 3 | 146162 | 335 | 6.296 | 23215.1 |
805 | 2023-08-01 02:05:31 | prefires | 1 | 82945 | 7 | 1.283 | 64649.3 |
804 | 2023-07-29 01:24:58 | prefires | 3 | 146162 | 335 | 7.906 | 18487.5 |
803 | 2023-07-27 08:13:46 | prefires | 3 | 146162 | 335 | 7.046 | 20744.0 |
802 | 2023-07-26 13:44:31 | prefires | 3 | 146162 | 335 | 6.373 | 22934.6 |
801 | 2023-07-25 19:38:16 | prefires | 3 | 146162 | 335 | 6.440 | 22696.0 |
800 | 2023-07-24 20:54:16 | prefires | 3 | 146162 | 335 | 6.686 | 21860.9 |
799 | 2023-07-23 05:21:00 | prefires | 3 | 146162 | 335 | 7.313 | 19986.6 |
798 | 2023-07-21 03:05:18 | prefires | 3 | 146162 | 335 | 6.563 | 22270.6 |
797 | 2023-07-19 21:12:51 | prefires | 3 | 146162 | 335 | 7.266 | 20115.9 |
796 | 2023-05-25 22:12:44 | prefires | 2 | 121059 | 41 | 3.186 | 37997.2 |
795 | 2023-05-18 17:51:39 | prefires | 1 | 82945 | 7 | 1.313 | 63172.1 |
794 | 2023-04-26 09:07:40 | prefires | 1 | 82945 | 7 | 1.280 | 64800.8 |
793 | 2023-04-21 13:14:16 | prefires | 3 | 146162 | 335 | 6.563 | 22270.6 |
792 | 2023-04-21 01:25:11 | prefires | 1 | 82945 | 7 | 1.330 | 62364.7 |
791 | 2023-04-07 02:56:23 | prefires | 3 | 146162 | 335 | 6.266 | 23326.2 |
790 | 2023-03-21 07:01:59 | prefires | 1 | 82945 | 7 | 1.296 | 64000.8 |
789 | 2023-03-04 20:31:37 | prefires | 2 | 121059 | 41 | 3.173 | 38152.9 |
788 | 2023-02-16 08:10:39 | prefires | 1 | 82945 | 7 | 1.263 | 65673.0 |
787 | 2023-02-12 13:00:51 | prefires | 1 | 82945 | 7 | 1.280 | 64800.8 |
786 | 2023-02-09 01:35:08 | prefires | 1 | 82945 | 7 | 1.263 | 65673.0 |
785 | 2023-02-01 10:40:15 | prefires | 3 | 146162 | 335 | 8.046 | 18165.8 |
784 | 2023-01-31 04:01:25 | prefires | 3 | 146162 | 335 | 7.783 | 18779.6 |
783 | 2023-01-30 05:48:05 | prefires | 3 | 146162 | 335 | 7.436 | 19656.0 |
782 | 2023-01-29 08:34:18 | prefires | 3 | 146162 | 335 | 8.470 | 17256.4 |
781 | 2023-01-28 10:13:22 | prefires | 3 | 146162 | 335 | 7.750 | 18859.6 |
780 | 2023-01-05 03:37:37 | prefires | 3 | 146162 | 335 | 7.673 | 19048.9 |
779 | 2022-12-13 23:20:32 | prefires | 1 | 82945 | 7 | 1.420 | 58412.0 |
778 | 2022-12-13 06:33:01 | prefires | 2 | 121059 | 41 | 5.030 | 24067.4 |
777 | 2022-12-01 19:30:42 | prefires | 3 | 146162 | 335 | 7.300 | 20022.2 |
776 | 2022-11-28 12:27:39 | prefires | 3 | 146162 | 335 | 7.500 | 19488.3 |
775 | 2022-10-26 02:42:31 | prefires | 1 | 82945 | 7 | 1.283 | 64649.3 |
774 | 2022-09-14 23:11:36 | prefires | 3 | 146162 | 335 | 8.983 | 16271.0 |
773 | 2022-09-14 03:09:58 | prefires | 3 | 146162 | 335 | 6.403 | 22827.1 |