History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
268 | 2024-04-09 01:08:29 | substate | 1 | 82945 | 4 | 1.530 | 54212.4 |
267 | 2024-04-06 10:17:45 | substate | 2 | 121059 | 18 | 12.140 | 9971.9 |
266 | 2024-04-06 10:17:40 | substate | 1 | 82945 | 4 | 3.173 | 26140.9 |
265 | 2024-04-03 09:57:14 | substate | 3 | 146162 | 123 | 26.783 | 5457.3 |
264 | 2024-04-03 09:47:33 | substate | 3 | 146162 | 123 | 22.266 | 6564.4 |
263 | 2024-03-31 15:56:28 | substate | 2 | 121059 | 18 | 4.250 | 28484.5 |
262 | 2024-03-31 15:55:44 | substate | 3 | 146162 | 123 | 7.813 | 18707.5 |
261 | 2024-03-30 11:58:37 | substate | 2 | 121059 | 18 | 3.346 | 36180.2 |
260 | 2024-03-30 11:58:35 | substate | 1 | 82945 | 4 | 1.550 | 53512.9 |
259 | 2024-03-30 02:29:37 | substate | 3 | 146162 | 123 | 9.830 | 14869.0 |
258 | 2024-03-29 22:43:00 | substate | 3 | 146162 | 123 | 19.706 | 7417.1 |
257 | 2024-03-29 22:42:58 | substate | 2 | 121059 | 18 | 8.923 | 13567.1 |
256 | 2024-03-29 22:16:54 | substate | 1 | 82945 | 4 | 3.720 | 22297.0 |
255 | 2024-03-07 09:04:41 | substate | 1 | 82945 | 4 | 1.703 | 48705.2 |
254 | 2024-02-28 12:45:10 | substate | 1 | 82945 | 4 | 1.546 | 53651.4 |
253 | 2024-02-04 09:27:41 | substate | 3 | 146162 | 123 | 12.406 | 11781.6 |
252 | 2024-01-31 05:43:42 | substate | 2 | 121059 | 18 | 4.000 | 30264.8 |
251 | 2024-01-31 05:39:23 | substate | 3 | 146162 | 123 | 7.783 | 18779.6 |
250 | 2024-01-31 04:51:11 | substate | 1 | 82945 | 4 | 1.436 | 57761.1 |
249 | 2024-01-31 04:47:47 | substate | 2 | 121059 | 18 | 4.626 | 26169.3 |
248 | 2024-01-31 04:47:35 | substate | 3 | 146162 | 123 | 7.373 | 19824.0 |
247 | 2024-01-31 04:46:39 | substate | 3 | 146162 | 123 | 8.876 | 16467.1 |
246 | 2024-01-31 04:46:35 | substate | 2 | 121059 | 18 | 6.013 | 20132.9 |
245 | 2024-01-21 15:42:23 | substate | 1 | 82945 | 4 | 1.393 | 59544.1 |
244 | 2024-01-16 01:17:13 | substate | 2 | 121059 | 18 | 3.233 | 37444.8 |
243 | 2023-12-31 15:43:49 | substate | 1 | 82945 | 4 | 1.423 | 58288.8 |
242 | 2023-12-28 16:06:02 | substate | 1 | 82945 | 4 | 2.673 | 31030.7 |
241 | 2023-12-28 07:27:11 | substate | 1 | 82945 | 4 | 1.263 | 65673.0 |
240 | 2023-11-20 20:52:52 | substate | 1 | 82945 | 4 | 3.343 | 24811.5 |
239 | 2023-10-24 14:04:11 | substate | 2 | 121059 | 18 | 3.280 | 36908.2 |
238 | 2023-10-17 15:34:54 | substate | 1 | 82945 | 4 | 1.453 | 57085.3 |
237 | 2023-10-06 11:34:07 | substate | 1 | 82945 | 4 | 1.296 | 64000.8 |
236 | 2023-09-07 16:32:30 | substate | 1 | 82945 | 4 | 1.266 | 65517.4 |
235 | 2023-08-13 03:20:36 | substate | 1 | 82945 | 4 | 1.296 | 64000.8 |
234 | 2023-08-03 02:01:22 | substate | 2 | 121059 | 18 | 3.890 | 31120.6 |
233 | 2023-05-14 22:56:48 | substate | 1 | 82945 | 4 | 1.343 | 61761.0 |
232 | 2023-05-11 06:01:40 | substate | 1 | 82945 | 4 | 1.263 | 65673.0 |
231 | 2023-04-13 02:54:57 | substate | 2 | 121059 | 18 | 3.110 | 38925.7 |
230 | 2023-03-10 23:25:10 | substate | 1 | 82945 | 4 | 1.283 | 64649.3 |
229 | 2023-01-19 07:47:47 | substate | 2 | 121059 | 18 | 3.406 | 35542.9 |
228 | 2023-01-14 06:58:14 | substate | 1 | 82945 | 4 | 1.423 | 58288.8 |
227 | 2022-12-30 11:23:49 | substate | 1 | 82945 | 4 | 1.470 | 56425.2 |
226 | 2022-10-29 10:08:38 | substate | 2 | 121059 | 18 | 3.643 | 33230.6 |
225 | 2022-09-18 04:09:01 | substate | 1 | 82945 | 4 | 1.283 | 64649.3 |
224 | 2022-09-12 07:14:32 | substate | 1 | 82945 | 4 | 1.453 | 57085.3 |
223 | 2022-09-08 17:07:11 | substate | 1 | 82945 | 4 | 1.423 | 58288.8 |
222 | 2022-05-30 23:51:11 | substate | 2 | 121059 | 18 | 3.640 | 33258.0 |
221 | 2022-04-27 00:07:45 | substate | 1 | 82945 | 4 | 1.500 | 55296.7 |
220 | 2022-04-25 16:03:01 | substate | 1 | 82945 | 4 | 1.703 | 48705.2 |
219 | 2022-01-17 04:07:55 | substate | 2 | 121059 | 18 | 3.216 | 37642.7 |
218 | 2022-01-11 20:03:01 | substate | 1 | 82945 | 4 | 1.313 | 63172.1 |
217 | 2021-12-30 12:35:18 | substate | 1 | 82945 | 4 | 3.110 | 26670.4 |
216 | 2021-11-10 21:14:26 | substate | 2 | 121059 | 18 | 3.983 | 30393.9 |
215 | 2021-11-07 19:35:21 | substate | 1 | 82945 | 4 | 1.453 | 57085.3 |
214 | 2021-10-10 02:36:20 | substate | 1 | 82945 | 4 | 1.310 | 63316.8 |
213 | 2021-09-17 00:33:47 | substate | 1 | 82945 | 4 | 1.423 | 58288.8 |
212 | 2021-09-13 19:12:39 | substate | 1 | 82945 | 4 | 1.560 | 53169.9 |
211 | 2021-06-09 17:35:48 | substate | 1 | 82945 | 4 | 1.423 | 58288.8 |
210 | 2021-02-28 18:00:05 | substate | 1 | 82945 | 4 | 1.313 | 63172.1 |
209 | 2021-02-25 06:52:12 | substate | 3 | 146162 | 123 | 6.326 | 23105.0 |
208 | 2020-11-14 17:33:44 | substate | 1 | 82945 | 4 | 1.343 | 61761.0 |
207 | 2020-10-26 14:57:06 | substate | 1 | 82945 | 4 | 1.330 | 62364.7 |
206 | 2020-10-18 08:59:21 | substate | 1 | 82945 | 4 | 1.283 | 64649.3 |
205 | 2020-09-17 19:09:26 | substate | 1 | 82945 | 4 | 1.343 | 61761.0 |
204 | 2020-08-22 12:55:34 | substate | 1 | 82945 | 4 | 1.326 | 62552.8 |
203 | 2020-08-07 06:01:24 | substate | 1 | 82945 | 4 | 1.310 | 63316.8 |
202 | 2020-05-05 20:18:32 | substate | 1 | 82945 | 4 | 1.326 | 62552.8 |
201 | 2020-03-22 06:56:52 | substate | 1 | 82945 | 4 | 1.513 | 54821.5 |
200 | 2020-02-29 21:06:16 | substate | 1 | 82945 | 4 | 3.266 | 25396.5 |
199 | 2020-02-29 15:59:20 | substate | 1 | 82945 | 4 | 3.046 | 27230.8 |
198 | 2020-02-27 02:56:18 | substate | 1 | 82945 | 4 | 3.220 | 25759.3 |
197 | 2020-02-25 01:03:07 | substate | 1 | 82945 | 4 | 3.080 | 26930.2 |
196 | 2020-02-10 21:43:49 | substate | 1 | 82945 | 4 | 1.610 | 51518.6 |
195 | 2020-02-06 21:34:55 | substate | 1 | 82945 | 4 | 1.453 | 57085.3 |
194 | 2020-02-01 07:47:34 | substate | 1 | 82945 | 4 | 3.343 | 24811.5 |
193 | 2020-01-31 12:44:55 | substate | 1 | 82945 | 4 | 2.576 | 32199.1 |
192 | 2020-01-27 05:46:54 | substate | 1 | 82945 | 4 | 1.470 | 56425.2 |
191 | 2020-01-26 23:38:01 | substate | 1 | 82945 | 4 | 2.703 | 30686.3 |
190 | 2020-01-26 18:58:40 | substate | 1 | 82945 | 4 | 2.733 | 30349.4 |
189 | 2020-01-20 11:21:54 | substate | 1 | 82945 | 4 | 2.966 | 27965.3 |
188 | 2020-01-14 18:56:09 | substate | 1 | 82945 | 4 | 1.440 | 57600.7 |
187 | 2020-01-09 20:35:28 | substate | 1 | 82945 | 4 | 1.593 | 52068.4 |
186 | 2020-01-07 14:25:35 | substate | 1 | 82945 | 4 | 1.690 | 49079.9 |
185 | 2020-01-07 00:16:02 | substate | 1 | 82945 | 4 | 3.330 | 24908.4 |
184 | 2019-12-29 07:51:27 | substate | 1 | 82945 | 4 | 1.606 | 51646.9 |
183 | 2019-12-25 05:17:54 | substate | 1 | 82945 | 4 | 1.436 | 57761.1 |
182 | 2019-10-30 11:40:28 | substate | 1 | 82945 | 4 | 1.326 | 62552.8 |
181 | 2019-07-29 09:05:43 | substate | 1 | 82945 | 4 | 1.280 | 64800.8 |
180 | 2019-04-22 01:30:26 | substate | 1 | 82945 | 4 | 1.470 | 56425.2 |
179 | 2019-03-08 04:28:04 | substate | 1 | 82945 | 4 | 1.256 | 66039.0 |
178 | 2019-02-02 06:27:49 | substate | 1 | 82945 | 4 | 1.226 | 67655.0 |
177 | 2019-01-24 11:57:41 | substate | 1 | 82945 | 4 | 1.453 | 57085.3 |
176 | 2018-12-29 21:59:38 | substate | 1 | 82945 | 4 | 1.260 | 65829.4 |
175 | 2018-12-01 23:20:08 | substate | 1 | 82945 | 4 | 1.230 | 67435.0 |
174 | 2018-09-14 20:39:50 | substate | 1 | 82945 | 4 | 1.353 | 61304.5 |
173 | 2018-08-30 08:11:14 | substate | 1 | 82945 | 4 | 1.366 | 60721.1 |
172 | 2018-08-16 01:48:55 | substate | 1 | 82945 | 4 | 2.220 | 37362.6 |
171 | 2018-08-14 10:50:40 | substate | 1 | 82945 | 4 | 1.446 | 57361.7 |
170 | 2018-08-12 12:36:11 | substate | 1 | 82945 | 4 | 1.483 | 55930.5 |
169 | 2018-08-10 16:40:19 | substate | 1 | 82945 | 4 | 1.376 | 60279.8 |