History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pian"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1206 | 2024-04-25 23:51:40 | pian | 1 | 13983 | 15 | 0.873 | 16017.2 |
1205 | 2024-04-22 19:12:58 | pian | 2 | 29872 | 272 | 0.766 | 38997.4 |
1204 | 2024-04-10 09:00:08 | pian | 1 | 13983 | 15 | 0.266 | 52567.7 |
1203 | 2024-04-10 08:44:26 | pian | 1 | 13983 | 15 | 0.266 | 52567.7 |
1202 | 2024-04-10 08:44:16 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1201 | 2024-04-10 08:35:33 | pian | 1 | 13983 | 15 | 0.263 | 53167.3 |
1200 | 2024-04-04 19:31:32 | pian | 1 | 13983 | 15 | 1.000 | 13983.0 |
1199 | 2024-03-31 02:37:05 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1198 | 2024-03-27 05:52:52 | pian | 1 | 13983 | 15 | 0.266 | 52567.7 |
1197 | 2024-03-16 08:51:58 | pian | 1 | 13983 | 15 | 0.533 | 26234.5 |
1196 | 2024-03-05 17:34:05 | pian | 1 | 13983 | 15 | 0.550 | 25423.6 |
1195 | 2024-03-02 18:17:36 | pian | 2 | 29872 | 272 | 2.140 | 13958.9 |
1194 | 2024-03-02 17:25:14 | pian | 1 | 13983 | 15 | 0.216 | 64736.1 |
1193 | 2024-02-26 03:32:34 | pian | 2 | 29872 | 272 | 0.906 | 32971.3 |
1192 | 2024-02-26 03:27:10 | pian | 1 | 13983 | 15 | 0.516 | 27098.8 |
1191 | 2024-02-18 12:31:53 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1190 | 2024-02-02 23:35:25 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1189 | 2024-01-29 14:41:24 | pian | 1 | 13983 | 15 | 0.500 | 27966.0 |
1188 | 2024-01-26 21:06:45 | pian | 1 | 13983 | 15 | 0.266 | 52567.7 |
1187 | 2024-01-22 23:58:23 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1186 | 2024-01-22 23:32:55 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1185 | 2024-01-09 06:36:55 | pian | 1 | 13983 | 15 | 0.236 | 59250.0 |
1184 | 2023-12-30 22:50:45 | pian | 1 | 13983 | 15 | 0.283 | 49409.9 |
1183 | 2023-12-27 06:06:29 | pian | 2 | 29872 | 272 | 0.813 | 36742.9 |
1182 | 2023-12-22 05:10:40 | pian | 2 | 29872 | 272 | 0.953 | 31345.2 |
1181 | 2023-12-17 19:24:12 | pian | 2 | 29872 | 272 | 1.093 | 27330.3 |
1180 | 2023-12-10 05:14:31 | pian | 2 | 29872 | 272 | 0.890 | 33564.0 |
1179 | 2023-12-08 11:26:34 | pian | 2 | 29872 | 272 | 0.876 | 34100.5 |
1178 | 2023-12-08 11:26:33 | pian | 2 | 29872 | 272 | 0.923 | 32364.0 |
1177 | 2023-12-08 01:58:00 | pian | 2 | 29872 | 272 | 0.890 | 33564.0 |
1176 | 2023-12-08 01:57:58 | pian | 2 | 29872 | 272 | 1.780 | 16782.0 |
1175 | 2023-12-08 01:49:11 | pian | 1 | 13983 | 15 | 0.360 | 38841.7 |
1174 | 2023-12-08 01:49:10 | pian | 1 | 13983 | 15 | 0.263 | 53167.3 |
1173 | 2023-11-28 14:34:12 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1172 | 2023-11-16 15:22:22 | pian | 1 | 13983 | 15 | 0.203 | 68881.8 |
1171 | 2023-11-13 22:41:20 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1170 | 2023-11-13 20:45:18 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1169 | 2023-11-11 00:56:34 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1168 | 2023-11-04 00:28:16 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1167 | 2023-10-29 06:12:05 | pian | 2 | 29872 | 272 | 0.750 | 39829.3 |
1166 | 2023-10-25 21:58:43 | pian | 1 | 13983 | 15 | 0.440 | 31779.5 |
1165 | 2023-10-20 07:12:31 | pian | 1 | 13983 | 15 | 0.216 | 64736.1 |
1164 | 2023-10-18 06:45:29 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1163 | 2023-10-12 00:01:15 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1162 | 2023-10-03 19:59:08 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1161 | 2023-09-25 14:22:51 | pian | 1 | 13983 | 15 | 0.236 | 59250.0 |
1160 | 2023-09-20 17:10:50 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1159 | 2023-09-19 15:41:17 | pian | 2 | 29872 | 272 | 0.923 | 32364.0 |
1158 | 2023-09-18 10:04:27 | pian | 2 | 29872 | 272 | 0.780 | 38297.4 |
1157 | 2023-09-14 10:07:03 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1156 | 2023-08-27 21:52:26 | pian | 1 | 13983 | 15 | 0.216 | 64736.1 |
1155 | 2023-07-30 10:40:18 | pian | 1 | 13983 | 15 | 0.236 | 59250.0 |
1154 | 2023-06-28 12:27:01 | pian | 2 | 29872 | 272 | 0.766 | 38997.4 |
1153 | 2023-06-24 19:17:21 | pian | 2 | 29872 | 272 | 0.750 | 39829.3 |
1152 | 2023-05-30 05:29:40 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1151 | 2023-04-22 02:09:03 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1150 | 2023-03-20 19:20:38 | pian | 1 | 13983 | 15 | 0.423 | 33056.7 |
1149 | 2023-03-20 18:49:30 | pian | 2 | 29872 | 272 | 0.750 | 39829.3 |
1148 | 2023-03-02 22:42:01 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1147 | 2023-01-08 07:31:48 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1146 | 2023-01-05 23:29:55 | pian | 1 | 13983 | 15 | 0.203 | 68881.8 |
1145 | 2022-12-22 03:22:25 | pian | 2 | 29872 | 272 | 0.766 | 38997.4 |
1144 | 2022-10-06 18:31:12 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1143 | 2022-09-22 06:27:06 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1142 | 2022-09-14 21:00:46 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1141 | 2022-08-19 15:05:59 | pian | 2 | 29872 | 272 | 0.780 | 38297.4 |
1140 | 2022-07-29 00:24:07 | pian | 1 | 13983 | 15 | 0.200 | 69915.0 |
1139 | 2022-07-18 18:21:45 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1138 | 2022-07-09 21:58:00 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1137 | 2022-06-17 02:26:16 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1136 | 2022-06-09 00:24:21 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1135 | 2022-06-08 21:09:32 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1134 | 2022-06-08 17:29:41 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1133 | 2022-06-07 08:21:29 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1132 | 2022-06-05 05:56:30 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1131 | 2022-06-01 13:46:45 | pian | 1 | 13983 | 15 | 0.216 | 64736.1 |
1130 | 2022-05-27 12:16:46 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1129 | 2022-05-25 17:23:15 | pian | 1 | 13983 | 15 | 0.203 | 68881.8 |
1128 | 2022-05-25 07:17:43 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1127 | 2022-05-02 07:44:58 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1126 | 2022-05-01 14:46:31 | pian | 1 | 13983 | 15 | 0.203 | 68881.8 |
1125 | 2022-04-30 16:08:12 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1124 | 2022-04-30 03:35:20 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1123 | 2022-04-29 13:53:33 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1122 | 2022-04-29 02:06:55 | pian | 1 | 13983 | 15 | 0.233 | 60012.9 |
1121 | 2022-04-28 17:13:24 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1120 | 2022-03-21 20:13:01 | pian | 2 | 29872 | 272 | 0.940 | 31778.7 |
1119 | 2022-03-19 18:17:37 | pian | 2 | 29872 | 272 | 0.843 | 35435.3 |
1118 | 2022-03-01 18:41:11 | pian | 1 | 13983 | 15 | 0.436 | 32071.1 |
1117 | 2022-02-28 19:10:39 | pian | 1 | 13983 | 15 | 0.266 | 52567.7 |
1116 | 2022-02-27 19:41:55 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1115 | 2022-02-26 21:25:52 | pian | 1 | 13983 | 15 | 0.266 | 52567.7 |
1114 | 2022-02-25 13:42:54 | pian | 1 | 13983 | 15 | 0.313 | 44674.1 |
1113 | 2022-02-21 23:55:45 | pian | 1 | 13983 | 15 | 0.266 | 52567.7 |
1112 | 2022-02-10 20:18:59 | pian | 1 | 13983 | 15 | 0.216 | 64736.1 |
1111 | 2022-02-10 02:28:48 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1110 | 2022-02-09 18:49:43 | pian | 1 | 13983 | 15 | 0.250 | 55932.0 |
1109 | 2022-02-09 01:08:34 | pian | 1 | 13983 | 15 | 0.220 | 63559.1 |
1108 | 2022-02-08 16:07:00 | pian | 1 | 13983 | 15 | 0.216 | 64736.1 |
1107 | 2022-02-07 20:59:38 | pian | 1 | 13983 | 15 | 0.216 | 64736.1 |