History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pampa"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1024 | 2024-04-06 06:04:25 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1023 | 2024-04-02 22:23:47 | pampa | 2 | 53800 | 88 | 4.326 | 12436.4 |
| 1022 | 2024-04-02 18:46:12 | pampa | 3 | 83667 | 961 | 14.250 | 5871.4 |
| 1021 | 2024-03-31 18:29:02 | pampa | 3 | 83667 | 961 | 5.733 | 14593.9 |
| 1020 | 2024-03-31 18:29:03 | pampa | 2 | 53800 | 88 | 4.236 | 12700.7 |
| 1019 | 2024-03-31 18:28:57 | pampa | 1 | 28756 | 3 | 1.143 | 25158.4 |
| 1018 | 2024-03-31 18:28:40 | pampa | 3 | 83667 | 961 | 8.000 | 10458.4 |
| 1017 | 2024-03-31 18:28:38 | pampa | 2 | 53800 | 88 | 1.873 | 28724.0 |
| 1016 | 2024-03-31 18:28:25 | pampa | 1 | 28756 | 3 | 1.140 | 25224.6 |
| 1015 | 2024-03-29 17:59:33 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1014 | 2024-03-07 04:09:27 | pampa | 1 | 28756 | 3 | 0.703 | 40904.7 |
| 1013 | 2024-03-06 18:12:30 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1012 | 2024-03-01 12:33:06 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1011 | 2024-03-01 10:41:46 | pampa | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1010 | 2024-02-28 07:37:00 | pampa | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1009 | 2024-02-03 21:49:39 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1008 | 2024-01-29 04:42:37 | pampa | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1007 | 2024-01-29 03:55:47 | pampa | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1006 | 2024-01-28 15:49:13 | pampa | 3 | 83667 | 961 | 3.720 | 22491.1 |
| 1005 | 2024-01-26 02:06:27 | pampa | 2 | 53800 | 88 | 1.796 | 29955.5 |
| 1004 | 2024-01-17 16:57:35 | pampa | 3 | 83667 | 961 | 3.483 | 24021.5 |
| 1003 | 2024-01-08 01:47:14 | pampa | 2 | 53800 | 88 | 1.643 | 32745.0 |
| 1002 | 2024-01-04 13:31:00 | pampa | 3 | 83667 | 961 | 4.110 | 20356.9 |
| 1001 | 2024-01-04 13:31:01 | pampa | 2 | 53800 | 88 | 1.716 | 31352.0 |
| 1000 | 2023-12-24 01:59:18 | pampa | 2 | 53800 | 88 | 1.420 | 37887.3 |
| 999 | 2023-12-10 23:26:35 | pampa | 1 | 28756 | 3 | 0.560 | 51350.0 |
| 998 | 2023-12-06 21:59:59 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 997 | 2023-11-27 20:19:36 | pampa | 3 | 83667 | 961 | 3.580 | 23370.7 |
| 996 | 2023-11-25 16:45:54 | pampa | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 995 | 2023-11-21 08:59:11 | pampa | 3 | 83667 | 961 | 3.686 | 22698.6 |
| 994 | 2023-11-19 06:19:44 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 993 | 2023-11-16 00:45:47 | pampa | 3 | 83667 | 961 | 3.513 | 23816.4 |
| 992 | 2023-11-12 07:31:44 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 991 | 2023-11-09 16:33:40 | pampa | 3 | 83667 | 961 | 3.393 | 24658.7 |
| 990 | 2023-11-05 20:52:02 | pampa | 2 | 53800 | 88 | 1.686 | 31909.8 |
| 989 | 2023-11-05 18:53:56 | pampa | 3 | 83667 | 961 | 3.733 | 22412.8 |
| 988 | 2023-10-31 09:27:34 | pampa | 1 | 28756 | 3 | 1.080 | 26625.9 |
| 987 | 2023-10-31 03:51:12 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 986 | 2023-10-22 01:38:36 | pampa | 3 | 83667 | 961 | 7.016 | 11925.2 |
| 985 | 2023-10-19 04:31:13 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 984 | 2023-10-13 06:09:14 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 983 | 2023-10-05 18:01:34 | pampa | 1 | 28756 | 3 | 0.450 | 63902.2 |
| 982 | 2023-09-28 16:23:03 | pampa | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 981 | 2023-09-24 20:15:01 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 980 | 2023-09-13 12:44:22 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 979 | 2023-08-15 02:25:50 | pampa | 3 | 83667 | 961 | 3.936 | 21256.9 |
| 978 | 2023-08-11 06:24:46 | pampa | 3 | 83667 | 961 | 3.826 | 21868.0 |
| 977 | 2023-08-10 21:22:42 | pampa | 2 | 53800 | 88 | 1.483 | 36277.8 |
| 976 | 2023-08-02 04:29:51 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 975 | 2023-07-21 12:30:00 | pampa | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 974 | 2023-04-24 12:48:11 | pampa | 3 | 83667 | 961 | 3.266 | 25617.6 |
| 973 | 2023-04-23 09:03:54 | pampa | 2 | 53800 | 88 | 1.686 | 31909.8 |
| 972 | 2023-04-21 04:30:52 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 971 | 2023-04-13 18:37:24 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 970 | 2023-04-05 20:25:43 | pampa | 3 | 83667 | 961 | 3.250 | 25743.7 |
| 969 | 2023-04-05 18:53:44 | pampa | 3 | 83667 | 961 | 4.500 | 18592.7 |
| 968 | 2023-02-15 21:52:12 | pampa | 3 | 83667 | 961 | 6.920 | 12090.6 |
| 967 | 2023-02-12 04:22:07 | pampa | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 966 | 2023-02-05 12:06:16 | pampa | 3 | 83667 | 961 | 3.313 | 25254.2 |
| 965 | 2023-01-30 05:04:22 | pampa | 2 | 53800 | 88 | 1.576 | 34137.1 |
| 964 | 2023-01-28 23:04:08 | pampa | 3 | 83667 | 961 | 3.313 | 25254.2 |
| 963 | 2022-12-28 12:13:43 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 962 | 2022-12-09 12:44:59 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 961 | 2022-11-12 01:28:34 | pampa | 2 | 53800 | 88 | 1.423 | 37807.4 |
| 960 | 2022-11-10 16:52:38 | pampa | 3 | 83667 | 961 | 3.376 | 24782.9 |
| 959 | 2022-09-01 07:57:00 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 958 | 2022-08-23 13:44:54 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 957 | 2022-08-20 23:55:58 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 956 | 2022-08-10 17:11:39 | pampa | 1 | 28756 | 3 | 0.906 | 31739.5 |
| 955 | 2022-07-29 10:36:55 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 954 | 2022-05-31 02:13:33 | pampa | 3 | 83667 | 961 | 3.373 | 24804.9 |
| 953 | 2022-05-25 02:46:36 | pampa | 2 | 53800 | 88 | 1.453 | 37026.8 |
| 952 | 2022-05-23 04:47:21 | pampa | 3 | 83667 | 961 | 3.876 | 21585.9 |
| 951 | 2022-04-20 10:06:01 | pampa | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 950 | 2022-04-17 00:42:13 | pampa | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 949 | 2022-04-04 06:10:44 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 948 | 2022-04-02 01:10:19 | pampa | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 947 | 2022-01-30 23:16:09 | pampa | 1 | 28756 | 3 | 0.456 | 63061.4 |
| 946 | 2022-01-22 05:32:54 | pampa | 2 | 53800 | 88 | 1.450 | 37103.4 |
| 945 | 2022-01-18 16:19:48 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 944 | 2022-01-13 22:19:56 | pampa | 3 | 83667 | 961 | 4.203 | 19906.5 |
| 943 | 2021-12-25 20:28:30 | pampa | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 942 | 2021-12-02 18:06:40 | pampa | 3 | 83667 | 961 | 3.453 | 24230.2 |
| 941 | 2021-12-01 19:19:58 | pampa | 3 | 83667 | 961 | 4.186 | 19987.3 |
| 940 | 2021-11-30 23:22:53 | pampa | 3 | 83667 | 961 | 3.626 | 23074.2 |
| 939 | 2021-11-29 19:18:21 | pampa | 3 | 83667 | 961 | 3.593 | 23286.1 |
| 938 | 2021-09-14 08:11:38 | pampa | 3 | 83667 | 961 | 4.560 | 18348.0 |
| 937 | 2021-09-12 05:26:31 | pampa | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 936 | 2021-09-05 23:11:46 | pampa | 3 | 83667 | 961 | 3.406 | 24564.6 |
| 935 | 2021-09-03 06:23:40 | pampa | 3 | 83667 | 961 | 3.410 | 24535.8 |
| 934 | 2021-08-17 03:31:25 | pampa | 3 | 83667 | 961 | 4.123 | 20292.7 |
| 933 | 2021-08-11 07:12:23 | pampa | 3 | 83667 | 961 | 3.453 | 24230.2 |
| 932 | 2021-07-30 06:22:08 | pampa | 3 | 83667 | 961 | 3.810 | 21959.8 |
| 931 | 2021-07-29 04:29:25 | pampa | 3 | 83667 | 961 | 4.093 | 20441.5 |
| 930 | 2021-07-28 09:22:49 | pampa | 3 | 83667 | 961 | 3.296 | 25384.4 |
| 929 | 2021-07-27 23:25:11 | pampa | 3 | 83667 | 961 | 3.313 | 25254.2 |
| 928 | 2021-07-27 14:08:59 | pampa | 3 | 83667 | 961 | 3.983 | 21006.0 |
| 927 | 2021-07-27 03:39:34 | pampa | 3 | 83667 | 961 | 3.813 | 21942.6 |
| 926 | 2021-07-26 19:05:46 | pampa | 3 | 83667 | 961 | 3.953 | 21165.4 |
| 925 | 2021-07-26 05:02:44 | pampa | 3 | 83667 | 961 | 3.406 | 24564.6 |