History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sewer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
965 | 2024-04-26 23:16:31 | sewer | 1 | 28756 | 18 | 1.140 | 25224.6 |
964 | 2024-04-18 20:03:37 | sewer | 2 | 53800 | 179 | 1.670 | 32215.6 |
963 | 2024-04-03 02:18:11 | sewer | 1 | 28756 | 18 | 0.546 | 52666.7 |
962 | 2024-03-31 05:06:50 | sewer | 2 | 53800 | 179 | 5.220 | 10306.5 |
961 | 2024-03-31 04:10:20 | sewer | 1 | 28756 | 18 | 0.546 | 52666.7 |
960 | 2024-03-30 21:03:07 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
959 | 2024-03-29 01:39:15 | sewer | 1 | 28756 | 18 | 1.343 | 21411.8 |
958 | 2024-03-03 21:19:23 | sewer | 1 | 28756 | 18 | 1.000 | 28756.0 |
957 | 2024-02-28 10:22:55 | sewer | 1 | 28756 | 18 | 0.750 | 38341.3 |
956 | 2024-02-28 05:23:03 | sewer | 2 | 53800 | 179 | 3.533 | 15227.9 |
955 | 2024-02-27 22:10:04 | sewer | 2 | 53800 | 179 | 2.953 | 18218.8 |
954 | 2024-02-27 21:02:37 | sewer | 1 | 28756 | 18 | 0.500 | 57512.0 |
953 | 2024-01-28 23:45:05 | sewer | 1 | 28756 | 18 | 0.436 | 65954.1 |
952 | 2024-01-09 05:37:13 | sewer | 1 | 28756 | 18 | 0.546 | 52666.7 |
951 | 2024-01-05 20:29:23 | sewer | 2 | 53800 | 179 | 1.500 | 35866.7 |
950 | 2023-12-18 15:08:17 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
949 | 2023-12-14 10:07:31 | sewer | 2 | 53800 | 179 | 1.890 | 28465.6 |
948 | 2023-12-02 12:56:05 | sewer | 1 | 28756 | 18 | 0.483 | 59536.2 |
947 | 2023-11-30 04:20:41 | sewer | 2 | 53800 | 179 | 1.390 | 38705.0 |
946 | 2023-11-14 09:54:49 | sewer | 1 | 28756 | 18 | 0.500 | 57512.0 |
945 | 2023-11-10 12:38:35 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
944 | 2023-11-04 09:21:46 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
943 | 2023-10-23 18:43:11 | sewer | 1 | 28756 | 18 | 0.516 | 55728.7 |
942 | 2023-10-18 15:18:51 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
941 | 2023-10-14 02:08:42 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
940 | 2023-10-04 23:54:00 | sewer | 1 | 28756 | 18 | 0.466 | 61708.2 |
939 | 2023-10-04 16:20:32 | sewer | 1 | 28756 | 18 | 0.516 | 55728.7 |
938 | 2023-09-25 11:51:11 | sewer | 1 | 28756 | 18 | 1.393 | 20643.2 |
937 | 2023-09-25 11:51:05 | sewer | 1 | 28756 | 18 | 0.576 | 49923.6 |
936 | 2023-09-23 22:57:42 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
935 | 2023-09-14 16:16:18 | sewer | 2 | 53800 | 179 | 2.093 | 25704.7 |
934 | 2023-09-06 10:29:13 | sewer | 1 | 28756 | 18 | 0.500 | 57512.0 |
933 | 2023-08-01 23:41:39 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
932 | 2023-07-28 16:33:20 | sewer | 2 | 53800 | 179 | 1.750 | 30742.9 |
931 | 2023-07-26 18:13:17 | sewer | 2 | 53800 | 179 | 1.576 | 34137.1 |
930 | 2023-07-25 00:04:04 | sewer | 2 | 53800 | 179 | 1.623 | 33148.5 |
929 | 2023-07-21 10:23:59 | sewer | 2 | 53800 | 179 | 1.736 | 30990.8 |
928 | 2023-07-20 23:11:35 | sewer | 2 | 53800 | 179 | 3.500 | 15371.4 |
927 | 2023-07-19 23:03:38 | sewer | 2 | 53800 | 179 | 1.750 | 30742.9 |
926 | 2023-07-18 19:37:44 | sewer | 2 | 53800 | 179 | 1.640 | 32804.9 |
925 | 2023-07-12 15:23:21 | sewer | 2 | 53800 | 179 | 1.546 | 34799.5 |
924 | 2023-07-11 20:58:38 | sewer | 2 | 53800 | 179 | 1.750 | 30742.9 |
923 | 2023-06-18 09:22:26 | sewer | 2 | 53800 | 179 | 1.576 | 34137.1 |
922 | 2023-05-20 14:47:03 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
921 | 2023-04-28 00:58:48 | sewer | 1 | 28756 | 18 | 0.456 | 63061.4 |
920 | 2023-04-09 11:06:27 | sewer | 2 | 53800 | 179 | 1.406 | 38264.6 |
919 | 2023-03-14 08:58:53 | sewer | 2 | 53800 | 179 | 1.580 | 34050.6 |
918 | 2023-02-18 08:02:04 | sewer | 1 | 28756 | 18 | 0.500 | 57512.0 |
917 | 2023-02-05 01:55:03 | sewer | 2 | 53800 | 179 | 1.626 | 33087.3 |
916 | 2023-02-03 18:42:13 | sewer | 1 | 28756 | 18 | 0.436 | 65954.1 |
915 | 2023-01-17 08:41:52 | sewer | 1 | 28756 | 18 | 0.500 | 57512.0 |
914 | 2022-12-19 19:01:24 | sewer | 2 | 53800 | 179 | 1.580 | 34050.6 |
913 | 2022-12-16 23:12:15 | sewer | 2 | 53800 | 179 | 1.390 | 38705.0 |
912 | 2022-12-16 09:40:21 | sewer | 1 | 28756 | 18 | 0.873 | 32939.3 |
911 | 2022-12-02 00:24:18 | sewer | 2 | 53800 | 179 | 1.686 | 31909.8 |
910 | 2022-11-29 23:45:02 | sewer | 2 | 53800 | 179 | 1.656 | 32487.9 |
909 | 2022-11-27 23:45:21 | sewer | 2 | 53800 | 179 | 1.673 | 32157.8 |
908 | 2022-11-07 13:11:37 | sewer | 2 | 53800 | 179 | 1.576 | 34137.1 |
907 | 2022-10-13 14:03:06 | sewer | 1 | 28756 | 18 | 0.470 | 61183.0 |
906 | 2022-08-23 18:29:38 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
905 | 2022-08-16 05:27:07 | sewer | 2 | 53800 | 179 | 1.563 | 34421.0 |
904 | 2022-07-18 00:10:01 | sewer | 1 | 28756 | 18 | 0.440 | 65354.5 |
903 | 2022-07-06 09:27:58 | sewer | 1 | 28756 | 18 | 0.516 | 55728.7 |
902 | 2022-07-04 04:09:49 | sewer | 2 | 53800 | 179 | 1.453 | 37026.8 |
901 | 2022-07-03 16:11:59 | sewer | 1 | 28756 | 18 | 0.453 | 63479.0 |
900 | 2022-07-03 04:21:18 | sewer | 1 | 28756 | 18 | 0.530 | 54256.6 |
899 | 2022-06-19 12:03:32 | sewer | 1 | 28756 | 18 | 0.440 | 65354.5 |
898 | 2022-06-08 23:49:18 | sewer | 1 | 28756 | 18 | 0.466 | 61708.2 |
897 | 2022-05-11 14:27:58 | sewer | 2 | 53800 | 179 | 1.563 | 34421.0 |
896 | 2022-05-10 19:03:14 | sewer | 2 | 53800 | 179 | 1.640 | 32804.9 |
895 | 2022-05-05 23:05:44 | sewer | 2 | 53800 | 179 | 1.626 | 33087.3 |
894 | 2022-05-04 20:19:55 | sewer | 2 | 53800 | 179 | 1.533 | 35094.6 |
893 | 2022-05-03 23:29:31 | sewer | 2 | 53800 | 179 | 1.640 | 32804.9 |
892 | 2022-05-01 19:44:15 | sewer | 2 | 53800 | 179 | 1.406 | 38264.6 |
891 | 2022-04-30 19:40:07 | sewer | 2 | 53800 | 179 | 1.673 | 32157.8 |
890 | 2022-04-29 15:46:55 | sewer | 2 | 53800 | 179 | 2.406 | 22360.8 |
889 | 2022-04-28 19:45:23 | sewer | 2 | 53800 | 179 | 1.656 | 32487.9 |
888 | 2022-04-09 14:03:11 | sewer | 1 | 28756 | 18 | 0.500 | 57512.0 |
887 | 2022-03-20 22:42:03 | sewer | 2 | 53800 | 179 | 1.596 | 33709.3 |
886 | 2022-03-15 13:17:49 | sewer | 1 | 28756 | 18 | 0.593 | 48492.4 |
885 | 2022-03-14 21:13:50 | sewer | 1 | 28756 | 18 | 0.546 | 52666.7 |
884 | 2022-03-13 21:16:23 | sewer | 1 | 28756 | 18 | 0.550 | 52283.6 |
883 | 2022-03-12 19:48:18 | sewer | 1 | 28756 | 18 | 0.563 | 51076.4 |
882 | 2022-03-01 13:53:10 | sewer | 2 | 53800 | 179 | 1.810 | 29723.8 |
881 | 2022-02-28 20:58:47 | sewer | 2 | 53800 | 179 | 1.716 | 31352.0 |
880 | 2022-02-28 07:52:44 | sewer | 2 | 53800 | 179 | 1.516 | 35488.1 |
879 | 2022-02-27 12:39:39 | sewer | 2 | 53800 | 179 | 1.670 | 32215.6 |
878 | 2022-02-26 07:20:48 | sewer | 2 | 53800 | 179 | 1.656 | 32487.9 |
877 | 2022-02-25 16:26:00 | sewer | 2 | 53800 | 179 | 1.780 | 30224.7 |
876 | 2022-02-25 06:30:32 | sewer | 2 | 53800 | 179 | 1.720 | 31279.1 |
875 | 2022-02-25 00:48:12 | sewer | 1 | 28756 | 18 | 0.546 | 52666.7 |
874 | 2022-02-24 09:33:40 | sewer | 2 | 53800 | 179 | 1.576 | 34137.1 |
873 | 2022-02-23 20:03:34 | sewer | 2 | 53800 | 179 | 1.546 | 34799.5 |
872 | 2022-02-22 20:06:09 | sewer | 2 | 53800 | 179 | 1.483 | 36277.8 |
871 | 2022-02-21 11:10:19 | sewer | 2 | 53800 | 179 | 1.750 | 30742.9 |
870 | 2022-02-20 15:26:57 | sewer | 2 | 53800 | 179 | 1.423 | 37807.4 |
869 | 2022-02-19 11:58:10 | sewer | 2 | 53800 | 179 | 1.610 | 33416.1 |
868 | 2022-02-18 10:35:43 | sewer | 2 | 53800 | 179 | 1.580 | 34050.6 |
867 | 2022-02-17 14:34:58 | sewer | 2 | 53800 | 179 | 1.640 | 32804.9 |
866 | 2022-02-16 19:57:55 | sewer | 2 | 53800 | 179 | 1.423 | 37807.4 |