History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
700 | 2024-05-01 10:52:03 | collier | 1 | 69583 | 9 | 1.936 | 35941.6 |
699 | 2024-04-28 06:59:34 | collier | 1 | 69583 | 9 | 2.970 | 23428.6 |
698 | 2024-04-27 16:05:12 | collier | 1 | 69583 | 9 | 3.846 | 18092.3 |
697 | 2024-04-20 21:48:11 | collier | 1 | 69583 | 9 | 3.796 | 18330.6 |
696 | 2024-02-28 08:27:26 | collier | 2 | 107671 | 89 | 9.673 | 11131.1 |
695 | 2024-02-26 16:04:37 | collier | 3 | 134027 | 742 | 10.236 | 13093.7 |
694 | 2024-02-26 16:04:15 | collier | 2 | 107671 | 89 | 7.486 | 14383.0 |
693 | 2024-02-23 07:48:15 | collier | 2 | 107671 | 89 | 3.376 | 31893.1 |
692 | 2024-02-11 07:06:10 | collier | 3 | 134027 | 742 | 26.473 | 5062.8 |
691 | 2024-02-08 12:14:22 | collier | 3 | 134027 | 742 | 15.373 | 8718.3 |
690 | 2024-01-25 11:19:17 | collier | 1 | 69583 | 9 | 1.110 | 62687.4 |
689 | 2024-01-18 09:30:37 | collier | 3 | 134027 | 742 | 6.656 | 20136.3 |
688 | 2024-01-18 06:59:36 | collier | 3 | 134027 | 742 | 6.406 | 20922.1 |
687 | 2024-01-17 13:57:13 | collier | 3 | 134027 | 742 | 7.203 | 18607.1 |
686 | 2024-01-13 14:52:55 | collier | 3 | 134027 | 742 | 6.190 | 21652.2 |
685 | 2024-01-11 02:56:04 | collier | 3 | 134027 | 742 | 6.876 | 19492.0 |
684 | 2024-01-10 15:03:00 | collier | 2 | 107671 | 89 | 3.423 | 31455.2 |
683 | 2024-01-04 02:09:26 | collier | 1 | 69583 | 9 | 1.126 | 61796.6 |
682 | 2023-12-15 01:36:00 | collier | 3 | 134027 | 742 | 6.283 | 21331.7 |
681 | 2023-12-15 01:35:58 | collier | 2 | 107671 | 89 | 3.440 | 31299.7 |
680 | 2023-12-06 10:28:06 | collier | 3 | 134027 | 742 | 5.800 | 23108.1 |
679 | 2023-11-17 00:39:46 | collier | 1 | 69583 | 9 | 1.236 | 56296.9 |
678 | 2023-11-17 00:37:02 | collier | 2 | 107671 | 89 | 2.890 | 37256.4 |
677 | 2023-11-15 23:32:52 | collier | 3 | 134027 | 742 | 8.093 | 16560.9 |
676 | 2023-11-15 02:15:34 | collier | 2 | 107671 | 89 | 3.796 | 28364.3 |
675 | 2023-11-10 12:49:04 | collier | 3 | 134027 | 742 | 15.300 | 8759.9 |
674 | 2023-11-09 12:15:13 | collier | 1 | 69583 | 9 | 1.123 | 61961.7 |
673 | 2023-11-07 09:32:11 | collier | 3 | 134027 | 742 | 16.516 | 8115.0 |
672 | 2023-11-07 09:31:59 | collier | 3 | 134027 | 742 | 11.096 | 12078.9 |
671 | 2023-11-07 09:31:43 | collier | 2 | 107671 | 89 | 3.736 | 28819.9 |
670 | 2023-11-07 09:25:39 | collier | 1 | 69583 | 9 | 2.546 | 27330.3 |
669 | 2023-11-01 21:33:03 | collier | 2 | 107671 | 89 | 3.390 | 31761.4 |
668 | 2023-11-01 21:26:42 | collier | 1 | 69583 | 9 | 1.203 | 57841.2 |
667 | 2023-10-30 07:39:40 | collier | 3 | 134027 | 742 | 5.936 | 22578.7 |
666 | 2023-10-29 19:23:01 | collier | 3 | 134027 | 742 | 6.860 | 19537.5 |
665 | 2023-10-28 22:35:16 | collier | 1 | 69583 | 9 | 1.250 | 55666.4 |
664 | 2023-10-26 03:44:36 | collier | 1 | 69583 | 9 | 1.326 | 52475.9 |
663 | 2023-10-20 21:45:23 | collier | 3 | 134027 | 742 | 7.750 | 17293.8 |
662 | 2023-10-19 02:12:22 | collier | 3 | 134027 | 742 | 6.966 | 19240.2 |
661 | 2023-10-17 16:05:37 | collier | 1 | 69583 | 9 | 1.250 | 55666.4 |
660 | 2023-10-11 22:30:14 | collier | 1 | 69583 | 9 | 1.233 | 56433.9 |
659 | 2023-10-10 15:37:39 | collier | 1 | 69583 | 9 | 1.186 | 58670.3 |
658 | 2023-10-08 13:49:10 | collier | 1 | 69583 | 9 | 1.203 | 57841.2 |
657 | 2023-09-24 23:38:02 | collier | 1 | 69583 | 9 | 1.096 | 63488.1 |
656 | 2023-09-21 03:00:59 | collier | 1 | 69583 | 9 | 1.296 | 53690.6 |
655 | 2023-09-19 14:18:15 | collier | 1 | 69583 | 9 | 1.106 | 62914.1 |
654 | 2023-08-20 03:02:27 | collier | 1 | 69583 | 9 | 1.310 | 53116.8 |
653 | 2023-08-18 09:56:46 | collier | 2 | 107671 | 89 | 3.736 | 28819.9 |
652 | 2023-08-09 07:35:04 | collier | 1 | 69583 | 9 | 1.266 | 54962.9 |
651 | 2023-08-07 16:54:58 | collier | 3 | 134027 | 742 | 6.170 | 21722.4 |
650 | 2023-07-04 16:37:49 | collier | 1 | 69583 | 9 | 1.233 | 56433.9 |
649 | 2023-07-01 05:29:03 | collier | 2 | 107671 | 89 | 3.466 | 31064.9 |
648 | 2023-05-20 14:50:01 | collier | 1 | 69583 | 9 | 2.173 | 32021.6 |
647 | 2023-05-11 02:13:41 | collier | 2 | 107671 | 89 | 3.013 | 35735.5 |
646 | 2023-05-05 01:27:43 | collier | 2 | 107671 | 89 | 2.906 | 37051.3 |
645 | 2023-04-20 13:16:23 | collier | 3 | 134027 | 742 | 6.640 | 20184.8 |
644 | 2023-04-02 02:43:26 | collier | 2 | 107671 | 89 | 2.986 | 36058.6 |
643 | 2023-03-31 21:26:35 | collier | 1 | 69583 | 9 | 2.186 | 31831.2 |
642 | 2023-03-30 23:49:17 | collier | 3 | 134027 | 742 | 5.953 | 22514.2 |
641 | 2023-03-17 16:14:35 | collier | 1 | 69583 | 9 | 1.093 | 63662.4 |
640 | 2023-02-26 03:25:21 | collier | 3 | 134027 | 742 | 5.736 | 23365.9 |
639 | 2023-02-11 12:07:16 | collier | 2 | 107671 | 89 | 2.923 | 36835.8 |
638 | 2023-02-04 21:18:12 | collier | 3 | 134027 | 742 | 6.360 | 21073.4 |
637 | 2023-01-30 07:52:34 | collier | 3 | 134027 | 742 | 6.390 | 20974.5 |
636 | 2023-01-22 14:47:41 | collier | 3 | 134027 | 742 | 5.783 | 23176.0 |
635 | 2023-01-04 15:08:12 | collier | 1 | 69583 | 9 | 1.080 | 64428.7 |
634 | 2022-12-26 17:19:10 | collier | 1 | 69583 | 9 | 1.063 | 65459.1 |
633 | 2022-12-23 20:38:45 | collier | 3 | 134027 | 742 | 5.846 | 22926.3 |
632 | 2022-11-24 07:40:45 | collier | 2 | 107671 | 89 | 5.750 | 18725.4 |
631 | 2022-11-02 07:30:49 | collier | 3 | 134027 | 742 | 6.593 | 20328.7 |
630 | 2022-09-25 18:59:07 | collier | 1 | 69583 | 9 | 1.123 | 61961.7 |
629 | 2022-09-16 00:13:38 | collier | 1 | 69583 | 9 | 1.093 | 63662.4 |
628 | 2022-09-14 17:09:24 | collier | 1 | 69583 | 9 | 1.076 | 64668.2 |
627 | 2022-08-01 10:55:24 | collier | 1 | 69583 | 9 | 1.096 | 63488.1 |
626 | 2022-06-30 03:50:38 | collier | 2 | 107671 | 89 | 2.860 | 37647.2 |
625 | 2022-06-27 22:24:37 | collier | 2 | 107671 | 89 | 2.876 | 37437.8 |
624 | 2022-06-14 14:52:59 | collier | 3 | 134027 | 742 | 5.923 | 22628.2 |
623 | 2022-06-10 23:52:24 | collier | 3 | 134027 | 742 | 6.826 | 19634.8 |
622 | 2022-06-04 12:05:06 | collier | 3 | 134027 | 742 | 5.766 | 23244.4 |
621 | 2022-06-02 18:57:11 | collier | 1 | 69583 | 9 | 1.140 | 61037.7 |
620 | 2022-06-02 06:05:47 | collier | 3 | 134027 | 742 | 5.953 | 22514.2 |
619 | 2022-05-08 09:05:14 | collier | 1 | 69583 | 9 | 1.173 | 59320.5 |
618 | 2022-05-02 19:57:46 | collier | 2 | 107671 | 89 | 3.733 | 28843.0 |
617 | 2022-05-01 17:37:06 | collier | 2 | 107671 | 89 | 2.890 | 37256.4 |
616 | 2022-05-01 02:33:20 | collier | 2 | 107671 | 89 | 3.296 | 32667.2 |
615 | 2022-04-30 13:41:37 | collier | 2 | 107671 | 89 | 3.376 | 31893.1 |
614 | 2022-04-30 04:02:02 | collier | 2 | 107671 | 89 | 2.893 | 37217.8 |
613 | 2022-04-29 10:34:09 | collier | 2 | 107671 | 89 | 3.373 | 31921.4 |
612 | 2022-04-28 21:24:54 | collier | 2 | 107671 | 89 | 3.436 | 31336.1 |
611 | 2022-04-28 12:11:52 | collier | 2 | 107671 | 89 | 3.750 | 28712.3 |
610 | 2022-04-28 04:37:25 | collier | 2 | 107671 | 89 | 2.923 | 36835.8 |
609 | 2022-04-27 13:13:38 | collier | 2 | 107671 | 89 | 4.656 | 23125.2 |
608 | 2022-04-27 00:20:42 | collier | 2 | 107671 | 89 | 2.966 | 36301.8 |
607 | 2022-04-26 10:29:53 | collier | 2 | 107671 | 89 | 3.546 | 30364.1 |
606 | 2022-04-26 02:59:01 | collier | 2 | 107671 | 89 | 6.576 | 16373.3 |
605 | 2022-04-25 12:34:19 | collier | 2 | 107671 | 89 | 3.660 | 29418.3 |
604 | 2022-04-24 21:17:24 | collier | 2 | 107671 | 89 | 3.016 | 35699.9 |
603 | 2022-04-24 02:50:09 | collier | 2 | 107671 | 89 | 3.313 | 32499.5 |
602 | 2022-04-23 09:46:59 | collier | 2 | 107671 | 89 | 2.876 | 37437.8 |
601 | 2022-04-22 12:09:58 | collier | 2 | 107671 | 89 | 4.110 | 26197.3 |