History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mysid"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 833 | 2024-05-01 02:34:56 | mysid | 1 | 28756 | 3 | 1.080 | 26625.9 |
| 832 | 2024-04-30 06:17:10 | mysid | 1 | 28756 | 3 | 1.626 | 17685.1 |
| 831 | 2024-04-25 11:21:33 | mysid | 3 | 83667 | 532 | 6.736 | 12420.9 |
| 830 | 2024-04-02 22:15:58 | mysid | 3 | 83667 | 532 | 11.783 | 7100.7 |
| 829 | 2024-04-02 22:15:58 | mysid | 2 | 53800 | 28 | 5.410 | 9944.5 |
| 828 | 2024-04-02 21:46:54 | mysid | 1 | 28756 | 3 | 0.423 | 67981.1 |
| 827 | 2024-04-01 11:31:44 | mysid | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 826 | 2024-03-31 15:13:02 | mysid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 825 | 2024-03-30 02:45:21 | mysid | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 824 | 2024-03-10 23:01:54 | mysid | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 823 | 2024-03-02 18:21:20 | mysid | 1 | 28756 | 3 | 0.550 | 52283.6 |
| 822 | 2024-03-01 13:36:07 | mysid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 821 | 2024-02-28 20:35:03 | mysid | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 820 | 2024-02-22 05:35:59 | mysid | 2 | 53800 | 28 | 1.330 | 40451.1 |
| 819 | 2024-02-01 12:04:59 | mysid | 3 | 83667 | 532 | 3.110 | 26902.6 |
| 818 | 2024-01-29 05:36:05 | mysid | 1 | 28756 | 3 | 0.403 | 71354.8 |
| 817 | 2024-01-29 05:11:59 | mysid | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 816 | 2024-01-18 12:08:06 | mysid | 3 | 83667 | 532 | 3.156 | 26510.5 |
| 815 | 2024-01-15 18:38:53 | mysid | 3 | 83667 | 532 | 3.250 | 25743.7 |
| 814 | 2023-12-29 06:12:02 | mysid | 2 | 53800 | 28 | 1.296 | 41512.3 |
| 813 | 2023-12-27 23:50:03 | mysid | 3 | 83667 | 532 | 3.640 | 22985.4 |
| 812 | 2023-12-24 06:25:12 | mysid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 811 | 2023-12-21 17:25:58 | mysid | 3 | 83667 | 532 | 3.623 | 23093.3 |
| 810 | 2023-12-21 17:25:57 | mysid | 2 | 53800 | 28 | 2.906 | 18513.4 |
| 809 | 2023-12-17 07:52:06 | mysid | 3 | 83667 | 532 | 3.656 | 22884.8 |
| 808 | 2023-12-07 17:03:37 | mysid | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 807 | 2023-11-18 19:32:59 | mysid | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 806 | 2023-11-17 20:57:06 | mysid | 2 | 53800 | 28 | 1.313 | 40974.9 |
| 805 | 2023-11-13 17:42:20 | mysid | 3 | 83667 | 532 | 3.546 | 23594.8 |
| 804 | 2023-11-13 17:42:18 | mysid | 2 | 53800 | 28 | 1.373 | 39184.3 |
| 803 | 2023-11-12 01:47:58 | mysid | 1 | 28756 | 3 | 0.423 | 67981.1 |
| 802 | 2023-11-03 12:42:55 | mysid | 1 | 28756 | 3 | 0.940 | 30591.5 |
| 801 | 2023-10-29 03:32:57 | mysid | 3 | 83667 | 532 | 4.423 | 18916.3 |
| 800 | 2023-10-21 09:30:26 | mysid | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 799 | 2023-10-18 19:53:55 | mysid | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 798 | 2023-10-12 13:56:38 | mysid | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 797 | 2023-10-11 04:57:53 | mysid | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 796 | 2023-10-05 06:39:01 | mysid | 1 | 28756 | 3 | 0.423 | 67981.1 |
| 795 | 2023-09-27 01:14:26 | mysid | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 794 | 2023-09-22 06:53:42 | mysid | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 793 | 2023-08-18 22:08:27 | mysid | 2 | 53800 | 28 | 1.330 | 40451.1 |
| 792 | 2023-08-08 23:17:38 | mysid | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 791 | 2023-08-08 05:47:26 | mysid | 3 | 83667 | 532 | 3.703 | 22594.4 |
| 790 | 2023-08-06 05:07:44 | mysid | 3 | 83667 | 532 | 3.156 | 26510.5 |
| 789 | 2023-07-20 05:43:03 | mysid | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 788 | 2023-07-11 16:29:23 | mysid | 3 | 83667 | 532 | 3.360 | 24900.9 |
| 787 | 2023-07-09 18:33:26 | mysid | 3 | 83667 | 532 | 3.796 | 22040.8 |
| 786 | 2023-07-08 20:14:30 | mysid | 3 | 83667 | 532 | 3.923 | 21327.3 |
| 785 | 2023-06-01 23:14:31 | mysid | 3 | 83667 | 532 | 3.513 | 23816.4 |
| 784 | 2023-05-27 20:10:13 | mysid | 2 | 53800 | 28 | 3.173 | 16955.6 |
| 783 | 2023-05-08 15:05:24 | mysid | 1 | 28756 | 3 | 0.420 | 68466.7 |
| 782 | 2023-05-04 18:53:48 | mysid | 2 | 53800 | 28 | 1.263 | 42597.0 |
| 781 | 2023-04-24 18:54:54 | mysid | 3 | 83667 | 532 | 3.093 | 27050.4 |
| 780 | 2023-04-13 11:47:10 | mysid | 3 | 83667 | 532 | 3.216 | 26015.9 |
| 779 | 2023-04-12 09:12:17 | mysid | 3 | 83667 | 532 | 4.140 | 20209.4 |
| 778 | 2023-04-11 09:06:32 | mysid | 3 | 83667 | 532 | 3.576 | 23396.8 |
| 777 | 2023-04-10 09:08:37 | mysid | 3 | 83667 | 532 | 3.126 | 26764.9 |
| 776 | 2023-04-09 09:15:53 | mysid | 3 | 83667 | 532 | 3.453 | 24230.2 |
| 775 | 2023-04-08 10:03:39 | mysid | 3 | 83667 | 532 | 3.500 | 23904.9 |
| 774 | 2023-04-07 23:22:36 | mysid | 2 | 53800 | 28 | 1.266 | 42496.1 |
| 773 | 2023-04-07 09:05:18 | mysid | 3 | 83667 | 532 | 3.046 | 27467.8 |
| 772 | 2023-04-06 10:41:50 | mysid | 3 | 83667 | 532 | 4.546 | 18404.5 |
| 771 | 2023-04-05 10:28:53 | mysid | 3 | 83667 | 532 | 3.203 | 26121.4 |
| 770 | 2023-04-04 09:48:03 | mysid | 3 | 83667 | 532 | 3.516 | 23796.1 |
| 769 | 2023-04-03 09:14:38 | mysid | 3 | 83667 | 532 | 3.436 | 24350.1 |
| 768 | 2023-04-02 09:00:39 | mysid | 3 | 83667 | 532 | 5.876 | 14238.8 |
| 767 | 2023-04-01 09:00:32 | mysid | 3 | 83667 | 532 | 3.283 | 25484.9 |
| 766 | 2023-03-31 13:36:48 | mysid | 3 | 83667 | 532 | 6.250 | 13386.7 |
| 765 | 2023-03-31 08:54:35 | mysid | 3 | 83667 | 532 | 3.483 | 24021.5 |
| 764 | 2023-03-30 08:45:35 | mysid | 3 | 83667 | 532 | 3.593 | 23286.1 |
| 763 | 2023-03-29 09:00:04 | mysid | 3 | 83667 | 532 | 3.516 | 23796.1 |
| 762 | 2023-03-28 08:53:45 | mysid | 3 | 83667 | 532 | 3.296 | 25384.4 |
| 761 | 2023-03-27 10:16:50 | mysid | 3 | 83667 | 532 | 3.283 | 25484.9 |
| 760 | 2023-03-26 22:06:57 | mysid | 3 | 83667 | 532 | 3.186 | 26260.8 |
| 759 | 2023-03-26 10:09:14 | mysid | 3 | 83667 | 532 | 3.126 | 26764.9 |
| 758 | 2023-03-26 02:13:38 | mysid | 3 | 83667 | 532 | 3.706 | 22576.1 |
| 757 | 2023-03-25 10:09:23 | mysid | 3 | 83667 | 532 | 3.093 | 27050.4 |
| 756 | 2023-03-24 10:23:11 | mysid | 3 | 83667 | 532 | 3.813 | 21942.6 |
| 755 | 2023-03-23 10:17:39 | mysid | 3 | 83667 | 532 | 6.690 | 12506.3 |
| 754 | 2023-03-22 10:14:21 | mysid | 3 | 83667 | 532 | 3.780 | 22134.1 |
| 753 | 2023-03-21 10:11:12 | mysid | 3 | 83667 | 532 | 3.483 | 24021.5 |
| 752 | 2023-03-20 09:51:28 | mysid | 3 | 83667 | 532 | 3.326 | 25155.4 |
| 751 | 2023-03-19 10:03:22 | mysid | 3 | 83667 | 532 | 3.063 | 27315.4 |
| 750 | 2023-03-18 08:43:06 | mysid | 3 | 83667 | 532 | 3.093 | 27050.4 |
| 749 | 2023-03-18 05:34:53 | mysid | 1 | 28756 | 3 | 0.420 | 68466.7 |
| 748 | 2023-03-17 08:37:39 | mysid | 3 | 83667 | 532 | 3.096 | 27024.2 |
| 747 | 2023-03-15 08:17:29 | mysid | 3 | 83667 | 532 | 3.093 | 27050.4 |
| 746 | 2023-03-14 08:47:09 | mysid | 3 | 83667 | 532 | 3.123 | 26790.6 |
| 745 | 2023-03-13 08:35:53 | mysid | 3 | 83667 | 532 | 3.126 | 26764.9 |
| 744 | 2023-03-12 10:01:47 | mysid | 3 | 83667 | 532 | 3.640 | 22985.4 |
| 743 | 2023-03-10 08:30:53 | mysid | 3 | 83667 | 532 | 3.076 | 27199.9 |
| 742 | 2023-03-09 09:00:34 | mysid | 3 | 83667 | 532 | 3.656 | 22884.8 |
| 741 | 2023-03-08 09:09:24 | mysid | 3 | 83667 | 532 | 3.296 | 25384.4 |
| 740 | 2023-03-07 09:46:12 | mysid | 3 | 83667 | 532 | 3.093 | 27050.4 |
| 739 | 2023-03-04 08:24:09 | mysid | 3 | 83667 | 532 | 3.266 | 25617.6 |
| 738 | 2023-03-03 17:10:17 | mysid | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 737 | 2023-03-03 08:14:59 | mysid | 3 | 83667 | 532 | 3.280 | 25508.2 |
| 736 | 2023-03-01 07:34:20 | mysid | 3 | 83667 | 532 | 3.906 | 21420.1 |
| 735 | 2023-02-28 07:38:06 | mysid | 3 | 83667 | 532 | 3.640 | 22985.4 |
| 734 | 2023-02-27 09:06:00 | mysid | 3 | 83667 | 532 | 3.063 | 27315.4 |