History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"face"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1322 | 2024-04-27 16:57:53 | face | 1 | 13983 | 24 | 0.283 | 49409.9 |
1321 | 2024-04-26 10:15:26 | face | 1 | 13983 | 24 | 0.263 | 53167.3 |
1320 | 2024-04-25 23:38:48 | face | 2 | 29872 | 382 | 2.610 | 11445.2 |
1319 | 2024-04-20 23:07:14 | face | 1 | 13983 | 24 | 0.716 | 19529.3 |
1318 | 2024-04-16 07:31:37 | face | 1 | 13983 | 24 | 0.283 | 49409.9 |
1317 | 2024-04-16 06:51:49 | face | 1 | 13983 | 24 | 0.266 | 52567.7 |
1316 | 2024-04-13 02:33:24 | face | 1 | 13983 | 24 | 0.283 | 49409.9 |
1315 | 2024-04-07 19:35:16 | face | 1 | 13983 | 24 | 0.263 | 53167.3 |
1314 | 2024-04-02 18:49:20 | face | 2 | 29872 | 382 | 2.093 | 14272.3 |
1313 | 2024-04-01 15:50:36 | face | 1 | 13983 | 24 | 0.483 | 28950.3 |
1312 | 2024-03-31 00:26:37 | face | 1 | 13983 | 24 | 0.546 | 25609.9 |
1311 | 2024-03-09 19:34:36 | face | 1 | 13983 | 24 | 0.623 | 22444.6 |
1310 | 2024-03-03 20:10:31 | face | 2 | 29872 | 382 | 0.843 | 35435.3 |
1309 | 2024-03-02 18:10:35 | face | 2 | 29872 | 382 | 1.250 | 23897.6 |
1308 | 2024-03-02 18:05:50 | face | 1 | 13983 | 24 | 0.266 | 52567.7 |
1307 | 2024-03-02 17:38:29 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1306 | 2024-03-02 13:01:21 | face | 1 | 13983 | 24 | 0.266 | 52567.7 |
1305 | 2024-02-25 17:02:00 | face | 1 | 13983 | 24 | 0.533 | 26234.5 |
1304 | 2024-01-28 14:55:36 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1303 | 2024-01-25 19:53:29 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1302 | 2024-01-20 16:02:40 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1301 | 2024-01-04 08:25:47 | face | 1 | 13983 | 24 | 0.436 | 32071.1 |
1300 | 2024-01-02 02:36:18 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1299 | 2023-12-29 15:58:39 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1298 | 2023-12-19 19:56:54 | face | 2 | 29872 | 382 | 0.923 | 32364.0 |
1297 | 2023-12-03 09:24:40 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1296 | 2023-12-03 09:24:40 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1295 | 2023-11-27 09:48:29 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1294 | 2023-11-16 01:14:59 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1293 | 2023-11-12 00:00:13 | face | 2 | 29872 | 382 | 0.890 | 33564.0 |
1292 | 2023-11-11 10:27:18 | face | 2 | 29872 | 382 | 0.890 | 33564.0 |
1291 | 2023-11-08 03:03:26 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1290 | 2023-11-07 13:11:28 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1289 | 2023-11-02 01:53:25 | face | 2 | 29872 | 382 | 0.750 | 39829.3 |
1288 | 2023-11-01 02:14:42 | face | 2 | 29872 | 382 | 0.780 | 38297.4 |
1287 | 2023-10-26 00:50:13 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1286 | 2023-10-24 17:59:52 | face | 2 | 29872 | 382 | 0.796 | 37527.6 |
1285 | 2023-10-23 12:38:07 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1284 | 2023-10-22 14:49:18 | face | 2 | 29872 | 382 | 0.766 | 38997.4 |
1283 | 2023-10-20 02:41:59 | face | 2 | 29872 | 382 | 0.843 | 35435.3 |
1282 | 2023-10-19 15:48:12 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1281 | 2023-10-18 14:45:21 | face | 2 | 29872 | 382 | 0.750 | 39829.3 |
1280 | 2023-10-17 08:43:44 | face | 2 | 29872 | 382 | 1.390 | 21490.6 |
1279 | 2023-10-16 19:33:49 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1278 | 2023-10-10 23:24:36 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1277 | 2023-10-07 09:23:24 | face | 2 | 29872 | 382 | 0.750 | 39829.3 |
1276 | 2023-10-03 11:51:21 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1275 | 2023-09-23 00:09:18 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1274 | 2023-09-20 04:22:37 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1273 | 2023-09-11 05:35:59 | face | 2 | 29872 | 382 | 0.766 | 38997.4 |
1272 | 2023-09-10 11:43:58 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1271 | 2023-09-02 19:04:16 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1270 | 2023-06-16 03:04:41 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1269 | 2023-06-06 19:32:55 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1268 | 2023-05-13 20:06:51 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1267 | 2023-03-28 11:44:55 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1266 | 2023-03-27 13:23:00 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1265 | 2023-03-10 09:49:01 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1264 | 2023-01-11 12:51:53 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1263 | 2022-12-02 04:02:59 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1262 | 2022-11-28 20:58:48 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1261 | 2022-11-24 20:31:44 | face | 1 | 13983 | 24 | 0.200 | 69915.0 |
1260 | 2022-10-20 08:49:33 | face | 1 | 13983 | 24 | 0.360 | 38841.7 |
1259 | 2022-08-25 10:53:14 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1258 | 2022-06-11 03:28:15 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1257 | 2022-05-23 02:52:20 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1256 | 2022-05-19 16:54:36 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1255 | 2022-05-18 19:41:21 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1254 | 2022-05-18 08:56:05 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1253 | 2022-05-17 18:37:31 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1252 | 2022-05-17 00:52:47 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1251 | 2022-05-16 12:42:00 | face | 1 | 13983 | 24 | 0.360 | 38841.7 |
1250 | 2022-05-15 23:15:19 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1249 | 2022-05-14 16:11:59 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1248 | 2022-05-14 05:57:39 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1247 | 2022-05-13 22:57:47 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1246 | 2022-05-13 12:59:40 | face | 1 | 13983 | 24 | 0.360 | 38841.7 |
1245 | 2022-05-13 03:44:09 | face | 1 | 13983 | 24 | 0.330 | 42372.7 |
1244 | 2022-05-12 14:38:43 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1243 | 2022-05-11 21:16:09 | face | 1 | 13983 | 24 | 0.216 | 64736.1 |
1242 | 2022-05-11 09:33:46 | face | 1 | 13983 | 24 | 0.326 | 42892.6 |
1241 | 2022-05-10 22:58:44 | face | 1 | 13983 | 24 | 0.410 | 34104.9 |
1240 | 2022-05-10 03:37:19 | face | 1 | 13983 | 24 | 0.326 | 42892.6 |
1239 | 2022-05-08 16:27:06 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1238 | 2022-05-08 03:40:01 | face | 1 | 13983 | 24 | 0.203 | 68881.8 |
1237 | 2022-05-07 17:39:52 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1236 | 2022-04-08 20:25:46 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |
1235 | 2022-04-08 07:06:09 | face | 1 | 13983 | 24 | 0.516 | 27098.8 |
1234 | 2022-04-07 22:38:17 | face | 1 | 13983 | 24 | 0.236 | 59250.0 |
1233 | 2022-04-07 08:48:34 | face | 1 | 13983 | 24 | 0.263 | 53167.3 |
1232 | 2022-04-06 18:40:38 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1231 | 2022-04-06 05:53:20 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1230 | 2022-04-05 23:43:39 | face | 1 | 13983 | 24 | 0.233 | 60012.9 |
1229 | 2022-04-04 21:31:57 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1228 | 2022-04-04 08:28:45 | face | 1 | 13983 | 24 | 0.483 | 28950.3 |
1227 | 2022-04-03 14:31:22 | face | 1 | 13983 | 24 | 0.266 | 52567.7 |
1226 | 2022-04-02 14:02:03 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1225 | 2022-04-01 21:48:38 | face | 1 | 13983 | 24 | 0.236 | 59250.0 |
1224 | 2022-04-01 07:06:00 | face | 1 | 13983 | 24 | 0.250 | 55932.0 |
1223 | 2022-03-01 22:02:33 | face | 1 | 13983 | 24 | 0.220 | 63559.1 |