History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"top"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3110 | 2024-04-18 16:58:01 | top | 2 | 14084 | 476 | 1.360 | 10355.9 |
3109 | 2024-04-15 02:52:07 | top | 1 | 5146 | 34 | 0.200 | 25730.0 |
3108 | 2024-04-15 02:51:41 | top | 1 | 5146 | 34 | 0.233 | 22085.8 |
3107 | 2024-04-05 22:21:24 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3106 | 2024-04-02 17:42:12 | top | 1 | 5146 | 34 | 0.203 | 25349.8 |
3105 | 2024-03-30 18:10:37 | top | 1 | 5146 | 34 | 0.233 | 22085.8 |
3104 | 2024-03-04 05:21:27 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3103 | 2024-03-02 16:01:51 | top | 1 | 5146 | 34 | 0.173 | 29745.7 |
3102 | 2024-02-25 15:26:18 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3101 | 2024-02-01 10:50:23 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3100 | 2024-01-27 18:46:03 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3099 | 2024-01-24 17:32:52 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3098 | 2024-01-24 00:27:21 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3097 | 2024-01-21 02:23:28 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3096 | 2024-01-20 02:49:59 | top | 2 | 14084 | 476 | 0.330 | 42678.8 |
3095 | 2024-01-18 20:09:20 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3094 | 2024-01-17 22:28:16 | top | 2 | 14084 | 476 | 0.406 | 34689.7 |
3093 | 2024-01-13 23:53:54 | top | 2 | 14084 | 476 | 0.373 | 37758.7 |
3092 | 2024-01-12 23:34:25 | top | 2 | 14084 | 476 | 0.406 | 34689.7 |
3091 | 2024-01-11 23:34:08 | top | 2 | 14084 | 476 | 0.406 | 34689.7 |
3090 | 2024-01-10 23:33:01 | top | 2 | 14084 | 476 | 1.266 | 11124.8 |
3089 | 2024-01-09 23:28:06 | top | 2 | 14084 | 476 | 0.470 | 29966.0 |
3088 | 2024-01-09 17:36:12 | top | 2 | 14084 | 476 | 0.330 | 42678.8 |
3087 | 2024-01-08 22:34:52 | top | 2 | 14084 | 476 | 0.406 | 34689.7 |
3086 | 2024-01-06 01:16:16 | top | 2 | 14084 | 476 | 0.373 | 37758.7 |
3085 | 2023-12-27 17:24:37 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3084 | 2023-12-27 02:28:44 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3083 | 2023-12-26 18:09:23 | top | 2 | 14084 | 476 | 0.360 | 39122.2 |
3082 | 2023-12-26 02:01:08 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3081 | 2023-12-25 22:11:06 | top | 2 | 14084 | 476 | 0.406 | 34689.7 |
3080 | 2023-12-07 10:38:33 | top | 2 | 14084 | 476 | 0.813 | 17323.5 |
3079 | 2023-12-05 03:43:06 | top | 2 | 14084 | 476 | 0.360 | 39122.2 |
3078 | 2023-11-25 02:37:49 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3077 | 2023-11-24 04:16:36 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3076 | 2023-11-22 21:49:58 | top | 2 | 14084 | 476 | 0.356 | 39561.8 |
3075 | 2023-11-22 08:19:33 | top | 1 | 5146 | 34 | 0.203 | 25349.8 |
3074 | 2023-11-12 20:40:47 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3073 | 2023-11-11 17:33:36 | top | 2 | 14084 | 476 | 0.393 | 35837.2 |
3072 | 2023-11-10 23:06:21 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3071 | 2023-11-10 04:12:16 | top | 2 | 14084 | 476 | 0.376 | 37457.4 |
3070 | 2023-11-09 10:35:49 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3069 | 2023-11-08 11:26:30 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3068 | 2023-11-08 00:23:48 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3067 | 2023-11-07 11:59:14 | top | 1 | 5146 | 34 | 0.096 | 53604.2 |
3066 | 2023-11-07 11:59:14 | top | 1 | 5146 | 34 | 0.280 | 18378.6 |
3065 | 2023-11-07 10:33:40 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3064 | 2023-11-07 06:56:25 | top | 2 | 14084 | 476 | 0.326 | 43202.5 |
3063 | 2023-11-07 05:19:28 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3062 | 2023-11-06 19:58:14 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3061 | 2023-11-06 15:53:06 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3060 | 2023-11-05 14:58:53 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3059 | 2023-10-28 01:18:11 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3058 | 2023-10-27 19:27:12 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3057 | 2023-10-25 20:45:42 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3056 | 2023-10-23 16:17:39 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3055 | 2023-10-20 19:03:29 | top | 2 | 14084 | 476 | 0.500 | 28168.0 |
3054 | 2023-10-19 15:00:38 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3053 | 2023-10-17 23:38:10 | top | 2 | 14084 | 476 | 0.330 | 42678.8 |
3052 | 2023-10-16 19:00:21 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3051 | 2023-10-14 03:08:39 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3050 | 2023-10-14 03:08:15 | top | 1 | 5146 | 34 | 0.096 | 53604.2 |
3049 | 2023-10-14 02:50:54 | top | 2 | 14084 | 476 | 0.376 | 37457.4 |
3048 | 2023-10-14 02:49:57 | top | 2 | 14084 | 476 | 0.423 | 33295.5 |
3047 | 2023-10-12 23:43:10 | top | 2 | 14084 | 476 | 0.330 | 42678.8 |
3046 | 2023-10-11 02:56:50 | top | 2 | 14084 | 476 | 0.330 | 42678.8 |
3045 | 2023-10-09 22:42:22 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3044 | 2023-10-04 11:57:21 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3043 | 2023-10-03 08:59:56 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3042 | 2023-09-25 14:25:49 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3041 | 2023-09-23 12:51:45 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3040 | 2023-09-18 22:58:25 | top | 1 | 5146 | 34 | 0.093 | 55333.3 |
3039 | 2023-09-12 16:07:34 | top | 2 | 14084 | 476 | 0.393 | 35837.2 |
3038 | 2023-09-10 13:07:55 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3037 | 2023-09-04 06:28:40 | top | 2 | 14084 | 476 | 0.373 | 37758.7 |
3036 | 2023-08-21 03:09:45 | top | 2 | 14084 | 476 | 0.423 | 33295.5 |
3035 | 2023-08-10 15:00:43 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3034 | 2023-08-07 23:09:35 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3033 | 2023-08-05 07:30:34 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3032 | 2023-08-02 23:28:22 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3031 | 2023-07-28 16:33:23 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3030 | 2023-07-26 18:13:23 | top | 2 | 14084 | 476 | 0.376 | 37457.4 |
3029 | 2023-07-25 03:41:15 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3028 | 2023-07-25 00:04:06 | top | 2 | 14084 | 476 | 0.356 | 39561.8 |
3027 | 2023-07-23 10:14:49 | top | 1 | 5146 | 34 | 0.076 | 67710.5 |
3026 | 2023-07-21 10:24:03 | top | 2 | 14084 | 476 | 0.406 | 34689.7 |
3025 | 2023-07-20 23:27:08 | top | 2 | 14084 | 476 | 0.393 | 35837.2 |
3024 | 2023-07-19 23:03:44 | top | 2 | 14084 | 476 | 0.406 | 34689.7 |
3023 | 2023-07-18 19:37:46 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3022 | 2023-07-16 19:50:53 | top | 1 | 5146 | 34 | 0.080 | 64325.0 |
3021 | 2023-06-23 04:31:34 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3020 | 2023-06-15 11:43:20 | top | 2 | 14084 | 476 | 0.800 | 17605.0 |
3019 | 2023-06-14 14:33:16 | top | 2 | 14084 | 476 | 0.860 | 16376.7 |
3018 | 2023-06-13 07:27:59 | top | 2 | 14084 | 476 | 0.376 | 37457.4 |
3017 | 2023-06-12 21:48:59 | top | 2 | 14084 | 476 | 0.346 | 40705.2 |
3016 | 2023-06-12 17:53:42 | top | 2 | 14084 | 476 | 0.343 | 41061.2 |
3015 | 2023-06-11 11:41:36 | top | 2 | 14084 | 476 | 0.373 | 37758.7 |
3014 | 2023-06-10 20:14:21 | top | 2 | 14084 | 476 | 0.410 | 34351.2 |
3013 | 2023-06-09 11:55:44 | top | 2 | 14084 | 476 | 0.390 | 36112.8 |
3012 | 2023-06-08 15:57:48 | top | 2 | 14084 | 476 | 0.393 | 35837.2 |
3011 | 2023-06-07 13:07:29 | top | 2 | 14084 | 476 | 0.330 | 42678.8 |