History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"toper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
691 | 2024-04-03 02:27:51 | toper | 1 | 28756 | 20 | 1.766 | 16283.1 |
690 | 2024-03-31 02:53:00 | toper | 1 | 28756 | 20 | 0.533 | 53951.2 |
689 | 2024-03-28 20:31:24 | toper | 1 | 28756 | 20 | 1.046 | 27491.4 |
688 | 2024-03-23 16:06:01 | toper | 1 | 28756 | 20 | 0.530 | 54256.6 |
687 | 2024-03-03 21:10:58 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
686 | 2024-02-27 23:44:27 | toper | 2 | 53800 | 276 | 1.686 | 31909.8 |
685 | 2024-02-27 22:20:34 | toper | 2 | 53800 | 276 | 1.550 | 34709.7 |
684 | 2024-02-27 20:59:53 | toper | 1 | 28756 | 20 | 0.546 | 52666.7 |
683 | 2024-02-02 19:21:55 | toper | 1 | 28756 | 20 | 0.530 | 54256.6 |
682 | 2024-01-22 02:14:07 | toper | 1 | 28756 | 20 | 0.516 | 55728.7 |
681 | 2024-01-21 22:07:40 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
680 | 2023-12-20 16:34:02 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
679 | 2023-12-20 15:32:21 | toper | 1 | 28756 | 20 | 0.450 | 63902.2 |
678 | 2023-12-07 20:38:45 | toper | 2 | 53800 | 276 | 1.483 | 36277.8 |
677 | 2023-12-05 12:35:15 | toper | 2 | 53800 | 276 | 1.390 | 38705.0 |
676 | 2023-11-18 12:14:27 | toper | 1 | 28756 | 20 | 0.513 | 56054.6 |
675 | 2023-11-17 20:06:51 | toper | 1 | 28756 | 20 | 0.533 | 53951.2 |
674 | 2023-11-10 15:45:36 | toper | 1 | 28756 | 20 | 0.453 | 63479.0 |
673 | 2023-11-03 23:18:22 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
672 | 2023-10-22 11:21:42 | toper | 1 | 28756 | 20 | 1.110 | 25906.3 |
671 | 2023-10-19 20:41:59 | toper | 1 | 28756 | 20 | 0.486 | 59168.7 |
670 | 2023-10-13 17:54:08 | toper | 1 | 28756 | 20 | 0.453 | 63479.0 |
669 | 2023-10-08 16:22:16 | toper | 1 | 28756 | 20 | 0.533 | 53951.2 |
668 | 2023-10-07 09:52:38 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
667 | 2023-09-25 06:25:25 | toper | 1 | 28756 | 20 | 0.783 | 36725.4 |
666 | 2023-09-21 06:27:43 | toper | 1 | 28756 | 20 | 0.436 | 65954.1 |
665 | 2023-08-05 05:09:40 | toper | 1 | 28756 | 20 | 0.440 | 65354.5 |
664 | 2023-05-31 20:12:13 | toper | 1 | 28756 | 20 | 0.436 | 65954.1 |
663 | 2023-05-02 08:58:27 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
662 | 2023-02-24 22:48:40 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
661 | 2023-02-12 08:59:03 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
660 | 2023-02-08 21:04:30 | toper | 1 | 28756 | 20 | 0.453 | 63479.0 |
659 | 2022-12-22 01:54:31 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
658 | 2022-10-22 09:47:30 | toper | 1 | 28756 | 20 | 0.436 | 65954.1 |
657 | 2022-09-10 21:07:30 | toper | 1 | 28756 | 20 | 0.436 | 65954.1 |
656 | 2022-09-08 02:57:14 | toper | 1 | 28756 | 20 | 0.440 | 65354.5 |
655 | 2022-09-03 19:00:16 | toper | 1 | 28756 | 20 | 0.486 | 59168.7 |
654 | 2022-09-01 04:31:47 | toper | 1 | 28756 | 20 | 0.453 | 63479.0 |
653 | 2022-08-15 03:52:50 | toper | 1 | 28756 | 20 | 0.450 | 63902.2 |
652 | 2022-08-10 16:44:02 | toper | 1 | 28756 | 20 | 0.440 | 65354.5 |
651 | 2022-08-03 00:52:15 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
650 | 2022-08-03 00:32:54 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
649 | 2022-07-29 11:18:10 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
648 | 2022-07-02 12:15:52 | toper | 1 | 28756 | 20 | 0.450 | 63902.2 |
647 | 2022-04-21 09:41:31 | toper | 1 | 28756 | 20 | 0.750 | 38341.3 |
646 | 2022-04-19 06:12:41 | toper | 1 | 28756 | 20 | 0.470 | 61183.0 |
645 | 2022-03-15 10:43:04 | toper | 1 | 28756 | 20 | 0.576 | 49923.6 |
644 | 2022-01-23 12:48:03 | toper | 1 | 28756 | 20 | 0.513 | 56054.6 |
643 | 2022-01-22 19:31:12 | toper | 1 | 28756 | 20 | 0.466 | 61708.2 |
642 | 2022-01-22 06:50:38 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
641 | 2022-01-13 03:29:50 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
640 | 2022-01-12 20:12:32 | toper | 1 | 28756 | 20 | 0.516 | 55728.7 |
639 | 2022-01-12 19:00:30 | toper | 1 | 28756 | 20 | 0.453 | 63479.0 |
638 | 2022-01-12 01:39:59 | toper | 1 | 28756 | 20 | 0.560 | 51350.0 |
637 | 2022-01-11 09:08:37 | toper | 1 | 28756 | 20 | 0.656 | 43835.4 |
636 | 2022-01-10 17:26:05 | toper | 1 | 28756 | 20 | 0.486 | 59168.7 |
635 | 2022-01-10 16:46:05 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
634 | 2022-01-10 08:57:18 | toper | 1 | 28756 | 20 | 0.516 | 55728.7 |
633 | 2022-01-09 18:57:55 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
632 | 2022-01-08 14:25:56 | toper | 1 | 28756 | 20 | 0.516 | 55728.7 |
631 | 2021-12-02 02:37:50 | toper | 1 | 28756 | 20 | 0.453 | 63479.0 |
630 | 2021-12-01 15:10:54 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
629 | 2021-12-01 02:51:04 | toper | 1 | 28756 | 20 | 0.563 | 51076.4 |
628 | 2021-11-30 13:48:12 | toper | 1 | 28756 | 20 | 0.563 | 51076.4 |
627 | 2021-11-29 15:51:13 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
626 | 2021-11-29 03:25:41 | toper | 1 | 28756 | 20 | 0.440 | 65354.5 |
625 | 2021-11-28 06:58:31 | toper | 1 | 28756 | 20 | 0.470 | 61183.0 |
624 | 2021-11-26 23:56:57 | toper | 1 | 28756 | 20 | 0.533 | 53951.2 |
623 | 2021-11-26 11:04:03 | toper | 1 | 28756 | 20 | 0.563 | 51076.4 |
622 | 2021-11-25 19:57:36 | toper | 1 | 28756 | 20 | 0.436 | 65954.1 |
621 | 2021-11-25 08:07:38 | toper | 1 | 28756 | 20 | 0.546 | 52666.7 |
620 | 2021-11-24 23:48:50 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
619 | 2021-11-19 22:58:54 | toper | 1 | 28756 | 20 | 0.516 | 55728.7 |
618 | 2021-11-19 00:12:52 | toper | 1 | 28756 | 20 | 0.530 | 54256.6 |
617 | 2021-11-18 00:26:08 | toper | 1 | 28756 | 20 | 0.593 | 48492.4 |
616 | 2021-11-06 17:51:03 | toper | 1 | 28756 | 20 | 0.516 | 55728.7 |
615 | 2021-10-26 13:10:20 | toper | 1 | 28756 | 20 | 0.533 | 53951.2 |
614 | 2021-10-25 18:35:13 | toper | 1 | 28756 | 20 | 0.843 | 34111.5 |
613 | 2021-10-25 02:42:33 | toper | 1 | 28756 | 20 | 0.516 | 55728.7 |
612 | 2021-10-24 19:55:34 | toper | 1 | 28756 | 20 | 0.530 | 54256.6 |
611 | 2021-10-24 07:51:19 | toper | 1 | 28756 | 20 | 0.560 | 51350.0 |
610 | 2021-10-23 20:01:20 | toper | 1 | 28756 | 20 | 1.000 | 28756.0 |
609 | 2021-10-23 08:47:06 | toper | 1 | 28756 | 20 | 0.436 | 65954.1 |
608 | 2021-10-22 21:24:41 | toper | 1 | 28756 | 20 | 0.513 | 56054.6 |
607 | 2021-10-21 22:30:50 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
606 | 2021-10-09 13:50:14 | toper | 1 | 28756 | 20 | 0.436 | 65954.1 |
605 | 2021-10-08 10:01:43 | toper | 1 | 28756 | 20 | 0.486 | 59168.7 |
604 | 2021-10-07 09:19:42 | toper | 1 | 28756 | 20 | 0.456 | 63061.4 |
603 | 2021-10-06 10:09:07 | toper | 1 | 28756 | 20 | 0.530 | 54256.6 |
602 | 2021-10-05 07:56:41 | toper | 1 | 28756 | 20 | 0.970 | 29645.4 |
601 | 2021-10-04 12:41:55 | toper | 1 | 28756 | 20 | 0.546 | 52666.7 |
600 | 2021-10-03 09:42:11 | toper | 1 | 28756 | 20 | 0.450 | 63902.2 |
599 | 2021-10-02 09:21:35 | toper | 1 | 28756 | 20 | 0.486 | 59168.7 |
598 | 2021-09-28 11:55:53 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
597 | 2021-09-09 23:27:37 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
596 | 2021-09-08 08:58:55 | toper | 1 | 28756 | 20 | 0.546 | 52666.7 |
595 | 2021-09-07 14:58:42 | toper | 1 | 28756 | 20 | 0.500 | 57512.0 |
594 | 2021-09-06 19:58:22 | toper | 1 | 28756 | 20 | 0.483 | 59536.2 |
593 | 2021-08-31 07:09:26 | toper | 1 | 28756 | 20 | 0.453 | 63479.0 |
592 | 2021-08-29 02:41:22 | toper | 1 | 28756 | 20 | 0.513 | 56054.6 |