History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"picaros"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 458 | 2025-10-24 19:48:40 | picaros | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 457 | 2025-10-18 05:14:39 | picaros | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 456 | 2025-10-17 20:01:14 | picaros | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 455 | 2025-09-18 22:17:40 | picaros | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 454 | 2025-09-06 10:35:08 | picaros | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 453 | 2025-08-28 12:00:30 | picaros | 1 | 69583 | 3 | 2.280 | 30518.9 |
| 452 | 2025-08-27 12:18:41 | picaros | 1 | 69583 | 3 | 1.716 | 40549.5 |
| 451 | 2025-08-16 21:54:48 | picaros | 1 | 69583 | 3 | 2.153 | 32319.1 |
| 450 | 2025-08-12 03:57:01 | picaros | 1 | 69583 | 3 | 3.593 | 19366.3 |
| 449 | 2025-08-10 10:22:17 | picaros | 1 | 69583 | 3 | 3.173 | 21929.7 |
| 448 | 2025-08-04 15:39:13 | picaros | 2 | 107671 | 17 | 3.470 | 31029.1 |
| 447 | 2025-08-01 22:09:30 | picaros | 1 | 69583 | 3 | 6.220 | 11187.0 |
| 446 | 2025-07-31 01:52:13 | picaros | 1 | 69583 | 3 | 2.810 | 24762.6 |
| 445 | 2025-07-27 15:24:32 | picaros | 1 | 69583 | 3 | 4.063 | 17126.0 |
| 444 | 2025-07-27 01:03:19 | picaros | 1 | 69583 | 3 | 5.576 | 12479.0 |
| 443 | 2025-07-26 22:03:53 | picaros | 1 | 69583 | 3 | 6.970 | 9983.2 |
| 442 | 2025-07-25 09:43:09 | picaros | 1 | 69583 | 3 | 2.660 | 26159.0 |
| 441 | 2025-07-20 23:06:57 | picaros | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 440 | 2025-07-19 03:13:18 | picaros | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 439 | 2025-07-10 17:51:00 | picaros | 1 | 69583 | 3 | 8.110 | 8579.9 |
| 438 | 2025-06-23 14:23:22 | picaros | 1 | 69583 | 3 | 6.016 | 11566.3 |
| 437 | 2025-06-22 12:57:48 | picaros | 1 | 69583 | 3 | 5.970 | 11655.4 |
| 436 | 2025-06-18 21:12:47 | picaros | 2 | 107671 | 17 | 16.953 | 6351.1 |
| 435 | 2025-06-16 21:11:17 | picaros | 2 | 107671 | 17 | 8.080 | 13325.6 |
| 434 | 2025-06-14 02:27:44 | picaros | 1 | 69583 | 3 | 2.983 | 23326.5 |
| 433 | 2025-06-12 08:31:56 | picaros | 1 | 69583 | 3 | 5.936 | 11722.2 |
| 432 | 2025-06-11 21:32:43 | picaros | 1 | 69583 | 3 | 6.156 | 11303.3 |
| 431 | 2025-06-10 09:37:48 | picaros | 1 | 69583 | 3 | 3.033 | 22942.0 |
| 430 | 2025-05-30 08:44:13 | picaros | 1 | 69583 | 3 | 3.640 | 19116.2 |
| 429 | 2025-05-26 00:16:26 | picaros | 1 | 69583 | 3 | 8.533 | 8154.6 |
| 428 | 2025-05-24 00:47:15 | picaros | 1 | 69583 | 3 | 2.966 | 23460.2 |
| 427 | 2025-05-20 14:41:00 | picaros | 1 | 69583 | 3 | 5.826 | 11943.5 |
| 426 | 2025-05-17 11:12:39 | picaros | 2 | 107671 | 17 | 2.840 | 37912.3 |
| 425 | 2025-05-11 21:26:07 | picaros | 1 | 69583 | 3 | 3.326 | 20920.9 |
| 424 | 2025-05-08 10:03:39 | picaros | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 423 | 2025-05-05 02:22:53 | picaros | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 422 | 2025-05-01 21:22:02 | picaros | 1 | 69583 | 3 | 7.000 | 9940.4 |
| 421 | 2025-04-30 12:37:46 | picaros | 1 | 69583 | 3 | 2.890 | 24077.2 |
| 420 | 2025-04-22 23:02:13 | picaros | 1 | 69583 | 3 | 5.940 | 11714.3 |
| 419 | 2025-04-16 16:15:38 | picaros | 1 | 69583 | 3 | 3.313 | 21003.0 |
| 418 | 2025-04-15 04:27:09 | picaros | 1 | 69583 | 3 | 6.203 | 11217.6 |
| 417 | 2025-04-10 21:10:46 | picaros | 1 | 69583 | 3 | 6.936 | 10032.2 |
| 416 | 2025-04-07 18:55:47 | picaros | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 415 | 2025-04-01 21:06:13 | picaros | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 414 | 2025-03-25 03:56:53 | picaros | 1 | 69583 | 3 | 6.376 | 10913.3 |
| 413 | 2025-03-23 14:47:55 | picaros | 1 | 69583 | 3 | 7.656 | 9088.7 |
| 412 | 2025-03-18 11:43:21 | picaros | 1 | 69583 | 3 | 5.343 | 13023.2 |
| 411 | 2025-03-10 23:41:12 | picaros | 1 | 69583 | 3 | 5.393 | 12902.5 |
| 410 | 2025-03-05 01:07:07 | picaros | 1 | 69583 | 3 | 3.060 | 22739.5 |
| 409 | 2025-03-03 07:31:31 | picaros | 2 | 107671 | 17 | 18.030 | 5971.8 |
| 408 | 2025-03-01 19:08:34 | picaros | 2 | 107671 | 17 | 8.640 | 12461.9 |
| 407 | 2025-02-27 10:50:13 | picaros | 2 | 107671 | 17 | 16.483 | 6532.2 |
| 406 | 2025-02-27 08:22:12 | picaros | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 405 | 2025-02-26 08:49:55 | picaros | 2 | 107671 | 17 | 19.703 | 5464.7 |
| 404 | 2025-02-16 02:23:29 | picaros | 1 | 69583 | 3 | 4.013 | 17339.4 |
| 403 | 2025-02-07 11:06:25 | picaros | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 402 | 2025-01-28 08:54:28 | picaros | 3 | 134027 | 236 | 46.440 | 2886.0 |
| 401 | 2025-01-28 06:37:53 | picaros | 3 | 134027 | 236 | 28.940 | 4631.2 |
| 400 | 2025-01-28 06:05:33 | picaros | 3 | 134027 | 236 | 26.346 | 5087.2 |
| 399 | 2025-01-28 06:05:09 | picaros | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 398 | 2025-01-21 00:05:30 | picaros | 2 | 107671 | 17 | 7.983 | 13487.5 |
| 397 | 2025-01-16 04:17:50 | picaros | 2 | 107671 | 17 | 16.813 | 6404.0 |
| 396 | 2025-01-10 19:29:47 | picaros | 1 | 69583 | 3 | 3.060 | 22739.5 |
| 395 | 2025-01-05 16:21:18 | picaros | 1 | 69583 | 3 | 6.513 | 10683.7 |
| 394 | 2024-12-27 10:11:49 | picaros | 3 | 134027 | 236 | 34.766 | 3855.1 |
| 393 | 2024-12-27 10:02:21 | picaros | 3 | 134027 | 236 | 34.456 | 3889.8 |
| 392 | 2024-12-27 08:18:37 | picaros | 3 | 134027 | 236 | 33.440 | 4008.0 |
| 391 | 2024-12-26 10:13:53 | picaros | 3 | 134027 | 236 | 31.580 | 4244.0 |
| 390 | 2024-12-26 07:51:24 | picaros | 3 | 134027 | 236 | 22.410 | 5980.7 |
| 389 | 2024-12-26 06:06:26 | picaros | 3 | 134027 | 236 | 6.250 | 21444.3 |
| 388 | 2024-12-10 19:37:39 | picaros | 1 | 69583 | 3 | 3.983 | 17470.0 |
| 387 | 2024-12-06 06:26:27 | picaros | 1 | 69583 | 3 | 6.483 | 10733.1 |
| 386 | 2024-12-04 15:17:22 | picaros | 1 | 69583 | 3 | 5.610 | 12403.4 |
| 385 | 2024-11-11 19:29:54 | picaros | 2 | 107671 | 17 | 17.186 | 6265.0 |
| 384 | 2024-11-11 16:25:51 | picaros | 3 | 134027 | 236 | 35.533 | 3771.9 |
| 383 | 2024-11-10 22:45:52 | picaros | 3 | 134027 | 236 | 30.910 | 4336.0 |
| 382 | 2024-11-10 22:45:53 | picaros | 2 | 107671 | 17 | 15.780 | 6823.3 |
| 381 | 2024-11-10 13:34:09 | picaros | 1 | 69583 | 3 | 2.670 | 26061.0 |
| 380 | 2024-11-03 17:27:06 | picaros | 1 | 69583 | 3 | 8.453 | 8231.8 |
| 379 | 2024-10-10 11:45:05 | picaros | 1 | 69583 | 3 | 3.186 | 21840.2 |
| 378 | 2024-10-07 08:00:57 | picaros | 3 | 134027 | 236 | 57.203 | 2343.0 |
| 377 | 2024-10-05 14:44:43 | picaros | 3 | 134027 | 236 | 48.963 | 2737.3 |
| 376 | 2024-10-05 08:04:04 | picaros | 3 | 134027 | 236 | 51.500 | 2602.5 |
| 375 | 2024-10-04 17:52:11 | picaros | 3 | 134027 | 236 | 77.410 | 1731.4 |
| 374 | 2024-10-04 17:52:07 | picaros | 2 | 107671 | 17 | 29.283 | 3676.9 |
| 373 | 2024-10-04 17:50:06 | picaros | 1 | 69583 | 3 | 4.593 | 15149.8 |
| 372 | 2024-09-10 08:33:41 | picaros | 1 | 69583 | 3 | 11.920 | 5837.5 |
| 371 | 2024-09-07 04:21:37 | picaros | 1 | 69583 | 3 | 7.626 | 9124.4 |
| 370 | 2024-08-31 08:59:56 | picaros | 1 | 69583 | 3 | 6.813 | 10213.3 |
| 369 | 2024-08-13 06:59:43 | picaros | 1 | 69583 | 3 | 12.266 | 5672.8 |
| 368 | 2024-08-11 16:31:05 | picaros | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 367 | 2024-08-10 18:38:33 | picaros | 1 | 69583 | 3 | 4.033 | 17253.4 |
| 366 | 2024-08-02 19:42:19 | picaros | 1 | 69583 | 3 | 3.580 | 19436.6 |
| 365 | 2024-08-02 07:06:26 | picaros | 1 | 69583 | 3 | 3.093 | 22496.9 |
| 364 | 2024-07-31 22:30:47 | picaros | 1 | 69583 | 3 | 4.750 | 14649.1 |
| 363 | 2024-07-24 02:29:33 | picaros | 3 | 134027 | 236 | 24.376 | 5498.3 |
| 362 | 2024-07-24 02:22:28 | picaros | 3 | 134027 | 236 | 25.846 | 5185.6 |
| 361 | 2024-07-21 21:51:01 | picaros | 3 | 134027 | 236 | 26.046 | 5145.8 |
| 360 | 2024-07-20 19:15:26 | picaros | 3 | 134027 | 236 | 12.423 | 10788.6 |
| 359 | 2024-07-20 17:11:05 | picaros | 3 | 134027 | 236 | 20.923 | 6405.7 |