History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preflight"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 394 | 2025-10-27 08:59:00 | preflight | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 393 | 2025-10-19 00:27:21 | preflight | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 392 | 2025-10-11 02:57:52 | preflight | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 391 | 2025-10-09 05:07:45 | preflight | 1 | 81242 | 3 | 1.576 | 51549.5 |
| 390 | 2025-10-08 13:05:59 | preflight | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 389 | 2025-10-08 08:57:12 | preflight | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 388 | 2025-09-29 14:09:07 | preflight | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 387 | 2025-09-28 14:06:06 | preflight | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 386 | 2025-09-25 10:13:25 | preflight | 1 | 81242 | 3 | 5.280 | 15386.7 |
| 385 | 2025-09-21 11:10:29 | preflight | 2 | 121436 | 7 | 3.406 | 35653.6 |
| 384 | 2025-09-17 13:49:10 | preflight | 3 | 148641 | 34 | 7.736 | 19214.2 |
| 383 | 2025-09-14 00:47:33 | preflight | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 382 | 2025-09-09 14:54:30 | preflight | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 381 | 2025-09-08 05:33:16 | preflight | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 380 | 2025-09-07 15:53:33 | preflight | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 379 | 2025-09-07 15:52:38 | preflight | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 378 | 2025-09-06 23:34:20 | preflight | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 377 | 2025-08-29 15:27:06 | preflight | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 376 | 2025-08-27 13:52:01 | preflight | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 375 | 2025-08-11 16:57:19 | preflight | 4 | 165329 | 187 | 53.973 | 3063.2 |
| 374 | 2025-08-11 16:57:08 | preflight | 4 | 165329 | 187 | 56.880 | 2906.6 |
| 373 | 2025-08-10 17:11:36 | preflight | 4 | 165329 | 187 | 31.146 | 5308.2 |
| 372 | 2025-08-10 15:25:52 | preflight | 3 | 148641 | 34 | 22.753 | 6532.8 |
| 371 | 2025-08-09 02:44:26 | preflight | 1 | 81242 | 3 | 8.110 | 10017.5 |
| 370 | 2025-08-05 13:14:16 | preflight | 3 | 148641 | 34 | 18.360 | 8095.9 |
| 369 | 2025-08-05 05:25:46 | preflight | 1 | 81242 | 3 | 3.186 | 25499.7 |
| 368 | 2025-08-05 05:21:39 | preflight | 2 | 121436 | 7 | 9.033 | 13443.6 |
| 367 | 2025-08-05 01:40:30 | preflight | 4 | 165329 | 187 | 33.393 | 4951.0 |
| 366 | 2025-08-04 10:34:27 | preflight | 1 | 81242 | 3 | 5.296 | 15340.3 |
| 365 | 2025-08-01 03:43:55 | preflight | 1 | 81242 | 3 | 3.133 | 25931.1 |
| 364 | 2025-07-31 05:20:37 | preflight | 1 | 81242 | 3 | 1.733 | 46879.4 |
| 363 | 2025-07-17 15:47:19 | preflight | 3 | 148641 | 34 | 18.346 | 8102.1 |
| 362 | 2025-07-17 02:29:23 | preflight | 2 | 121436 | 7 | 25.956 | 4678.5 |
| 361 | 2025-07-16 14:41:53 | preflight | 1 | 81242 | 3 | 4.173 | 19468.5 |
| 360 | 2025-07-11 17:22:29 | preflight | 1 | 81242 | 3 | 7.203 | 11278.9 |
| 359 | 2025-07-10 11:49:52 | preflight | 2 | 121436 | 7 | 3.593 | 33797.9 |
| 358 | 2025-07-10 08:44:18 | preflight | 2 | 121436 | 7 | 13.093 | 9274.9 |
| 357 | 2025-07-02 09:43:52 | preflight | 1 | 81242 | 3 | 3.906 | 20799.3 |
| 356 | 2025-06-28 05:30:39 | preflight | 2 | 121436 | 7 | 30.160 | 4026.4 |
| 355 | 2025-06-28 00:29:19 | preflight | 3 | 148641 | 34 | 35.410 | 4197.7 |
| 354 | 2025-06-27 22:07:03 | preflight | 3 | 148641 | 34 | 37.440 | 3970.1 |
| 353 | 2025-06-27 02:52:44 | preflight | 1 | 81242 | 3 | 3.780 | 21492.6 |
| 352 | 2025-06-14 14:07:34 | preflight | 1 | 81242 | 3 | 3.953 | 20552.0 |
| 351 | 2025-05-28 21:19:26 | preflight | 2 | 121436 | 7 | 14.876 | 8163.2 |
| 350 | 2025-05-28 16:09:15 | preflight | 3 | 148641 | 34 | 7.156 | 20771.5 |
| 349 | 2025-05-23 11:03:51 | preflight | 1 | 81242 | 3 | 3.623 | 22424.0 |
| 348 | 2025-05-20 14:27:18 | preflight | 1 | 81242 | 3 | 8.003 | 10151.4 |
| 347 | 2025-05-20 12:56:53 | preflight | 1 | 81242 | 3 | 3.720 | 21839.2 |
| 346 | 2025-05-17 04:07:14 | preflight | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 345 | 2025-05-14 19:32:53 | preflight | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 344 | 2025-05-14 13:48:57 | preflight | 1 | 81242 | 3 | 7.936 | 10237.1 |
| 343 | 2025-04-28 02:39:33 | preflight | 3 | 148641 | 34 | 49.973 | 2974.4 |
| 342 | 2025-04-28 00:46:12 | preflight | 3 | 148641 | 34 | 37.406 | 3973.7 |
| 341 | 2025-04-23 20:44:13 | preflight | 3 | 148641 | 34 | 37.890 | 3923.0 |
| 340 | 2025-04-23 18:15:19 | preflight | 3 | 148641 | 34 | 14.813 | 10034.5 |
| 339 | 2025-04-20 14:05:23 | preflight | 3 | 148641 | 34 | 26.800 | 5546.3 |
| 338 | 2025-04-18 13:20:29 | preflight | 1 | 81242 | 3 | 3.203 | 25364.3 |
| 337 | 2025-04-11 14:17:18 | preflight | 1 | 81242 | 3 | 3.906 | 20799.3 |
| 336 | 2025-03-23 17:45:11 | preflight | 3 | 148641 | 34 | 38.253 | 3885.7 |
| 335 | 2025-03-23 10:31:03 | preflight | 1 | 81242 | 3 | 3.343 | 24302.1 |
| 334 | 2025-03-21 02:12:21 | preflight | 3 | 148641 | 34 | 34.190 | 4347.5 |
| 333 | 2025-03-18 16:40:50 | preflight | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 332 | 2025-03-14 03:59:05 | preflight | 3 | 148641 | 34 | 35.250 | 4216.8 |
| 331 | 2025-03-14 03:58:58 | preflight | 3 | 148641 | 34 | 37.750 | 3937.5 |
| 330 | 2025-03-14 03:58:55 | preflight | 2 | 121436 | 7 | 9.186 | 13219.7 |
| 329 | 2025-03-10 19:26:22 | preflight | 3 | 148641 | 34 | 32.516 | 4571.3 |
| 328 | 2025-03-10 13:04:31 | preflight | 1 | 81242 | 3 | 8.560 | 9490.9 |
| 327 | 2025-03-09 22:40:42 | preflight | 4 | 165329 | 187 | 60.333 | 2740.3 |
| 326 | 2025-03-09 22:40:41 | preflight | 3 | 148641 | 34 | 36.936 | 4024.3 |
| 325 | 2025-03-09 22:40:27 | preflight | 2 | 121436 | 7 | 18.376 | 6608.4 |
| 324 | 2025-03-09 22:37:57 | preflight | 1 | 81242 | 3 | 3.733 | 21763.2 |
| 323 | 2025-03-08 20:43:29 | preflight | 3 | 148641 | 34 | 12.810 | 11603.5 |
| 322 | 2025-02-27 19:32:02 | preflight | 3 | 148641 | 34 | 40.953 | 3629.6 |
| 321 | 2025-02-25 17:05:14 | preflight | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 320 | 2025-02-23 04:47:54 | preflight | 2 | 121436 | 7 | 9.453 | 12846.3 |
| 319 | 2025-02-23 04:47:20 | preflight | 1 | 81242 | 3 | 2.686 | 30246.5 |
| 318 | 2025-02-23 04:45:05 | preflight | 3 | 148641 | 34 | 37.423 | 3971.9 |
| 317 | 2025-02-17 09:38:05 | preflight | 2 | 121436 | 7 | 9.063 | 13399.1 |
| 316 | 2025-02-17 09:37:16 | preflight | 1 | 81242 | 3 | 4.046 | 20079.6 |
| 315 | 2025-02-15 08:15:19 | preflight | 3 | 148641 | 34 | 32.613 | 4557.7 |
| 314 | 2025-02-09 01:22:47 | preflight | 4 | 165329 | 187 | 78.470 | 2106.9 |
| 313 | 2025-02-06 19:41:35 | preflight | 4 | 165329 | 187 | 58.266 | 2837.5 |
| 312 | 2025-02-06 19:41:31 | preflight | 2 | 121436 | 7 | 16.156 | 7516.5 |
| 311 | 2025-02-06 19:41:28 | preflight | 1 | 81242 | 3 | 3.046 | 26671.7 |
| 310 | 2025-01-24 20:08:56 | preflight | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 309 | 2025-01-23 14:34:05 | preflight | 3 | 148641 | 34 | 29.206 | 5089.4 |
| 308 | 2025-01-22 17:55:40 | preflight | 3 | 148641 | 34 | 34.690 | 4284.8 |
| 307 | 2025-01-20 02:46:21 | preflight | 1 | 81242 | 3 | 7.000 | 11606.0 |
| 306 | 2025-01-14 04:02:15 | preflight | 3 | 148641 | 34 | 35.003 | 4246.5 |
| 305 | 2025-01-13 09:30:41 | preflight | 1 | 81242 | 3 | 4.720 | 17212.3 |
| 304 | 2025-01-03 14:10:37 | preflight | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 303 | 2024-12-15 05:01:54 | preflight | 3 | 148641 | 34 | 36.300 | 4094.8 |
| 302 | 2024-12-15 05:00:53 | preflight | 1 | 81242 | 3 | 7.063 | 11502.5 |
| 301 | 2024-12-10 09:41:15 | preflight | 3 | 148641 | 34 | 37.893 | 3922.7 |
| 300 | 2024-12-08 17:35:07 | preflight | 3 | 148641 | 34 | 34.343 | 4328.1 |
| 299 | 2024-12-08 17:35:04 | preflight | 3 | 148641 | 34 | 37.016 | 4015.6 |
| 298 | 2024-12-08 17:35:05 | preflight | 2 | 121436 | 7 | 9.233 | 13152.4 |
| 297 | 2024-12-08 17:35:01 | preflight | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 296 | 2024-12-02 17:02:06 | preflight | 1 | 81242 | 3 | 5.783 | 14048.4 |
| 295 | 2024-11-13 15:28:55 | preflight | 1 | 81242 | 3 | 1.483 | 54782.2 |