History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prenames"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
634 | 2025-04-28 00:43:57 | prenames | 3 | 146162 | 283 | 46.690 | 3130.5 |
633 | 2025-04-26 01:15:27 | prenames | 3 | 146162 | 283 | 37.646 | 3882.5 |
632 | 2025-04-25 15:29:21 | prenames | 2 | 121059 | 28 | 20.580 | 5882.4 |
631 | 2025-04-25 08:26:46 | prenames | 3 | 146162 | 283 | 38.753 | 3771.6 |
630 | 2025-04-23 07:54:39 | prenames | 1 | 82945 | 4 | 4.483 | 18502.1 |
629 | 2025-04-15 09:20:59 | prenames | 1 | 82945 | 4 | 10.203 | 8129.5 |
628 | 2025-04-15 04:59:02 | prenames | 1 | 82945 | 4 | 6.846 | 12115.8 |
627 | 2025-04-14 03:02:53 | prenames | 1 | 82945 | 4 | 4.623 | 17941.8 |
626 | 2025-04-14 02:11:52 | prenames | 1 | 82945 | 4 | 6.703 | 12374.3 |
625 | 2025-03-31 16:39:29 | prenames | 1 | 82945 | 4 | 7.156 | 11591.0 |
624 | 2025-03-27 19:04:29 | prenames | 3 | 146162 | 283 | 23.686 | 6170.8 |
623 | 2025-03-27 02:03:14 | prenames | 3 | 146162 | 283 | 23.580 | 6198.6 |
622 | 2025-03-25 15:50:24 | prenames | 3 | 146162 | 283 | 30.236 | 4834.0 |
621 | 2025-03-25 11:13:14 | prenames | 3 | 146162 | 283 | 52.520 | 2783.0 |
620 | 2025-03-25 02:23:24 | prenames | 3 | 146162 | 283 | 39.296 | 3719.5 |
619 | 2025-03-24 18:42:54 | prenames | 2 | 121059 | 28 | 5.360 | 22585.6 |
618 | 2025-03-22 17:34:07 | prenames | 2 | 121059 | 28 | 31.813 | 3805.3 |
617 | 2025-03-22 16:51:35 | prenames | 3 | 146162 | 283 | 21.533 | 6787.8 |
616 | 2025-03-22 12:13:42 | prenames | 2 | 121059 | 28 | 27.800 | 4354.6 |
615 | 2025-03-22 08:48:11 | prenames | 1 | 82945 | 4 | 4.376 | 18954.5 |
614 | 2025-03-19 12:44:05 | prenames | 2 | 121059 | 28 | 3.626 | 33386.4 |
613 | 2025-03-13 14:55:07 | prenames | 1 | 82945 | 4 | 7.080 | 11715.4 |
612 | 2025-03-13 00:35:15 | prenames | 1 | 82945 | 4 | 6.923 | 11981.1 |
611 | 2025-03-12 21:11:28 | prenames | 1 | 82945 | 4 | 6.440 | 12879.7 |
610 | 2025-03-12 04:14:22 | prenames | 1 | 82945 | 4 | 8.810 | 9414.9 |
609 | 2025-03-10 00:40:30 | prenames | 1 | 82945 | 4 | 5.860 | 14154.4 |
608 | 2025-03-02 18:25:01 | prenames | 1 | 82945 | 4 | 5.626 | 14743.2 |
607 | 2025-03-01 10:50:00 | prenames | 1 | 82945 | 4 | 4.940 | 16790.5 |
606 | 2025-02-10 08:46:27 | prenames | 1 | 82945 | 4 | 1.296 | 64000.8 |
605 | 2025-02-08 14:27:59 | prenames | 2 | 121059 | 28 | 3.593 | 33693.0 |
604 | 2025-02-08 03:57:12 | prenames | 2 | 121059 | 28 | 19.096 | 6339.5 |
603 | 2025-02-08 03:54:36 | prenames | 1 | 82945 | 4 | 1.470 | 56425.2 |
602 | 2025-02-07 16:32:40 | prenames | 2 | 121059 | 28 | 12.780 | 9472.5 |
601 | 2025-02-07 16:29:20 | prenames | 3 | 146162 | 283 | 8.516 | 17163.2 |
600 | 2025-02-06 05:49:36 | prenames | 3 | 146162 | 283 | 55.646 | 2626.6 |
599 | 2025-02-06 04:29:43 | prenames | 3 | 146162 | 283 | 32.140 | 4547.7 |
598 | 2025-02-06 00:59:38 | prenames | 3 | 146162 | 283 | 32.610 | 4482.1 |
597 | 2025-02-06 00:59:39 | prenames | 2 | 121059 | 28 | 19.576 | 6184.1 |
596 | 2025-02-06 00:59:38 | prenames | 1 | 82945 | 4 | 10.453 | 7935.0 |
595 | 2025-01-24 23:04:50 | prenames | 1 | 82945 | 4 | 6.453 | 12853.7 |
594 | 2025-01-08 14:38:32 | prenames | 1 | 82945 | 4 | 5.343 | 15524.1 |
593 | 2024-12-20 09:47:02 | prenames | 1 | 82945 | 4 | 10.936 | 7584.6 |
592 | 2024-12-18 10:16:50 | prenames | 1 | 82945 | 4 | 8.560 | 9689.8 |
591 | 2024-12-15 16:36:10 | prenames | 1 | 82945 | 4 | 7.076 | 11722.0 |
590 | 2024-12-07 04:15:16 | prenames | 2 | 121059 | 28 | 13.516 | 8956.7 |
589 | 2024-12-07 04:15:11 | prenames | 1 | 82945 | 4 | 4.500 | 18432.2 |
588 | 2024-12-06 04:30:39 | prenames | 1 | 82945 | 4 | 6.563 | 12638.3 |
587 | 2024-11-19 15:49:03 | prenames | 1 | 82945 | 4 | 6.890 | 12038.5 |
586 | 2024-11-10 09:41:02 | prenames | 1 | 82945 | 4 | 1.546 | 53651.4 |
585 | 2024-11-08 13:46:23 | prenames | 3 | 146162 | 283 | 37.443 | 3903.6 |
584 | 2024-11-08 09:41:31 | prenames | 3 | 146162 | 283 | 25.816 | 5661.7 |
583 | 2024-11-08 07:18:00 | prenames | 3 | 146162 | 283 | 40.333 | 3623.9 |
582 | 2024-11-06 16:38:53 | prenames | 1 | 82945 | 4 | 3.450 | 24042.0 |
581 | 2024-11-05 05:10:55 | prenames | 1 | 82945 | 4 | 10.050 | 8253.2 |
580 | 2024-10-20 04:32:31 | prenames | 1 | 82945 | 4 | 3.860 | 21488.3 |
579 | 2024-10-16 04:36:22 | prenames | 1 | 82945 | 4 | 7.463 | 11114.2 |
578 | 2024-10-12 05:06:43 | prenames | 2 | 121059 | 28 | 24.940 | 4854.0 |
577 | 2024-10-12 03:27:59 | prenames | 2 | 121059 | 28 | 9.593 | 12619.5 |
576 | 2024-10-11 04:38:15 | prenames | 1 | 82945 | 4 | 10.283 | 8066.2 |
575 | 2024-10-07 10:39:36 | prenames | 2 | 121059 | 28 | 25.500 | 4747.4 |
574 | 2024-10-07 10:39:34 | prenames | 1 | 82945 | 4 | 10.483 | 7912.3 |
573 | 2024-10-01 15:51:09 | prenames | 1 | 82945 | 4 | 15.016 | 5523.8 |
572 | 2024-09-20 03:16:36 | prenames | 2 | 121059 | 28 | 23.250 | 5206.8 |
571 | 2024-09-19 13:22:08 | prenames | 3 | 146162 | 283 | 57.830 | 2527.4 |
570 | 2024-09-19 13:22:23 | prenames | 2 | 121059 | 28 | 29.783 | 4064.7 |
569 | 2024-09-19 13:21:57 | prenames | 1 | 82945 | 4 | 5.640 | 14706.6 |
568 | 2024-09-10 07:52:51 | prenames | 1 | 82945 | 4 | 15.390 | 5389.5 |
567 | 2024-09-04 19:28:16 | prenames | 1 | 82945 | 4 | 9.903 | 8375.7 |
566 | 2024-08-28 20:10:48 | prenames | 2 | 121059 | 28 | 4.500 | 26902.0 |
565 | 2024-08-28 20:10:48 | prenames | 1 | 82945 | 4 | 2.123 | 39069.7 |
564 | 2024-08-28 16:52:43 | prenames | 1 | 82945 | 4 | 1.326 | 62552.8 |
563 | 2024-08-15 04:22:51 | prenames | 1 | 82945 | 4 | 5.656 | 14665.0 |
562 | 2024-08-11 22:30:31 | prenames | 1 | 82945 | 4 | 6.563 | 12638.3 |
561 | 2024-08-09 04:04:24 | prenames | 3 | 146162 | 283 | 16.580 | 8815.6 |
560 | 2024-08-08 10:25:20 | prenames | 3 | 146162 | 283 | 26.576 | 5499.8 |
559 | 2024-08-04 07:32:27 | prenames | 1 | 82945 | 4 | 4.953 | 16746.4 |
558 | 2024-08-03 01:22:17 | prenames | 3 | 146162 | 283 | 22.093 | 6615.8 |
557 | 2024-08-03 00:24:24 | prenames | 3 | 146162 | 283 | 24.360 | 6000.1 |
556 | 2024-08-02 23:46:19 | prenames | 3 | 146162 | 283 | 25.970 | 5628.1 |
555 | 2024-08-02 09:41:30 | prenames | 3 | 146162 | 283 | 39.470 | 3703.1 |
554 | 2024-08-02 09:41:32 | prenames | 2 | 121059 | 28 | 7.093 | 17067.4 |
553 | 2024-08-02 09:41:21 | prenames | 1 | 82945 | 4 | 5.110 | 16231.9 |
552 | 2024-07-30 08:28:42 | prenames | 2 | 121059 | 28 | 16.453 | 7357.9 |
551 | 2024-07-30 08:13:14 | prenames | 1 | 82945 | 4 | 1.423 | 58288.8 |
550 | 2024-07-25 21:49:48 | prenames | 1 | 82945 | 4 | 3.813 | 21753.2 |
549 | 2024-07-24 17:01:08 | prenames | 2 | 121059 | 28 | 18.063 | 6702.0 |
548 | 2024-07-24 17:00:26 | prenames | 1 | 82945 | 4 | 2.500 | 33178.0 |
547 | 2024-07-16 12:52:56 | prenames | 1 | 82945 | 4 | 7.390 | 11224.0 |
546 | 2024-07-16 12:51:23 | prenames | 1 | 82945 | 4 | 5.360 | 15474.8 |
545 | 2024-07-11 04:24:09 | prenames | 1 | 82945 | 4 | 2.576 | 32199.1 |
544 | 2024-07-08 00:00:43 | prenames | 2 | 121059 | 28 | 15.376 | 7873.2 |
543 | 2024-07-07 11:18:20 | prenames | 2 | 121059 | 28 | 14.533 | 8329.9 |
542 | 2024-07-07 10:52:00 | prenames | 1 | 82945 | 4 | 1.606 | 51646.9 |
541 | 2024-07-07 10:43:48 | prenames | 2 | 121059 | 28 | 19.503 | 6207.2 |
540 | 2024-07-07 10:40:36 | prenames | 1 | 82945 | 4 | 5.376 | 15428.8 |
539 | 2024-07-03 08:41:47 | prenames | 3 | 146162 | 283 | 22.173 | 6591.9 |
538 | 2024-07-03 06:20:11 | prenames | 3 | 146162 | 283 | 16.330 | 8950.5 |
537 | 2024-07-02 18:00:49 | prenames | 3 | 146162 | 283 | 27.500 | 5315.0 |
536 | 2024-07-02 12:54:42 | prenames | 3 | 146162 | 283 | 23.546 | 6207.5 |
535 | 2024-07-02 07:52:40 | prenames | 3 | 146162 | 283 | 33.050 | 4422.5 |