History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"optimal"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 383 | 2025-10-24 14:41:48 | optimal | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 382 | 2025-10-04 21:30:26 | optimal | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 381 | 2025-09-21 18:08:48 | optimal | 3 | 134027 | 101 | 6.983 | 19193.3 |
| 380 | 2025-09-07 14:50:05 | optimal | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 379 | 2025-08-23 10:20:00 | optimal | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 378 | 2025-08-21 01:18:43 | optimal | 1 | 69583 | 3 | 2.576 | 27012.0 |
| 377 | 2025-08-12 19:11:25 | optimal | 1 | 69583 | 3 | 5.420 | 12838.2 |
| 376 | 2025-08-11 11:58:23 | optimal | 1 | 69583 | 3 | 8.393 | 8290.6 |
| 375 | 2025-08-10 16:11:29 | optimal | 3 | 134027 | 101 | 16.156 | 8295.8 |
| 374 | 2025-08-06 10:58:59 | optimal | 3 | 134027 | 101 | 15.143 | 8850.8 |
| 373 | 2025-08-05 16:54:21 | optimal | 1 | 69583 | 3 | 4.530 | 15360.5 |
| 372 | 2025-08-05 04:14:29 | optimal | 3 | 134027 | 101 | 17.860 | 7504.3 |
| 371 | 2025-08-04 15:02:58 | optimal | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 370 | 2025-08-03 20:07:37 | optimal | 1 | 69583 | 3 | 6.720 | 10354.6 |
| 369 | 2025-08-01 18:23:55 | optimal | 3 | 134027 | 101 | 39.546 | 3389.1 |
| 368 | 2025-08-01 18:16:56 | optimal | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 367 | 2025-07-31 01:29:41 | optimal | 2 | 107671 | 10 | 15.346 | 7016.2 |
| 366 | 2025-07-29 04:13:48 | optimal | 3 | 134027 | 101 | 17.876 | 7497.6 |
| 365 | 2025-07-29 04:12:56 | optimal | 2 | 107671 | 10 | 15.533 | 6931.8 |
| 364 | 2025-07-27 16:30:02 | optimal | 1 | 69583 | 3 | 5.016 | 13872.2 |
| 363 | 2025-07-27 13:04:08 | optimal | 1 | 69583 | 3 | 3.220 | 21609.6 |
| 362 | 2025-07-25 18:21:31 | optimal | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 361 | 2025-07-19 06:19:05 | optimal | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 360 | 2025-07-19 02:35:46 | optimal | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 359 | 2025-07-11 09:51:30 | optimal | 1 | 69583 | 3 | 9.280 | 7498.2 |
| 358 | 2025-07-08 01:59:28 | optimal | 1 | 69583 | 3 | 8.610 | 8081.6 |
| 357 | 2025-07-05 15:00:21 | optimal | 1 | 69583 | 3 | 6.780 | 10263.0 |
| 356 | 2025-07-03 16:05:21 | optimal | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 355 | 2025-06-28 16:35:56 | optimal | 1 | 69583 | 3 | 2.860 | 24329.7 |
| 354 | 2025-06-25 23:00:01 | optimal | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 353 | 2025-06-23 12:27:24 | optimal | 1 | 69583 | 3 | 3.033 | 22942.0 |
| 352 | 2025-06-21 11:38:36 | optimal | 1 | 69583 | 3 | 4.550 | 15293.0 |
| 351 | 2025-06-20 19:28:53 | optimal | 1 | 69583 | 3 | 3.860 | 18026.7 |
| 350 | 2025-06-17 03:10:25 | optimal | 1 | 69583 | 3 | 5.513 | 12621.6 |
| 349 | 2025-06-14 04:06:51 | optimal | 1 | 69583 | 3 | 6.233 | 11163.6 |
| 348 | 2025-06-10 01:52:44 | optimal | 1 | 69583 | 3 | 4.580 | 15192.8 |
| 347 | 2025-06-04 15:57:18 | optimal | 1 | 69583 | 3 | 2.783 | 25002.9 |
| 346 | 2025-05-28 12:14:07 | optimal | 1 | 69583 | 3 | 6.123 | 11364.2 |
| 345 | 2025-05-26 17:10:39 | optimal | 1 | 69583 | 3 | 5.266 | 13213.6 |
| 344 | 2025-05-23 12:01:42 | optimal | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 343 | 2025-05-16 14:15:06 | optimal | 1 | 69583 | 3 | 4.390 | 15850.3 |
| 342 | 2025-05-13 13:47:59 | optimal | 1 | 69583 | 3 | 4.690 | 14836.5 |
| 341 | 2025-05-12 19:27:18 | optimal | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 340 | 2025-05-10 02:21:14 | optimal | 1 | 69583 | 3 | 5.016 | 13872.2 |
| 339 | 2025-04-30 14:04:10 | optimal | 1 | 69583 | 3 | 4.093 | 17000.5 |
| 338 | 2025-04-27 00:35:28 | optimal | 1 | 69583 | 3 | 2.453 | 28366.5 |
| 337 | 2025-04-22 13:04:00 | optimal | 2 | 107671 | 10 | 4.000 | 26917.8 |
| 336 | 2025-04-22 10:12:30 | optimal | 2 | 107671 | 10 | 2.953 | 36461.6 |
| 335 | 2025-04-16 15:46:28 | optimal | 1 | 69583 | 3 | 5.016 | 13872.2 |
| 334 | 2025-04-14 14:08:28 | optimal | 1 | 69583 | 3 | 5.873 | 11847.9 |
| 333 | 2025-04-08 01:43:25 | optimal | 1 | 69583 | 3 | 5.656 | 12302.5 |
| 332 | 2025-03-29 16:58:16 | optimal | 1 | 69583 | 3 | 6.643 | 10474.6 |
| 331 | 2025-03-20 18:30:46 | optimal | 1 | 69583 | 3 | 2.860 | 24329.7 |
| 330 | 2025-03-15 01:12:24 | optimal | 1 | 69583 | 3 | 2.716 | 25619.7 |
| 329 | 2025-03-07 13:54:39 | optimal | 1 | 69583 | 3 | 4.063 | 17126.0 |
| 328 | 2025-03-06 09:32:59 | optimal | 1 | 69583 | 3 | 3.923 | 17737.2 |
| 327 | 2025-02-04 04:38:10 | optimal | 1 | 69583 | 3 | 3.203 | 21724.3 |
| 326 | 2025-02-04 03:52:59 | optimal | 1 | 69583 | 3 | 3.110 | 22374.0 |
| 325 | 2025-01-25 19:47:04 | optimal | 1 | 69583 | 3 | 5.673 | 12265.6 |
| 324 | 2025-01-19 10:06:10 | optimal | 1 | 69583 | 3 | 5.110 | 13617.0 |
| 323 | 2025-01-04 02:41:58 | optimal | 1 | 69583 | 3 | 3.483 | 19977.9 |
| 322 | 2024-12-16 14:08:33 | optimal | 1 | 69583 | 3 | 7.126 | 9764.7 |
| 321 | 2024-11-29 10:10:20 | optimal | 1 | 69583 | 3 | 6.030 | 11539.5 |
| 320 | 2024-11-17 00:50:18 | optimal | 1 | 69583 | 3 | 2.923 | 23805.3 |
| 319 | 2024-10-27 02:09:45 | optimal | 1 | 69583 | 3 | 5.623 | 12374.7 |
| 318 | 2024-10-08 02:38:17 | optimal | 1 | 69583 | 3 | 10.046 | 6926.4 |
| 317 | 2024-09-11 00:59:51 | optimal | 1 | 69583 | 3 | 8.923 | 7798.2 |
| 316 | 2024-09-08 14:35:09 | optimal | 1 | 69583 | 3 | 4.950 | 14057.2 |
| 315 | 2024-09-02 21:18:06 | optimal | 1 | 69583 | 3 | 12.266 | 5672.8 |
| 314 | 2024-08-10 09:42:27 | optimal | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 313 | 2024-08-04 02:49:45 | optimal | 1 | 69583 | 3 | 5.860 | 11874.2 |
| 312 | 2024-07-30 22:58:31 | optimal | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 311 | 2024-07-19 16:26:31 | optimal | 1 | 69583 | 3 | 8.313 | 8370.4 |
| 310 | 2024-07-16 18:55:55 | optimal | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 309 | 2024-07-12 19:57:07 | optimal | 3 | 134027 | 101 | 22.516 | 5952.5 |
| 308 | 2024-07-12 02:43:57 | optimal | 3 | 134027 | 101 | 34.660 | 3866.9 |
| 307 | 2024-07-11 20:42:43 | optimal | 3 | 134027 | 101 | 31.940 | 4196.2 |
| 306 | 2024-07-11 05:31:17 | optimal | 3 | 134027 | 101 | 21.863 | 6130.3 |
| 305 | 2024-07-11 05:08:43 | optimal | 3 | 134027 | 101 | 18.376 | 7293.6 |
| 304 | 2024-07-11 05:08:18 | optimal | 3 | 134027 | 101 | 28.843 | 4646.8 |
| 303 | 2024-07-07 02:11:13 | optimal | 1 | 69583 | 3 | 2.343 | 29698.3 |
| 302 | 2024-07-07 01:50:10 | optimal | 1 | 69583 | 3 | 6.313 | 11022.2 |
| 301 | 2024-07-03 04:08:07 | optimal | 1 | 69583 | 3 | 2.280 | 30518.9 |
| 300 | 2024-06-29 16:44:11 | optimal | 1 | 69583 | 3 | 6.766 | 10284.2 |
| 299 | 2024-06-22 23:53:57 | optimal | 1 | 69583 | 3 | 3.406 | 20429.5 |
| 298 | 2024-06-19 01:55:13 | optimal | 1 | 69583 | 3 | 4.373 | 15912.0 |
| 297 | 2024-06-18 02:08:54 | optimal | 1 | 69583 | 3 | 5.350 | 13006.2 |
| 296 | 2024-06-13 05:04:14 | optimal | 1 | 69583 | 3 | 3.750 | 18555.5 |
| 295 | 2024-06-11 02:15:23 | optimal | 3 | 134027 | 101 | 37.300 | 3593.2 |
| 294 | 2024-06-07 06:40:26 | optimal | 3 | 134027 | 101 | 11.233 | 11931.5 |
| 293 | 2024-06-07 06:40:22 | optimal | 2 | 107671 | 10 | 6.873 | 15665.8 |
| 292 | 2024-06-07 02:27:59 | optimal | 3 | 134027 | 101 | 34.143 | 3925.5 |
| 291 | 2024-06-07 02:27:23 | optimal | 2 | 107671 | 10 | 19.063 | 5648.2 |
| 290 | 2024-06-07 02:13:49 | optimal | 1 | 69583 | 3 | 1.906 | 36507.3 |
| 289 | 2024-06-06 02:33:45 | optimal | 1 | 69583 | 3 | 6.593 | 10554.1 |
| 288 | 2024-05-05 00:30:25 | optimal | 3 | 134027 | 101 | 23.500 | 5703.3 |
| 287 | 2024-05-04 16:53:59 | optimal | 3 | 134027 | 101 | 14.876 | 9009.6 |
| 286 | 2024-05-04 12:17:04 | optimal | 2 | 107671 | 10 | 3.560 | 30244.7 |
| 285 | 2024-05-04 12:16:31 | optimal | 3 | 134027 | 101 | 7.186 | 18651.1 |
| 284 | 2024-05-03 20:09:56 | optimal | 2 | 107671 | 10 | 3.186 | 33795.0 |