History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"capitals"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 523 | 2025-10-26 13:27:04 | capitals | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 522 | 2025-10-24 11:35:46 | capitals | 1 | 82945 | 3 | 1.503 | 55186.3 |
| 521 | 2025-10-24 03:00:47 | capitals | 3 | 146162 | 137 | 8.250 | 17716.6 |
| 520 | 2025-10-23 23:47:28 | capitals | 3 | 146162 | 137 | 6.533 | 22372.9 |
| 519 | 2025-10-23 21:58:39 | capitals | 3 | 146162 | 137 | 7.516 | 19446.8 |
| 518 | 2025-10-23 21:58:27 | capitals | 3 | 146162 | 137 | 6.576 | 22226.6 |
| 517 | 2025-10-23 20:02:29 | capitals | 3 | 146162 | 137 | 21.333 | 6851.5 |
| 516 | 2025-10-23 01:32:38 | capitals | 3 | 146162 | 137 | 35.890 | 4072.5 |
| 515 | 2025-10-22 11:11:30 | capitals | 2 | 121059 | 21 | 20.203 | 5992.1 |
| 514 | 2025-10-22 11:11:05 | capitals | 2 | 121059 | 21 | 13.860 | 8734.4 |
| 513 | 2025-10-21 01:34:22 | capitals | 2 | 121059 | 21 | 10.110 | 11974.2 |
| 512 | 2025-10-20 12:55:16 | capitals | 2 | 121059 | 21 | 4.013 | 30166.7 |
| 511 | 2025-10-16 23:22:31 | capitals | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 510 | 2025-10-15 19:25:14 | capitals | 2 | 121059 | 21 | 3.313 | 36540.6 |
| 509 | 2025-10-14 23:44:52 | capitals | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 508 | 2025-10-09 16:30:51 | capitals | 1 | 82945 | 3 | 1.606 | 51646.9 |
| 507 | 2025-10-09 12:58:48 | capitals | 1 | 82945 | 3 | 1.596 | 51970.6 |
| 506 | 2025-10-08 14:53:10 | capitals | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 505 | 2025-10-06 01:38:24 | capitals | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 504 | 2025-10-03 18:43:49 | capitals | 3 | 146162 | 137 | 7.593 | 19249.6 |
| 503 | 2025-09-29 04:00:48 | capitals | 1 | 82945 | 3 | 1.673 | 49578.6 |
| 502 | 2025-09-26 23:33:57 | capitals | 2 | 121059 | 21 | 4.060 | 29817.5 |
| 501 | 2025-09-26 19:12:23 | capitals | 2 | 121059 | 21 | 3.830 | 31608.1 |
| 500 | 2025-09-26 17:31:16 | capitals | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 499 | 2025-09-26 13:25:32 | capitals | 2 | 121059 | 21 | 3.406 | 35542.9 |
| 498 | 2025-09-26 12:45:40 | capitals | 3 | 146162 | 137 | 7.546 | 19369.5 |
| 497 | 2025-09-26 02:58:19 | capitals | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 496 | 2025-09-25 13:34:15 | capitals | 1 | 82945 | 3 | 3.140 | 26415.6 |
| 495 | 2025-09-22 11:50:34 | capitals | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 494 | 2025-09-21 06:19:02 | capitals | 2 | 121059 | 21 | 3.830 | 31608.1 |
| 493 | 2025-09-19 05:32:07 | capitals | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 492 | 2025-09-18 01:17:06 | capitals | 2 | 121059 | 21 | 3.813 | 31749.0 |
| 491 | 2025-09-13 23:29:12 | capitals | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 490 | 2025-09-08 12:03:16 | capitals | 1 | 82945 | 3 | 2.596 | 31951.1 |
| 489 | 2025-09-06 14:27:12 | capitals | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 488 | 2025-09-05 01:18:36 | capitals | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 487 | 2025-08-28 17:51:32 | capitals | 2 | 121059 | 21 | 3.483 | 34757.1 |
| 486 | 2025-08-28 09:55:26 | capitals | 2 | 121059 | 21 | 3.326 | 36397.8 |
| 485 | 2025-08-27 03:41:07 | capitals | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 484 | 2025-08-25 03:12:22 | capitals | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 483 | 2025-08-23 11:12:56 | capitals | 1 | 82945 | 3 | 7.610 | 10899.5 |
| 482 | 2025-08-17 16:15:59 | capitals | 3 | 146162 | 137 | 18.800 | 7774.6 |
| 481 | 2025-08-16 22:15:34 | capitals | 2 | 121059 | 21 | 8.533 | 14187.2 |
| 480 | 2025-08-15 18:05:02 | capitals | 3 | 146162 | 137 | 43.080 | 3392.8 |
| 479 | 2025-08-15 06:21:31 | capitals | 2 | 121059 | 21 | 24.393 | 4962.9 |
| 478 | 2025-08-13 23:57:55 | capitals | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 477 | 2025-08-05 11:00:49 | capitals | 2 | 121059 | 21 | 9.640 | 12558.0 |
| 476 | 2025-08-05 03:26:57 | capitals | 3 | 146162 | 137 | 20.143 | 7256.2 |
| 475 | 2025-08-05 02:43:47 | capitals | 2 | 121059 | 21 | 8.843 | 13689.8 |
| 474 | 2025-08-04 10:01:58 | capitals | 3 | 146162 | 137 | 40.956 | 3568.8 |
| 473 | 2025-08-04 04:32:53 | capitals | 1 | 82945 | 3 | 2.360 | 35146.2 |
| 472 | 2025-08-01 18:53:02 | capitals | 3 | 146162 | 137 | 47.500 | 3077.1 |
| 471 | 2025-08-01 15:55:46 | capitals | 1 | 82945 | 3 | 9.050 | 9165.2 |
| 470 | 2025-07-31 12:42:12 | capitals | 1 | 82945 | 3 | 3.390 | 24467.6 |
| 469 | 2025-07-27 04:11:48 | capitals | 1 | 82945 | 3 | 3.720 | 22297.0 |
| 468 | 2025-07-24 23:19:10 | capitals | 1 | 82945 | 3 | 3.643 | 22768.3 |
| 467 | 2025-07-23 19:08:58 | capitals | 1 | 82945 | 3 | 2.986 | 27778.0 |
| 466 | 2025-07-22 19:32:16 | capitals | 1 | 82945 | 3 | 3.813 | 21753.2 |
| 465 | 2025-07-14 07:18:50 | capitals | 3 | 146162 | 137 | 28.956 | 5047.7 |
| 464 | 2025-07-14 02:37:52 | capitals | 1 | 82945 | 3 | 7.156 | 11591.0 |
| 463 | 2025-07-12 23:38:56 | capitals | 3 | 146162 | 137 | 7.513 | 19454.5 |
| 462 | 2025-07-11 02:05:14 | capitals | 3 | 146162 | 137 | 46.706 | 3129.4 |
| 461 | 2025-07-10 02:28:38 | capitals | 1 | 82945 | 3 | 10.673 | 7771.5 |
| 460 | 2025-07-07 17:42:41 | capitals | 3 | 146162 | 137 | 22.936 | 6372.6 |
| 459 | 2025-07-06 22:17:16 | capitals | 2 | 121059 | 21 | 11.516 | 10512.2 |
| 458 | 2025-07-06 13:54:25 | capitals | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 457 | 2025-06-30 03:40:32 | capitals | 1 | 82945 | 3 | 10.033 | 8267.2 |
| 456 | 2025-06-24 04:49:17 | capitals | 1 | 82945 | 3 | 7.453 | 11129.1 |
| 455 | 2025-06-22 04:16:20 | capitals | 1 | 82945 | 3 | 5.016 | 16536.1 |
| 454 | 2025-06-13 10:38:11 | capitals | 1 | 82945 | 3 | 2.390 | 34705.0 |
| 453 | 2025-06-07 12:03:25 | capitals | 1 | 82945 | 3 | 1.720 | 48223.8 |
| 452 | 2025-05-27 16:57:17 | capitals | 3 | 146162 | 137 | 43.426 | 3365.8 |
| 451 | 2025-05-22 16:39:30 | capitals | 3 | 146162 | 137 | 42.690 | 3423.8 |
| 450 | 2025-05-22 11:23:43 | capitals | 2 | 121059 | 21 | 15.983 | 7574.2 |
| 449 | 2025-05-21 05:04:08 | capitals | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 448 | 2025-05-19 09:43:46 | capitals | 1 | 82945 | 3 | 1.340 | 61899.3 |
| 447 | 2025-05-14 00:00:20 | capitals | 1 | 82945 | 3 | 8.110 | 10227.5 |
| 446 | 2025-05-11 01:04:03 | capitals | 1 | 82945 | 3 | 5.766 | 14385.2 |
| 445 | 2025-05-08 17:03:34 | capitals | 1 | 82945 | 3 | 5.313 | 15611.7 |
| 444 | 2025-05-06 13:33:21 | capitals | 1 | 82945 | 3 | 7.733 | 10726.1 |
| 443 | 2025-05-02 13:44:58 | capitals | 1 | 82945 | 3 | 6.576 | 12613.3 |
| 442 | 2025-04-26 02:09:25 | capitals | 1 | 82945 | 3 | 7.140 | 11616.9 |
| 441 | 2025-04-18 16:24:49 | capitals | 3 | 146162 | 137 | 21.686 | 6739.9 |
| 440 | 2025-04-18 06:15:22 | capitals | 3 | 146162 | 137 | 37.406 | 3907.4 |
| 439 | 2025-04-18 00:32:19 | capitals | 3 | 146162 | 137 | 23.890 | 6118.1 |
| 438 | 2025-04-16 10:15:08 | capitals | 3 | 146162 | 137 | 39.173 | 3731.2 |
| 437 | 2025-04-16 08:54:20 | capitals | 2 | 121059 | 21 | 22.486 | 5383.7 |
| 436 | 2025-04-15 04:09:12 | capitals | 1 | 82945 | 3 | 9.063 | 9152.0 |
| 435 | 2025-04-15 03:47:59 | capitals | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 434 | 2025-04-11 00:53:53 | capitals | 1 | 82945 | 3 | 5.593 | 14830.1 |
| 433 | 2025-04-06 11:32:39 | capitals | 1 | 82945 | 3 | 6.843 | 12121.1 |
| 432 | 2025-03-26 02:41:22 | capitals | 1 | 82945 | 3 | 6.670 | 12435.5 |
| 431 | 2025-03-20 04:02:01 | capitals | 1 | 82945 | 3 | 7.126 | 11639.8 |
| 430 | 2025-03-07 23:42:51 | capitals | 1 | 82945 | 3 | 5.796 | 14310.7 |
| 429 | 2025-03-02 22:24:24 | capitals | 1 | 82945 | 3 | 5.986 | 13856.5 |
| 428 | 2025-03-01 13:11:37 | capitals | 1 | 82945 | 3 | 5.720 | 14500.9 |
| 427 | 2025-02-24 09:12:21 | capitals | 2 | 121059 | 21 | 14.423 | 8393.5 |
| 426 | 2025-02-05 21:59:05 | capitals | 2 | 121059 | 21 | 10.796 | 11213.3 |
| 425 | 2025-02-04 13:04:16 | capitals | 1 | 82945 | 3 | 6.580 | 12605.6 |
| 424 | 2025-02-01 10:59:17 | capitals | 2 | 121059 | 21 | 15.733 | 7694.6 |