History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crafting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
335 | 2024-05-12 21:56:40 | crafting | 1 | 82945 | 5 | 1.733 | 47862.1 |
334 | 2024-04-08 07:50:47 | crafting | 1 | 82945 | 5 | 2.826 | 29350.7 |
333 | 2024-04-07 17:17:55 | crafting | 3 | 146162 | 488 | 12.890 | 11339.2 |
332 | 2024-04-05 21:37:33 | crafting | 3 | 146162 | 488 | 11.236 | 13008.4 |
331 | 2024-04-05 18:57:41 | crafting | 3 | 146162 | 488 | 26.470 | 5521.8 |
330 | 2024-04-05 10:20:26 | crafting | 3 | 146162 | 488 | 21.186 | 6899.0 |
329 | 2024-04-05 10:20:38 | crafting | 3 | 146162 | 488 | 8.986 | 16265.5 |
328 | 2024-04-05 10:20:39 | crafting | 2 | 121059 | 54 | 4.733 | 25577.6 |
327 | 2024-04-05 10:20:34 | crafting | 1 | 82945 | 5 | 1.826 | 45424.4 |
326 | 2024-04-05 10:20:27 | crafting | 1 | 82945 | 5 | 6.736 | 12313.7 |
325 | 2024-04-05 10:20:24 | crafting | 2 | 121059 | 54 | 6.250 | 19369.4 |
324 | 2024-03-29 23:45:43 | crafting | 1 | 82945 | 5 | 5.220 | 15889.8 |
323 | 2024-03-20 19:04:37 | crafting | 1 | 82945 | 5 | 3.203 | 25896.0 |
322 | 2024-03-17 09:28:08 | crafting | 1 | 82945 | 5 | 1.546 | 53651.4 |
321 | 2024-03-17 00:18:49 | crafting | 1 | 82945 | 5 | 1.326 | 62552.8 |
320 | 2024-03-02 15:37:04 | crafting | 1 | 82945 | 5 | 3.580 | 23169.0 |
319 | 2024-02-28 13:30:52 | crafting | 1 | 82945 | 5 | 2.873 | 28870.5 |
318 | 2024-02-16 06:08:22 | crafting | 1 | 82945 | 5 | 3.280 | 25288.1 |
317 | 2024-02-04 21:10:54 | crafting | 3 | 146162 | 488 | 10.766 | 13576.3 |
316 | 2024-02-04 15:05:19 | crafting | 3 | 146162 | 488 | 9.533 | 15332.2 |
315 | 2024-02-04 10:20:46 | crafting | 3 | 146162 | 488 | 7.703 | 18974.7 |
314 | 2024-02-01 02:05:52 | crafting | 3 | 146162 | 488 | 8.076 | 18098.3 |
313 | 2024-01-26 12:56:07 | crafting | 3 | 146162 | 488 | 6.953 | 21021.4 |
312 | 2024-01-23 02:09:20 | crafting | 2 | 121059 | 54 | 4.313 | 28068.4 |
311 | 2024-01-23 01:25:29 | crafting | 3 | 146162 | 488 | 8.766 | 16673.7 |
310 | 2024-01-21 08:19:50 | crafting | 3 | 146162 | 488 | 6.310 | 23163.5 |
309 | 2024-01-15 20:44:54 | crafting | 2 | 121059 | 54 | 4.076 | 29700.4 |
308 | 2023-12-16 17:58:17 | crafting | 1 | 82945 | 5 | 1.516 | 54713.1 |
307 | 2023-12-09 21:07:10 | crafting | 1 | 82945 | 5 | 1.593 | 52068.4 |
306 | 2023-12-01 13:25:15 | crafting | 1 | 82945 | 5 | 1.423 | 58288.8 |
305 | 2023-11-30 08:50:44 | crafting | 1 | 82945 | 5 | 1.313 | 63172.1 |
304 | 2023-11-11 01:31:40 | crafting | 1 | 82945 | 5 | 2.733 | 30349.4 |
303 | 2023-11-07 00:48:46 | crafting | 1 | 82945 | 5 | 1.313 | 63172.1 |
302 | 2023-11-02 20:52:44 | crafting | 2 | 121059 | 54 | 4.013 | 30166.7 |
301 | 2023-10-31 13:57:16 | crafting | 1 | 82945 | 5 | 1.390 | 59672.7 |
300 | 2023-10-25 06:22:01 | crafting | 2 | 121059 | 54 | 3.610 | 33534.3 |
299 | 2023-10-14 00:19:54 | crafting | 1 | 82945 | 5 | 1.390 | 59672.7 |
298 | 2023-10-06 20:27:40 | crafting | 1 | 82945 | 5 | 1.406 | 58993.6 |
297 | 2023-10-01 11:59:40 | crafting | 1 | 82945 | 5 | 1.296 | 64000.8 |
296 | 2023-09-23 03:08:17 | crafting | 1 | 82945 | 5 | 1.453 | 57085.3 |
295 | 2023-09-20 18:48:51 | crafting | 1 | 82945 | 5 | 1.500 | 55296.7 |
294 | 2023-08-17 05:05:24 | crafting | 1 | 82945 | 5 | 2.860 | 29001.7 |
293 | 2023-08-13 22:02:43 | crafting | 1 | 82945 | 5 | 1.436 | 57761.1 |
292 | 2023-08-05 01:46:33 | crafting | 2 | 121059 | 54 | 3.376 | 35858.7 |
291 | 2023-07-29 04:36:34 | crafting | 1 | 82945 | 5 | 1.423 | 58288.8 |
290 | 2023-06-21 05:42:34 | crafting | 1 | 82945 | 5 | 1.330 | 62364.7 |
289 | 2023-05-06 16:43:58 | crafting | 1 | 82945 | 5 | 1.283 | 64649.3 |
288 | 2023-04-24 13:49:39 | crafting | 1 | 82945 | 5 | 1.516 | 54713.1 |
287 | 2023-04-17 10:20:05 | crafting | 2 | 121059 | 54 | 3.216 | 37642.7 |
286 | 2023-02-12 21:10:28 | crafting | 1 | 82945 | 5 | 1.466 | 56579.1 |
285 | 2023-01-24 08:41:47 | crafting | 1 | 82945 | 5 | 1.546 | 53651.4 |
284 | 2023-01-22 14:00:49 | crafting | 2 | 121059 | 54 | 7.046 | 17181.2 |
283 | 2022-12-10 01:18:06 | crafting | 1 | 82945 | 5 | 1.516 | 54713.1 |
282 | 2022-11-02 01:02:14 | crafting | 2 | 121059 | 54 | 3.250 | 37248.9 |
281 | 2022-10-10 00:23:21 | crafting | 1 | 82945 | 5 | 1.330 | 62364.7 |
280 | 2022-09-30 17:49:46 | crafting | 1 | 82945 | 5 | 1.343 | 61761.0 |
279 | 2022-08-13 09:23:30 | crafting | 1 | 82945 | 5 | 1.313 | 63172.1 |
278 | 2022-06-23 09:19:12 | crafting | 1 | 82945 | 5 | 1.330 | 62364.7 |
277 | 2022-05-18 11:15:27 | crafting | 1 | 82945 | 5 | 1.296 | 64000.8 |
276 | 2022-05-18 03:14:29 | crafting | 2 | 121059 | 54 | 3.330 | 36354.1 |
275 | 2022-04-04 14:04:31 | crafting | 1 | 82945 | 5 | 1.906 | 43517.8 |
274 | 2022-03-07 10:00:07 | crafting | 1 | 82945 | 5 | 1.516 | 54713.1 |
273 | 2022-03-03 23:27:01 | crafting | 1 | 82945 | 5 | 1.330 | 62364.7 |
272 | 2022-01-03 23:59:10 | crafting | 1 | 82945 | 5 | 1.563 | 53067.8 |
271 | 2021-11-20 07:40:10 | crafting | 1 | 82945 | 5 | 1.326 | 62552.8 |
270 | 2021-11-09 19:22:43 | crafting | 1 | 82945 | 5 | 1.546 | 53651.4 |
269 | 2021-11-08 10:42:15 | crafting | 1 | 82945 | 5 | 1.626 | 51011.7 |
268 | 2021-11-06 10:53:10 | crafting | 1 | 82945 | 5 | 1.656 | 50087.6 |
267 | 2021-09-23 21:29:23 | crafting | 1 | 82945 | 5 | 1.406 | 58993.6 |
266 | 2021-09-21 18:52:54 | crafting | 1 | 82945 | 5 | 1.373 | 60411.5 |
265 | 2021-09-02 04:45:43 | crafting | 1 | 82945 | 5 | 1.296 | 64000.8 |
264 | 2021-08-17 10:59:44 | crafting | 1 | 82945 | 5 | 1.313 | 63172.1 |
263 | 2021-08-02 22:35:59 | crafting | 1 | 82945 | 5 | 1.283 | 64649.3 |
262 | 2021-07-26 03:03:31 | crafting | 1 | 82945 | 5 | 1.440 | 57600.7 |
261 | 2021-06-16 11:33:24 | crafting | 3 | 146162 | 488 | 6.686 | 21860.9 |
260 | 2021-06-13 07:44:59 | crafting | 2 | 121059 | 54 | 5.873 | 20612.8 |
259 | 2021-06-05 12:38:05 | crafting | 1 | 82945 | 5 | 1.296 | 64000.8 |
258 | 2021-05-16 19:33:05 | crafting | 1 | 82945 | 5 | 1.420 | 58412.0 |
257 | 2021-05-16 08:50:46 | crafting | 1 | 82945 | 5 | 1.440 | 57600.7 |
256 | 2021-04-20 14:14:44 | crafting | 2 | 121059 | 54 | 3.436 | 35232.5 |
255 | 2021-04-16 00:55:59 | crafting | 1 | 82945 | 5 | 1.453 | 57085.3 |
254 | 2021-04-03 02:54:59 | crafting | 3 | 146162 | 488 | 7.530 | 19410.6 |
253 | 2021-03-19 03:37:13 | crafting | 1 | 82945 | 5 | 1.890 | 43886.2 |
252 | 2021-02-11 13:41:31 | crafting | 3 | 146162 | 488 | 6.500 | 22486.5 |
251 | 2021-02-09 18:34:10 | crafting | 1 | 82945 | 5 | 1.500 | 55296.7 |
250 | 2021-02-04 08:13:18 | crafting | 1 | 82945 | 5 | 1.483 | 55930.5 |
249 | 2020-12-31 08:47:49 | crafting | 1 | 82945 | 5 | 1.593 | 52068.4 |
248 | 2020-12-14 03:46:28 | crafting | 3 | 146162 | 488 | 6.593 | 22169.3 |
247 | 2020-12-08 01:12:56 | crafting | 2 | 121059 | 54 | 3.376 | 35858.7 |
246 | 2020-11-10 07:34:15 | crafting | 3 | 146162 | 488 | 6.843 | 21359.3 |
245 | 2020-11-04 20:58:37 | crafting | 1 | 82945 | 5 | 1.356 | 61168.9 |
244 | 2020-11-02 22:37:21 | crafting | 1 | 82945 | 5 | 1.516 | 54713.1 |
243 | 2020-10-29 03:00:38 | crafting | 3 | 146162 | 488 | 7.500 | 19488.3 |
242 | 2020-10-27 05:30:04 | crafting | 1 | 82945 | 5 | 1.483 | 55930.5 |
241 | 2020-10-22 22:31:16 | crafting | 1 | 82945 | 5 | 3.000 | 27648.3 |
240 | 2020-10-04 00:57:14 | crafting | 3 | 146162 | 488 | 6.436 | 22710.1 |
239 | 2020-09-23 09:35:55 | crafting | 1 | 82945 | 5 | 1.280 | 64800.8 |
238 | 2020-09-23 04:25:52 | crafting | 1 | 82945 | 5 | 1.296 | 64000.8 |
237 | 2020-09-11 12:35:14 | crafting | 2 | 121059 | 54 | 3.296 | 36729.1 |
236 | 2020-08-30 05:07:34 | crafting | 1 | 82945 | 5 | 1.500 | 55296.7 |