History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subchief"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
244 | 2024-04-29 15:18:50 | subchief | 3 | 146162 | 16 | 7.420 | 19698.4 |
243 | 2024-04-29 15:18:53 | subchief | 1 | 82945 | 2 | 1.533 | 54106.3 |
242 | 2024-04-29 15:18:38 | subchief | 4 | 161609 | 443 | 13.546 | 11930.4 |
241 | 2024-04-29 15:18:42 | subchief | 2 | 121059 | 2 | 4.106 | 29483.4 |
240 | 2024-04-21 12:48:10 | subchief | 3 | 146162 | 16 | 15.690 | 9315.6 |
239 | 2024-04-14 16:16:55 | subchief | 3 | 146162 | 16 | 8.313 | 17582.3 |
238 | 2024-04-14 16:15:43 | subchief | 2 | 121059 | 2 | 3.736 | 32403.4 |
237 | 2024-04-14 16:15:34 | subchief | 1 | 82945 | 2 | 1.546 | 53651.4 |
236 | 2024-04-13 15:40:52 | subchief | 1 | 82945 | 2 | 1.406 | 58993.6 |
235 | 2024-04-13 09:54:08 | subchief | 1 | 82945 | 2 | 1.516 | 54713.1 |
234 | 2024-04-13 09:48:08 | subchief | 3 | 146162 | 16 | 8.076 | 18098.3 |
233 | 2024-04-13 09:48:04 | subchief | 2 | 121059 | 2 | 3.970 | 30493.5 |
232 | 2024-04-13 00:49:04 | subchief | 4 | 161609 | 443 | 12.690 | 12735.1 |
231 | 2024-04-12 22:10:13 | subchief | 3 | 146162 | 16 | 13.203 | 11070.4 |
230 | 2024-04-12 22:10:09 | subchief | 2 | 121059 | 2 | 5.516 | 21946.9 |
229 | 2024-04-11 19:43:13 | subchief | 4 | 161609 | 443 | 45.173 | 3577.6 |
228 | 2024-04-10 21:09:14 | subchief | 4 | 161609 | 443 | 29.720 | 5437.7 |
227 | 2024-04-10 21:09:15 | subchief | 3 | 146162 | 16 | 13.393 | 10913.3 |
226 | 2024-04-10 21:09:16 | subchief | 2 | 121059 | 2 | 8.893 | 13612.8 |
225 | 2024-04-10 21:09:09 | subchief | 1 | 82945 | 2 | 5.093 | 16286.1 |
224 | 2024-04-03 04:09:54 | subchief | 2 | 121059 | 2 | 3.500 | 34588.3 |
223 | 2024-03-28 08:37:11 | subchief | 1 | 82945 | 2 | 1.500 | 55296.7 |
222 | 2024-03-10 23:11:28 | subchief | 3 | 146162 | 16 | 8.326 | 17554.9 |
221 | 2024-03-10 23:11:27 | subchief | 2 | 121059 | 2 | 7.736 | 15648.8 |
220 | 2024-03-10 23:11:24 | subchief | 1 | 82945 | 2 | 3.440 | 24111.9 |
219 | 2024-03-10 18:46:44 | subchief | 1 | 82945 | 2 | 4.000 | 20736.3 |
218 | 2024-03-10 17:36:34 | subchief | 4 | 161609 | 443 | 12.780 | 12645.5 |
217 | 2024-03-08 21:27:53 | subchief | 1 | 82945 | 2 | 3.093 | 26817.0 |
216 | 2024-03-06 22:17:00 | subchief | 4 | 161609 | 443 | 22.796 | 7089.4 |
215 | 2024-03-05 08:22:57 | subchief | 4 | 161609 | 443 | 12.063 | 13397.1 |
214 | 2024-03-04 07:44:38 | subchief | 4 | 161609 | 443 | 23.596 | 6849.0 |
213 | 2024-03-04 00:03:52 | subchief | 4 | 161609 | 443 | 20.173 | 8011.2 |
212 | 2024-03-04 00:03:50 | subchief | 3 | 146162 | 16 | 10.313 | 14172.6 |
211 | 2024-03-04 00:03:52 | subchief | 2 | 121059 | 2 | 4.936 | 24525.7 |
210 | 2024-03-04 00:03:48 | subchief | 1 | 82945 | 2 | 1.563 | 53067.8 |
209 | 2024-02-27 19:04:42 | subchief | 1 | 82945 | 2 | 1.483 | 55930.5 |
208 | 2024-02-07 14:53:03 | subchief | 2 | 121059 | 2 | 4.343 | 27874.5 |
207 | 2024-02-07 14:50:46 | subchief | 1 | 82945 | 2 | 1.670 | 49667.7 |
206 | 2024-02-07 08:35:02 | subchief | 4 | 161609 | 443 | 14.033 | 11516.4 |
205 | 2024-02-07 08:35:06 | subchief | 2 | 121059 | 2 | 6.470 | 18710.8 |
204 | 2024-02-07 08:34:50 | subchief | 3 | 146162 | 16 | 6.483 | 22545.4 |
203 | 2024-02-04 04:17:51 | subchief | 2 | 121059 | 2 | 3.513 | 34460.3 |
202 | 2024-02-04 04:17:47 | subchief | 3 | 146162 | 16 | 6.456 | 22639.7 |
201 | 2024-01-30 19:59:35 | subchief | 1 | 82945 | 2 | 1.533 | 54106.3 |
200 | 2024-01-30 03:40:12 | subchief | 4 | 161609 | 443 | 11.970 | 13501.2 |
199 | 2024-01-30 03:39:53 | subchief | 4 | 161609 | 443 | 14.110 | 11453.5 |
198 | 2024-01-30 03:40:00 | subchief | 2 | 121059 | 2 | 7.360 | 16448.2 |
197 | 2024-01-30 03:39:55 | subchief | 3 | 146162 | 16 | 7.436 | 19656.0 |
196 | 2024-01-30 03:39:41 | subchief | 3 | 146162 | 16 | 8.673 | 16852.5 |
195 | 2024-01-30 03:39:37 | subchief | 2 | 121059 | 2 | 3.656 | 33112.4 |
194 | 2024-01-30 03:39:29 | subchief | 1 | 82945 | 2 | 1.516 | 54713.1 |
193 | 2023-12-18 07:33:42 | subchief | 1 | 82945 | 2 | 1.360 | 60989.0 |
192 | 2023-12-15 09:59:06 | subchief | 3 | 146162 | 16 | 8.173 | 17883.5 |
191 | 2023-12-06 04:19:48 | subchief | 2 | 121059 | 2 | 3.186 | 37997.2 |
190 | 2023-12-04 00:05:42 | subchief | 1 | 82945 | 2 | 1.500 | 55296.7 |
189 | 2023-11-26 05:56:31 | subchief | 1 | 82945 | 2 | 1.466 | 56579.1 |
188 | 2023-09-14 21:35:29 | subchief | 3 | 146162 | 16 | 10.643 | 13733.2 |
187 | 2023-09-11 03:09:44 | subchief | 1 | 82945 | 2 | 1.406 | 58993.6 |
186 | 2023-09-03 05:14:47 | subchief | 2 | 121059 | 2 | 3.330 | 36354.1 |
185 | 2023-06-25 01:18:59 | subchief | 1 | 82945 | 2 | 1.280 | 64800.8 |
184 | 2023-06-23 10:26:30 | subchief | 1 | 82945 | 2 | 1.313 | 63172.1 |
183 | 2023-06-15 02:17:56 | subchief | 3 | 146162 | 16 | 6.190 | 23612.6 |
182 | 2023-05-20 03:14:51 | subchief | 2 | 121059 | 2 | 3.186 | 37997.2 |
181 | 2023-04-06 07:24:10 | subchief | 1 | 82945 | 2 | 1.330 | 62364.7 |
180 | 2023-03-13 09:14:00 | subchief | 3 | 146162 | 16 | 7.453 | 19611.2 |
179 | 2023-03-01 03:40:46 | subchief | 2 | 121059 | 2 | 3.093 | 39139.7 |
178 | 2023-02-01 10:41:29 | subchief | 1 | 82945 | 2 | 1.563 | 53067.8 |
177 | 2023-01-28 00:49:33 | subchief | 1 | 82945 | 2 | 1.283 | 64649.3 |
176 | 2022-12-16 09:45:22 | subchief | 3 | 146162 | 16 | 6.436 | 22710.1 |
175 | 2022-12-10 13:16:31 | subchief | 2 | 121059 | 2 | 3.123 | 38763.7 |
174 | 2022-11-26 03:39:52 | subchief | 1 | 82945 | 2 | 1.283 | 64649.3 |
173 | 2022-09-08 15:33:36 | subchief | 1 | 82945 | 2 | 1.313 | 63172.1 |
172 | 2022-08-04 02:50:32 | subchief | 3 | 146162 | 16 | 6.296 | 23215.1 |
171 | 2022-07-25 07:37:29 | subchief | 2 | 121059 | 2 | 3.406 | 35542.9 |
170 | 2022-07-21 23:05:57 | subchief | 1 | 82945 | 2 | 1.360 | 60989.0 |
169 | 2022-07-19 15:35:11 | subchief | 1 | 82945 | 2 | 1.310 | 63316.8 |
168 | 2022-03-28 20:49:09 | subchief | 1 | 82945 | 2 | 1.733 | 47862.1 |
167 | 2021-11-11 07:42:39 | subchief | 1 | 82945 | 2 | 1.503 | 55186.3 |
166 | 2021-09-16 20:45:10 | subchief | 1 | 82945 | 2 | 1.483 | 55930.5 |
165 | 2021-09-16 02:17:06 | subchief | 1 | 82945 | 2 | 1.450 | 57203.4 |
164 | 2021-09-15 08:58:17 | subchief | 1 | 82945 | 2 | 1.403 | 59119.7 |
163 | 2021-09-14 15:43:19 | subchief | 2 | 121059 | 2 | 3.843 | 31501.2 |
162 | 2021-09-14 15:43:09 | subchief | 4 | 161609 | 443 | 11.440 | 14126.7 |
161 | 2021-09-14 15:40:57 | subchief | 1 | 82945 | 2 | 1.453 | 57085.3 |
160 | 2021-09-09 10:58:15 | subchief | 1 | 82945 | 2 | 1.356 | 61168.9 |
159 | 2021-07-11 10:46:28 | subchief | 1 | 82945 | 2 | 1.436 | 57761.1 |
158 | 2021-04-07 12:38:13 | subchief | 1 | 82945 | 2 | 1.516 | 54713.1 |
157 | 2021-04-03 08:59:41 | subchief | 1 | 82945 | 2 | 1.486 | 55817.6 |
156 | 2021-03-25 09:32:02 | subchief | 1 | 82945 | 2 | 1.436 | 57761.1 |
155 | 2021-02-27 15:29:20 | subchief | 1 | 82945 | 2 | 1.280 | 64800.8 |
154 | 2020-12-11 05:22:44 | subchief | 1 | 82945 | 2 | 1.343 | 61761.0 |
153 | 2020-11-19 10:27:23 | subchief | 1 | 82945 | 2 | 1.360 | 60989.0 |
152 | 2020-10-29 01:16:56 | subchief | 1 | 82945 | 2 | 1.500 | 55296.7 |
151 | 2020-10-26 06:48:31 | subchief | 1 | 82945 | 2 | 1.393 | 59544.1 |
150 | 2020-08-16 04:14:23 | subchief | 1 | 82945 | 2 | 1.326 | 62552.8 |
149 | 2020-05-05 18:40:09 | subchief | 1 | 82945 | 2 | 1.330 | 62364.7 |
148 | 2020-03-29 17:56:05 | subchief | 1 | 82945 | 2 | 1.326 | 62552.8 |
147 | 2020-03-29 15:22:54 | subchief | 1 | 82945 | 2 | 1.453 | 57085.3 |
146 | 2020-03-26 17:13:34 | subchief | 1 | 82945 | 2 | 1.563 | 53067.8 |
145 | 2020-03-02 19:00:26 | subchief | 1 | 82945 | 2 | 1.940 | 42755.2 |