History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"port"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1140 | 2024-04-02 18:28:06 | port | 1 | 13983 | 20 | 0.516 | 27098.8 |
1139 | 2024-04-01 16:21:41 | port | 1 | 13983 | 20 | 0.826 | 16928.6 |
1138 | 2024-03-30 20:47:01 | port | 1 | 13983 | 20 | 0.550 | 25423.6 |
1137 | 2024-03-02 14:24:00 | port | 2 | 29872 | 359 | 3.173 | 9414.4 |
1136 | 2024-03-02 13:54:02 | port | 1 | 13983 | 20 | 0.296 | 47239.9 |
1135 | 2024-02-29 22:48:52 | port | 1 | 13983 | 20 | 0.263 | 53167.3 |
1134 | 2024-02-28 16:52:57 | port | 1 | 13983 | 20 | 0.640 | 21848.4 |
1133 | 2024-01-30 15:02:29 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1132 | 2024-01-25 18:54:49 | port | 1 | 13983 | 20 | 0.550 | 25423.6 |
1131 | 2024-01-08 07:51:19 | port | 2 | 29872 | 359 | 1.546 | 19322.1 |
1130 | 2023-12-17 17:54:41 | port | 2 | 29872 | 359 | 0.843 | 35435.3 |
1129 | 2023-12-17 03:33:00 | port | 2 | 29872 | 359 | 1.516 | 19704.5 |
1128 | 2023-12-03 15:35:32 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1127 | 2023-12-03 15:35:31 | port | 1 | 13983 | 20 | 0.313 | 44674.1 |
1126 | 2023-11-25 20:13:42 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1125 | 2023-11-16 22:04:44 | port | 1 | 13983 | 20 | 0.530 | 26383.0 |
1124 | 2023-11-13 04:31:12 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1123 | 2023-11-12 01:36:59 | port | 1 | 13983 | 20 | 0.266 | 52567.7 |
1122 | 2023-11-02 05:01:35 | port | 2 | 29872 | 359 | 0.763 | 39150.7 |
1121 | 2023-10-28 16:40:08 | port | 2 | 29872 | 359 | 0.893 | 33451.3 |
1120 | 2023-10-26 02:02:25 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1119 | 2023-10-19 20:55:56 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1118 | 2023-10-17 17:05:56 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1117 | 2023-10-14 00:08:58 | port | 1 | 13983 | 20 | 0.280 | 49939.3 |
1116 | 2023-10-03 08:34:12 | port | 2 | 29872 | 359 | 0.783 | 38150.7 |
1115 | 2023-10-03 08:03:42 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1114 | 2023-09-19 18:21:57 | port | 2 | 29872 | 359 | 1.126 | 26529.3 |
1113 | 2023-09-19 10:43:07 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1112 | 2023-09-18 07:53:24 | port | 2 | 29872 | 359 | 0.766 | 38997.4 |
1111 | 2023-09-12 10:16:10 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1110 | 2023-09-11 08:39:21 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1109 | 2023-07-30 07:05:14 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1108 | 2023-06-25 05:09:16 | port | 2 | 29872 | 359 | 0.873 | 34217.6 |
1107 | 2023-06-22 11:47:24 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1106 | 2023-04-21 22:24:23 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1105 | 2023-04-06 01:08:34 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1104 | 2023-03-20 17:48:02 | port | 2 | 29872 | 359 | 0.750 | 39829.3 |
1103 | 2023-02-01 19:22:21 | port | 1 | 13983 | 20 | 0.200 | 69915.0 |
1102 | 2023-01-21 02:38:26 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1101 | 2023-01-05 19:47:18 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1100 | 2022-12-22 01:51:47 | port | 2 | 29872 | 359 | 0.750 | 39829.3 |
1099 | 2022-12-17 00:31:34 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1098 | 2022-12-05 19:18:36 | port | 2 | 29872 | 359 | 0.826 | 36164.6 |
1097 | 2022-11-22 19:14:49 | port | 1 | 13983 | 20 | 0.236 | 59250.0 |
1096 | 2022-11-16 22:41:39 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1095 | 2022-11-11 15:04:20 | port | 1 | 13983 | 20 | 0.280 | 49939.3 |
1094 | 2022-11-10 20:29:44 | port | 1 | 13983 | 20 | 0.216 | 64736.1 |
1093 | 2022-11-02 23:50:51 | port | 2 | 29872 | 359 | 0.936 | 31914.5 |
1092 | 2022-09-18 13:21:49 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1091 | 2022-09-12 07:33:17 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1090 | 2022-08-21 23:10:30 | port | 2 | 29872 | 359 | 0.843 | 35435.3 |
1089 | 2022-08-14 07:02:14 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1088 | 2022-08-05 23:29:18 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1087 | 2022-07-30 06:48:12 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1086 | 2022-07-17 22:48:32 | port | 1 | 13983 | 20 | 0.216 | 64736.1 |
1085 | 2022-07-07 00:26:55 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1084 | 2022-07-02 23:45:38 | port | 1 | 13983 | 20 | 0.216 | 64736.1 |
1083 | 2022-06-05 02:34:16 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1082 | 2022-06-01 21:07:55 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1081 | 2022-03-25 10:03:44 | port | 1 | 13983 | 20 | 0.283 | 49409.9 |
1080 | 2022-03-24 20:19:51 | port | 1 | 13983 | 20 | 0.326 | 42892.6 |
1079 | 2022-03-23 12:34:45 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1078 | 2022-03-23 00:06:54 | port | 1 | 13983 | 20 | 0.390 | 35853.8 |
1077 | 2022-03-15 12:54:51 | port | 1 | 13983 | 20 | 0.280 | 49939.3 |
1076 | 2022-03-15 08:17:24 | port | 2 | 29872 | 359 | 0.936 | 31914.5 |
1075 | 2022-03-14 20:51:30 | port | 1 | 13983 | 20 | 0.326 | 42892.6 |
1074 | 2022-03-13 20:53:23 | port | 1 | 13983 | 20 | 0.263 | 53167.3 |
1073 | 2022-03-12 19:26:32 | port | 1 | 13983 | 20 | 0.236 | 59250.0 |
1072 | 2022-03-07 11:31:45 | port | 1 | 13983 | 20 | 0.296 | 47239.9 |
1071 | 2022-02-25 06:20:45 | port | 1 | 13983 | 20 | 0.216 | 64736.1 |
1070 | 2022-02-13 09:31:40 | port | 1 | 13983 | 20 | 0.263 | 53167.3 |
1069 | 2022-02-12 06:32:29 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1068 | 2022-02-11 07:50:43 | port | 1 | 13983 | 20 | 0.546 | 25609.9 |
1067 | 2022-01-05 23:59:23 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1066 | 2022-01-05 14:43:15 | port | 1 | 13983 | 20 | 0.266 | 52567.7 |
1065 | 2022-01-04 23:50:58 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1064 | 2021-12-17 22:57:56 | port | 1 | 13983 | 20 | 0.266 | 52567.7 |
1063 | 2021-12-07 18:49:27 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1062 | 2021-12-07 11:34:01 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1061 | 2021-12-06 23:11:42 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1060 | 2021-12-06 15:21:06 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1059 | 2021-12-06 01:26:28 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1058 | 2021-12-05 16:41:57 | port | 1 | 13983 | 20 | 0.253 | 55268.8 |
1057 | 2021-12-05 09:06:44 | port | 1 | 13983 | 20 | 0.280 | 49939.3 |
1056 | 2021-12-05 00:39:27 | port | 1 | 13983 | 20 | 0.253 | 55268.8 |
1055 | 2021-12-04 14:49:06 | port | 1 | 13983 | 20 | 0.236 | 59250.0 |
1054 | 2021-12-04 04:35:57 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1053 | 2021-12-03 10:52:41 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1052 | 2021-12-03 02:08:55 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1051 | 2021-12-02 18:51:46 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1050 | 2021-12-02 12:41:50 | port | 2 | 29872 | 359 | 0.906 | 32971.3 |
1049 | 2021-12-02 02:21:02 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1048 | 2021-12-01 15:31:40 | port | 1 | 13983 | 20 | 0.220 | 63559.1 |
1047 | 2021-12-01 09:16:54 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1046 | 2021-11-30 20:50:14 | port | 1 | 13983 | 20 | 0.280 | 49939.3 |
1045 | 2021-11-30 13:39:34 | port | 1 | 13983 | 20 | 0.516 | 27098.8 |
1044 | 2021-11-29 14:28:27 | port | 1 | 13983 | 20 | 0.233 | 60012.9 |
1043 | 2021-11-29 02:45:22 | port | 1 | 13983 | 20 | 0.216 | 64736.1 |
1042 | 2021-11-19 00:23:57 | port | 1 | 13983 | 20 | 0.250 | 55932.0 |
1041 | 2021-11-18 12:15:37 | port | 1 | 13983 | 20 | 0.310 | 45106.5 |