History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"voyages"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
287 | 2024-03-27 14:23:26 | voyages | 2 | 107671 | 23 | 6.250 | 17227.4 |
286 | 2024-03-26 14:58:48 | voyages | 3 | 134027 | 245 | 19.686 | 6808.2 |
285 | 2024-03-26 14:58:45 | voyages | 2 | 107671 | 23 | 7.440 | 14471.9 |
284 | 2024-03-15 23:29:30 | voyages | 1 | 69583 | 5 | 3.280 | 21214.3 |
283 | 2024-03-08 23:52:10 | voyages | 3 | 134027 | 245 | 8.096 | 16554.7 |
282 | 2024-03-07 09:14:38 | voyages | 3 | 134027 | 245 | 18.843 | 7112.8 |
281 | 2024-03-07 07:39:03 | voyages | 2 | 107671 | 23 | 6.096 | 17662.6 |
280 | 2024-03-01 18:54:46 | voyages | 2 | 107671 | 23 | 10.143 | 10615.3 |
279 | 2024-02-10 08:49:29 | voyages | 3 | 134027 | 245 | 13.546 | 9894.2 |
278 | 2024-02-09 20:49:30 | voyages | 3 | 134027 | 245 | 14.220 | 9425.2 |
277 | 2024-02-09 20:49:26 | voyages | 2 | 107671 | 23 | 7.716 | 13954.3 |
276 | 2024-02-06 04:58:33 | voyages | 2 | 107671 | 23 | 3.313 | 32499.5 |
275 | 2024-02-06 04:58:05 | voyages | 3 | 134027 | 245 | 7.046 | 19021.7 |
274 | 2024-02-05 08:52:14 | voyages | 2 | 107671 | 23 | 3.453 | 31181.9 |
273 | 2024-02-05 08:51:46 | voyages | 3 | 134027 | 245 | 8.530 | 15712.4 |
272 | 2024-02-04 23:57:03 | voyages | 3 | 134027 | 245 | 10.393 | 12895.9 |
271 | 2023-12-25 07:01:51 | voyages | 1 | 69583 | 5 | 1.046 | 66522.9 |
270 | 2023-12-25 02:34:25 | voyages | 3 | 134027 | 245 | 6.656 | 20136.3 |
269 | 2023-12-13 09:15:47 | voyages | 3 | 134027 | 245 | 12.296 | 10900.0 |
268 | 2023-12-09 12:06:10 | voyages | 3 | 134027 | 245 | 6.266 | 21389.6 |
267 | 2023-12-09 04:21:32 | voyages | 1 | 69583 | 5 | 1.203 | 57841.2 |
266 | 2023-11-17 14:41:31 | voyages | 1 | 69583 | 5 | 1.170 | 59472.6 |
265 | 2023-11-11 21:13:49 | voyages | 1 | 69583 | 5 | 1.076 | 64668.2 |
264 | 2023-11-11 09:20:08 | voyages | 1 | 69583 | 5 | 2.470 | 28171.3 |
263 | 2023-11-11 05:07:59 | voyages | 3 | 134027 | 245 | 5.500 | 24368.5 |
262 | 2023-11-10 22:34:53 | voyages | 1 | 69583 | 5 | 1.030 | 67556.3 |
261 | 2023-10-29 22:23:33 | voyages | 3 | 134027 | 245 | 8.080 | 16587.5 |
260 | 2023-10-29 22:21:15 | voyages | 1 | 69583 | 5 | 1.126 | 61796.6 |
259 | 2023-10-14 07:07:06 | voyages | 1 | 69583 | 5 | 1.156 | 60192.9 |
258 | 2023-10-13 18:05:07 | voyages | 1 | 69583 | 5 | 1.186 | 58670.3 |
257 | 2023-09-30 03:19:20 | voyages | 1 | 69583 | 5 | 1.030 | 67556.3 |
256 | 2023-08-17 10:35:01 | voyages | 3 | 134027 | 245 | 6.206 | 21596.4 |
255 | 2023-08-08 20:55:48 | voyages | 1 | 69583 | 5 | 1.033 | 67360.1 |
254 | 2023-05-06 18:34:04 | voyages | 1 | 69583 | 5 | 1.170 | 59472.6 |
253 | 2023-04-26 20:39:43 | voyages | 3 | 134027 | 245 | 5.546 | 24166.4 |
252 | 2023-02-26 04:57:02 | voyages | 1 | 69583 | 5 | 1.123 | 61961.7 |
251 | 2023-02-10 18:16:20 | voyages | 3 | 134027 | 245 | 6.173 | 21711.8 |
250 | 2023-01-30 19:54:38 | voyages | 3 | 134027 | 245 | 5.563 | 24092.6 |
249 | 2023-01-15 04:39:24 | voyages | 3 | 134027 | 245 | 5.610 | 23890.7 |
248 | 2022-12-22 22:56:14 | voyages | 1 | 69583 | 5 | 1.000 | 69583.0 |
247 | 2022-12-10 14:02:04 | voyages | 3 | 134027 | 245 | 5.576 | 24036.4 |
246 | 2022-12-10 01:58:51 | voyages | 3 | 134027 | 245 | 6.063 | 22105.7 |
245 | 2022-11-12 04:09:20 | voyages | 3 | 134027 | 245 | 5.500 | 24368.5 |
244 | 2022-09-17 20:50:20 | voyages | 1 | 69583 | 5 | 1.096 | 63488.1 |
243 | 2022-09-08 19:19:20 | voyages | 1 | 69583 | 5 | 1.013 | 68690.0 |
242 | 2022-06-13 19:09:39 | voyages | 3 | 134027 | 245 | 6.313 | 21230.3 |
241 | 2022-04-22 01:22:23 | voyages | 1 | 69583 | 5 | 1.186 | 58670.3 |
240 | 2022-02-10 12:55:13 | voyages | 1 | 69583 | 5 | 1.373 | 50679.5 |
239 | 2022-02-09 21:50:17 | voyages | 1 | 69583 | 5 | 1.156 | 60192.9 |
238 | 2022-02-08 21:49:16 | voyages | 1 | 69583 | 5 | 1.250 | 55666.4 |
237 | 2022-02-07 23:50:19 | voyages | 1 | 69583 | 5 | 1.283 | 54234.6 |
236 | 2022-01-22 03:35:00 | voyages | 1 | 69583 | 5 | 1.030 | 67556.3 |
235 | 2022-01-19 23:06:44 | voyages | 1 | 69583 | 5 | 1.453 | 47889.2 |
234 | 2022-01-09 16:34:32 | voyages | 1 | 69583 | 5 | 1.190 | 58473.1 |
233 | 2022-01-08 23:05:19 | voyages | 1 | 69583 | 5 | 1.233 | 56433.9 |
232 | 2022-01-07 17:35:51 | voyages | 1 | 69583 | 5 | 1.250 | 55666.4 |
231 | 2022-01-06 18:12:58 | voyages | 1 | 69583 | 5 | 1.110 | 62687.4 |
230 | 2021-12-05 08:24:25 | voyages | 1 | 69583 | 5 | 1.050 | 66269.5 |
229 | 2021-12-04 12:47:01 | voyages | 1 | 69583 | 5 | 1.063 | 65459.1 |
228 | 2021-12-03 06:57:24 | voyages | 1 | 69583 | 5 | 1.093 | 63662.4 |
227 | 2021-11-30 04:21:26 | voyages | 1 | 69583 | 5 | 1.063 | 65459.1 |
226 | 2021-10-02 14:43:03 | voyages | 1 | 69583 | 5 | 1.110 | 62687.4 |
225 | 2021-09-14 07:14:19 | voyages | 1 | 69583 | 5 | 1.186 | 58670.3 |
224 | 2021-05-11 01:09:21 | voyages | 1 | 69583 | 5 | 1.203 | 57841.2 |
223 | 2021-04-09 18:52:40 | voyages | 1 | 69583 | 5 | 1.186 | 58670.3 |
222 | 2021-04-07 14:29:48 | voyages | 1 | 69583 | 5 | 2.203 | 31585.6 |
221 | 2021-01-24 08:56:42 | voyages | 1 | 69583 | 5 | 1.076 | 64668.2 |
220 | 2020-12-22 08:28:28 | voyages | 3 | 134027 | 245 | 5.763 | 23256.5 |
219 | 2020-11-29 02:49:53 | voyages | 1 | 69583 | 5 | 1.030 | 67556.3 |
218 | 2020-11-02 12:01:19 | voyages | 1 | 69583 | 5 | 2.720 | 25582.0 |
217 | 2020-10-24 17:47:29 | voyages | 1 | 69583 | 5 | 1.173 | 59320.5 |
216 | 2020-10-19 10:06:24 | voyages | 1 | 69583 | 5 | 1.046 | 66522.9 |
215 | 2020-09-09 17:35:11 | voyages | 1 | 69583 | 5 | 1.030 | 67556.3 |
214 | 2020-09-04 13:19:11 | voyages | 1 | 69583 | 5 | 1.140 | 61037.7 |
213 | 2020-09-03 12:27:49 | voyages | 1 | 69583 | 5 | 1.250 | 55666.4 |
212 | 2020-08-29 00:16:29 | voyages | 1 | 69583 | 5 | 1.063 | 65459.1 |
211 | 2020-08-12 05:36:04 | voyages | 1 | 69583 | 5 | 1.046 | 66522.9 |
210 | 2020-07-20 16:26:24 | voyages | 1 | 69583 | 5 | 1.190 | 58473.1 |
209 | 2020-05-30 18:32:54 | voyages | 1 | 69583 | 5 | 1.046 | 66522.9 |
208 | 2020-05-26 23:42:06 | voyages | 1 | 69583 | 5 | 1.030 | 67556.3 |
207 | 2020-03-29 20:29:45 | voyages | 1 | 69583 | 5 | 1.123 | 61961.7 |
206 | 2020-03-24 12:52:00 | voyages | 1 | 69583 | 5 | 1.360 | 51164.0 |
205 | 2020-03-24 09:08:31 | voyages | 3 | 134027 | 245 | 7.750 | 17293.8 |
204 | 2020-03-24 05:09:07 | voyages | 1 | 69583 | 5 | 1.173 | 59320.5 |
203 | 2020-03-23 23:59:06 | voyages | 1 | 69583 | 5 | 1.093 | 63662.4 |
202 | 2020-03-23 14:55:06 | voyages | 3 | 134027 | 245 | 7.563 | 17721.4 |
201 | 2020-03-22 18:55:38 | voyages | 3 | 134027 | 245 | 7.533 | 17792.0 |
200 | 2020-03-22 05:50:06 | voyages | 3 | 134027 | 245 | 6.890 | 19452.4 |
199 | 2020-03-21 05:00:12 | voyages | 1 | 69583 | 5 | 1.170 | 59472.6 |
198 | 2020-03-20 21:53:01 | voyages | 1 | 69583 | 5 | 1.173 | 59320.5 |
197 | 2020-03-06 03:24:49 | voyages | 3 | 134027 | 245 | 19.000 | 7054.1 |
196 | 2020-03-03 15:19:10 | voyages | 3 | 134027 | 245 | 6.313 | 21230.3 |
195 | 2020-02-28 17:21:57 | voyages | 3 | 134027 | 245 | 15.576 | 8604.7 |
194 | 2020-02-28 04:32:28 | voyages | 1 | 69583 | 5 | 1.220 | 57035.2 |
193 | 2020-02-22 17:38:22 | voyages | 1 | 69583 | 5 | 2.390 | 29114.2 |
192 | 2020-02-22 17:36:06 | voyages | 1 | 69583 | 5 | 1.186 | 58670.3 |
191 | 2020-02-22 16:09:50 | voyages | 1 | 69583 | 5 | 1.296 | 53690.6 |
190 | 2020-02-21 09:45:53 | voyages | 3 | 134027 | 245 | 7.500 | 17870.3 |
189 | 2020-02-15 12:41:40 | voyages | 1 | 69583 | 5 | 1.313 | 52995.4 |
188 | 2020-02-11 22:45:35 | voyages | 1 | 69583 | 5 | 1.186 | 58670.3 |