History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"terry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
658 | 2025-08-26 22:53:37 | terry | 1 | 28756 | 13 | 0.530 | 54256.6 |
657 | 2025-08-12 21:49:14 | terry | 1 | 28756 | 13 | 1.313 | 21901.0 |
656 | 2025-08-10 05:48:15 | terry | 1 | 28756 | 13 | 1.296 | 22188.3 |
655 | 2025-08-10 03:56:49 | terry | 1 | 28756 | 13 | 1.250 | 23004.8 |
654 | 2025-08-06 08:55:43 | terry | 1 | 28756 | 13 | 1.046 | 27491.4 |
653 | 2025-08-05 13:00:29 | terry | 2 | 53800 | 103 | 4.063 | 13241.4 |
652 | 2025-08-05 00:36:37 | terry | 1 | 28756 | 13 | 1.360 | 21144.1 |
651 | 2025-08-04 13:03:05 | terry | 1 | 28756 | 13 | 2.500 | 11502.4 |
650 | 2025-08-03 21:28:34 | terry | 2 | 53800 | 103 | 3.890 | 13830.3 |
649 | 2025-08-02 00:54:41 | terry | 2 | 53800 | 103 | 6.780 | 7935.1 |
648 | 2025-08-01 17:06:37 | terry | 1 | 28756 | 13 | 1.436 | 20025.1 |
647 | 2025-08-01 14:43:12 | terry | 2 | 53800 | 103 | 4.716 | 11408.0 |
646 | 2025-07-31 17:30:54 | terry | 1 | 28756 | 13 | 0.563 | 51076.4 |
645 | 2025-07-31 00:53:53 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
644 | 2025-07-28 10:48:45 | terry | 1 | 28756 | 13 | 0.953 | 30174.2 |
643 | 2025-07-28 08:53:18 | terry | 2 | 53800 | 103 | 3.203 | 16796.8 |
642 | 2025-07-27 16:56:27 | terry | 1 | 28756 | 13 | 3.296 | 8724.5 |
641 | 2025-07-27 03:52:47 | terry | 2 | 53800 | 103 | 5.643 | 9533.9 |
640 | 2025-07-24 19:52:48 | terry | 1 | 28756 | 13 | 1.326 | 21686.3 |
639 | 2025-07-21 07:45:56 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
638 | 2025-07-19 02:41:54 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
637 | 2025-07-19 00:56:31 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
636 | 2025-07-18 14:16:58 | terry | 1 | 28756 | 13 | 1.126 | 25538.2 |
635 | 2025-07-13 17:38:34 | terry | 1 | 28756 | 13 | 0.563 | 51076.4 |
634 | 2025-07-12 11:13:21 | terry | 1 | 28756 | 13 | 0.546 | 52666.7 |
633 | 2025-07-10 16:21:47 | terry | 2 | 53800 | 103 | 8.360 | 6435.4 |
632 | 2025-07-10 10:38:27 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
631 | 2025-07-09 01:32:46 | terry | 2 | 53800 | 103 | 1.686 | 31909.8 |
630 | 2025-07-09 01:32:44 | terry | 2 | 53800 | 103 | 1.720 | 31279.1 |
629 | 2025-07-06 17:59:49 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
628 | 2025-07-06 10:04:26 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
627 | 2025-07-06 10:04:26 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
626 | 2025-07-05 00:42:42 | terry | 1 | 28756 | 13 | 0.983 | 29253.3 |
625 | 2025-07-04 11:46:54 | terry | 1 | 28756 | 13 | 1.313 | 21901.0 |
624 | 2025-07-03 18:01:00 | terry | 1 | 28756 | 13 | 0.530 | 54256.6 |
623 | 2025-06-30 17:12:12 | terry | 1 | 28756 | 13 | 2.483 | 11581.2 |
622 | 2025-06-29 15:09:50 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
621 | 2025-06-18 09:40:00 | terry | 1 | 28756 | 13 | 4.106 | 7003.4 |
620 | 2025-06-13 16:01:16 | terry | 1 | 28756 | 13 | 0.533 | 53951.2 |
619 | 2025-06-09 00:23:26 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
618 | 2025-06-04 00:28:15 | terry | 1 | 28756 | 13 | 1.233 | 23322.0 |
617 | 2025-06-02 11:57:29 | terry | 1 | 28756 | 13 | 3.076 | 9348.5 |
616 | 2025-05-31 15:38:03 | terry | 1 | 28756 | 13 | 2.153 | 13356.2 |
615 | 2025-05-28 06:01:50 | terry | 2 | 53800 | 103 | 1.530 | 35163.4 |
614 | 2025-05-28 04:40:56 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
613 | 2025-05-23 13:35:07 | terry | 1 | 28756 | 13 | 1.300 | 22120.0 |
612 | 2025-05-18 04:51:40 | terry | 2 | 53800 | 103 | 7.673 | 7011.6 |
611 | 2025-05-16 10:06:12 | terry | 1 | 28756 | 13 | 1.403 | 20496.1 |
610 | 2025-05-12 10:51:24 | terry | 2 | 53800 | 103 | 7.513 | 7160.9 |
609 | 2025-05-11 10:30:45 | terry | 1 | 28756 | 13 | 1.356 | 21206.5 |
608 | 2025-05-11 07:24:55 | terry | 2 | 53800 | 103 | 8.406 | 6400.2 |
607 | 2025-05-08 13:06:34 | terry | 1 | 28756 | 13 | 2.190 | 13130.6 |
606 | 2025-05-08 01:51:17 | terry | 1 | 28756 | 13 | 3.080 | 9336.4 |
605 | 2025-05-05 16:45:57 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
604 | 2025-05-04 00:28:49 | terry | 1 | 28756 | 13 | 0.906 | 31739.5 |
603 | 2025-05-02 11:25:55 | terry | 1 | 28756 | 13 | 3.623 | 7937.1 |
602 | 2025-05-01 09:09:31 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
601 | 2025-04-30 17:07:58 | terry | 1 | 28756 | 13 | 1.016 | 28303.1 |
600 | 2025-04-27 16:38:12 | terry | 1 | 28756 | 13 | 0.440 | 65354.5 |
599 | 2025-04-18 01:04:35 | terry | 1 | 28756 | 13 | 2.440 | 11785.2 |
598 | 2025-04-16 03:59:17 | terry | 2 | 53800 | 103 | 7.856 | 6848.3 |
597 | 2025-04-15 08:50:02 | terry | 1 | 28756 | 13 | 0.516 | 55728.7 |
596 | 2025-04-13 15:27:46 | terry | 2 | 53800 | 103 | 1.640 | 32804.9 |
595 | 2025-04-12 16:30:00 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
594 | 2025-04-12 16:19:00 | terry | 2 | 53800 | 103 | 12.170 | 4420.7 |
593 | 2025-04-09 06:22:29 | terry | 2 | 53800 | 103 | 8.173 | 6582.7 |
592 | 2025-04-08 21:04:56 | terry | 1 | 28756 | 13 | 3.126 | 9199.0 |
591 | 2025-04-08 01:13:18 | terry | 1 | 28756 | 13 | 1.390 | 20687.8 |
590 | 2025-04-06 09:13:13 | terry | 2 | 53800 | 103 | 5.830 | 9228.1 |
589 | 2025-04-05 03:37:26 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
588 | 2025-04-03 13:08:52 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
587 | 2025-04-03 01:49:01 | terry | 1 | 28756 | 13 | 2.326 | 12362.9 |
586 | 2025-04-03 00:20:00 | terry | 1 | 28756 | 13 | 3.140 | 9158.0 |
585 | 2025-03-31 14:02:42 | terry | 1 | 28756 | 13 | 3.173 | 9062.7 |
584 | 2025-03-30 00:50:38 | terry | 1 | 28756 | 13 | 0.513 | 56054.6 |
583 | 2025-03-29 18:40:09 | terry | 1 | 28756 | 13 | 2.373 | 12118.0 |
582 | 2025-03-19 01:11:48 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
581 | 2025-03-15 10:28:38 | terry | 2 | 53800 | 103 | 4.686 | 11481.0 |
580 | 2025-03-15 10:25:39 | terry | 1 | 28756 | 13 | 2.483 | 11581.2 |
579 | 2025-03-15 05:09:12 | terry | 1 | 28756 | 13 | 2.700 | 10650.4 |
578 | 2025-03-14 18:19:36 | terry | 1 | 28756 | 13 | 0.546 | 52666.7 |
577 | 2025-03-12 14:29:26 | terry | 1 | 28756 | 13 | 3.483 | 8256.1 |
576 | 2025-03-07 15:18:21 | terry | 1 | 28756 | 13 | 2.343 | 12273.2 |
575 | 2025-03-06 21:46:56 | terry | 1 | 28756 | 13 | 2.326 | 12362.9 |
574 | 2025-03-05 20:19:57 | terry | 1 | 28756 | 13 | 2.406 | 11951.8 |
573 | 2025-03-05 06:46:37 | terry | 2 | 53800 | 103 | 7.030 | 7652.9 |
572 | 2025-03-03 14:29:50 | terry | 1 | 28756 | 13 | 1.686 | 17055.8 |
571 | 2025-02-27 23:58:02 | terry | 1 | 28756 | 13 | 0.453 | 63479.0 |
570 | 2025-02-26 05:47:29 | terry | 1 | 28756 | 13 | 0.966 | 29768.1 |
569 | 2025-01-28 15:12:01 | terry | 2 | 53800 | 103 | 5.030 | 10695.8 |
568 | 2025-01-28 13:45:45 | terry | 2 | 53800 | 103 | 8.203 | 6558.6 |
567 | 2025-01-28 11:21:28 | terry | 2 | 53800 | 103 | 6.530 | 8238.9 |
566 | 2025-01-28 09:52:28 | terry | 1 | 28756 | 13 | 0.500 | 57512.0 |
565 | 2025-01-26 20:34:50 | terry | 1 | 28756 | 13 | 2.076 | 13851.6 |
564 | 2025-01-26 03:02:13 | terry | 1 | 28756 | 13 | 2.530 | 11366.0 |
563 | 2025-01-08 18:48:45 | terry | 2 | 53800 | 103 | 4.970 | 10824.9 |
562 | 2025-01-06 11:10:21 | terry | 2 | 53800 | 103 | 4.250 | 12658.8 |
561 | 2025-01-06 11:10:14 | terry | 1 | 28756 | 13 | 0.936 | 30722.2 |
560 | 2024-12-29 10:17:10 | terry | 2 | 53800 | 103 | 8.656 | 6215.3 |
559 | 2024-12-29 09:07:44 | terry | 2 | 53800 | 103 | 10.783 | 4989.3 |