History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smeared"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 359 | 2024-04-27 11:43:32 | smeared | 1 | 69583 | 5 | 1.720 | 40455.2 |
| 358 | 2024-04-27 04:13:32 | smeared | 3 | 134027 | 572 | 14.173 | 9456.5 |
| 357 | 2024-04-15 21:35:50 | smeared | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 356 | 2024-04-14 09:50:51 | smeared | 2 | 107671 | 60 | 7.753 | 13887.7 |
| 355 | 2024-03-28 22:19:55 | smeared | 2 | 107671 | 60 | 10.236 | 10518.9 |
| 354 | 2024-03-28 22:18:21 | smeared | 1 | 69583 | 5 | 1.346 | 51696.1 |
| 353 | 2024-03-28 19:51:34 | smeared | 3 | 134027 | 572 | 22.096 | 6065.7 |
| 352 | 2024-03-28 19:51:34 | smeared | 2 | 107671 | 60 | 8.376 | 12854.7 |
| 351 | 2024-03-07 05:50:46 | smeared | 1 | 69583 | 5 | 3.843 | 18106.4 |
| 350 | 2024-03-01 09:44:03 | smeared | 2 | 107671 | 60 | 7.470 | 14413.8 |
| 349 | 2024-02-29 01:29:40 | smeared | 2 | 107671 | 60 | 3.030 | 35535.0 |
| 348 | 2024-02-29 01:29:21 | smeared | 3 | 134027 | 572 | 6.346 | 21119.9 |
| 347 | 2024-02-28 09:01:57 | smeared | 3 | 134027 | 572 | 8.080 | 16587.5 |
| 346 | 2024-02-25 21:10:29 | smeared | 3 | 134027 | 572 | 20.080 | 6674.7 |
| 345 | 2024-02-23 06:29:05 | smeared | 3 | 134027 | 572 | 6.843 | 19586.0 |
| 344 | 2024-01-29 05:07:35 | smeared | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 343 | 2024-01-26 13:26:18 | smeared | 1 | 69583 | 5 | 2.516 | 27656.2 |
| 342 | 2024-01-20 12:53:56 | smeared | 2 | 107671 | 60 | 2.970 | 36252.9 |
| 341 | 2024-01-12 14:31:50 | smeared | 3 | 134027 | 572 | 6.310 | 21240.4 |
| 340 | 2023-12-30 06:31:59 | smeared | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 339 | 2023-12-27 01:45:09 | smeared | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 338 | 2023-12-09 01:51:09 | smeared | 2 | 107671 | 60 | 2.906 | 37051.3 |
| 337 | 2023-12-07 16:09:28 | smeared | 3 | 134027 | 572 | 6.813 | 19672.2 |
| 336 | 2023-12-07 16:00:24 | smeared | 3 | 134027 | 572 | 7.000 | 19146.7 |
| 335 | 2023-12-07 15:50:32 | smeared | 3 | 134027 | 572 | 6.736 | 19897.1 |
| 334 | 2023-12-06 05:07:58 | smeared | 3 | 134027 | 572 | 16.156 | 8295.8 |
| 333 | 2023-12-06 05:07:44 | smeared | 2 | 107671 | 60 | 7.830 | 13751.1 |
| 332 | 2023-11-24 10:14:21 | smeared | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 331 | 2023-11-20 09:14:41 | smeared | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 330 | 2023-11-18 04:47:07 | smeared | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 329 | 2023-11-16 11:09:42 | smeared | 3 | 134027 | 572 | 7.453 | 17983.0 |
| 328 | 2023-11-10 23:25:23 | smeared | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 327 | 2023-10-24 07:32:05 | smeared | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 326 | 2023-10-14 00:35:24 | smeared | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 325 | 2023-10-07 03:15:14 | smeared | 3 | 134027 | 572 | 7.220 | 18563.3 |
| 324 | 2023-10-01 18:37:25 | smeared | 3 | 134027 | 572 | 7.330 | 18284.7 |
| 323 | 2023-10-01 18:37:28 | smeared | 2 | 107671 | 60 | 3.440 | 31299.7 |
| 322 | 2023-09-29 08:18:09 | smeared | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 321 | 2023-09-20 19:34:14 | smeared | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 320 | 2023-09-09 17:24:42 | smeared | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 319 | 2023-09-06 15:22:16 | smeared | 2 | 107671 | 60 | 3.060 | 35186.6 |
| 318 | 2023-08-17 22:46:17 | smeared | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 317 | 2023-08-17 02:42:52 | smeared | 3 | 134027 | 572 | 5.750 | 23309.0 |
| 316 | 2023-06-14 11:38:59 | smeared | 1 | 69583 | 5 | 2.093 | 33245.6 |
| 315 | 2023-05-25 13:20:37 | smeared | 2 | 107671 | 60 | 2.860 | 37647.2 |
| 314 | 2023-04-29 06:14:07 | smeared | 3 | 134027 | 572 | 5.690 | 23554.8 |
| 313 | 2023-04-22 14:57:43 | smeared | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 312 | 2023-03-31 07:29:24 | smeared | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 311 | 2023-03-02 14:11:52 | smeared | 2 | 107671 | 60 | 2.766 | 38926.6 |
| 310 | 2023-02-01 12:33:35 | smeared | 3 | 134027 | 572 | 6.516 | 20568.9 |
| 309 | 2023-01-13 18:07:48 | smeared | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 308 | 2022-12-30 00:15:55 | smeared | 1 | 69583 | 5 | 1.153 | 60349.5 |
| 307 | 2022-12-10 02:51:06 | smeared | 2 | 107671 | 60 | 2.750 | 39153.1 |
| 306 | 2022-11-14 21:37:23 | smeared | 3 | 134027 | 572 | 5.686 | 23571.4 |
| 305 | 2022-11-02 00:28:55 | smeared | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 304 | 2022-08-29 10:00:56 | smeared | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 303 | 2022-07-18 21:33:25 | smeared | 2 | 107671 | 60 | 2.826 | 38100.1 |
| 302 | 2022-06-22 07:58:40 | smeared | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 301 | 2022-06-20 02:22:15 | smeared | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 300 | 2022-05-12 15:16:53 | smeared | 3 | 134027 | 572 | 7.390 | 18136.3 |
| 299 | 2022-04-18 10:35:12 | smeared | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 298 | 2022-02-24 22:11:23 | smeared | 2 | 107671 | 60 | 3.813 | 28237.9 |
| 297 | 2022-02-23 05:39:30 | smeared | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 296 | 2021-12-27 02:12:08 | smeared | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 295 | 2021-12-14 09:55:00 | smeared | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 294 | 2021-11-25 05:04:35 | smeared | 2 | 107671 | 60 | 3.280 | 32826.5 |
| 293 | 2021-10-19 13:13:46 | smeared | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 292 | 2021-09-24 12:07:47 | smeared | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 291 | 2021-09-10 07:19:47 | smeared | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 290 | 2021-06-09 10:02:32 | smeared | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 289 | 2021-05-12 20:05:46 | smeared | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 288 | 2021-04-11 16:32:13 | smeared | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 287 | 2021-03-10 10:01:10 | smeared | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 286 | 2021-01-29 01:30:53 | smeared | 3 | 134027 | 572 | 6.263 | 21399.8 |
| 285 | 2021-01-25 20:59:41 | smeared | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 284 | 2020-12-31 10:17:30 | smeared | 3 | 134027 | 572 | 5.846 | 22926.3 |
| 283 | 2020-12-07 01:42:08 | smeared | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 282 | 2020-11-09 09:01:44 | smeared | 3 | 134027 | 572 | 5.970 | 22450.1 |
| 281 | 2020-11-05 14:15:35 | smeared | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 280 | 2020-11-01 19:22:34 | smeared | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 279 | 2020-10-30 13:03:33 | smeared | 1 | 69583 | 5 | 1.453 | 47889.2 |
| 278 | 2020-10-14 02:38:07 | smeared | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 277 | 2020-08-25 10:17:13 | smeared | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 276 | 2020-08-11 16:16:55 | smeared | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 275 | 2020-08-11 06:50:49 | smeared | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 274 | 2020-05-20 23:06:34 | smeared | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 273 | 2020-03-31 23:39:13 | smeared | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 272 | 2020-03-29 06:00:18 | smeared | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 271 | 2020-03-24 21:48:59 | smeared | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 270 | 2020-03-24 18:05:23 | smeared | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 269 | 2020-03-20 11:21:02 | smeared | 1 | 69583 | 5 | 1.346 | 51696.1 |
| 268 | 2020-02-29 10:17:32 | smeared | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 267 | 2020-02-25 07:19:18 | smeared | 1 | 69583 | 5 | 2.750 | 25302.9 |
| 266 | 2020-02-17 22:08:32 | smeared | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 265 | 2020-02-17 18:06:04 | smeared | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 264 | 2020-02-07 22:25:30 | smeared | 1 | 69583 | 5 | 1.346 | 51696.1 |
| 263 | 2020-02-07 17:05:36 | smeared | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 262 | 2020-02-07 16:47:59 | smeared | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 261 | 2020-02-05 02:47:38 | smeared | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 260 | 2020-02-02 10:59:05 | smeared | 1 | 69583 | 5 | 1.390 | 50059.7 |