History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1294 | 2024-05-07 20:09:16 | roan | 1 | 13983 | 12 | 0.623 | 22444.6 |
1293 | 2024-05-05 02:32:57 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1292 | 2024-04-30 08:33:33 | roan | 1 | 13983 | 12 | 0.266 | 52567.7 |
1291 | 2024-04-30 07:14:21 | roan | 1 | 13983 | 12 | 0.266 | 52567.7 |
1290 | 2024-04-29 06:09:46 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1289 | 2024-04-28 20:54:33 | roan | 1 | 13983 | 12 | 0.470 | 29751.1 |
1288 | 2024-04-28 02:52:48 | roan | 1 | 13983 | 12 | 0.810 | 17263.0 |
1287 | 2024-04-27 05:26:37 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1286 | 2024-04-11 23:10:19 | roan | 1 | 13983 | 12 | 0.263 | 53167.3 |
1285 | 2024-04-05 00:27:05 | roan | 1 | 13983 | 12 | 0.280 | 49939.3 |
1284 | 2024-03-31 09:27:57 | roan | 2 | 29872 | 279 | 1.063 | 28101.6 |
1283 | 2024-03-31 01:29:47 | roan | 2 | 29872 | 279 | 1.046 | 28558.3 |
1282 | 2024-03-31 00:57:49 | roan | 1 | 13983 | 12 | 0.826 | 16928.6 |
1281 | 2024-03-05 19:49:09 | roan | 1 | 13983 | 12 | 0.343 | 40766.8 |
1280 | 2024-03-02 18:05:55 | roan | 2 | 29872 | 279 | 2.190 | 13640.2 |
1279 | 2024-03-02 17:46:56 | roan | 1 | 13983 | 12 | 0.236 | 59250.0 |
1278 | 2024-02-29 20:52:16 | roan | 1 | 13983 | 12 | 0.266 | 52567.7 |
1277 | 2024-02-03 01:03:42 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1276 | 2024-01-29 07:22:30 | roan | 2 | 29872 | 279 | 0.763 | 39150.7 |
1275 | 2024-01-28 13:29:59 | roan | 1 | 13983 | 12 | 0.236 | 59250.0 |
1274 | 2024-01-22 22:49:50 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1273 | 2024-01-05 03:39:37 | roan | 1 | 13983 | 12 | 0.220 | 63559.1 |
1272 | 2023-12-29 04:42:01 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1271 | 2023-12-28 03:53:44 | roan | 2 | 29872 | 279 | 0.876 | 34100.5 |
1270 | 2023-12-16 12:41:15 | roan | 2 | 29872 | 279 | 0.810 | 36879.0 |
1269 | 2023-12-14 19:08:09 | roan | 2 | 29872 | 279 | 0.813 | 36742.9 |
1268 | 2023-12-03 14:22:08 | roan | 2 | 29872 | 279 | 0.766 | 38997.4 |
1267 | 2023-11-28 03:53:05 | roan | 2 | 29872 | 279 | 0.906 | 32971.3 |
1266 | 2023-11-16 02:55:13 | roan | 1 | 13983 | 12 | 0.266 | 52567.7 |
1265 | 2023-11-13 18:35:43 | roan | 2 | 29872 | 279 | 0.763 | 39150.7 |
1264 | 2023-11-09 23:01:35 | roan | 1 | 13983 | 12 | 0.220 | 63559.1 |
1263 | 2023-10-29 11:43:25 | roan | 2 | 29872 | 279 | 0.873 | 34217.6 |
1262 | 2023-10-27 02:26:10 | roan | 1 | 13983 | 12 | 0.236 | 59250.0 |
1261 | 2023-10-26 18:52:05 | roan | 1 | 13983 | 12 | 0.500 | 27966.0 |
1260 | 2023-10-19 21:27:57 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1259 | 2023-10-17 07:10:13 | roan | 1 | 13983 | 12 | 0.233 | 60012.9 |
1258 | 2023-10-12 00:07:54 | roan | 1 | 13983 | 12 | 0.233 | 60012.9 |
1257 | 2023-10-04 00:42:04 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1256 | 2023-10-01 20:26:53 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1255 | 2023-09-23 12:14:01 | roan | 1 | 13983 | 12 | 0.236 | 59250.0 |
1254 | 2023-09-21 15:16:03 | roan | 1 | 13983 | 12 | 0.253 | 55268.8 |
1253 | 2023-09-01 00:37:20 | roan | 2 | 29872 | 279 | 0.783 | 38150.7 |
1252 | 2023-08-23 10:00:51 | roan | 2 | 29872 | 279 | 0.860 | 34734.9 |
1251 | 2023-08-21 20:59:02 | roan | 1 | 13983 | 12 | 0.216 | 64736.1 |
1250 | 2023-07-26 10:22:45 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1249 | 2023-06-29 09:59:16 | roan | 2 | 29872 | 279 | 0.796 | 37527.6 |
1248 | 2023-06-23 10:46:01 | roan | 2 | 29872 | 279 | 0.890 | 33564.0 |
1247 | 2023-06-18 02:19:36 | roan | 1 | 13983 | 12 | 0.220 | 63559.1 |
1246 | 2023-06-14 20:25:00 | roan | 1 | 13983 | 12 | 0.233 | 60012.9 |
1245 | 2023-06-09 19:51:10 | roan | 2 | 29872 | 279 | 0.890 | 33564.0 |
1244 | 2023-06-08 22:56:34 | roan | 2 | 29872 | 279 | 0.906 | 32971.3 |
1243 | 2023-05-24 03:11:58 | roan | 1 | 13983 | 12 | 0.233 | 60012.9 |
1242 | 2023-05-17 23:21:59 | roan | 2 | 29872 | 279 | 0.766 | 38997.4 |
1241 | 2023-03-19 04:46:24 | roan | 1 | 13983 | 12 | 0.220 | 63559.1 |
1240 | 2023-03-05 21:10:11 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1239 | 2023-02-25 07:13:52 | roan | 2 | 29872 | 279 | 0.766 | 38997.4 |
1238 | 2023-01-04 22:42:32 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1237 | 2022-12-21 13:21:13 | roan | 2 | 29872 | 279 | 0.766 | 38997.4 |
1236 | 2022-12-19 22:53:01 | roan | 2 | 29872 | 279 | 0.940 | 31778.7 |
1235 | 2022-12-18 13:41:48 | roan | 2 | 29872 | 279 | 0.953 | 31345.2 |
1234 | 2022-12-17 18:14:28 | roan | 2 | 29872 | 279 | 0.860 | 34734.9 |
1233 | 2022-12-16 23:19:25 | roan | 2 | 29872 | 279 | 0.936 | 31914.5 |
1232 | 2022-12-15 22:28:48 | roan | 2 | 29872 | 279 | 1.610 | 18554.0 |
1231 | 2022-12-13 15:22:39 | roan | 2 | 29872 | 279 | 0.923 | 32364.0 |
1230 | 2022-12-12 19:51:23 | roan | 2 | 29872 | 279 | 0.970 | 30795.9 |
1229 | 2022-12-11 14:00:21 | roan | 2 | 29872 | 279 | 0.860 | 34734.9 |
1228 | 2022-12-09 15:57:00 | roan | 2 | 29872 | 279 | 1.000 | 29872.0 |
1227 | 2022-12-08 23:46:22 | roan | 2 | 29872 | 279 | 0.953 | 31345.2 |
1226 | 2022-12-06 05:57:11 | roan | 2 | 29872 | 279 | 0.860 | 34734.9 |
1225 | 2022-11-17 08:04:15 | roan | 1 | 13983 | 12 | 0.266 | 52567.7 |
1224 | 2022-11-13 16:25:11 | roan | 1 | 13983 | 12 | 0.233 | 60012.9 |
1223 | 2022-09-29 23:25:08 | roan | 1 | 13983 | 12 | 0.250 | 55932.0 |
1222 | 2022-09-16 19:35:30 | roan | 1 | 13983 | 12 | 0.216 | 64736.1 |
1221 | 2022-08-31 23:03:35 | roan | 1 | 13983 | 12 | 0.220 | 63559.1 |
1220 | 2022-08-07 16:16:59 | roan | 1 | 13983 | 12 | 0.220 | 63559.1 |
1219 | 2022-07-21 21:22:19 | roan | 2 | 29872 | 279 | 0.766 | 38997.4 |
1218 | 2022-07-20 20:11:49 | roan | 1 | 13983 | 12 | 0.233 | 60012.9 |
1217 | 2022-07-17 02:45:55 | roan | 1 | 13983 | 12 | 0.233 | 60012.9 |
1216 | 2022-05-14 18:49:09 | roan | 1 | 13983 | 12 | 0.220 | 63559.1 |
1215 | 2022-05-02 23:17:26 | roan | 2 | 29872 | 279 | 1.610 | 18554.0 |
1214 | 2022-05-01 12:50:55 | roan | 2 | 29872 | 279 | 0.970 | 30795.9 |
1213 | 2022-05-01 07:20:58 | roan | 2 | 29872 | 279 | 0.843 | 35435.3 |
1212 | 2022-04-30 13:18:44 | roan | 2 | 29872 | 279 | 0.796 | 37527.6 |
1211 | 2022-04-30 11:33:41 | roan | 2 | 29872 | 279 | 1.033 | 28917.7 |
1210 | 2022-04-29 06:33:36 | roan | 2 | 29872 | 279 | 1.970 | 15163.5 |
1209 | 2022-04-29 04:21:36 | roan | 2 | 29872 | 279 | 0.920 | 32469.6 |
1208 | 2022-04-28 13:31:19 | roan | 2 | 29872 | 279 | 0.843 | 35435.3 |
1207 | 2022-04-27 20:24:16 | roan | 2 | 29872 | 279 | 1.016 | 29401.6 |
1206 | 2022-04-27 03:59:02 | roan | 2 | 29872 | 279 | 0.780 | 38297.4 |
1205 | 2022-04-26 16:21:55 | roan | 2 | 29872 | 279 | 0.890 | 33564.0 |
1204 | 2022-04-26 04:50:18 | roan | 2 | 29872 | 279 | 0.780 | 38297.4 |
1203 | 2022-04-25 14:06:43 | roan | 2 | 29872 | 279 | 0.766 | 38997.4 |
1202 | 2022-04-24 22:47:34 | roan | 2 | 29872 | 279 | 0.860 | 34734.9 |
1201 | 2022-04-23 11:20:11 | roan | 2 | 29872 | 279 | 0.876 | 34100.5 |
1200 | 2022-04-22 14:00:07 | roan | 2 | 29872 | 279 | 1.220 | 24485.2 |
1199 | 2022-04-21 19:51:22 | roan | 2 | 29872 | 279 | 1.000 | 29872.0 |
1198 | 2022-04-21 06:50:17 | roan | 2 | 29872 | 279 | 0.783 | 38150.7 |
1197 | 2022-04-20 14:25:53 | roan | 2 | 29872 | 279 | 1.143 | 26134.7 |
1196 | 2022-04-20 01:23:24 | roan | 2 | 29872 | 279 | 1.123 | 26600.2 |
1195 | 2022-04-19 13:58:34 | roan | 2 | 29872 | 279 | 0.970 | 30795.9 |