History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prosecutor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
196 | 2024-05-04 03:29:15 | prosecutor | 1 | 67641 | 3 | 1.203 | 56226.9 |
195 | 2024-05-03 06:32:25 | prosecutor | 1 | 67641 | 3 | 2.640 | 25621.6 |
194 | 2024-04-28 04:42:25 | prosecutor | 1 | 67641 | 3 | 3.813 | 17739.6 |
193 | 2024-04-11 07:09:18 | prosecutor | 1 | 67641 | 3 | 1.250 | 54112.8 |
192 | 2024-04-09 22:25:16 | prosecutor | 1 | 67641 | 3 | 1.220 | 55443.4 |
191 | 2024-04-07 20:17:19 | prosecutor | 2 | 108824 | 13 | 13.140 | 8281.9 |
190 | 2024-04-07 20:09:14 | prosecutor | 1 | 67641 | 3 | 3.046 | 22206.5 |
189 | 2024-04-04 10:52:16 | prosecutor | 2 | 108824 | 13 | 3.250 | 33484.3 |
188 | 2024-03-29 00:27:50 | prosecutor | 1 | 67641 | 3 | 3.626 | 18654.4 |
187 | 2024-03-28 13:43:23 | prosecutor | 1 | 67641 | 3 | 1.203 | 56226.9 |
186 | 2024-03-12 05:55:24 | prosecutor | 1 | 67641 | 3 | 1.153 | 58665.2 |
185 | 2024-03-07 01:21:34 | prosecutor | 1 | 67641 | 3 | 1.110 | 60937.8 |
184 | 2024-02-29 20:47:45 | prosecutor | 3 | 140603 | 33 | 14.156 | 9932.4 |
183 | 2024-02-29 14:11:43 | prosecutor | 1 | 67641 | 3 | 1.233 | 54858.9 |
182 | 2024-02-27 05:10:31 | prosecutor | 1 | 67641 | 3 | 1.326 | 51011.3 |
181 | 2024-02-04 11:24:37 | prosecutor | 1 | 67641 | 3 | 2.576 | 26258.2 |
180 | 2024-01-30 13:54:44 | prosecutor | 1 | 67641 | 3 | 1.030 | 65670.9 |
179 | 2024-01-26 21:47:15 | prosecutor | 1 | 67641 | 3 | 2.423 | 27916.2 |
178 | 2024-01-10 20:32:28 | prosecutor | 4 | 161450 | 108 | 9.890 | 16324.6 |
177 | 2023-12-18 14:11:42 | prosecutor | 4 | 161450 | 108 | 14.516 | 11122.2 |
176 | 2023-12-12 08:16:07 | prosecutor | 1 | 67641 | 3 | 1.266 | 53428.9 |
175 | 2023-12-07 01:29:23 | prosecutor | 2 | 108824 | 13 | 2.953 | 36852.0 |
174 | 2023-11-20 16:51:18 | prosecutor | 3 | 140603 | 33 | 7.263 | 19358.8 |
173 | 2023-11-13 22:03:42 | prosecutor | 1 | 67641 | 3 | 1.126 | 60071.9 |
172 | 2023-11-05 16:11:38 | prosecutor | 1 | 67641 | 3 | 1.033 | 65480.2 |
171 | 2023-10-21 07:41:57 | prosecutor | 4 | 161450 | 108 | 11.173 | 14450.0 |
170 | 2023-10-20 16:48:46 | prosecutor | 1 | 67641 | 3 | 1.123 | 60232.4 |
169 | 2023-09-27 18:16:19 | prosecutor | 1 | 67641 | 3 | 1.190 | 56841.2 |
168 | 2023-09-04 13:04:10 | prosecutor | 2 | 108824 | 13 | 3.110 | 34991.6 |
167 | 2023-08-21 06:38:10 | prosecutor | 3 | 140603 | 33 | 6.060 | 23201.8 |
166 | 2023-08-01 12:30:50 | prosecutor | 4 | 161450 | 108 | 10.673 | 15127.0 |
165 | 2023-07-24 14:32:52 | prosecutor | 1 | 67641 | 3 | 1.046 | 64666.3 |
164 | 2023-06-23 09:05:37 | prosecutor | 1 | 67641 | 3 | 1.046 | 64666.3 |
163 | 2023-05-19 17:05:45 | prosecutor | 2 | 108824 | 13 | 3.063 | 35528.6 |
162 | 2023-05-05 05:36:19 | prosecutor | 3 | 140603 | 33 | 5.500 | 25564.2 |
161 | 2023-04-23 02:56:14 | prosecutor | 1 | 67641 | 3 | 1.033 | 65480.2 |
160 | 2023-04-08 20:58:57 | prosecutor | 4 | 161450 | 108 | 11.546 | 13983.2 |
159 | 2023-03-29 17:24:03 | prosecutor | 3 | 140603 | 33 | 5.873 | 23940.6 |
158 | 2023-02-26 10:19:55 | prosecutor | 2 | 108824 | 13 | 2.690 | 40455.0 |
157 | 2023-02-14 07:37:52 | prosecutor | 1 | 67641 | 3 | 1.126 | 60071.9 |
156 | 2023-02-11 13:27:15 | prosecutor | 3 | 140603 | 33 | 5.486 | 25629.4 |
155 | 2023-02-01 09:11:46 | prosecutor | 1 | 67641 | 3 | 1.156 | 58513.0 |
154 | 2023-01-16 04:36:22 | prosecutor | 4 | 161450 | 108 | 10.703 | 15084.6 |
153 | 2022-12-11 00:00:01 | prosecutor | 1 | 67641 | 3 | 1.123 | 60232.4 |
152 | 2022-12-07 01:05:23 | prosecutor | 2 | 108824 | 13 | 2.700 | 40305.2 |
151 | 2022-11-23 17:46:16 | prosecutor | 3 | 140603 | 33 | 5.546 | 25352.1 |
150 | 2022-10-28 03:17:03 | prosecutor | 4 | 161450 | 108 | 9.356 | 17256.3 |
149 | 2022-09-08 13:48:29 | prosecutor | 1 | 67641 | 3 | 1.203 | 56226.9 |
148 | 2022-08-15 02:32:47 | prosecutor | 1 | 67641 | 3 | 1.156 | 58513.0 |
147 | 2022-08-12 19:15:06 | prosecutor | 1 | 67641 | 3 | 1.046 | 64666.3 |
146 | 2022-07-22 13:57:50 | prosecutor | 2 | 108824 | 13 | 2.783 | 39103.1 |
145 | 2022-05-26 23:06:34 | prosecutor | 4 | 161450 | 108 | 9.983 | 16172.5 |
144 | 2022-04-26 01:18:10 | prosecutor | 3 | 140603 | 33 | 6.016 | 23371.5 |
143 | 2022-03-28 19:15:13 | prosecutor | 1 | 67641 | 3 | 1.236 | 54725.7 |
142 | 2022-03-28 14:20:29 | prosecutor | 1 | 67641 | 3 | 1.250 | 54112.8 |
141 | 2022-03-26 09:42:58 | prosecutor | 1 | 67641 | 3 | 1.076 | 62863.4 |
140 | 2022-01-01 07:56:33 | prosecutor | 1 | 67641 | 3 | 1.080 | 62630.6 |
139 | 2021-11-14 13:35:29 | prosecutor | 1 | 67641 | 3 | 2.313 | 29243.8 |
138 | 2021-11-05 11:39:29 | prosecutor | 1 | 67641 | 3 | 1.126 | 60071.9 |
137 | 2021-10-30 17:35:08 | prosecutor | 1 | 67641 | 3 | 1.156 | 58513.0 |
136 | 2021-10-30 09:57:30 | prosecutor | 1 | 67641 | 3 | 1.156 | 58513.0 |
135 | 2021-10-29 08:37:35 | prosecutor | 1 | 67641 | 3 | 1.203 | 56226.9 |
134 | 2021-10-28 21:17:54 | prosecutor | 1 | 67641 | 3 | 1.313 | 51516.4 |
133 | 2021-10-27 17:06:56 | prosecutor | 1 | 67641 | 3 | 1.233 | 54858.9 |
132 | 2021-10-21 12:22:29 | prosecutor | 1 | 67641 | 3 | 1.046 | 64666.3 |
131 | 2021-09-19 12:14:20 | prosecutor | 1 | 67641 | 3 | 1.046 | 64666.3 |
130 | 2021-09-19 04:21:32 | prosecutor | 1 | 67641 | 3 | 2.266 | 29850.4 |
129 | 2021-09-18 11:46:21 | prosecutor | 1 | 67641 | 3 | 1.156 | 58513.0 |
128 | 2021-09-14 19:07:25 | prosecutor | 1 | 67641 | 3 | 1.186 | 57032.9 |
127 | 2021-09-12 16:15:47 | prosecutor | 1 | 67641 | 3 | 1.046 | 64666.3 |
126 | 2021-09-11 19:36:27 | prosecutor | 1 | 67641 | 3 | 1.126 | 60071.9 |
125 | 2021-08-26 00:46:53 | prosecutor | 1 | 67641 | 3 | 1.013 | 66773.0 |
124 | 2021-08-23 20:50:44 | prosecutor | 1 | 67641 | 3 | 1.063 | 63632.2 |
123 | 2021-07-18 20:45:16 | prosecutor | 1 | 67641 | 3 | 1.160 | 58311.2 |
122 | 2021-07-11 09:01:13 | prosecutor | 1 | 67641 | 3 | 1.250 | 54112.8 |
121 | 2021-06-20 23:10:47 | prosecutor | 1 | 67641 | 3 | 1.080 | 62630.6 |
120 | 2021-04-07 10:36:39 | prosecutor | 1 | 67641 | 3 | 1.216 | 55625.8 |
119 | 2021-04-03 06:48:27 | prosecutor | 1 | 67641 | 3 | 1.233 | 54858.9 |
118 | 2020-12-03 04:47:58 | prosecutor | 1 | 67641 | 3 | 1.063 | 63632.2 |
117 | 2020-10-30 04:05:30 | prosecutor | 1 | 67641 | 3 | 1.173 | 57665.0 |
116 | 2020-10-21 01:53:53 | prosecutor | 1 | 67641 | 3 | 1.060 | 63812.3 |
115 | 2020-08-27 05:41:42 | prosecutor | 1 | 67641 | 3 | 1.156 | 58513.0 |
114 | 2020-08-04 00:23:45 | prosecutor | 1 | 67641 | 3 | 1.046 | 64666.3 |
113 | 2020-04-22 23:41:54 | prosecutor | 1 | 67641 | 3 | 1.063 | 63632.2 |
112 | 2020-03-26 00:52:57 | prosecutor | 1 | 67641 | 3 | 1.266 | 53428.9 |
111 | 2020-02-18 12:57:03 | prosecutor | 1 | 67641 | 3 | 1.423 | 47534.1 |
110 | 2020-02-17 02:24:21 | prosecutor | 1 | 67641 | 3 | 1.186 | 57032.9 |
109 | 2020-02-10 08:28:17 | prosecutor | 1 | 67641 | 3 | 3.843 | 17601.1 |
108 | 2020-02-08 13:40:27 | prosecutor | 1 | 67641 | 3 | 2.373 | 28504.4 |
107 | 2020-02-04 20:21:56 | prosecutor | 1 | 67641 | 3 | 2.623 | 25787.6 |
106 | 2020-02-01 10:11:07 | prosecutor | 1 | 67641 | 3 | 2.640 | 25621.6 |
105 | 2020-01-19 10:55:31 | prosecutor | 1 | 67641 | 3 | 1.250 | 54112.8 |
104 | 2020-01-14 21:14:00 | prosecutor | 3 | 140603 | 33 | 7.080 | 19859.2 |
103 | 2020-01-14 16:49:52 | prosecutor | 1 | 67641 | 3 | 2.280 | 29667.1 |
102 | 2020-01-06 23:45:21 | prosecutor | 1 | 67641 | 3 | 1.203 | 56226.9 |
101 | 2020-01-01 20:39:52 | prosecutor | 1 | 67641 | 3 | 1.906 | 35488.5 |
100 | 2019-10-02 22:53:56 | prosecutor | 1 | 67641 | 3 | 0.996 | 67912.7 |
99 | 2019-09-26 08:13:40 | prosecutor | 1 | 67641 | 3 | 1.010 | 66971.3 |
98 | 2019-06-08 00:57:49 | prosecutor | 1 | 67641 | 3 | 1.156 | 58513.0 |
97 | 2019-02-04 17:46:06 | prosecutor | 1 | 67641 | 3 | 1.083 | 62457.1 |