History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"homes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
755 | 2024-04-17 02:59:01 | homes | 1 | 28756 | 24 | 0.733 | 39230.6 |
754 | 2024-04-03 03:53:30 | homes | 1 | 28756 | 24 | 1.250 | 23004.8 |
753 | 2024-03-31 07:50:10 | homes | 1 | 28756 | 24 | 1.123 | 25606.4 |
752 | 2024-03-27 01:11:51 | homes | 1 | 28756 | 24 | 0.513 | 56054.6 |
751 | 2024-03-22 05:38:19 | homes | 1 | 28756 | 24 | 0.580 | 49579.3 |
750 | 2024-03-06 03:33:54 | homes | 1 | 28756 | 24 | 0.580 | 49579.3 |
749 | 2024-03-04 00:13:40 | homes | 1 | 28756 | 24 | 1.690 | 17015.4 |
748 | 2024-02-25 17:27:26 | homes | 1 | 28756 | 24 | 1.203 | 23903.6 |
747 | 2024-02-15 14:01:36 | homes | 1 | 28756 | 24 | 0.563 | 51076.4 |
746 | 2024-01-26 05:08:57 | homes | 1 | 28756 | 24 | 0.483 | 59536.2 |
745 | 2024-01-24 05:29:24 | homes | 1 | 28756 | 24 | 0.420 | 68466.7 |
744 | 2024-01-07 16:39:53 | homes | 2 | 53800 | 361 | 1.376 | 39098.8 |
743 | 2023-12-01 03:03:56 | homes | 2 | 53800 | 361 | 1.673 | 32157.8 |
742 | 2023-11-29 04:16:57 | homes | 1 | 28756 | 24 | 1.390 | 20687.8 |
741 | 2023-11-21 18:24:28 | homes | 2 | 53800 | 361 | 1.470 | 36598.6 |
740 | 2023-11-18 15:12:16 | homes | 2 | 53800 | 361 | 1.516 | 35488.1 |
739 | 2023-11-10 11:59:30 | homes | 1 | 28756 | 24 | 0.483 | 59536.2 |
738 | 2023-11-09 03:28:37 | homes | 1 | 28756 | 24 | 0.436 | 65954.1 |
737 | 2023-11-07 10:53:08 | homes | 1 | 28756 | 24 | 1.126 | 25538.2 |
736 | 2023-11-07 10:53:01 | homes | 1 | 28756 | 24 | 0.563 | 51076.4 |
735 | 2023-10-27 00:43:46 | homes | 1 | 28756 | 24 | 0.580 | 49579.3 |
734 | 2023-10-20 09:40:01 | homes | 2 | 53800 | 361 | 3.733 | 14412.0 |
733 | 2023-10-19 20:39:11 | homes | 1 | 28756 | 24 | 0.986 | 29164.3 |
732 | 2023-10-17 08:46:25 | homes | 1 | 28756 | 24 | 0.483 | 59536.2 |
731 | 2023-10-17 08:12:30 | homes | 2 | 53800 | 361 | 1.736 | 30990.8 |
730 | 2023-10-16 20:36:58 | homes | 2 | 53800 | 361 | 1.670 | 32215.6 |
729 | 2023-10-15 10:08:06 | homes | 2 | 53800 | 361 | 1.530 | 35163.4 |
728 | 2023-10-12 07:01:08 | homes | 1 | 28756 | 24 | 0.436 | 65954.1 |
727 | 2023-10-10 20:44:18 | homes | 2 | 53800 | 361 | 1.560 | 34487.2 |
726 | 2023-10-09 10:37:41 | homes | 1 | 28756 | 24 | 0.436 | 65954.1 |
725 | 2023-10-04 00:11:15 | homes | 1 | 28756 | 24 | 0.563 | 51076.4 |
724 | 2023-09-23 06:28:13 | homes | 1 | 28756 | 24 | 0.453 | 63479.0 |
723 | 2023-09-10 23:40:56 | homes | 1 | 28756 | 24 | 0.453 | 63479.0 |
722 | 2023-08-31 20:55:40 | homes | 2 | 53800 | 361 | 1.626 | 33087.3 |
721 | 2023-07-26 23:19:06 | homes | 2 | 53800 | 361 | 1.686 | 31909.8 |
720 | 2023-07-07 03:52:07 | homes | 1 | 28756 | 24 | 0.436 | 65954.1 |
719 | 2023-04-07 02:46:38 | homes | 1 | 28756 | 24 | 0.483 | 59536.2 |
718 | 2023-04-06 11:27:26 | homes | 2 | 53800 | 361 | 1.343 | 40059.6 |
717 | 2023-03-03 02:05:21 | homes | 1 | 28756 | 24 | 0.420 | 68466.7 |
716 | 2023-01-03 05:56:02 | homes | 2 | 53800 | 361 | 1.343 | 40059.6 |
715 | 2023-01-01 20:50:14 | homes | 1 | 28756 | 24 | 0.530 | 54256.6 |
714 | 2022-09-21 22:48:39 | homes | 1 | 28756 | 24 | 0.440 | 65354.5 |
713 | 2022-09-16 00:19:21 | homes | 1 | 28756 | 24 | 0.436 | 65954.1 |
712 | 2022-09-06 18:39:39 | homes | 2 | 53800 | 361 | 1.343 | 40059.6 |
711 | 2022-08-16 01:26:44 | homes | 1 | 28756 | 24 | 0.483 | 59536.2 |
710 | 2022-07-30 10:57:58 | homes | 1 | 28756 | 24 | 0.483 | 59536.2 |
709 | 2022-06-15 19:52:31 | homes | 1 | 28756 | 24 | 0.466 | 61708.2 |
708 | 2022-04-23 23:50:19 | homes | 1 | 28756 | 24 | 0.453 | 63479.0 |
707 | 2022-04-05 14:48:18 | homes | 2 | 53800 | 361 | 1.486 | 36204.6 |
706 | 2022-03-15 21:53:13 | homes | 1 | 28756 | 24 | 0.470 | 61183.0 |
705 | 2022-03-10 16:59:22 | homes | 1 | 28756 | 24 | 0.576 | 49923.6 |
704 | 2022-01-19 16:29:40 | homes | 1 | 28756 | 24 | 0.516 | 55728.7 |
703 | 2022-01-10 10:07:08 | homes | 1 | 28756 | 24 | 0.530 | 54256.6 |
702 | 2021-12-23 04:18:35 | homes | 1 | 28756 | 24 | 0.546 | 52666.7 |
701 | 2021-12-07 02:04:32 | homes | 1 | 28756 | 24 | 0.470 | 61183.0 |
700 | 2021-12-03 19:28:03 | homes | 1 | 28756 | 24 | 0.893 | 32201.6 |
699 | 2021-11-15 09:21:30 | homes | 1 | 28756 | 24 | 0.513 | 56054.6 |
698 | 2021-11-09 00:17:53 | homes | 1 | 28756 | 24 | 0.500 | 57512.0 |
697 | 2021-11-08 07:15:13 | homes | 1 | 28756 | 24 | 0.486 | 59168.7 |
696 | 2021-10-07 08:10:22 | homes | 1 | 28756 | 24 | 0.486 | 59168.7 |
695 | 2021-10-05 05:28:19 | homes | 1 | 28756 | 24 | 0.486 | 59168.7 |
694 | 2021-08-31 16:56:53 | homes | 1 | 28756 | 24 | 0.563 | 51076.4 |
693 | 2021-08-30 17:22:18 | homes | 1 | 28756 | 24 | 0.563 | 51076.4 |
692 | 2021-08-14 06:32:44 | homes | 1 | 28756 | 24 | 0.440 | 65354.5 |
691 | 2021-06-10 23:50:39 | homes | 1 | 28756 | 24 | 0.530 | 54256.6 |
690 | 2021-05-30 00:34:37 | homes | 1 | 28756 | 24 | 0.516 | 55728.7 |
689 | 2021-03-20 07:05:00 | homes | 1 | 28756 | 24 | 0.470 | 61183.0 |
688 | 2021-03-19 09:54:06 | homes | 1 | 28756 | 24 | 0.483 | 59536.2 |
687 | 2021-02-27 09:27:22 | homes | 1 | 28756 | 24 | 0.450 | 63902.2 |
686 | 2021-02-22 21:01:56 | homes | 1 | 28756 | 24 | 0.453 | 63479.0 |
685 | 2021-02-19 20:16:08 | homes | 1 | 28756 | 24 | 0.530 | 54256.6 |
684 | 2021-02-15 13:23:23 | homes | 1 | 28756 | 24 | 0.440 | 65354.5 |
683 | 2021-01-29 22:29:01 | homes | 1 | 28756 | 24 | 0.453 | 63479.0 |
682 | 2021-01-01 17:20:18 | homes | 1 | 28756 | 24 | 0.546 | 52666.7 |
681 | 2020-12-03 04:30:10 | homes | 1 | 28756 | 24 | 0.470 | 61183.0 |
680 | 2020-11-22 16:52:40 | homes | 1 | 28756 | 24 | 0.436 | 65954.1 |
679 | 2020-10-17 09:41:08 | homes | 1 | 28756 | 24 | 0.500 | 57512.0 |
678 | 2020-10-15 00:40:59 | homes | 1 | 28756 | 24 | 0.453 | 63479.0 |
677 | 2020-10-05 21:42:54 | homes | 1 | 28756 | 24 | 0.420 | 68466.7 |
676 | 2020-08-30 20:21:34 | homes | 1 | 28756 | 24 | 0.466 | 61708.2 |
675 | 2020-08-29 01:43:18 | homes | 1 | 28756 | 24 | 0.560 | 51350.0 |
674 | 2020-08-18 08:17:21 | homes | 1 | 28756 | 24 | 0.516 | 55728.7 |
673 | 2020-08-01 01:27:05 | homes | 1 | 28756 | 24 | 0.470 | 61183.0 |
672 | 2020-07-18 14:16:45 | homes | 1 | 28756 | 24 | 0.470 | 61183.0 |
671 | 2020-07-17 14:24:02 | homes | 1 | 28756 | 24 | 0.500 | 57512.0 |
670 | 2020-07-16 14:15:16 | homes | 1 | 28756 | 24 | 0.466 | 61708.2 |
669 | 2020-07-15 13:50:15 | homes | 1 | 28756 | 24 | 0.466 | 61708.2 |
668 | 2020-07-13 11:51:38 | homes | 1 | 28756 | 24 | 0.470 | 61183.0 |
667 | 2020-05-30 04:43:47 | homes | 1 | 28756 | 24 | 0.453 | 63479.0 |
666 | 2020-05-17 02:35:04 | homes | 1 | 28756 | 24 | 0.486 | 59168.7 |
665 | 2020-03-27 07:09:03 | homes | 1 | 28756 | 24 | 0.513 | 56054.6 |
664 | 2020-03-24 17:12:20 | homes | 1 | 28756 | 24 | 0.436 | 65954.1 |
663 | 2020-03-23 17:12:46 | homes | 1 | 28756 | 24 | 0.516 | 55728.7 |
662 | 2020-03-22 00:33:35 | homes | 1 | 28756 | 24 | 0.500 | 57512.0 |
661 | 2020-03-21 15:49:16 | homes | 1 | 28756 | 24 | 0.500 | 57512.0 |
660 | 2020-03-21 01:39:10 | homes | 1 | 28756 | 24 | 0.500 | 57512.0 |
659 | 2020-03-18 03:32:03 | homes | 1 | 28756 | 24 | 0.516 | 55728.7 |
658 | 2020-02-27 13:30:11 | homes | 1 | 28756 | 24 | 1.140 | 25224.6 |
657 | 2020-02-26 23:28:42 | homes | 1 | 28756 | 24 | 0.686 | 41918.4 |
656 | 2020-02-17 18:55:13 | homes | 1 | 28756 | 24 | 1.123 | 25606.4 |