History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"councillor"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 848 | 2025-12-31 08:11:04 | councillor | 4 | 161450 | 51 | 9.936 | 16249.0 |
| 847 | 2025-12-27 15:20:39 | councillor | 2 | 108824 | 5 | 3.986 | 27301.6 |
| 846 | 2025-12-27 09:47:40 | councillor | 1 | 67641 | 3 | 1.686 | 40119.2 |
| 845 | 2025-12-26 18:40:25 | councillor | 3 | 140603 | 13 | 17.033 | 8254.7 |
| 844 | 2025-12-08 00:22:31 | councillor | 4 | 161450 | 51 | 11.686 | 13815.7 |
| 843 | 2025-12-02 06:10:35 | councillor | 4 | 161450 | 51 | 11.813 | 13667.1 |
| 842 | 2025-11-29 17:59:01 | councillor | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 841 | 2025-11-26 16:13:51 | councillor | 4 | 161450 | 51 | 35.063 | 4604.6 |
| 840 | 2025-10-25 19:02:03 | councillor | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 839 | 2025-10-25 06:22:13 | councillor | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 838 | 2025-10-24 20:35:50 | councillor | 1 | 67641 | 3 | 2.643 | 25592.5 |
| 837 | 2025-10-24 13:11:23 | councillor | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 836 | 2025-10-23 18:32:42 | councillor | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 835 | 2025-10-23 18:32:13 | councillor | 1 | 67641 | 3 | 5.890 | 11484.0 |
| 834 | 2025-10-23 11:23:07 | councillor | 1 | 67641 | 3 | 6.360 | 10635.4 |
| 833 | 2025-10-23 11:22:50 | councillor | 1 | 67641 | 3 | 3.173 | 21317.7 |
| 832 | 2025-10-13 08:01:56 | councillor | 2 | 108824 | 5 | 2.766 | 39343.5 |
| 831 | 2025-10-13 02:07:58 | councillor | 3 | 140603 | 13 | 6.190 | 22714.5 |
| 830 | 2025-09-28 09:34:33 | councillor | 5 | 173545 | 353 | 19.703 | 8808.0 |
| 829 | 2025-09-28 09:33:56 | councillor | 2 | 108824 | 5 | 2.923 | 37230.2 |
| 828 | 2025-09-28 08:18:32 | councillor | 3 | 140603 | 13 | 6.576 | 21381.2 |
| 827 | 2025-09-28 07:00:03 | councillor | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 826 | 2025-09-25 16:21:00 | councillor | 1 | 67641 | 3 | 4.220 | 16028.7 |
| 825 | 2025-09-25 16:20:47 | councillor | 1 | 67641 | 3 | 2.873 | 23543.7 |
| 824 | 2025-09-25 16:20:37 | councillor | 1 | 67641 | 3 | 6.656 | 10162.4 |
| 823 | 2025-09-25 16:20:20 | councillor | 1 | 67641 | 3 | 6.000 | 11273.5 |
| 822 | 2025-09-22 23:01:59 | councillor | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 821 | 2025-09-18 04:07:38 | councillor | 4 | 161450 | 51 | 13.720 | 11767.5 |
| 820 | 2025-08-29 12:49:43 | councillor | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 819 | 2025-08-09 02:39:33 | councillor | 1 | 67641 | 3 | 7.296 | 9271.0 |
| 818 | 2025-07-27 14:43:38 | councillor | 4 | 161450 | 51 | 36.766 | 4391.3 |
| 817 | 2025-07-27 05:53:46 | councillor | 4 | 161450 | 51 | 49.533 | 3259.4 |
| 816 | 2025-07-23 18:28:22 | councillor | 1 | 67641 | 3 | 2.640 | 25621.6 |
| 815 | 2025-07-23 00:17:22 | councillor | 4 | 161450 | 51 | 36.423 | 4432.6 |
| 814 | 2025-07-18 14:47:44 | councillor | 4 | 161450 | 51 | 50.740 | 3181.9 |
| 813 | 2025-07-14 18:14:39 | councillor | 4 | 161450 | 51 | 65.380 | 2469.4 |
| 812 | 2025-07-07 06:27:36 | councillor | 1 | 67641 | 3 | 5.766 | 11731.0 |
| 811 | 2025-07-07 05:22:18 | councillor | 4 | 161450 | 51 | 43.220 | 3735.5 |
| 810 | 2025-07-06 22:24:22 | councillor | 2 | 108824 | 5 | 13.843 | 7861.3 |
| 809 | 2025-07-06 21:17:30 | councillor | 3 | 140603 | 13 | 6.123 | 22963.1 |
| 808 | 2025-07-06 20:59:32 | councillor | 3 | 140603 | 13 | 6.936 | 20271.5 |
| 807 | 2025-07-06 02:03:22 | councillor | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 806 | 2025-07-02 03:47:59 | councillor | 1 | 67641 | 3 | 3.016 | 22427.4 |
| 805 | 2025-05-29 07:38:44 | councillor | 3 | 140603 | 13 | 33.440 | 4204.6 |
| 804 | 2025-05-27 05:19:54 | councillor | 1 | 67641 | 3 | 5.576 | 12130.7 |
| 803 | 2025-05-21 20:57:32 | councillor | 3 | 140603 | 13 | 17.263 | 8144.8 |
| 802 | 2025-05-06 11:44:04 | councillor | 3 | 140603 | 13 | 27.266 | 5156.7 |
| 801 | 2025-04-23 07:24:44 | councillor | 3 | 140603 | 13 | 21.843 | 6437.0 |
| 800 | 2025-04-02 10:53:50 | councillor | 1 | 67641 | 3 | 8.546 | 7914.9 |
| 799 | 2025-03-31 06:50:29 | councillor | 1 | 67641 | 3 | 3.000 | 22547.0 |
| 798 | 2025-03-26 22:14:37 | councillor | 3 | 140603 | 13 | 44.066 | 3190.7 |
| 797 | 2025-03-20 18:07:42 | councillor | 2 | 108824 | 5 | 21.190 | 5135.6 |
| 796 | 2025-03-20 08:27:22 | councillor | 1 | 67641 | 3 | 8.000 | 8455.1 |
| 795 | 2025-03-19 11:44:33 | councillor | 3 | 140603 | 13 | 6.423 | 21890.5 |
| 794 | 2025-03-18 04:29:31 | councillor | 3 | 140603 | 13 | 39.080 | 3597.8 |
| 793 | 2025-03-06 17:10:23 | councillor | 4 | 161450 | 51 | 55.683 | 2899.4 |
| 792 | 2025-03-05 19:13:32 | councillor | 4 | 161450 | 51 | 23.020 | 7013.5 |
| 791 | 2025-03-01 15:25:45 | councillor | 4 | 161450 | 51 | 56.113 | 2877.2 |
| 790 | 2025-03-01 15:24:48 | councillor | 4 | 161450 | 51 | 55.580 | 2904.8 |
| 789 | 2025-03-01 15:21:48 | councillor | 1 | 67641 | 3 | 3.420 | 19778.1 |
| 788 | 2025-02-24 19:57:33 | councillor | 3 | 140603 | 13 | 17.096 | 8224.3 |
| 787 | 2025-02-23 03:28:56 | councillor | 3 | 140603 | 13 | 37.710 | 3728.5 |
| 786 | 2025-02-20 21:21:38 | councillor | 1 | 67641 | 3 | 8.220 | 8228.8 |
| 785 | 2025-02-15 02:56:24 | councillor | 1 | 67641 | 3 | 5.593 | 12093.9 |
| 784 | 2025-02-08 02:43:41 | councillor | 2 | 108824 | 5 | 9.626 | 11305.2 |
| 783 | 2025-01-31 13:08:40 | councillor | 3 | 140603 | 13 | 34.550 | 4069.6 |
| 782 | 2025-01-31 10:18:21 | councillor | 3 | 140603 | 13 | 28.940 | 4858.4 |
| 781 | 2025-01-31 10:18:25 | councillor | 2 | 108824 | 5 | 21.830 | 4985.1 |
| 780 | 2025-01-31 10:17:38 | councillor | 1 | 67641 | 3 | 5.610 | 12057.2 |
| 779 | 2025-01-23 12:01:12 | councillor | 3 | 140603 | 13 | 38.140 | 3686.5 |
| 778 | 2025-01-16 12:59:41 | councillor | 3 | 140603 | 13 | 31.016 | 4533.2 |
| 777 | 2025-01-12 14:05:44 | councillor | 3 | 140603 | 13 | 32.703 | 4299.4 |
| 776 | 2025-01-12 04:40:29 | councillor | 1 | 67641 | 3 | 3.140 | 21541.7 |
| 775 | 2025-01-11 07:15:13 | councillor | 4 | 161450 | 51 | 57.143 | 2825.4 |
| 774 | 2025-01-11 07:15:12 | councillor | 4 | 161450 | 51 | 56.346 | 2865.3 |
| 773 | 2025-01-11 07:15:21 | councillor | 2 | 108824 | 5 | 15.390 | 7071.1 |
| 772 | 2025-01-11 07:15:02 | councillor | 1 | 67641 | 3 | 5.876 | 11511.4 |
| 771 | 2025-01-05 13:37:15 | councillor | 1 | 67641 | 3 | 2.703 | 25024.4 |
| 770 | 2024-12-30 02:24:41 | councillor | 3 | 140603 | 13 | 29.083 | 4834.5 |
| 769 | 2024-12-22 19:43:28 | councillor | 3 | 140603 | 13 | 27.176 | 5173.8 |
| 768 | 2024-12-20 18:07:42 | councillor | 3 | 140603 | 13 | 34.110 | 4122.0 |
| 767 | 2024-12-08 22:21:51 | councillor | 1 | 67641 | 3 | 2.970 | 22774.7 |
| 766 | 2024-12-05 01:02:56 | councillor | 3 | 140603 | 13 | 30.863 | 4555.7 |
| 765 | 2024-12-02 00:22:45 | councillor | 2 | 108824 | 5 | 15.203 | 7158.1 |
| 764 | 2024-12-02 00:21:38 | councillor | 1 | 67641 | 3 | 5.546 | 12196.4 |
| 763 | 2024-12-01 15:06:07 | councillor | 2 | 108824 | 5 | 16.296 | 6678.0 |
| 762 | 2024-12-01 15:04:50 | councillor | 1 | 67641 | 3 | 2.750 | 24596.7 |
| 761 | 2024-12-01 05:29:48 | councillor | 3 | 140603 | 13 | 33.470 | 4200.9 |
| 760 | 2024-11-30 22:02:30 | councillor | 3 | 140603 | 13 | 42.286 | 3325.0 |
| 759 | 2024-11-30 22:02:32 | councillor | 2 | 108824 | 5 | 14.673 | 7416.6 |
| 758 | 2024-11-30 22:02:01 | councillor | 1 | 67641 | 3 | 7.940 | 8519.0 |
| 757 | 2024-11-20 06:57:04 | councillor | 3 | 140603 | 13 | 41.656 | 3375.3 |
| 756 | 2024-11-19 04:47:24 | councillor | 3 | 140603 | 13 | 20.110 | 6991.7 |
| 755 | 2024-11-17 03:38:10 | councillor | 3 | 140603 | 13 | 33.240 | 4229.9 |
| 754 | 2024-11-08 17:01:33 | councillor | 1 | 67641 | 3 | 6.330 | 10685.8 |
| 753 | 2024-11-05 04:12:00 | councillor | 3 | 140603 | 13 | 34.376 | 4090.2 |
| 752 | 2024-11-04 16:37:47 | councillor | 3 | 140603 | 13 | 35.473 | 3963.7 |
| 751 | 2024-11-02 13:59:52 | councillor | 3 | 140603 | 13 | 32.800 | 4286.7 |
| 750 | 2024-10-30 13:52:30 | councillor | 1 | 67641 | 3 | 2.766 | 24454.4 |
| 749 | 2024-10-28 00:26:59 | councillor | 3 | 140603 | 13 | 35.910 | 3915.4 |