History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deficient"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 353 | 2025-10-27 16:22:45 | deficient | 4 | 165329 | 262 | 12.176 | 13578.3 |
| 352 | 2025-10-21 10:15:16 | deficient | 4 | 165329 | 262 | 11.843 | 13960.1 |
| 351 | 2025-09-28 23:03:54 | deficient | 4 | 165329 | 262 | 11.096 | 14899.9 |
| 350 | 2025-09-17 08:27:04 | deficient | 2 | 121436 | 7 | 3.203 | 37913.2 |
| 349 | 2025-09-05 04:42:28 | deficient | 4 | 165329 | 262 | 12.970 | 12747.0 |
| 348 | 2025-08-25 15:11:14 | deficient | 1 | 81242 | 2 | 3.843 | 21140.3 |
| 347 | 2025-08-12 14:27:10 | deficient | 1 | 81242 | 2 | 6.530 | 12441.3 |
| 346 | 2025-08-04 02:02:02 | deficient | 1 | 81242 | 2 | 1.516 | 53589.7 |
| 345 | 2025-07-24 18:28:08 | deficient | 1 | 81242 | 2 | 2.983 | 27235.0 |
| 344 | 2025-07-24 08:02:52 | deficient | 1 | 81242 | 2 | 6.570 | 12365.6 |
| 343 | 2025-07-17 06:48:46 | deficient | 1 | 81242 | 2 | 3.016 | 26937.0 |
| 342 | 2025-07-16 12:25:26 | deficient | 3 | 148641 | 37 | 13.063 | 11378.8 |
| 341 | 2025-07-10 21:05:37 | deficient | 2 | 121436 | 7 | 10.533 | 11529.1 |
| 340 | 2025-06-29 10:52:09 | deficient | 4 | 165329 | 262 | 66.626 | 2481.4 |
| 339 | 2025-06-22 12:45:59 | deficient | 1 | 81242 | 2 | 6.470 | 12556.7 |
| 338 | 2025-06-18 16:13:22 | deficient | 4 | 165329 | 262 | 110.350 | 1498.2 |
| 337 | 2025-06-18 02:58:19 | deficient | 4 | 165329 | 262 | 58.610 | 2820.8 |
| 336 | 2025-06-17 04:41:29 | deficient | 4 | 165329 | 262 | 22.986 | 7192.6 |
| 335 | 2025-06-14 14:55:06 | deficient | 1 | 81242 | 2 | 5.953 | 13647.2 |
| 334 | 2025-06-11 20:13:04 | deficient | 1 | 81242 | 2 | 3.546 | 22910.9 |
| 333 | 2025-06-01 10:16:56 | deficient | 3 | 148641 | 37 | 26.283 | 5655.4 |
| 332 | 2025-06-01 09:34:05 | deficient | 2 | 121436 | 7 | 20.346 | 5968.5 |
| 331 | 2025-06-01 06:11:57 | deficient | 3 | 148641 | 37 | 35.266 | 4214.9 |
| 330 | 2025-06-01 05:57:07 | deficient | 2 | 121436 | 7 | 9.236 | 13148.1 |
| 329 | 2025-05-31 13:53:29 | deficient | 1 | 81242 | 2 | 10.373 | 7832.1 |
| 328 | 2025-05-30 05:27:18 | deficient | 1 | 81242 | 2 | 6.656 | 12205.8 |
| 327 | 2025-05-28 20:17:34 | deficient | 1 | 81242 | 2 | 6.860 | 11842.9 |
| 326 | 2025-05-26 05:05:12 | deficient | 1 | 81242 | 2 | 6.846 | 11867.1 |
| 325 | 2025-05-24 09:13:29 | deficient | 2 | 121436 | 7 | 9.253 | 13124.0 |
| 324 | 2025-05-24 08:46:58 | deficient | 3 | 148641 | 37 | 30.330 | 4900.8 |
| 323 | 2025-05-18 11:40:23 | deficient | 4 | 165329 | 262 | 66.106 | 2501.0 |
| 322 | 2025-05-17 18:19:42 | deficient | 4 | 165329 | 262 | 59.453 | 2780.8 |
| 321 | 2025-05-15 10:23:50 | deficient | 4 | 165329 | 262 | 57.333 | 2883.7 |
| 320 | 2025-05-02 13:11:41 | deficient | 1 | 81242 | 2 | 6.563 | 12378.8 |
| 319 | 2025-04-26 05:58:52 | deficient | 1 | 81242 | 2 | 3.563 | 22801.6 |
| 318 | 2025-04-12 19:42:11 | deficient | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 317 | 2025-04-09 21:13:31 | deficient | 4 | 165329 | 262 | 13.280 | 12449.5 |
| 316 | 2025-04-09 17:05:37 | deficient | 4 | 165329 | 262 | 58.066 | 2847.3 |
| 315 | 2025-04-09 10:07:48 | deficient | 2 | 121436 | 7 | 25.046 | 4848.5 |
| 314 | 2025-04-09 04:04:59 | deficient | 4 | 165329 | 262 | 67.203 | 2460.1 |
| 313 | 2025-04-07 12:13:20 | deficient | 4 | 165329 | 262 | 92.806 | 1781.4 |
| 312 | 2025-04-05 16:15:44 | deficient | 4 | 165329 | 262 | 22.160 | 7460.7 |
| 311 | 2025-04-02 13:36:28 | deficient | 1 | 81242 | 2 | 4.813 | 16879.7 |
| 310 | 2025-03-28 16:38:59 | deficient | 2 | 121436 | 7 | 3.593 | 33797.9 |
| 309 | 2025-03-28 15:00:33 | deficient | 3 | 148641 | 37 | 18.313 | 8116.7 |
| 308 | 2025-03-20 19:58:08 | deficient | 1 | 81242 | 2 | 1.420 | 57212.7 |
| 307 | 2025-03-11 15:12:13 | deficient | 3 | 148641 | 37 | 33.830 | 4393.8 |
| 306 | 2025-03-10 23:14:45 | deficient | 3 | 148641 | 37 | 57.176 | 2599.7 |
| 305 | 2025-02-27 21:19:19 | deficient | 1 | 81242 | 2 | 4.766 | 17046.2 |
| 304 | 2025-02-24 09:10:32 | deficient | 3 | 148641 | 37 | 36.436 | 4079.5 |
| 303 | 2025-02-24 09:10:34 | deficient | 3 | 148641 | 37 | 27.110 | 5482.9 |
| 302 | 2025-02-24 09:10:30 | deficient | 2 | 121436 | 7 | 14.186 | 8560.3 |
| 301 | 2025-02-24 09:10:19 | deficient | 1 | 81242 | 2 | 6.906 | 11764.0 |
| 300 | 2025-02-19 12:59:54 | deficient | 3 | 148641 | 37 | 41.516 | 3580.3 |
| 299 | 2025-02-19 12:59:53 | deficient | 3 | 148641 | 37 | 34.610 | 4294.7 |
| 298 | 2025-02-19 12:59:51 | deficient | 2 | 121436 | 7 | 18.203 | 6671.2 |
| 297 | 2025-02-19 12:59:21 | deficient | 1 | 81242 | 2 | 6.953 | 11684.5 |
| 296 | 2025-02-14 21:59:24 | deficient | 1 | 81242 | 2 | 6.610 | 12290.8 |
| 295 | 2025-01-23 00:04:40 | deficient | 1 | 81242 | 2 | 4.076 | 19931.8 |
| 294 | 2025-01-22 22:08:34 | deficient | 2 | 121436 | 7 | 16.750 | 7249.9 |
| 293 | 2025-01-17 23:47:42 | deficient | 1 | 81242 | 2 | 6.953 | 11684.5 |
| 292 | 2025-01-16 21:23:32 | deficient | 2 | 121436 | 7 | 17.690 | 6864.7 |
| 291 | 2025-01-16 21:22:23 | deficient | 1 | 81242 | 2 | 3.233 | 25129.0 |
| 290 | 2025-01-14 11:20:40 | deficient | 3 | 148641 | 37 | 44.576 | 3334.6 |
| 289 | 2025-01-13 12:12:28 | deficient | 3 | 148641 | 37 | 35.410 | 4197.7 |
| 288 | 2025-01-12 12:28:24 | deficient | 3 | 148641 | 37 | 35.783 | 4154.0 |
| 287 | 2025-01-12 12:28:26 | deficient | 2 | 121436 | 7 | 17.690 | 6864.7 |
| 286 | 2025-01-12 09:26:34 | deficient | 2 | 121436 | 7 | 17.373 | 6989.9 |
| 285 | 2025-01-12 09:25:47 | deficient | 1 | 81242 | 2 | 5.266 | 15427.6 |
| 284 | 2024-12-30 00:24:41 | deficient | 3 | 148641 | 37 | 44.516 | 3339.0 |
| 283 | 2024-12-16 12:22:44 | deficient | 3 | 148641 | 37 | 49.656 | 2993.4 |
| 282 | 2024-12-16 12:22:13 | deficient | 1 | 81242 | 2 | 3.533 | 22995.2 |
| 281 | 2024-12-15 20:16:37 | deficient | 1 | 81242 | 2 | 3.890 | 20884.8 |
| 280 | 2024-12-15 06:20:49 | deficient | 3 | 148641 | 37 | 35.893 | 4141.2 |
| 279 | 2024-12-13 03:10:55 | deficient | 3 | 148641 | 37 | 30.766 | 4831.3 |
| 278 | 2024-12-12 04:36:57 | deficient | 3 | 148641 | 37 | 46.050 | 3227.8 |
| 277 | 2024-12-12 04:33:43 | deficient | 1 | 81242 | 2 | 4.906 | 16559.7 |
| 276 | 2024-12-02 20:27:09 | deficient | 1 | 81242 | 2 | 8.313 | 9772.9 |
| 275 | 2024-11-17 00:05:24 | deficient | 2 | 121436 | 7 | 20.390 | 5955.7 |
| 274 | 2024-11-12 08:53:53 | deficient | 2 | 121436 | 7 | 18.203 | 6671.2 |
| 273 | 2024-11-12 00:55:55 | deficient | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 272 | 2024-11-11 16:37:51 | deficient | 1 | 81242 | 2 | 3.593 | 22611.2 |
| 271 | 2024-11-09 15:09:53 | deficient | 1 | 81242 | 2 | 6.500 | 12498.8 |
| 270 | 2024-11-02 11:46:11 | deficient | 1 | 81242 | 2 | 10.266 | 7913.7 |
| 269 | 2024-11-01 06:55:25 | deficient | 3 | 148641 | 37 | 36.910 | 4027.1 |
| 268 | 2024-10-29 07:01:41 | deficient | 3 | 148641 | 37 | 51.486 | 2887.0 |
| 267 | 2024-10-28 15:37:24 | deficient | 3 | 148641 | 37 | 39.660 | 3747.9 |
| 266 | 2024-10-20 16:09:29 | deficient | 3 | 148641 | 37 | 40.610 | 3660.2 |
| 265 | 2024-10-20 16:09:14 | deficient | 3 | 148641 | 37 | 37.143 | 4001.9 |
| 264 | 2024-09-25 03:33:52 | deficient | 1 | 81242 | 2 | 9.846 | 8251.3 |
| 263 | 2024-09-25 00:11:36 | deficient | 3 | 148641 | 37 | 30.660 | 4848.0 |
| 262 | 2024-09-24 11:54:01 | deficient | 1 | 81242 | 2 | 10.376 | 7829.8 |
| 261 | 2024-09-21 03:08:12 | deficient | 4 | 165329 | 262 | 108.070 | 1529.8 |
| 260 | 2024-09-20 04:19:34 | deficient | 3 | 148641 | 37 | 25.140 | 5912.5 |
| 259 | 2024-09-17 16:46:59 | deficient | 2 | 121436 | 7 | 20.550 | 5909.3 |
| 258 | 2024-09-16 13:35:53 | deficient | 4 | 165329 | 262 | 77.393 | 2136.2 |
| 257 | 2024-09-16 13:36:07 | deficient | 3 | 148641 | 37 | 53.956 | 2754.9 |
| 256 | 2024-09-16 13:35:52 | deficient | 2 | 121436 | 7 | 41.580 | 2920.5 |
| 255 | 2024-09-05 02:43:43 | deficient | 1 | 81242 | 2 | 5.423 | 14981.0 |
| 254 | 2024-09-02 07:26:10 | deficient | 1 | 81242 | 2 | 10.050 | 8083.8 |