History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prospects"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1013 | 2025-11-28 12:40:20 | prospects | 1 | 81242 | 4 | 1.466 | 55417.5 |
| 1012 | 2025-11-26 00:35:19 | prospects | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 1011 | 2025-11-24 16:21:58 | prospects | 1 | 81242 | 4 | 2.093 | 38816.1 |
| 1010 | 2025-11-23 18:36:31 | prospects | 1 | 81242 | 4 | 3.046 | 26671.7 |
| 1009 | 2025-11-22 00:30:08 | prospects | 1 | 81242 | 4 | 1.796 | 45235.0 |
| 1008 | 2025-11-21 12:53:24 | prospects | 1 | 81242 | 4 | 1.513 | 53696.0 |
| 1007 | 2025-11-21 02:00:18 | prospects | 1 | 81242 | 4 | 1.533 | 52995.4 |
| 1006 | 2025-11-19 05:10:43 | prospects | 2 | 121436 | 12 | 13.530 | 8975.3 |
| 1005 | 2025-11-17 21:18:19 | prospects | 1 | 81242 | 4 | 2.843 | 28576.2 |
| 1004 | 2025-11-09 06:02:55 | prospects | 1 | 81242 | 4 | 1.420 | 57212.7 |
| 1003 | 2025-11-08 19:13:31 | prospects | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 1002 | 2025-11-02 03:20:40 | prospects | 1 | 81242 | 4 | 2.000 | 40621.0 |
| 1001 | 2025-11-01 18:06:09 | prospects | 3 | 148641 | 63 | 27.533 | 5398.6 |
| 1000 | 2025-10-27 22:54:57 | prospects | 1 | 81242 | 4 | 1.563 | 51978.2 |
| 999 | 2025-10-26 02:51:15 | prospects | 3 | 148641 | 63 | 11.643 | 12766.6 |
| 998 | 2025-10-26 00:34:41 | prospects | 1 | 81242 | 4 | 1.533 | 52995.4 |
| 997 | 2025-10-25 01:58:58 | prospects | 1 | 81242 | 4 | 1.546 | 52549.8 |
| 996 | 2025-10-22 16:21:09 | prospects | 1 | 81242 | 4 | 3.610 | 22504.7 |
| 995 | 2025-10-21 23:30:42 | prospects | 1 | 81242 | 4 | 3.546 | 22910.9 |
| 994 | 2025-10-21 23:30:38 | prospects | 1 | 81242 | 4 | 6.936 | 11713.1 |
| 993 | 2025-10-21 23:30:31 | prospects | 1 | 81242 | 4 | 10.173 | 7986.0 |
| 992 | 2025-10-21 23:30:22 | prospects | 1 | 81242 | 4 | 6.236 | 13027.9 |
| 991 | 2025-10-21 11:20:15 | prospects | 4 | 165329 | 432 | 67.050 | 2465.8 |
| 990 | 2025-10-19 20:38:01 | prospects | 1 | 81242 | 4 | 5.346 | 15196.8 |
| 989 | 2025-10-19 18:37:05 | prospects | 1 | 81242 | 4 | 9.923 | 8187.2 |
| 988 | 2025-10-18 03:24:44 | prospects | 4 | 165329 | 432 | 10.906 | 15159.5 |
| 987 | 2025-10-17 13:45:12 | prospects | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 986 | 2025-10-16 14:25:28 | prospects | 1 | 81242 | 4 | 1.313 | 61875.1 |
| 985 | 2025-10-13 17:09:41 | prospects | 1 | 81242 | 4 | 1.326 | 61268.5 |
| 984 | 2025-10-13 17:09:40 | prospects | 1 | 81242 | 4 | 1.330 | 61084.2 |
| 983 | 2025-10-09 18:35:03 | prospects | 1 | 81242 | 4 | 2.670 | 30427.7 |
| 982 | 2025-10-06 12:41:25 | prospects | 4 | 165329 | 432 | 10.813 | 15289.8 |
| 981 | 2025-10-04 16:31:10 | prospects | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 980 | 2025-10-02 19:34:43 | prospects | 1 | 81242 | 4 | 1.266 | 64172.2 |
| 979 | 2025-10-02 08:58:34 | prospects | 4 | 165329 | 432 | 12.173 | 13581.6 |
| 978 | 2025-10-02 02:23:15 | prospects | 3 | 148641 | 63 | 7.300 | 20361.8 |
| 977 | 2025-09-27 11:57:58 | prospects | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 976 | 2025-09-27 02:05:01 | prospects | 1 | 81242 | 4 | 1.330 | 61084.2 |
| 975 | 2025-09-26 23:34:33 | prospects | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 974 | 2025-09-26 09:30:28 | prospects | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 973 | 2025-09-24 17:07:28 | prospects | 1 | 81242 | 4 | 1.420 | 57212.7 |
| 972 | 2025-09-19 23:45:01 | prospects | 3 | 148641 | 63 | 9.470 | 15696.0 |
| 971 | 2025-09-19 20:47:22 | prospects | 1 | 81242 | 4 | 1.610 | 50460.9 |
| 970 | 2025-09-19 01:31:14 | prospects | 2 | 121436 | 12 | 3.843 | 31599.3 |
| 969 | 2025-09-15 18:56:04 | prospects | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 968 | 2025-09-13 00:55:54 | prospects | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 967 | 2025-09-08 15:59:49 | prospects | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 966 | 2025-09-05 03:49:06 | prospects | 1 | 81242 | 4 | 1.360 | 59736.8 |
| 965 | 2025-09-02 17:48:40 | prospects | 1 | 81242 | 4 | 1.470 | 55266.7 |
| 964 | 2025-09-02 12:57:33 | prospects | 3 | 148641 | 63 | 6.406 | 23203.4 |
| 963 | 2025-08-29 05:53:55 | prospects | 3 | 148641 | 63 | 7.266 | 20457.1 |
| 962 | 2025-08-28 16:36:10 | prospects | 1 | 81242 | 4 | 1.313 | 61875.1 |
| 961 | 2025-08-27 08:32:30 | prospects | 1 | 81242 | 4 | 1.466 | 55417.5 |
| 960 | 2025-08-26 06:54:39 | prospects | 1 | 81242 | 4 | 6.406 | 12682.2 |
| 959 | 2025-08-24 00:08:00 | prospects | 2 | 121436 | 12 | 19.750 | 6148.7 |
| 958 | 2025-08-22 00:38:47 | prospects | 3 | 148641 | 63 | 24.076 | 6173.8 |
| 957 | 2025-08-19 17:36:49 | prospects | 3 | 148641 | 63 | 23.080 | 6440.3 |
| 956 | 2025-08-18 14:45:33 | prospects | 1 | 81242 | 4 | 1.266 | 64172.2 |
| 955 | 2025-08-17 00:31:41 | prospects | 3 | 148641 | 63 | 31.940 | 4653.8 |
| 954 | 2025-08-15 01:59:42 | prospects | 3 | 148641 | 63 | 36.653 | 4055.4 |
| 953 | 2025-08-14 02:52:48 | prospects | 1 | 81242 | 4 | 1.326 | 61268.5 |
| 952 | 2025-08-12 17:54:01 | prospects | 3 | 148641 | 63 | 19.206 | 7739.3 |
| 951 | 2025-08-10 03:05:01 | prospects | 3 | 148641 | 63 | 23.033 | 6453.4 |
| 950 | 2025-08-07 09:08:16 | prospects | 1 | 81242 | 4 | 7.156 | 11353.0 |
| 949 | 2025-08-06 10:04:23 | prospects | 4 | 165329 | 432 | 56.206 | 2941.5 |
| 948 | 2025-08-06 10:04:06 | prospects | 4 | 165329 | 432 | 54.766 | 3018.8 |
| 947 | 2025-08-06 02:54:19 | prospects | 3 | 148641 | 63 | 17.346 | 8569.2 |
| 946 | 2025-08-03 22:30:34 | prospects | 1 | 81242 | 4 | 3.563 | 22801.6 |
| 945 | 2025-08-03 22:30:22 | prospects | 2 | 121436 | 12 | 11.313 | 10734.2 |
| 944 | 2025-08-03 17:02:06 | prospects | 4 | 165329 | 432 | 51.876 | 3187.0 |
| 943 | 2025-08-03 03:36:40 | prospects | 3 | 148641 | 63 | 23.296 | 6380.5 |
| 942 | 2025-08-03 03:32:22 | prospects | 2 | 121436 | 12 | 18.536 | 6551.4 |
| 941 | 2025-08-01 11:59:10 | prospects | 1 | 81242 | 4 | 5.390 | 15072.7 |
| 940 | 2025-07-28 22:56:52 | prospects | 1 | 81242 | 4 | 3.356 | 24208.0 |
| 939 | 2025-07-26 16:22:07 | prospects | 2 | 121436 | 12 | 12.796 | 9490.2 |
| 938 | 2025-07-23 16:02:06 | prospects | 1 | 81242 | 4 | 7.860 | 10336.1 |
| 937 | 2025-07-23 10:01:11 | prospects | 1 | 81242 | 4 | 3.390 | 23965.2 |
| 936 | 2025-07-20 21:49:07 | prospects | 1 | 81242 | 4 | 1.330 | 61084.2 |
| 935 | 2025-07-16 10:53:22 | prospects | 2 | 121436 | 12 | 3.906 | 31089.6 |
| 934 | 2025-07-15 03:10:43 | prospects | 1 | 81242 | 4 | 7.016 | 11579.5 |
| 933 | 2025-07-12 19:22:02 | prospects | 1 | 81242 | 4 | 2.563 | 31698.0 |
| 932 | 2025-07-11 20:42:04 | prospects | 3 | 148641 | 63 | 21.973 | 6764.7 |
| 931 | 2025-07-08 15:13:21 | prospects | 3 | 148641 | 63 | 48.346 | 3074.5 |
| 930 | 2025-07-07 14:24:53 | prospects | 1 | 81242 | 4 | 5.250 | 15474.7 |
| 929 | 2025-07-06 19:18:06 | prospects | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 928 | 2025-07-05 14:54:27 | prospects | 3 | 148641 | 63 | 42.926 | 3462.7 |
| 927 | 2025-06-30 07:43:04 | prospects | 3 | 148641 | 63 | 37.733 | 3939.3 |
| 926 | 2025-06-29 11:47:44 | prospects | 1 | 81242 | 4 | 5.126 | 15849.0 |
| 925 | 2025-06-26 17:09:54 | prospects | 1 | 81242 | 4 | 5.233 | 15524.9 |
| 924 | 2025-06-22 09:23:11 | prospects | 1 | 81242 | 4 | 6.783 | 11977.3 |
| 923 | 2025-06-20 03:07:32 | prospects | 1 | 81242 | 4 | 10.080 | 8059.7 |
| 922 | 2025-06-16 14:01:46 | prospects | 1 | 81242 | 4 | 7.266 | 11181.1 |
| 921 | 2025-06-12 05:58:52 | prospects | 3 | 148641 | 63 | 35.160 | 4227.6 |
| 920 | 2025-06-11 15:00:12 | prospects | 1 | 81242 | 4 | 6.920 | 11740.2 |
| 919 | 2025-06-08 14:57:58 | prospects | 3 | 148641 | 63 | 49.893 | 2979.2 |
| 918 | 2025-06-08 12:10:45 | prospects | 2 | 121436 | 12 | 20.800 | 5838.3 |
| 917 | 2025-06-07 13:26:22 | prospects | 1 | 81242 | 4 | 5.216 | 15575.5 |
| 916 | 2025-06-02 17:40:29 | prospects | 3 | 148641 | 63 | 35.830 | 4148.5 |
| 915 | 2025-06-02 13:50:45 | prospects | 3 | 148641 | 63 | 28.083 | 5292.9 |
| 914 | 2025-05-29 22:57:00 | prospects | 3 | 148641 | 63 | 28.673 | 5184.0 |