History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"first"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1356 | 2024-05-01 17:52:21 | first | 1 | 28756 | 4 | 0.593 | 48492.4 |
| 1355 | 2024-05-01 06:49:59 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1354 | 2024-04-29 21:42:05 | first | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 1353 | 2024-04-27 08:27:44 | first | 2 | 53800 | 98 | 2.390 | 22510.5 |
| 1352 | 2024-04-27 06:16:54 | first | 1 | 28756 | 4 | 0.563 | 51076.4 |
| 1351 | 2024-04-08 18:54:32 | first | 1 | 28756 | 4 | 0.953 | 30174.2 |
| 1350 | 2024-04-06 05:57:45 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1349 | 2024-04-02 18:51:38 | first | 2 | 53800 | 98 | 3.766 | 14285.7 |
| 1348 | 2024-04-01 17:36:37 | first | 2 | 53800 | 98 | 5.626 | 9562.7 |
| 1347 | 2024-03-31 15:33:03 | first | 2 | 53800 | 98 | 3.436 | 15657.7 |
| 1346 | 2024-03-31 15:33:02 | first | 3 | 83667 | 1220 | 4.703 | 17790.1 |
| 1345 | 2024-03-31 15:32:56 | first | 1 | 28756 | 4 | 1.093 | 26309.2 |
| 1344 | 2024-03-31 15:32:26 | first | 3 | 83667 | 1220 | 3.580 | 23370.7 |
| 1343 | 2024-03-31 15:32:25 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1342 | 2024-03-29 23:49:45 | first | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 1341 | 2024-03-09 00:26:27 | first | 1 | 28756 | 4 | 1.576 | 18246.2 |
| 1340 | 2024-03-07 04:10:03 | first | 1 | 28756 | 4 | 0.563 | 51076.4 |
| 1339 | 2024-03-05 07:47:08 | first | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 1338 | 2024-03-01 11:45:31 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1337 | 2024-02-29 18:03:45 | first | 2 | 53800 | 98 | 3.080 | 17467.5 |
| 1336 | 2024-02-29 18:03:16 | first | 3 | 83667 | 1220 | 3.860 | 21675.4 |
| 1335 | 2024-02-28 19:48:01 | first | 3 | 83667 | 1220 | 8.890 | 9411.4 |
| 1334 | 2024-02-28 19:26:26 | first | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 1333 | 2024-02-18 13:48:59 | first | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 1332 | 2024-02-07 04:47:01 | first | 2 | 53800 | 98 | 1.706 | 31535.8 |
| 1331 | 2024-02-07 04:46:57 | first | 3 | 83667 | 1220 | 3.703 | 22594.4 |
| 1330 | 2024-02-07 04:46:53 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1329 | 2024-02-03 20:45:19 | first | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1328 | 2024-01-29 07:37:37 | first | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1327 | 2024-01-16 01:23:04 | first | 2 | 53800 | 98 | 1.500 | 35866.7 |
| 1326 | 2024-01-16 01:22:33 | first | 3 | 83667 | 1220 | 3.920 | 21343.6 |
| 1325 | 2024-01-08 02:55:03 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1324 | 2023-12-30 04:26:28 | first | 3 | 83667 | 1220 | 3.453 | 24230.2 |
| 1323 | 2023-12-30 04:26:30 | first | 2 | 53800 | 98 | 1.610 | 33416.1 |
| 1322 | 2023-12-15 09:31:43 | first | 3 | 83667 | 1220 | 3.936 | 21256.9 |
| 1321 | 2023-12-15 09:31:38 | first | 2 | 53800 | 98 | 1.780 | 30224.7 |
| 1320 | 2023-12-10 04:44:29 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1319 | 2023-12-07 23:14:28 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1318 | 2023-12-07 23:14:27 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1317 | 2023-11-16 13:44:32 | first | 1 | 28756 | 4 | 0.580 | 49579.3 |
| 1316 | 2023-11-13 23:47:49 | first | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 1315 | 2023-11-11 08:38:56 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1314 | 2023-11-05 01:12:33 | first | 2 | 53800 | 98 | 1.500 | 35866.7 |
| 1313 | 2023-11-05 01:12:29 | first | 3 | 83667 | 1220 | 3.296 | 25384.4 |
| 1312 | 2023-11-02 01:55:47 | first | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 1311 | 2023-10-21 02:46:39 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1310 | 2023-10-18 15:55:08 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1309 | 2023-10-12 01:21:32 | first | 1 | 28756 | 4 | 0.440 | 65354.5 |
| 1308 | 2023-10-05 01:26:14 | first | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 1307 | 2023-09-24 12:06:30 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1306 | 2023-09-24 06:55:22 | first | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 1305 | 2023-09-12 01:56:41 | first | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 1304 | 2023-08-03 03:55:58 | first | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1303 | 2023-07-22 01:10:23 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1302 | 2023-04-25 16:56:06 | first | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 1301 | 2023-04-20 13:09:34 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1300 | 2023-02-11 13:33:12 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1299 | 2023-01-09 14:41:37 | first | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1298 | 2022-12-09 23:26:42 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1297 | 2022-11-14 16:48:13 | first | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1296 | 2022-09-25 19:25:33 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1295 | 2022-08-11 05:13:08 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1294 | 2022-08-08 19:19:57 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1293 | 2022-06-16 02:43:18 | first | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1292 | 2022-06-02 11:28:06 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1291 | 2022-03-31 10:22:39 | first | 1 | 28756 | 4 | 0.656 | 43835.4 |
| 1290 | 2022-03-04 03:57:38 | first | 1 | 28756 | 4 | 0.610 | 47141.0 |
| 1289 | 2022-02-28 18:13:48 | first | 1 | 28756 | 4 | 0.533 | 53951.2 |
| 1288 | 2022-01-25 20:19:18 | first | 1 | 28756 | 4 | 0.440 | 65354.5 |
| 1287 | 2022-01-03 17:01:29 | first | 1 | 28756 | 4 | 0.576 | 49923.6 |
| 1286 | 2022-01-02 00:15:37 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1285 | 2021-12-25 10:41:42 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1284 | 2021-11-23 22:52:36 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1283 | 2021-11-02 16:34:41 | first | 1 | 28756 | 4 | 0.513 | 56054.6 |
| 1282 | 2021-11-02 10:44:00 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1281 | 2021-11-01 10:01:07 | first | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 1280 | 2021-10-31 09:45:57 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1279 | 2021-10-02 14:03:46 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1278 | 2021-08-24 08:24:24 | first | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 1277 | 2021-08-20 21:50:16 | first | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1276 | 2021-06-23 18:49:24 | first | 3 | 83667 | 1220 | 3.250 | 25743.7 |
| 1275 | 2021-06-06 12:19:29 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1274 | 2021-06-04 08:05:34 | first | 3 | 83667 | 1220 | 3.906 | 21420.1 |
| 1273 | 2021-05-20 07:26:04 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1272 | 2021-05-12 13:17:46 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1271 | 2021-04-11 09:18:48 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1270 | 2021-04-04 16:56:40 | first | 3 | 83667 | 1220 | 4.000 | 20916.8 |
| 1269 | 2021-03-12 23:14:49 | first | 3 | 83667 | 1220 | 3.516 | 23796.1 |
| 1268 | 2021-02-21 18:28:31 | first | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 1267 | 2021-02-18 11:15:22 | first | 1 | 28756 | 4 | 0.890 | 32310.1 |
| 1266 | 2021-02-17 15:38:18 | first | 1 | 28756 | 4 | 0.440 | 65354.5 |
| 1265 | 2021-02-16 08:09:58 | first | 3 | 83667 | 1220 | 3.860 | 21675.4 |
| 1264 | 2021-02-01 13:30:58 | first | 3 | 83667 | 1220 | 3.300 | 25353.6 |
| 1263 | 2020-12-27 22:25:03 | first | 3 | 83667 | 1220 | 3.296 | 25384.4 |
| 1262 | 2020-12-23 10:35:39 | first | 3 | 83667 | 1220 | 3.266 | 25617.6 |
| 1261 | 2020-11-30 09:13:59 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1260 | 2020-11-13 09:52:17 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1259 | 2020-11-02 04:15:47 | first | 3 | 83667 | 1220 | 3.890 | 21508.2 |
| 1258 | 2020-11-01 03:03:37 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1257 | 2020-10-25 19:41:17 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |