History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"colonel"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 482 | 2025-08-22 19:44:47 | colonel | 1 | 69583 | 5 | 5.673 | 12265.6 |
| 481 | 2025-08-10 00:36:15 | colonel | 1 | 69583 | 5 | 3.096 | 22475.1 |
| 480 | 2025-08-05 15:10:02 | colonel | 1 | 69583 | 5 | 2.563 | 27149.0 |
| 479 | 2025-07-25 16:25:00 | colonel | 1 | 69583 | 5 | 3.093 | 22496.9 |
| 478 | 2025-07-24 06:00:53 | colonel | 1 | 69583 | 5 | 3.016 | 23071.3 |
| 477 | 2025-07-21 16:51:53 | colonel | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 476 | 2025-07-21 08:06:21 | colonel | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 475 | 2025-07-10 20:47:09 | colonel | 1 | 69583 | 5 | 5.500 | 12651.5 |
| 474 | 2025-07-04 15:12:51 | colonel | 3 | 134027 | 249 | 33.220 | 4034.5 |
| 473 | 2025-07-04 13:17:17 | colonel | 3 | 134027 | 249 | 34.673 | 3865.5 |
| 472 | 2025-07-02 15:16:53 | colonel | 1 | 69583 | 5 | 5.970 | 11655.4 |
| 471 | 2025-07-02 07:07:46 | colonel | 3 | 134027 | 249 | 20.003 | 6700.3 |
| 470 | 2025-07-01 14:25:04 | colonel | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 469 | 2025-06-21 20:21:53 | colonel | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 468 | 2025-06-20 05:36:15 | colonel | 1 | 69583 | 5 | 3.060 | 22739.5 |
| 467 | 2025-06-18 10:16:09 | colonel | 1 | 69583 | 5 | 3.656 | 19032.5 |
| 466 | 2025-06-16 14:49:10 | colonel | 1 | 69583 | 5 | 4.890 | 14229.7 |
| 465 | 2025-06-10 08:58:44 | colonel | 1 | 69583 | 5 | 3.610 | 19275.1 |
| 464 | 2025-06-07 05:16:57 | colonel | 1 | 69583 | 5 | 6.940 | 10026.4 |
| 463 | 2025-06-03 21:18:58 | colonel | 3 | 134027 | 249 | 38.330 | 3496.7 |
| 462 | 2025-06-03 11:11:55 | colonel | 3 | 134027 | 249 | 9.423 | 14223.4 |
| 461 | 2025-06-01 22:48:40 | colonel | 2 | 107671 | 33 | 22.030 | 4887.5 |
| 460 | 2025-06-01 14:11:58 | colonel | 3 | 134027 | 249 | 7.250 | 18486.5 |
| 459 | 2025-06-01 13:52:52 | colonel | 1 | 69583 | 5 | 2.986 | 23303.1 |
| 458 | 2025-05-31 23:37:23 | colonel | 1 | 69583 | 5 | 3.280 | 21214.3 |
| 457 | 2025-05-31 05:37:22 | colonel | 3 | 134027 | 249 | 29.596 | 4528.6 |
| 456 | 2025-05-31 04:35:52 | colonel | 1 | 69583 | 5 | 4.500 | 15462.9 |
| 455 | 2025-05-29 04:56:37 | colonel | 3 | 134027 | 249 | 21.580 | 6210.7 |
| 454 | 2025-05-27 10:38:52 | colonel | 1 | 69583 | 5 | 8.963 | 7763.4 |
| 453 | 2025-05-27 03:47:37 | colonel | 1 | 69583 | 5 | 4.766 | 14599.9 |
| 452 | 2025-05-26 10:39:02 | colonel | 3 | 134027 | 249 | 26.656 | 5028.0 |
| 451 | 2025-05-25 13:47:08 | colonel | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 450 | 2025-05-24 18:23:31 | colonel | 3 | 134027 | 249 | 24.380 | 5497.4 |
| 449 | 2025-05-23 07:58:35 | colonel | 1 | 69583 | 5 | 6.100 | 11407.0 |
| 448 | 2025-05-16 10:02:53 | colonel | 1 | 69583 | 5 | 8.313 | 8370.4 |
| 447 | 2025-05-10 08:52:49 | colonel | 1 | 69583 | 5 | 3.373 | 20629.4 |
| 446 | 2025-05-06 14:27:46 | colonel | 1 | 69583 | 5 | 5.956 | 11682.8 |
| 445 | 2025-04-23 15:29:50 | colonel | 1 | 69583 | 5 | 8.826 | 7883.9 |
| 444 | 2025-04-20 04:46:54 | colonel | 1 | 69583 | 5 | 5.670 | 12272.1 |
| 443 | 2025-04-17 04:25:53 | colonel | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 442 | 2025-04-14 12:14:57 | colonel | 3 | 134027 | 249 | 40.673 | 3295.2 |
| 441 | 2025-04-13 00:10:47 | colonel | 3 | 134027 | 249 | 6.436 | 20824.6 |
| 440 | 2025-04-12 09:32:39 | colonel | 1 | 69583 | 5 | 2.890 | 24077.2 |
| 439 | 2025-04-09 20:11:42 | colonel | 1 | 69583 | 5 | 4.283 | 16246.3 |
| 438 | 2025-04-03 13:44:55 | colonel | 1 | 69583 | 5 | 2.483 | 28023.8 |
| 437 | 2025-04-01 16:29:40 | colonel | 3 | 134027 | 249 | 12.750 | 10511.9 |
| 436 | 2025-04-01 12:43:17 | colonel | 3 | 134027 | 249 | 9.313 | 14391.4 |
| 435 | 2025-03-31 16:21:56 | colonel | 1 | 69583 | 5 | 5.453 | 12760.5 |
| 434 | 2025-03-30 14:07:43 | colonel | 3 | 134027 | 249 | 29.596 | 4528.6 |
| 433 | 2025-03-26 07:07:48 | colonel | 3 | 134027 | 249 | 35.503 | 3775.1 |
| 432 | 2025-03-23 22:31:14 | colonel | 2 | 107671 | 33 | 18.296 | 5884.9 |
| 431 | 2025-03-23 22:09:45 | colonel | 3 | 134027 | 249 | 42.113 | 3182.6 |
| 430 | 2025-03-22 15:22:33 | colonel | 1 | 69583 | 5 | 6.326 | 10999.5 |
| 429 | 2025-03-20 06:52:43 | colonel | 1 | 69583 | 5 | 3.076 | 22621.3 |
| 428 | 2025-03-15 03:47:47 | colonel | 1 | 69583 | 5 | 2.813 | 24736.2 |
| 427 | 2025-03-13 08:06:14 | colonel | 1 | 69583 | 5 | 5.970 | 11655.4 |
| 426 | 2025-03-13 07:11:09 | colonel | 3 | 134027 | 249 | 33.393 | 4013.6 |
| 425 | 2025-03-08 12:38:11 | colonel | 1 | 69583 | 5 | 5.563 | 12508.2 |
| 424 | 2025-03-06 18:04:51 | colonel | 2 | 107671 | 33 | 17.110 | 6292.9 |
| 423 | 2025-03-03 03:19:25 | colonel | 1 | 69583 | 5 | 2.313 | 30083.4 |
| 422 | 2025-02-26 02:44:58 | colonel | 3 | 134027 | 249 | 40.190 | 3334.8 |
| 421 | 2025-02-25 20:52:37 | colonel | 3 | 134027 | 249 | 38.003 | 3526.7 |
| 420 | 2025-02-25 13:48:11 | colonel | 3 | 134027 | 249 | 18.530 | 7233.0 |
| 419 | 2025-02-25 03:56:20 | colonel | 3 | 134027 | 249 | 33.623 | 3986.2 |
| 418 | 2025-02-23 22:50:56 | colonel | 3 | 134027 | 249 | 40.863 | 3279.9 |
| 417 | 2025-02-21 17:15:12 | colonel | 3 | 134027 | 249 | 30.236 | 4432.7 |
| 416 | 2025-02-21 17:15:09 | colonel | 2 | 107671 | 33 | 18.596 | 5790.0 |
| 415 | 2025-02-21 17:14:48 | colonel | 1 | 69583 | 5 | 3.626 | 19190.0 |
| 414 | 2025-01-27 00:56:01 | colonel | 3 | 134027 | 249 | 32.860 | 4078.7 |
| 413 | 2025-01-25 06:22:07 | colonel | 3 | 134027 | 249 | 23.440 | 5717.9 |
| 412 | 2025-01-24 16:26:04 | colonel | 3 | 134027 | 249 | 31.203 | 4295.3 |
| 411 | 2025-01-10 02:38:18 | colonel | 3 | 134027 | 249 | 38.063 | 3521.2 |
| 410 | 2025-01-10 02:38:20 | colonel | 2 | 107671 | 33 | 16.626 | 6476.1 |
| 409 | 2025-01-02 02:00:20 | colonel | 2 | 107671 | 33 | 17.266 | 6236.0 |
| 408 | 2025-01-02 01:59:09 | colonel | 1 | 69583 | 5 | 3.203 | 21724.3 |
| 407 | 2025-01-01 02:06:34 | colonel | 1 | 69583 | 5 | 7.080 | 9828.1 |
| 406 | 2024-12-30 07:29:00 | colonel | 1 | 69583 | 5 | 4.796 | 14508.5 |
| 405 | 2024-12-27 08:22:01 | colonel | 1 | 69583 | 5 | 3.533 | 19695.2 |
| 404 | 2024-12-26 12:02:54 | colonel | 1 | 69583 | 5 | 5.766 | 12067.8 |
| 403 | 2024-12-24 05:23:46 | colonel | 3 | 134027 | 249 | 47.956 | 2794.8 |
| 402 | 2024-12-21 08:58:38 | colonel | 3 | 134027 | 249 | 25.376 | 5281.6 |
| 401 | 2024-12-10 15:37:39 | colonel | 3 | 134027 | 249 | 17.283 | 7754.8 |
| 400 | 2024-12-10 05:53:59 | colonel | 3 | 134027 | 249 | 43.283 | 3096.5 |
| 399 | 2024-12-10 05:53:59 | colonel | 2 | 107671 | 33 | 17.123 | 6288.1 |
| 398 | 2024-11-28 13:33:38 | colonel | 1 | 69583 | 5 | 4.330 | 16070.0 |
| 397 | 2024-11-25 01:15:31 | colonel | 1 | 69583 | 5 | 4.486 | 15511.1 |
| 396 | 2024-11-22 16:51:40 | colonel | 1 | 69583 | 5 | 6.203 | 11217.6 |
| 395 | 2024-11-21 08:08:52 | colonel | 3 | 134027 | 249 | 35.533 | 3771.9 |
| 394 | 2024-11-20 18:32:19 | colonel | 3 | 134027 | 249 | 44.020 | 3044.7 |
| 393 | 2024-11-18 16:16:23 | colonel | 3 | 134027 | 249 | 45.813 | 2925.5 |
| 392 | 2024-11-18 16:16:28 | colonel | 2 | 107671 | 33 | 16.453 | 6544.2 |
| 391 | 2024-11-06 13:46:55 | colonel | 2 | 107671 | 33 | 10.000 | 10767.1 |
| 390 | 2024-11-06 12:48:49 | colonel | 3 | 134027 | 249 | 7.093 | 18895.7 |
| 389 | 2024-11-06 12:48:50 | colonel | 2 | 107671 | 33 | 3.593 | 29966.9 |
| 388 | 2024-10-27 23:06:27 | colonel | 1 | 69583 | 5 | 5.983 | 11630.1 |
| 387 | 2024-10-25 17:51:17 | colonel | 1 | 69583 | 5 | 5.780 | 12038.6 |
| 386 | 2024-10-21 22:52:49 | colonel | 2 | 107671 | 33 | 12.313 | 8744.5 |
| 385 | 2024-10-21 04:59:21 | colonel | 3 | 134027 | 249 | 48.093 | 2786.8 |
| 384 | 2024-10-21 01:56:45 | colonel | 3 | 134027 | 249 | 24.376 | 5498.3 |
| 383 | 2024-10-21 00:15:01 | colonel | 1 | 69583 | 5 | 3.233 | 21522.7 |