History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"troops"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 486 | 2024-05-06 23:11:17 | troops | 2 | 82551 | 90 | 2.560 | 32246.5 |
| 485 | 2024-05-06 23:10:57 | troops | 3 | 112716 | 778 | 4.953 | 22757.1 |
| 484 | 2024-05-06 19:51:08 | troops | 2 | 82551 | 90 | 3.216 | 25668.8 |
| 483 | 2024-05-06 19:49:43 | troops | 3 | 112716 | 778 | 15.360 | 7338.3 |
| 482 | 2024-05-06 19:49:48 | troops | 2 | 82551 | 90 | 5.970 | 13827.6 |
| 481 | 2024-05-06 19:49:40 | troops | 1 | 48755 | 4 | 1.860 | 26212.4 |
| 480 | 2024-05-06 19:49:12 | troops | 3 | 112716 | 778 | 8.266 | 13636.1 |
| 479 | 2024-05-06 05:48:16 | troops | 3 | 112716 | 778 | 6.110 | 18447.8 |
| 478 | 2024-05-05 12:42:55 | troops | 1 | 48755 | 4 | 0.810 | 60191.4 |
| 477 | 2024-05-04 03:22:07 | troops | 1 | 48755 | 4 | 0.953 | 51159.5 |
| 476 | 2024-04-03 06:33:10 | troops | 1 | 48755 | 4 | 2.876 | 16952.4 |
| 475 | 2024-03-05 19:04:09 | troops | 3 | 112716 | 778 | 16.190 | 6962.1 |
| 474 | 2024-03-05 08:41:39 | troops | 3 | 112716 | 778 | 6.830 | 16503.1 |
| 473 | 2024-03-04 20:49:53 | troops | 2 | 82551 | 90 | 2.890 | 28564.4 |
| 472 | 2024-03-04 16:37:25 | troops | 3 | 112716 | 778 | 15.766 | 7149.3 |
| 471 | 2024-03-04 15:51:00 | troops | 1 | 48755 | 4 | 1.856 | 26268.9 |
| 470 | 2024-03-04 14:30:47 | troops | 3 | 112716 | 778 | 12.500 | 9017.3 |
| 469 | 2024-03-04 14:30:53 | troops | 2 | 82551 | 90 | 5.906 | 13977.5 |
| 468 | 2024-03-04 11:24:51 | troops | 2 | 82551 | 90 | 2.516 | 32810.4 |
| 467 | 2024-03-04 11:24:50 | troops | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 466 | 2024-03-04 11:24:29 | troops | 3 | 112716 | 778 | 5.393 | 20900.4 |
| 465 | 2024-03-04 03:48:37 | troops | 3 | 112716 | 778 | 7.843 | 14371.5 |
| 464 | 2024-03-04 03:48:37 | troops | 2 | 82551 | 90 | 2.640 | 31269.3 |
| 463 | 2024-03-04 03:48:36 | troops | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 462 | 2024-02-25 23:14:20 | troops | 1 | 48755 | 4 | 2.843 | 17149.1 |
| 461 | 2024-02-05 02:36:09 | troops | 1 | 48755 | 4 | 1.156 | 42175.6 |
| 460 | 2024-01-16 11:46:39 | troops | 3 | 112716 | 778 | 4.986 | 22606.5 |
| 459 | 2024-01-16 11:46:41 | troops | 2 | 82551 | 90 | 2.450 | 33694.3 |
| 458 | 2024-01-14 14:08:42 | troops | 1 | 48755 | 4 | 0.953 | 51159.5 |
| 457 | 2023-11-28 06:30:14 | troops | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 456 | 2023-11-21 10:25:57 | troops | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 455 | 2023-11-16 10:41:27 | troops | 1 | 48755 | 4 | 0.846 | 57630.0 |
| 454 | 2023-10-25 06:09:08 | troops | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 453 | 2023-10-23 03:31:55 | troops | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 452 | 2023-10-14 02:44:41 | troops | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 451 | 2023-10-09 17:30:01 | troops | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 450 | 2023-09-29 09:44:26 | troops | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 449 | 2023-09-22 06:08:48 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 448 | 2023-09-12 23:52:14 | troops | 1 | 48755 | 4 | 0.966 | 50471.0 |
| 447 | 2023-08-18 14:55:34 | troops | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 446 | 2023-06-27 16:51:37 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 445 | 2023-04-08 16:41:19 | troops | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 444 | 2023-04-06 16:36:04 | troops | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 443 | 2023-01-18 12:18:32 | troops | 1 | 48755 | 4 | 0.846 | 57630.0 |
| 442 | 2022-12-06 17:27:58 | troops | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 441 | 2022-11-14 20:47:20 | troops | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 440 | 2022-07-23 14:37:45 | troops | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 439 | 2022-07-19 22:13:34 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 438 | 2022-07-06 21:08:35 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 437 | 2022-03-09 10:59:30 | troops | 1 | 48755 | 4 | 0.920 | 52994.6 |
| 436 | 2022-02-26 13:00:48 | troops | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 435 | 2021-12-21 22:51:03 | troops | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 434 | 2021-10-26 21:38:44 | troops | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 433 | 2021-10-25 21:05:21 | troops | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 432 | 2021-09-17 05:28:30 | troops | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 431 | 2021-09-01 22:01:52 | troops | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 430 | 2021-08-02 00:51:41 | troops | 1 | 48755 | 4 | 0.720 | 67715.3 |
| 429 | 2021-07-25 00:59:22 | troops | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 428 | 2021-07-17 00:55:33 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 427 | 2021-07-07 19:30:43 | troops | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 426 | 2021-06-06 11:10:53 | troops | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 425 | 2021-05-12 12:04:21 | troops | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 424 | 2021-04-08 00:09:39 | troops | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 423 | 2021-04-03 20:27:12 | troops | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 422 | 2021-03-15 07:03:57 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 421 | 2021-02-16 17:48:03 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 420 | 2021-02-11 16:44:04 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 419 | 2020-12-29 20:11:46 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 418 | 2020-12-27 14:53:16 | troops | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 417 | 2020-11-04 03:19:46 | troops | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 416 | 2020-10-31 21:26:16 | troops | 1 | 48755 | 4 | 0.920 | 52994.6 |
| 415 | 2020-10-28 02:28:05 | troops | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 414 | 2020-10-17 05:31:20 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 413 | 2020-09-26 12:54:50 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 412 | 2020-09-02 14:36:29 | troops | 1 | 48755 | 4 | 0.856 | 56956.8 |
| 411 | 2020-08-30 14:34:46 | troops | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 410 | 2020-06-11 16:32:11 | troops | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 409 | 2020-05-27 06:29:36 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 408 | 2020-03-28 01:04:36 | troops | 1 | 48755 | 4 | 1.140 | 42767.5 |
| 407 | 2020-03-25 18:28:53 | troops | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 406 | 2020-03-24 11:22:41 | troops | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 405 | 2020-03-23 02:58:19 | troops | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 404 | 2020-03-19 22:56:07 | troops | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 403 | 2020-03-12 08:29:06 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 402 | 2020-03-07 04:04:19 | troops | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 401 | 2020-02-25 19:51:57 | troops | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 400 | 2020-02-13 03:29:34 | troops | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 399 | 2020-02-04 15:25:26 | troops | 1 | 48755 | 4 | 1.266 | 38511.1 |
| 398 | 2020-02-04 11:48:08 | troops | 1 | 48755 | 4 | 0.893 | 54596.9 |
| 397 | 2020-02-02 19:53:09 | troops | 1 | 48755 | 4 | 0.953 | 51159.5 |
| 396 | 2020-02-02 05:50:48 | troops | 1 | 48755 | 4 | 2.313 | 21078.7 |
| 395 | 2020-02-02 03:18:40 | troops | 1 | 48755 | 4 | 0.936 | 52088.7 |
| 394 | 2020-02-01 13:22:56 | troops | 1 | 48755 | 4 | 1.703 | 28628.9 |
| 393 | 2020-01-24 02:09:50 | troops | 2 | 82551 | 90 | 2.890 | 28564.4 |
| 392 | 2020-01-22 23:49:34 | troops | 1 | 48755 | 4 | 0.893 | 54596.9 |
| 391 | 2020-01-14 18:34:13 | troops | 1 | 48755 | 4 | 0.923 | 52822.3 |
| 390 | 2020-01-12 12:59:56 | troops | 1 | 48755 | 4 | 1.906 | 25579.7 |
| 389 | 2020-01-12 06:13:18 | troops | 2 | 82551 | 90 | 8.673 | 9518.2 |
| 388 | 2020-01-11 23:50:54 | troops | 2 | 82551 | 90 | 2.720 | 30349.6 |
| 387 | 2020-01-11 20:56:43 | troops | 1 | 48755 | 4 | 0.920 | 52994.6 |