History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preplans"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
293 | 2024-04-07 10:40:52 | preplans | 1 | 82945 | 4 | 1.843 | 45005.4 |
292 | 2024-04-02 12:36:33 | preplans | 1 | 82945 | 4 | 1.373 | 60411.5 |
291 | 2024-03-29 05:41:00 | preplans | 1 | 82945 | 4 | 4.626 | 17930.2 |
290 | 2024-02-28 14:24:52 | preplans | 1 | 82945 | 4 | 1.626 | 51011.7 |
289 | 2024-02-28 01:51:45 | preplans | 2 | 121059 | 16 | 4.203 | 28803.0 |
288 | 2024-02-26 12:32:23 | preplans | 1 | 82945 | 4 | 1.656 | 50087.6 |
287 | 2024-02-09 21:38:19 | preplans | 2 | 121059 | 16 | 6.940 | 17443.7 |
286 | 2024-02-09 19:48:26 | preplans | 3 | 146162 | 150 | 8.420 | 17358.9 |
285 | 2024-02-05 13:08:14 | preplans | 3 | 146162 | 150 | 14.470 | 10101.0 |
284 | 2024-01-31 03:03:38 | preplans | 3 | 146162 | 150 | 11.750 | 12439.3 |
283 | 2024-01-31 02:09:59 | preplans | 2 | 121059 | 16 | 3.390 | 35710.6 |
282 | 2024-01-31 02:09:08 | preplans | 3 | 146162 | 150 | 9.173 | 15933.9 |
281 | 2024-01-29 17:17:35 | preplans | 2 | 121059 | 16 | 3.936 | 30756.9 |
280 | 2024-01-29 17:17:31 | preplans | 3 | 146162 | 150 | 7.360 | 19859.0 |
279 | 2024-01-29 17:17:27 | preplans | 1 | 82945 | 4 | 1.266 | 65517.4 |
278 | 2024-01-26 01:12:29 | preplans | 1 | 82945 | 4 | 1.483 | 55930.5 |
277 | 2023-12-27 04:31:31 | preplans | 1 | 82945 | 4 | 1.346 | 61623.3 |
276 | 2023-12-14 15:35:49 | preplans | 1 | 82945 | 4 | 1.546 | 53651.4 |
275 | 2023-12-14 10:41:10 | preplans | 2 | 121059 | 16 | 3.423 | 35366.3 |
274 | 2023-12-11 11:38:18 | preplans | 2 | 121059 | 16 | 3.190 | 37949.5 |
273 | 2023-12-10 10:03:53 | preplans | 3 | 146162 | 150 | 8.343 | 17519.1 |
272 | 2023-12-09 07:36:03 | preplans | 1 | 82945 | 4 | 1.440 | 57600.7 |
271 | 2023-11-21 07:32:38 | preplans | 3 | 146162 | 150 | 7.763 | 18828.0 |
270 | 2023-11-11 12:51:31 | preplans | 1 | 82945 | 4 | 1.440 | 57600.7 |
269 | 2023-11-11 00:29:21 | preplans | 1 | 82945 | 4 | 1.343 | 61761.0 |
268 | 2023-11-09 00:46:28 | preplans | 2 | 121059 | 16 | 5.080 | 23830.5 |
267 | 2023-11-09 00:46:15 | preplans | 3 | 146162 | 150 | 6.860 | 21306.4 |
266 | 2023-11-02 13:02:43 | preplans | 1 | 82945 | 4 | 1.483 | 55930.5 |
265 | 2023-10-26 13:59:51 | preplans | 1 | 82945 | 4 | 1.466 | 56579.1 |
264 | 2023-10-17 22:03:32 | preplans | 1 | 82945 | 4 | 1.576 | 52630.1 |
263 | 2023-10-16 03:07:23 | preplans | 1 | 82945 | 4 | 1.546 | 53651.4 |
262 | 2023-10-06 22:16:17 | preplans | 1 | 82945 | 4 | 1.266 | 65517.4 |
261 | 2023-09-18 21:42:17 | preplans | 1 | 82945 | 4 | 1.330 | 62364.7 |
260 | 2023-09-13 03:02:27 | preplans | 2 | 121059 | 16 | 3.733 | 32429.4 |
259 | 2023-08-12 16:59:14 | preplans | 1 | 82945 | 4 | 1.516 | 54713.1 |
258 | 2023-07-20 18:45:46 | preplans | 1 | 82945 | 4 | 1.263 | 65673.0 |
257 | 2023-06-12 06:18:03 | preplans | 2 | 121059 | 16 | 3.813 | 31749.0 |
256 | 2023-05-15 11:28:08 | preplans | 1 | 82945 | 4 | 1.296 | 64000.8 |
255 | 2023-04-01 18:10:14 | preplans | 1 | 82945 | 4 | 1.280 | 64800.8 |
254 | 2023-03-13 21:08:51 | preplans | 1 | 82945 | 4 | 1.263 | 65673.0 |
253 | 2023-03-12 14:09:50 | preplans | 2 | 121059 | 16 | 3.640 | 33258.0 |
252 | 2023-01-03 05:00:07 | preplans | 1 | 82945 | 4 | 1.423 | 58288.8 |
251 | 2022-12-16 21:12:01 | preplans | 1 | 82945 | 4 | 1.406 | 58993.6 |
250 | 2022-12-15 10:42:50 | preplans | 2 | 121059 | 16 | 3.576 | 33853.2 |
249 | 2022-12-13 16:42:34 | preplans | 1 | 82945 | 4 | 1.436 | 57761.1 |
248 | 2022-09-26 00:05:07 | preplans | 1 | 82945 | 4 | 1.423 | 58288.8 |
247 | 2022-08-20 02:33:32 | preplans | 1 | 82945 | 4 | 1.280 | 64800.8 |
246 | 2022-08-05 07:46:30 | preplans | 2 | 121059 | 16 | 3.203 | 37795.5 |
245 | 2022-08-02 23:04:25 | preplans | 2 | 121059 | 16 | 3.203 | 37795.5 |
244 | 2022-05-09 13:28:53 | preplans | 1 | 82945 | 4 | 1.923 | 43133.1 |
243 | 2022-05-07 09:21:20 | preplans | 1 | 82945 | 4 | 1.296 | 64000.8 |
242 | 2022-04-19 13:48:20 | preplans | 1 | 82945 | 4 | 1.530 | 54212.4 |
241 | 2022-01-24 05:05:31 | preplans | 1 | 82945 | 4 | 1.470 | 56425.2 |
240 | 2022-01-22 01:51:28 | preplans | 1 | 82945 | 4 | 1.310 | 63316.8 |
239 | 2022-01-06 18:49:37 | preplans | 1 | 82945 | 4 | 1.610 | 51518.6 |
238 | 2021-11-26 21:38:52 | preplans | 1 | 82945 | 4 | 1.423 | 58288.8 |
237 | 2021-11-25 14:12:35 | preplans | 1 | 82945 | 4 | 1.516 | 54713.1 |
236 | 2021-09-30 14:55:54 | preplans | 1 | 82945 | 4 | 1.483 | 55930.5 |
235 | 2021-09-20 00:25:19 | preplans | 1 | 82945 | 4 | 1.830 | 45325.1 |
234 | 2021-09-18 19:41:41 | preplans | 1 | 82945 | 4 | 1.313 | 63172.1 |
233 | 2021-09-11 20:14:03 | preplans | 1 | 82945 | 4 | 1.436 | 57761.1 |
232 | 2021-07-01 05:36:15 | preplans | 1 | 82945 | 4 | 1.330 | 62364.7 |
231 | 2021-04-06 05:53:57 | preplans | 1 | 82945 | 4 | 1.516 | 54713.1 |
230 | 2021-03-31 06:15:43 | preplans | 1 | 82945 | 4 | 1.466 | 56579.1 |
229 | 2021-02-22 12:26:36 | preplans | 1 | 82945 | 4 | 1.440 | 57600.7 |
228 | 2021-02-03 12:20:56 | preplans | 1 | 82945 | 4 | 1.313 | 63172.1 |
227 | 2020-12-26 19:17:15 | preplans | 1 | 82945 | 4 | 1.296 | 64000.8 |
226 | 2020-12-22 06:53:34 | preplans | 1 | 82945 | 4 | 1.296 | 64000.8 |
225 | 2020-11-03 17:52:59 | preplans | 1 | 82945 | 4 | 1.466 | 56579.1 |
224 | 2020-10-15 07:04:21 | preplans | 1 | 82945 | 4 | 1.453 | 57085.3 |
223 | 2020-09-23 03:03:45 | preplans | 1 | 82945 | 4 | 1.343 | 61761.0 |
222 | 2020-09-15 07:39:59 | preplans | 1 | 82945 | 4 | 1.393 | 59544.1 |
221 | 2020-09-01 17:27:13 | preplans | 1 | 82945 | 4 | 1.393 | 59544.1 |
220 | 2020-08-28 22:46:53 | preplans | 1 | 82945 | 4 | 1.310 | 63316.8 |
219 | 2020-06-12 02:45:27 | preplans | 1 | 82945 | 4 | 1.313 | 63172.1 |
218 | 2020-06-09 03:03:04 | preplans | 1 | 82945 | 4 | 1.373 | 60411.5 |
217 | 2020-03-29 18:13:34 | preplans | 1 | 82945 | 4 | 1.483 | 55930.5 |
216 | 2020-03-25 16:17:46 | preplans | 1 | 82945 | 4 | 1.423 | 58288.8 |
215 | 2020-03-24 17:18:33 | preplans | 1 | 82945 | 4 | 1.576 | 52630.1 |
214 | 2020-03-21 03:00:40 | preplans | 1 | 82945 | 4 | 2.593 | 31988.0 |
213 | 2020-03-01 19:26:59 | preplans | 1 | 82945 | 4 | 1.500 | 55296.7 |
212 | 2020-02-29 18:42:50 | preplans | 1 | 82945 | 4 | 1.700 | 48791.2 |
211 | 2020-02-29 11:39:07 | preplans | 1 | 82945 | 4 | 2.750 | 30161.8 |
210 | 2020-02-29 09:26:40 | preplans | 1 | 82945 | 4 | 1.610 | 51518.6 |
209 | 2020-02-22 11:50:43 | preplans | 1 | 82945 | 4 | 2.390 | 34705.0 |
208 | 2020-02-17 22:03:00 | preplans | 1 | 82945 | 4 | 3.190 | 26001.6 |
207 | 2020-02-08 09:13:20 | preplans | 1 | 82945 | 4 | 1.656 | 50087.6 |
206 | 2020-02-05 13:58:55 | preplans | 1 | 82945 | 4 | 1.670 | 49667.7 |
205 | 2020-02-05 01:15:40 | preplans | 1 | 82945 | 4 | 1.720 | 48223.8 |
204 | 2020-02-01 13:10:17 | preplans | 1 | 82945 | 4 | 3.393 | 24445.9 |
203 | 2020-01-25 03:58:23 | preplans | 1 | 82945 | 4 | 3.643 | 22768.3 |
202 | 2020-01-24 02:41:04 | preplans | 1 | 82945 | 4 | 5.110 | 16231.9 |
201 | 2020-01-17 16:16:37 | preplans | 2 | 121059 | 16 | 5.233 | 23133.8 |
200 | 2020-01-17 02:10:53 | preplans | 2 | 121059 | 16 | 3.830 | 31608.1 |
199 | 2020-01-16 20:55:24 | preplans | 1 | 82945 | 4 | 2.656 | 31229.3 |
198 | 2020-01-14 01:30:45 | preplans | 1 | 82945 | 4 | 3.173 | 26140.9 |
197 | 2020-01-08 08:28:48 | preplans | 1 | 82945 | 4 | 3.190 | 26001.6 |
196 | 2020-01-06 18:55:58 | preplans | 1 | 82945 | 4 | 2.890 | 28700.7 |
195 | 2020-01-02 04:50:04 | preplans | 1 | 82945 | 4 | 2.376 | 34909.5 |
194 | 2019-12-28 17:16:02 | preplans | 1 | 82945 | 4 | 1.343 | 61761.0 |