History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assay"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
938 | 2024-04-23 21:35:08 | assay | 3 | 83667 | 710 | 9.906 | 8446.1 |
937 | 2024-04-23 16:35:27 | assay | 1 | 28756 | 4 | 1.106 | 26000.0 |
936 | 2024-04-05 23:59:01 | assay | 3 | 83667 | 710 | 13.596 | 6153.8 |
935 | 2024-04-05 23:58:54 | assay | 2 | 53800 | 43 | 5.966 | 9017.8 |
934 | 2024-04-05 23:22:29 | assay | 1 | 28756 | 4 | 0.530 | 54256.6 |
933 | 2024-04-01 16:50:43 | assay | 3 | 83667 | 710 | 12.000 | 6972.3 |
932 | 2024-03-31 13:51:53 | assay | 3 | 83667 | 710 | 12.250 | 6830.0 |
931 | 2024-03-31 13:48:57 | assay | 1 | 28756 | 4 | 1.296 | 22188.3 |
930 | 2024-03-31 07:49:24 | assay | 2 | 53800 | 43 | 1.906 | 28226.7 |
929 | 2024-03-30 04:36:47 | assay | 2 | 53800 | 43 | 5.873 | 9160.6 |
928 | 2024-03-30 04:36:14 | assay | 3 | 83667 | 710 | 7.703 | 10861.6 |
927 | 2024-03-29 03:43:15 | assay | 3 | 83667 | 710 | 5.906 | 14166.4 |
926 | 2024-03-29 03:43:10 | assay | 1 | 28756 | 4 | 0.560 | 51350.0 |
925 | 2024-03-29 03:43:01 | assay | 3 | 83667 | 710 | 5.313 | 15747.6 |
924 | 2024-03-29 03:43:01 | assay | 2 | 53800 | 43 | 3.796 | 14172.8 |
923 | 2024-03-29 03:43:00 | assay | 1 | 28756 | 4 | 1.563 | 18398.0 |
922 | 2024-03-06 22:23:02 | assay | 3 | 83667 | 710 | 14.300 | 5850.8 |
921 | 2024-03-06 22:23:05 | assay | 2 | 53800 | 43 | 4.030 | 13349.9 |
920 | 2024-03-06 19:30:17 | assay | 1 | 28756 | 4 | 0.530 | 54256.6 |
919 | 2024-03-02 03:04:41 | assay | 2 | 53800 | 43 | 3.873 | 13891.0 |
918 | 2024-03-01 11:50:06 | assay | 1 | 28756 | 4 | 0.623 | 46157.3 |
917 | 2024-03-01 05:33:05 | assay | 2 | 53800 | 43 | 1.813 | 29674.6 |
916 | 2024-03-01 05:32:45 | assay | 3 | 83667 | 710 | 4.486 | 18650.7 |
915 | 2024-02-28 13:13:00 | assay | 3 | 83667 | 710 | 9.123 | 9171.0 |
914 | 2024-02-28 12:53:29 | assay | 2 | 53800 | 43 | 1.733 | 31044.4 |
913 | 2024-02-28 02:42:07 | assay | 3 | 83667 | 710 | 10.283 | 8136.4 |
912 | 2024-02-28 02:39:23 | assay | 3 | 83667 | 710 | 6.173 | 13553.7 |
911 | 2024-02-28 02:39:25 | assay | 2 | 53800 | 43 | 3.783 | 14221.5 |
910 | 2024-02-28 02:37:06 | assay | 1 | 28756 | 4 | 0.826 | 34813.6 |
909 | 2024-02-22 02:34:00 | assay | 1 | 28756 | 4 | 0.563 | 51076.4 |
908 | 2024-02-03 18:19:11 | assay | 1 | 28756 | 4 | 0.530 | 54256.6 |
907 | 2024-01-29 03:07:59 | assay | 1 | 28756 | 4 | 0.516 | 55728.7 |
906 | 2024-01-29 02:28:05 | assay | 1 | 28756 | 4 | 0.516 | 55728.7 |
905 | 2024-01-22 03:30:28 | assay | 1 | 28756 | 4 | 0.670 | 42919.4 |
904 | 2024-01-12 09:20:32 | assay | 2 | 53800 | 43 | 1.706 | 31535.8 |
903 | 2023-12-31 00:53:47 | assay | 1 | 28756 | 4 | 0.470 | 61183.0 |
902 | 2023-12-30 00:10:45 | assay | 3 | 83667 | 710 | 3.563 | 23482.2 |
901 | 2023-12-30 00:10:42 | assay | 2 | 53800 | 43 | 1.440 | 37361.1 |
900 | 2023-12-08 11:15:46 | assay | 1 | 28756 | 4 | 0.500 | 57512.0 |
899 | 2023-12-08 11:15:45 | assay | 1 | 28756 | 4 | 0.610 | 47141.0 |
898 | 2023-12-07 14:08:49 | assay | 2 | 53800 | 43 | 1.673 | 32157.8 |
897 | 2023-12-07 14:08:47 | assay | 2 | 53800 | 43 | 1.640 | 32804.9 |
896 | 2023-12-07 10:34:13 | assay | 3 | 83667 | 710 | 8.360 | 10008.0 |
895 | 2023-12-07 10:34:07 | assay | 2 | 53800 | 43 | 1.563 | 34421.0 |
894 | 2023-12-04 02:13:59 | assay | 1 | 28756 | 4 | 0.516 | 55728.7 |
893 | 2023-12-04 02:13:58 | assay | 1 | 28756 | 4 | 0.516 | 55728.7 |
892 | 2023-12-02 21:41:07 | assay | 1 | 28756 | 4 | 1.076 | 26724.9 |
891 | 2023-11-25 05:51:56 | assay | 2 | 53800 | 43 | 1.703 | 31591.3 |
890 | 2023-11-25 05:51:53 | assay | 3 | 83667 | 710 | 3.750 | 22311.2 |
889 | 2023-11-22 05:20:00 | assay | 2 | 53800 | 43 | 1.513 | 35558.5 |
888 | 2023-11-13 23:43:09 | assay | 1 | 28756 | 4 | 0.436 | 65954.1 |
887 | 2023-11-10 19:30:44 | assay | 1 | 28756 | 4 | 0.436 | 65954.1 |
886 | 2023-11-03 11:06:26 | assay | 1 | 28756 | 4 | 0.516 | 55728.7 |
885 | 2023-10-21 22:49:23 | assay | 1 | 28756 | 4 | 1.313 | 21901.0 |
884 | 2023-10-18 16:58:07 | assay | 1 | 28756 | 4 | 0.500 | 57512.0 |
883 | 2023-10-13 01:11:17 | assay | 1 | 28756 | 4 | 0.440 | 65354.5 |
882 | 2023-10-07 15:43:11 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
881 | 2023-10-05 02:56:53 | assay | 1 | 28756 | 4 | 0.500 | 57512.0 |
880 | 2023-10-04 08:48:24 | assay | 1 | 28756 | 4 | 0.906 | 31739.5 |
879 | 2023-09-29 06:00:36 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
878 | 2023-09-23 12:44:54 | assay | 1 | 28756 | 4 | 0.470 | 61183.0 |
877 | 2023-09-18 12:31:06 | assay | 1 | 28756 | 4 | 0.466 | 61708.2 |
876 | 2023-08-24 06:43:34 | assay | 2 | 53800 | 43 | 1.453 | 37026.8 |
875 | 2023-07-09 12:58:30 | assay | 1 | 28756 | 4 | 0.456 | 63061.4 |
874 | 2023-06-27 14:12:40 | assay | 1 | 28756 | 4 | 0.470 | 61183.0 |
873 | 2023-06-23 22:50:01 | assay | 1 | 28756 | 4 | 0.533 | 53951.2 |
872 | 2023-05-07 01:36:40 | assay | 2 | 53800 | 43 | 1.560 | 34487.2 |
871 | 2023-04-15 20:20:07 | assay | 1 | 28756 | 4 | 0.450 | 63902.2 |
870 | 2023-03-26 20:21:01 | assay | 1 | 28756 | 4 | 0.486 | 59168.7 |
869 | 2023-03-21 14:34:18 | assay | 1 | 28756 | 4 | 0.516 | 55728.7 |
868 | 2023-02-11 09:55:31 | assay | 2 | 53800 | 43 | 1.610 | 33416.1 |
867 | 2023-02-07 23:50:18 | assay | 1 | 28756 | 4 | 0.466 | 61708.2 |
866 | 2022-12-13 07:22:53 | assay | 1 | 28756 | 4 | 0.483 | 59536.2 |
865 | 2022-12-06 04:12:39 | assay | 1 | 28756 | 4 | 1.000 | 28756.0 |
864 | 2022-11-23 16:18:14 | assay | 2 | 53800 | 43 | 1.393 | 38621.7 |
863 | 2022-09-19 02:48:51 | assay | 1 | 28756 | 4 | 0.500 | 57512.0 |
862 | 2022-09-01 06:35:53 | assay | 2 | 53800 | 43 | 1.360 | 39558.8 |
861 | 2022-08-30 04:09:05 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
860 | 2022-08-25 14:19:58 | assay | 3 | 83667 | 710 | 3.360 | 24900.9 |
859 | 2022-08-23 02:30:14 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
858 | 2022-08-06 14:34:26 | assay | 1 | 28756 | 4 | 0.483 | 59536.2 |
857 | 2022-07-28 19:52:33 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
856 | 2022-07-17 19:54:19 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
855 | 2022-05-17 15:16:31 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
854 | 2022-05-14 02:06:37 | assay | 1 | 28756 | 4 | 0.606 | 47452.1 |
853 | 2022-04-23 21:01:47 | assay | 2 | 53800 | 43 | 1.546 | 34799.5 |
852 | 2022-03-31 11:57:37 | assay | 1 | 28756 | 4 | 0.690 | 41675.4 |
851 | 2022-02-09 07:46:05 | assay | 1 | 28756 | 4 | 0.530 | 54256.6 |
850 | 2021-12-31 00:01:47 | assay | 1 | 28756 | 4 | 0.483 | 59536.2 |
849 | 2021-12-29 05:39:23 | assay | 2 | 53800 | 43 | 1.436 | 37465.2 |
848 | 2021-11-05 02:29:25 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
847 | 2021-10-31 11:12:29 | assay | 1 | 28756 | 4 | 0.533 | 53951.2 |
846 | 2021-10-11 08:34:35 | assay | 2 | 53800 | 43 | 1.403 | 38346.4 |
845 | 2021-09-17 17:47:50 | assay | 1 | 28756 | 4 | 0.483 | 59536.2 |
844 | 2021-08-31 05:12:20 | assay | 1 | 28756 | 4 | 0.440 | 65354.5 |
843 | 2021-08-05 08:32:14 | assay | 1 | 28756 | 4 | 0.486 | 59168.7 |
842 | 2021-06-16 05:21:54 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
841 | 2021-05-01 06:03:13 | assay | 1 | 28756 | 4 | 0.563 | 51076.4 |
840 | 2021-04-24 22:00:37 | assay | 1 | 28756 | 4 | 0.483 | 59536.2 |
839 | 2021-01-28 19:11:22 | assay | 1 | 28756 | 4 | 0.500 | 57512.0 |