History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"john"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 684 | 2025-10-19 13:27:27 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 683 | 2025-10-16 13:49:02 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 682 | 2025-10-07 14:39:10 | john | 1 | 13983 | 4 | 0.686 | 20383.4 |
| 681 | 2025-10-01 12:23:58 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 680 | 2025-09-19 21:54:23 | john | 2 | 29872 | 101 | 0.796 | 37527.6 |
| 679 | 2025-09-13 01:00:01 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 678 | 2025-09-08 11:33:24 | john | 1 | 13983 | 4 | 0.440 | 31779.5 |
| 677 | 2025-09-06 00:27:31 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 676 | 2025-09-01 04:22:06 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 675 | 2025-08-30 12:54:56 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 674 | 2025-08-19 08:49:24 | john | 1 | 13983 | 4 | 0.686 | 20383.4 |
| 673 | 2025-08-09 20:16:12 | john | 1 | 13983 | 4 | 0.966 | 14475.2 |
| 672 | 2025-08-04 09:29:27 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 671 | 2025-08-02 07:58:42 | john | 1 | 13983 | 4 | 1.063 | 13154.3 |
| 670 | 2025-08-01 04:46:33 | john | 1 | 13983 | 4 | 0.906 | 15433.8 |
| 669 | 2025-07-31 02:13:12 | john | 1 | 13983 | 4 | 1.330 | 10513.5 |
| 668 | 2025-07-27 19:37:13 | john | 2 | 29872 | 101 | 1.860 | 16060.2 |
| 667 | 2025-07-27 07:15:34 | john | 1 | 13983 | 4 | 1.656 | 8443.8 |
| 666 | 2025-07-26 11:51:17 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 665 | 2025-07-09 12:12:59 | john | 1 | 13983 | 4 | 0.263 | 53167.3 |
| 664 | 2025-07-07 09:02:18 | john | 2 | 29872 | 101 | 5.423 | 5508.4 |
| 663 | 2025-07-05 09:00:17 | john | 2 | 29872 | 101 | 2.436 | 12262.7 |
| 662 | 2025-07-04 08:58:45 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 661 | 2025-07-02 02:20:11 | john | 1 | 13983 | 4 | 1.436 | 9737.5 |
| 660 | 2025-06-24 19:27:09 | john | 1 | 13983 | 4 | 0.420 | 33292.9 |
| 659 | 2025-06-17 02:08:14 | john | 1 | 13983 | 4 | 1.156 | 12096.0 |
| 658 | 2025-06-16 02:34:15 | john | 1 | 13983 | 4 | 0.670 | 20870.1 |
| 657 | 2025-06-08 03:32:00 | john | 1 | 13983 | 4 | 1.186 | 11790.1 |
| 656 | 2025-06-02 08:46:12 | john | 1 | 13983 | 4 | 0.923 | 15149.5 |
| 655 | 2025-06-02 02:24:58 | john | 1 | 13983 | 4 | 1.033 | 13536.3 |
| 654 | 2025-06-01 01:39:29 | john | 1 | 13983 | 4 | 0.686 | 20383.4 |
| 653 | 2025-05-29 00:28:54 | john | 1 | 13983 | 4 | 0.533 | 26234.5 |
| 652 | 2025-05-25 04:19:13 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 651 | 2025-05-16 02:11:57 | john | 1 | 13983 | 4 | 0.656 | 21315.5 |
| 650 | 2025-05-05 02:40:13 | john | 1 | 13983 | 4 | 1.376 | 10162.1 |
| 649 | 2025-05-02 08:52:00 | john | 1 | 13983 | 4 | 1.920 | 7282.8 |
| 648 | 2025-05-01 23:19:46 | john | 1 | 13983 | 4 | 1.140 | 12265.8 |
| 647 | 2025-05-01 11:15:08 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 646 | 2025-04-28 00:54:59 | john | 1 | 13983 | 4 | 1.983 | 7051.4 |
| 645 | 2025-04-14 01:55:04 | john | 1 | 13983 | 4 | 0.953 | 14672.6 |
| 644 | 2025-04-11 08:39:39 | john | 2 | 29872 | 101 | 2.046 | 14600.2 |
| 643 | 2025-04-11 04:30:03 | john | 2 | 29872 | 101 | 6.513 | 4586.5 |
| 642 | 2025-04-10 23:32:44 | john | 2 | 29872 | 101 | 6.220 | 4802.6 |
| 641 | 2025-04-08 19:58:12 | john | 2 | 29872 | 101 | 2.173 | 13746.9 |
| 640 | 2025-04-05 02:19:28 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 639 | 2025-03-31 02:31:04 | john | 1 | 13983 | 4 | 0.750 | 18644.0 |
| 638 | 2025-03-28 01:09:14 | john | 1 | 13983 | 4 | 1.530 | 9139.2 |
| 637 | 2025-03-26 11:30:10 | john | 1 | 13983 | 4 | 1.156 | 12096.0 |
| 636 | 2025-03-19 04:37:56 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 635 | 2025-03-14 21:50:48 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 634 | 2025-03-13 00:17:27 | john | 2 | 29872 | 101 | 4.046 | 7383.1 |
| 633 | 2025-03-13 00:17:07 | john | 1 | 13983 | 4 | 1.200 | 11652.5 |
| 632 | 2025-03-05 22:31:33 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 631 | 2025-02-27 22:21:50 | john | 2 | 29872 | 101 | 5.513 | 5418.5 |
| 630 | 2025-02-27 22:18:37 | john | 2 | 29872 | 101 | 6.500 | 4595.7 |
| 629 | 2025-02-27 21:27:39 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 628 | 2025-02-27 21:24:57 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 627 | 2025-02-26 11:38:22 | john | 1 | 13983 | 4 | 1.640 | 8526.2 |
| 626 | 2025-02-25 07:48:37 | john | 1 | 13983 | 4 | 1.436 | 9737.5 |
| 625 | 2025-02-06 17:52:06 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 624 | 2025-01-28 17:23:49 | john | 2 | 29872 | 101 | 6.770 | 4412.4 |
| 623 | 2025-01-28 16:55:27 | john | 1 | 13983 | 4 | 0.716 | 19529.3 |
| 622 | 2025-01-28 09:39:04 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 621 | 2025-01-25 18:36:56 | john | 2 | 29872 | 101 | 3.970 | 7524.4 |
| 620 | 2025-01-18 04:50:48 | john | 2 | 29872 | 101 | 0.813 | 36742.9 |
| 619 | 2025-01-07 16:34:02 | john | 1 | 13983 | 4 | 1.876 | 7453.6 |
| 618 | 2025-01-02 17:47:11 | john | 2 | 29872 | 101 | 6.060 | 4929.4 |
| 617 | 2024-12-30 15:08:25 | john | 2 | 29872 | 101 | 4.170 | 7163.5 |
| 616 | 2024-12-29 16:04:31 | john | 2 | 29872 | 101 | 0.720 | 41488.9 |
| 615 | 2024-12-29 16:04:27 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 614 | 2024-12-29 09:17:09 | john | 2 | 29872 | 101 | 3.610 | 8274.8 |
| 613 | 2024-12-29 07:55:39 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 612 | 2024-12-28 05:10:56 | john | 1 | 13983 | 4 | 0.623 | 22444.6 |
| 611 | 2024-12-26 20:30:34 | john | 1 | 13983 | 4 | 0.563 | 24836.6 |
| 610 | 2024-12-21 20:03:49 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 609 | 2024-12-20 06:43:49 | john | 1 | 13983 | 4 | 0.953 | 14672.6 |
| 608 | 2024-12-15 16:43:25 | john | 2 | 29872 | 101 | 0.936 | 31914.5 |
| 607 | 2024-12-08 13:51:49 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 606 | 2024-11-29 13:09:13 | john | 1 | 13983 | 4 | 0.206 | 67878.6 |
| 605 | 2024-11-29 07:31:13 | john | 2 | 29872 | 101 | 2.126 | 14050.8 |
| 604 | 2024-11-29 04:33:05 | john | 2 | 29872 | 101 | 4.016 | 7438.2 |
| 603 | 2024-11-29 03:22:25 | john | 1 | 13983 | 4 | 0.813 | 17199.3 |
| 602 | 2024-11-26 15:33:34 | john | 1 | 13983 | 4 | 1.063 | 13154.3 |
| 601 | 2024-11-25 17:28:40 | john | 2 | 29872 | 101 | 6.656 | 4488.0 |
| 600 | 2024-11-10 23:58:56 | john | 2 | 29872 | 101 | 3.970 | 7524.4 |
| 599 | 2024-11-08 14:51:41 | john | 2 | 29872 | 101 | 4.236 | 7051.9 |
| 598 | 2024-11-08 07:35:11 | john | 1 | 13983 | 4 | 0.690 | 20265.2 |
| 597 | 2024-10-30 04:32:29 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 596 | 2024-10-30 02:47:18 | john | 2 | 29872 | 101 | 3.983 | 7499.9 |
| 595 | 2024-10-30 02:36:41 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 594 | 2024-10-27 13:42:49 | john | 1 | 13983 | 4 | 1.093 | 12793.2 |
| 593 | 2024-10-24 01:23:20 | john | 1 | 13983 | 4 | 1.643 | 8510.7 |
| 592 | 2024-10-09 03:55:54 | john | 1 | 13983 | 4 | 1.796 | 7785.6 |
| 591 | 2024-10-05 11:34:12 | john | 2 | 29872 | 101 | 3.173 | 9414.4 |
| 590 | 2024-09-30 00:01:09 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 589 | 2024-09-29 17:49:25 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 588 | 2024-09-27 05:40:19 | john | 1 | 13983 | 4 | 2.293 | 6098.1 |
| 587 | 2024-09-09 10:04:33 | john | 2 | 29872 | 101 | 4.923 | 6067.8 |
| 586 | 2024-09-09 01:41:40 | john | 2 | 29872 | 101 | 0.826 | 36164.6 |
| 585 | 2024-09-09 01:41:34 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |