History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shooting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
916 | 2024-04-07 18:45:07 | shooting | 3 | 146162 | 511 | 16.080 | 9089.7 |
915 | 2024-04-06 14:02:19 | shooting | 3 | 146162 | 511 | 22.173 | 6591.9 |
914 | 2024-04-06 12:36:42 | shooting | 3 | 146162 | 511 | 21.580 | 6773.0 |
913 | 2024-03-30 23:26:13 | shooting | 3 | 146162 | 511 | 14.313 | 10211.8 |
912 | 2024-03-30 10:25:41 | shooting | 3 | 146162 | 511 | 12.890 | 11339.2 |
911 | 2024-03-30 07:15:05 | shooting | 3 | 146162 | 511 | 8.626 | 16944.4 |
910 | 2024-03-30 07:14:59 | shooting | 1 | 82945 | 11 | 3.343 | 24811.5 |
909 | 2024-03-08 21:11:37 | shooting | 1 | 82945 | 11 | 1.516 | 54713.1 |
908 | 2024-03-07 04:49:37 | shooting | 2 | 121059 | 78 | 8.393 | 14423.8 |
907 | 2024-03-07 02:07:50 | shooting | 1 | 82945 | 11 | 1.470 | 56425.2 |
906 | 2024-03-06 23:32:43 | shooting | 3 | 146162 | 511 | 18.440 | 7926.4 |
905 | 2024-03-06 09:15:55 | shooting | 3 | 146162 | 511 | 9.156 | 15963.5 |
904 | 2024-03-05 06:14:05 | shooting | 3 | 146162 | 511 | 6.186 | 23627.9 |
903 | 2024-03-01 04:44:04 | shooting | 3 | 146162 | 511 | 8.096 | 18053.6 |
902 | 2024-03-01 04:44:07 | shooting | 2 | 121059 | 78 | 3.670 | 32986.1 |
901 | 2024-02-28 11:28:26 | shooting | 1 | 82945 | 11 | 1.466 | 56579.1 |
900 | 2024-02-22 09:42:41 | shooting | 2 | 121059 | 78 | 4.700 | 25757.2 |
899 | 2024-02-22 09:42:10 | shooting | 3 | 146162 | 511 | 7.456 | 19603.3 |
898 | 2024-02-18 08:48:47 | shooting | 3 | 146162 | 511 | 19.986 | 7313.2 |
897 | 2024-02-15 23:39:15 | shooting | 3 | 146162 | 511 | 17.656 | 8278.3 |
896 | 2024-01-30 09:27:45 | shooting | 2 | 121059 | 78 | 4.596 | 26340.1 |
895 | 2024-01-30 09:26:37 | shooting | 3 | 146162 | 511 | 7.516 | 19446.8 |
894 | 2024-01-23 03:53:02 | shooting | 3 | 146162 | 511 | 8.936 | 16356.5 |
893 | 2024-01-16 05:18:04 | shooting | 1 | 82945 | 11 | 1.310 | 63316.8 |
892 | 2024-01-14 21:39:49 | shooting | 2 | 121059 | 78 | 6.423 | 18847.7 |
891 | 2024-01-10 02:41:08 | shooting | 3 | 146162 | 511 | 7.563 | 19325.9 |
890 | 2023-12-31 00:24:27 | shooting | 3 | 146162 | 511 | 6.576 | 22226.6 |
889 | 2023-12-25 09:16:11 | shooting | 1 | 82945 | 11 | 1.470 | 56425.2 |
888 | 2023-12-12 14:25:51 | shooting | 3 | 146162 | 511 | 7.406 | 19735.6 |
887 | 2023-12-08 02:11:39 | shooting | 2 | 121059 | 78 | 4.923 | 24590.5 |
886 | 2023-12-02 11:33:18 | shooting | 1 | 82945 | 11 | 1.423 | 58288.8 |
885 | 2023-11-30 03:46:55 | shooting | 1 | 82945 | 11 | 1.406 | 58993.6 |
884 | 2023-11-25 02:03:33 | shooting | 3 | 146162 | 511 | 6.280 | 23274.2 |
883 | 2023-11-19 12:50:23 | shooting | 3 | 146162 | 511 | 7.876 | 18557.9 |
882 | 2023-11-10 22:39:42 | shooting | 1 | 82945 | 11 | 1.470 | 56425.2 |
881 | 2023-11-09 11:57:57 | shooting | 2 | 121059 | 78 | 3.283 | 36874.5 |
880 | 2023-11-06 02:32:24 | shooting | 1 | 82945 | 11 | 1.406 | 58993.6 |
879 | 2023-11-05 18:08:23 | shooting | 1 | 82945 | 11 | 1.436 | 57761.1 |
878 | 2023-11-01 04:32:13 | shooting | 3 | 146162 | 511 | 7.936 | 18417.6 |
877 | 2023-10-27 00:39:31 | shooting | 1 | 82945 | 11 | 1.280 | 64800.8 |
876 | 2023-10-21 18:20:54 | shooting | 3 | 146162 | 511 | 7.250 | 20160.3 |
875 | 2023-10-21 06:50:34 | shooting | 3 | 146162 | 511 | 8.110 | 18022.4 |
874 | 2023-10-17 13:03:42 | shooting | 3 | 146162 | 511 | 7.206 | 20283.4 |
873 | 2023-10-14 10:39:04 | shooting | 1 | 82945 | 11 | 1.453 | 57085.3 |
872 | 2023-10-14 06:23:25 | shooting | 3 | 146162 | 511 | 6.483 | 22545.4 |
871 | 2023-10-12 06:14:12 | shooting | 3 | 146162 | 511 | 6.033 | 24227.1 |
870 | 2023-10-12 03:18:44 | shooting | 3 | 146162 | 511 | 7.486 | 19524.7 |
869 | 2023-10-11 15:57:06 | shooting | 3 | 146162 | 511 | 8.390 | 17421.0 |
868 | 2023-10-07 04:09:14 | shooting | 1 | 82945 | 11 | 1.486 | 55817.6 |
867 | 2023-10-06 15:23:32 | shooting | 3 | 146162 | 511 | 26.550 | 5505.2 |
866 | 2023-10-01 19:36:32 | shooting | 3 | 146162 | 511 | 8.593 | 17009.4 |
865 | 2023-09-28 22:28:42 | shooting | 3 | 146162 | 511 | 6.970 | 20970.2 |
864 | 2023-09-26 17:03:31 | shooting | 3 | 146162 | 511 | 6.563 | 22270.6 |
863 | 2023-09-11 13:57:38 | shooting | 1 | 82945 | 11 | 1.296 | 64000.8 |
862 | 2023-08-29 10:41:03 | shooting | 1 | 82945 | 11 | 1.266 | 65517.4 |
861 | 2023-08-24 16:58:51 | shooting | 3 | 146162 | 511 | 6.843 | 21359.3 |
860 | 2023-07-26 00:00:16 | shooting | 3 | 146162 | 511 | 6.936 | 21073.0 |
859 | 2023-07-10 10:58:22 | shooting | 1 | 82945 | 11 | 1.250 | 66356.0 |
858 | 2023-06-10 07:26:30 | shooting | 3 | 146162 | 511 | 6.623 | 22068.9 |
857 | 2023-06-02 07:43:30 | shooting | 1 | 82945 | 11 | 1.236 | 67107.6 |
856 | 2023-05-10 17:19:46 | shooting | 3 | 146162 | 511 | 6.500 | 22486.5 |
855 | 2023-05-05 10:04:12 | shooting | 3 | 146162 | 511 | 6.436 | 22710.1 |
854 | 2023-04-06 10:40:45 | shooting | 3 | 146162 | 511 | 7.393 | 19770.3 |
853 | 2023-03-24 05:02:45 | shooting | 1 | 82945 | 11 | 1.376 | 60279.8 |
852 | 2023-03-23 00:08:10 | shooting | 1 | 82945 | 11 | 1.470 | 56425.2 |
851 | 2023-03-19 18:46:58 | shooting | 1 | 82945 | 11 | 1.266 | 65517.4 |
850 | 2023-02-19 17:34:42 | shooting | 3 | 146162 | 511 | 6.533 | 22372.9 |
849 | 2023-01-08 06:19:30 | shooting | 1 | 82945 | 11 | 1.420 | 58412.0 |
848 | 2022-11-30 18:46:56 | shooting | 3 | 146162 | 511 | 6.046 | 24175.0 |
847 | 2022-11-21 15:26:44 | shooting | 1 | 82945 | 11 | 1.533 | 54106.3 |
846 | 2022-10-06 05:22:17 | shooting | 1 | 82945 | 11 | 1.546 | 53651.4 |
845 | 2022-09-01 21:11:28 | shooting | 3 | 146162 | 511 | 6.253 | 23374.7 |
844 | 2022-09-01 09:54:32 | shooting | 1 | 82945 | 11 | 1.436 | 57761.1 |
843 | 2022-08-08 20:40:46 | shooting | 3 | 146162 | 511 | 7.403 | 19743.6 |
842 | 2022-08-01 07:26:47 | shooting | 1 | 82945 | 11 | 1.313 | 63172.1 |
841 | 2022-07-30 23:54:32 | shooting | 3 | 146162 | 511 | 6.300 | 23200.3 |
840 | 2022-07-29 08:40:51 | shooting | 1 | 82945 | 11 | 1.296 | 64000.8 |
839 | 2022-07-28 20:04:52 | shooting | 1 | 82945 | 11 | 1.296 | 64000.8 |
838 | 2022-07-07 00:50:38 | shooting | 3 | 146162 | 511 | 6.203 | 23563.1 |
837 | 2022-06-02 08:48:31 | shooting | 1 | 82945 | 11 | 1.343 | 61761.0 |
836 | 2022-05-22 10:08:06 | shooting | 1 | 82945 | 11 | 1.326 | 62552.8 |
835 | 2022-05-08 03:01:18 | shooting | 1 | 82945 | 11 | 1.500 | 55296.7 |
834 | 2022-05-05 15:59:21 | shooting | 3 | 146162 | 511 | 6.940 | 21060.8 |
833 | 2022-05-04 15:37:08 | shooting | 1 | 82945 | 11 | 1.453 | 57085.3 |
832 | 2022-04-24 11:02:42 | shooting | 3 | 146162 | 511 | 6.266 | 23326.2 |
831 | 2022-04-23 09:48:26 | shooting | 3 | 146162 | 511 | 6.906 | 21164.5 |
830 | 2022-04-06 18:55:25 | shooting | 1 | 82945 | 11 | 1.436 | 57761.1 |
829 | 2022-03-18 03:33:01 | shooting | 3 | 146162 | 511 | 6.516 | 22431.2 |
828 | 2022-02-07 22:39:49 | shooting | 3 | 146162 | 511 | 6.313 | 23152.5 |
827 | 2022-02-03 20:14:12 | shooting | 1 | 82945 | 11 | 1.500 | 55296.7 |
826 | 2021-12-22 20:42:03 | shooting | 1 | 82945 | 11 | 1.546 | 53651.4 |
825 | 2021-11-23 13:49:03 | shooting | 1 | 82945 | 11 | 1.516 | 54713.1 |
824 | 2021-11-21 12:24:02 | shooting | 1 | 82945 | 11 | 1.313 | 63172.1 |
823 | 2021-11-10 02:01:11 | shooting | 1 | 82945 | 11 | 1.300 | 63803.8 |
822 | 2021-10-07 06:08:09 | shooting | 1 | 82945 | 11 | 1.436 | 57761.1 |
821 | 2021-10-05 03:11:49 | shooting | 1 | 82945 | 11 | 1.283 | 64649.3 |
820 | 2021-09-18 03:20:53 | shooting | 1 | 82945 | 11 | 1.406 | 58993.6 |
819 | 2021-09-15 14:51:41 | shooting | 1 | 82945 | 11 | 1.500 | 55296.7 |
818 | 2021-07-28 12:10:48 | shooting | 3 | 146162 | 511 | 12.236 | 11945.2 |
817 | 2021-07-27 12:13:58 | shooting | 3 | 146162 | 511 | 6.436 | 22710.1 |