History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sketched"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
219 | 2024-04-27 23:07:33 | sketched | 1 | 82945 | 3 | 4.326 | 19173.6 |
218 | 2024-04-20 22:41:23 | sketched | 2 | 121059 | 27 | 5.533 | 21879.5 |
217 | 2024-04-20 03:46:09 | sketched | 3 | 146162 | 165 | 9.423 | 15511.2 |
216 | 2024-04-14 16:15:06 | sketched | 3 | 146162 | 165 | 8.420 | 17358.9 |
215 | 2024-04-13 01:12:32 | sketched | 3 | 146162 | 165 | 7.923 | 18447.8 |
214 | 2024-04-13 01:12:36 | sketched | 2 | 121059 | 27 | 3.906 | 30993.1 |
213 | 2024-04-06 11:50:04 | sketched | 1 | 82945 | 3 | 4.576 | 18126.1 |
212 | 2024-04-05 03:10:05 | sketched | 1 | 82945 | 3 | 3.296 | 25165.4 |
211 | 2024-04-05 03:09:51 | sketched | 2 | 121059 | 27 | 7.780 | 15560.3 |
210 | 2024-04-03 09:52:56 | sketched | 2 | 121059 | 27 | 8.593 | 14088.1 |
209 | 2024-04-01 15:58:36 | sketched | 2 | 121059 | 27 | 11.640 | 10400.3 |
208 | 2024-04-01 15:58:30 | sketched | 3 | 146162 | 165 | 17.156 | 8519.6 |
207 | 2024-04-01 08:13:32 | sketched | 2 | 121059 | 27 | 12.810 | 9450.4 |
206 | 2024-04-01 08:13:30 | sketched | 3 | 146162 | 165 | 8.906 | 16411.6 |
205 | 2024-04-01 08:13:21 | sketched | 1 | 82945 | 3 | 4.030 | 20581.9 |
204 | 2024-03-31 14:01:39 | sketched | 1 | 82945 | 3 | 6.830 | 12144.2 |
203 | 2024-03-30 06:32:56 | sketched | 1 | 82945 | 3 | 3.860 | 21488.3 |
202 | 2024-03-11 04:56:52 | sketched | 3 | 146162 | 165 | 17.423 | 8389.0 |
201 | 2024-03-07 06:34:37 | sketched | 1 | 82945 | 3 | 3.280 | 25288.1 |
200 | 2024-03-06 13:10:26 | sketched | 3 | 146162 | 165 | 14.363 | 10176.3 |
199 | 2024-03-05 15:07:28 | sketched | 2 | 121059 | 27 | 3.300 | 36684.5 |
198 | 2024-03-05 03:48:14 | sketched | 3 | 146162 | 165 | 18.580 | 7866.6 |
197 | 2024-03-04 22:31:33 | sketched | 3 | 146162 | 165 | 16.546 | 8833.7 |
196 | 2024-03-02 04:06:29 | sketched | 2 | 121059 | 27 | 3.780 | 32026.2 |
195 | 2024-03-02 04:05:57 | sketched | 3 | 146162 | 165 | 8.576 | 17043.1 |
194 | 2024-03-01 17:53:56 | sketched | 3 | 146162 | 165 | 12.016 | 12163.9 |
193 | 2024-03-01 17:53:58 | sketched | 2 | 121059 | 27 | 4.296 | 28179.5 |
192 | 2024-03-01 17:53:51 | sketched | 1 | 82945 | 3 | 1.593 | 52068.4 |
191 | 2024-02-29 11:57:05 | sketched | 1 | 82945 | 3 | 1.436 | 57761.1 |
190 | 2024-02-22 01:09:36 | sketched | 2 | 121059 | 27 | 8.750 | 13835.3 |
189 | 2024-02-10 17:04:45 | sketched | 3 | 146162 | 165 | 16.440 | 8890.6 |
188 | 2024-02-09 21:40:57 | sketched | 2 | 121059 | 27 | 12.343 | 9807.9 |
187 | 2024-02-09 19:40:48 | sketched | 3 | 146162 | 165 | 7.720 | 18932.9 |
186 | 2024-02-07 14:53:30 | sketched | 2 | 121059 | 27 | 4.856 | 24929.8 |
185 | 2024-01-31 06:08:50 | sketched | 3 | 146162 | 165 | 8.970 | 16294.5 |
184 | 2024-01-31 06:08:10 | sketched | 2 | 121059 | 27 | 3.610 | 33534.3 |
183 | 2024-01-30 06:04:47 | sketched | 3 | 146162 | 165 | 7.610 | 19206.6 |
182 | 2024-01-30 06:04:43 | sketched | 2 | 121059 | 27 | 3.500 | 34588.3 |
181 | 2024-01-30 06:02:04 | sketched | 3 | 146162 | 165 | 7.720 | 18932.9 |
180 | 2024-01-20 05:49:59 | sketched | 3 | 146162 | 165 | 7.470 | 19566.5 |
179 | 2024-01-05 20:09:20 | sketched | 1 | 82945 | 3 | 1.313 | 63172.1 |
178 | 2023-12-30 05:14:39 | sketched | 3 | 146162 | 165 | 7.546 | 19369.5 |
177 | 2023-12-15 17:11:42 | sketched | 2 | 121059 | 27 | 3.766 | 32145.2 |
176 | 2023-12-03 16:10:24 | sketched | 1 | 82945 | 3 | 1.546 | 53651.4 |
175 | 2023-12-03 16:10:22 | sketched | 1 | 82945 | 3 | 1.513 | 54821.5 |
174 | 2023-11-22 23:35:42 | sketched | 1 | 82945 | 3 | 1.220 | 67987.7 |
173 | 2023-11-22 05:07:27 | sketched | 1 | 82945 | 3 | 1.420 | 58412.0 |
172 | 2023-11-19 13:38:53 | sketched | 2 | 121059 | 27 | 3.296 | 36729.1 |
171 | 2023-11-18 17:27:07 | sketched | 3 | 146162 | 165 | 8.063 | 18127.5 |
170 | 2023-11-09 19:28:14 | sketched | 1 | 82945 | 3 | 1.406 | 58993.6 |
169 | 2023-11-08 18:34:56 | sketched | 1 | 82945 | 3 | 1.393 | 59544.1 |
168 | 2023-10-31 12:27:27 | sketched | 3 | 146162 | 165 | 6.313 | 23152.5 |
167 | 2023-10-30 09:01:06 | sketched | 1 | 82945 | 3 | 1.283 | 64649.3 |
166 | 2023-10-20 07:00:14 | sketched | 1 | 82945 | 3 | 1.393 | 59544.1 |
165 | 2023-10-16 17:22:02 | sketched | 1 | 82945 | 3 | 1.343 | 61761.0 |
164 | 2023-09-29 21:27:59 | sketched | 1 | 82945 | 3 | 1.300 | 63803.8 |
163 | 2023-09-14 14:27:35 | sketched | 2 | 121059 | 27 | 3.656 | 33112.4 |
162 | 2023-08-23 06:40:35 | sketched | 1 | 82945 | 3 | 1.266 | 65517.4 |
161 | 2023-08-07 18:05:46 | sketched | 3 | 146162 | 165 | 6.190 | 23612.6 |
160 | 2023-07-10 21:45:57 | sketched | 1 | 82945 | 3 | 1.330 | 62364.7 |
159 | 2023-06-09 19:33:42 | sketched | 2 | 121059 | 27 | 3.080 | 39304.9 |
158 | 2023-05-27 09:50:55 | sketched | 1 | 82945 | 3 | 1.266 | 65517.4 |
157 | 2023-04-16 02:39:25 | sketched | 3 | 146162 | 165 | 6.033 | 24227.1 |
156 | 2023-03-21 21:40:18 | sketched | 1 | 82945 | 3 | 1.343 | 61761.0 |
155 | 2023-03-12 23:43:35 | sketched | 2 | 121059 | 27 | 3.076 | 39356.0 |
154 | 2023-03-06 23:23:35 | sketched | 1 | 82945 | 3 | 1.360 | 60989.0 |
153 | 2023-01-21 11:30:30 | sketched | 3 | 146162 | 165 | 6.080 | 24039.8 |
152 | 2023-01-06 20:03:14 | sketched | 1 | 82945 | 3 | 1.296 | 64000.8 |
151 | 2022-12-17 06:45:50 | sketched | 2 | 121059 | 27 | 3.046 | 39743.6 |
150 | 2022-11-02 14:14:08 | sketched | 3 | 146162 | 165 | 8.860 | 16496.8 |
149 | 2022-10-24 14:09:40 | sketched | 1 | 82945 | 3 | 1.250 | 66356.0 |
148 | 2022-10-20 23:53:42 | sketched | 1 | 82945 | 3 | 1.233 | 67270.9 |
147 | 2022-10-04 23:24:30 | sketched | 1 | 82945 | 3 | 1.420 | 58412.0 |
146 | 2022-08-10 11:52:22 | sketched | 2 | 121059 | 27 | 3.046 | 39743.6 |
145 | 2022-06-15 19:54:19 | sketched | 1 | 82945 | 3 | 1.296 | 64000.8 |
144 | 2022-06-04 07:44:21 | sketched | 3 | 146162 | 165 | 6.063 | 24107.2 |
143 | 2022-05-22 11:45:40 | sketched | 1 | 82945 | 3 | 1.296 | 64000.8 |
142 | 2022-05-16 12:58:35 | sketched | 1 | 82945 | 3 | 1.533 | 54106.3 |
141 | 2022-03-26 11:14:11 | sketched | 2 | 121059 | 27 | 3.186 | 37997.2 |
140 | 2022-02-08 04:10:35 | sketched | 1 | 82945 | 3 | 1.250 | 66356.0 |
139 | 2022-02-04 05:29:50 | sketched | 1 | 82945 | 3 | 1.343 | 61761.0 |
138 | 2021-11-29 21:06:18 | sketched | 1 | 82945 | 3 | 1.343 | 61761.0 |
137 | 2021-10-13 11:43:34 | sketched | 1 | 82945 | 3 | 1.313 | 63172.1 |
136 | 2021-10-08 09:29:14 | sketched | 1 | 82945 | 3 | 1.483 | 55930.5 |
135 | 2021-09-22 10:56:55 | sketched | 1 | 82945 | 3 | 1.483 | 55930.5 |
134 | 2021-07-29 14:12:19 | sketched | 3 | 146162 | 165 | 6.236 | 23438.4 |
133 | 2021-07-06 04:35:20 | sketched | 1 | 82945 | 3 | 1.576 | 52630.1 |
132 | 2021-07-02 15:59:50 | sketched | 1 | 82945 | 3 | 1.420 | 58412.0 |
131 | 2021-05-30 18:15:29 | sketched | 1 | 82945 | 3 | 1.326 | 62552.8 |
130 | 2021-05-05 11:09:01 | sketched | 1 | 82945 | 3 | 1.436 | 57761.1 |
129 | 2021-04-03 14:40:41 | sketched | 1 | 82945 | 3 | 1.250 | 66356.0 |
128 | 2021-03-28 19:21:32 | sketched | 1 | 82945 | 3 | 1.406 | 58993.6 |
127 | 2021-03-24 10:37:26 | sketched | 1 | 82945 | 3 | 1.296 | 64000.8 |
126 | 2021-02-22 06:43:03 | sketched | 1 | 82945 | 3 | 1.266 | 65517.4 |
125 | 2020-12-21 03:35:17 | sketched | 1 | 82945 | 3 | 1.296 | 64000.8 |
124 | 2020-11-13 01:36:59 | sketched | 1 | 82945 | 3 | 1.313 | 63172.1 |
123 | 2020-10-24 18:52:12 | sketched | 1 | 82945 | 3 | 1.406 | 58993.6 |
122 | 2020-09-17 05:08:23 | sketched | 1 | 82945 | 3 | 1.296 | 64000.8 |
121 | 2020-07-26 06:43:54 | sketched | 1 | 82945 | 3 | 1.500 | 55296.7 |
120 | 2020-06-01 10:48:43 | sketched | 1 | 82945 | 3 | 1.406 | 58993.6 |