History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"concerto"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 642 | 2025-05-08 12:41:54 | concerto | 1 | 82945 | 5 | 5.403 | 15351.7 |
| 641 | 2025-05-06 16:52:58 | concerto | 1 | 82945 | 5 | 3.470 | 23903.5 |
| 640 | 2025-04-30 16:32:33 | concerto | 1 | 82945 | 5 | 3.893 | 21306.2 |
| 639 | 2025-04-27 00:56:17 | concerto | 3 | 146162 | 112 | 7.610 | 19206.6 |
| 638 | 2025-04-23 22:11:08 | concerto | 3 | 146162 | 112 | 33.080 | 4418.4 |
| 637 | 2025-04-22 00:49:39 | concerto | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 636 | 2025-04-20 14:11:03 | concerto | 1 | 82945 | 5 | 1.796 | 46183.2 |
| 635 | 2025-04-14 03:51:12 | concerto | 1 | 82945 | 5 | 8.343 | 9941.9 |
| 634 | 2025-04-10 21:45:09 | concerto | 1 | 82945 | 5 | 7.656 | 10834.0 |
| 633 | 2025-04-08 11:24:11 | concerto | 1 | 82945 | 5 | 9.206 | 9009.9 |
| 632 | 2025-04-06 08:39:16 | concerto | 3 | 146162 | 112 | 29.330 | 4983.4 |
| 631 | 2025-04-03 23:59:17 | concerto | 3 | 146162 | 112 | 50.610 | 2888.0 |
| 630 | 2025-03-29 19:13:45 | concerto | 1 | 82945 | 5 | 4.660 | 17799.4 |
| 629 | 2025-03-28 23:58:12 | concerto | 3 | 146162 | 112 | 21.296 | 6863.4 |
| 628 | 2025-03-21 02:25:20 | concerto | 1 | 82945 | 5 | 7.656 | 10834.0 |
| 627 | 2025-03-14 22:42:23 | concerto | 1 | 82945 | 5 | 7.483 | 11084.5 |
| 626 | 2025-03-12 17:16:47 | concerto | 1 | 82945 | 5 | 7.326 | 11322.0 |
| 625 | 2025-03-05 06:00:03 | concerto | 1 | 82945 | 5 | 8.800 | 9425.6 |
| 624 | 2025-02-24 18:38:48 | concerto | 3 | 146162 | 112 | 33.186 | 4404.3 |
| 623 | 2025-02-24 18:39:07 | concerto | 1 | 82945 | 5 | 7.356 | 11275.8 |
| 622 | 2025-02-24 18:38:47 | concerto | 2 | 121059 | 22 | 17.470 | 6929.5 |
| 621 | 2025-02-11 08:43:58 | concerto | 1 | 82945 | 5 | 3.610 | 22976.5 |
| 620 | 2025-02-01 00:26:49 | concerto | 1 | 82945 | 5 | 7.300 | 11362.3 |
| 619 | 2025-01-25 13:45:27 | concerto | 3 | 146162 | 112 | 32.346 | 4518.7 |
| 618 | 2025-01-17 17:13:35 | concerto | 3 | 146162 | 112 | 40.110 | 3644.0 |
| 617 | 2025-01-16 02:00:31 | concerto | 3 | 146162 | 112 | 25.330 | 5770.3 |
| 616 | 2025-01-16 02:00:20 | concerto | 2 | 121059 | 22 | 22.033 | 5494.4 |
| 615 | 2025-01-15 05:10:00 | concerto | 3 | 146162 | 112 | 33.220 | 4399.8 |
| 614 | 2025-01-15 05:10:01 | concerto | 2 | 121059 | 22 | 17.500 | 6917.7 |
| 613 | 2025-01-14 01:56:04 | concerto | 1 | 82945 | 5 | 5.406 | 15343.1 |
| 612 | 2024-12-28 05:40:10 | concerto | 1 | 82945 | 5 | 6.656 | 12461.7 |
| 611 | 2024-12-13 02:03:32 | concerto | 2 | 121059 | 22 | 23.470 | 5158.0 |
| 610 | 2024-12-13 02:02:15 | concerto | 1 | 82945 | 5 | 3.876 | 21399.6 |
| 609 | 2024-12-04 18:00:07 | concerto | 3 | 146162 | 112 | 29.660 | 4927.9 |
| 608 | 2024-12-04 12:52:23 | concerto | 3 | 146162 | 112 | 37.500 | 3897.7 |
| 607 | 2024-12-04 01:58:29 | concerto | 3 | 146162 | 112 | 22.860 | 6393.8 |
| 606 | 2024-12-02 16:05:32 | concerto | 3 | 146162 | 112 | 12.623 | 11579.0 |
| 605 | 2024-12-02 16:05:31 | concerto | 2 | 121059 | 22 | 7.173 | 16877.0 |
| 604 | 2024-12-02 16:05:29 | concerto | 1 | 82945 | 5 | 2.690 | 30834.6 |
| 603 | 2024-11-29 00:05:40 | concerto | 1 | 82945 | 5 | 3.813 | 21753.2 |
| 602 | 2024-11-02 09:55:42 | concerto | 1 | 82945 | 5 | 5.453 | 15210.9 |
| 601 | 2024-10-27 08:30:39 | concerto | 1 | 82945 | 5 | 6.143 | 13502.4 |
| 600 | 2024-10-09 19:40:06 | concerto | 1 | 82945 | 5 | 7.143 | 11612.1 |
| 599 | 2024-09-22 01:45:43 | concerto | 1 | 82945 | 5 | 4.923 | 16848.5 |
| 598 | 2024-09-14 02:01:10 | concerto | 1 | 82945 | 5 | 13.393 | 6193.2 |
| 597 | 2024-08-30 07:56:15 | concerto | 3 | 146162 | 112 | 93.863 | 1557.2 |
| 596 | 2024-08-24 01:56:26 | concerto | 2 | 121059 | 22 | 10.843 | 11164.7 |
| 595 | 2024-08-24 01:55:44 | concerto | 2 | 121059 | 22 | 25.316 | 4781.9 |
| 594 | 2024-08-23 19:19:27 | concerto | 3 | 146162 | 112 | 87.006 | 1679.9 |
| 593 | 2024-08-23 19:19:35 | concerto | 2 | 121059 | 22 | 33.343 | 3630.7 |
| 592 | 2024-08-23 19:15:45 | concerto | 1 | 82945 | 5 | 5.673 | 14621.0 |
| 591 | 2024-08-20 06:52:13 | concerto | 1 | 82945 | 5 | 15.173 | 5466.6 |
| 590 | 2024-08-15 08:58:09 | concerto | 1 | 82945 | 5 | 4.500 | 18432.2 |
| 589 | 2024-08-14 18:58:40 | concerto | 1 | 82945 | 5 | 11.003 | 7538.4 |
| 588 | 2024-07-26 14:46:02 | concerto | 1 | 82945 | 5 | 6.266 | 13237.3 |
| 587 | 2024-07-19 21:31:25 | concerto | 1 | 82945 | 5 | 7.500 | 11059.3 |
| 586 | 2024-07-11 05:04:46 | concerto | 1 | 82945 | 5 | 3.266 | 25396.5 |
| 585 | 2024-07-07 20:07:27 | concerto | 3 | 146162 | 112 | 30.423 | 4804.3 |
| 584 | 2024-07-07 20:07:30 | concerto | 2 | 121059 | 22 | 15.800 | 7662.0 |
| 583 | 2024-07-07 20:06:40 | concerto | 1 | 82945 | 5 | 6.093 | 13613.2 |
| 582 | 2024-07-02 03:28:08 | concerto | 1 | 82945 | 5 | 6.253 | 13264.8 |
| 581 | 2024-06-12 10:00:14 | concerto | 3 | 146162 | 112 | 27.610 | 5293.8 |
| 580 | 2024-06-12 01:52:51 | concerto | 2 | 121059 | 22 | 7.986 | 15158.9 |
| 579 | 2024-06-12 01:52:27 | concerto | 3 | 146162 | 112 | 7.796 | 18748.3 |
| 578 | 2024-06-11 01:14:35 | concerto | 3 | 146162 | 112 | 14.280 | 10235.4 |
| 577 | 2024-06-07 21:52:18 | concerto | 3 | 146162 | 112 | 35.770 | 4086.2 |
| 576 | 2024-06-05 21:07:03 | concerto | 1 | 82945 | 5 | 9.793 | 8469.8 |
| 575 | 2024-06-04 10:19:29 | concerto | 3 | 146162 | 112 | 37.733 | 3873.6 |
| 574 | 2024-06-03 23:25:51 | concerto | 3 | 146162 | 112 | 14.423 | 10134.0 |
| 573 | 2024-05-31 07:56:51 | concerto | 1 | 82945 | 5 | 2.703 | 30686.3 |
| 572 | 2024-05-12 19:50:23 | concerto | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 571 | 2024-05-12 19:49:52 | concerto | 2 | 121059 | 22 | 4.093 | 29577.1 |
| 570 | 2024-05-11 23:37:55 | concerto | 2 | 121059 | 22 | 9.970 | 12142.3 |
| 569 | 2024-05-11 22:25:30 | concerto | 3 | 146162 | 112 | 9.390 | 15565.7 |
| 568 | 2024-05-11 13:02:11 | concerto | 3 | 146162 | 112 | 15.986 | 9143.1 |
| 567 | 2024-05-11 08:16:37 | concerto | 3 | 146162 | 112 | 12.343 | 11841.7 |
| 566 | 2024-05-11 08:16:37 | concerto | 2 | 121059 | 22 | 8.093 | 14958.5 |
| 565 | 2024-05-10 04:30:35 | concerto | 2 | 121059 | 22 | 4.156 | 29128.7 |
| 564 | 2024-05-10 04:30:16 | concerto | 3 | 146162 | 112 | 7.516 | 19446.8 |
| 563 | 2024-05-08 14:34:45 | concerto | 3 | 146162 | 112 | 7.610 | 19206.6 |
| 562 | 2024-05-08 14:34:36 | concerto | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 561 | 2024-05-08 14:34:28 | concerto | 2 | 121059 | 22 | 3.986 | 30371.0 |
| 560 | 2024-05-08 14:33:40 | concerto | 1 | 82945 | 5 | 1.623 | 51106.0 |
| 559 | 2024-05-04 05:26:14 | concerto | 1 | 82945 | 5 | 3.253 | 25498.0 |
| 558 | 2024-04-30 11:11:37 | concerto | 1 | 82945 | 5 | 5.266 | 15751.0 |
| 557 | 2024-04-19 09:49:46 | concerto | 3 | 146162 | 112 | 6.906 | 21164.5 |
| 556 | 2024-04-09 13:59:22 | concerto | 3 | 146162 | 112 | 7.796 | 18748.3 |
| 555 | 2024-04-09 13:59:24 | concerto | 2 | 121059 | 22 | 4.250 | 28484.5 |
| 554 | 2024-04-09 11:31:37 | concerto | 2 | 121059 | 22 | 4.576 | 26455.2 |
| 553 | 2024-04-09 10:14:14 | concerto | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 552 | 2024-04-08 13:36:22 | concerto | 3 | 146162 | 112 | 16.093 | 9082.3 |
| 551 | 2024-04-08 03:44:09 | concerto | 3 | 146162 | 112 | 8.440 | 17317.8 |
| 550 | 2024-04-06 19:22:52 | concerto | 3 | 146162 | 112 | 8.920 | 16385.9 |
| 549 | 2024-04-06 19:22:45 | concerto | 2 | 121059 | 22 | 12.816 | 9445.9 |
| 548 | 2024-04-05 06:05:46 | concerto | 3 | 146162 | 112 | 12.280 | 11902.4 |
| 547 | 2024-04-05 06:05:47 | concerto | 2 | 121059 | 22 | 4.016 | 30144.2 |
| 546 | 2024-04-05 06:05:45 | concerto | 1 | 82945 | 5 | 3.000 | 27648.3 |
| 545 | 2024-03-31 22:03:25 | concerto | 2 | 121059 | 22 | 4.360 | 27765.8 |
| 544 | 2024-03-31 22:01:36 | concerto | 1 | 82945 | 5 | 3.216 | 25791.4 |
| 543 | 2024-03-31 00:09:19 | concerto | 1 | 82945 | 5 | 5.563 | 14910.1 |