History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johnnie"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 710 | 2025-09-18 18:47:45 | johnnie | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 709 | 2025-09-14 16:54:50 | johnnie | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 708 | 2025-08-28 07:58:18 | johnnie | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 707 | 2025-08-28 05:10:44 | johnnie | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 706 | 2025-08-27 20:27:51 | johnnie | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 705 | 2025-08-23 02:19:42 | johnnie | 1 | 69583 | 2 | 3.186 | 21840.2 |
| 704 | 2025-08-19 10:32:48 | johnnie | 3 | 134027 | 41 | 17.813 | 7524.1 |
| 703 | 2025-08-14 04:44:02 | johnnie | 3 | 134027 | 41 | 6.453 | 20769.7 |
| 702 | 2025-07-27 08:36:50 | johnnie | 1 | 69583 | 2 | 2.970 | 23428.6 |
| 701 | 2025-07-25 13:32:23 | johnnie | 1 | 69583 | 2 | 2.750 | 25302.9 |
| 700 | 2025-07-24 23:57:20 | johnnie | 1 | 69583 | 2 | 2.983 | 23326.5 |
| 699 | 2025-07-16 10:52:20 | johnnie | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 698 | 2025-07-14 04:49:26 | johnnie | 1 | 69583 | 2 | 3.326 | 20920.9 |
| 697 | 2025-07-12 12:29:57 | johnnie | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 696 | 2025-07-11 00:06:59 | johnnie | 3 | 134027 | 41 | 45.453 | 2948.7 |
| 695 | 2025-07-10 17:03:12 | johnnie | 1 | 69583 | 2 | 2.436 | 28564.4 |
| 694 | 2025-07-09 23:00:12 | johnnie | 3 | 134027 | 41 | 31.223 | 4292.6 |
| 693 | 2025-07-07 05:26:31 | johnnie | 1 | 69583 | 2 | 3.110 | 22374.0 |
| 692 | 2025-07-06 18:43:36 | johnnie | 1 | 69583 | 2 | 1.110 | 62687.4 |
| 691 | 2025-06-24 15:20:14 | johnnie | 2 | 107671 | 4 | 16.766 | 6422.0 |
| 690 | 2025-06-24 02:02:27 | johnnie | 3 | 134027 | 41 | 29.890 | 4484.0 |
| 689 | 2025-06-23 07:08:22 | johnnie | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 688 | 2025-06-22 16:04:43 | johnnie | 3 | 134027 | 41 | 21.610 | 6202.1 |
| 687 | 2025-06-22 09:55:18 | johnnie | 1 | 69583 | 2 | 4.406 | 15792.8 |
| 686 | 2025-06-22 02:17:35 | johnnie | 2 | 107671 | 4 | 18.110 | 5945.4 |
| 685 | 2025-06-21 07:22:25 | johnnie | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 684 | 2025-06-21 00:45:09 | johnnie | 1 | 69583 | 2 | 5.690 | 12229.0 |
| 683 | 2025-06-18 00:18:51 | johnnie | 1 | 69583 | 2 | 6.236 | 11158.3 |
| 682 | 2025-06-13 22:22:38 | johnnie | 1 | 69583 | 2 | 2.560 | 27180.9 |
| 681 | 2025-06-11 23:19:53 | johnnie | 4 | 151207 | 690 | 41.410 | 3651.5 |
| 680 | 2025-06-10 11:30:05 | johnnie | 4 | 151207 | 690 | 38.473 | 3930.2 |
| 679 | 2025-06-08 08:56:20 | johnnie | 4 | 151207 | 690 | 48.673 | 3106.6 |
| 678 | 2025-05-31 04:46:36 | johnnie | 4 | 151207 | 690 | 61.893 | 2443.0 |
| 677 | 2025-05-31 03:15:48 | johnnie | 2 | 107671 | 4 | 22.500 | 4785.4 |
| 676 | 2025-05-31 01:10:30 | johnnie | 3 | 134027 | 41 | 25.080 | 5344.0 |
| 675 | 2025-05-30 20:11:53 | johnnie | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 674 | 2025-05-30 04:46:49 | johnnie | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 673 | 2025-05-24 18:27:44 | johnnie | 2 | 107671 | 4 | 7.530 | 14298.9 |
| 672 | 2025-05-24 07:37:10 | johnnie | 4 | 151207 | 690 | 58.236 | 2596.5 |
| 671 | 2025-05-23 04:05:07 | johnnie | 4 | 151207 | 690 | 16.296 | 9278.8 |
| 670 | 2025-05-22 04:33:56 | johnnie | 1 | 69583 | 2 | 6.000 | 11597.2 |
| 669 | 2025-05-15 06:41:17 | johnnie | 4 | 151207 | 690 | 10.986 | 13763.6 |
| 668 | 2025-05-14 09:41:57 | johnnie | 1 | 69583 | 2 | 4.783 | 14548.0 |
| 667 | 2025-05-10 23:43:58 | johnnie | 4 | 151207 | 690 | 49.550 | 3051.6 |
| 666 | 2025-05-08 12:24:16 | johnnie | 4 | 151207 | 690 | 49.220 | 3072.1 |
| 665 | 2025-05-05 21:59:59 | johnnie | 1 | 69583 | 2 | 2.830 | 24587.6 |
| 664 | 2025-05-05 13:36:23 | johnnie | 4 | 151207 | 690 | 21.206 | 7130.4 |
| 663 | 2025-05-05 07:54:13 | johnnie | 4 | 151207 | 690 | 55.596 | 2719.7 |
| 662 | 2025-05-04 01:22:30 | johnnie | 4 | 151207 | 690 | 47.190 | 3204.2 |
| 661 | 2025-05-03 17:06:56 | johnnie | 4 | 151207 | 690 | 14.500 | 10428.1 |
| 660 | 2025-04-27 04:16:20 | johnnie | 4 | 151207 | 690 | 13.156 | 11493.4 |
| 659 | 2025-04-23 06:50:17 | johnnie | 4 | 151207 | 690 | 61.176 | 2471.7 |
| 658 | 2025-04-23 02:31:45 | johnnie | 1 | 69583 | 2 | 5.966 | 11663.3 |
| 657 | 2025-04-20 03:56:05 | johnnie | 1 | 69583 | 2 | 5.343 | 13023.2 |
| 656 | 2025-04-11 06:29:40 | johnnie | 1 | 69583 | 2 | 8.596 | 8094.8 |
| 655 | 2025-04-09 08:31:50 | johnnie | 1 | 69583 | 2 | 6.173 | 11272.2 |
| 654 | 2025-04-08 11:35:12 | johnnie | 4 | 151207 | 690 | 52.940 | 2856.2 |
| 653 | 2025-04-07 22:28:41 | johnnie | 4 | 151207 | 690 | 68.130 | 2219.4 |
| 652 | 2025-04-06 13:47:27 | johnnie | 4 | 151207 | 690 | 57.656 | 2622.6 |
| 651 | 2025-04-04 20:59:52 | johnnie | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 650 | 2025-03-27 06:51:01 | johnnie | 1 | 69583 | 2 | 4.343 | 16021.9 |
| 649 | 2025-03-26 05:32:55 | johnnie | 4 | 151207 | 690 | 58.863 | 2568.8 |
| 648 | 2025-03-20 20:21:46 | johnnie | 4 | 151207 | 690 | 10.970 | 13783.7 |
| 647 | 2025-03-20 01:32:46 | johnnie | 2 | 107671 | 4 | 17.483 | 6158.6 |
| 646 | 2025-03-19 05:39:25 | johnnie | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 645 | 2025-03-15 06:51:57 | johnnie | 1 | 69583 | 2 | 4.313 | 16133.3 |
| 644 | 2025-03-10 13:47:13 | johnnie | 2 | 107671 | 4 | 13.126 | 8202.9 |
| 643 | 2025-03-10 13:00:57 | johnnie | 1 | 69583 | 2 | 5.266 | 13213.6 |
| 642 | 2025-03-09 20:14:47 | johnnie | 1 | 69583 | 2 | 5.263 | 13221.2 |
| 641 | 2025-03-06 16:11:54 | johnnie | 3 | 134027 | 41 | 24.703 | 5425.5 |
| 640 | 2025-03-06 08:58:19 | johnnie | 4 | 151207 | 690 | 29.063 | 5202.7 |
| 639 | 2025-03-05 22:29:47 | johnnie | 3 | 134027 | 41 | 28.596 | 4686.9 |
| 638 | 2025-03-05 22:28:49 | johnnie | 3 | 134027 | 41 | 31.796 | 4215.2 |
| 637 | 2025-03-05 07:01:45 | johnnie | 4 | 151207 | 690 | 54.483 | 2775.3 |
| 636 | 2025-03-05 07:00:59 | johnnie | 3 | 134027 | 41 | 27.923 | 4799.9 |
| 635 | 2025-03-05 07:00:57 | johnnie | 2 | 107671 | 4 | 10.266 | 10488.1 |
| 634 | 2025-03-05 07:00:51 | johnnie | 1 | 69583 | 2 | 2.093 | 33245.6 |
| 633 | 2025-02-28 04:36:49 | johnnie | 1 | 69583 | 2 | 6.420 | 10838.5 |
| 632 | 2025-02-26 22:46:40 | johnnie | 1 | 69583 | 2 | 5.843 | 11908.8 |
| 631 | 2025-02-23 08:02:47 | johnnie | 2 | 107671 | 4 | 16.330 | 6593.4 |
| 630 | 2025-02-23 08:01:18 | johnnie | 1 | 69583 | 2 | 5.406 | 12871.4 |
| 629 | 2025-02-18 08:47:37 | johnnie | 3 | 134027 | 41 | 31.020 | 4320.7 |
| 628 | 2025-02-15 07:31:15 | johnnie | 3 | 134027 | 41 | 41.766 | 3209.0 |
| 627 | 2025-02-11 23:03:28 | johnnie | 3 | 134027 | 41 | 33.126 | 4046.0 |
| 626 | 2025-01-30 22:16:41 | johnnie | 1 | 69583 | 2 | 5.643 | 12330.9 |
| 625 | 2025-01-29 22:07:37 | johnnie | 1 | 69583 | 2 | 3.576 | 19458.3 |
| 624 | 2025-01-21 14:21:01 | johnnie | 1 | 69583 | 2 | 5.766 | 12067.8 |
| 623 | 2025-01-06 16:09:41 | johnnie | 2 | 107671 | 4 | 4.266 | 25239.3 |
| 622 | 2024-12-28 18:38:23 | johnnie | 3 | 134027 | 41 | 31.846 | 4208.6 |
| 621 | 2024-12-28 18:38:23 | johnnie | 2 | 107671 | 4 | 21.610 | 4982.5 |
| 620 | 2024-12-28 17:36:05 | johnnie | 1 | 69583 | 2 | 2.533 | 27470.6 |
| 619 | 2024-12-20 21:16:33 | johnnie | 3 | 134027 | 41 | 44.410 | 3017.9 |
| 618 | 2024-12-20 21:16:48 | johnnie | 1 | 69583 | 2 | 5.250 | 13253.9 |
| 617 | 2024-12-20 21:16:32 | johnnie | 2 | 107671 | 4 | 14.890 | 7231.1 |
| 616 | 2024-12-19 12:15:38 | johnnie | 3 | 134027 | 41 | 6.060 | 22116.7 |
| 615 | 2024-12-19 12:15:39 | johnnie | 2 | 107671 | 4 | 3.093 | 34811.2 |
| 614 | 2024-12-19 12:15:34 | johnnie | 1 | 69583 | 2 | 1.080 | 64428.7 |
| 613 | 2024-12-05 00:48:57 | johnnie | 4 | 151207 | 690 | 40.656 | 3719.2 |
| 612 | 2024-12-05 00:16:54 | johnnie | 4 | 151207 | 690 | 56.566 | 2673.1 |
| 611 | 2024-12-04 22:01:03 | johnnie | 4 | 151207 | 690 | 57.456 | 2631.7 |