History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pinyin"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 710 | 2024-04-27 14:29:50 | pinyin | 3 | 112716 | 377 | 17.016 | 6624.1 |
| 709 | 2024-04-27 11:50:17 | pinyin | 1 | 48755 | 2 | 3.063 | 15917.4 |
| 708 | 2024-04-06 08:43:33 | pinyin | 1 | 48755 | 2 | 2.296 | 21234.8 |
| 707 | 2024-03-31 19:20:35 | pinyin | 2 | 82551 | 23 | 5.906 | 13977.5 |
| 706 | 2024-03-30 09:40:40 | pinyin | 1 | 48755 | 2 | 1.923 | 25353.6 |
| 705 | 2024-03-30 02:12:06 | pinyin | 3 | 112716 | 377 | 17.796 | 6333.8 |
| 704 | 2024-03-29 06:18:08 | pinyin | 2 | 82551 | 23 | 8.280 | 9969.9 |
| 703 | 2024-03-28 22:14:51 | pinyin | 3 | 112716 | 377 | 10.953 | 10290.9 |
| 702 | 2024-03-28 21:20:22 | pinyin | 3 | 112716 | 377 | 8.156 | 13820.0 |
| 701 | 2024-03-28 21:11:15 | pinyin | 1 | 48755 | 2 | 0.923 | 52822.3 |
| 700 | 2024-03-28 21:11:03 | pinyin | 3 | 112716 | 377 | 8.813 | 12789.7 |
| 699 | 2024-03-28 21:11:02 | pinyin | 2 | 82551 | 23 | 5.783 | 14274.8 |
| 698 | 2024-03-28 21:10:56 | pinyin | 1 | 48755 | 2 | 0.953 | 51159.5 |
| 697 | 2024-03-10 17:43:18 | pinyin | 3 | 112716 | 377 | 6.796 | 16585.6 |
| 696 | 2024-02-21 20:44:01 | pinyin | 1 | 48755 | 2 | 1.763 | 27654.6 |
| 695 | 2024-02-18 03:57:05 | pinyin | 3 | 112716 | 377 | 12.126 | 9295.4 |
| 694 | 2024-02-17 16:42:08 | pinyin | 3 | 112716 | 377 | 8.703 | 12951.4 |
| 693 | 2024-02-16 01:23:39 | pinyin | 3 | 112716 | 377 | 6.766 | 16659.2 |
| 692 | 2024-02-16 01:23:39 | pinyin | 2 | 82551 | 23 | 5.856 | 14096.8 |
| 691 | 2024-02-16 00:07:38 | pinyin | 1 | 48755 | 2 | 0.906 | 53813.5 |
| 690 | 2024-02-12 06:57:30 | pinyin | 1 | 48755 | 2 | 0.860 | 56691.9 |
| 689 | 2024-01-21 03:39:11 | pinyin | 2 | 82551 | 23 | 2.220 | 37185.1 |
| 688 | 2024-01-18 11:43:57 | pinyin | 3 | 112716 | 377 | 5.123 | 22002.0 |
| 687 | 2024-01-08 05:50:17 | pinyin | 3 | 112716 | 377 | 5.423 | 20784.8 |
| 686 | 2024-01-08 05:50:18 | pinyin | 2 | 82551 | 23 | 2.546 | 32423.8 |
| 685 | 2023-12-23 17:52:55 | pinyin | 3 | 112716 | 377 | 5.060 | 22275.9 |
| 684 | 2023-12-03 15:30:03 | pinyin | 3 | 112716 | 377 | 4.843 | 23274.0 |
| 683 | 2023-12-01 19:41:55 | pinyin | 1 | 48755 | 2 | 0.766 | 63648.8 |
| 682 | 2023-11-20 17:54:29 | pinyin | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 681 | 2023-11-17 15:05:59 | pinyin | 1 | 48755 | 2 | 0.766 | 63648.8 |
| 680 | 2023-11-14 21:26:09 | pinyin | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 679 | 2023-10-29 22:31:13 | pinyin | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 678 | 2023-10-19 01:54:52 | pinyin | 1 | 48755 | 2 | 0.783 | 62266.9 |
| 677 | 2023-10-14 23:22:38 | pinyin | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 676 | 2023-10-13 05:48:00 | pinyin | 3 | 112716 | 377 | 19.046 | 5918.1 |
| 675 | 2023-10-13 05:29:26 | pinyin | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 674 | 2023-10-09 17:16:58 | pinyin | 1 | 48755 | 2 | 0.846 | 57630.0 |
| 673 | 2023-10-06 18:58:57 | pinyin | 3 | 112716 | 377 | 11.216 | 10049.6 |
| 672 | 2023-09-30 07:11:42 | pinyin | 3 | 112716 | 377 | 5.610 | 20092.0 |
| 671 | 2023-09-26 08:18:30 | pinyin | 1 | 48755 | 2 | 1.206 | 40427.0 |
| 670 | 2023-09-23 22:20:30 | pinyin | 1 | 48755 | 2 | 0.733 | 66514.3 |
| 669 | 2023-09-17 00:56:14 | pinyin | 1 | 48755 | 2 | 0.813 | 59969.2 |
| 668 | 2023-09-01 01:10:11 | pinyin | 3 | 112716 | 377 | 4.640 | 24292.2 |
| 667 | 2023-07-13 04:45:06 | pinyin | 3 | 112716 | 377 | 5.236 | 21527.1 |
| 666 | 2023-07-08 17:58:17 | pinyin | 1 | 48755 | 2 | 0.750 | 65006.7 |
| 665 | 2023-06-14 17:03:50 | pinyin | 3 | 112716 | 377 | 4.690 | 24033.3 |
| 664 | 2023-06-12 23:22:24 | pinyin | 1 | 48755 | 2 | 0.750 | 65006.7 |
| 663 | 2023-05-24 13:26:13 | pinyin | 3 | 112716 | 377 | 4.796 | 23502.1 |
| 662 | 2023-05-24 07:22:27 | pinyin | 3 | 112716 | 377 | 5.000 | 22543.2 |
| 661 | 2023-05-18 22:42:38 | pinyin | 3 | 112716 | 377 | 4.593 | 24540.8 |
| 660 | 2023-04-26 11:24:15 | pinyin | 3 | 112716 | 377 | 4.783 | 23566.0 |
| 659 | 2023-04-23 02:43:42 | pinyin | 3 | 112716 | 377 | 4.686 | 24053.8 |
| 658 | 2023-04-18 08:49:34 | pinyin | 1 | 48755 | 2 | 0.813 | 59969.2 |
| 657 | 2023-03-19 15:07:40 | pinyin | 3 | 112716 | 377 | 4.593 | 24540.8 |
| 656 | 2023-02-28 22:08:24 | pinyin | 3 | 112716 | 377 | 4.970 | 22679.3 |
| 655 | 2023-02-26 05:38:06 | pinyin | 3 | 112716 | 377 | 4.576 | 24632.0 |
| 654 | 2023-02-10 03:14:07 | pinyin | 1 | 48755 | 2 | 0.733 | 66514.3 |
| 653 | 2023-02-07 18:46:48 | pinyin | 1 | 48755 | 2 | 0.736 | 66243.2 |
| 652 | 2023-01-05 23:17:11 | pinyin | 3 | 112716 | 377 | 5.000 | 22543.2 |
| 651 | 2022-12-08 13:37:22 | pinyin | 3 | 112716 | 377 | 4.563 | 24702.2 |
| 650 | 2022-12-08 05:07:33 | pinyin | 1 | 48755 | 2 | 0.736 | 66243.2 |
| 649 | 2022-11-28 04:20:54 | pinyin | 3 | 112716 | 377 | 5.560 | 20272.7 |
| 648 | 2022-10-31 19:00:17 | pinyin | 3 | 112716 | 377 | 4.626 | 24365.8 |
| 647 | 2022-10-30 06:44:57 | pinyin | 3 | 112716 | 377 | 5.783 | 19490.9 |
| 646 | 2022-10-29 05:15:52 | pinyin | 3 | 112716 | 377 | 5.580 | 20200.0 |
| 645 | 2022-10-28 04:06:09 | pinyin | 3 | 112716 | 377 | 5.376 | 20966.5 |
| 644 | 2022-10-27 07:28:45 | pinyin | 3 | 112716 | 377 | 5.500 | 20493.8 |
| 643 | 2022-10-26 14:53:52 | pinyin | 3 | 112716 | 377 | 5.390 | 20912.1 |
| 642 | 2022-10-25 04:39:16 | pinyin | 3 | 112716 | 377 | 5.376 | 20966.5 |
| 641 | 2022-10-24 09:14:28 | pinyin | 3 | 112716 | 377 | 5.986 | 18829.9 |
| 640 | 2022-10-23 04:52:57 | pinyin | 3 | 112716 | 377 | 5.906 | 19085.0 |
| 639 | 2022-10-22 04:26:39 | pinyin | 3 | 112716 | 377 | 7.046 | 15997.2 |
| 638 | 2022-10-21 09:51:10 | pinyin | 3 | 112716 | 377 | 6.033 | 18683.2 |
| 637 | 2022-10-20 08:44:54 | pinyin | 3 | 112716 | 377 | 10.123 | 11134.6 |
| 636 | 2022-10-19 08:21:37 | pinyin | 3 | 112716 | 377 | 5.560 | 20272.7 |
| 635 | 2022-10-18 12:39:08 | pinyin | 3 | 112716 | 377 | 5.236 | 21527.1 |
| 634 | 2022-10-17 18:22:41 | pinyin | 3 | 112716 | 377 | 5.626 | 20034.8 |
| 633 | 2022-10-16 12:32:12 | pinyin | 3 | 112716 | 377 | 5.516 | 20434.4 |
| 632 | 2022-10-15 12:37:30 | pinyin | 3 | 112716 | 377 | 5.906 | 19085.0 |
| 631 | 2022-10-14 15:16:48 | pinyin | 3 | 112716 | 377 | 11.920 | 9456.0 |
| 630 | 2022-10-13 05:57:42 | pinyin | 3 | 112716 | 377 | 5.970 | 18880.4 |
| 629 | 2022-10-12 13:04:15 | pinyin | 3 | 112716 | 377 | 5.876 | 19182.4 |
| 628 | 2022-10-11 09:25:25 | pinyin | 3 | 112716 | 377 | 5.360 | 21029.1 |
| 627 | 2022-10-10 13:58:17 | pinyin | 3 | 112716 | 377 | 5.220 | 21593.1 |
| 626 | 2022-10-09 12:04:12 | pinyin | 3 | 112716 | 377 | 5.593 | 20153.0 |
| 625 | 2022-10-08 08:49:59 | pinyin | 3 | 112716 | 377 | 7.503 | 15022.8 |
| 624 | 2022-10-07 12:19:46 | pinyin | 3 | 112716 | 377 | 5.656 | 19928.6 |
| 623 | 2022-10-06 16:26:31 | pinyin | 1 | 48755 | 2 | 0.766 | 63648.8 |
| 622 | 2022-10-03 02:18:33 | pinyin | 1 | 48755 | 2 | 0.876 | 55656.4 |
| 621 | 2022-10-01 12:52:41 | pinyin | 3 | 112716 | 377 | 4.970 | 22679.3 |
| 620 | 2022-09-11 11:42:32 | pinyin | 3 | 112716 | 377 | 5.920 | 19039.9 |
| 619 | 2022-08-29 23:01:41 | pinyin | 3 | 112716 | 377 | 5.673 | 19868.9 |
| 618 | 2022-08-08 02:18:54 | pinyin | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 617 | 2022-07-31 08:21:03 | pinyin | 3 | 112716 | 377 | 5.580 | 20200.0 |
| 616 | 2022-07-21 21:15:11 | pinyin | 3 | 112716 | 377 | 4.703 | 23966.8 |
| 615 | 2022-07-12 19:30:45 | pinyin | 3 | 112716 | 377 | 4.810 | 23433.7 |
| 614 | 2022-07-09 18:05:42 | pinyin | 3 | 112716 | 377 | 4.686 | 24053.8 |
| 613 | 2022-07-09 09:27:20 | pinyin | 3 | 112716 | 377 | 4.733 | 23814.9 |
| 612 | 2022-07-08 21:52:28 | pinyin | 3 | 112716 | 377 | 4.830 | 23336.6 |
| 611 | 2022-07-06 19:09:48 | pinyin | 3 | 112716 | 377 | 4.626 | 24365.8 |