History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"soldier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
998 | 2024-04-26 22:55:55 | soldier | 1 | 69583 | 6 | 5.283 | 13171.1 |
997 | 2024-04-26 09:13:49 | soldier | 1 | 69583 | 6 | 1.420 | 49002.1 |
996 | 2024-03-13 17:48:06 | soldier | 1 | 69583 | 6 | 2.610 | 26660.2 |
995 | 2024-02-27 13:15:50 | soldier | 1 | 69583 | 6 | 1.300 | 53525.4 |
994 | 2024-02-07 18:32:22 | soldier | 1 | 69583 | 6 | 1.390 | 50059.7 |
993 | 2024-01-18 04:17:54 | soldier | 2 | 107671 | 62 | 3.623 | 29718.7 |
992 | 2024-01-07 10:35:34 | soldier | 1 | 69583 | 6 | 1.313 | 52995.4 |
991 | 2024-01-05 05:40:49 | soldier | 1 | 69583 | 6 | 1.203 | 57841.2 |
990 | 2023-12-03 04:03:13 | soldier | 1 | 69583 | 6 | 1.156 | 60192.9 |
989 | 2023-12-03 00:04:06 | soldier | 1 | 69583 | 6 | 1.220 | 57035.2 |
988 | 2023-11-29 18:38:25 | soldier | 1 | 69583 | 6 | 1.153 | 60349.5 |
987 | 2023-11-18 19:57:20 | soldier | 1 | 69583 | 6 | 2.656 | 26198.4 |
986 | 2023-11-10 18:12:29 | soldier | 1 | 69583 | 6 | 1.296 | 53690.6 |
985 | 2023-10-30 09:44:05 | soldier | 1 | 69583 | 6 | 1.280 | 54361.7 |
984 | 2023-10-14 06:51:33 | soldier | 1 | 69583 | 6 | 1.123 | 61961.7 |
983 | 2023-09-29 11:26:41 | soldier | 1 | 69583 | 6 | 1.126 | 61796.6 |
982 | 2023-08-23 12:08:01 | soldier | 1 | 69583 | 6 | 1.110 | 62687.4 |
981 | 2023-07-26 14:00:41 | soldier | 1 | 69583 | 6 | 1.250 | 55666.4 |
980 | 2023-05-24 12:37:35 | soldier | 1 | 69583 | 6 | 1.080 | 64428.7 |
979 | 2023-04-03 16:29:12 | soldier | 1 | 69583 | 6 | 1.203 | 57841.2 |
978 | 2023-01-02 23:46:47 | soldier | 2 | 107671 | 62 | 3.623 | 29718.7 |
977 | 2022-12-15 22:37:16 | soldier | 1 | 69583 | 6 | 1.266 | 54962.9 |
976 | 2022-12-08 20:59:45 | soldier | 1 | 69583 | 6 | 1.220 | 57035.2 |
975 | 2022-11-19 22:45:36 | soldier | 1 | 69583 | 6 | 1.110 | 62687.4 |
974 | 2022-11-19 02:02:59 | soldier | 2 | 107671 | 62 | 3.220 | 33438.2 |
973 | 2022-11-05 13:04:49 | soldier | 2 | 107671 | 62 | 2.873 | 37476.9 |
972 | 2022-10-25 23:28:22 | soldier | 2 | 107671 | 62 | 2.910 | 37000.3 |
971 | 2022-10-22 07:42:10 | soldier | 2 | 107671 | 62 | 6.016 | 17897.4 |
970 | 2022-09-12 12:10:47 | soldier | 2 | 107671 | 62 | 2.860 | 37647.2 |
969 | 2022-09-10 21:52:32 | soldier | 1 | 69583 | 6 | 1.080 | 64428.7 |
968 | 2022-08-15 22:53:37 | soldier | 2 | 107671 | 62 | 2.860 | 37647.2 |
967 | 2022-08-15 06:07:24 | soldier | 1 | 69583 | 6 | 1.096 | 63488.1 |
966 | 2022-08-02 01:44:00 | soldier | 1 | 69583 | 6 | 1.110 | 62687.4 |
965 | 2022-07-29 13:22:33 | soldier | 1 | 69583 | 6 | 1.096 | 63488.1 |
964 | 2022-07-29 09:09:23 | soldier | 1 | 69583 | 6 | 1.123 | 61961.7 |
963 | 2022-07-24 10:50:11 | soldier | 1 | 69583 | 6 | 1.140 | 61037.7 |
962 | 2022-07-18 00:49:39 | soldier | 1 | 69583 | 6 | 1.093 | 63662.4 |
961 | 2022-07-10 12:16:50 | soldier | 1 | 69583 | 6 | 1.186 | 58670.3 |
960 | 2022-07-04 05:28:54 | soldier | 2 | 107671 | 62 | 2.873 | 37476.9 |
959 | 2022-07-03 16:23:06 | soldier | 1 | 69583 | 6 | 1.106 | 62914.1 |
958 | 2022-07-03 05:11:57 | soldier | 1 | 69583 | 6 | 1.126 | 61796.6 |
957 | 2022-07-02 21:17:11 | soldier | 1 | 69583 | 6 | 1.096 | 63488.1 |
956 | 2022-06-15 22:48:55 | soldier | 1 | 69583 | 6 | 1.233 | 56433.9 |
955 | 2022-06-09 00:14:41 | soldier | 1 | 69583 | 6 | 1.126 | 61796.6 |
954 | 2022-03-31 13:46:11 | soldier | 1 | 69583 | 6 | 1.593 | 43680.5 |
953 | 2022-03-23 07:40:15 | soldier | 1 | 69583 | 6 | 1.186 | 58670.3 |
952 | 2022-03-17 05:15:51 | soldier | 1 | 69583 | 6 | 1.096 | 63488.1 |
951 | 2022-01-13 15:00:56 | soldier | 1 | 69583 | 6 | 1.110 | 62687.4 |
950 | 2022-01-12 15:12:50 | soldier | 1 | 69583 | 6 | 1.220 | 57035.2 |
949 | 2022-01-11 18:47:49 | soldier | 1 | 69583 | 6 | 1.423 | 48898.8 |
948 | 2022-01-10 20:24:13 | soldier | 1 | 69583 | 6 | 1.186 | 58670.3 |
947 | 2022-01-04 09:02:11 | soldier | 1 | 69583 | 6 | 1.173 | 59320.5 |
946 | 2022-01-03 17:38:20 | soldier | 1 | 69583 | 6 | 1.143 | 60877.5 |
945 | 2022-01-03 09:54:36 | soldier | 1 | 69583 | 6 | 1.216 | 57222.9 |
944 | 2021-12-31 19:52:00 | soldier | 1 | 69583 | 6 | 1.266 | 54962.9 |
943 | 2021-12-31 09:11:11 | soldier | 1 | 69583 | 6 | 2.466 | 28217.0 |
942 | 2021-12-30 15:39:53 | soldier | 1 | 69583 | 6 | 1.313 | 52995.4 |
941 | 2021-12-30 01:12:25 | soldier | 1 | 69583 | 6 | 1.313 | 52995.4 |
940 | 2021-12-29 14:21:51 | soldier | 1 | 69583 | 6 | 1.360 | 51164.0 |
939 | 2021-12-29 05:26:16 | soldier | 1 | 69583 | 6 | 2.173 | 32021.6 |
938 | 2021-12-28 13:43:56 | soldier | 1 | 69583 | 6 | 1.326 | 52475.9 |
937 | 2021-12-27 17:33:31 | soldier | 1 | 69583 | 6 | 1.346 | 51696.1 |
936 | 2021-12-27 00:45:45 | soldier | 1 | 69583 | 6 | 1.233 | 56433.9 |
935 | 2021-12-26 13:59:59 | soldier | 1 | 69583 | 6 | 1.250 | 55666.4 |
934 | 2021-12-26 05:11:27 | soldier | 1 | 69583 | 6 | 1.250 | 55666.4 |
933 | 2021-12-25 12:55:04 | soldier | 1 | 69583 | 6 | 1.280 | 54361.7 |
932 | 2021-12-25 07:55:44 | soldier | 1 | 69583 | 6 | 1.296 | 53690.6 |
931 | 2021-12-25 00:12:10 | soldier | 1 | 69583 | 6 | 1.186 | 58670.3 |
930 | 2021-12-24 10:30:24 | soldier | 1 | 69583 | 6 | 1.123 | 61961.7 |
929 | 2021-12-24 03:19:54 | soldier | 1 | 69583 | 6 | 1.156 | 60192.9 |
928 | 2021-12-10 15:18:36 | soldier | 1 | 69583 | 6 | 1.313 | 52995.4 |
927 | 2021-10-30 11:30:46 | soldier | 1 | 69583 | 6 | 1.343 | 51811.6 |
926 | 2021-10-29 10:11:23 | soldier | 1 | 69583 | 6 | 1.233 | 56433.9 |
925 | 2021-10-28 22:50:44 | soldier | 1 | 69583 | 6 | 1.220 | 57035.2 |
924 | 2021-10-27 18:40:15 | soldier | 1 | 69583 | 6 | 1.216 | 57222.9 |
923 | 2021-10-26 02:03:15 | soldier | 1 | 69583 | 6 | 1.093 | 63662.4 |
922 | 2021-09-21 13:18:49 | soldier | 1 | 69583 | 6 | 1.343 | 51811.6 |
921 | 2021-09-21 00:58:21 | soldier | 1 | 69583 | 6 | 1.110 | 62687.4 |
920 | 2021-09-20 07:54:42 | soldier | 1 | 69583 | 6 | 1.266 | 54962.9 |
919 | 2021-09-16 10:23:39 | soldier | 1 | 69583 | 6 | 1.126 | 61796.6 |
918 | 2021-09-13 22:10:51 | soldier | 1 | 69583 | 6 | 1.220 | 57035.2 |
917 | 2021-08-29 19:06:30 | soldier | 1 | 69583 | 6 | 1.093 | 63662.4 |
916 | 2021-08-27 14:27:52 | soldier | 1 | 69583 | 6 | 1.250 | 55666.4 |
915 | 2021-08-24 09:20:21 | soldier | 1 | 69583 | 6 | 1.280 | 54361.7 |
914 | 2021-08-20 22:51:41 | soldier | 1 | 69583 | 6 | 1.236 | 56296.9 |
913 | 2021-05-21 21:59:27 | soldier | 2 | 107671 | 62 | 3.266 | 32967.2 |
912 | 2021-05-13 15:59:14 | soldier | 1 | 69583 | 6 | 1.313 | 52995.4 |
911 | 2021-04-22 15:33:50 | soldier | 2 | 107671 | 62 | 3.530 | 30501.7 |
910 | 2021-03-24 22:17:48 | soldier | 2 | 107671 | 62 | 2.936 | 36672.7 |
909 | 2021-02-27 04:38:05 | soldier | 2 | 107671 | 62 | 3.236 | 33272.9 |
908 | 2021-02-10 01:02:11 | soldier | 1 | 69583 | 6 | 1.110 | 62687.4 |
907 | 2021-02-04 14:32:29 | soldier | 1 | 69583 | 6 | 1.436 | 48456.1 |
906 | 2021-01-07 17:08:54 | soldier | 2 | 107671 | 62 | 2.950 | 36498.6 |
905 | 2020-11-14 20:24:46 | soldier | 2 | 107671 | 62 | 3.266 | 32967.2 |
904 | 2020-11-03 06:34:05 | soldier | 1 | 69583 | 6 | 1.250 | 55666.4 |
903 | 2020-10-23 12:50:57 | soldier | 1 | 69583 | 6 | 1.203 | 57841.2 |
902 | 2020-10-21 11:05:27 | soldier | 1 | 69583 | 6 | 1.250 | 55666.4 |
901 | 2020-10-04 05:25:33 | soldier | 1 | 69583 | 6 | 1.296 | 53690.6 |
900 | 2020-09-03 01:03:52 | soldier | 1 | 69583 | 6 | 1.156 | 60192.9 |
899 | 2020-08-01 01:38:58 | soldier | 1 | 69583 | 6 | 1.140 | 61037.7 |