History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"extra"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
376 | 2024-03-10 14:12:01 | extra | 2 | 53800 | 30 | 4.813 | 11178.1 |
375 | 2024-03-08 22:58:01 | extra | 2 | 53800 | 30 | 1.656 | 32487.9 |
374 | 2024-03-08 22:57:38 | extra | 3 | 83667 | 390 | 4.440 | 18843.9 |
373 | 2024-03-07 04:43:28 | extra | 2 | 53800 | 30 | 2.580 | 20852.7 |
372 | 2024-03-07 04:43:01 | extra | 3 | 83667 | 390 | 3.970 | 21074.8 |
371 | 2024-03-07 04:40:20 | extra | 1 | 28756 | 2 | 1.093 | 26309.2 |
370 | 2024-03-01 13:34:51 | extra | 1 | 28756 | 2 | 0.483 | 59536.2 |
369 | 2024-03-01 10:36:36 | extra | 1 | 28756 | 2 | 1.673 | 17188.3 |
368 | 2024-03-01 07:33:06 | extra | 1 | 28756 | 2 | 0.593 | 48492.4 |
367 | 2024-02-29 21:12:01 | extra | 2 | 53800 | 30 | 1.360 | 39558.8 |
366 | 2024-02-29 21:11:41 | extra | 3 | 83667 | 390 | 7.000 | 11952.4 |
365 | 2024-02-28 20:10:15 | extra | 2 | 53800 | 30 | 1.720 | 31279.1 |
364 | 2024-02-28 20:10:11 | extra | 3 | 83667 | 390 | 4.016 | 20833.4 |
363 | 2024-02-28 20:00:19 | extra | 1 | 28756 | 2 | 1.000 | 28756.0 |
362 | 2024-02-04 00:39:03 | extra | 1 | 28756 | 2 | 0.423 | 67981.1 |
361 | 2024-01-29 10:56:55 | extra | 1 | 28756 | 2 | 0.440 | 65354.5 |
360 | 2024-01-29 06:31:41 | extra | 1 | 28756 | 2 | 0.466 | 61708.2 |
359 | 2024-01-03 03:50:54 | extra | 3 | 83667 | 390 | 3.346 | 25005.1 |
358 | 2024-01-03 03:50:53 | extra | 2 | 53800 | 30 | 1.423 | 37807.4 |
357 | 2024-01-02 19:57:14 | extra | 1 | 28756 | 2 | 0.470 | 61183.0 |
356 | 2023-12-24 21:01:55 | extra | 2 | 53800 | 30 | 1.310 | 41068.7 |
355 | 2023-12-11 13:39:17 | extra | 3 | 83667 | 390 | 3.673 | 22778.9 |
354 | 2023-12-11 13:39:15 | extra | 2 | 53800 | 30 | 1.640 | 32804.9 |
353 | 2023-11-30 15:02:08 | extra | 3 | 83667 | 390 | 7.813 | 10708.7 |
352 | 2023-11-30 15:02:02 | extra | 2 | 53800 | 30 | 1.906 | 28226.7 |
351 | 2023-11-13 16:04:25 | extra | 1 | 28756 | 2 | 0.436 | 65954.1 |
350 | 2023-11-11 09:50:27 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
349 | 2023-11-03 06:55:24 | extra | 1 | 28756 | 2 | 0.440 | 65354.5 |
348 | 2023-11-01 22:53:51 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
347 | 2023-10-31 08:59:58 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
346 | 2023-10-24 02:10:56 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
345 | 2023-10-22 07:11:11 | extra | 1 | 28756 | 2 | 0.533 | 53951.2 |
344 | 2023-10-16 14:04:40 | extra | 1 | 28756 | 2 | 0.486 | 59168.7 |
343 | 2023-10-07 22:59:16 | extra | 1 | 28756 | 2 | 0.486 | 59168.7 |
342 | 2023-09-29 03:10:14 | extra | 1 | 28756 | 2 | 0.486 | 59168.7 |
341 | 2023-09-25 12:57:32 | extra | 2 | 53800 | 30 | 1.576 | 34137.1 |
340 | 2023-09-22 11:36:19 | extra | 1 | 28756 | 2 | 0.420 | 68466.7 |
339 | 2023-08-19 13:11:03 | extra | 1 | 28756 | 2 | 0.420 | 68466.7 |
338 | 2023-07-17 08:48:38 | extra | 1 | 28756 | 2 | 0.423 | 67981.1 |
337 | 2023-07-05 18:17:57 | extra | 2 | 53800 | 30 | 1.360 | 39558.8 |
336 | 2023-05-22 14:31:48 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
335 | 2023-03-29 10:27:25 | extra | 1 | 28756 | 2 | 0.516 | 55728.7 |
334 | 2023-03-25 17:58:34 | extra | 1 | 28756 | 2 | 0.423 | 67981.1 |
333 | 2023-03-24 17:16:00 | extra | 2 | 53800 | 30 | 1.343 | 40059.6 |
332 | 2023-03-17 21:22:02 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
331 | 2023-01-05 18:22:51 | extra | 1 | 28756 | 2 | 0.486 | 59168.7 |
330 | 2022-12-22 06:22:01 | extra | 2 | 53800 | 30 | 1.576 | 34137.1 |
329 | 2022-12-07 13:24:11 | extra | 1 | 28756 | 2 | 0.420 | 68466.7 |
328 | 2022-10-02 14:53:11 | extra | 1 | 28756 | 2 | 0.486 | 59168.7 |
327 | 2022-08-21 07:26:54 | extra | 2 | 53800 | 30 | 1.313 | 40974.9 |
326 | 2022-08-10 14:37:24 | extra | 1 | 28756 | 2 | 0.483 | 59536.2 |
325 | 2022-07-29 00:46:48 | extra | 1 | 28756 | 2 | 0.440 | 65354.5 |
324 | 2022-07-18 18:45:02 | extra | 1 | 28756 | 2 | 0.436 | 65954.1 |
323 | 2022-07-17 23:53:14 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
322 | 2022-07-15 19:07:18 | extra | 3 | 83667 | 390 | 3.313 | 25254.2 |
321 | 2022-06-17 02:39:55 | extra | 1 | 28756 | 2 | 0.436 | 65954.1 |
320 | 2022-06-09 00:29:03 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
319 | 2022-06-08 17:47:08 | extra | 1 | 28756 | 2 | 0.563 | 51076.4 |
318 | 2022-06-01 14:03:20 | extra | 1 | 28756 | 2 | 0.420 | 68466.7 |
317 | 2022-05-25 17:41:23 | extra | 1 | 28756 | 2 | 0.513 | 56054.6 |
316 | 2022-05-16 22:58:41 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
315 | 2022-04-09 12:46:00 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
314 | 2022-01-29 09:37:41 | extra | 1 | 28756 | 2 | 0.440 | 65354.5 |
313 | 2021-12-25 09:27:14 | extra | 1 | 28756 | 2 | 0.470 | 61183.0 |
312 | 2021-11-26 16:50:13 | extra | 1 | 28756 | 2 | 0.576 | 49923.6 |
311 | 2021-10-26 17:54:09 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
310 | 2021-09-14 23:39:21 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
309 | 2021-06-14 23:26:03 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
308 | 2021-06-02 14:32:25 | extra | 1 | 28756 | 2 | 0.483 | 59536.2 |
307 | 2021-04-28 05:00:17 | extra | 1 | 28756 | 2 | 0.516 | 55728.7 |
306 | 2021-03-15 13:48:22 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
305 | 2021-03-11 01:19:14 | extra | 1 | 28756 | 2 | 0.436 | 65954.1 |
304 | 2021-02-23 22:37:54 | extra | 2 | 53800 | 30 | 1.483 | 36277.8 |
303 | 2021-02-14 17:31:46 | extra | 1 | 28756 | 2 | 0.470 | 61183.0 |
302 | 2021-01-22 21:59:46 | extra | 3 | 83667 | 390 | 3.406 | 24564.6 |
301 | 2021-01-21 23:46:14 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
300 | 2020-12-24 02:56:21 | extra | 3 | 83667 | 390 | 3.360 | 24900.9 |
299 | 2020-12-23 01:55:30 | extra | 1 | 28756 | 2 | 0.873 | 32939.3 |
298 | 2020-11-30 13:28:57 | extra | 1 | 28756 | 2 | 0.450 | 63902.2 |
297 | 2020-11-11 05:42:01 | extra | 3 | 83667 | 390 | 3.623 | 23093.3 |
296 | 2020-11-02 07:16:38 | extra | 3 | 83667 | 390 | 6.796 | 12311.2 |
295 | 2020-10-29 05:16:55 | extra | 2 | 53800 | 30 | 1.500 | 35866.7 |
294 | 2020-10-28 04:33:15 | extra | 1 | 28756 | 2 | 0.483 | 59536.2 |
293 | 2020-10-23 09:18:49 | extra | 1 | 28756 | 2 | 0.436 | 65954.1 |
292 | 2020-10-20 13:00:45 | extra | 1 | 28756 | 2 | 0.436 | 65954.1 |
291 | 2020-10-10 14:08:32 | extra | 1 | 28756 | 2 | 0.436 | 65954.1 |
290 | 2020-09-15 19:38:52 | extra | 1 | 28756 | 2 | 0.423 | 67981.1 |
289 | 2020-08-23 16:42:56 | extra | 1 | 28756 | 2 | 0.470 | 61183.0 |
288 | 2020-06-02 10:48:19 | extra | 1 | 28756 | 2 | 0.533 | 53951.2 |
287 | 2020-05-10 01:11:49 | extra | 1 | 28756 | 2 | 0.420 | 68466.7 |
286 | 2020-03-26 04:21:44 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
285 | 2020-03-24 19:48:27 | extra | 1 | 28756 | 2 | 0.533 | 53951.2 |
284 | 2020-03-21 22:50:40 | extra | 1 | 28756 | 2 | 0.470 | 61183.0 |
283 | 2020-03-21 14:29:20 | extra | 1 | 28756 | 2 | 0.686 | 41918.4 |
282 | 2020-03-20 21:44:56 | extra | 1 | 28756 | 2 | 0.500 | 57512.0 |
281 | 2020-03-18 01:11:08 | extra | 1 | 28756 | 2 | 0.453 | 63479.0 |
280 | 2020-02-22 23:41:23 | extra | 1 | 28756 | 2 | 0.560 | 51350.0 |
279 | 2020-02-19 16:12:09 | extra | 1 | 28756 | 2 | 0.546 | 52666.7 |
278 | 2020-02-19 15:07:17 | extra | 1 | 28756 | 2 | 0.686 | 41918.4 |
277 | 2020-02-07 11:50:27 | extra | 1 | 28756 | 2 | 0.580 | 49579.3 |