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 |
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 |
1256 | 2020-10-23 17:26:53 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
1255 | 2020-10-13 21:31:53 | first | 1 | 28756 | 4 | 0.483 | 59536.2 |
1254 | 2020-09-06 16:26:07 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |
1253 | 2020-09-03 05:14:29 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
1252 | 2020-08-09 11:13:11 | first | 1 | 28756 | 4 | 0.453 | 63479.0 |
1251 | 2020-08-06 15:16:02 | first | 1 | 28756 | 4 | 0.440 | 65354.5 |
1250 | 2020-07-30 21:51:14 | first | 1 | 28756 | 4 | 0.500 | 57512.0 |
1249 | 2020-07-14 15:58:49 | first | 1 | 28756 | 4 | 0.453 | 63479.0 |
1248 | 2020-06-03 16:54:23 | first | 1 | 28756 | 4 | 0.486 | 59168.7 |
1247 | 2020-05-08 06:08:11 | first | 1 | 28756 | 4 | 0.453 | 63479.0 |
1246 | 2020-03-28 14:50:09 | first | 3 | 83667 | 1220 | 5.013 | 16690.0 |
1245 | 2020-03-28 12:40:19 | first | 3 | 83667 | 1220 | 4.313 | 19398.8 |
1244 | 2020-03-28 03:45:59 | first | 3 | 83667 | 1220 | 5.186 | 16133.2 |
1243 | 2020-03-26 21:03:32 | first | 1 | 28756 | 4 | 1.080 | 26625.9 |
1242 | 2020-03-25 05:18:00 | first | 1 | 28756 | 4 | 0.436 | 65954.1 |