History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mainliner"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
709 | 2024-05-15 23:41:23 | mainliner | 1 | 81242 | 5 | 1.690 | 48072.2 |
708 | 2024-05-05 18:00:52 | mainliner | 4 | 165329 | 571 | 25.720 | 6428.0 |
707 | 2024-04-29 21:20:03 | mainliner | 2 | 121436 | 11 | 8.780 | 13831.0 |
706 | 2024-04-29 21:19:03 | mainliner | 3 | 148641 | 62 | 8.016 | 18543.0 |
705 | 2024-04-29 21:06:35 | mainliner | 1 | 81242 | 5 | 1.796 | 45235.0 |
704 | 2024-04-29 21:06:27 | mainliner | 1 | 81242 | 5 | 1.500 | 54161.3 |
703 | 2024-04-29 00:32:19 | mainliner | 1 | 81242 | 5 | 2.986 | 27207.6 |
702 | 2024-04-27 10:31:38 | mainliner | 1 | 81242 | 5 | 4.390 | 18506.2 |
701 | 2024-04-21 16:25:08 | mainliner | 4 | 165329 | 571 | 40.816 | 4050.6 |
700 | 2024-04-19 17:00:36 | mainliner | 3 | 148641 | 62 | 12.283 | 12101.4 |
699 | 2024-04-19 17:00:36 | mainliner | 2 | 121436 | 11 | 9.546 | 12721.1 |
698 | 2024-04-19 14:41:36 | mainliner | 1 | 81242 | 5 | 1.750 | 46424.0 |
697 | 2024-04-15 09:56:04 | mainliner | 4 | 165329 | 571 | 24.300 | 6803.7 |
696 | 2024-04-11 09:31:54 | mainliner | 1 | 81242 | 5 | 1.546 | 52549.8 |
695 | 2024-04-07 23:53:21 | mainliner | 4 | 165329 | 571 | 42.173 | 3920.3 |
694 | 2024-04-05 11:24:02 | mainliner | 4 | 165329 | 571 | 34.126 | 4844.7 |
693 | 2024-04-04 04:16:38 | mainliner | 4 | 165329 | 571 | 20.093 | 8228.2 |
692 | 2024-04-03 23:52:13 | mainliner | 4 | 165329 | 571 | 41.596 | 3974.6 |
691 | 2024-04-03 23:51:12 | mainliner | 4 | 165329 | 571 | 18.546 | 8914.5 |
690 | 2024-03-30 20:52:40 | mainliner | 1 | 81242 | 5 | 5.876 | 13826.1 |
689 | 2024-03-29 03:26:22 | mainliner | 1 | 81242 | 5 | 2.453 | 33119.4 |
688 | 2024-03-24 17:23:59 | mainliner | 3 | 148641 | 62 | 19.533 | 7609.7 |
687 | 2024-03-18 18:04:01 | mainliner | 3 | 148641 | 62 | 13.673 | 10871.1 |
686 | 2024-03-18 18:04:00 | mainliner | 2 | 121436 | 11 | 10.580 | 11477.9 |
685 | 2024-03-14 14:50:08 | mainliner | 3 | 148641 | 62 | 17.563 | 8463.3 |
684 | 2024-03-14 14:49:25 | mainliner | 2 | 121436 | 11 | 12.906 | 9409.3 |
683 | 2024-03-14 13:56:48 | mainliner | 1 | 81242 | 5 | 1.530 | 53099.3 |
682 | 2024-03-12 09:21:45 | mainliner | 3 | 148641 | 62 | 18.516 | 8027.7 |
681 | 2024-03-12 09:21:46 | mainliner | 2 | 121436 | 11 | 5.703 | 21293.4 |
680 | 2024-03-12 06:53:43 | mainliner | 1 | 81242 | 5 | 1.453 | 55913.3 |
679 | 2024-03-11 01:51:49 | mainliner | 1 | 81242 | 5 | 1.420 | 57212.7 |
678 | 2024-03-06 03:37:57 | mainliner | 4 | 165329 | 571 | 32.503 | 5086.6 |
677 | 2024-03-05 20:19:13 | mainliner | 4 | 165329 | 571 | 38.050 | 4345.0 |
676 | 2024-03-05 18:41:08 | mainliner | 4 | 165329 | 571 | 44.410 | 3722.8 |
675 | 2024-02-28 21:09:37 | mainliner | 1 | 81242 | 5 | 1.360 | 59736.8 |
674 | 2024-02-26 12:03:13 | mainliner | 1 | 81242 | 5 | 3.016 | 26937.0 |
673 | 2024-02-08 09:15:25 | mainliner | 1 | 81242 | 5 | 1.796 | 45235.0 |
672 | 2024-02-01 14:50:35 | mainliner | 1 | 81242 | 5 | 1.360 | 59736.8 |
671 | 2024-01-31 12:57:35 | mainliner | 4 | 165329 | 571 | 12.233 | 13515.0 |
670 | 2024-01-31 04:02:47 | mainliner | 1 | 81242 | 5 | 1.360 | 59736.8 |
669 | 2024-01-30 06:56:28 | mainliner | 1 | 81242 | 5 | 1.406 | 57782.4 |
668 | 2024-01-29 23:26:53 | mainliner | 1 | 81242 | 5 | 1.453 | 55913.3 |
667 | 2024-01-27 11:41:21 | mainliner | 1 | 81242 | 5 | 2.546 | 31909.7 |
666 | 2024-01-26 19:57:27 | mainliner | 1 | 81242 | 5 | 1.406 | 57782.4 |
665 | 2024-01-26 14:22:10 | mainliner | 4 | 165329 | 571 | 19.080 | 8665.0 |
664 | 2023-12-31 03:13:43 | mainliner | 1 | 81242 | 5 | 1.313 | 61875.1 |
663 | 2023-12-07 00:37:41 | mainliner | 4 | 165329 | 571 | 10.706 | 15442.6 |
662 | 2023-11-30 16:12:08 | mainliner | 1 | 81242 | 5 | 1.423 | 57092.1 |
661 | 2023-11-24 01:00:53 | mainliner | 1 | 81242 | 5 | 3.173 | 25604.2 |
660 | 2023-11-23 11:22:35 | mainliner | 1 | 81242 | 5 | 1.266 | 64172.2 |
659 | 2023-10-30 07:51:49 | mainliner | 2 | 121436 | 11 | 3.483 | 34865.3 |
658 | 2023-10-30 07:44:25 | mainliner | 4 | 165329 | 571 | 18.656 | 8862.0 |
657 | 2023-10-30 07:44:24 | mainliner | 3 | 148641 | 62 | 7.546 | 19698.0 |
656 | 2023-10-26 02:22:32 | mainliner | 1 | 81242 | 5 | 1.313 | 61875.1 |
655 | 2023-10-25 23:01:22 | mainliner | 1 | 81242 | 5 | 1.376 | 59042.2 |
654 | 2023-09-26 02:38:46 | mainliner | 1 | 81242 | 5 | 1.326 | 61268.5 |
653 | 2023-09-12 07:48:47 | mainliner | 1 | 81242 | 5 | 1.346 | 60358.1 |
652 | 2023-09-11 23:31:17 | mainliner | 4 | 165329 | 571 | 14.783 | 11183.7 |
651 | 2023-09-09 23:28:11 | mainliner | 1 | 81242 | 5 | 1.390 | 58447.5 |
650 | 2023-09-04 06:27:40 | mainliner | 4 | 165329 | 571 | 11.470 | 14414.0 |
649 | 2023-08-10 01:30:57 | mainliner | 4 | 165329 | 571 | 10.830 | 15265.8 |
648 | 2023-07-08 18:21:10 | mainliner | 4 | 165329 | 571 | 11.983 | 13797.0 |
647 | 2023-06-23 03:35:29 | mainliner | 1 | 81242 | 5 | 1.283 | 63321.9 |
646 | 2023-05-09 02:27:28 | mainliner | 1 | 81242 | 5 | 1.216 | 66810.9 |
645 | 2023-04-06 21:57:59 | mainliner | 1 | 81242 | 5 | 1.233 | 65889.7 |
644 | 2023-03-31 15:47:23 | mainliner | 4 | 165329 | 571 | 10.610 | 15582.4 |
643 | 2023-02-17 23:29:15 | mainliner | 4 | 165329 | 571 | 13.530 | 12219.4 |
642 | 2023-02-05 13:20:54 | mainliner | 4 | 165329 | 571 | 10.860 | 15223.7 |
641 | 2023-01-24 12:55:18 | mainliner | 4 | 165329 | 571 | 10.530 | 15700.8 |
640 | 2023-01-21 16:48:36 | mainliner | 1 | 81242 | 5 | 1.250 | 64993.6 |
639 | 2023-01-08 06:11:10 | mainliner | 1 | 81242 | 5 | 1.406 | 57782.4 |
638 | 2022-12-20 05:57:51 | mainliner | 4 | 165329 | 571 | 10.500 | 15745.6 |
637 | 2022-12-13 06:07:29 | mainliner | 4 | 165329 | 571 | 11.156 | 14819.7 |
636 | 2022-11-22 08:02:58 | mainliner | 4 | 165329 | 571 | 11.326 | 14597.3 |
635 | 2022-11-20 00:51:22 | mainliner | 4 | 165329 | 571 | 11.470 | 14414.0 |
634 | 2022-11-18 22:16:09 | mainliner | 1 | 81242 | 5 | 1.250 | 64993.6 |
633 | 2022-11-13 08:25:42 | mainliner | 4 | 165329 | 571 | 11.953 | 13831.6 |
632 | 2022-11-10 19:00:25 | mainliner | 4 | 165329 | 571 | 11.376 | 14533.1 |
631 | 2022-11-04 21:00:56 | mainliner | 4 | 165329 | 571 | 10.690 | 15465.8 |
630 | 2022-11-03 00:51:57 | mainliner | 4 | 165329 | 571 | 10.623 | 15563.3 |
629 | 2022-10-04 07:56:59 | mainliner | 4 | 165329 | 571 | 10.796 | 15313.9 |
628 | 2022-08-27 16:14:18 | mainliner | 1 | 81242 | 5 | 1.233 | 65889.7 |
627 | 2022-08-08 02:31:56 | mainliner | 1 | 81242 | 5 | 1.220 | 66591.8 |
626 | 2022-07-09 00:12:21 | mainliner | 1 | 81242 | 5 | 1.220 | 66591.8 |
625 | 2022-07-06 20:03:53 | mainliner | 1 | 81242 | 5 | 1.250 | 64993.6 |
624 | 2022-06-17 10:13:41 | mainliner | 4 | 165329 | 571 | 10.940 | 15112.3 |
623 | 2022-06-06 15:26:15 | mainliner | 4 | 165329 | 571 | 10.970 | 15071.0 |
622 | 2022-04-09 14:29:51 | mainliner | 1 | 81242 | 5 | 1.456 | 55798.1 |
621 | 2022-03-07 06:16:48 | mainliner | 1 | 81242 | 5 | 1.233 | 65889.7 |
620 | 2022-03-05 03:14:01 | mainliner | 1 | 81242 | 5 | 1.216 | 66810.9 |
619 | 2022-03-02 23:45:20 | mainliner | 1 | 81242 | 5 | 1.250 | 64993.6 |
618 | 2022-01-01 13:01:39 | mainliner | 1 | 81242 | 5 | 1.423 | 57092.1 |
617 | 2021-12-09 09:00:58 | mainliner | 1 | 81242 | 5 | 1.310 | 62016.8 |
616 | 2021-12-03 08:54:02 | mainliner | 4 | 165329 | 571 | 21.143 | 7819.6 |
615 | 2021-10-29 08:09:30 | mainliner | 4 | 165329 | 571 | 12.813 | 12903.2 |
614 | 2021-09-29 13:16:40 | mainliner | 1 | 81242 | 5 | 1.360 | 59736.8 |
613 | 2021-09-26 22:18:32 | mainliner | 4 | 165329 | 571 | 13.186 | 12538.2 |
612 | 2021-09-21 02:53:15 | mainliner | 1 | 81242 | 5 | 2.783 | 29192.2 |
611 | 2021-08-23 00:17:06 | mainliner | 4 | 165329 | 571 | 11.046 | 14967.3 |
610 | 2021-08-19 17:06:01 | mainliner | 1 | 81242 | 5 | 1.390 | 58447.5 |