History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"topaz"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 873 | 2025-11-06 08:59:23 | topaz | 3 | 83667 | 736 | 3.470 | 24111.5 |
| 872 | 2025-11-03 22:15:40 | topaz | 3 | 83667 | 736 | 3.830 | 21845.2 |
| 871 | 2025-11-02 16:17:56 | topaz | 3 | 83667 | 736 | 3.956 | 21149.4 |
| 870 | 2025-10-31 14:41:40 | topaz | 3 | 83667 | 736 | 3.466 | 24139.4 |
| 869 | 2025-10-29 14:25:35 | topaz | 3 | 83667 | 736 | 3.940 | 21235.3 |
| 868 | 2025-10-27 07:07:52 | topaz | 3 | 83667 | 736 | 4.220 | 19826.3 |
| 867 | 2025-10-25 18:53:15 | topaz | 3 | 83667 | 736 | 3.813 | 21942.6 |
| 866 | 2025-10-25 06:39:59 | topaz | 3 | 83667 | 736 | 3.860 | 21675.4 |
| 865 | 2025-10-23 07:49:09 | topaz | 3 | 83667 | 736 | 17.436 | 4798.5 |
| 864 | 2025-10-21 15:17:25 | topaz | 3 | 83667 | 736 | 10.393 | 8050.3 |
| 863 | 2025-10-20 12:42:39 | topaz | 1 | 28756 | 1 | 0.470 | 61183.0 |
| 862 | 2025-10-17 00:58:25 | topaz | 1 | 28756 | 1 | 0.533 | 53951.2 |
| 861 | 2025-10-14 05:24:17 | topaz | 3 | 83667 | 736 | 3.966 | 21096.1 |
| 860 | 2025-10-04 14:12:32 | topaz | 3 | 83667 | 736 | 3.800 | 22017.6 |
| 859 | 2025-10-03 07:41:52 | topaz | 3 | 83667 | 736 | 3.923 | 21327.3 |
| 858 | 2025-10-02 03:06:26 | topaz | 3 | 83667 | 736 | 3.986 | 20990.2 |
| 857 | 2025-09-27 14:35:43 | topaz | 3 | 83667 | 736 | 3.486 | 24000.9 |
| 856 | 2025-09-26 11:45:39 | topaz | 3 | 83667 | 736 | 3.640 | 22985.4 |
| 855 | 2025-09-23 02:27:56 | topaz | 3 | 83667 | 736 | 4.310 | 19412.3 |
| 854 | 2025-09-21 07:55:57 | topaz | 3 | 83667 | 736 | 4.003 | 20901.1 |
| 853 | 2025-09-15 09:52:05 | topaz | 1 | 28756 | 1 | 0.500 | 57512.0 |
| 852 | 2025-09-08 23:51:10 | topaz | 3 | 83667 | 736 | 3.500 | 23904.9 |
| 851 | 2025-09-06 15:04:44 | topaz | 1 | 28756 | 1 | 0.453 | 63479.0 |
| 850 | 2025-09-03 10:32:45 | topaz | 1 | 28756 | 1 | 0.453 | 63479.0 |
| 849 | 2025-09-03 03:17:06 | topaz | 3 | 83667 | 736 | 4.266 | 19612.5 |
| 848 | 2025-08-27 22:57:45 | topaz | 3 | 83667 | 736 | 3.876 | 21585.9 |
| 847 | 2025-08-27 04:58:06 | topaz | 1 | 28756 | 1 | 0.516 | 55728.7 |
| 846 | 2025-08-27 04:58:04 | topaz | 1 | 28756 | 1 | 0.530 | 54256.6 |
| 845 | 2025-08-11 16:41:45 | topaz | 3 | 83667 | 736 | 9.440 | 8863.0 |
| 844 | 2025-08-09 11:34:52 | topaz | 3 | 83667 | 736 | 16.500 | 5070.7 |
| 843 | 2025-08-05 17:04:03 | topaz | 1 | 28756 | 1 | 2.313 | 12432.3 |
| 842 | 2025-08-05 16:18:42 | topaz | 1 | 28756 | 1 | 1.220 | 23570.5 |
| 841 | 2025-08-05 04:13:58 | topaz | 1 | 28756 | 1 | 1.953 | 14724.0 |
| 840 | 2025-07-29 02:17:13 | topaz | 2 | 53800 | 52 | 3.906 | 13773.7 |
| 839 | 2025-07-29 01:37:42 | topaz | 3 | 83667 | 736 | 9.813 | 8526.1 |
| 838 | 2025-07-29 00:25:58 | topaz | 2 | 53800 | 52 | 8.220 | 6545.0 |
| 837 | 2025-07-28 16:55:22 | topaz | 1 | 28756 | 1 | 1.233 | 23322.0 |
| 836 | 2025-07-28 02:30:51 | topaz | 3 | 83667 | 736 | 19.500 | 4290.6 |
| 835 | 2025-07-28 02:30:56 | topaz | 3 | 83667 | 736 | 11.436 | 7316.1 |
| 834 | 2025-07-28 01:51:50 | topaz | 2 | 53800 | 52 | 9.470 | 5681.1 |
| 833 | 2025-07-28 01:51:46 | topaz | 2 | 53800 | 52 | 4.126 | 13039.3 |
| 832 | 2025-07-27 07:23:45 | topaz | 3 | 83667 | 736 | 20.046 | 4173.8 |
| 831 | 2025-07-26 01:41:42 | topaz | 1 | 28756 | 1 | 0.516 | 55728.7 |
| 830 | 2025-07-26 01:41:41 | topaz | 1 | 28756 | 1 | 0.560 | 51350.0 |
| 829 | 2025-07-24 14:24:00 | topaz | 1 | 28756 | 1 | 0.953 | 30174.2 |
| 828 | 2025-07-22 02:01:40 | topaz | 1 | 28756 | 1 | 0.530 | 54256.6 |
| 827 | 2025-07-17 16:48:17 | topaz | 1 | 28756 | 1 | 1.500 | 19170.7 |
| 826 | 2025-07-17 09:29:49 | topaz | 2 | 53800 | 52 | 4.126 | 13039.3 |
| 825 | 2025-07-15 13:55:14 | topaz | 2 | 53800 | 52 | 3.703 | 14528.8 |
| 824 | 2025-07-15 11:48:15 | topaz | 1 | 28756 | 1 | 1.233 | 23322.0 |
| 823 | 2025-07-13 01:28:33 | topaz | 1 | 28756 | 1 | 1.186 | 24246.2 |
| 822 | 2025-07-09 18:34:42 | topaz | 3 | 83667 | 736 | 4.016 | 20833.4 |
| 821 | 2025-07-09 17:30:08 | topaz | 1 | 28756 | 1 | 0.486 | 59168.7 |
| 820 | 2025-07-08 15:14:47 | topaz | 3 | 83667 | 736 | 14.360 | 5826.4 |
| 819 | 2025-07-05 04:44:46 | topaz | 3 | 83667 | 736 | 19.580 | 4273.1 |
| 818 | 2025-07-05 02:49:37 | topaz | 3 | 83667 | 736 | 21.410 | 3907.8 |
| 817 | 2025-07-04 01:59:29 | topaz | 3 | 83667 | 736 | 20.453 | 4090.7 |
| 816 | 2025-07-02 21:42:02 | topaz | 1 | 28756 | 1 | 1.170 | 24577.8 |
| 815 | 2025-07-02 15:27:45 | topaz | 1 | 28756 | 1 | 1.763 | 16310.8 |
| 814 | 2025-06-23 06:56:18 | topaz | 1 | 28756 | 1 | 0.470 | 61183.0 |
| 813 | 2025-06-21 21:32:36 | topaz | 1 | 28756 | 1 | 2.516 | 11429.3 |
| 812 | 2025-06-20 13:56:51 | topaz | 1 | 28756 | 1 | 2.736 | 10510.2 |
| 811 | 2025-06-17 12:46:35 | topaz | 1 | 28756 | 1 | 0.530 | 54256.6 |
| 810 | 2025-06-15 03:05:56 | topaz | 1 | 28756 | 1 | 0.546 | 52666.7 |
| 809 | 2025-06-12 01:19:28 | topaz | 1 | 28756 | 1 | 2.373 | 12118.0 |
| 808 | 2025-06-11 11:10:45 | topaz | 3 | 83667 | 736 | 13.610 | 6147.5 |
| 807 | 2025-06-07 07:03:13 | topaz | 3 | 83667 | 736 | 7.110 | 11767.5 |
| 806 | 2025-06-06 15:08:00 | topaz | 3 | 83667 | 736 | 20.266 | 4128.4 |
| 805 | 2025-06-05 05:26:56 | topaz | 2 | 53800 | 52 | 4.546 | 11834.6 |
| 804 | 2025-06-04 14:43:33 | topaz | 3 | 83667 | 736 | 19.686 | 4250.1 |
| 803 | 2025-06-04 05:49:22 | topaz | 1 | 28756 | 1 | 2.653 | 10839.1 |
| 802 | 2025-06-03 01:34:18 | topaz | 3 | 83667 | 736 | 3.483 | 24021.5 |
| 801 | 2025-06-02 14:40:35 | topaz | 1 | 28756 | 1 | 2.343 | 12273.2 |
| 800 | 2025-05-31 19:11:41 | topaz | 2 | 53800 | 52 | 4.280 | 12570.1 |
| 799 | 2025-05-31 11:38:01 | topaz | 3 | 83667 | 736 | 11.596 | 7215.2 |
| 798 | 2025-05-31 08:03:14 | topaz | 1 | 28756 | 1 | 2.343 | 12273.2 |
| 797 | 2025-05-31 07:58:12 | topaz | 1 | 28756 | 1 | 2.170 | 13251.6 |
| 796 | 2025-05-29 22:44:18 | topaz | 3 | 83667 | 736 | 8.656 | 9665.8 |
| 795 | 2025-05-29 19:43:19 | topaz | 3 | 83667 | 736 | 6.046 | 13838.4 |
| 794 | 2025-05-28 14:07:36 | topaz | 3 | 83667 | 736 | 13.173 | 6351.4 |
| 793 | 2025-05-27 23:20:29 | topaz | 3 | 83667 | 736 | 3.893 | 21491.7 |
| 792 | 2025-05-27 09:48:41 | topaz | 3 | 83667 | 736 | 15.250 | 5486.4 |
| 791 | 2025-05-26 17:37:04 | topaz | 3 | 83667 | 736 | 19.816 | 4222.2 |
| 790 | 2025-05-25 06:31:43 | topaz | 1 | 28756 | 1 | 0.513 | 56054.6 |
| 789 | 2025-05-20 09:35:56 | topaz | 1 | 28756 | 1 | 2.690 | 10690.0 |
| 788 | 2025-05-20 00:18:01 | topaz | 1 | 28756 | 1 | 2.093 | 13739.1 |
| 787 | 2025-05-14 00:02:11 | topaz | 1 | 28756 | 1 | 1.606 | 17905.4 |
| 786 | 2025-05-12 01:36:58 | topaz | 1 | 28756 | 1 | 3.530 | 8146.2 |
| 785 | 2025-04-22 11:56:08 | topaz | 3 | 83667 | 736 | 5.440 | 15380.0 |
| 784 | 2025-04-21 17:53:47 | topaz | 2 | 53800 | 52 | 12.046 | 4466.2 |
| 783 | 2025-04-21 17:43:39 | topaz | 3 | 83667 | 736 | 23.813 | 3513.5 |
| 782 | 2025-04-20 08:08:20 | topaz | 1 | 28756 | 1 | 0.513 | 56054.6 |
| 781 | 2025-04-17 23:07:41 | topaz | 1 | 28756 | 1 | 2.436 | 11804.6 |
| 780 | 2025-04-11 19:56:31 | topaz | 2 | 53800 | 52 | 7.780 | 6915.2 |
| 779 | 2025-04-11 19:49:50 | topaz | 3 | 83667 | 736 | 16.783 | 4985.2 |
| 778 | 2025-04-11 01:25:12 | topaz | 1 | 28756 | 1 | 2.360 | 12184.7 |
| 777 | 2025-04-10 23:40:37 | topaz | 1 | 28756 | 1 | 3.186 | 9025.7 |
| 776 | 2025-04-02 14:32:15 | topaz | 1 | 28756 | 1 | 1.423 | 20208.0 |
| 775 | 2025-03-31 06:46:30 | topaz | 1 | 28756 | 1 | 0.936 | 30722.2 |
| 774 | 2025-03-18 02:25:47 | topaz | 2 | 53800 | 52 | 7.846 | 6857.0 |