History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"resample"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
270 | 2024-04-11 05:35:46 | resample | 3 | 146162 | 75 | 7.843 | 18636.0 |
269 | 2024-04-11 05:35:45 | resample | 2 | 121059 | 9 | 3.766 | 32145.2 |
268 | 2024-04-11 05:35:42 | resample | 1 | 82945 | 3 | 1.406 | 58993.6 |
267 | 2024-04-08 03:00:17 | resample | 4 | 161609 | 600 | 15.690 | 10300.1 |
266 | 2024-04-07 12:21:10 | resample | 3 | 146162 | 75 | 27.643 | 5287.5 |
265 | 2024-04-07 12:21:08 | resample | 2 | 121059 | 9 | 9.300 | 13017.1 |
264 | 2024-04-07 07:01:23 | resample | 3 | 146162 | 75 | 31.020 | 4711.9 |
263 | 2024-04-07 07:01:27 | resample | 2 | 121059 | 9 | 13.000 | 9312.2 |
262 | 2024-04-07 06:59:33 | resample | 1 | 82945 | 3 | 4.190 | 19795.9 |
261 | 2024-04-07 00:24:51 | resample | 4 | 161609 | 600 | 20.270 | 7972.8 |
260 | 2024-04-06 00:07:55 | resample | 4 | 161609 | 600 | 43.753 | 3693.7 |
259 | 2024-04-05 04:52:20 | resample | 4 | 161609 | 600 | 25.483 | 6341.8 |
258 | 2024-04-04 15:35:37 | resample | 3 | 146162 | 75 | 11.423 | 12795.4 |
257 | 2024-04-04 07:08:42 | resample | 4 | 161609 | 600 | 25.470 | 6345.1 |
256 | 2024-04-04 07:08:43 | resample | 3 | 146162 | 75 | 15.720 | 9297.8 |
255 | 2024-04-04 07:08:41 | resample | 2 | 121059 | 9 | 9.343 | 12957.2 |
254 | 2024-04-04 07:08:36 | resample | 1 | 82945 | 3 | 4.093 | 20265.1 |
253 | 2024-04-03 19:38:07 | resample | 1 | 82945 | 3 | 4.250 | 19516.5 |
252 | 2024-03-29 22:15:49 | resample | 1 | 82945 | 3 | 4.626 | 17930.2 |
251 | 2024-03-07 22:37:45 | resample | 3 | 146162 | 75 | 11.250 | 12992.2 |
250 | 2024-03-07 22:24:49 | resample | 3 | 146162 | 75 | 7.890 | 18525.0 |
249 | 2024-03-07 17:49:21 | resample | 4 | 161609 | 600 | 13.720 | 11779.1 |
248 | 2024-03-07 17:16:04 | resample | 3 | 146162 | 75 | 8.550 | 17095.0 |
247 | 2024-03-06 20:14:56 | resample | 4 | 161609 | 600 | 33.220 | 4864.8 |
246 | 2024-03-06 03:20:50 | resample | 4 | 161609 | 600 | 25.626 | 6306.4 |
245 | 2024-03-04 18:31:30 | resample | 3 | 146162 | 75 | 18.360 | 7960.9 |
244 | 2024-03-04 18:18:28 | resample | 4 | 161609 | 600 | 22.253 | 7262.3 |
243 | 2024-03-04 09:30:22 | resample | 4 | 161609 | 600 | 16.470 | 9812.3 |
242 | 2024-03-04 09:30:17 | resample | 3 | 146162 | 75 | 10.203 | 14325.4 |
241 | 2024-03-04 09:30:20 | resample | 1 | 82945 | 3 | 2.376 | 34909.5 |
240 | 2024-03-04 09:30:15 | resample | 2 | 121059 | 9 | 4.153 | 29149.8 |
239 | 2024-03-02 05:08:20 | resample | 3 | 146162 | 75 | 19.720 | 7411.9 |
238 | 2024-03-02 05:08:24 | resample | 2 | 121059 | 9 | 8.436 | 14350.3 |
237 | 2024-03-02 05:07:47 | resample | 1 | 82945 | 3 | 3.440 | 24111.9 |
236 | 2024-02-29 09:56:06 | resample | 1 | 82945 | 3 | 1.593 | 52068.4 |
235 | 2024-02-28 06:02:26 | resample | 1 | 82945 | 3 | 2.516 | 32967.0 |
234 | 2024-02-19 17:18:13 | resample | 1 | 82945 | 3 | 1.533 | 54106.3 |
233 | 2024-02-05 07:54:46 | resample | 2 | 121059 | 9 | 4.813 | 25152.5 |
232 | 2024-02-05 07:54:33 | resample | 3 | 146162 | 75 | 9.063 | 16127.3 |
231 | 2024-02-05 07:53:53 | resample | 4 | 161609 | 600 | 26.110 | 6189.5 |
230 | 2024-02-04 12:23:06 | resample | 4 | 161609 | 600 | 31.223 | 5176.0 |
229 | 2024-02-04 11:20:30 | resample | 3 | 146162 | 75 | 15.373 | 9507.7 |
228 | 2024-02-04 11:20:27 | resample | 2 | 121059 | 9 | 8.580 | 14109.4 |
227 | 2024-02-04 11:20:23 | resample | 1 | 82945 | 3 | 2.860 | 29001.7 |
226 | 2024-02-04 07:25:00 | resample | 4 | 161609 | 600 | 20.266 | 7974.4 |
225 | 2024-02-04 07:24:41 | resample | 3 | 146162 | 75 | 13.343 | 10954.2 |
224 | 2024-02-03 07:40:58 | resample | 1 | 82945 | 3 | 1.310 | 63316.8 |
223 | 2024-02-03 07:40:46 | resample | 4 | 161609 | 600 | 12.003 | 13464.1 |
222 | 2024-02-03 07:40:50 | resample | 2 | 121059 | 9 | 3.733 | 32429.4 |
221 | 2024-02-03 07:40:42 | resample | 3 | 146162 | 75 | 6.766 | 21602.4 |
220 | 2024-01-23 16:38:20 | resample | 1 | 82945 | 3 | 3.326 | 24938.4 |
219 | 2024-01-04 01:05:50 | resample | 1 | 82945 | 3 | 1.610 | 51518.6 |
218 | 2023-12-12 15:17:38 | resample | 1 | 82945 | 3 | 1.516 | 54713.1 |
217 | 2023-12-02 01:32:44 | resample | 1 | 82945 | 3 | 1.393 | 59544.1 |
216 | 2023-10-11 03:55:44 | resample | 1 | 82945 | 3 | 1.263 | 65673.0 |
215 | 2023-09-17 15:50:02 | resample | 1 | 82945 | 3 | 3.093 | 26817.0 |
214 | 2023-07-01 23:20:35 | resample | 1 | 82945 | 3 | 1.296 | 64000.8 |
213 | 2023-04-13 03:09:59 | resample | 1 | 82945 | 3 | 1.500 | 55296.7 |
212 | 2023-04-11 07:11:38 | resample | 1 | 82945 | 3 | 1.436 | 57761.1 |
211 | 2023-02-16 00:57:49 | resample | 1 | 82945 | 3 | 1.296 | 64000.8 |
210 | 2023-02-06 03:31:16 | resample | 1 | 82945 | 3 | 1.296 | 64000.8 |
209 | 2022-12-27 14:29:17 | resample | 1 | 82945 | 3 | 1.296 | 64000.8 |
208 | 2022-12-04 16:36:29 | resample | 1 | 82945 | 3 | 1.296 | 64000.8 |
207 | 2022-11-12 19:01:05 | resample | 1 | 82945 | 3 | 1.420 | 58412.0 |
206 | 2022-09-03 17:50:00 | resample | 1 | 82945 | 3 | 1.313 | 63172.1 |
205 | 2022-08-15 20:11:30 | resample | 1 | 82945 | 3 | 1.453 | 57085.3 |
204 | 2022-08-10 16:08:19 | resample | 1 | 82945 | 3 | 1.313 | 63172.1 |
203 | 2022-08-03 00:03:00 | resample | 1 | 82945 | 3 | 1.453 | 57085.3 |
202 | 2022-08-01 16:46:11 | resample | 1 | 82945 | 3 | 1.580 | 52496.8 |
201 | 2022-07-25 05:23:25 | resample | 1 | 82945 | 3 | 1.453 | 57085.3 |
200 | 2022-07-18 12:26:38 | resample | 1 | 82945 | 3 | 1.436 | 57761.1 |
199 | 2022-07-15 22:48:07 | resample | 1 | 82945 | 3 | 1.330 | 62364.7 |
198 | 2022-07-03 14:33:01 | resample | 1 | 82945 | 3 | 1.296 | 64000.8 |
197 | 2022-06-17 04:32:04 | resample | 1 | 82945 | 3 | 1.436 | 57761.1 |
196 | 2022-06-04 03:57:24 | resample | 1 | 82945 | 3 | 1.280 | 64800.8 |
195 | 2021-04-12 16:37:23 | resample | 1 | 82945 | 3 | 1.326 | 62552.8 |
194 | 2020-12-01 04:28:50 | resample | 1 | 82945 | 3 | 1.406 | 58993.6 |
193 | 2020-11-09 15:15:20 | resample | 1 | 82945 | 3 | 1.343 | 61761.0 |
192 | 2020-11-06 17:00:09 | resample | 1 | 82945 | 3 | 1.406 | 58993.6 |
191 | 2020-10-14 17:06:19 | resample | 1 | 82945 | 3 | 1.360 | 60989.0 |
190 | 2020-03-29 12:19:23 | resample | 4 | 161609 | 600 | 13.233 | 12212.6 |
189 | 2020-03-28 18:01:37 | resample | 4 | 161609 | 600 | 22.643 | 7137.3 |
188 | 2020-03-28 13:25:03 | resample | 1 | 82945 | 3 | 1.436 | 57761.1 |
187 | 2020-03-28 04:57:20 | resample | 4 | 161609 | 600 | 14.373 | 11243.9 |
186 | 2020-03-27 15:17:16 | resample | 4 | 161609 | 600 | 14.453 | 11181.7 |
185 | 2020-03-21 07:23:37 | resample | 1 | 82945 | 3 | 1.343 | 61761.0 |
184 | 2020-03-15 23:22:58 | resample | 1 | 82945 | 3 | 1.453 | 57085.3 |
183 | 2020-03-14 07:39:33 | resample | 1 | 82945 | 3 | 1.300 | 63803.8 |
182 | 2020-03-01 10:33:34 | resample | 4 | 161609 | 600 | 14.800 | 10919.5 |
181 | 2020-03-01 10:21:30 | resample | 1 | 82945 | 3 | 1.593 | 52068.4 |
180 | 2020-03-01 01:38:32 | resample | 1 | 82945 | 3 | 1.576 | 52630.1 |
179 | 2020-03-01 01:38:09 | resample | 1 | 82945 | 3 | 1.580 | 52496.8 |
178 | 2020-02-29 23:21:30 | resample | 1 | 82945 | 3 | 2.046 | 40540.1 |
177 | 2020-02-26 22:26:23 | resample | 1 | 82945 | 3 | 1.606 | 51646.9 |
176 | 2020-02-13 00:24:40 | resample | 4 | 161609 | 600 | 12.126 | 13327.5 |
175 | 2020-02-07 20:38:19 | resample | 4 | 161609 | 600 | 14.516 | 11133.2 |
174 | 2020-02-07 17:28:48 | resample | 4 | 161609 | 600 | 37.393 | 4321.9 |
173 | 2020-02-04 06:29:57 | resample | 2 | 121059 | 9 | 6.763 | 17900.2 |
172 | 2020-02-04 03:48:32 | resample | 4 | 161609 | 600 | 14.016 | 11530.3 |
171 | 2020-02-04 01:42:18 | resample | 4 | 161609 | 600 | 33.643 | 4803.6 |