History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
687 | 2024-03-28 07:39:01 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
686 | 2024-03-18 04:37:04 | crest | 2 | 53800 | 181 | 1.670 | 32215.6 |
685 | 2024-03-04 03:15:32 | crest | 2 | 53800 | 181 | 1.626 | 33087.3 |
684 | 2024-03-04 03:15:23 | crest | 1 | 28756 | 10 | 0.486 | 59168.7 |
683 | 2024-02-27 11:41:00 | crest | 2 | 53800 | 181 | 1.890 | 28465.6 |
682 | 2024-02-26 03:58:45 | crest | 2 | 53800 | 181 | 5.266 | 10216.5 |
681 | 2024-02-26 03:35:47 | crest | 1 | 28756 | 10 | 0.513 | 56054.6 |
680 | 2024-02-22 08:30:43 | crest | 1 | 28756 | 10 | 1.063 | 27051.7 |
679 | 2024-02-14 16:41:45 | crest | 2 | 53800 | 181 | 1.936 | 27789.3 |
678 | 2024-02-03 02:28:27 | crest | 1 | 28756 | 10 | 0.546 | 52666.7 |
677 | 2024-01-26 21:25:45 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
676 | 2024-01-20 02:36:44 | crest | 1 | 28756 | 10 | 0.483 | 59536.2 |
675 | 2024-01-05 14:42:37 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
674 | 2023-12-06 04:33:58 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
673 | 2023-12-04 20:38:20 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
672 | 2023-11-28 00:53:26 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
671 | 2023-11-23 15:44:15 | crest | 2 | 53800 | 181 | 1.623 | 33148.5 |
670 | 2023-11-23 03:26:10 | crest | 2 | 53800 | 181 | 3.750 | 14346.7 |
669 | 2023-11-19 07:29:54 | crest | 2 | 53800 | 181 | 1.580 | 34050.6 |
668 | 2023-11-13 14:12:18 | crest | 1 | 28756 | 10 | 0.440 | 65354.5 |
667 | 2023-11-09 16:01:15 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
666 | 2023-11-06 16:24:37 | crest | 2 | 53800 | 181 | 1.390 | 38705.0 |
665 | 2023-10-28 15:33:07 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
664 | 2023-10-26 04:29:13 | crest | 2 | 53800 | 181 | 1.593 | 33772.8 |
663 | 2023-10-19 19:24:08 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
662 | 2023-10-18 15:53:39 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
661 | 2023-10-11 23:37:53 | crest | 1 | 28756 | 10 | 0.860 | 33437.2 |
660 | 2023-10-09 04:29:00 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
659 | 2023-10-07 23:54:58 | crest | 1 | 28756 | 10 | 0.420 | 68466.7 |
658 | 2023-09-24 18:13:22 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
657 | 2023-09-22 18:04:12 | crest | 1 | 28756 | 10 | 0.516 | 55728.7 |
656 | 2023-09-19 22:38:04 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
655 | 2023-07-03 02:30:35 | crest | 1 | 28756 | 10 | 1.000 | 28756.0 |
654 | 2023-04-12 19:58:48 | crest | 1 | 28756 | 10 | 0.420 | 68466.7 |
653 | 2023-03-23 03:39:52 | crest | 1 | 28756 | 10 | 0.423 | 67981.1 |
652 | 2023-03-19 22:12:12 | crest | 1 | 28756 | 10 | 0.486 | 59168.7 |
651 | 2023-02-04 02:04:01 | crest | 1 | 28756 | 10 | 0.440 | 65354.5 |
650 | 2023-01-27 14:47:15 | crest | 1 | 28756 | 10 | 0.483 | 59536.2 |
649 | 2022-12-13 00:07:58 | crest | 1 | 28756 | 10 | 0.483 | 59536.2 |
648 | 2022-12-11 15:32:31 | crest | 1 | 28756 | 10 | 0.466 | 61708.2 |
647 | 2022-12-03 05:29:23 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
646 | 2022-11-14 20:00:35 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
645 | 2022-08-31 16:04:59 | crest | 1 | 28756 | 10 | 0.546 | 52666.7 |
644 | 2022-07-28 19:47:59 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
643 | 2022-05-26 01:47:12 | crest | 1 | 28756 | 10 | 0.483 | 59536.2 |
642 | 2022-04-11 01:34:35 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
641 | 2022-02-19 16:08:48 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
640 | 2022-02-18 01:11:28 | crest | 1 | 28756 | 10 | 0.533 | 53951.2 |
639 | 2021-12-25 03:48:23 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
638 | 2021-12-21 13:56:51 | crest | 1 | 28756 | 10 | 0.516 | 55728.7 |
637 | 2021-11-21 14:19:50 | crest | 1 | 28756 | 10 | 0.450 | 63902.2 |
636 | 2021-11-16 16:56:22 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
635 | 2021-10-29 23:22:03 | crest | 1 | 28756 | 10 | 0.483 | 59536.2 |
634 | 2021-09-24 16:39:31 | crest | 1 | 28756 | 10 | 0.530 | 54256.6 |
633 | 2021-08-23 01:27:14 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
632 | 2021-08-20 20:52:53 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
631 | 2021-08-17 02:50:27 | crest | 1 | 28756 | 10 | 0.970 | 29645.4 |
630 | 2021-05-30 04:45:49 | crest | 2 | 53800 | 181 | 1.530 | 35163.4 |
629 | 2021-05-22 19:14:34 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
628 | 2021-05-16 10:48:51 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
627 | 2021-05-13 01:59:22 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
626 | 2021-04-23 20:13:41 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
625 | 2021-03-25 21:31:20 | crest | 1 | 28756 | 10 | 0.890 | 32310.1 |
624 | 2021-02-23 03:39:31 | crest | 1 | 28756 | 10 | 0.466 | 61708.2 |
623 | 2021-02-14 07:24:33 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
622 | 2021-02-09 07:43:39 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
621 | 2021-01-09 03:42:43 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
620 | 2020-12-13 22:54:17 | crest | 2 | 53800 | 181 | 1.390 | 38705.0 |
619 | 2020-12-10 15:25:59 | crest | 1 | 28756 | 10 | 0.440 | 65354.5 |
618 | 2020-11-07 14:13:05 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
617 | 2020-10-31 17:58:50 | crest | 1 | 28756 | 10 | 0.516 | 55728.7 |
616 | 2020-10-31 10:46:11 | crest | 1 | 28756 | 10 | 0.533 | 53951.2 |
615 | 2020-08-07 16:10:19 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
614 | 2020-08-02 20:22:50 | crest | 1 | 28756 | 10 | 0.466 | 61708.2 |
613 | 2020-08-01 09:00:54 | crest | 1 | 28756 | 10 | 0.470 | 61183.0 |
612 | 2020-07-29 19:52:16 | crest | 1 | 28756 | 10 | 0.466 | 61708.2 |
611 | 2020-07-28 18:23:56 | crest | 1 | 28756 | 10 | 0.470 | 61183.0 |
610 | 2020-07-25 07:39:09 | crest | 1 | 28756 | 10 | 0.470 | 61183.0 |
609 | 2020-07-23 08:37:46 | crest | 1 | 28756 | 10 | 0.470 | 61183.0 |
608 | 2020-05-04 13:19:33 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
607 | 2020-04-21 07:06:42 | crest | 1 | 28756 | 10 | 0.483 | 59536.2 |
606 | 2020-04-13 02:26:12 | crest | 2 | 53800 | 181 | 1.406 | 38264.6 |
605 | 2020-04-08 02:10:08 | crest | 2 | 53800 | 181 | 1.533 | 35094.6 |
604 | 2020-03-30 02:27:12 | crest | 1 | 28756 | 10 | 0.423 | 67981.1 |
603 | 2020-03-29 00:39:21 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
602 | 2020-03-25 19:58:25 | crest | 1 | 28756 | 10 | 0.436 | 65954.1 |
601 | 2020-03-22 05:35:04 | crest | 1 | 28756 | 10 | 0.546 | 52666.7 |
600 | 2020-03-21 10:12:23 | crest | 1 | 28756 | 10 | 0.483 | 59536.2 |
599 | 2020-03-21 01:20:44 | crest | 1 | 28756 | 10 | 0.530 | 54256.6 |
598 | 2020-03-18 00:23:18 | crest | 1 | 28756 | 10 | 0.500 | 57512.0 |
597 | 2020-03-01 07:40:02 | crest | 1 | 28756 | 10 | 0.453 | 63479.0 |
596 | 2020-03-01 04:28:07 | crest | 1 | 28756 | 10 | 0.686 | 41918.4 |
595 | 2020-02-28 02:31:01 | crest | 2 | 53800 | 181 | 1.830 | 29398.9 |
594 | 2020-02-27 12:10:27 | crest | 2 | 53800 | 181 | 1.610 | 33416.1 |
593 | 2020-02-25 11:13:21 | crest | 1 | 28756 | 10 | 1.593 | 18051.5 |
592 | 2020-02-20 07:48:49 | crest | 2 | 53800 | 181 | 5.300 | 10150.9 |
591 | 2020-02-19 04:38:03 | crest | 2 | 53800 | 181 | 1.906 | 28226.7 |
590 | 2020-02-17 23:09:49 | crest | 2 | 53800 | 181 | 1.686 | 31909.8 |
589 | 2020-02-17 18:24:58 | crest | 2 | 53800 | 181 | 3.390 | 15870.2 |
588 | 2020-02-14 04:38:29 | crest | 1 | 28756 | 10 | 0.780 | 36866.7 |