History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sprits"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1238 | 2024-04-28 01:18:47 | sprits | 3 | 112716 | 1117 | 13.330 | 8455.8 |
1237 | 2024-04-27 10:09:59 | sprits | 3 | 112716 | 1117 | 6.783 | 16617.4 |
1236 | 2024-04-26 09:56:23 | sprits | 3 | 112716 | 1117 | 6.000 | 18786.0 |
1235 | 2024-04-24 22:07:54 | sprits | 3 | 112716 | 1117 | 4.843 | 23274.0 |
1234 | 2024-04-23 21:41:50 | sprits | 3 | 112716 | 1117 | 19.656 | 5734.4 |
1233 | 2024-04-22 22:41:42 | sprits | 3 | 112716 | 1117 | 4.813 | 23419.1 |
1232 | 2024-04-22 10:07:11 | sprits | 3 | 112716 | 1117 | 10.593 | 10640.6 |
1231 | 2024-04-22 07:49:04 | sprits | 3 | 112716 | 1117 | 15.170 | 7430.2 |
1230 | 2024-04-22 05:37:40 | sprits | 2 | 82551 | 98 | 4.373 | 18877.4 |
1229 | 2024-04-22 05:37:08 | sprits | 3 | 112716 | 1117 | 6.516 | 17298.3 |
1228 | 2024-04-21 22:34:46 | sprits | 3 | 112716 | 1117 | 13.440 | 8386.6 |
1227 | 2024-04-20 22:24:38 | sprits | 3 | 112716 | 1117 | 16.890 | 6673.5 |
1226 | 2024-04-20 06:31:19 | sprits | 3 | 112716 | 1117 | 4.873 | 23130.7 |
1225 | 2024-04-19 06:20:01 | sprits | 3 | 112716 | 1117 | 6.140 | 18357.7 |
1224 | 2024-04-18 03:03:43 | sprits | 3 | 112716 | 1117 | 18.500 | 6092.8 |
1223 | 2024-04-17 03:18:59 | sprits | 3 | 112716 | 1117 | 5.643 | 19974.5 |
1222 | 2024-04-17 00:51:45 | sprits | 3 | 112716 | 1117 | 10.640 | 10593.6 |
1221 | 2024-04-16 11:44:37 | sprits | 3 | 112716 | 1117 | 8.750 | 12881.8 |
1220 | 2024-04-16 01:05:59 | sprits | 3 | 112716 | 1117 | 5.750 | 19602.8 |
1219 | 2024-04-15 10:18:26 | sprits | 3 | 112716 | 1117 | 14.156 | 7962.4 |
1218 | 2024-04-15 00:53:39 | sprits | 3 | 112716 | 1117 | 11.516 | 9787.8 |
1217 | 2024-04-14 23:33:02 | sprits | 1 | 48755 | 14 | 1.206 | 40427.0 |
1216 | 2024-04-14 12:44:18 | sprits | 3 | 112716 | 1117 | 10.546 | 10688.0 |
1215 | 2024-04-14 01:49:58 | sprits | 3 | 112716 | 1117 | 10.280 | 10964.6 |
1214 | 2024-04-13 19:32:01 | sprits | 3 | 112716 | 1117 | 18.893 | 5966.0 |
1213 | 2024-04-12 23:42:54 | sprits | 3 | 112716 | 1117 | 7.393 | 15246.3 |
1212 | 2024-04-12 16:21:40 | sprits | 3 | 112716 | 1117 | 6.530 | 17261.3 |
1211 | 2024-04-12 15:16:45 | sprits | 3 | 112716 | 1117 | 21.486 | 5246.0 |
1210 | 2024-04-11 21:55:05 | sprits | 3 | 112716 | 1117 | 8.720 | 12926.1 |
1209 | 2024-04-11 19:21:30 | sprits | 3 | 112716 | 1117 | 15.566 | 7241.2 |
1208 | 2024-04-11 15:06:57 | sprits | 3 | 112716 | 1117 | 12.593 | 8950.7 |
1207 | 2024-04-10 18:35:19 | sprits | 3 | 112716 | 1117 | 10.076 | 11186.6 |
1206 | 2024-04-10 11:50:15 | sprits | 3 | 112716 | 1117 | 6.343 | 17770.1 |
1205 | 2024-04-09 18:04:18 | sprits | 3 | 112716 | 1117 | 7.563 | 14903.6 |
1204 | 2024-04-09 15:53:20 | sprits | 3 | 112716 | 1117 | 7.076 | 15929.3 |
1203 | 2024-04-08 17:47:06 | sprits | 3 | 112716 | 1117 | 22.890 | 4924.2 |
1202 | 2024-04-08 15:39:48 | sprits | 3 | 112716 | 1117 | 9.410 | 11978.3 |
1201 | 2024-04-08 02:36:33 | sprits | 3 | 112716 | 1117 | 6.596 | 17088.5 |
1200 | 2024-04-07 02:38:15 | sprits | 3 | 112716 | 1117 | 7.016 | 16065.6 |
1199 | 2024-04-06 12:35:15 | sprits | 3 | 112716 | 1117 | 10.843 | 10395.3 |
1198 | 2024-04-06 02:37:36 | sprits | 3 | 112716 | 1117 | 15.766 | 7149.3 |
1197 | 2024-04-05 17:10:55 | sprits | 3 | 112716 | 1117 | 12.253 | 9199.1 |
1196 | 2024-04-05 13:47:30 | sprits | 3 | 112716 | 1117 | 13.406 | 8407.9 |
1195 | 2024-04-05 11:00:51 | sprits | 3 | 112716 | 1117 | 9.783 | 11521.6 |
1194 | 2024-04-04 19:55:14 | sprits | 3 | 112716 | 1117 | 21.173 | 5323.6 |
1193 | 2024-04-04 07:47:50 | sprits | 3 | 112716 | 1117 | 6.343 | 17770.1 |
1192 | 2024-04-03 13:10:43 | sprits | 2 | 82551 | 98 | 4.326 | 19082.5 |
1191 | 2024-04-03 13:04:16 | sprits | 3 | 112716 | 1117 | 8.236 | 13685.8 |
1190 | 2024-04-03 11:46:54 | sprits | 3 | 112716 | 1117 | 13.453 | 8378.5 |
1189 | 2024-04-03 04:43:46 | sprits | 1 | 48755 | 14 | 2.063 | 23633.1 |
1188 | 2024-03-31 13:47:17 | sprits | 1 | 48755 | 14 | 2.563 | 19022.6 |
1187 | 2024-03-30 01:40:13 | sprits | 2 | 82551 | 98 | 4.346 | 18994.7 |
1186 | 2024-03-29 22:25:48 | sprits | 2 | 82551 | 98 | 6.046 | 13653.8 |
1185 | 2024-03-29 22:25:47 | sprits | 1 | 48755 | 14 | 1.156 | 42175.6 |
1184 | 2024-03-29 20:51:48 | sprits | 3 | 112716 | 1117 | 10.016 | 11253.6 |
1183 | 2024-03-29 00:32:55 | sprits | 3 | 112716 | 1117 | 14.220 | 7926.6 |
1182 | 2024-03-28 15:08:02 | sprits | 1 | 48755 | 14 | 0.753 | 64747.7 |
1181 | 2024-03-28 13:50:20 | sprits | 3 | 112716 | 1117 | 5.470 | 20606.2 |
1180 | 2024-03-28 00:31:27 | sprits | 3 | 112716 | 1117 | 8.670 | 13000.7 |
1179 | 2024-03-27 00:24:46 | sprits | 3 | 112716 | 1117 | 11.000 | 10246.9 |
1178 | 2024-03-25 14:24:41 | sprits | 3 | 112716 | 1117 | 5.453 | 20670.5 |
1177 | 2024-03-25 00:44:40 | sprits | 3 | 112716 | 1117 | 5.716 | 19719.4 |
1176 | 2024-03-24 17:49:21 | sprits | 3 | 112716 | 1117 | 5.016 | 22471.3 |
1175 | 2024-03-23 18:49:31 | sprits | 3 | 112716 | 1117 | 12.096 | 9318.5 |
1174 | 2024-03-23 02:28:46 | sprits | 3 | 112716 | 1117 | 13.250 | 8506.9 |
1173 | 2024-03-22 18:31:34 | sprits | 3 | 112716 | 1117 | 15.360 | 7338.3 |
1172 | 2024-03-22 11:06:17 | sprits | 3 | 112716 | 1117 | 9.346 | 12060.3 |
1171 | 2024-03-21 10:36:10 | sprits | 3 | 112716 | 1117 | 16.673 | 6760.4 |
1170 | 2024-03-20 17:50:22 | sprits | 3 | 112716 | 1117 | 4.813 | 23419.1 |
1169 | 2024-03-20 10:48:31 | sprits | 3 | 112716 | 1117 | 4.936 | 22835.5 |
1168 | 2024-03-19 18:35:10 | sprits | 3 | 112716 | 1117 | 10.236 | 11011.7 |
1167 | 2024-03-18 18:05:46 | sprits | 3 | 112716 | 1117 | 15.750 | 7156.6 |
1166 | 2024-03-18 08:21:19 | sprits | 3 | 112716 | 1117 | 5.720 | 19705.6 |
1165 | 2024-03-17 18:08:00 | sprits | 3 | 112716 | 1117 | 19.593 | 5752.9 |
1164 | 2024-03-17 13:19:42 | sprits | 3 | 112716 | 1117 | 5.640 | 19985.1 |
1163 | 2024-03-16 13:21:19 | sprits | 3 | 112716 | 1117 | 16.720 | 6741.4 |
1162 | 2024-03-15 14:09:21 | sprits | 3 | 112716 | 1117 | 21.986 | 5126.7 |
1161 | 2024-03-15 13:35:22 | sprits | 3 | 112716 | 1117 | 6.106 | 18459.9 |
1160 | 2024-03-15 09:24:41 | sprits | 3 | 112716 | 1117 | 8.750 | 12881.8 |
1159 | 2024-03-14 21:07:32 | sprits | 3 | 112716 | 1117 | 12.626 | 8927.3 |
1158 | 2024-03-13 20:36:13 | sprits | 3 | 112716 | 1117 | 13.546 | 8321.0 |
1157 | 2024-03-13 15:48:05 | sprits | 3 | 112716 | 1117 | 14.530 | 7757.5 |
1156 | 2024-03-13 14:21:03 | sprits | 3 | 112716 | 1117 | 20.796 | 5420.1 |
1155 | 2024-03-12 20:57:28 | sprits | 3 | 112716 | 1117 | 7.016 | 16065.6 |
1154 | 2024-03-12 12:31:37 | sprits | 3 | 112716 | 1117 | 12.406 | 9085.6 |
1153 | 2024-03-11 20:45:43 | sprits | 3 | 112716 | 1117 | 5.783 | 19490.9 |
1152 | 2024-03-11 09:18:22 | sprits | 3 | 112716 | 1117 | 19.156 | 5884.1 |
1151 | 2024-03-10 10:26:47 | sprits | 3 | 112716 | 1117 | 18.470 | 6102.7 |
1150 | 2024-03-07 18:35:21 | sprits | 3 | 112716 | 1117 | 6.906 | 16321.5 |
1149 | 2024-03-07 09:02:39 | sprits | 3 | 112716 | 1117 | 15.330 | 7352.6 |
1148 | 2024-03-06 18:45:15 | sprits | 3 | 112716 | 1117 | 5.690 | 19809.5 |
1147 | 2024-03-06 09:01:49 | sprits | 3 | 112716 | 1117 | 9.000 | 12524.0 |
1146 | 2024-03-05 19:21:24 | sprits | 3 | 112716 | 1117 | 9.080 | 12413.7 |
1145 | 2024-03-04 22:34:27 | sprits | 3 | 112716 | 1117 | 13.533 | 8329.0 |
1144 | 2024-03-04 02:00:00 | sprits | 2 | 82551 | 98 | 2.123 | 38884.1 |
1143 | 2024-03-04 01:59:59 | sprits | 1 | 48755 | 14 | 0.846 | 57630.0 |
1142 | 2024-03-03 22:38:14 | sprits | 3 | 112716 | 1117 | 7.313 | 15413.1 |
1141 | 2024-03-03 05:12:52 | sprits | 3 | 112716 | 1117 | 4.890 | 23050.3 |
1140 | 2024-03-02 05:05:58 | sprits | 3 | 112716 | 1117 | 6.063 | 18590.8 |
1139 | 2024-03-01 12:40:09 | sprits | 3 | 112716 | 1117 | 7.096 | 15884.4 |