History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yardarm"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1006 | 2024-04-10 07:12:19 | yardarm | 1 | 69583 | 2 | 1.263 | 55093.4 |
1005 | 2024-04-10 05:50:36 | yardarm | 4 | 151207 | 1057 | 19.593 | 7717.4 |
1004 | 2024-04-07 19:45:55 | yardarm | 4 | 151207 | 1057 | 22.206 | 6809.3 |
1003 | 2024-04-06 06:38:38 | yardarm | 3 | 134027 | 73 | 11.860 | 11300.8 |
1002 | 2024-04-04 07:00:17 | yardarm | 2 | 107671 | 7 | 10.970 | 9815.0 |
1001 | 2024-04-04 06:54:36 | yardarm | 3 | 134027 | 73 | 8.953 | 14970.1 |
1000 | 2024-04-03 15:29:37 | yardarm | 4 | 151207 | 1057 | 39.956 | 3784.3 |
999 | 2024-04-02 18:44:56 | yardarm | 3 | 134027 | 73 | 15.500 | 8646.9 |
998 | 2024-04-01 13:01:02 | yardarm | 4 | 151207 | 1057 | 12.923 | 11700.6 |
997 | 2024-04-01 09:10:56 | yardarm | 4 | 151207 | 1057 | 33.300 | 4540.8 |
996 | 2024-04-01 09:10:53 | yardarm | 3 | 134027 | 73 | 21.533 | 6224.3 |
995 | 2024-04-01 09:11:08 | yardarm | 1 | 69583 | 2 | 3.936 | 17678.6 |
994 | 2024-04-01 09:10:53 | yardarm | 2 | 107671 | 7 | 3.843 | 28017.4 |
993 | 2024-04-01 09:10:46 | yardarm | 1 | 69583 | 2 | 2.720 | 25582.0 |
992 | 2024-02-29 00:46:11 | yardarm | 1 | 69583 | 2 | 1.173 | 59320.5 |
991 | 2024-01-27 17:26:45 | yardarm | 4 | 151207 | 1057 | 14.860 | 10175.4 |
990 | 2024-01-27 17:14:11 | yardarm | 4 | 151207 | 1057 | 18.860 | 8017.3 |
989 | 2024-01-25 13:05:37 | yardarm | 1 | 69583 | 2 | 1.080 | 64428.7 |
988 | 2024-01-09 03:49:50 | yardarm | 2 | 107671 | 7 | 2.860 | 37647.2 |
987 | 2023-12-31 08:36:44 | yardarm | 4 | 151207 | 1057 | 10.390 | 14553.1 |
986 | 2023-12-29 12:17:10 | yardarm | 1 | 69583 | 2 | 1.030 | 67556.3 |
985 | 2023-12-25 10:15:45 | yardarm | 4 | 151207 | 1057 | 10.563 | 14314.8 |
984 | 2023-12-20 22:42:47 | yardarm | 1 | 69583 | 2 | 1.236 | 56296.9 |
983 | 2023-12-06 19:23:38 | yardarm | 3 | 134027 | 73 | 5.830 | 22989.2 |
982 | 2023-12-02 05:45:55 | yardarm | 4 | 151207 | 1057 | 13.843 | 10923.0 |
981 | 2023-12-02 05:45:51 | yardarm | 3 | 134027 | 73 | 6.936 | 19323.4 |
980 | 2023-12-02 05:45:49 | yardarm | 2 | 107671 | 7 | 4.063 | 26500.4 |
979 | 2023-11-12 09:29:29 | yardarm | 1 | 69583 | 2 | 1.123 | 61961.7 |
978 | 2023-11-10 03:40:11 | yardarm | 1 | 69583 | 2 | 2.656 | 26198.4 |
977 | 2023-11-01 12:03:11 | yardarm | 1 | 69583 | 2 | 1.140 | 61037.7 |
976 | 2023-10-26 17:29:50 | yardarm | 4 | 151207 | 1057 | 15.156 | 9976.7 |
975 | 2023-10-26 17:29:36 | yardarm | 3 | 134027 | 73 | 8.530 | 15712.4 |
974 | 2023-10-20 12:59:24 | yardarm | 3 | 134027 | 73 | 8.110 | 16526.1 |
973 | 2023-10-20 00:58:30 | yardarm | 4 | 151207 | 1057 | 11.953 | 12650.1 |
972 | 2023-10-19 10:44:10 | yardarm | 4 | 151207 | 1057 | 11.063 | 13667.8 |
971 | 2023-10-18 21:53:07 | yardarm | 1 | 69583 | 2 | 1.123 | 61961.7 |
970 | 2023-10-17 09:49:02 | yardarm | 1 | 69583 | 2 | 1.190 | 58473.1 |
969 | 2023-10-17 09:47:21 | yardarm | 3 | 134027 | 73 | 16.986 | 7890.4 |
968 | 2023-10-17 09:39:59 | yardarm | 4 | 151207 | 1057 | 44.610 | 3389.5 |
967 | 2023-10-17 01:14:00 | yardarm | 2 | 107671 | 7 | 2.906 | 37051.3 |
966 | 2023-10-11 09:21:49 | yardarm | 3 | 134027 | 73 | 9.500 | 14108.1 |
965 | 2023-10-11 09:15:25 | yardarm | 4 | 151207 | 1057 | 13.250 | 11411.8 |
964 | 2023-10-11 08:16:52 | yardarm | 1 | 69583 | 2 | 1.343 | 51811.6 |
963 | 2023-10-04 10:05:32 | yardarm | 4 | 151207 | 1057 | 10.346 | 14615.0 |
962 | 2023-10-04 01:39:08 | yardarm | 3 | 134027 | 73 | 8.143 | 16459.2 |
961 | 2023-10-04 01:38:36 | yardarm | 1 | 69583 | 2 | 1.013 | 68690.0 |
960 | 2023-09-23 04:13:46 | yardarm | 1 | 69583 | 2 | 1.110 | 62687.4 |
959 | 2023-09-22 20:40:48 | yardarm | 3 | 134027 | 73 | 15.890 | 8434.7 |
958 | 2023-09-11 02:49:03 | yardarm | 1 | 69583 | 2 | 1.046 | 66522.9 |
957 | 2023-09-10 19:19:12 | yardarm | 3 | 134027 | 73 | 12.813 | 10460.2 |
956 | 2023-09-04 06:42:19 | yardarm | 3 | 134027 | 73 | 5.626 | 23822.8 |
955 | 2023-08-21 17:28:40 | yardarm | 1 | 69583 | 2 | 1.203 | 57841.2 |
954 | 2023-08-15 02:50:00 | yardarm | 1 | 69583 | 2 | 1.060 | 65644.3 |
953 | 2023-08-01 18:27:53 | yardarm | 4 | 151207 | 1057 | 16.673 | 9069.0 |
952 | 2023-07-28 05:13:41 | yardarm | 2 | 107671 | 7 | 5.780 | 18628.2 |
951 | 2023-07-15 14:28:07 | yardarm | 4 | 151207 | 1057 | 11.283 | 13401.3 |
950 | 2023-06-08 10:31:57 | yardarm | 4 | 151207 | 1057 | 9.656 | 15659.4 |
949 | 2023-05-16 19:07:45 | yardarm | 1 | 69583 | 2 | 1.030 | 67556.3 |
948 | 2023-04-05 07:51:53 | yardarm | 2 | 107671 | 7 | 3.313 | 32499.5 |
947 | 2023-04-04 17:16:01 | yardarm | 1 | 69583 | 2 | 1.156 | 60192.9 |
946 | 2023-04-01 23:12:59 | yardarm | 4 | 151207 | 1057 | 10.986 | 13763.6 |
945 | 2023-03-10 06:25:56 | yardarm | 1 | 69583 | 2 | 1.080 | 64428.7 |
944 | 2023-01-02 11:01:18 | yardarm | 2 | 107671 | 7 | 2.783 | 38688.8 |
943 | 2022-12-31 12:57:28 | yardarm | 1 | 69583 | 2 | 1.063 | 65459.1 |
942 | 2022-12-27 13:27:00 | yardarm | 4 | 151207 | 1057 | 10.860 | 13923.3 |
941 | 2022-12-16 01:39:26 | yardarm | 3 | 134027 | 73 | 5.623 | 23835.5 |
940 | 2022-11-16 06:20:02 | yardarm | 1 | 69583 | 2 | 1.046 | 66522.9 |
939 | 2022-10-23 10:00:44 | yardarm | 4 | 151207 | 1057 | 9.546 | 15839.8 |
938 | 2022-10-05 08:38:57 | yardarm | 4 | 151207 | 1057 | 9.686 | 15610.9 |
937 | 2022-09-24 19:35:23 | yardarm | 1 | 69583 | 2 | 1.096 | 63488.1 |
936 | 2022-09-11 22:33:03 | yardarm | 4 | 151207 | 1057 | 10.690 | 14144.7 |
935 | 2022-09-04 08:01:11 | yardarm | 2 | 107671 | 7 | 2.826 | 38100.1 |
934 | 2022-08-27 11:31:44 | yardarm | 4 | 151207 | 1057 | 10.266 | 14728.9 |
933 | 2022-08-05 19:15:33 | yardarm | 3 | 134027 | 73 | 6.656 | 20136.3 |
932 | 2022-08-03 10:44:52 | yardarm | 3 | 134027 | 73 | 5.733 | 23378.2 |
931 | 2022-06-26 19:41:27 | yardarm | 4 | 151207 | 1057 | 10.673 | 14167.2 |
930 | 2022-06-13 11:43:26 | yardarm | 1 | 69583 | 2 | 1.050 | 66269.5 |
929 | 2022-05-09 06:47:51 | yardarm | 4 | 151207 | 1057 | 10.186 | 14844.6 |
928 | 2022-05-06 23:31:55 | yardarm | 4 | 151207 | 1057 | 10.346 | 14615.0 |
927 | 2022-05-06 09:02:28 | yardarm | 1 | 69583 | 2 | 1.063 | 65459.1 |
926 | 2022-04-09 15:26:26 | yardarm | 4 | 151207 | 1057 | 9.813 | 15408.8 |
925 | 2022-03-26 19:39:09 | yardarm | 4 | 151207 | 1057 | 11.033 | 13705.0 |
924 | 2022-03-04 23:17:31 | yardarm | 3 | 134027 | 73 | 5.656 | 23696.4 |
923 | 2022-01-27 11:35:46 | yardarm | 1 | 69583 | 2 | 1.046 | 66522.9 |
922 | 2022-01-25 07:35:54 | yardarm | 1 | 69583 | 2 | 1.143 | 60877.5 |
921 | 2022-01-17 11:56:54 | yardarm | 4 | 151207 | 1057 | 11.720 | 12901.6 |
920 | 2022-01-16 08:29:07 | yardarm | 4 | 151207 | 1057 | 19.830 | 7625.2 |
919 | 2022-01-15 14:29:09 | yardarm | 4 | 151207 | 1057 | 11.346 | 13326.9 |
918 | 2022-01-14 16:12:09 | yardarm | 4 | 151207 | 1057 | 10.096 | 14976.9 |
917 | 2022-01-09 08:10:37 | yardarm | 1 | 69583 | 2 | 1.250 | 55666.4 |
916 | 2021-12-15 18:51:47 | yardarm | 4 | 151207 | 1057 | 11.610 | 13023.9 |
915 | 2021-12-12 22:29:58 | yardarm | 4 | 151207 | 1057 | 11.566 | 13073.4 |
914 | 2021-12-11 14:04:32 | yardarm | 4 | 151207 | 1057 | 10.766 | 14044.9 |
913 | 2021-11-25 20:35:50 | yardarm | 4 | 151207 | 1057 | 10.343 | 14619.3 |
912 | 2021-11-18 16:30:12 | yardarm | 1 | 69583 | 2 | 1.076 | 64668.2 |
911 | 2021-10-09 07:54:05 | yardarm | 4 | 151207 | 1057 | 10.406 | 14530.8 |
910 | 2021-10-08 13:37:39 | yardarm | 1 | 69583 | 2 | 1.186 | 58670.3 |
909 | 2021-10-07 10:52:46 | yardarm | 4 | 151207 | 1057 | 11.233 | 13461.0 |
908 | 2021-10-06 12:20:21 | yardarm | 1 | 69583 | 2 | 1.186 | 58670.3 |
907 | 2021-10-06 10:47:52 | yardarm | 4 | 151207 | 1057 | 10.266 | 14728.9 |