History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pedro"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
336 | 2024-05-02 01:18:09 | pedro | 1 | 28756 | 2 | 0.593 | 48492.4 |
335 | 2024-04-30 21:54:35 | pedro | 1 | 28756 | 2 | 1.076 | 26724.9 |
334 | 2024-04-30 14:23:21 | pedro | 1 | 28756 | 2 | 0.516 | 55728.7 |
333 | 2024-04-29 04:59:24 | pedro | 2 | 53800 | 51 | 3.406 | 15795.7 |
332 | 2024-04-29 04:58:54 | pedro | 1 | 28756 | 2 | 0.516 | 55728.7 |
331 | 2024-04-29 04:57:59 | pedro | 3 | 83667 | 714 | 3.970 | 21074.8 |
330 | 2024-04-28 23:29:32 | pedro | 3 | 83667 | 714 | 3.953 | 21165.4 |
329 | 2024-04-28 21:06:14 | pedro | 1 | 28756 | 2 | 0.483 | 59536.2 |
328 | 2024-04-27 20:39:50 | pedro | 3 | 83667 | 714 | 8.140 | 10278.5 |
327 | 2024-04-25 18:41:12 | pedro | 3 | 83667 | 714 | 5.580 | 14994.1 |
326 | 2024-04-19 03:13:16 | pedro | 1 | 28756 | 2 | 0.563 | 51076.4 |
325 | 2024-04-03 10:25:16 | pedro | 3 | 83667 | 714 | 9.313 | 8983.9 |
324 | 2024-04-03 10:25:15 | pedro | 2 | 53800 | 51 | 4.186 | 12852.4 |
323 | 2024-04-03 08:44:41 | pedro | 1 | 28756 | 2 | 0.436 | 65954.1 |
322 | 2024-03-31 15:41:57 | pedro | 1 | 28756 | 2 | 0.516 | 55728.7 |
321 | 2024-03-29 09:20:26 | pedro | 1 | 28756 | 2 | 0.500 | 57512.0 |
320 | 2024-03-05 06:03:56 | pedro | 3 | 83667 | 714 | 3.623 | 23093.3 |
319 | 2024-03-04 00:03:00 | pedro | 1 | 28756 | 2 | 0.500 | 57512.0 |
318 | 2024-03-01 14:08:13 | pedro | 3 | 83667 | 714 | 3.436 | 24350.1 |
317 | 2024-03-01 14:08:11 | pedro | 2 | 53800 | 51 | 1.563 | 34421.0 |
316 | 2024-03-01 14:08:07 | pedro | 1 | 28756 | 2 | 0.483 | 59536.2 |
315 | 2024-02-28 07:47:48 | pedro | 1 | 28756 | 2 | 0.486 | 59168.7 |
314 | 2024-01-29 17:02:21 | pedro | 3 | 83667 | 714 | 3.766 | 22216.4 |
313 | 2024-01-29 04:48:47 | pedro | 1 | 28756 | 2 | 0.486 | 59168.7 |
312 | 2024-01-29 03:48:29 | pedro | 1 | 28756 | 2 | 0.440 | 65354.5 |
311 | 2024-01-27 23:37:36 | pedro | 3 | 83667 | 714 | 3.860 | 21675.4 |
310 | 2024-01-19 12:22:45 | pedro | 3 | 83667 | 714 | 3.610 | 23176.5 |
309 | 2024-01-16 15:02:19 | pedro | 3 | 83667 | 714 | 6.736 | 12420.9 |
308 | 2024-01-16 15:02:18 | pedro | 2 | 53800 | 51 | 1.563 | 34421.0 |
307 | 2024-01-13 19:47:46 | pedro | 1 | 28756 | 2 | 0.470 | 61183.0 |
306 | 2024-01-12 07:32:02 | pedro | 1 | 28756 | 2 | 0.470 | 61183.0 |
305 | 2024-01-08 23:26:41 | pedro | 2 | 53800 | 51 | 1.373 | 39184.3 |
304 | 2023-12-31 21:10:45 | pedro | 1 | 28756 | 2 | 0.500 | 57512.0 |
303 | 2023-12-30 14:09:13 | pedro | 3 | 83667 | 714 | 3.546 | 23594.8 |
302 | 2023-12-17 06:24:04 | pedro | 3 | 83667 | 714 | 3.546 | 23594.8 |
301 | 2023-12-17 06:24:01 | pedro | 2 | 53800 | 51 | 1.720 | 31279.1 |
300 | 2023-11-23 15:15:04 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
299 | 2023-11-17 22:55:49 | pedro | 1 | 28756 | 2 | 0.513 | 56054.6 |
298 | 2023-11-11 13:58:44 | pedro | 1 | 28756 | 2 | 0.513 | 56054.6 |
297 | 2023-11-05 03:33:15 | pedro | 1 | 28756 | 2 | 0.486 | 59168.7 |
296 | 2023-11-04 23:59:12 | pedro | 1 | 28756 | 2 | 0.516 | 55728.7 |
295 | 2023-10-30 14:50:01 | pedro | 3 | 83667 | 714 | 7.376 | 11343.1 |
294 | 2023-10-24 04:37:32 | pedro | 1 | 28756 | 2 | 0.436 | 65954.1 |
293 | 2023-10-22 11:57:57 | pedro | 1 | 28756 | 2 | 0.440 | 65354.5 |
292 | 2023-10-15 14:09:35 | pedro | 2 | 53800 | 51 | 1.440 | 37361.1 |
291 | 2023-10-11 14:22:10 | pedro | 1 | 28756 | 2 | 0.440 | 65354.5 |
290 | 2023-10-04 04:02:43 | pedro | 1 | 28756 | 2 | 0.546 | 52666.7 |
289 | 2023-09-29 05:16:59 | pedro | 1 | 28756 | 2 | 0.516 | 55728.7 |
288 | 2023-09-22 07:35:01 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
287 | 2023-09-05 20:04:43 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
286 | 2023-08-16 19:52:44 | pedro | 1 | 28756 | 2 | 0.436 | 65954.1 |
285 | 2023-08-06 18:16:19 | pedro | 3 | 83667 | 714 | 3.250 | 25743.7 |
284 | 2023-07-26 14:58:14 | pedro | 2 | 53800 | 51 | 1.516 | 35488.1 |
283 | 2023-05-21 11:29:41 | pedro | 1 | 28756 | 2 | 0.500 | 57512.0 |
282 | 2023-05-09 10:57:20 | pedro | 1 | 28756 | 2 | 0.466 | 61708.2 |
281 | 2023-04-19 12:49:13 | pedro | 3 | 83667 | 714 | 3.250 | 25743.7 |
280 | 2023-04-07 02:50:15 | pedro | 2 | 53800 | 51 | 1.360 | 39558.8 |
279 | 2023-03-17 03:22:13 | pedro | 1 | 28756 | 2 | 0.486 | 59168.7 |
278 | 2023-01-20 19:33:05 | pedro | 3 | 83667 | 714 | 3.200 | 26145.9 |
277 | 2023-01-16 02:19:01 | pedro | 1 | 28756 | 2 | 0.436 | 65954.1 |
276 | 2023-01-05 10:34:07 | pedro | 1 | 28756 | 2 | 0.436 | 65954.1 |
275 | 2023-01-03 08:35:37 | pedro | 2 | 53800 | 51 | 1.546 | 34799.5 |
274 | 2022-12-15 01:27:06 | pedro | 3 | 83667 | 714 | 3.783 | 22116.6 |
273 | 2022-11-29 20:21:42 | pedro | 3 | 83667 | 714 | 3.610 | 23176.5 |
272 | 2022-11-14 07:30:28 | pedro | 3 | 83667 | 714 | 3.703 | 22594.4 |
271 | 2022-11-10 12:05:27 | pedro | 3 | 83667 | 714 | 3.626 | 23074.2 |
270 | 2022-10-31 17:11:50 | pedro | 3 | 83667 | 714 | 3.436 | 24350.1 |
269 | 2022-10-05 21:48:49 | pedro | 3 | 83667 | 714 | 3.300 | 25353.6 |
268 | 2022-09-29 02:46:40 | pedro | 1 | 28756 | 2 | 0.440 | 65354.5 |
267 | 2022-09-10 12:18:05 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
266 | 2022-09-07 00:09:36 | pedro | 2 | 53800 | 51 | 1.343 | 40059.6 |
265 | 2022-09-05 20:25:05 | pedro | 3 | 83667 | 714 | 3.266 | 25617.6 |
264 | 2022-07-28 10:00:55 | pedro | 3 | 83667 | 714 | 3.360 | 24900.9 |
263 | 2022-06-21 12:07:14 | pedro | 3 | 83667 | 714 | 3.326 | 25155.4 |
262 | 2022-06-15 22:16:19 | pedro | 3 | 83667 | 714 | 3.373 | 24804.9 |
261 | 2022-05-18 05:13:00 | pedro | 3 | 83667 | 714 | 3.280 | 25508.2 |
260 | 2022-05-10 23:56:19 | pedro | 1 | 28756 | 2 | 0.656 | 43835.4 |
259 | 2022-05-08 18:51:07 | pedro | 1 | 28756 | 2 | 0.483 | 59536.2 |
258 | 2022-05-04 18:25:43 | pedro | 1 | 28756 | 2 | 0.563 | 51076.4 |
257 | 2022-03-24 00:01:53 | pedro | 2 | 53800 | 51 | 1.763 | 30516.2 |
256 | 2022-01-27 17:52:49 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
255 | 2022-01-25 14:14:07 | pedro | 1 | 28756 | 2 | 0.440 | 65354.5 |
254 | 2022-01-07 13:01:25 | pedro | 1 | 28756 | 2 | 0.513 | 56054.6 |
253 | 2021-12-08 19:29:12 | pedro | 2 | 53800 | 51 | 1.580 | 34050.6 |
252 | 2021-12-06 17:13:46 | pedro | 2 | 53800 | 51 | 1.436 | 37465.2 |
251 | 2021-12-03 12:05:12 | pedro | 1 | 28756 | 2 | 0.500 | 57512.0 |
250 | 2021-09-18 15:03:35 | pedro | 1 | 28756 | 2 | 0.486 | 59168.7 |
249 | 2021-09-15 08:13:18 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
248 | 2021-06-18 18:42:28 | pedro | 1 | 28756 | 2 | 0.450 | 63902.2 |
247 | 2021-05-29 22:41:00 | pedro | 1 | 28756 | 2 | 1.033 | 27837.4 |
246 | 2021-05-04 12:25:18 | pedro | 1 | 28756 | 2 | 0.516 | 55728.7 |
245 | 2021-04-02 14:28:49 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
244 | 2021-03-19 15:16:32 | pedro | 1 | 28756 | 2 | 0.500 | 57512.0 |
243 | 2021-01-17 15:30:53 | pedro | 1 | 28756 | 2 | 0.500 | 57512.0 |
242 | 2020-12-16 17:48:00 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
241 | 2020-11-05 02:07:46 | pedro | 1 | 28756 | 2 | 0.546 | 52666.7 |
240 | 2020-11-02 07:36:59 | pedro | 1 | 28756 | 2 | 0.513 | 56054.6 |
239 | 2020-11-01 09:25:21 | pedro | 1 | 28756 | 2 | 0.453 | 63479.0 |
238 | 2020-10-29 13:50:22 | pedro | 1 | 28756 | 2 | 0.483 | 59536.2 |
237 | 2020-10-08 23:54:21 | pedro | 1 | 28756 | 2 | 0.436 | 65954.1 |