History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assays"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
986 | 2025-07-15 18:13:41 | assays | 3 | 112716 | 428 | 5.326 | 21163.3 |
985 | 2025-07-15 13:52:41 | assays | 3 | 112716 | 428 | 34.866 | 3232.8 |
984 | 2025-07-11 03:48:49 | assays | 1 | 48755 | 4 | 2.173 | 22436.7 |
983 | 2025-07-10 22:40:15 | assays | 2 | 82551 | 31 | 11.936 | 6916.1 |
982 | 2025-07-08 23:16:48 | assays | 3 | 112716 | 428 | 12.923 | 8722.1 |
981 | 2025-07-08 17:04:17 | assays | 1 | 48755 | 4 | 0.890 | 54780.9 |
980 | 2025-07-04 11:12:51 | assays | 1 | 48755 | 4 | 6.470 | 7535.5 |
979 | 2025-06-29 00:56:56 | assays | 3 | 112716 | 428 | 14.343 | 7858.6 |
978 | 2025-06-24 04:48:13 | assays | 3 | 112716 | 428 | 26.613 | 4235.4 |
977 | 2025-06-23 15:42:51 | assays | 1 | 48755 | 4 | 0.860 | 56691.9 |
976 | 2025-06-23 10:36:29 | assays | 3 | 112716 | 428 | 27.220 | 4140.9 |
975 | 2025-06-23 09:49:03 | assays | 3 | 112716 | 428 | 25.780 | 4372.2 |
974 | 2025-06-23 00:00:30 | assays | 3 | 112716 | 428 | 5.140 | 21929.2 |
973 | 2025-06-21 15:20:52 | assays | 3 | 112716 | 428 | 5.250 | 21469.7 |
972 | 2025-06-20 14:10:55 | assays | 1 | 48755 | 4 | 2.893 | 16852.7 |
971 | 2025-06-19 23:34:05 | assays | 1 | 48755 | 4 | 4.110 | 11862.5 |
970 | 2025-06-16 06:31:58 | assays | 1 | 48755 | 4 | 2.313 | 21078.7 |
969 | 2025-06-15 01:26:06 | assays | 3 | 112716 | 428 | 5.220 | 21593.1 |
968 | 2025-06-13 21:20:34 | assays | 3 | 112716 | 428 | 15.533 | 7256.6 |
967 | 2025-06-13 02:07:37 | assays | 3 | 112716 | 428 | 5.486 | 20546.1 |
966 | 2025-06-10 21:07:00 | assays | 3 | 112716 | 428 | 22.456 | 5019.4 |
965 | 2025-06-09 20:17:31 | assays | 1 | 48755 | 4 | 4.046 | 12050.2 |
964 | 2025-06-08 16:53:01 | assays | 1 | 48755 | 4 | 4.420 | 11030.5 |
963 | 2025-05-31 17:59:23 | assays | 1 | 48755 | 4 | 2.250 | 21668.9 |
962 | 2025-05-28 06:03:44 | assays | 1 | 48755 | 4 | 0.890 | 54780.9 |
961 | 2025-05-21 11:23:28 | assays | 3 | 112716 | 428 | 18.720 | 6021.2 |
960 | 2025-05-20 10:44:26 | assays | 1 | 48755 | 4 | 2.313 | 21078.7 |
959 | 2025-05-19 00:03:50 | assays | 3 | 112716 | 428 | 5.673 | 19868.9 |
958 | 2025-05-18 05:35:08 | assays | 3 | 112716 | 428 | 32.330 | 3486.4 |
957 | 2025-05-17 04:06:22 | assays | 3 | 112716 | 428 | 5.250 | 21469.7 |
956 | 2025-05-15 03:31:53 | assays | 1 | 48755 | 4 | 1.533 | 31803.7 |
955 | 2025-05-07 20:41:04 | assays | 1 | 48755 | 4 | 3.436 | 14189.5 |
954 | 2025-05-06 16:29:16 | assays | 1 | 48755 | 4 | 4.360 | 11182.3 |
953 | 2025-05-03 06:18:13 | assays | 1 | 48755 | 4 | 6.126 | 7958.7 |
952 | 2025-05-01 05:59:49 | assays | 3 | 112716 | 428 | 9.046 | 12460.3 |
951 | 2025-05-01 02:49:02 | assays | 3 | 112716 | 428 | 26.203 | 4301.6 |
950 | 2025-04-20 21:31:29 | assays | 3 | 112716 | 428 | 38.173 | 2952.8 |
949 | 2025-04-20 09:58:15 | assays | 1 | 48755 | 4 | 2.750 | 17729.1 |
948 | 2025-04-16 10:53:01 | assays | 3 | 112716 | 428 | 14.770 | 7631.4 |
947 | 2025-04-14 21:37:50 | assays | 1 | 48755 | 4 | 0.796 | 61250.0 |
946 | 2025-04-11 05:38:55 | assays | 1 | 48755 | 4 | 4.403 | 11073.1 |
945 | 2025-04-11 03:52:11 | assays | 3 | 112716 | 428 | 39.313 | 2867.1 |
944 | 2025-04-10 23:39:45 | assays | 3 | 112716 | 428 | 22.126 | 5094.3 |
943 | 2025-04-09 12:27:48 | assays | 3 | 112716 | 428 | 16.720 | 6741.4 |
942 | 2025-04-09 03:55:10 | assays | 2 | 82551 | 31 | 6.893 | 11976.1 |
941 | 2025-04-07 20:11:42 | assays | 1 | 48755 | 4 | 0.796 | 61250.0 |
940 | 2025-03-20 11:18:00 | assays | 3 | 112716 | 428 | 19.096 | 5902.6 |
939 | 2025-03-19 23:28:41 | assays | 2 | 82551 | 31 | 11.966 | 6898.8 |
938 | 2025-03-19 12:25:47 | assays | 1 | 48755 | 4 | 0.873 | 55847.7 |
937 | 2025-03-07 03:38:00 | assays | 1 | 48755 | 4 | 3.720 | 13106.2 |
936 | 2025-03-06 21:12:46 | assays | 1 | 48755 | 4 | 2.610 | 18680.1 |
935 | 2025-03-03 10:57:55 | assays | 1 | 48755 | 4 | 4.546 | 10724.8 |
934 | 2025-03-02 05:01:10 | assays | 3 | 112716 | 428 | 16.626 | 6779.5 |
933 | 2025-03-02 02:23:18 | assays | 2 | 82551 | 31 | 16.673 | 4951.2 |
932 | 2025-03-02 02:23:19 | assays | 3 | 112716 | 428 | 15.596 | 7227.2 |
931 | 2025-02-28 01:23:15 | assays | 2 | 82551 | 31 | 10.156 | 8128.3 |
930 | 2025-02-27 22:29:01 | assays | 1 | 48755 | 4 | 7.156 | 6813.2 |
929 | 2025-02-27 22:10:31 | assays | 2 | 82551 | 31 | 8.393 | 9835.7 |
928 | 2025-02-27 21:47:41 | assays | 3 | 112716 | 428 | 26.530 | 4248.6 |
927 | 2025-02-27 20:15:33 | assays | 3 | 112716 | 428 | 13.156 | 8567.6 |
926 | 2025-02-27 16:54:20 | assays | 3 | 112716 | 428 | 27.673 | 4073.1 |
925 | 2025-02-27 16:54:21 | assays | 2 | 82551 | 31 | 17.673 | 4671.0 |
924 | 2025-02-27 16:53:31 | assays | 1 | 48755 | 4 | 3.513 | 13878.5 |
923 | 2025-02-10 16:37:49 | assays | 1 | 48755 | 4 | 4.330 | 11259.8 |
922 | 2025-02-05 11:01:51 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
921 | 2025-02-04 17:07:58 | assays | 1 | 48755 | 4 | 2.203 | 22131.2 |
920 | 2025-02-03 17:17:16 | assays | 1 | 48755 | 4 | 4.360 | 11182.3 |
919 | 2025-01-30 13:53:34 | assays | 1 | 48755 | 4 | 4.063 | 11999.8 |
918 | 2025-01-26 12:28:15 | assays | 2 | 82551 | 31 | 9.780 | 8440.8 |
917 | 2025-01-26 12:12:04 | assays | 2 | 82551 | 31 | 7.720 | 10693.1 |
916 | 2025-01-26 08:25:16 | assays | 1 | 48755 | 4 | 6.296 | 7743.8 |
915 | 2025-01-26 08:24:50 | assays | 3 | 112716 | 428 | 30.406 | 3707.0 |
914 | 2025-01-26 08:22:07 | assays | 2 | 82551 | 31 | 5.000 | 16510.2 |
913 | 2025-01-25 22:27:54 | assays | 3 | 112716 | 428 | 29.390 | 3835.2 |
912 | 2025-01-25 20:02:16 | assays | 3 | 112716 | 428 | 17.563 | 6417.8 |
911 | 2025-01-25 19:08:18 | assays | 2 | 82551 | 31 | 2.576 | 32046.2 |
910 | 2025-01-25 19:07:57 | assays | 3 | 112716 | 428 | 5.906 | 19085.0 |
909 | 2025-01-12 12:28:35 | assays | 2 | 82551 | 31 | 11.406 | 7237.5 |
908 | 2025-01-11 00:49:10 | assays | 3 | 112716 | 428 | 17.030 | 6618.7 |
907 | 2025-01-04 16:31:32 | assays | 1 | 48755 | 4 | 2.266 | 21515.9 |
906 | 2025-01-02 18:17:59 | assays | 1 | 48755 | 4 | 3.706 | 13155.7 |
905 | 2024-12-28 23:47:09 | assays | 1 | 48755 | 4 | 3.660 | 13321.0 |
904 | 2024-12-26 19:47:01 | assays | 2 | 82551 | 31 | 12.470 | 6620.0 |
903 | 2024-12-26 19:46:43 | assays | 1 | 48755 | 4 | 2.030 | 24017.2 |
902 | 2024-12-24 10:46:02 | assays | 2 | 82551 | 31 | 11.050 | 7470.7 |
901 | 2024-12-21 02:25:19 | assays | 2 | 82551 | 31 | 5.406 | 15270.3 |
900 | 2024-12-19 14:59:08 | assays | 2 | 82551 | 31 | 16.860 | 4896.3 |
899 | 2024-12-19 14:54:47 | assays | 3 | 112716 | 428 | 5.593 | 20153.0 |
898 | 2024-12-17 23:00:42 | assays | 3 | 112716 | 428 | 35.876 | 3141.8 |
897 | 2024-12-16 00:24:08 | assays | 3 | 112716 | 428 | 27.596 | 4084.5 |
896 | 2024-12-15 16:25:21 | assays | 3 | 112716 | 428 | 16.326 | 6904.1 |
895 | 2024-12-04 19:40:21 | assays | 1 | 48755 | 4 | 4.766 | 10229.8 |
894 | 2024-12-03 03:54:32 | assays | 1 | 48755 | 4 | 4.906 | 9937.8 |
893 | 2024-11-25 04:15:39 | assays | 3 | 112716 | 428 | 27.533 | 4093.9 |
892 | 2024-11-13 16:00:47 | assays | 3 | 112716 | 428 | 4.876 | 23116.5 |
891 | 2024-11-06 04:48:18 | assays | 3 | 112716 | 428 | 13.860 | 8132.5 |
890 | 2024-11-04 11:42:05 | assays | 1 | 48755 | 4 | 3.673 | 13273.9 |
889 | 2024-11-03 14:00:33 | assays | 3 | 112716 | 428 | 30.000 | 3757.2 |
888 | 2024-11-02 14:09:20 | assays | 3 | 112716 | 428 | 26.250 | 4293.9 |
887 | 2024-11-01 02:42:43 | assays | 1 | 48755 | 4 | 5.546 | 8791.0 |