History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lineages"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
392 | 2024-04-20 23:07:26 | lineages | 1 | 82945 | 4 | 5.390 | 15388.7 |
391 | 2024-04-13 07:35:44 | lineages | 1 | 82945 | 4 | 1.563 | 53067.8 |
390 | 2024-04-06 08:06:39 | lineages | 3 | 146162 | 194 | 31.843 | 4590.1 |
389 | 2024-04-05 03:13:34 | lineages | 3 | 146162 | 194 | 12.703 | 11506.1 |
388 | 2024-04-03 16:14:09 | lineages | 3 | 146162 | 194 | 13.513 | 10816.4 |
387 | 2024-04-01 02:23:31 | lineages | 3 | 146162 | 194 | 15.190 | 9622.3 |
386 | 2024-04-01 01:43:52 | lineages | 2 | 121059 | 21 | 9.843 | 12299.0 |
385 | 2024-04-01 01:43:51 | lineages | 3 | 146162 | 194 | 8.906 | 16411.6 |
384 | 2024-04-01 01:43:46 | lineages | 1 | 82945 | 4 | 3.593 | 23085.2 |
383 | 2024-03-30 08:56:23 | lineages | 1 | 82945 | 4 | 4.796 | 17294.6 |
382 | 2024-03-23 02:23:28 | lineages | 2 | 121059 | 21 | 4.313 | 28068.4 |
381 | 2024-03-22 04:19:28 | lineages | 2 | 121059 | 21 | 3.813 | 31749.0 |
380 | 2024-03-04 21:21:15 | lineages | 1 | 82945 | 4 | 1.720 | 48223.8 |
379 | 2024-01-28 03:48:58 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
378 | 2024-01-04 02:40:52 | lineages | 1 | 82945 | 4 | 1.420 | 58412.0 |
377 | 2023-12-13 13:44:30 | lineages | 1 | 82945 | 4 | 1.313 | 63172.1 |
376 | 2023-12-06 13:14:03 | lineages | 1 | 82945 | 4 | 1.420 | 58412.0 |
375 | 2023-12-02 11:56:20 | lineages | 2 | 121059 | 21 | 3.750 | 32282.4 |
374 | 2023-12-01 09:08:23 | lineages | 3 | 146162 | 194 | 7.233 | 20207.7 |
373 | 2023-12-01 09:08:24 | lineages | 2 | 121059 | 21 | 3.703 | 32692.1 |
372 | 2023-11-14 03:01:26 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
371 | 2023-11-10 03:58:53 | lineages | 1 | 82945 | 4 | 1.390 | 59672.7 |
370 | 2023-10-25 22:20:55 | lineages | 1 | 82945 | 4 | 1.356 | 61168.9 |
369 | 2023-10-06 07:50:21 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
368 | 2023-09-30 03:15:57 | lineages | 1 | 82945 | 4 | 1.533 | 54106.3 |
367 | 2023-08-30 14:47:22 | lineages | 2 | 121059 | 21 | 3.970 | 30493.5 |
366 | 2023-08-21 10:15:54 | lineages | 1 | 82945 | 4 | 1.330 | 62364.7 |
365 | 2023-06-22 14:14:18 | lineages | 1 | 82945 | 4 | 1.393 | 59544.1 |
364 | 2023-06-05 01:56:30 | lineages | 3 | 146162 | 194 | 6.376 | 22923.8 |
363 | 2023-05-23 02:56:27 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
362 | 2023-05-15 18:53:59 | lineages | 2 | 121059 | 21 | 3.486 | 34727.2 |
361 | 2023-05-11 11:39:38 | lineages | 3 | 146162 | 194 | 7.216 | 20255.3 |
360 | 2023-04-25 01:21:24 | lineages | 2 | 121059 | 21 | 3.266 | 37066.4 |
359 | 2023-04-24 23:56:26 | lineages | 2 | 121059 | 21 | 3.046 | 39743.6 |
358 | 2023-04-12 13:42:38 | lineages | 3 | 146162 | 194 | 6.096 | 23976.7 |
357 | 2023-03-27 19:02:44 | lineages | 2 | 121059 | 21 | 3.500 | 34588.3 |
356 | 2023-03-21 14:19:27 | lineages | 3 | 146162 | 194 | 8.156 | 17920.8 |
355 | 2023-03-20 13:39:35 | lineages | 1 | 82945 | 4 | 1.360 | 60989.0 |
354 | 2023-03-03 19:34:30 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
353 | 2023-02-23 12:43:10 | lineages | 2 | 121059 | 21 | 3.280 | 36908.2 |
352 | 2023-01-26 00:00:06 | lineages | 3 | 146162 | 194 | 6.580 | 22213.1 |
351 | 2023-01-22 10:42:31 | lineages | 3 | 146162 | 194 | 6.093 | 23988.5 |
350 | 2023-01-06 00:07:39 | lineages | 1 | 82945 | 4 | 1.296 | 64000.8 |
349 | 2022-12-11 18:55:05 | lineages | 3 | 146162 | 194 | 6.250 | 23385.9 |
348 | 2022-12-04 22:37:59 | lineages | 2 | 121059 | 21 | 3.046 | 39743.6 |
347 | 2022-12-04 11:29:52 | lineages | 3 | 146162 | 194 | 7.580 | 19282.6 |
346 | 2022-12-03 09:23:26 | lineages | 3 | 146162 | 194 | 10.970 | 13323.8 |
345 | 2022-11-11 10:11:14 | lineages | 1 | 82945 | 4 | 1.406 | 58993.6 |
344 | 2022-11-07 23:36:02 | lineages | 1 | 82945 | 4 | 1.220 | 67987.7 |
343 | 2022-11-06 17:17:28 | lineages | 3 | 146162 | 194 | 6.626 | 22058.9 |
342 | 2022-11-06 17:17:24 | lineages | 3 | 146162 | 194 | 7.126 | 20511.1 |
341 | 2022-09-28 09:51:22 | lineages | 1 | 82945 | 4 | 1.263 | 65673.0 |
340 | 2022-07-22 06:44:37 | lineages | 1 | 82945 | 4 | 1.216 | 68211.3 |
339 | 2022-06-29 19:13:44 | lineages | 3 | 146162 | 194 | 6.190 | 23612.6 |
338 | 2022-06-27 20:33:37 | lineages | 3 | 146162 | 194 | 7.466 | 19577.0 |
337 | 2022-06-25 17:39:12 | lineages | 3 | 146162 | 194 | 6.250 | 23385.9 |
336 | 2022-06-24 21:50:20 | lineages | 3 | 146162 | 194 | 6.186 | 23627.9 |
335 | 2022-06-23 19:11:05 | lineages | 3 | 146162 | 194 | 6.220 | 23498.7 |
334 | 2022-06-22 18:44:34 | lineages | 3 | 146162 | 194 | 6.186 | 23627.9 |
333 | 2022-06-21 23:50:19 | lineages | 3 | 146162 | 194 | 6.890 | 21213.6 |
332 | 2022-06-19 17:14:01 | lineages | 3 | 146162 | 194 | 6.216 | 23513.8 |
331 | 2022-06-18 23:08:55 | lineages | 3 | 146162 | 194 | 6.986 | 20922.1 |
330 | 2022-06-14 22:44:34 | lineages | 3 | 146162 | 194 | 6.423 | 22756.0 |
329 | 2022-05-09 20:50:17 | lineages | 1 | 82945 | 4 | 1.500 | 55296.7 |
328 | 2022-05-07 16:32:30 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
327 | 2022-05-05 14:04:34 | lineages | 1 | 82945 | 4 | 1.343 | 61761.0 |
326 | 2022-04-16 16:33:25 | lineages | 2 | 121059 | 21 | 3.283 | 36874.5 |
325 | 2022-04-03 21:59:18 | lineages | 1 | 82945 | 4 | 1.376 | 60279.8 |
324 | 2022-01-24 12:51:49 | lineages | 1 | 82945 | 4 | 1.406 | 58993.6 |
323 | 2022-01-22 08:37:51 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
322 | 2022-01-20 04:39:50 | lineages | 1 | 82945 | 4 | 1.373 | 60411.5 |
321 | 2021-12-31 06:52:52 | lineages | 3 | 146162 | 194 | 7.250 | 20160.3 |
320 | 2021-12-20 04:18:33 | lineages | 1 | 82945 | 4 | 1.406 | 58993.6 |
319 | 2021-12-19 00:38:30 | lineages | 3 | 146162 | 194 | 6.953 | 21021.4 |
318 | 2021-11-13 19:59:35 | lineages | 1 | 82945 | 4 | 1.423 | 58288.8 |
317 | 2021-11-12 13:51:24 | lineages | 3 | 146162 | 194 | 6.486 | 22535.0 |
316 | 2021-10-01 11:51:07 | lineages | 1 | 82945 | 4 | 1.233 | 67270.9 |
315 | 2021-09-09 17:15:24 | lineages | 1 | 82945 | 4 | 1.423 | 58288.8 |
314 | 2021-08-29 23:56:46 | lineages | 1 | 82945 | 4 | 1.263 | 65673.0 |
313 | 2021-08-14 18:53:22 | lineages | 1 | 82945 | 4 | 1.250 | 66356.0 |
312 | 2021-08-10 08:37:07 | lineages | 3 | 146162 | 194 | 6.423 | 22756.0 |
311 | 2021-06-08 18:27:34 | lineages | 1 | 82945 | 4 | 1.266 | 65517.4 |
310 | 2021-06-02 15:10:13 | lineages | 3 | 146162 | 194 | 7.486 | 19524.7 |
309 | 2021-05-29 09:32:04 | lineages | 2 | 121059 | 21 | 3.423 | 35366.3 |
308 | 2021-05-08 10:15:04 | lineages | 3 | 146162 | 194 | 8.110 | 18022.4 |
307 | 2021-05-02 11:11:19 | lineages | 1 | 82945 | 4 | 1.450 | 57203.4 |
306 | 2021-04-02 00:33:56 | lineages | 2 | 121059 | 21 | 3.470 | 34887.3 |
305 | 2021-03-06 15:32:51 | lineages | 2 | 121059 | 21 | 3.453 | 35059.1 |
304 | 2021-03-06 12:15:48 | lineages | 1 | 82945 | 4 | 1.266 | 65517.4 |
303 | 2021-03-03 07:06:25 | lineages | 1 | 82945 | 4 | 1.360 | 60989.0 |
302 | 2021-02-03 08:41:37 | lineages | 1 | 82945 | 4 | 1.280 | 64800.8 |
301 | 2021-01-06 22:16:59 | lineages | 3 | 146162 | 194 | 6.313 | 23152.5 |
300 | 2020-11-27 17:36:37 | lineages | 1 | 82945 | 4 | 1.283 | 64649.3 |
299 | 2020-11-22 09:05:56 | lineages | 2 | 121059 | 21 | 3.093 | 39139.7 |
298 | 2020-11-14 01:42:07 | lineages | 3 | 146162 | 194 | 6.376 | 22923.8 |
297 | 2020-11-08 19:36:40 | lineages | 3 | 146162 | 194 | 6.343 | 23043.0 |
296 | 2020-10-31 05:04:10 | lineages | 2 | 121059 | 21 | 3.750 | 32282.4 |
295 | 2020-10-28 10:54:42 | lineages | 2 | 121059 | 21 | 3.390 | 35710.6 |
294 | 2020-10-27 17:40:49 | lineages | 3 | 146162 | 194 | 7.376 | 19815.9 |
293 | 2020-10-24 15:44:51 | lineages | 3 | 146162 | 194 | 6.313 | 23152.5 |