History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ones"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1114 | 2024-03-05 20:45:30 | ones | 1 | 13983 | 27 | 0.563 | 24836.6 |
1113 | 2024-03-02 05:26:18 | ones | 1 | 13983 | 27 | 0.263 | 53167.3 |
1112 | 2024-02-13 08:45:42 | ones | 1 | 13983 | 27 | 0.266 | 52567.7 |
1111 | 2024-02-06 07:08:22 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1110 | 2024-02-03 03:03:22 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1109 | 2024-01-27 01:25:36 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1108 | 2023-12-20 16:50:20 | ones | 2 | 29872 | 505 | 0.923 | 32364.0 |
1107 | 2023-12-17 14:44:24 | ones | 1 | 13983 | 27 | 0.500 | 27966.0 |
1106 | 2023-12-08 10:59:40 | ones | 1 | 13983 | 27 | 0.296 | 47239.9 |
1105 | 2023-12-06 12:44:21 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1104 | 2023-12-01 17:01:32 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1103 | 2023-11-27 13:52:40 | ones | 2 | 29872 | 505 | 0.780 | 38297.4 |
1102 | 2023-11-23 21:55:18 | ones | 2 | 29872 | 505 | 0.890 | 33564.0 |
1101 | 2023-11-15 12:35:37 | ones | 1 | 13983 | 27 | 0.266 | 52567.7 |
1100 | 2023-11-10 01:52:44 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1099 | 2023-11-09 09:18:42 | ones | 1 | 13983 | 27 | 0.216 | 64736.1 |
1098 | 2023-11-07 11:04:41 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1097 | 2023-10-27 00:57:38 | ones | 1 | 13983 | 27 | 0.216 | 64736.1 |
1096 | 2023-10-25 16:39:39 | ones | 1 | 13983 | 27 | 0.236 | 59250.0 |
1095 | 2023-10-23 03:52:13 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1094 | 2023-10-19 21:38:38 | ones | 1 | 13983 | 27 | 0.313 | 44674.1 |
1093 | 2023-10-17 08:50:50 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1092 | 2023-10-11 16:28:58 | ones | 1 | 13983 | 27 | 0.263 | 53167.3 |
1091 | 2023-10-04 00:15:46 | ones | 1 | 13983 | 27 | 0.236 | 59250.0 |
1090 | 2023-09-29 13:42:32 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1089 | 2023-09-28 01:03:02 | ones | 2 | 29872 | 505 | 0.890 | 33564.0 |
1088 | 2023-09-22 05:44:36 | ones | 1 | 13983 | 27 | 0.203 | 68881.8 |
1087 | 2023-09-21 05:23:55 | ones | 2 | 29872 | 505 | 0.750 | 39829.3 |
1086 | 2023-08-31 19:12:28 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1085 | 2023-08-15 14:31:14 | ones | 1 | 13983 | 27 | 0.216 | 64736.1 |
1084 | 2023-07-17 15:09:36 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1083 | 2023-07-16 14:26:56 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1082 | 2023-06-27 17:16:40 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1081 | 2023-05-07 17:24:08 | ones | 1 | 13983 | 27 | 0.216 | 64736.1 |
1080 | 2023-04-19 23:51:32 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1079 | 2023-04-08 22:13:37 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1078 | 2023-03-26 11:19:55 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1077 | 2023-03-21 06:53:17 | ones | 2 | 29872 | 505 | 0.860 | 34734.9 |
1076 | 2023-03-03 01:09:00 | ones | 1 | 13983 | 27 | 0.203 | 68881.8 |
1075 | 2023-02-08 00:38:28 | ones | 1 | 13983 | 27 | 0.203 | 68881.8 |
1074 | 2022-12-30 22:39:46 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1073 | 2022-12-21 09:55:27 | ones | 2 | 29872 | 505 | 0.860 | 34734.9 |
1072 | 2022-12-14 19:22:31 | ones | 2 | 29872 | 505 | 0.763 | 39150.7 |
1071 | 2022-12-09 15:12:57 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1070 | 2022-11-15 18:26:13 | ones | 2 | 29872 | 505 | 0.750 | 39829.3 |
1069 | 2022-11-02 02:27:53 | ones | 2 | 29872 | 505 | 0.763 | 39150.7 |
1068 | 2022-10-28 08:01:54 | ones | 2 | 29872 | 505 | 0.750 | 39829.3 |
1067 | 2022-10-28 01:24:17 | ones | 2 | 29872 | 505 | 0.826 | 36164.6 |
1066 | 2022-09-19 17:58:27 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1065 | 2022-09-18 13:23:06 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1064 | 2022-09-16 12:08:38 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1063 | 2022-09-14 11:46:49 | ones | 2 | 29872 | 505 | 0.830 | 35990.4 |
1062 | 2022-09-08 12:41:34 | ones | 2 | 29872 | 505 | 0.736 | 40587.0 |
1061 | 2022-09-03 12:14:16 | ones | 1 | 13983 | 27 | 0.236 | 59250.0 |
1060 | 2022-08-26 03:37:36 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1059 | 2022-08-23 18:57:09 | ones | 1 | 13983 | 27 | 0.206 | 67878.6 |
1058 | 2022-08-18 00:30:11 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1057 | 2022-08-17 14:58:50 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1056 | 2022-08-12 11:25:14 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1055 | 2022-08-10 14:29:34 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1054 | 2022-08-09 08:01:20 | ones | 1 | 13983 | 27 | 0.236 | 59250.0 |
1053 | 2022-08-07 02:29:54 | ones | 1 | 13983 | 27 | 0.216 | 64736.1 |
1052 | 2022-08-02 16:03:38 | ones | 2 | 29872 | 505 | 0.860 | 34734.9 |
1051 | 2022-07-30 03:30:48 | ones | 1 | 13983 | 27 | 0.236 | 59250.0 |
1050 | 2022-07-28 04:52:08 | ones | 2 | 29872 | 505 | 0.780 | 38297.4 |
1049 | 2022-07-25 03:12:47 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1048 | 2022-07-17 19:08:37 | ones | 1 | 13983 | 27 | 0.233 | 60012.9 |
1047 | 2022-07-10 04:14:21 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1046 | 2022-07-03 10:54:41 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1045 | 2022-07-03 07:05:22 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1044 | 2022-07-02 15:56:38 | ones | 1 | 13983 | 27 | 0.203 | 68881.8 |
1043 | 2022-06-16 10:53:45 | ones | 1 | 13983 | 27 | 0.200 | 69915.0 |
1042 | 2022-06-15 17:08:16 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1041 | 2022-05-31 02:26:34 | ones | 1 | 13983 | 27 | 0.206 | 67878.6 |
1040 | 2022-05-26 03:02:33 | ones | 1 | 13983 | 27 | 0.236 | 59250.0 |
1039 | 2022-05-15 19:11:44 | ones | 2 | 29872 | 505 | 0.796 | 37527.6 |
1038 | 2022-04-26 10:27:14 | ones | 2 | 29872 | 505 | 0.890 | 33564.0 |
1037 | 2022-04-10 22:07:10 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1036 | 2022-03-27 15:26:10 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1035 | 2022-03-25 05:17:04 | ones | 1 | 13983 | 27 | 0.266 | 52567.7 |
1034 | 2022-03-23 01:54:47 | ones | 1 | 13983 | 27 | 0.216 | 64736.1 |
1033 | 2022-03-13 23:19:29 | ones | 2 | 29872 | 505 | 0.923 | 32364.0 |
1032 | 2022-02-24 02:52:43 | ones | 2 | 29872 | 505 | 1.000 | 29872.0 |
1031 | 2022-02-16 13:07:16 | ones | 1 | 13983 | 27 | 0.280 | 49939.3 |
1030 | 2022-02-06 18:46:39 | ones | 2 | 29872 | 505 | 0.750 | 39829.3 |
1029 | 2022-01-26 10:09:45 | ones | 2 | 29872 | 505 | 0.766 | 38997.4 |
1028 | 2022-01-07 13:55:55 | ones | 2 | 29872 | 505 | 0.890 | 33564.0 |
1027 | 2021-12-29 01:05:47 | ones | 1 | 13983 | 27 | 0.236 | 59250.0 |
1026 | 2021-12-14 19:58:50 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1025 | 2021-12-07 10:31:54 | ones | 2 | 29872 | 505 | 0.970 | 30795.9 |
1024 | 2021-11-15 04:38:31 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1023 | 2021-11-02 16:36:26 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1022 | 2021-09-22 07:17:15 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1021 | 2021-09-21 16:59:25 | ones | 2 | 29872 | 505 | 0.923 | 32364.0 |
1020 | 2021-09-20 10:45:36 | ones | 2 | 29872 | 505 | 0.843 | 35435.3 |
1019 | 2021-08-24 20:23:13 | ones | 1 | 13983 | 27 | 0.250 | 55932.0 |
1018 | 2021-08-22 16:07:19 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1017 | 2021-08-19 03:27:33 | ones | 2 | 29872 | 505 | 1.686 | 17717.7 |
1016 | 2021-08-16 17:50:15 | ones | 1 | 13983 | 27 | 0.220 | 63559.1 |
1015 | 2021-08-15 16:16:08 | ones | 1 | 13983 | 27 | 0.390 | 35853.8 |