History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"calif"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
800 | 2025-02-05 23:43:32 | calif | 1 | 28756 | 6 | 1.470 | 19561.9 |
799 | 2025-02-05 11:47:54 | calif | 3 | 83667 | 1237 | 16.016 | 5224.0 |
798 | 2025-02-05 11:47:51 | calif | 2 | 53800 | 66 | 12.440 | 4324.8 |
797 | 2025-02-05 11:43:00 | calif | 1 | 28756 | 6 | 3.846 | 7476.9 |
796 | 2025-01-28 16:33:56 | calif | 3 | 83667 | 1237 | 14.983 | 5584.1 |
795 | 2025-01-28 10:43:38 | calif | 3 | 83667 | 1237 | 20.566 | 4068.2 |
794 | 2025-01-28 10:43:39 | calif | 2 | 53800 | 66 | 7.016 | 7668.2 |
793 | 2025-01-28 10:21:31 | calif | 1 | 28756 | 6 | 0.436 | 65954.1 |
792 | 2025-01-27 10:30:19 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
791 | 2025-01-27 08:35:51 | calif | 2 | 53800 | 66 | 8.393 | 6410.1 |
790 | 2025-01-27 02:50:16 | calif | 2 | 53800 | 66 | 10.796 | 4983.3 |
789 | 2025-01-26 18:39:32 | calif | 3 | 83667 | 1237 | 20.500 | 4081.3 |
788 | 2025-01-22 07:58:16 | calif | 1 | 28756 | 6 | 2.296 | 12524.4 |
787 | 2025-01-06 01:04:58 | calif | 2 | 53800 | 66 | 1.673 | 32157.8 |
786 | 2025-01-06 01:04:57 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
785 | 2025-01-03 06:45:32 | calif | 3 | 83667 | 1237 | 17.983 | 4652.6 |
784 | 2024-12-30 19:29:51 | calif | 2 | 53800 | 66 | 1.703 | 31591.3 |
783 | 2024-12-30 19:29:25 | calif | 3 | 83667 | 1237 | 5.906 | 14166.4 |
782 | 2024-12-29 15:40:17 | calif | 3 | 83667 | 1237 | 17.816 | 4696.2 |
781 | 2024-12-29 10:00:47 | calif | 3 | 83667 | 1237 | 14.970 | 5589.0 |
780 | 2024-12-29 10:00:48 | calif | 2 | 53800 | 66 | 8.250 | 6521.2 |
779 | 2024-12-29 09:53:07 | calif | 1 | 28756 | 6 | 0.543 | 52957.6 |
778 | 2024-12-28 06:52:34 | calif | 1 | 28756 | 6 | 2.030 | 14165.5 |
777 | 2024-12-07 01:08:45 | calif | 1 | 28756 | 6 | 1.670 | 17219.2 |
776 | 2024-11-29 11:19:51 | calif | 2 | 53800 | 66 | 8.550 | 6292.4 |
775 | 2024-11-29 07:41:08 | calif | 2 | 53800 | 66 | 11.970 | 4494.6 |
774 | 2024-11-29 07:41:05 | calif | 3 | 83667 | 1237 | 11.626 | 7196.5 |
773 | 2024-11-29 06:48:15 | calif | 1 | 28756 | 6 | 0.530 | 54256.6 |
772 | 2024-11-28 22:33:56 | calif | 2 | 53800 | 66 | 8.563 | 6282.8 |
771 | 2024-11-28 03:09:42 | calif | 1 | 28756 | 6 | 0.533 | 53951.2 |
770 | 2024-11-26 05:35:25 | calif | 1 | 28756 | 6 | 2.376 | 12102.7 |
769 | 2024-11-06 22:37:18 | calif | 1 | 28756 | 6 | 3.703 | 7765.6 |
768 | 2024-11-03 14:46:43 | calif | 2 | 53800 | 66 | 8.140 | 6609.3 |
767 | 2024-11-03 14:42:53 | calif | 3 | 83667 | 1237 | 21.563 | 3880.1 |
766 | 2024-11-02 11:13:25 | calif | 2 | 53800 | 66 | 8.343 | 6448.5 |
765 | 2024-11-02 11:12:52 | calif | 3 | 83667 | 1237 | 22.983 | 3640.4 |
764 | 2024-10-30 11:49:41 | calif | 2 | 53800 | 66 | 4.373 | 12302.8 |
763 | 2024-10-30 11:45:11 | calif | 3 | 83667 | 1237 | 4.203 | 19906.5 |
762 | 2024-10-30 05:45:51 | calif | 3 | 83667 | 1237 | 16.186 | 5169.1 |
761 | 2024-10-30 05:45:48 | calif | 2 | 53800 | 66 | 8.173 | 6582.7 |
760 | 2024-10-30 04:41:47 | calif | 1 | 28756 | 6 | 0.516 | 55728.7 |
759 | 2024-10-29 00:24:32 | calif | 1 | 28756 | 6 | 0.513 | 56054.6 |
758 | 2024-10-27 04:56:52 | calif | 1 | 28756 | 6 | 1.093 | 26309.2 |
757 | 2024-10-23 23:02:31 | calif | 1 | 28756 | 6 | 2.610 | 11017.6 |
756 | 2024-10-23 22:56:01 | calif | 1 | 28756 | 6 | 1.656 | 17364.7 |
755 | 2024-10-23 22:55:10 | calif | 3 | 83667 | 1237 | 13.826 | 6051.4 |
754 | 2024-10-23 22:51:22 | calif | 2 | 53800 | 66 | 6.940 | 7752.2 |
753 | 2024-10-23 22:50:21 | calif | 1 | 28756 | 6 | 2.580 | 11145.7 |
752 | 2024-10-15 15:16:54 | calif | 1 | 28756 | 6 | 2.360 | 12184.7 |
751 | 2024-10-07 21:42:41 | calif | 1 | 28756 | 6 | 2.296 | 12524.4 |
750 | 2024-10-02 12:48:59 | calif | 2 | 53800 | 66 | 13.326 | 4037.2 |
749 | 2024-10-01 17:22:48 | calif | 3 | 83667 | 1237 | 26.300 | 3181.3 |
748 | 2024-09-30 23:48:05 | calif | 3 | 83667 | 1237 | 31.280 | 2674.8 |
747 | 2024-09-30 06:27:07 | calif | 3 | 83667 | 1237 | 34.720 | 2409.8 |
746 | 2024-09-30 01:08:50 | calif | 3 | 83667 | 1237 | 31.893 | 2623.4 |
745 | 2024-09-30 01:08:52 | calif | 2 | 53800 | 66 | 12.173 | 4419.6 |
744 | 2024-09-30 00:08:23 | calif | 1 | 28756 | 6 | 0.466 | 61708.2 |
743 | 2024-09-28 19:00:58 | calif | 1 | 28756 | 6 | 3.346 | 8594.1 |
742 | 2024-09-27 00:15:44 | calif | 1 | 28756 | 6 | 4.000 | 7189.0 |
741 | 2024-09-10 04:10:29 | calif | 1 | 28756 | 6 | 3.623 | 7937.1 |
740 | 2024-09-10 04:09:35 | calif | 1 | 28756 | 6 | 6.013 | 4782.3 |
739 | 2024-09-07 12:51:46 | calif | 1 | 28756 | 6 | 2.016 | 14263.9 |
738 | 2024-09-02 19:39:54 | calif | 2 | 53800 | 66 | 9.156 | 5875.9 |
737 | 2024-09-02 19:39:43 | calif | 1 | 28756 | 6 | 3.486 | 8249.0 |
736 | 2024-08-30 19:47:07 | calif | 2 | 53800 | 66 | 13.610 | 3953.0 |
735 | 2024-08-30 19:13:26 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
734 | 2024-08-30 04:49:00 | calif | 1 | 28756 | 6 | 3.330 | 8635.4 |
733 | 2024-08-30 03:08:16 | calif | 3 | 83667 | 1237 | 31.173 | 2684.0 |
732 | 2024-08-29 08:49:27 | calif | 3 | 83667 | 1237 | 26.533 | 3153.3 |
731 | 2024-08-29 08:48:57 | calif | 3 | 83667 | 1237 | 22.110 | 3784.1 |
730 | 2024-08-29 07:47:48 | calif | 3 | 83667 | 1237 | 23.220 | 3603.2 |
729 | 2024-08-29 07:47:47 | calif | 2 | 53800 | 66 | 6.220 | 8649.5 |
728 | 2024-08-29 07:34:24 | calif | 1 | 28756 | 6 | 0.486 | 59168.7 |
727 | 2024-08-13 21:02:35 | calif | 2 | 53800 | 66 | 9.080 | 5925.1 |
726 | 2024-08-11 09:29:37 | calif | 2 | 53800 | 66 | 7.966 | 6753.7 |
725 | 2024-08-08 10:31:30 | calif | 1 | 28756 | 6 | 1.513 | 19005.9 |
724 | 2024-08-07 23:52:46 | calif | 2 | 53800 | 66 | 12.376 | 4347.1 |
723 | 2024-08-06 20:45:39 | calif | 2 | 53800 | 66 | 5.406 | 9951.9 |
722 | 2024-08-06 20:44:24 | calif | 1 | 28756 | 6 | 1.000 | 28756.0 |
721 | 2024-07-31 21:03:52 | calif | 3 | 83667 | 1237 | 8.360 | 10008.0 |
720 | 2024-07-31 15:00:52 | calif | 1 | 28756 | 6 | 2.923 | 9837.8 |
719 | 2024-07-31 14:24:15 | calif | 3 | 83667 | 1237 | 8.843 | 9461.4 |
718 | 2024-07-31 14:24:18 | calif | 2 | 53800 | 66 | 2.920 | 18424.7 |
717 | 2024-07-31 14:14:54 | calif | 1 | 28756 | 6 | 2.643 | 10880.1 |
716 | 2024-07-31 14:09:07 | calif | 3 | 83667 | 1237 | 16.736 | 4999.2 |
715 | 2024-07-31 14:09:07 | calif | 2 | 53800 | 66 | 8.920 | 6031.4 |
714 | 2024-07-31 13:51:35 | calif | 1 | 28756 | 6 | 1.000 | 28756.0 |
713 | 2024-07-31 09:22:12 | calif | 1 | 28756 | 6 | 2.546 | 11294.6 |
712 | 2024-07-30 06:48:24 | calif | 3 | 83667 | 1237 | 7.046 | 11874.4 |
711 | 2024-07-30 04:00:29 | calif | 3 | 83667 | 1237 | 18.920 | 4422.1 |
710 | 2024-07-30 02:23:40 | calif | 2 | 53800 | 66 | 8.890 | 6051.7 |
709 | 2024-07-30 00:09:39 | calif | 3 | 83667 | 1237 | 14.266 | 5864.8 |
708 | 2024-07-30 00:09:36 | calif | 2 | 53800 | 66 | 3.953 | 13609.9 |
707 | 2024-07-29 22:51:15 | calif | 1 | 28756 | 6 | 0.530 | 54256.6 |
706 | 2024-07-28 12:57:44 | calif | 1 | 28756 | 6 | 1.703 | 16885.5 |
705 | 2024-07-27 15:34:35 | calif | 1 | 28756 | 6 | 1.950 | 14746.7 |
704 | 2024-07-22 04:03:24 | calif | 1 | 28756 | 6 | 1.966 | 14626.7 |
703 | 2024-07-10 06:39:10 | calif | 1 | 28756 | 6 | 1.530 | 18794.8 |
702 | 2024-07-06 19:48:25 | calif | 1 | 28756 | 6 | 1.966 | 14626.7 |
701 | 2024-07-03 06:48:16 | calif | 1 | 28756 | 6 | 2.313 | 12432.3 |