History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subitems"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 987 | 2026-04-20 00:29:45 | subitems | 1 | 82945 | 2 | 2.296 | 36125.9 |
| 986 | 2026-04-16 18:10:38 | subitems | 4 | 161609 | 1120 | 44.206 | 3655.8 |
| 985 | 2026-04-16 18:10:30 | subitems | 4 | 161609 | 1120 | 37.596 | 4298.6 |
| 984 | 2026-04-16 18:10:17 | subitems | 4 | 161609 | 1120 | 35.080 | 4606.9 |
| 983 | 2026-04-16 00:02:46 | subitems | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 982 | 2026-04-14 19:06:33 | subitems | 4 | 161609 | 1120 | 48.686 | 3319.4 |
| 981 | 2026-04-12 04:28:24 | subitems | 4 | 161609 | 1120 | 63.143 | 2559.4 |
| 980 | 2026-04-09 15:45:30 | subitems | 4 | 161609 | 1120 | 79.520 | 2032.3 |
| 979 | 2026-04-07 02:51:12 | subitems | 4 | 161609 | 1120 | 79.003 | 2045.6 |
| 978 | 2026-04-07 02:51:10 | subitems | 4 | 161609 | 1120 | 51.550 | 3135.0 |
| 977 | 2026-04-07 02:50:32 | subitems | 4 | 161609 | 1120 | 55.173 | 2929.1 |
| 976 | 2026-04-04 18:57:27 | subitems | 4 | 161609 | 1120 | 31.736 | 5092.3 |
| 975 | 2026-04-04 11:09:44 | subitems | 3 | 146162 | 92 | 7.876 | 18557.9 |
| 974 | 2026-04-02 15:29:16 | subitems | 3 | 146162 | 92 | 41.013 | 3563.8 |
| 973 | 2026-04-02 05:20:17 | subitems | 2 | 121059 | 7 | 24.970 | 4848.2 |
| 972 | 2026-04-01 08:25:41 | subitems | 1 | 82945 | 2 | 6.813 | 12174.5 |
| 971 | 2026-04-01 05:03:30 | subitems | 1 | 82945 | 2 | 7.470 | 11103.7 |
| 970 | 2026-03-31 21:17:47 | subitems | 1 | 82945 | 2 | 6.983 | 11878.1 |
| 969 | 2026-03-31 19:46:11 | subitems | 1 | 82945 | 2 | 10.063 | 8242.6 |
| 968 | 2026-03-31 19:06:13 | subitems | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 967 | 2026-03-30 11:24:16 | subitems | 1 | 82945 | 2 | 7.673 | 10810.0 |
| 966 | 2026-03-18 10:09:12 | subitems | 1 | 82945 | 2 | 1.560 | 53169.9 |
| 965 | 2026-03-10 22:13:57 | subitems | 1 | 82945 | 2 | 6.143 | 13502.4 |
| 964 | 2026-03-10 09:58:16 | subitems | 4 | 161609 | 1120 | 14.580 | 11084.3 |
| 963 | 2026-02-24 15:28:31 | subitems | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 962 | 2026-02-24 12:43:11 | subitems | 1 | 82945 | 2 | 1.326 | 62552.8 |
| 961 | 2026-02-24 12:13:11 | subitems | 1 | 82945 | 2 | 1.593 | 52068.4 |
| 960 | 2026-02-24 11:35:41 | subitems | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 959 | 2026-02-22 16:12:28 | subitems | 4 | 161609 | 1120 | 12.093 | 13363.8 |
| 958 | 2026-02-16 13:57:24 | subitems | 1 | 82945 | 2 | 4.533 | 18298.0 |
| 957 | 2026-02-16 11:11:29 | subitems | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 956 | 2026-02-13 23:06:37 | subitems | 4 | 161609 | 1120 | 53.316 | 3031.2 |
| 955 | 2026-02-13 23:06:08 | subitems | 4 | 161609 | 1120 | 34.970 | 4621.4 |
| 954 | 2026-02-13 19:56:06 | subitems | 4 | 161609 | 1120 | 24.080 | 6711.3 |
| 953 | 2026-02-13 15:31:59 | subitems | 1 | 82945 | 2 | 6.800 | 12197.8 |
| 952 | 2026-02-13 15:31:25 | subitems | 1 | 82945 | 2 | 7.190 | 11536.2 |
| 951 | 2026-02-13 15:31:10 | subitems | 1 | 82945 | 2 | 7.170 | 11568.3 |
| 950 | 2026-02-06 21:01:57 | subitems | 2 | 121059 | 7 | 3.923 | 30858.8 |
| 949 | 2026-01-23 02:27:57 | subitems | 4 | 161609 | 1120 | 12.000 | 13467.4 |
| 948 | 2026-01-22 17:17:54 | subitems | 4 | 161609 | 1120 | 53.270 | 3033.8 |
| 947 | 2026-01-22 14:25:58 | subitems | 1 | 82945 | 2 | 2.093 | 39629.7 |
| 946 | 2026-01-21 10:38:35 | subitems | 4 | 161609 | 1120 | 18.423 | 8772.1 |
| 945 | 2026-01-16 18:43:10 | subitems | 2 | 121059 | 7 | 3.263 | 37100.5 |
| 944 | 2026-01-14 18:19:18 | subitems | 3 | 146162 | 92 | 6.716 | 21763.3 |
| 943 | 2026-01-14 18:15:33 | subitems | 3 | 146162 | 92 | 14.170 | 10314.9 |
| 942 | 2026-01-14 15:40:36 | subitems | 3 | 146162 | 92 | 20.203 | 7234.7 |
| 941 | 2026-01-10 00:48:30 | subitems | 1 | 82945 | 2 | 1.376 | 60279.8 |
| 940 | 2026-01-02 01:46:10 | subitems | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 939 | 2025-12-23 20:08:31 | subitems | 1 | 82945 | 2 | 1.330 | 62364.7 |
| 938 | 2025-12-12 20:32:48 | subitems | 3 | 146162 | 92 | 7.326 | 19951.1 |
| 937 | 2025-12-12 16:56:20 | subitems | 3 | 146162 | 92 | 36.450 | 4009.9 |
| 936 | 2025-12-12 01:16:52 | subitems | 2 | 121059 | 7 | 19.123 | 6330.5 |
| 935 | 2025-12-11 01:22:07 | subitems | 1 | 82945 | 2 | 1.623 | 51106.0 |
| 934 | 2025-12-03 19:13:04 | subitems | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 933 | 2025-12-02 22:38:18 | subitems | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 932 | 2025-12-02 19:06:32 | subitems | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 931 | 2025-11-29 01:40:37 | subitems | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 930 | 2025-11-25 22:21:39 | subitems | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 929 | 2025-11-24 07:18:41 | subitems | 1 | 82945 | 2 | 2.030 | 40859.6 |
| 928 | 2025-11-24 03:46:25 | subitems | 1 | 82945 | 2 | 4.846 | 17116.2 |
| 927 | 2025-11-23 21:06:23 | subitems | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 926 | 2025-11-16 09:15:21 | subitems | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 925 | 2025-11-13 10:37:15 | subitems | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 924 | 2025-11-10 01:29:14 | subitems | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 923 | 2025-11-09 10:46:00 | subitems | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 922 | 2025-11-09 04:40:50 | subitems | 2 | 121059 | 7 | 3.436 | 35232.5 |
| 921 | 2025-11-05 05:50:27 | subitems | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 920 | 2025-10-31 04:43:46 | subitems | 1 | 82945 | 2 | 1.326 | 62552.8 |
| 919 | 2025-10-31 04:09:28 | subitems | 1 | 82945 | 2 | 2.046 | 40540.1 |
| 918 | 2025-10-29 02:57:51 | subitems | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 917 | 2025-10-21 09:03:47 | subitems | 1 | 82945 | 2 | 3.796 | 21850.6 |
| 916 | 2025-10-17 09:30:15 | subitems | 1 | 82945 | 2 | 1.330 | 62364.7 |
| 915 | 2025-09-29 04:38:22 | subitems | 1 | 82945 | 2 | 3.703 | 22399.4 |
| 914 | 2025-09-29 04:08:11 | subitems | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 913 | 2025-09-28 02:50:49 | subitems | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 912 | 2025-09-27 02:30:45 | subitems | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 911 | 2025-09-18 22:09:13 | subitems | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 910 | 2025-09-18 03:51:03 | subitems | 1 | 82945 | 2 | 1.330 | 62364.7 |
| 909 | 2025-09-11 08:35:13 | subitems | 1 | 82945 | 2 | 1.593 | 52068.4 |
| 908 | 2025-09-10 14:52:51 | subitems | 1 | 82945 | 2 | 1.606 | 51646.9 |
| 907 | 2025-09-01 08:28:48 | subitems | 2 | 121059 | 7 | 3.393 | 35679.0 |
| 906 | 2025-08-29 03:57:10 | subitems | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 905 | 2025-08-28 04:30:49 | subitems | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 904 | 2025-08-28 02:53:16 | subitems | 1 | 82945 | 2 | 1.563 | 53067.8 |
| 903 | 2025-08-27 01:53:03 | subitems | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 902 | 2025-08-17 08:23:52 | subitems | 4 | 161609 | 1120 | 35.423 | 4562.3 |
| 901 | 2025-08-16 12:00:04 | subitems | 4 | 161609 | 1120 | 11.516 | 14033.4 |
| 900 | 2025-08-15 06:48:01 | subitems | 4 | 161609 | 1120 | 47.876 | 3375.6 |
| 899 | 2025-08-12 03:47:32 | subitems | 4 | 161609 | 1120 | 36.956 | 4373.0 |
| 898 | 2025-08-10 17:07:23 | subitems | 1 | 82945 | 2 | 5.920 | 14011.0 |
| 897 | 2025-08-09 10:49:47 | subitems | 1 | 82945 | 2 | 5.080 | 16327.8 |
| 896 | 2025-08-02 23:33:18 | subitems | 1 | 82945 | 2 | 3.030 | 27374.6 |
| 895 | 2025-08-01 05:05:49 | subitems | 3 | 146162 | 92 | 19.500 | 7495.5 |
| 894 | 2025-07-27 20:58:42 | subitems | 1 | 82945 | 2 | 6.060 | 13687.3 |
| 893 | 2025-07-27 19:27:53 | subitems | 1 | 82945 | 2 | 6.923 | 11981.1 |
| 892 | 2025-07-24 06:11:07 | subitems | 1 | 82945 | 2 | 9.206 | 9009.9 |
| 891 | 2025-07-07 04:21:48 | subitems | 1 | 82945 | 2 | 3.456 | 24000.3 |
| 890 | 2025-07-05 10:35:48 | subitems | 1 | 82945 | 2 | 5.170 | 16043.5 |
| 889 | 2025-06-25 14:42:57 | subitems | 4 | 161609 | 1120 | 34.630 | 4666.7 |
| 888 | 2025-06-20 12:32:52 | subitems | 4 | 161609 | 1120 | 77.660 | 2081.0 |