History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pickles"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 901 | 2025-11-23 16:46:18 | pickles | 1 | 69583 | 8 | 1.546 | 45008.4 |
| 900 | 2025-11-23 16:46:07 | pickles | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 899 | 2025-11-21 14:19:47 | pickles | 1 | 69583 | 8 | 1.296 | 53690.6 |
| 898 | 2025-11-19 17:49:04 | pickles | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 897 | 2025-11-18 09:49:13 | pickles | 1 | 69583 | 8 | 3.563 | 19529.3 |
| 896 | 2025-11-17 02:19:55 | pickles | 3 | 134027 | 608 | 7.000 | 19146.7 |
| 895 | 2025-11-16 04:49:14 | pickles | 1 | 69583 | 8 | 1.236 | 56296.9 |
| 894 | 2025-11-12 18:01:14 | pickles | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 893 | 2025-11-12 14:09:23 | pickles | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 892 | 2025-10-24 19:02:35 | pickles | 3 | 134027 | 608 | 6.376 | 21020.5 |
| 891 | 2025-10-23 01:50:14 | pickles | 1 | 69583 | 8 | 5.750 | 12101.4 |
| 890 | 2025-10-14 20:38:24 | pickles | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 889 | 2025-10-13 20:01:15 | pickles | 1 | 69583 | 8 | 1.186 | 58670.3 |
| 888 | 2025-10-11 05:15:50 | pickles | 3 | 134027 | 608 | 6.733 | 19906.0 |
| 887 | 2025-09-29 02:11:51 | pickles | 3 | 134027 | 608 | 7.500 | 17870.3 |
| 886 | 2025-09-28 19:18:13 | pickles | 1 | 69583 | 8 | 1.330 | 52318.0 |
| 885 | 2025-09-28 00:33:09 | pickles | 1 | 69583 | 8 | 1.376 | 50569.0 |
| 884 | 2025-09-26 18:53:04 | pickles | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 883 | 2025-09-25 21:13:50 | pickles | 1 | 69583 | 8 | 4.173 | 16674.6 |
| 882 | 2025-09-23 11:22:39 | pickles | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 881 | 2025-09-21 16:22:56 | pickles | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 880 | 2025-09-18 22:18:10 | pickles | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 879 | 2025-09-03 23:34:47 | pickles | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 878 | 2025-09-03 00:31:22 | pickles | 1 | 69583 | 8 | 1.153 | 60349.5 |
| 877 | 2025-08-25 09:14:45 | pickles | 1 | 69583 | 8 | 7.406 | 9395.5 |
| 876 | 2025-08-25 06:23:23 | pickles | 1 | 69583 | 8 | 4.970 | 14000.6 |
| 875 | 2025-08-25 00:45:27 | pickles | 1 | 69583 | 8 | 5.626 | 12368.1 |
| 874 | 2025-08-24 22:09:35 | pickles | 1 | 69583 | 8 | 6.533 | 10651.0 |
| 873 | 2025-08-15 16:56:25 | pickles | 1 | 69583 | 8 | 2.843 | 24475.2 |
| 872 | 2025-08-09 17:38:18 | pickles | 1 | 69583 | 8 | 3.140 | 22160.2 |
| 871 | 2025-08-03 23:50:53 | pickles | 1 | 69583 | 8 | 2.343 | 29698.3 |
| 870 | 2025-07-30 04:35:13 | pickles | 1 | 69583 | 8 | 2.486 | 27989.9 |
| 869 | 2025-07-26 22:36:54 | pickles | 3 | 134027 | 608 | 19.830 | 6758.8 |
| 868 | 2025-07-25 02:01:56 | pickles | 1 | 69583 | 8 | 8.046 | 8648.1 |
| 867 | 2025-07-24 14:05:14 | pickles | 3 | 134027 | 608 | 32.016 | 4186.3 |
| 866 | 2025-07-24 02:24:08 | pickles | 1 | 69583 | 8 | 9.220 | 7547.0 |
| 865 | 2025-07-23 23:03:22 | pickles | 3 | 134027 | 608 | 23.393 | 5729.4 |
| 864 | 2025-07-23 16:49:25 | pickles | 1 | 69583 | 8 | 6.046 | 11508.9 |
| 863 | 2025-07-23 10:01:09 | pickles | 1 | 69583 | 8 | 5.266 | 13213.6 |
| 862 | 2025-07-23 04:13:13 | pickles | 1 | 69583 | 8 | 8.563 | 8126.0 |
| 861 | 2025-07-23 01:16:50 | pickles | 1 | 69583 | 8 | 5.516 | 12614.8 |
| 860 | 2025-07-23 01:07:50 | pickles | 1 | 69583 | 8 | 4.406 | 15792.8 |
| 859 | 2025-07-23 01:05:24 | pickles | 1 | 69583 | 8 | 8.280 | 8403.7 |
| 858 | 2025-07-22 20:55:56 | pickles | 2 | 107671 | 77 | 10.156 | 10601.7 |
| 857 | 2025-07-22 14:52:54 | pickles | 1 | 69583 | 8 | 2.766 | 25156.5 |
| 856 | 2025-07-22 14:23:41 | pickles | 1 | 69583 | 8 | 2.923 | 23805.3 |
| 855 | 2025-07-22 03:37:55 | pickles | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 854 | 2025-07-20 07:33:41 | pickles | 3 | 134027 | 608 | 6.953 | 19276.1 |
| 853 | 2025-07-15 13:17:28 | pickles | 1 | 69583 | 8 | 6.013 | 11572.1 |
| 852 | 2025-07-15 13:16:54 | pickles | 1 | 69583 | 8 | 3.016 | 23071.3 |
| 851 | 2025-07-15 02:27:21 | pickles | 2 | 107671 | 77 | 13.436 | 8013.6 |
| 850 | 2025-07-14 23:06:39 | pickles | 1 | 69583 | 8 | 4.983 | 13964.1 |
| 849 | 2025-07-14 16:46:13 | pickles | 1 | 69583 | 8 | 9.110 | 7638.1 |
| 848 | 2025-07-11 14:37:30 | pickles | 3 | 134027 | 608 | 37.920 | 3534.5 |
| 847 | 2025-07-10 16:30:23 | pickles | 2 | 107671 | 77 | 9.546 | 11279.2 |
| 846 | 2025-07-09 20:41:56 | pickles | 3 | 134027 | 608 | 34.440 | 3891.6 |
| 845 | 2025-07-09 19:04:52 | pickles | 2 | 107671 | 77 | 3.330 | 32333.6 |
| 844 | 2025-07-09 16:15:06 | pickles | 1 | 69583 | 8 | 1.106 | 62914.1 |
| 843 | 2025-07-08 06:16:20 | pickles | 1 | 69583 | 8 | 5.750 | 12101.4 |
| 842 | 2025-07-07 22:57:02 | pickles | 2 | 107671 | 77 | 20.330 | 5296.2 |
| 841 | 2025-07-03 22:32:48 | pickles | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 840 | 2025-07-03 22:32:22 | pickles | 2 | 107671 | 77 | 3.326 | 32372.5 |
| 839 | 2025-07-02 03:58:48 | pickles | 1 | 69583 | 8 | 4.813 | 14457.3 |
| 838 | 2025-06-25 13:31:27 | pickles | 1 | 69583 | 8 | 4.876 | 14270.5 |
| 837 | 2025-06-25 12:49:51 | pickles | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 836 | 2025-06-24 20:14:07 | pickles | 2 | 107671 | 77 | 14.673 | 7338.0 |
| 835 | 2025-06-23 01:35:04 | pickles | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 834 | 2025-06-22 00:43:20 | pickles | 1 | 69583 | 8 | 7.203 | 9660.3 |
| 833 | 2025-06-20 11:40:22 | pickles | 1 | 69583 | 8 | 5.466 | 12730.2 |
| 832 | 2025-06-20 07:43:38 | pickles | 1 | 69583 | 8 | 9.123 | 7627.2 |
| 831 | 2025-06-20 02:15:56 | pickles | 2 | 107671 | 77 | 16.906 | 6368.8 |
| 830 | 2025-06-19 06:28:17 | pickles | 2 | 107671 | 77 | 3.173 | 33933.5 |
| 829 | 2025-06-18 13:51:06 | pickles | 2 | 107671 | 77 | 8.563 | 12574.0 |
| 828 | 2025-06-17 06:41:24 | pickles | 2 | 107671 | 77 | 3.470 | 31029.1 |
| 827 | 2025-06-13 07:16:00 | pickles | 1 | 69583 | 8 | 5.733 | 12137.3 |
| 826 | 2025-06-12 07:36:38 | pickles | 1 | 69583 | 8 | 5.780 | 12038.6 |
| 825 | 2025-06-11 17:19:05 | pickles | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 824 | 2025-06-11 09:55:26 | pickles | 1 | 69583 | 8 | 2.750 | 25302.9 |
| 823 | 2025-06-10 11:39:26 | pickles | 2 | 107671 | 77 | 8.983 | 11986.1 |
| 822 | 2025-06-09 15:45:18 | pickles | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 821 | 2025-06-04 23:58:13 | pickles | 2 | 107671 | 77 | 18.643 | 5775.4 |
| 820 | 2025-06-04 19:22:56 | pickles | 3 | 134027 | 608 | 38.173 | 3511.0 |
| 819 | 2025-06-03 09:28:21 | pickles | 1 | 69583 | 8 | 1.190 | 58473.1 |
| 818 | 2025-06-02 08:16:18 | pickles | 3 | 134027 | 608 | 31.503 | 4254.4 |
| 817 | 2025-06-02 07:46:35 | pickles | 3 | 134027 | 608 | 29.656 | 4519.4 |
| 816 | 2025-06-01 20:51:04 | pickles | 1 | 69583 | 8 | 8.563 | 8126.0 |
| 815 | 2025-06-01 20:16:22 | pickles | 3 | 134027 | 608 | 30.563 | 4385.3 |
| 814 | 2025-06-01 05:46:23 | pickles | 3 | 134027 | 608 | 48.470 | 2765.2 |
| 813 | 2025-05-31 22:56:20 | pickles | 3 | 134027 | 608 | 29.323 | 4570.7 |
| 812 | 2025-05-30 21:40:25 | pickles | 3 | 134027 | 608 | 38.360 | 3493.9 |
| 811 | 2025-05-28 21:52:01 | pickles | 3 | 134027 | 608 | 28.376 | 4723.3 |
| 810 | 2025-05-25 03:34:45 | pickles | 1 | 69583 | 8 | 1.280 | 54361.7 |
| 809 | 2025-05-22 01:18:21 | pickles | 1 | 69583 | 8 | 6.216 | 11194.2 |
| 808 | 2025-05-20 21:24:20 | pickles | 1 | 69583 | 8 | 1.360 | 51164.0 |
| 807 | 2025-05-20 18:47:56 | pickles | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 806 | 2025-05-20 06:20:29 | pickles | 1 | 69583 | 8 | 6.516 | 10678.8 |
| 805 | 2025-05-17 04:55:45 | pickles | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 804 | 2025-05-14 12:26:40 | pickles | 3 | 134027 | 608 | 30.503 | 4393.9 |
| 803 | 2025-05-12 16:02:57 | pickles | 2 | 107671 | 77 | 16.390 | 6569.3 |
| 802 | 2025-05-12 06:26:19 | pickles | 2 | 107671 | 77 | 10.296 | 10457.6 |