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 |
| 740 | 2026-04-17 10:21:53 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 739 | 2026-04-17 04:38:25 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 738 | 2026-04-04 03:42:49 | john | 1 | 13983 | 4 | 1.653 | 8459.2 |
| 737 | 2026-04-03 21:35:37 | john | 1 | 13983 | 4 | 0.390 | 35853.8 |
| 736 | 2026-04-03 14:08:49 | john | 1 | 13983 | 4 | 1.110 | 12597.3 |
| 735 | 2026-04-02 17:11:07 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 734 | 2026-03-30 15:10:26 | john | 2 | 29872 | 101 | 4.643 | 6433.8 |
| 733 | 2026-03-30 15:10:08 | john | 2 | 29872 | 101 | 5.033 | 5935.2 |
| 732 | 2026-03-30 15:10:00 | john | 2 | 29872 | 101 | 2.110 | 14157.3 |
| 731 | 2026-03-30 04:49:49 | john | 2 | 29872 | 101 | 3.360 | 8890.5 |
| 730 | 2026-03-29 21:29:15 | john | 2 | 29872 | 101 | 4.563 | 6546.6 |
| 729 | 2026-03-29 12:49:25 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 728 | 2026-03-28 22:07:35 | john | 2 | 29872 | 101 | 2.016 | 14817.5 |
| 727 | 2026-03-27 09:19:30 | john | 1 | 13983 | 4 | 1.503 | 9303.4 |
| 726 | 2026-03-24 21:41:15 | john | 1 | 13983 | 4 | 1.093 | 12793.2 |
| 725 | 2026-03-24 16:04:55 | john | 2 | 29872 | 101 | 6.406 | 4663.1 |
| 724 | 2026-03-17 05:42:34 | john | 2 | 29872 | 101 | 1.266 | 23595.6 |
| 723 | 2026-03-14 10:51:13 | john | 2 | 29872 | 101 | 3.936 | 7589.4 |
| 722 | 2026-03-11 13:07:25 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 721 | 2026-03-09 18:21:53 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 720 | 2026-03-09 08:23:37 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 719 | 2026-03-07 02:22:16 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 718 | 2026-03-06 10:53:44 | john | 2 | 29872 | 101 | 1.750 | 17069.7 |
| 717 | 2026-03-04 10:56:08 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 716 | 2026-03-02 08:00:25 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 715 | 2026-02-20 07:10:37 | john | 1 | 13983 | 4 | 0.403 | 34697.3 |
| 714 | 2026-02-14 00:06:07 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 713 | 2026-02-12 16:36:47 | john | 1 | 13983 | 4 | 0.263 | 53167.3 |
| 712 | 2026-02-12 03:15:47 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 711 | 2026-02-11 20:39:45 | john | 2 | 29872 | 101 | 3.453 | 8651.0 |
| 710 | 2026-02-11 13:06:30 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 709 | 2026-02-05 01:47:49 | john | 2 | 29872 | 101 | 0.890 | 33564.0 |
| 708 | 2026-01-21 21:47:30 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 707 | 2026-01-11 06:54:14 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 706 | 2026-01-11 01:33:59 | john | 2 | 29872 | 101 | 0.873 | 34217.6 |
| 705 | 2026-01-06 05:13:48 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 704 | 2025-12-31 01:23:07 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 703 | 2025-12-28 19:41:39 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 702 | 2025-12-27 21:54:34 | john | 1 | 13983 | 4 | 0.296 | 47239.9 |
| 701 | 2025-12-26 18:45:25 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 700 | 2025-12-26 05:28:30 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 699 | 2025-12-14 01:29:40 | john | 1 | 13983 | 4 | 0.280 | 49939.3 |
| 698 | 2025-12-14 01:27:25 | john | 1 | 13983 | 4 | 0.576 | 24276.0 |
| 697 | 2025-12-02 03:51:38 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 696 | 2025-11-30 01:23:28 | john | 1 | 13983 | 4 | 0.656 | 21315.5 |
| 695 | 2025-11-23 07:56:05 | john | 1 | 13983 | 4 | 0.516 | 27098.8 |
| 694 | 2025-11-22 23:54:06 | john | 2 | 29872 | 101 | 0.750 | 39829.3 |
| 693 | 2025-11-21 17:38:50 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 692 | 2025-11-18 05:47:10 | john | 1 | 13983 | 4 | 0.263 | 53167.3 |
| 691 | 2025-11-14 20:38:14 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 690 | 2025-11-14 13:24:31 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 689 | 2025-11-14 12:14:30 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 688 | 2025-11-13 18:13:50 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 687 | 2025-11-13 17:49:12 | john | 1 | 13983 | 4 | 0.516 | 27098.8 |
| 686 | 2025-11-10 22:14:01 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 685 | 2025-11-10 21:06:47 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 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 |