History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"freighters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
296 | 2024-04-30 08:17:09 | freighters | 1 | 67641 | 2 | 1.546 | 43752.3 |
295 | 2024-04-28 05:48:07 | freighters | 4 | 161450 | 282 | 28.156 | 5734.1 |
294 | 2024-04-28 05:48:11 | freighters | 3 | 140603 | 42 | 20.486 | 6863.4 |
293 | 2024-04-28 05:48:04 | freighters | 2 | 108824 | 9 | 7.063 | 15407.6 |
292 | 2024-04-28 04:35:10 | freighters | 1 | 67641 | 2 | 1.750 | 38652.0 |
291 | 2024-04-27 22:17:13 | freighters | 1 | 67641 | 2 | 2.326 | 29080.4 |
290 | 2024-04-12 19:10:21 | freighters | 3 | 140603 | 42 | 7.126 | 19731.0 |
289 | 2024-04-07 19:16:37 | freighters | 1 | 67641 | 2 | 1.250 | 54112.8 |
288 | 2024-04-07 01:49:33 | freighters | 4 | 161450 | 282 | 19.563 | 8252.8 |
287 | 2024-04-06 08:52:28 | freighters | 4 | 161450 | 282 | 26.986 | 5982.7 |
286 | 2024-04-06 08:52:27 | freighters | 2 | 108824 | 9 | 13.253 | 8211.3 |
285 | 2024-04-06 07:45:17 | freighters | 1 | 67641 | 2 | 1.140 | 59334.2 |
284 | 2024-04-05 20:26:48 | freighters | 1 | 67641 | 2 | 4.313 | 15683.1 |
283 | 2024-04-04 10:24:18 | freighters | 3 | 140603 | 42 | 9.670 | 14540.1 |
282 | 2024-03-27 01:27:16 | freighters | 1 | 67641 | 2 | 1.563 | 43276.4 |
281 | 2024-03-26 11:45:57 | freighters | 1 | 67641 | 2 | 1.126 | 60071.9 |
280 | 2024-03-24 04:23:03 | freighters | 3 | 140603 | 42 | 20.766 | 6770.8 |
279 | 2024-03-19 16:16:32 | freighters | 3 | 140603 | 42 | 16.343 | 8603.3 |
278 | 2024-03-19 16:16:32 | freighters | 4 | 161450 | 282 | 14.656 | 11016.0 |
277 | 2024-03-19 16:16:33 | freighters | 2 | 108824 | 9 | 7.483 | 14542.8 |
276 | 2024-03-19 15:22:43 | freighters | 1 | 67641 | 2 | 1.920 | 35229.7 |
275 | 2024-03-05 15:00:33 | freighters | 1 | 67641 | 2 | 2.376 | 28468.4 |
274 | 2024-03-02 12:04:52 | freighters | 1 | 67641 | 2 | 1.220 | 55443.4 |
273 | 2024-02-25 07:14:42 | freighters | 1 | 67641 | 2 | 1.123 | 60232.4 |
272 | 2024-02-06 08:20:20 | freighters | 4 | 161450 | 282 | 14.673 | 11003.2 |
271 | 2024-02-05 03:16:47 | freighters | 1 | 67641 | 2 | 1.280 | 52844.5 |
270 | 2024-02-03 06:21:26 | freighters | 4 | 161450 | 282 | 24.160 | 6682.5 |
269 | 2024-01-31 09:36:52 | freighters | 1 | 67641 | 2 | 1.126 | 60071.9 |
268 | 2024-01-31 00:36:07 | freighters | 1 | 67641 | 2 | 2.170 | 31171.0 |
267 | 2024-01-25 21:24:59 | freighters | 1 | 67641 | 2 | 0.983 | 68810.8 |
266 | 2023-12-29 00:42:07 | freighters | 4 | 161450 | 282 | 21.516 | 7503.7 |
265 | 2023-12-27 16:44:16 | freighters | 4 | 161450 | 282 | 10.953 | 14740.3 |
264 | 2023-12-23 19:19:58 | freighters | 1 | 67641 | 2 | 1.110 | 60937.8 |
263 | 2023-12-22 22:18:37 | freighters | 2 | 108824 | 9 | 2.843 | 38277.9 |
262 | 2023-12-11 23:29:30 | freighters | 3 | 140603 | 42 | 5.500 | 25564.2 |
261 | 2023-12-11 21:59:29 | freighters | 1 | 67641 | 2 | 2.266 | 29850.4 |
260 | 2023-12-08 12:15:32 | freighters | 1 | 67641 | 2 | 2.236 | 30250.9 |
259 | 2023-11-13 04:19:34 | freighters | 4 | 161450 | 282 | 11.033 | 14633.4 |
258 | 2023-11-05 00:30:58 | freighters | 1 | 67641 | 2 | 1.046 | 64666.3 |
257 | 2023-10-31 02:07:57 | freighters | 1 | 67641 | 2 | 1.140 | 59334.2 |
256 | 2023-10-17 11:44:36 | freighters | 1 | 67641 | 2 | 1.283 | 52721.0 |
255 | 2023-10-11 00:34:47 | freighters | 1 | 67641 | 2 | 1.016 | 66575.8 |
254 | 2023-09-23 00:17:34 | freighters | 2 | 108824 | 9 | 2.690 | 40455.0 |
253 | 2023-09-09 18:56:38 | freighters | 3 | 140603 | 42 | 5.330 | 26379.5 |
252 | 2023-08-16 02:41:05 | freighters | 4 | 161450 | 282 | 11.390 | 14174.7 |
251 | 2023-08-06 09:14:15 | freighters | 1 | 67641 | 2 | 1.013 | 66773.0 |
250 | 2023-06-28 08:13:16 | freighters | 2 | 108824 | 9 | 2.643 | 41174.4 |
249 | 2023-06-01 22:53:07 | freighters | 3 | 140603 | 42 | 5.453 | 25784.5 |
248 | 2023-05-02 14:40:46 | freighters | 4 | 161450 | 282 | 9.533 | 16935.9 |
247 | 2023-05-01 15:59:38 | freighters | 1 | 67641 | 2 | 1.016 | 66575.8 |
246 | 2023-03-19 16:26:42 | freighters | 2 | 108824 | 9 | 2.750 | 39572.4 |
245 | 2023-03-12 05:30:39 | freighters | 3 | 140603 | 42 | 6.440 | 21832.8 |
244 | 2023-02-22 06:29:31 | freighters | 1 | 67641 | 2 | 0.986 | 68601.4 |
243 | 2023-02-07 19:39:55 | freighters | 4 | 161450 | 282 | 9.423 | 17133.6 |
242 | 2022-12-21 06:29:26 | freighters | 1 | 67641 | 2 | 0.970 | 69733.0 |
241 | 2022-12-20 20:21:45 | freighters | 2 | 108824 | 9 | 2.626 | 41441.0 |
240 | 2022-12-15 07:33:23 | freighters | 3 | 140603 | 42 | 5.420 | 25941.5 |
239 | 2022-11-19 22:05:45 | freighters | 4 | 161450 | 282 | 10.376 | 15559.9 |
238 | 2022-09-21 09:03:46 | freighters | 4 | 161450 | 282 | 9.500 | 16994.7 |
237 | 2022-09-03 22:23:18 | freighters | 1 | 67641 | 2 | 1.123 | 60232.4 |
236 | 2022-09-03 19:57:46 | freighters | 1 | 67641 | 2 | 1.253 | 53983.2 |
235 | 2022-09-01 14:14:08 | freighters | 1 | 67641 | 2 | 1.000 | 67641.0 |
234 | 2022-08-18 14:54:01 | freighters | 2 | 108824 | 9 | 2.720 | 40008.8 |
233 | 2022-08-06 02:37:15 | freighters | 4 | 161450 | 282 | 20.563 | 7851.5 |
232 | 2022-08-02 10:01:15 | freighters | 3 | 140603 | 42 | 5.656 | 24859.1 |
231 | 2022-07-19 01:19:15 | freighters | 1 | 67641 | 2 | 1.060 | 63812.3 |
230 | 2022-06-23 21:39:29 | freighters | 4 | 161450 | 282 | 10.860 | 14866.5 |
229 | 2022-06-05 00:38:03 | freighters | 1 | 67641 | 2 | 1.016 | 66575.8 |
228 | 2022-04-26 21:12:30 | freighters | 1 | 67641 | 2 | 1.063 | 63632.2 |
227 | 2022-04-19 04:15:24 | freighters | 1 | 67641 | 2 | 1.063 | 63632.2 |
226 | 2022-03-06 01:27:10 | freighters | 3 | 140603 | 42 | 6.406 | 21948.6 |
225 | 2022-02-13 21:41:15 | freighters | 4 | 161450 | 282 | 16.373 | 9860.7 |
224 | 2022-02-03 10:11:40 | freighters | 1 | 67641 | 2 | 1.203 | 56226.9 |
223 | 2022-02-01 06:06:49 | freighters | 1 | 67641 | 2 | 1.063 | 63632.2 |
222 | 2021-02-02 11:25:08 | freighters | 1 | 67641 | 2 | 1.000 | 67641.0 |
221 | 2020-12-08 21:25:16 | freighters | 1 | 67641 | 2 | 0.983 | 68810.8 |
220 | 2020-11-12 12:32:51 | freighters | 1 | 67641 | 2 | 1.016 | 66575.8 |
219 | 2020-11-05 16:04:30 | freighters | 1 | 67641 | 2 | 1.013 | 66773.0 |
218 | 2020-10-29 05:25:36 | freighters | 1 | 67641 | 2 | 1.013 | 66773.0 |
217 | 2020-03-26 05:37:14 | freighters | 1 | 67641 | 2 | 1.170 | 57812.8 |
216 | 2020-03-15 13:15:50 | freighters | 1 | 67641 | 2 | 1.013 | 66773.0 |
215 | 2020-02-13 08:39:26 | freighters | 1 | 67641 | 2 | 1.186 | 57032.9 |
214 | 2020-02-09 12:58:17 | freighters | 1 | 67641 | 2 | 1.813 | 37308.9 |
213 | 2020-02-04 14:34:44 | freighters | 1 | 67641 | 2 | 2.563 | 26391.3 |
212 | 2020-01-31 17:55:02 | freighters | 1 | 67641 | 2 | 1.813 | 37308.9 |
211 | 2020-01-31 09:41:18 | freighters | 1 | 67641 | 2 | 2.016 | 33552.1 |
210 | 2020-01-22 20:43:13 | freighters | 1 | 67641 | 2 | 1.313 | 51516.4 |
209 | 2020-01-16 20:41:43 | freighters | 1 | 67641 | 2 | 1.283 | 52721.0 |
208 | 2020-01-06 21:42:58 | freighters | 1 | 67641 | 2 | 2.656 | 25467.2 |
207 | 2020-01-02 19:26:15 | freighters | 1 | 67641 | 2 | 2.533 | 26703.9 |
206 | 2019-12-09 19:53:05 | freighters | 1 | 67641 | 2 | 1.060 | 63812.3 |
205 | 2019-09-07 22:31:05 | freighters | 1 | 67641 | 2 | 1.776 | 38086.1 |
204 | 2019-06-09 15:23:55 | freighters | 1 | 67641 | 2 | 0.986 | 68601.4 |
203 | 2019-06-02 02:33:48 | freighters | 1 | 67641 | 2 | 1.113 | 60773.6 |
202 | 2019-05-30 00:15:05 | freighters | 1 | 67641 | 2 | 1.003 | 67438.7 |
201 | 2019-02-08 03:41:13 | freighters | 1 | 67641 | 2 | 1.126 | 60071.9 |
200 | 2018-10-14 04:56:23 | freighters | 1 | 67641 | 2 | 1.170 | 57812.8 |
199 | 2018-08-24 22:52:38 | freighters | 1 | 67641 | 2 | 1.100 | 61491.8 |
198 | 2018-07-12 14:19:43 | freighters | 1 | 67641 | 2 | 1.056 | 64054.0 |
197 | 2018-06-28 09:17:42 | freighters | 1 | 67641 | 2 | 1.096 | 61716.2 |