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 |
871 | 2025-07-05 04:47:12 | calif | 3 | 83667 | 1237 | 13.783 | 6070.3 |
870 | 2025-07-05 02:53:53 | calif | 3 | 83667 | 1237 | 14.423 | 5800.9 |
869 | 2025-07-04 20:49:04 | calif | 3 | 83667 | 1237 | 30.000 | 2788.9 |
868 | 2025-07-04 08:26:38 | calif | 3 | 83667 | 1237 | 22.906 | 3652.6 |
867 | 2025-06-30 02:34:46 | calif | 1 | 28756 | 6 | 3.013 | 9544.0 |
866 | 2025-06-29 11:45:04 | calif | 1 | 28756 | 6 | 2.376 | 12102.7 |
865 | 2025-06-29 11:09:49 | calif | 1 | 28756 | 6 | 0.546 | 52666.7 |
864 | 2025-06-19 21:49:34 | calif | 1 | 28756 | 6 | 2.673 | 10757.9 |
863 | 2025-06-18 12:11:43 | calif | 1 | 28756 | 6 | 1.936 | 14853.3 |
862 | 2025-06-16 12:02:36 | calif | 1 | 28756 | 6 | 2.623 | 10963.0 |
861 | 2025-06-15 08:50:20 | calif | 1 | 28756 | 6 | 0.550 | 52283.6 |
860 | 2025-06-10 17:14:18 | calif | 1 | 28756 | 6 | 2.046 | 14054.7 |
859 | 2025-06-09 12:16:37 | calif | 3 | 83667 | 1237 | 4.360 | 19189.7 |
858 | 2025-06-06 22:41:56 | calif | 1 | 28756 | 6 | 2.153 | 13356.2 |
857 | 2025-06-01 23:01:35 | calif | 1 | 28756 | 6 | 2.563 | 11219.7 |
856 | 2025-05-31 01:02:09 | calif | 1 | 28756 | 6 | 2.483 | 11581.2 |
855 | 2025-05-29 15:37:55 | calif | 1 | 28756 | 6 | 1.406 | 20452.3 |
854 | 2025-05-29 13:54:50 | calif | 3 | 83667 | 1237 | 19.906 | 4203.1 |
853 | 2025-05-29 11:48:31 | calif | 1 | 28756 | 6 | 2.640 | 10892.4 |
852 | 2025-05-25 05:48:07 | calif | 1 | 28756 | 6 | 0.516 | 55728.7 |
851 | 2025-05-23 15:39:23 | calif | 1 | 28756 | 6 | 2.123 | 13545.0 |
850 | 2025-05-17 10:09:58 | calif | 3 | 83667 | 1237 | 3.640 | 22985.4 |
849 | 2025-05-16 12:07:21 | calif | 1 | 28756 | 6 | 3.063 | 9388.2 |
848 | 2025-05-14 22:58:51 | calif | 3 | 83667 | 1237 | 13.296 | 6292.6 |
847 | 2025-05-14 17:49:09 | calif | 3 | 83667 | 1237 | 17.750 | 4713.6 |
846 | 2025-05-14 04:12:56 | calif | 3 | 83667 | 1237 | 29.600 | 2826.6 |
845 | 2025-05-13 21:03:06 | calif | 3 | 83667 | 1237 | 10.330 | 8099.4 |
844 | 2025-05-13 07:15:30 | calif | 3 | 83667 | 1237 | 4.110 | 20356.9 |
843 | 2025-05-12 14:34:19 | calif | 3 | 83667 | 1237 | 29.283 | 2857.2 |
842 | 2025-05-10 18:33:47 | calif | 1 | 28756 | 6 | 0.970 | 29645.4 |
841 | 2025-05-10 09:16:10 | calif | 1 | 28756 | 6 | 2.576 | 11163.0 |
840 | 2025-05-09 10:05:49 | calif | 1 | 28756 | 6 | 0.470 | 61183.0 |
839 | 2025-05-08 05:32:35 | calif | 1 | 28756 | 6 | 3.750 | 7668.3 |
838 | 2025-05-03 07:45:19 | calif | 1 | 28756 | 6 | 2.390 | 12031.8 |
837 | 2025-05-01 23:06:37 | calif | 1 | 28756 | 6 | 2.563 | 11219.7 |
836 | 2025-04-29 01:16:13 | calif | 1 | 28756 | 6 | 0.563 | 51076.4 |
835 | 2025-04-28 03:24:05 | calif | 2 | 53800 | 66 | 7.626 | 7054.8 |
834 | 2025-04-27 11:50:00 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
833 | 2025-04-24 20:46:24 | calif | 3 | 83667 | 1237 | 3.766 | 22216.4 |
832 | 2025-04-16 10:50:15 | calif | 1 | 28756 | 6 | 1.000 | 28756.0 |
831 | 2025-04-14 13:52:33 | calif | 3 | 83667 | 1237 | 19.546 | 4280.5 |
830 | 2025-04-14 07:54:17 | calif | 2 | 53800 | 66 | 3.920 | 13724.5 |
829 | 2025-04-14 04:46:23 | calif | 3 | 83667 | 1237 | 23.703 | 3529.8 |
828 | 2025-04-12 17:05:23 | calif | 3 | 83667 | 1237 | 6.470 | 12931.5 |
827 | 2025-04-12 11:34:02 | calif | 3 | 83667 | 1237 | 24.236 | 3452.2 |
826 | 2025-04-10 20:50:48 | calif | 3 | 83667 | 1237 | 26.923 | 3107.6 |
825 | 2025-04-09 04:54:58 | calif | 3 | 83667 | 1237 | 10.470 | 7991.1 |
824 | 2025-04-07 05:28:31 | calif | 1 | 28756 | 6 | 0.533 | 53951.2 |
823 | 2025-03-29 01:39:32 | calif | 1 | 28756 | 6 | 1.470 | 19561.9 |
822 | 2025-03-19 04:16:16 | calif | 1 | 28756 | 6 | 0.513 | 56054.6 |
821 | 2025-03-15 14:26:51 | calif | 1 | 28756 | 6 | 1.530 | 18794.8 |
820 | 2025-03-14 17:53:10 | calif | 3 | 83667 | 1237 | 29.016 | 2883.5 |
819 | 2025-03-11 16:23:24 | calif | 3 | 83667 | 1237 | 20.046 | 4173.8 |
818 | 2025-03-10 00:48:32 | calif | 1 | 28756 | 6 | 1.326 | 21686.3 |
817 | 2025-03-08 17:24:27 | calif | 3 | 83667 | 1237 | 14.593 | 5733.4 |
816 | 2025-03-08 17:10:43 | calif | 3 | 83667 | 1237 | 19.800 | 4225.6 |
815 | 2025-03-07 15:35:04 | calif | 3 | 83667 | 1237 | 17.766 | 4709.4 |
814 | 2025-03-07 15:35:01 | calif | 2 | 53800 | 66 | 8.390 | 6412.4 |
813 | 2025-03-07 15:34:54 | calif | 1 | 28756 | 6 | 1.360 | 21144.1 |
812 | 2025-02-27 22:29:05 | calif | 3 | 83667 | 1237 | 33.706 | 2482.3 |
811 | 2025-02-27 16:39:03 | calif | 2 | 53800 | 66 | 9.646 | 5577.4 |
810 | 2025-02-27 15:28:40 | calif | 3 | 83667 | 1237 | 19.456 | 4300.3 |
809 | 2025-02-27 15:28:44 | calif | 2 | 53800 | 66 | 10.970 | 4904.3 |
808 | 2025-02-27 15:24:04 | calif | 1 | 28756 | 6 | 2.253 | 12763.4 |
807 | 2025-02-26 21:18:53 | calif | 1 | 28756 | 6 | 2.813 | 10222.5 |
806 | 2025-02-24 22:03:40 | calif | 1 | 28756 | 6 | 1.186 | 24246.2 |
805 | 2025-02-20 12:40:58 | calif | 3 | 83667 | 1237 | 18.436 | 4538.2 |
804 | 2025-02-17 05:28:40 | calif | 3 | 83667 | 1237 | 24.140 | 3465.9 |
803 | 2025-02-16 02:06:09 | calif | 3 | 83667 | 1237 | 16.860 | 4962.5 |
802 | 2025-02-15 11:01:17 | calif | 3 | 83667 | 1237 | 9.906 | 8446.1 |
801 | 2025-02-06 11:30:48 | calif | 3 | 83667 | 1237 | 17.250 | 4850.3 |
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 |