History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
505 | 2024-04-27 10:20:14 | preps | 1 | 28756 | 11 | 0.530 | 54256.6 |
504 | 2024-04-02 22:16:53 | preps | 2 | 53800 | 186 | 1.986 | 27089.6 |
503 | 2024-04-02 21:45:17 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
502 | 2024-04-02 04:21:06 | preps | 1 | 28756 | 11 | 0.563 | 51076.4 |
501 | 2024-03-31 02:51:24 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
500 | 2024-03-29 01:19:34 | preps | 2 | 53800 | 186 | 5.826 | 9234.5 |
499 | 2024-03-29 01:15:59 | preps | 1 | 28756 | 11 | 1.750 | 16432.0 |
498 | 2024-03-23 17:31:37 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
497 | 2024-03-02 14:27:29 | preps | 1 | 28756 | 11 | 1.110 | 25906.3 |
496 | 2024-02-27 20:13:01 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
495 | 2024-01-29 02:20:15 | preps | 1 | 28756 | 11 | 0.470 | 61183.0 |
494 | 2024-01-28 18:51:38 | preps | 1 | 28756 | 11 | 0.440 | 65354.5 |
493 | 2024-01-09 00:47:47 | preps | 2 | 53800 | 186 | 1.360 | 39558.8 |
492 | 2023-12-24 05:29:42 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
491 | 2023-12-15 22:31:00 | preps | 1 | 28756 | 11 | 0.486 | 59168.7 |
490 | 2023-12-04 05:42:49 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
489 | 2023-12-04 05:42:48 | preps | 1 | 28756 | 11 | 0.910 | 31600.0 |
488 | 2023-11-24 08:21:06 | preps | 2 | 53800 | 186 | 1.406 | 38264.6 |
487 | 2023-11-14 20:32:01 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
486 | 2023-11-09 16:07:50 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
485 | 2023-11-04 13:35:39 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
484 | 2023-11-03 09:00:22 | preps | 2 | 53800 | 186 | 1.406 | 38264.6 |
483 | 2023-10-20 23:51:36 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
482 | 2023-10-18 07:38:53 | preps | 1 | 28756 | 11 | 0.983 | 29253.3 |
481 | 2023-10-14 02:54:20 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
480 | 2023-10-10 06:20:22 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
479 | 2023-10-08 08:23:08 | preps | 1 | 28756 | 11 | 0.516 | 55728.7 |
478 | 2023-09-26 02:08:04 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
477 | 2023-09-14 07:09:35 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
476 | 2023-08-23 00:09:34 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
475 | 2023-08-19 17:11:40 | preps | 1 | 28756 | 11 | 0.450 | 63902.2 |
474 | 2023-08-06 08:27:22 | preps | 1 | 28756 | 11 | 0.486 | 59168.7 |
473 | 2023-05-05 16:54:43 | preps | 1 | 28756 | 11 | 0.483 | 59536.2 |
472 | 2023-05-03 17:02:14 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
471 | 2023-02-25 15:36:49 | preps | 1 | 28756 | 11 | 0.440 | 65354.5 |
470 | 2023-01-23 10:10:33 | preps | 1 | 28756 | 11 | 0.483 | 59536.2 |
469 | 2022-12-22 10:58:34 | preps | 1 | 28756 | 11 | 0.483 | 59536.2 |
468 | 2022-10-05 13:01:07 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
467 | 2022-09-10 19:13:54 | preps | 1 | 28756 | 11 | 0.516 | 55728.7 |
466 | 2022-09-04 20:14:08 | preps | 1 | 28756 | 11 | 0.483 | 59536.2 |
465 | 2022-09-02 04:41:50 | preps | 1 | 28756 | 11 | 0.470 | 61183.0 |
464 | 2022-08-14 17:11:55 | preps | 1 | 28756 | 11 | 0.450 | 63902.2 |
463 | 2022-08-06 07:02:19 | preps | 1 | 28756 | 11 | 0.440 | 65354.5 |
462 | 2022-06-14 22:24:56 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
461 | 2022-04-11 13:11:17 | preps | 1 | 28756 | 11 | 0.593 | 48492.4 |
460 | 2022-03-03 02:49:42 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
459 | 2022-01-07 11:29:46 | preps | 1 | 28756 | 11 | 0.513 | 56054.6 |
458 | 2021-12-30 21:46:36 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
457 | 2021-12-24 01:24:31 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
456 | 2021-11-23 18:56:59 | preps | 1 | 28756 | 11 | 0.610 | 47141.0 |
455 | 2021-11-19 10:33:02 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
454 | 2021-11-05 14:29:21 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
453 | 2021-11-03 12:06:00 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
452 | 2021-09-14 11:26:54 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
451 | 2021-08-27 21:05:40 | preps | 1 | 28756 | 11 | 0.483 | 59536.2 |
450 | 2021-08-13 07:05:33 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
449 | 2021-05-12 13:25:20 | preps | 1 | 28756 | 11 | 0.483 | 59536.2 |
448 | 2021-04-29 02:03:43 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
447 | 2021-02-25 18:17:20 | preps | 1 | 28756 | 11 | 0.623 | 46157.3 |
446 | 2021-02-25 05:33:56 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
445 | 2021-02-13 22:00:55 | preps | 1 | 28756 | 11 | 0.516 | 55728.7 |
444 | 2021-02-08 12:48:23 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
443 | 2021-01-12 13:06:49 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
442 | 2020-11-06 18:25:40 | preps | 1 | 28756 | 11 | 0.450 | 63902.2 |
441 | 2020-10-29 02:21:37 | preps | 2 | 53800 | 186 | 1.376 | 39098.8 |
440 | 2020-10-26 01:09:14 | preps | 1 | 28756 | 11 | 0.486 | 59168.7 |
439 | 2020-10-19 15:52:47 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
438 | 2020-10-02 04:34:03 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
437 | 2020-09-29 23:44:26 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
436 | 2020-09-25 15:00:07 | preps | 1 | 28756 | 11 | 0.470 | 61183.0 |
435 | 2020-08-06 00:42:33 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
434 | 2020-08-05 13:14:52 | preps | 1 | 28756 | 11 | 0.516 | 55728.7 |
433 | 2020-05-10 08:32:02 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
432 | 2020-05-04 01:31:11 | preps | 1 | 28756 | 11 | 0.906 | 31739.5 |
431 | 2020-03-25 23:33:45 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
430 | 2020-03-25 05:59:03 | preps | 1 | 28756 | 11 | 0.483 | 59536.2 |
429 | 2020-03-23 13:35:44 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
428 | 2020-03-23 01:43:53 | preps | 1 | 28756 | 11 | 0.986 | 29164.3 |
427 | 2020-03-22 16:32:59 | preps | 1 | 28756 | 11 | 0.546 | 52666.7 |
426 | 2020-03-21 08:39:26 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
425 | 2020-03-18 03:26:25 | preps | 1 | 28756 | 11 | 0.500 | 57512.0 |
424 | 2020-03-03 01:49:40 | preps | 1 | 28756 | 11 | 0.453 | 63479.0 |
423 | 2020-02-24 21:04:59 | preps | 1 | 28756 | 11 | 0.470 | 61183.0 |
422 | 2020-02-24 11:46:42 | preps | 1 | 28756 | 11 | 1.080 | 26625.9 |
421 | 2020-02-18 15:43:29 | preps | 1 | 28756 | 11 | 0.546 | 52666.7 |
420 | 2020-02-17 16:46:51 | preps | 1 | 28756 | 11 | 1.140 | 25224.6 |
419 | 2020-02-12 10:35:29 | preps | 1 | 28756 | 11 | 1.106 | 26000.0 |
418 | 2020-02-09 00:42:56 | preps | 1 | 28756 | 11 | 0.530 | 54256.6 |
417 | 2020-02-08 18:27:36 | preps | 1 | 28756 | 11 | 1.140 | 25224.6 |
416 | 2020-02-01 20:31:48 | preps | 1 | 28756 | 11 | 0.436 | 65954.1 |
415 | 2020-01-29 07:12:14 | preps | 1 | 28756 | 11 | 1.156 | 24875.4 |
414 | 2020-01-29 04:34:25 | preps | 1 | 28756 | 11 | 0.423 | 67981.1 |
413 | 2020-01-29 04:06:58 | preps | 1 | 28756 | 11 | 0.516 | 55728.7 |
412 | 2020-01-23 12:07:22 | preps | 1 | 28756 | 11 | 1.140 | 25224.6 |
411 | 2020-01-22 00:59:18 | preps | 1 | 28756 | 11 | 0.626 | 45936.1 |
410 | 2020-01-21 07:01:21 | preps | 1 | 28756 | 11 | 0.563 | 51076.4 |
409 | 2020-01-11 05:05:41 | preps | 1 | 28756 | 11 | 0.546 | 52666.7 |
408 | 2020-01-11 03:05:01 | preps | 1 | 28756 | 11 | 0.580 | 49579.3 |
407 | 2020-01-10 05:35:01 | preps | 1 | 28756 | 11 | 0.923 | 31154.9 |
406 | 2020-01-06 21:59:35 | preps | 1 | 28756 | 11 | 0.560 | 51350.0 |