History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bastions"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
296 | 2024-05-01 20:11:43 | bastions | 2 | 121059 | 25 | 6.076 | 19924.1 |
295 | 2024-04-30 18:17:34 | bastions | 3 | 146162 | 292 | 14.203 | 10290.9 |
294 | 2024-04-30 18:17:37 | bastions | 2 | 121059 | 25 | 6.126 | 19761.5 |
293 | 2024-04-30 16:14:29 | bastions | 1 | 82945 | 3 | 3.186 | 26034.2 |
292 | 2024-04-19 19:14:16 | bastions | 2 | 121059 | 25 | 14.080 | 8597.9 |
291 | 2024-04-19 19:12:26 | bastions | 3 | 146162 | 292 | 9.360 | 15615.6 |
290 | 2024-04-19 12:21:35 | bastions | 3 | 146162 | 292 | 7.703 | 18974.7 |
289 | 2024-03-31 12:49:06 | bastions | 1 | 82945 | 3 | 5.046 | 16437.8 |
288 | 2024-03-28 09:50:37 | bastions | 1 | 82945 | 3 | 4.280 | 19379.7 |
287 | 2024-03-01 01:11:33 | bastions | 1 | 82945 | 3 | 1.483 | 55930.5 |
286 | 2024-02-07 06:09:17 | bastions | 1 | 82945 | 3 | 1.406 | 58993.6 |
285 | 2024-02-03 10:55:40 | bastions | 1 | 82945 | 3 | 1.406 | 58993.6 |
284 | 2024-01-25 18:53:04 | bastions | 1 | 82945 | 3 | 1.440 | 57600.7 |
283 | 2023-12-14 09:50:03 | bastions | 3 | 146162 | 292 | 6.796 | 21507.1 |
282 | 2023-11-29 23:05:16 | bastions | 1 | 82945 | 3 | 1.453 | 57085.3 |
281 | 2023-11-26 01:34:33 | bastions | 1 | 82945 | 3 | 1.393 | 59544.1 |
280 | 2023-11-22 01:32:22 | bastions | 1 | 82945 | 3 | 1.310 | 63316.8 |
279 | 2023-11-20 08:24:18 | bastions | 1 | 82945 | 3 | 1.283 | 64649.3 |
278 | 2023-11-15 12:38:26 | bastions | 1 | 82945 | 3 | 1.283 | 64649.3 |
277 | 2023-11-01 06:02:40 | bastions | 1 | 82945 | 3 | 1.560 | 53169.9 |
276 | 2023-10-19 06:57:20 | bastions | 1 | 82945 | 3 | 1.296 | 64000.8 |
275 | 2023-10-16 02:46:25 | bastions | 1 | 82945 | 3 | 1.343 | 61761.0 |
274 | 2023-10-06 12:55:50 | bastions | 1 | 82945 | 3 | 1.310 | 63316.8 |
273 | 2023-09-14 20:53:58 | bastions | 1 | 82945 | 3 | 1.423 | 58288.8 |
272 | 2023-09-13 18:45:41 | bastions | 3 | 146162 | 292 | 6.343 | 23043.0 |
271 | 2023-09-05 22:51:27 | bastions | 1 | 82945 | 3 | 1.250 | 66356.0 |
270 | 2023-07-09 21:33:13 | bastions | 1 | 82945 | 3 | 1.313 | 63172.1 |
269 | 2023-06-16 16:40:16 | bastions | 3 | 146162 | 292 | 6.500 | 22486.5 |
268 | 2023-06-12 10:25:32 | bastions | 3 | 146162 | 292 | 7.220 | 20244.0 |
267 | 2023-06-09 02:10:01 | bastions | 1 | 82945 | 3 | 1.266 | 65517.4 |
266 | 2023-04-02 09:10:45 | bastions | 1 | 82945 | 3 | 1.450 | 57203.4 |
265 | 2023-03-28 10:18:26 | bastions | 1 | 82945 | 3 | 1.263 | 65673.0 |
264 | 2023-03-12 21:54:41 | bastions | 3 | 146162 | 292 | 6.266 | 23326.2 |
263 | 2023-01-23 15:17:13 | bastions | 3 | 146162 | 292 | 6.300 | 23200.3 |
262 | 2023-01-11 13:54:11 | bastions | 1 | 82945 | 3 | 2.626 | 31586.1 |
261 | 2022-12-28 04:23:37 | bastions | 1 | 82945 | 3 | 1.466 | 56579.1 |
260 | 2022-12-26 06:31:40 | bastions | 3 | 146162 | 292 | 6.200 | 23574.5 |
259 | 2022-12-17 05:37:06 | bastions | 3 | 146162 | 292 | 6.436 | 22710.1 |
258 | 2022-12-09 08:47:44 | bastions | 3 | 146162 | 292 | 6.966 | 20982.2 |
257 | 2022-11-27 01:54:38 | bastions | 3 | 146162 | 292 | 7.063 | 20694.0 |
256 | 2022-11-03 07:41:56 | bastions | 3 | 146162 | 292 | 7.953 | 18378.2 |
255 | 2022-10-23 05:14:23 | bastions | 3 | 146162 | 292 | 6.266 | 23326.2 |
254 | 2022-10-17 21:25:34 | bastions | 1 | 82945 | 3 | 1.266 | 65517.4 |
253 | 2022-09-18 22:16:22 | bastions | 3 | 146162 | 292 | 7.033 | 20782.3 |
252 | 2022-09-13 19:06:46 | bastions | 1 | 82945 | 3 | 1.376 | 60279.8 |
251 | 2022-09-13 17:34:27 | bastions | 1 | 82945 | 3 | 1.403 | 59119.7 |
250 | 2022-09-10 18:05:13 | bastions | 3 | 146162 | 292 | 6.673 | 21903.5 |
249 | 2022-09-07 14:27:05 | bastions | 2 | 121059 | 25 | 3.716 | 32577.8 |
248 | 2022-09-05 12:22:51 | bastions | 2 | 121059 | 25 | 3.623 | 33414.0 |
247 | 2022-09-03 02:30:55 | bastions | 3 | 146162 | 292 | 7.736 | 18893.7 |
246 | 2022-08-27 14:11:24 | bastions | 1 | 82945 | 3 | 1.296 | 64000.8 |
245 | 2022-08-15 14:25:31 | bastions | 3 | 146162 | 292 | 6.530 | 22383.2 |
244 | 2022-08-10 20:44:25 | bastions | 3 | 146162 | 292 | 6.626 | 22058.9 |
243 | 2022-07-29 13:24:13 | bastions | 1 | 82945 | 3 | 1.250 | 66356.0 |
242 | 2022-07-10 15:50:35 | bastions | 1 | 82945 | 3 | 1.330 | 62364.7 |
241 | 2022-06-08 13:42:57 | bastions | 1 | 82945 | 3 | 1.296 | 64000.8 |
240 | 2022-06-02 00:39:14 | bastions | 3 | 146162 | 292 | 6.326 | 23105.0 |
239 | 2022-05-28 16:36:44 | bastions | 1 | 82945 | 3 | 1.346 | 61623.3 |
238 | 2022-04-27 07:27:12 | bastions | 3 | 146162 | 292 | 6.766 | 21602.4 |
237 | 2022-04-10 01:33:13 | bastions | 2 | 121059 | 25 | 3.406 | 35542.9 |
236 | 2022-03-11 10:55:33 | bastions | 3 | 146162 | 292 | 6.750 | 21653.6 |
235 | 2022-03-07 11:33:00 | bastions | 3 | 146162 | 292 | 7.703 | 18974.7 |
234 | 2022-02-20 13:11:33 | bastions | 1 | 82945 | 3 | 1.483 | 55930.5 |
233 | 2022-02-18 08:22:29 | bastions | 1 | 82945 | 3 | 1.423 | 58288.8 |
232 | 2022-02-13 20:35:09 | bastions | 1 | 82945 | 3 | 1.296 | 64000.8 |
231 | 2021-12-05 12:24:21 | bastions | 1 | 82945 | 3 | 1.420 | 58412.0 |
230 | 2021-11-06 00:54:29 | bastions | 1 | 82945 | 3 | 1.326 | 62552.8 |
229 | 2021-10-19 01:57:06 | bastions | 1 | 82945 | 3 | 1.296 | 64000.8 |
228 | 2021-09-21 20:53:07 | bastions | 1 | 82945 | 3 | 1.486 | 55817.6 |
227 | 2021-08-06 08:21:40 | bastions | 1 | 82945 | 3 | 1.453 | 57085.3 |
226 | 2021-06-11 12:32:44 | bastions | 1 | 82945 | 3 | 1.500 | 55296.7 |
225 | 2021-05-27 06:22:06 | bastions | 1 | 82945 | 3 | 1.296 | 64000.8 |
224 | 2021-05-24 00:50:04 | bastions | 3 | 146162 | 292 | 8.186 | 17855.1 |
223 | 2021-05-02 07:45:13 | bastions | 1 | 82945 | 3 | 1.376 | 60279.8 |
222 | 2021-05-01 11:09:10 | bastions | 1 | 82945 | 3 | 1.500 | 55296.7 |
221 | 2021-02-08 12:56:38 | bastions | 1 | 82945 | 3 | 1.453 | 57085.3 |
220 | 2021-02-01 14:13:46 | bastions | 1 | 82945 | 3 | 1.453 | 57085.3 |
219 | 2021-02-01 02:08:02 | bastions | 3 | 146162 | 292 | 6.390 | 22873.6 |
218 | 2021-01-30 00:28:07 | bastions | 1 | 82945 | 3 | 2.843 | 29175.2 |
217 | 2020-11-05 18:41:19 | bastions | 1 | 82945 | 3 | 1.373 | 60411.5 |
216 | 2020-10-30 20:29:08 | bastions | 1 | 82945 | 3 | 1.503 | 55186.3 |
215 | 2020-10-29 21:17:37 | bastions | 3 | 146162 | 292 | 6.766 | 21602.4 |
214 | 2020-10-27 08:09:03 | bastions | 1 | 82945 | 3 | 1.483 | 55930.5 |
213 | 2020-10-22 02:30:23 | bastions | 1 | 82945 | 3 | 1.266 | 65517.4 |
212 | 2020-08-22 08:16:50 | bastions | 1 | 82945 | 3 | 1.343 | 61761.0 |
211 | 2020-07-26 16:08:28 | bastions | 1 | 82945 | 3 | 1.376 | 60279.8 |
210 | 2020-05-21 09:42:52 | bastions | 1 | 82945 | 3 | 1.313 | 63172.1 |
209 | 2020-04-24 10:11:52 | bastions | 1 | 82945 | 3 | 1.283 | 64649.3 |
208 | 2020-04-10 12:59:55 | bastions | 3 | 146162 | 292 | 6.953 | 21021.4 |
207 | 2020-03-25 20:01:07 | bastions | 1 | 82945 | 3 | 1.410 | 58826.2 |
206 | 2020-03-24 00:14:22 | bastions | 1 | 82945 | 3 | 1.500 | 55296.7 |
205 | 2020-03-21 16:03:01 | bastions | 1 | 82945 | 3 | 1.313 | 63172.1 |
204 | 2020-03-04 14:14:18 | bastions | 3 | 146162 | 292 | 7.470 | 19566.5 |
203 | 2020-02-28 00:16:57 | bastions | 3 | 146162 | 292 | 9.063 | 16127.3 |
202 | 2020-02-26 16:24:31 | bastions | 1 | 82945 | 3 | 2.610 | 31779.7 |
201 | 2020-02-26 05:20:54 | bastions | 3 | 146162 | 292 | 17.300 | 8448.7 |
200 | 2020-02-19 19:14:20 | bastions | 1 | 82945 | 3 | 1.580 | 52496.8 |
199 | 2020-02-15 06:00:22 | bastions | 1 | 82945 | 3 | 2.343 | 35401.2 |
198 | 2020-02-13 22:12:13 | bastions | 3 | 146162 | 292 | 9.500 | 15385.5 |
197 | 2020-02-09 14:42:10 | bastions | 1 | 82945 | 3 | 1.453 | 57085.3 |