History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lighting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
893 | 2024-05-15 02:09:10 | lighting | 3 | 146162 | 241 | 18.393 | 7946.6 |
892 | 2024-05-14 08:14:43 | lighting | 2 | 121059 | 40 | 3.860 | 31362.4 |
891 | 2024-05-14 08:13:30 | lighting | 3 | 146162 | 241 | 7.626 | 19166.3 |
890 | 2024-05-11 16:01:09 | lighting | 3 | 146162 | 241 | 14.563 | 10036.5 |
889 | 2024-05-11 02:46:30 | lighting | 3 | 146162 | 241 | 25.550 | 5720.6 |
888 | 2024-05-11 02:46:24 | lighting | 2 | 121059 | 40 | 8.686 | 13937.3 |
887 | 2024-05-10 19:10:22 | lighting | 3 | 146162 | 241 | 19.360 | 7549.7 |
886 | 2024-05-09 15:29:58 | lighting | 3 | 146162 | 241 | 18.280 | 7995.7 |
885 | 2024-05-09 15:29:59 | lighting | 2 | 121059 | 40 | 8.310 | 14567.9 |
884 | 2024-05-09 14:23:40 | lighting | 1 | 82945 | 16 | 1.283 | 64649.3 |
883 | 2024-05-02 13:35:58 | lighting | 1 | 82945 | 16 | 1.313 | 63172.1 |
882 | 2024-04-25 14:37:17 | lighting | 1 | 82945 | 16 | 1.360 | 60989.0 |
881 | 2024-04-14 12:19:14 | lighting | 1 | 82945 | 16 | 4.406 | 18825.5 |
880 | 2024-04-14 09:21:21 | lighting | 1 | 82945 | 16 | 1.313 | 63172.1 |
879 | 2024-04-08 07:37:28 | lighting | 1 | 82945 | 16 | 1.403 | 59119.7 |
878 | 2024-04-05 09:14:45 | lighting | 1 | 82945 | 16 | 1.610 | 51518.6 |
877 | 2024-03-30 19:55:11 | lighting | 1 | 82945 | 16 | 3.046 | 27230.8 |
876 | 2024-03-19 17:38:13 | lighting | 1 | 82945 | 16 | 3.220 | 25759.3 |
875 | 2024-03-13 22:16:45 | lighting | 1 | 82945 | 16 | 1.610 | 51518.6 |
874 | 2024-03-01 17:31:38 | lighting | 2 | 121059 | 40 | 7.483 | 16177.9 |
873 | 2024-03-01 17:30:39 | lighting | 3 | 146162 | 241 | 23.000 | 6354.9 |
872 | 2024-02-29 12:26:45 | lighting | 2 | 121059 | 40 | 3.763 | 32170.9 |
871 | 2024-02-29 12:26:34 | lighting | 3 | 146162 | 241 | 6.360 | 22981.4 |
870 | 2024-02-29 05:40:04 | lighting | 1 | 82945 | 16 | 1.406 | 58993.6 |
869 | 2024-02-28 03:23:53 | lighting | 1 | 82945 | 16 | 1.450 | 57203.4 |
868 | 2024-02-27 05:28:53 | lighting | 3 | 146162 | 241 | 8.156 | 17920.8 |
867 | 2024-02-27 05:28:51 | lighting | 2 | 121059 | 40 | 3.813 | 31749.0 |
866 | 2024-02-26 20:53:10 | lighting | 3 | 146162 | 241 | 8.156 | 17920.8 |
865 | 2024-02-26 20:53:10 | lighting | 2 | 121059 | 40 | 6.096 | 19858.8 |
864 | 2024-02-26 20:53:05 | lighting | 1 | 82945 | 16 | 1.483 | 55930.5 |
863 | 2024-01-12 06:53:36 | lighting | 1 | 82945 | 16 | 1.330 | 62364.7 |
862 | 2024-01-08 08:00:54 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
861 | 2023-12-29 21:02:39 | lighting | 1 | 82945 | 16 | 1.596 | 51970.6 |
860 | 2023-12-22 22:16:32 | lighting | 1 | 82945 | 16 | 1.296 | 64000.8 |
859 | 2023-12-21 22:01:00 | lighting | 1 | 82945 | 16 | 1.373 | 60411.5 |
858 | 2023-12-19 17:39:37 | lighting | 3 | 146162 | 241 | 6.483 | 22545.4 |
857 | 2023-12-19 17:39:39 | lighting | 2 | 121059 | 40 | 3.533 | 34265.2 |
856 | 2023-12-05 22:55:07 | lighting | 1 | 82945 | 16 | 1.266 | 65517.4 |
855 | 2023-11-24 19:16:49 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
854 | 2023-11-23 16:04:37 | lighting | 1 | 82945 | 16 | 1.296 | 64000.8 |
853 | 2023-11-02 08:00:20 | lighting | 1 | 82945 | 16 | 1.500 | 55296.7 |
852 | 2023-11-01 23:39:51 | lighting | 1 | 82945 | 16 | 1.453 | 57085.3 |
851 | 2023-10-31 18:55:11 | lighting | 1 | 82945 | 16 | 1.406 | 58993.6 |
850 | 2023-10-29 12:18:12 | lighting | 1 | 82945 | 16 | 1.436 | 57761.1 |
849 | 2023-10-03 22:24:23 | lighting | 1 | 82945 | 16 | 1.266 | 65517.4 |
848 | 2023-10-01 18:09:42 | lighting | 1 | 82945 | 16 | 1.280 | 64800.8 |
847 | 2023-09-29 15:42:58 | lighting | 1 | 82945 | 16 | 1.376 | 60279.8 |
846 | 2023-09-20 06:31:50 | lighting | 1 | 82945 | 16 | 1.470 | 56425.2 |
845 | 2023-09-19 08:46:50 | lighting | 1 | 82945 | 16 | 1.253 | 66197.1 |
844 | 2023-09-16 01:44:42 | lighting | 1 | 82945 | 16 | 1.406 | 58993.6 |
843 | 2023-09-16 00:19:37 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
842 | 2023-09-09 17:00:46 | lighting | 1 | 82945 | 16 | 1.440 | 57600.7 |
841 | 2023-09-08 05:15:09 | lighting | 1 | 82945 | 16 | 1.266 | 65517.4 |
840 | 2023-08-30 04:53:14 | lighting | 1 | 82945 | 16 | 1.376 | 60279.8 |
839 | 2023-08-28 17:13:23 | lighting | 1 | 82945 | 16 | 1.266 | 65517.4 |
838 | 2023-08-27 03:34:48 | lighting | 1 | 82945 | 16 | 1.233 | 67270.9 |
837 | 2023-08-26 06:14:15 | lighting | 1 | 82945 | 16 | 1.253 | 66197.1 |
836 | 2023-08-25 04:15:49 | lighting | 1 | 82945 | 16 | 4.046 | 20500.5 |
835 | 2023-08-13 12:54:26 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
834 | 2023-08-10 14:59:32 | lighting | 1 | 82945 | 16 | 1.296 | 64000.8 |
833 | 2023-08-10 06:52:18 | lighting | 1 | 82945 | 16 | 1.263 | 65673.0 |
832 | 2023-08-08 08:49:56 | lighting | 1 | 82945 | 16 | 1.360 | 60989.0 |
831 | 2023-07-30 20:39:50 | lighting | 1 | 82945 | 16 | 1.406 | 58993.6 |
830 | 2023-07-29 19:34:54 | lighting | 1 | 82945 | 16 | 1.330 | 62364.7 |
829 | 2023-07-28 16:55:02 | lighting | 1 | 82945 | 16 | 1.436 | 57761.1 |
828 | 2023-07-27 12:03:53 | lighting | 1 | 82945 | 16 | 1.436 | 57761.1 |
827 | 2023-07-26 16:17:19 | lighting | 1 | 82945 | 16 | 1.343 | 61761.0 |
826 | 2023-07-25 02:05:36 | lighting | 1 | 82945 | 16 | 1.516 | 54713.1 |
825 | 2023-07-23 03:27:23 | lighting | 1 | 82945 | 16 | 1.423 | 58288.8 |
824 | 2023-07-20 21:33:18 | lighting | 1 | 82945 | 16 | 1.326 | 62552.8 |
823 | 2023-07-18 22:57:00 | lighting | 1 | 82945 | 16 | 1.393 | 59544.1 |
822 | 2023-05-29 22:50:19 | lighting | 1 | 82945 | 16 | 1.236 | 67107.6 |
821 | 2023-05-28 12:15:08 | lighting | 1 | 82945 | 16 | 1.280 | 64800.8 |
820 | 2023-05-07 22:49:59 | lighting | 1 | 82945 | 16 | 1.346 | 61623.3 |
819 | 2023-05-07 02:03:40 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
818 | 2023-05-06 06:16:23 | lighting | 1 | 82945 | 16 | 1.280 | 64800.8 |
817 | 2023-05-05 13:50:35 | lighting | 1 | 82945 | 16 | 1.203 | 68948.5 |
816 | 2023-05-04 18:25:36 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
815 | 2023-05-03 16:41:36 | lighting | 1 | 82945 | 16 | 1.313 | 63172.1 |
814 | 2023-05-02 07:02:25 | lighting | 1 | 82945 | 16 | 1.263 | 65673.0 |
813 | 2023-03-22 13:34:15 | lighting | 1 | 82945 | 16 | 1.220 | 67987.7 |
812 | 2023-02-13 18:24:48 | lighting | 1 | 82945 | 16 | 1.236 | 67107.6 |
811 | 2023-01-08 18:08:37 | lighting | 1 | 82945 | 16 | 1.390 | 59672.7 |
810 | 2022-12-27 23:50:24 | lighting | 1 | 82945 | 16 | 1.406 | 58993.6 |
809 | 2022-12-24 17:15:05 | lighting | 1 | 82945 | 16 | 1.376 | 60279.8 |
808 | 2022-12-19 22:54:14 | lighting | 1 | 82945 | 16 | 1.390 | 59672.7 |
807 | 2022-12-18 13:43:20 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
806 | 2022-12-17 18:16:40 | lighting | 1 | 82945 | 16 | 1.466 | 56579.1 |
805 | 2022-12-16 23:20:12 | lighting | 1 | 82945 | 16 | 1.470 | 56425.2 |
804 | 2022-12-15 22:30:29 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
803 | 2022-12-13 15:31:57 | lighting | 1 | 82945 | 16 | 1.423 | 58288.8 |
802 | 2022-12-12 19:54:56 | lighting | 1 | 82945 | 16 | 1.656 | 50087.6 |
801 | 2022-12-11 14:02:45 | lighting | 1 | 82945 | 16 | 1.250 | 66356.0 |
800 | 2022-12-09 15:59:24 | lighting | 1 | 82945 | 16 | 1.406 | 58993.6 |
799 | 2022-12-08 23:47:16 | lighting | 1 | 82945 | 16 | 1.436 | 57761.1 |
798 | 2022-10-27 10:22:38 | lighting | 1 | 82945 | 16 | 1.373 | 60411.5 |
797 | 2022-10-18 22:58:56 | lighting | 1 | 82945 | 16 | 1.263 | 65673.0 |
796 | 2022-10-17 22:54:07 | lighting | 1 | 82945 | 16 | 1.376 | 60279.8 |
795 | 2022-10-16 22:48:31 | lighting | 1 | 82945 | 16 | 1.360 | 60989.0 |
794 | 2022-10-14 22:41:36 | lighting | 1 | 82945 | 16 | 1.233 | 67270.9 |