History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
522 | 2024-05-09 01:22:11 | transect | 3 | 146162 | 70 | 21.640 | 6754.3 |
521 | 2024-05-07 22:01:34 | transect | 3 | 146162 | 70 | 16.533 | 8840.6 |
520 | 2024-05-06 22:00:24 | transect | 2 | 121059 | 15 | 8.203 | 14757.9 |
519 | 2024-05-06 22:00:15 | transect | 3 | 146162 | 70 | 10.003 | 14611.8 |
518 | 2024-05-06 02:12:49 | transect | 3 | 146162 | 70 | 8.970 | 16294.5 |
517 | 2024-05-05 23:31:17 | transect | 3 | 146162 | 70 | 11.440 | 12776.4 |
516 | 2024-05-05 21:08:15 | transect | 1 | 82945 | 5 | 1.513 | 54821.5 |
515 | 2024-05-05 21:06:24 | transect | 2 | 121059 | 15 | 5.033 | 24053.0 |
514 | 2024-05-05 21:06:20 | transect | 3 | 146162 | 70 | 8.780 | 16647.2 |
513 | 2024-05-05 21:06:16 | transect | 1 | 82945 | 5 | 1.563 | 53067.8 |
512 | 2024-05-01 08:57:51 | transect | 4 | 161609 | 672 | 15.906 | 10160.3 |
511 | 2024-04-29 09:35:31 | transect | 4 | 161609 | 672 | 15.346 | 10531.0 |
510 | 2024-04-29 01:44:20 | transect | 4 | 161609 | 672 | 14.563 | 11097.2 |
509 | 2024-04-29 01:08:35 | transect | 4 | 161609 | 672 | 14.720 | 10978.9 |
508 | 2024-04-28 23:49:12 | transect | 4 | 161609 | 672 | 13.563 | 11915.4 |
507 | 2024-04-13 16:20:55 | transect | 1 | 82945 | 5 | 1.373 | 60411.5 |
506 | 2024-04-10 09:43:21 | transect | 3 | 146162 | 70 | 8.220 | 17781.3 |
505 | 2024-04-08 05:34:14 | transect | 2 | 121059 | 15 | 7.690 | 15742.4 |
504 | 2024-04-08 05:34:00 | transect | 1 | 82945 | 5 | 1.653 | 50178.5 |
503 | 2024-04-07 07:27:18 | transect | 3 | 146162 | 70 | 17.156 | 8519.6 |
502 | 2024-04-05 13:48:34 | transect | 2 | 121059 | 15 | 11.516 | 10512.2 |
501 | 2024-04-05 08:38:53 | transect | 1 | 82945 | 5 | 1.986 | 41764.9 |
500 | 2024-04-05 08:38:38 | transect | 3 | 146162 | 70 | 15.423 | 9476.9 |
499 | 2024-04-05 08:38:39 | transect | 2 | 121059 | 15 | 8.593 | 14088.1 |
498 | 2024-04-05 08:38:29 | transect | 1 | 82945 | 5 | 3.250 | 25521.5 |
497 | 2024-03-30 03:48:47 | transect | 4 | 161609 | 672 | 35.410 | 4563.9 |
496 | 2024-03-29 03:34:40 | transect | 4 | 161609 | 672 | 26.783 | 6034.0 |
495 | 2024-03-26 16:05:02 | transect | 4 | 161609 | 672 | 11.753 | 13750.4 |
494 | 2024-03-12 04:17:31 | transect | 3 | 146162 | 70 | 8.013 | 18240.6 |
493 | 2024-03-12 04:17:32 | transect | 2 | 121059 | 15 | 3.920 | 30882.4 |
492 | 2024-03-12 04:17:31 | transect | 1 | 82945 | 5 | 1.483 | 55930.5 |
491 | 2024-03-10 10:18:19 | transect | 1 | 82945 | 5 | 3.376 | 24569.0 |
490 | 2024-03-07 09:06:09 | transect | 4 | 161609 | 672 | 27.610 | 5853.3 |
489 | 2024-03-07 05:47:09 | transect | 2 | 121059 | 15 | 5.936 | 20394.0 |
488 | 2024-03-06 22:30:37 | transect | 3 | 146162 | 70 | 26.626 | 5489.4 |
487 | 2024-03-06 17:41:43 | transect | 3 | 146162 | 70 | 16.983 | 8606.4 |
486 | 2024-03-05 02:35:49 | transect | 3 | 146162 | 70 | 17.923 | 8155.0 |
485 | 2024-03-05 02:35:51 | transect | 2 | 121059 | 15 | 4.453 | 27185.9 |
484 | 2024-03-05 02:35:46 | transect | 1 | 82945 | 5 | 1.406 | 58993.6 |
483 | 2024-03-05 02:35:25 | transect | 3 | 146162 | 70 | 15.910 | 9186.8 |
482 | 2024-03-05 02:35:33 | transect | 1 | 82945 | 5 | 3.126 | 26533.9 |
481 | 2024-03-05 02:35:27 | transect | 2 | 121059 | 15 | 4.296 | 28179.5 |
480 | 2024-03-05 02:35:21 | transect | 1 | 82945 | 5 | 1.516 | 54713.1 |
479 | 2024-03-01 13:53:13 | transect | 1 | 82945 | 5 | 2.673 | 31030.7 |
478 | 2024-03-01 13:52:20 | transect | 4 | 161609 | 672 | 15.736 | 10270.0 |
477 | 2024-03-01 01:25:01 | transect | 1 | 82945 | 5 | 1.406 | 58993.6 |
476 | 2024-02-26 05:56:19 | transect | 4 | 161609 | 672 | 41.703 | 3875.2 |
475 | 2024-02-25 09:36:06 | transect | 4 | 161609 | 672 | 11.673 | 13844.7 |
474 | 2024-02-18 23:18:14 | transect | 4 | 161609 | 672 | 16.140 | 10012.9 |
473 | 2024-02-04 04:12:15 | transect | 4 | 161609 | 672 | 16.373 | 9870.5 |
472 | 2024-02-04 04:12:11 | transect | 3 | 146162 | 70 | 8.296 | 17618.4 |
471 | 2024-01-31 19:36:44 | transect | 3 | 146162 | 70 | 8.423 | 17352.7 |
470 | 2024-01-31 19:16:24 | transect | 2 | 121059 | 15 | 3.716 | 32577.8 |
469 | 2024-01-31 08:57:31 | transect | 3 | 146162 | 70 | 8.050 | 18156.8 |
468 | 2024-01-31 08:57:35 | transect | 2 | 121059 | 15 | 3.986 | 30371.0 |
467 | 2024-01-31 08:57:30 | transect | 3 | 146162 | 70 | 7.656 | 19091.2 |
466 | 2024-01-31 08:57:26 | transect | 2 | 121059 | 15 | 3.436 | 35232.5 |
465 | 2024-01-31 08:57:27 | transect | 1 | 82945 | 5 | 1.500 | 55296.7 |
464 | 2024-01-31 08:57:22 | transect | 1 | 82945 | 5 | 1.436 | 57761.1 |
463 | 2024-01-27 00:14:21 | transect | 4 | 161609 | 672 | 12.643 | 12782.5 |
462 | 2024-01-26 23:15:31 | transect | 4 | 161609 | 672 | 14.390 | 11230.6 |
461 | 2024-01-12 12:39:15 | transect | 4 | 161609 | 672 | 13.656 | 11834.3 |
460 | 2024-01-09 10:30:33 | transect | 4 | 161609 | 672 | 14.406 | 11218.2 |
459 | 2023-12-30 15:03:00 | transect | 1 | 82945 | 5 | 1.453 | 57085.3 |
458 | 2023-12-30 03:18:59 | transect | 2 | 121059 | 15 | 3.156 | 38358.4 |
457 | 2023-12-28 12:02:50 | transect | 3 | 146162 | 70 | 6.313 | 23152.5 |
456 | 2023-12-15 18:23:41 | transect | 1 | 82945 | 5 | 1.470 | 56425.2 |
455 | 2023-12-10 23:06:01 | transect | 1 | 82945 | 5 | 1.453 | 57085.3 |
454 | 2023-11-16 05:10:11 | transect | 4 | 161609 | 672 | 11.893 | 13588.6 |
453 | 2023-10-24 12:31:28 | transect | 1 | 82945 | 5 | 1.500 | 55296.7 |
452 | 2023-10-03 03:37:03 | transect | 2 | 121059 | 15 | 3.266 | 37066.4 |
451 | 2023-09-29 19:12:05 | transect | 3 | 146162 | 70 | 6.466 | 22604.7 |
450 | 2023-09-24 05:10:37 | transect | 1 | 82945 | 5 | 1.250 | 66356.0 |
449 | 2023-08-17 12:27:06 | transect | 4 | 161609 | 672 | 10.783 | 14987.4 |
448 | 2023-07-19 18:11:39 | transect | 1 | 82945 | 5 | 1.266 | 65517.4 |
447 | 2023-06-09 19:12:47 | transect | 1 | 82945 | 5 | 1.263 | 65673.0 |
446 | 2023-05-02 16:35:25 | transect | 4 | 161609 | 672 | 10.766 | 15011.1 |
445 | 2023-04-19 17:40:48 | transect | 1 | 82945 | 5 | 1.423 | 58288.8 |
444 | 2023-04-04 12:04:18 | transect | 2 | 121059 | 15 | 3.266 | 37066.4 |
443 | 2023-03-23 20:31:19 | transect | 3 | 146162 | 70 | 6.423 | 22756.0 |
442 | 2023-02-07 19:35:23 | transect | 4 | 161609 | 672 | 10.720 | 15075.5 |
441 | 2023-02-07 04:44:11 | transect | 1 | 82945 | 5 | 1.250 | 66356.0 |
440 | 2023-01-21 01:16:29 | transect | 1 | 82945 | 5 | 1.250 | 66356.0 |
439 | 2022-12-30 20:49:22 | transect | 2 | 121059 | 15 | 3.170 | 38189.0 |
438 | 2022-12-24 09:02:55 | transect | 3 | 146162 | 70 | 7.750 | 18859.6 |
437 | 2022-12-05 14:32:23 | transect | 1 | 82945 | 5 | 1.390 | 59672.7 |
436 | 2022-11-19 19:09:50 | transect | 4 | 161609 | 672 | 10.783 | 14987.4 |
435 | 2022-09-08 00:42:31 | transect | 1 | 82945 | 5 | 1.280 | 64800.8 |
434 | 2022-08-31 22:42:38 | transect | 2 | 121059 | 15 | 3.173 | 38152.9 |
433 | 2022-08-23 07:47:15 | transect | 3 | 146162 | 70 | 6.373 | 22934.6 |
432 | 2022-07-31 14:51:52 | transect | 1 | 82945 | 5 | 1.280 | 64800.8 |
431 | 2022-06-23 16:18:18 | transect | 4 | 161609 | 672 | 10.736 | 15053.0 |
430 | 2022-06-21 12:15:53 | transect | 4 | 161609 | 672 | 10.986 | 14710.4 |
429 | 2022-04-21 10:31:49 | transect | 1 | 82945 | 5 | 1.843 | 45005.4 |
428 | 2022-04-05 18:02:38 | transect | 1 | 82945 | 5 | 1.813 | 45750.1 |
427 | 2022-04-03 14:06:55 | transect | 1 | 82945 | 5 | 1.263 | 65673.0 |
426 | 2022-03-21 19:42:36 | transect | 2 | 121059 | 15 | 3.750 | 32282.4 |
425 | 2022-03-20 20:58:58 | transect | 2 | 121059 | 15 | 3.720 | 32542.7 |
424 | 2022-03-15 13:21:45 | transect | 2 | 121059 | 15 | 5.156 | 23479.2 |
423 | 2022-03-13 21:20:14 | transect | 2 | 121059 | 15 | 3.343 | 36212.7 |