History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pivot"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1030 | 2025-10-26 10:22:59 | pivot | 3 | 83667 | 701 | 3.313 | 25254.2 |
| 1029 | 2025-10-25 14:22:27 | pivot | 1 | 28756 | 6 | 0.530 | 54256.6 |
| 1028 | 2025-10-25 13:25:44 | pivot | 1 | 28756 | 6 | 0.516 | 55728.7 |
| 1027 | 2025-10-20 04:12:58 | pivot | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 1026 | 2025-10-07 20:15:02 | pivot | 1 | 28756 | 6 | 0.470 | 61183.0 |
| 1025 | 2025-09-28 04:54:47 | pivot | 3 | 83667 | 701 | 16.013 | 5224.9 |
| 1024 | 2025-09-28 04:54:24 | pivot | 3 | 83667 | 701 | 13.580 | 6161.0 |
| 1023 | 2025-09-28 04:53:44 | pivot | 3 | 83667 | 701 | 9.110 | 9184.1 |
| 1022 | 2025-09-28 04:52:39 | pivot | 3 | 83667 | 701 | 9.920 | 8434.2 |
| 1021 | 2025-09-27 18:01:32 | pivot | 3 | 83667 | 701 | 5.643 | 14826.7 |
| 1020 | 2025-09-23 12:24:47 | pivot | 3 | 83667 | 701 | 3.936 | 21256.9 |
| 1019 | 2025-09-20 20:22:10 | pivot | 2 | 53800 | 38 | 1.406 | 38264.6 |
| 1018 | 2025-09-10 16:45:39 | pivot | 1 | 28756 | 6 | 0.546 | 52666.7 |
| 1017 | 2025-09-07 09:29:14 | pivot | 1 | 28756 | 6 | 0.516 | 55728.7 |
| 1016 | 2025-08-24 19:16:57 | pivot | 1 | 28756 | 6 | 2.330 | 12341.6 |
| 1015 | 2025-08-24 06:38:14 | pivot | 1 | 28756 | 6 | 2.736 | 10510.2 |
| 1014 | 2025-08-17 07:35:43 | pivot | 1 | 28756 | 6 | 0.970 | 29645.4 |
| 1013 | 2025-08-09 18:55:52 | pivot | 1 | 28756 | 6 | 1.143 | 25158.4 |
| 1012 | 2025-08-08 11:28:44 | pivot | 1 | 28756 | 6 | 0.513 | 56054.6 |
| 1011 | 2025-08-04 18:54:16 | pivot | 1 | 28756 | 6 | 0.970 | 29645.4 |
| 1010 | 2025-08-04 02:09:03 | pivot | 1 | 28756 | 6 | 0.513 | 56054.6 |
| 1009 | 2025-08-03 01:49:41 | pivot | 3 | 83667 | 701 | 13.450 | 6220.6 |
| 1008 | 2025-08-03 01:48:23 | pivot | 2 | 53800 | 38 | 4.110 | 13090.0 |
| 1007 | 2025-08-01 18:01:59 | pivot | 2 | 53800 | 38 | 10.486 | 5130.7 |
| 1006 | 2025-08-01 02:53:27 | pivot | 1 | 28756 | 6 | 4.143 | 6940.9 |
| 1005 | 2025-07-31 15:14:44 | pivot | 1 | 28756 | 6 | 0.576 | 49923.6 |
| 1004 | 2025-07-31 14:22:29 | pivot | 1 | 28756 | 6 | 2.186 | 13154.6 |
| 1003 | 2025-07-23 22:30:17 | pivot | 1 | 28756 | 6 | 3.203 | 8977.8 |
| 1002 | 2025-07-23 15:54:48 | pivot | 1 | 28756 | 6 | 3.516 | 8178.6 |
| 1001 | 2025-07-23 12:16:59 | pivot | 1 | 28756 | 6 | 2.250 | 12780.4 |
| 1000 | 2025-07-23 03:21:51 | pivot | 1 | 28756 | 6 | 2.860 | 10054.5 |
| 999 | 2025-07-23 03:20:21 | pivot | 1 | 28756 | 6 | 0.953 | 30174.2 |
| 998 | 2025-07-23 00:18:54 | pivot | 1 | 28756 | 6 | 1.060 | 27128.3 |
| 997 | 2025-07-22 03:15:52 | pivot | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 996 | 2025-07-17 23:33:47 | pivot | 3 | 83667 | 701 | 18.483 | 4526.7 |
| 995 | 2025-07-17 12:18:30 | pivot | 1 | 28756 | 6 | 2.486 | 11567.2 |
| 994 | 2025-07-17 04:53:37 | pivot | 1 | 28756 | 6 | 1.733 | 16593.2 |
| 993 | 2025-07-16 23:58:51 | pivot | 3 | 83667 | 701 | 8.220 | 10178.5 |
| 992 | 2025-07-16 15:55:02 | pivot | 3 | 83667 | 701 | 5.013 | 16690.0 |
| 991 | 2025-07-16 05:21:04 | pivot | 1 | 28756 | 6 | 2.406 | 11951.8 |
| 990 | 2025-07-05 17:44:16 | pivot | 1 | 28756 | 6 | 3.656 | 7865.4 |
| 989 | 2025-07-04 02:14:37 | pivot | 1 | 28756 | 6 | 2.560 | 11232.8 |
| 988 | 2025-06-28 09:58:43 | pivot | 1 | 28756 | 6 | 1.173 | 24514.9 |
| 987 | 2025-06-20 21:34:32 | pivot | 1 | 28756 | 6 | 1.470 | 19561.9 |
| 986 | 2025-06-18 23:46:37 | pivot | 1 | 28756 | 6 | 2.460 | 11689.4 |
| 985 | 2025-06-11 08:27:32 | pivot | 1 | 28756 | 6 | 3.033 | 9481.0 |
| 984 | 2025-06-10 08:02:57 | pivot | 1 | 28756 | 6 | 1.423 | 20208.0 |
| 983 | 2025-06-08 10:36:33 | pivot | 3 | 83667 | 701 | 13.000 | 6435.9 |
| 982 | 2025-06-07 05:34:29 | pivot | 3 | 83667 | 701 | 5.233 | 15988.3 |
| 981 | 2025-06-04 11:48:00 | pivot | 3 | 83667 | 701 | 25.750 | 3249.2 |
| 980 | 2025-06-03 17:04:28 | pivot | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 979 | 2025-06-02 17:01:58 | pivot | 1 | 28756 | 6 | 3.673 | 7829.0 |
| 978 | 2025-06-02 05:04:45 | pivot | 3 | 83667 | 701 | 21.250 | 3937.3 |
| 977 | 2025-06-02 02:03:21 | pivot | 1 | 28756 | 6 | 3.186 | 9025.7 |
| 976 | 2025-06-01 22:34:35 | pivot | 2 | 53800 | 38 | 11.890 | 4524.8 |
| 975 | 2025-06-01 07:41:48 | pivot | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 974 | 2025-05-31 09:35:10 | pivot | 1 | 28756 | 6 | 1.190 | 24164.7 |
| 973 | 2025-05-28 21:51:32 | pivot | 1 | 28756 | 6 | 2.716 | 10587.6 |
| 972 | 2025-05-26 10:12:15 | pivot | 1 | 28756 | 6 | 2.326 | 12362.9 |
| 971 | 2025-05-22 19:18:20 | pivot | 2 | 53800 | 38 | 1.670 | 32215.6 |
| 970 | 2025-05-21 23:26:20 | pivot | 3 | 83667 | 701 | 22.110 | 3784.1 |
| 969 | 2025-05-20 19:49:57 | pivot | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 968 | 2025-05-20 02:23:33 | pivot | 1 | 28756 | 6 | 2.516 | 11429.3 |
| 967 | 2025-05-10 09:03:07 | pivot | 1 | 28756 | 6 | 1.313 | 21901.0 |
| 966 | 2025-05-07 13:40:36 | pivot | 1 | 28756 | 6 | 0.453 | 63479.0 |
| 965 | 2025-05-06 16:25:28 | pivot | 1 | 28756 | 6 | 1.233 | 23322.0 |
| 964 | 2025-05-02 17:00:09 | pivot | 1 | 28756 | 6 | 1.376 | 20898.3 |
| 963 | 2025-05-02 07:28:59 | pivot | 1 | 28756 | 6 | 2.250 | 12780.4 |
| 962 | 2025-04-20 01:07:40 | pivot | 1 | 28756 | 6 | 1.593 | 18051.5 |
| 961 | 2025-04-19 19:19:31 | pivot | 1 | 28756 | 6 | 0.966 | 29768.1 |
| 960 | 2025-03-31 18:44:47 | pivot | 1 | 28756 | 6 | 1.950 | 14746.7 |
| 959 | 2025-03-31 08:56:41 | pivot | 1 | 28756 | 6 | 1.280 | 22465.6 |
| 958 | 2025-03-31 03:37:31 | pivot | 1 | 28756 | 6 | 2.500 | 11502.4 |
| 957 | 2025-03-26 15:06:52 | pivot | 3 | 83667 | 701 | 11.926 | 7015.5 |
| 956 | 2025-03-22 07:49:51 | pivot | 3 | 83667 | 701 | 22.643 | 3695.0 |
| 955 | 2025-03-21 02:06:38 | pivot | 2 | 53800 | 38 | 11.360 | 4735.9 |
| 954 | 2025-03-21 00:50:02 | pivot | 3 | 83667 | 701 | 18.083 | 4626.8 |
| 953 | 2025-03-20 11:11:27 | pivot | 2 | 53800 | 38 | 4.390 | 12255.1 |
| 952 | 2025-03-19 21:17:28 | pivot | 3 | 83667 | 701 | 10.220 | 8186.6 |
| 951 | 2025-03-19 01:32:35 | pivot | 1 | 28756 | 6 | 0.483 | 59536.2 |
| 950 | 2025-03-18 20:28:06 | pivot | 1 | 28756 | 6 | 0.436 | 65954.1 |
| 949 | 2025-03-12 14:36:52 | pivot | 1 | 28756 | 6 | 0.483 | 59536.2 |
| 948 | 2025-03-10 03:25:00 | pivot | 1 | 28756 | 6 | 0.500 | 57512.0 |
| 947 | 2025-03-05 19:14:14 | pivot | 1 | 28756 | 6 | 0.513 | 56054.6 |
| 946 | 2025-03-01 09:02:35 | pivot | 1 | 28756 | 6 | 2.813 | 10222.5 |
| 945 | 2025-02-27 16:06:43 | pivot | 1 | 28756 | 6 | 2.876 | 9998.6 |
| 944 | 2025-02-27 16:02:02 | pivot | 3 | 83667 | 701 | 21.580 | 3877.1 |
| 943 | 2025-02-27 16:02:01 | pivot | 2 | 53800 | 38 | 10.406 | 5170.1 |
| 942 | 2025-02-27 14:55:45 | pivot | 3 | 83667 | 701 | 17.953 | 4660.3 |
| 941 | 2025-02-27 12:39:55 | pivot | 3 | 83667 | 701 | 14.126 | 5922.9 |
| 940 | 2025-02-27 12:39:55 | pivot | 2 | 53800 | 38 | 12.123 | 4437.8 |
| 939 | 2025-02-27 12:31:48 | pivot | 1 | 28756 | 6 | 0.513 | 56054.6 |
| 938 | 2025-02-07 19:27:21 | pivot | 1 | 28756 | 6 | 2.250 | 12780.4 |
| 937 | 2025-01-30 07:44:44 | pivot | 2 | 53800 | 38 | 8.093 | 6647.7 |
| 936 | 2025-01-30 07:43:50 | pivot | 1 | 28756 | 6 | 2.373 | 12118.0 |
| 935 | 2025-01-28 01:15:20 | pivot | 3 | 83667 | 701 | 21.406 | 3908.6 |
| 934 | 2025-01-28 01:15:21 | pivot | 2 | 53800 | 38 | 6.110 | 8805.2 |
| 933 | 2025-01-28 01:08:49 | pivot | 1 | 28756 | 6 | 0.513 | 56054.6 |
| 932 | 2025-01-27 17:21:22 | pivot | 1 | 28756 | 6 | 2.436 | 11804.6 |
| 931 | 2025-01-24 16:53:04 | pivot | 3 | 83667 | 701 | 17.110 | 4889.9 |