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 |
1030 | 2024-12-26 19:47:33 | assay | 2 | 53800 | 43 | 16.420 | 3276.5 |
1029 | 2024-12-25 15:52:40 | assay | 2 | 53800 | 43 | 5.890 | 9134.1 |
1028 | 2024-12-25 01:28:44 | assay | 2 | 53800 | 43 | 9.186 | 5856.7 |
1027 | 2024-12-24 06:44:46 | assay | 3 | 83667 | 710 | 8.923 | 9376.6 |
1026 | 2024-12-08 14:03:29 | assay | 1 | 28756 | 4 | 1.280 | 22465.6 |
1025 | 2024-12-07 08:18:09 | assay | 3 | 83667 | 710 | 21.376 | 3914.1 |
1024 | 2024-12-06 14:38:45 | assay | 3 | 83667 | 710 | 19.453 | 4301.0 |
1023 | 2024-12-06 13:46:36 | assay | 3 | 83667 | 710 | 19.283 | 4338.9 |
1022 | 2024-12-06 13:46:39 | assay | 2 | 53800 | 43 | 9.123 | 5897.2 |
1021 | 2024-12-06 13:33:06 | assay | 1 | 28756 | 4 | 0.453 | 63479.0 |
1020 | 2024-12-04 19:22:32 | assay | 2 | 53800 | 43 | 1.780 | 30224.7 |
1019 | 2024-12-04 19:22:12 | assay | 1 | 28756 | 4 | 0.500 | 57512.0 |
1018 | 2024-12-03 05:36:27 | assay | 1 | 28756 | 4 | 1.200 | 23963.3 |
1017 | 2024-11-07 19:51:29 | assay | 3 | 83667 | 710 | 4.203 | 19906.5 |
1016 | 2024-11-07 11:10:58 | assay | 2 | 53800 | 43 | 6.750 | 7970.4 |
1015 | 2024-11-07 11:10:50 | assay | 1 | 28756 | 4 | 1.356 | 21206.5 |
1014 | 2024-11-06 10:25:38 | assay | 3 | 83667 | 710 | 20.000 | 4183.4 |
1013 | 2024-11-06 10:22:16 | assay | 3 | 83667 | 710 | 30.533 | 2740.2 |
1012 | 2024-11-06 07:38:25 | assay | 1 | 28756 | 4 | 0.483 | 59536.2 |
1011 | 2024-11-06 04:21:36 | assay | 3 | 83667 | 710 | 4.063 | 20592.4 |
1010 | 2024-11-06 04:21:31 | assay | 2 | 53800 | 43 | 1.640 | 32804.9 |
1009 | 2024-11-04 16:44:31 | assay | 2 | 53800 | 43 | 7.920 | 6792.9 |
1008 | 2024-11-04 16:44:20 | assay | 1 | 28756 | 4 | 1.936 | 14853.3 |
1007 | 2024-10-25 08:56:25 | assay | 1 | 28756 | 4 | 2.343 | 12273.2 |
1006 | 2024-10-08 16:03:08 | assay | 3 | 83667 | 710 | 23.546 | 3553.3 |
1005 | 2024-10-07 17:29:14 | assay | 2 | 53800 | 43 | 9.923 | 5421.7 |
1004 | 2024-10-07 17:22:46 | assay | 1 | 28756 | 4 | 4.423 | 6501.5 |
1003 | 2024-10-07 06:14:40 | assay | 3 | 83667 | 710 | 16.423 | 5094.5 |
1002 | 2024-10-07 05:24:55 | assay | 3 | 83667 | 710 | 22.596 | 3702.7 |
1001 | 2024-10-07 05:24:55 | assay | 2 | 53800 | 43 | 12.640 | 4256.3 |
1000 | 2024-10-07 05:06:07 | assay | 1 | 28756 | 4 | 0.546 | 52666.7 |
999 | 2024-10-04 13:46:29 | assay | 2 | 53800 | 43 | 17.720 | 3036.1 |
998 | 2024-10-04 13:46:24 | assay | 1 | 28756 | 4 | 5.483 | 5244.6 |
997 | 2024-09-09 10:00:07 | assay | 3 | 83667 | 710 | 11.563 | 7235.8 |
996 | 2024-09-08 08:41:30 | assay | 3 | 83667 | 710 | 30.880 | 2709.4 |
995 | 2024-09-07 18:02:19 | assay | 1 | 28756 | 4 | 4.093 | 7025.7 |
994 | 2024-09-07 12:32:00 | assay | 1 | 28756 | 4 | 4.250 | 6766.1 |
993 | 2024-09-07 02:52:51 | assay | 2 | 53800 | 43 | 12.763 | 4215.3 |
992 | 2024-09-06 23:06:41 | assay | 3 | 83667 | 710 | 10.953 | 7638.7 |
991 | 2024-09-06 23:06:39 | assay | 2 | 53800 | 43 | 1.656 | 32487.9 |
990 | 2024-09-06 23:06:37 | assay | 1 | 28756 | 4 | 0.920 | 31256.5 |
989 | 2024-09-03 19:28:04 | assay | 1 | 28756 | 4 | 3.796 | 7575.3 |
988 | 2024-08-30 04:49:35 | assay | 1 | 28756 | 4 | 3.076 | 9348.5 |
987 | 2024-08-30 04:23:03 | assay | 1 | 28756 | 4 | 3.830 | 7508.1 |
986 | 2024-08-15 09:18:30 | assay | 3 | 83667 | 710 | 26.723 | 3130.9 |
985 | 2024-08-14 19:48:45 | assay | 3 | 83667 | 710 | 33.580 | 2491.6 |
984 | 2024-08-14 06:48:26 | assay | 3 | 83667 | 710 | 30.046 | 2784.6 |
983 | 2024-08-12 22:35:38 | assay | 1 | 28756 | 4 | 2.580 | 11145.7 |
982 | 2024-08-09 06:18:23 | assay | 1 | 28756 | 4 | 1.000 | 28756.0 |
981 | 2024-08-08 03:57:08 | assay | 1 | 28756 | 4 | 2.326 | 12362.9 |
980 | 2024-08-08 01:47:16 | assay | 1 | 28756 | 4 | 2.830 | 10161.1 |
979 | 2024-07-31 14:12:21 | assay | 3 | 83667 | 710 | 20.706 | 4040.7 |
978 | 2024-07-31 03:01:43 | assay | 2 | 53800 | 43 | 3.000 | 17933.3 |
977 | 2024-07-30 22:25:23 | assay | 3 | 83667 | 710 | 15.220 | 5497.2 |
976 | 2024-07-30 22:25:21 | assay | 2 | 53800 | 43 | 5.910 | 9103.2 |
975 | 2024-07-30 22:24:50 | assay | 1 | 28756 | 4 | 1.110 | 25906.3 |
974 | 2024-07-30 21:16:33 | assay | 1 | 28756 | 4 | 1.233 | 23322.0 |
973 | 2024-07-25 07:26:19 | assay | 1 | 28756 | 4 | 1.140 | 25224.6 |
972 | 2024-07-13 10:52:09 | assay | 1 | 28756 | 4 | 1.046 | 27491.4 |
971 | 2024-07-09 21:28:36 | assay | 1 | 28756 | 4 | 1.830 | 15713.7 |
970 | 2024-07-07 14:34:13 | assay | 1 | 28756 | 4 | 0.920 | 31256.5 |
969 | 2024-07-07 13:29:56 | assay | 1 | 28756 | 4 | 2.470 | 11642.1 |
968 | 2024-07-02 02:16:39 | assay | 1 | 28756 | 4 | 1.310 | 21951.1 |
967 | 2024-07-01 04:35:34 | assay | 3 | 83667 | 710 | 17.736 | 4717.4 |
966 | 2024-07-01 00:40:14 | assay | 3 | 83667 | 710 | 8.296 | 10085.2 |
965 | 2024-06-30 22:36:21 | assay | 3 | 83667 | 710 | 16.923 | 4944.0 |
964 | 2024-06-30 22:35:27 | assay | 2 | 53800 | 43 | 5.733 | 9384.3 |
963 | 2024-06-30 22:17:58 | assay | 3 | 83667 | 710 | 7.343 | 11394.1 |
962 | 2024-06-30 20:44:59 | assay | 3 | 83667 | 710 | 17.296 | 4837.4 |
961 | 2024-06-30 20:45:05 | assay | 2 | 53800 | 43 | 9.030 | 5957.9 |
960 | 2024-06-30 20:14:30 | assay | 1 | 28756 | 4 | 1.170 | 24577.8 |
959 | 2024-06-30 13:39:12 | assay | 1 | 28756 | 4 | 2.533 | 11352.5 |
958 | 2024-06-29 20:56:04 | assay | 1 | 28756 | 4 | 3.673 | 7829.0 |
957 | 2024-06-12 14:03:26 | assay | 1 | 28756 | 4 | 1.890 | 15214.8 |
956 | 2024-06-10 23:19:14 | assay | 1 | 28756 | 4 | 1.750 | 16432.0 |
955 | 2024-06-05 05:56:56 | assay | 1 | 28756 | 4 | 0.516 | 55728.7 |
954 | 2024-05-31 19:16:40 | assay | 1 | 28756 | 4 | 0.533 | 53951.2 |
953 | 2024-05-30 15:35:23 | assay | 1 | 28756 | 4 | 1.096 | 26237.2 |
952 | 2024-05-30 03:43:11 | assay | 1 | 28756 | 4 | 2.263 | 12707.0 |
951 | 2024-05-15 20:25:23 | assay | 1 | 28756 | 4 | 1.186 | 24246.2 |
950 | 2024-05-14 13:45:17 | assay | 2 | 53800 | 43 | 1.796 | 29955.5 |
949 | 2024-05-06 00:54:27 | assay | 1 | 28756 | 4 | 0.576 | 49923.6 |
948 | 2024-05-05 20:51:45 | assay | 3 | 83667 | 710 | 4.076 | 20526.7 |
947 | 2024-05-05 19:50:48 | assay | 3 | 83667 | 710 | 5.736 | 14586.3 |
946 | 2024-05-05 19:50:52 | assay | 2 | 53800 | 43 | 1.686 | 31909.8 |
945 | 2024-05-05 19:50:43 | assay | 2 | 53800 | 43 | 3.466 | 15522.2 |
944 | 2024-05-05 19:50:44 | assay | 1 | 28756 | 4 | 1.140 | 25224.6 |
943 | 2024-05-05 19:50:15 | assay | 3 | 83667 | 710 | 8.436 | 9917.9 |
942 | 2024-05-05 13:44:56 | assay | 3 | 83667 | 710 | 9.533 | 8776.6 |
941 | 2024-05-01 20:37:43 | assay | 1 | 28756 | 4 | 1.110 | 25906.3 |
940 | 2024-05-01 03:43:19 | assay | 1 | 28756 | 4 | 0.500 | 57512.0 |
939 | 2024-04-29 23:28:37 | assay | 1 | 28756 | 4 | 0.546 | 52666.7 |
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 |