History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefects"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 721 | 2025-10-23 13:54:09 | prefects | 1 | 82945 | 6 | 3.500 | 23698.6 |
| 720 | 2025-09-15 05:48:42 | prefects | 1 | 82945 | 6 | 1.466 | 56579.1 |
| 719 | 2025-09-11 20:07:03 | prefects | 2 | 121059 | 37 | 6.016 | 20122.8 |
| 718 | 2025-09-09 12:06:46 | prefects | 3 | 146162 | 198 | 7.610 | 19206.6 |
| 717 | 2025-09-08 03:03:09 | prefects | 1 | 82945 | 6 | 1.406 | 58993.6 |
| 716 | 2025-08-27 13:38:59 | prefects | 1 | 82945 | 6 | 1.516 | 54713.1 |
| 715 | 2025-08-23 08:24:03 | prefects | 1 | 82945 | 6 | 4.453 | 18626.8 |
| 714 | 2025-08-23 00:58:12 | prefects | 3 | 146162 | 198 | 31.936 | 4576.7 |
| 713 | 2025-08-20 23:16:32 | prefects | 1 | 82945 | 6 | 3.373 | 24590.9 |
| 712 | 2025-08-20 03:45:38 | prefects | 3 | 146162 | 198 | 7.296 | 20033.2 |
| 711 | 2025-08-15 02:29:22 | prefects | 2 | 121059 | 37 | 15.826 | 7649.4 |
| 710 | 2025-08-13 02:50:21 | prefects | 3 | 146162 | 198 | 18.126 | 8063.7 |
| 709 | 2025-08-12 03:08:55 | prefects | 3 | 146162 | 198 | 17.813 | 8205.4 |
| 708 | 2025-08-10 14:23:54 | prefects | 3 | 146162 | 198 | 26.160 | 5587.2 |
| 707 | 2025-08-09 08:03:38 | prefects | 1 | 82945 | 6 | 5.923 | 14003.9 |
| 706 | 2025-08-06 23:18:00 | prefects | 3 | 146162 | 198 | 19.656 | 7436.0 |
| 705 | 2025-08-04 02:34:44 | prefects | 1 | 82945 | 6 | 7.266 | 11415.5 |
| 704 | 2025-08-04 01:24:33 | prefects | 1 | 82945 | 6 | 4.763 | 17414.4 |
| 703 | 2025-07-27 12:54:08 | prefects | 1 | 82945 | 6 | 13.860 | 5984.5 |
| 702 | 2025-07-23 16:39:49 | prefects | 1 | 82945 | 6 | 6.580 | 12605.6 |
| 701 | 2025-07-23 14:22:24 | prefects | 1 | 82945 | 6 | 3.563 | 23279.5 |
| 700 | 2025-07-15 06:55:21 | prefects | 1 | 82945 | 6 | 3.580 | 23169.0 |
| 699 | 2025-07-10 03:06:08 | prefects | 1 | 82945 | 6 | 7.390 | 11224.0 |
| 698 | 2025-07-08 07:17:14 | prefects | 1 | 82945 | 6 | 3.453 | 24021.1 |
| 697 | 2025-07-07 16:52:10 | prefects | 1 | 82945 | 6 | 4.000 | 20736.3 |
| 696 | 2025-07-07 00:59:51 | prefects | 1 | 82945 | 6 | 6.436 | 12887.7 |
| 695 | 2025-06-27 04:50:18 | prefects | 2 | 121059 | 37 | 18.016 | 6719.5 |
| 694 | 2025-06-25 11:24:21 | prefects | 3 | 146162 | 198 | 16.280 | 8978.0 |
| 693 | 2025-06-23 13:50:57 | prefects | 3 | 146162 | 198 | 8.830 | 16552.9 |
| 692 | 2025-06-17 00:15:32 | prefects | 3 | 146162 | 198 | 41.783 | 3498.1 |
| 691 | 2025-06-13 10:04:17 | prefects | 1 | 82945 | 6 | 1.466 | 56579.1 |
| 690 | 2025-06-13 07:51:01 | prefects | 3 | 146162 | 198 | 15.016 | 9733.8 |
| 689 | 2025-06-12 03:47:08 | prefects | 2 | 121059 | 37 | 28.280 | 4280.7 |
| 688 | 2025-06-11 17:47:33 | prefects | 3 | 146162 | 198 | 6.813 | 21453.4 |
| 687 | 2025-06-10 19:38:45 | prefects | 3 | 146162 | 198 | 35.283 | 4142.6 |
| 686 | 2025-06-08 17:49:22 | prefects | 2 | 121059 | 37 | 9.453 | 12806.4 |
| 685 | 2025-06-08 17:06:25 | prefects | 3 | 146162 | 198 | 29.440 | 4964.7 |
| 684 | 2025-06-07 06:34:35 | prefects | 1 | 82945 | 6 | 4.233 | 19594.8 |
| 683 | 2025-06-04 15:14:15 | prefects | 2 | 121059 | 37 | 17.890 | 6766.9 |
| 682 | 2025-06-04 01:05:33 | prefects | 1 | 82945 | 6 | 4.420 | 18765.8 |
| 681 | 2025-05-31 11:49:59 | prefects | 1 | 82945 | 6 | 3.906 | 21235.3 |
| 680 | 2025-05-31 09:56:35 | prefects | 1 | 82945 | 6 | 3.903 | 21251.6 |
| 679 | 2025-05-22 07:56:20 | prefects | 1 | 82945 | 6 | 8.703 | 9530.6 |
| 678 | 2025-05-18 09:19:10 | prefects | 1 | 82945 | 6 | 3.970 | 20892.9 |
| 677 | 2025-05-16 18:10:31 | prefects | 1 | 82945 | 6 | 9.813 | 8452.6 |
| 676 | 2025-05-16 13:46:41 | prefects | 1 | 82945 | 6 | 6.143 | 13502.4 |
| 675 | 2025-05-12 09:54:16 | prefects | 1 | 82945 | 6 | 10.206 | 8127.1 |
| 674 | 2025-05-06 06:39:31 | prefects | 1 | 82945 | 6 | 3.720 | 22297.0 |
| 673 | 2025-05-02 01:19:52 | prefects | 1 | 82945 | 6 | 3.436 | 24140.0 |
| 672 | 2025-04-20 07:49:17 | prefects | 1 | 82945 | 6 | 6.923 | 11981.1 |
| 671 | 2025-04-19 08:09:42 | prefects | 1 | 82945 | 6 | 1.500 | 55296.7 |
| 670 | 2025-04-14 13:02:28 | prefects | 1 | 82945 | 6 | 9.313 | 8906.4 |
| 669 | 2025-04-06 09:58:45 | prefects | 1 | 82945 | 6 | 6.283 | 13201.5 |
| 668 | 2025-04-05 23:45:14 | prefects | 1 | 82945 | 6 | 7.190 | 11536.2 |
| 667 | 2025-04-04 05:44:39 | prefects | 1 | 82945 | 6 | 7.140 | 11616.9 |
| 666 | 2025-04-01 13:14:38 | prefects | 2 | 121059 | 37 | 3.920 | 30882.4 |
| 665 | 2025-04-01 02:15:40 | prefects | 1 | 82945 | 6 | 1.530 | 54212.4 |
| 664 | 2025-03-30 14:19:04 | prefects | 2 | 121059 | 37 | 26.310 | 4601.3 |
| 663 | 2025-03-20 10:12:43 | prefects | 1 | 82945 | 6 | 4.000 | 20736.3 |
| 662 | 2025-03-16 03:01:36 | prefects | 2 | 121059 | 37 | 23.600 | 5129.6 |
| 661 | 2025-03-13 18:34:00 | prefects | 1 | 82945 | 6 | 10.596 | 7828.0 |
| 660 | 2025-03-12 09:22:46 | prefects | 1 | 82945 | 6 | 8.313 | 9977.7 |
| 659 | 2025-03-06 19:55:49 | prefects | 1 | 82945 | 6 | 4.703 | 17636.6 |
| 658 | 2025-03-04 10:49:46 | prefects | 3 | 146162 | 198 | 41.460 | 3525.4 |
| 657 | 2025-03-03 14:32:18 | prefects | 3 | 146162 | 198 | 26.720 | 5470.1 |
| 656 | 2025-03-03 02:22:40 | prefects | 3 | 146162 | 198 | 30.020 | 4868.8 |
| 655 | 2025-03-01 20:22:17 | prefects | 1 | 82945 | 6 | 6.673 | 12429.9 |
| 654 | 2025-03-01 16:39:32 | prefects | 3 | 146162 | 198 | 46.796 | 3123.4 |
| 653 | 2025-03-01 09:54:04 | prefects | 3 | 146162 | 198 | 49.020 | 2981.7 |
| 652 | 2025-03-01 09:54:37 | prefects | 1 | 82945 | 6 | 7.233 | 11467.6 |
| 651 | 2025-02-25 20:42:03 | prefects | 2 | 121059 | 37 | 15.220 | 7953.9 |
| 650 | 2025-02-23 07:36:07 | prefects | 2 | 121059 | 37 | 18.173 | 6661.5 |
| 649 | 2025-02-23 03:54:56 | prefects | 2 | 121059 | 37 | 11.423 | 10597.8 |
| 648 | 2025-02-23 03:54:49 | prefects | 1 | 82945 | 6 | 1.500 | 55296.7 |
| 647 | 2025-02-17 00:08:36 | prefects | 1 | 82945 | 6 | 7.970 | 10407.2 |
| 646 | 2025-02-01 10:55:00 | prefects | 3 | 146162 | 198 | 40.396 | 3618.2 |
| 645 | 2025-01-25 03:26:23 | prefects | 1 | 82945 | 6 | 4.436 | 18698.2 |
| 644 | 2025-01-24 18:37:55 | prefects | 3 | 146162 | 198 | 33.033 | 4424.7 |
| 643 | 2025-01-22 15:54:05 | prefects | 1 | 82945 | 6 | 2.703 | 30686.3 |
| 642 | 2025-01-21 15:56:51 | prefects | 3 | 146162 | 198 | 37.656 | 3881.5 |
| 641 | 2025-01-20 11:47:20 | prefects | 3 | 146162 | 198 | 34.646 | 4218.7 |
| 640 | 2025-01-20 02:28:08 | prefects | 3 | 146162 | 198 | 38.226 | 3823.6 |
| 639 | 2025-01-17 05:50:48 | prefects | 1 | 82945 | 6 | 3.296 | 25165.4 |
| 638 | 2025-01-05 01:56:11 | prefects | 2 | 121059 | 37 | 19.533 | 6197.7 |
| 637 | 2025-01-01 19:55:06 | prefects | 2 | 121059 | 37 | 13.906 | 8705.5 |
| 636 | 2024-12-26 01:33:59 | prefects | 2 | 121059 | 37 | 16.970 | 7133.7 |
| 635 | 2024-12-26 01:33:51 | prefects | 1 | 82945 | 6 | 6.876 | 12063.0 |
| 634 | 2024-12-25 02:32:08 | prefects | 3 | 146162 | 198 | 34.050 | 4292.6 |
| 633 | 2024-12-23 21:12:06 | prefects | 3 | 146162 | 198 | 22.483 | 6501.0 |
| 632 | 2024-12-14 09:22:00 | prefects | 3 | 146162 | 198 | 38.206 | 3825.6 |
| 631 | 2024-12-13 11:03:18 | prefects | 3 | 146162 | 198 | 42.720 | 3421.4 |
| 630 | 2024-12-13 11:03:20 | prefects | 2 | 121059 | 37 | 28.820 | 4200.5 |
| 629 | 2024-12-13 11:02:51 | prefects | 1 | 82945 | 6 | 7.103 | 11677.5 |
| 628 | 2024-11-25 15:23:11 | prefects | 1 | 82945 | 6 | 10.970 | 7561.1 |
| 627 | 2024-11-19 00:06:49 | prefects | 1 | 82945 | 6 | 5.346 | 15515.3 |
| 626 | 2024-11-17 01:42:01 | prefects | 2 | 121059 | 37 | 18.703 | 6472.7 |
| 625 | 2024-11-14 07:39:57 | prefects | 2 | 121059 | 37 | 17.003 | 7119.9 |
| 624 | 2024-11-13 14:23:53 | prefects | 2 | 121059 | 37 | 4.046 | 29920.7 |
| 623 | 2024-11-11 20:46:59 | prefects | 2 | 121059 | 37 | 14.250 | 8495.4 |
| 622 | 2024-11-11 10:44:07 | prefects | 1 | 82945 | 6 | 1.533 | 54106.3 |