History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smearer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 534 | 2025-10-12 12:31:31 | smearer | 1 | 69583 | 8 | 1.126 | 61796.6 |
| 533 | 2025-09-14 07:55:06 | smearer | 3 | 134027 | 475 | 6.780 | 19768.0 |
| 532 | 2025-09-07 19:30:49 | smearer | 1 | 69583 | 8 | 2.483 | 28023.8 |
| 531 | 2025-08-27 09:05:55 | smearer | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 530 | 2025-08-27 04:17:52 | smearer | 1 | 69583 | 8 | 5.046 | 13789.7 |
| 529 | 2025-08-02 10:53:02 | smearer | 1 | 69583 | 8 | 1.643 | 42351.2 |
| 528 | 2025-08-02 10:24:42 | smearer | 2 | 107671 | 53 | 6.453 | 16685.4 |
| 527 | 2025-08-01 02:46:28 | smearer | 1 | 69583 | 8 | 7.143 | 9741.4 |
| 526 | 2025-07-31 14:58:01 | smearer | 1 | 69583 | 8 | 2.826 | 24622.4 |
| 525 | 2025-07-29 11:35:24 | smearer | 3 | 134027 | 475 | 17.520 | 7649.9 |
| 524 | 2025-07-29 02:35:41 | smearer | 3 | 134027 | 475 | 22.890 | 5855.3 |
| 523 | 2025-07-27 02:03:16 | smearer | 1 | 69583 | 8 | 3.453 | 20151.5 |
| 522 | 2025-07-26 23:02:02 | smearer | 2 | 107671 | 53 | 12.846 | 8381.7 |
| 521 | 2025-07-26 19:53:07 | smearer | 1 | 69583 | 8 | 3.766 | 18476.6 |
| 520 | 2025-07-26 01:58:19 | smearer | 3 | 134027 | 475 | 6.596 | 20319.4 |
| 519 | 2025-07-24 22:26:36 | smearer | 1 | 69583 | 8 | 3.236 | 21502.8 |
| 518 | 2025-07-24 04:41:40 | smearer | 1 | 69583 | 8 | 3.016 | 23071.3 |
| 517 | 2025-07-23 17:49:33 | smearer | 1 | 69583 | 8 | 3.470 | 20052.7 |
| 516 | 2025-07-21 15:37:08 | smearer | 3 | 134027 | 475 | 7.500 | 17870.3 |
| 515 | 2025-07-21 10:51:31 | smearer | 2 | 107671 | 53 | 5.783 | 18618.5 |
| 514 | 2025-07-20 10:33:20 | smearer | 3 | 134027 | 475 | 6.483 | 20673.6 |
| 513 | 2025-07-18 08:08:53 | smearer | 3 | 134027 | 475 | 33.376 | 4015.7 |
| 512 | 2025-07-17 17:37:56 | smearer | 3 | 134027 | 475 | 34.923 | 3837.8 |
| 511 | 2025-07-16 07:54:41 | smearer | 1 | 69583 | 8 | 1.326 | 52475.9 |
| 510 | 2025-07-15 11:27:30 | smearer | 2 | 107671 | 53 | 15.143 | 7110.3 |
| 509 | 2025-07-15 11:01:13 | smearer | 3 | 134027 | 475 | 29.940 | 4476.5 |
| 508 | 2025-07-15 10:50:10 | smearer | 3 | 134027 | 475 | 23.596 | 5680.1 |
| 507 | 2025-07-12 03:38:18 | smearer | 3 | 134027 | 475 | 6.126 | 21878.4 |
| 506 | 2025-07-07 15:15:26 | smearer | 2 | 107671 | 53 | 17.800 | 6048.9 |
| 505 | 2025-07-06 16:32:33 | smearer | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 504 | 2025-07-05 16:45:50 | smearer | 2 | 107671 | 53 | 19.173 | 5615.8 |
| 503 | 2025-07-02 10:40:44 | smearer | 1 | 69583 | 8 | 3.826 | 18186.9 |
| 502 | 2025-07-02 02:10:42 | smearer | 1 | 69583 | 8 | 3.546 | 19623.0 |
| 501 | 2025-06-29 19:20:56 | smearer | 1 | 69583 | 8 | 5.906 | 11781.7 |
| 500 | 2025-06-29 16:08:25 | smearer | 2 | 107671 | 53 | 3.140 | 34290.1 |
| 499 | 2025-06-23 16:51:07 | smearer | 1 | 69583 | 8 | 1.093 | 63662.4 |
| 498 | 2025-06-23 05:34:04 | smearer | 2 | 107671 | 53 | 16.673 | 6457.8 |
| 497 | 2025-06-23 03:13:44 | smearer | 2 | 107671 | 53 | 7.126 | 15109.6 |
| 496 | 2025-06-21 23:07:31 | smearer | 1 | 69583 | 8 | 5.593 | 12441.1 |
| 495 | 2025-06-21 08:39:21 | smearer | 2 | 107671 | 53 | 17.173 | 6269.8 |
| 494 | 2025-06-19 13:08:07 | smearer | 2 | 107671 | 53 | 13.360 | 8059.2 |
| 493 | 2025-06-18 13:51:15 | smearer | 2 | 107671 | 53 | 16.270 | 6617.8 |
| 492 | 2025-06-16 09:35:31 | smearer | 1 | 69583 | 8 | 5.110 | 13617.0 |
| 491 | 2025-06-16 02:48:01 | smearer | 1 | 69583 | 8 | 6.423 | 10833.4 |
| 490 | 2025-06-15 09:48:38 | smearer | 1 | 69583 | 8 | 1.076 | 64668.2 |
| 489 | 2025-06-15 05:58:34 | smearer | 3 | 134027 | 475 | 20.813 | 6439.6 |
| 488 | 2025-06-14 11:12:21 | smearer | 1 | 69583 | 8 | 5.313 | 13096.7 |
| 487 | 2025-06-12 23:14:49 | smearer | 3 | 134027 | 475 | 7.550 | 17751.9 |
| 486 | 2025-06-12 22:04:27 | smearer | 3 | 134027 | 475 | 16.376 | 8184.4 |
| 485 | 2025-06-12 10:42:49 | smearer | 3 | 134027 | 475 | 37.843 | 3541.7 |
| 484 | 2025-06-11 03:26:26 | smearer | 3 | 134027 | 475 | 17.280 | 7756.2 |
| 483 | 2025-06-10 08:39:18 | smearer | 1 | 69583 | 8 | 5.156 | 13495.5 |
| 482 | 2025-06-04 22:32:45 | smearer | 1 | 69583 | 8 | 5.406 | 12871.4 |
| 481 | 2025-06-02 09:45:17 | smearer | 1 | 69583 | 8 | 6.263 | 11110.2 |
| 480 | 2025-05-31 18:11:14 | smearer | 1 | 69583 | 8 | 3.093 | 22496.9 |
| 479 | 2025-05-30 05:21:06 | smearer | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 478 | 2025-05-25 04:14:03 | smearer | 2 | 107671 | 53 | 3.643 | 29555.6 |
| 477 | 2025-05-25 02:09:55 | smearer | 3 | 134027 | 475 | 33.590 | 3990.1 |
| 476 | 2025-05-23 17:01:00 | smearer | 1 | 69583 | 8 | 3.673 | 18944.5 |
| 475 | 2025-05-21 22:52:51 | smearer | 1 | 69583 | 8 | 3.800 | 18311.3 |
| 474 | 2025-05-21 03:21:50 | smearer | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 473 | 2025-05-20 05:17:09 | smearer | 1 | 69583 | 8 | 4.390 | 15850.3 |
| 472 | 2025-05-16 09:54:18 | smearer | 1 | 69583 | 8 | 3.123 | 22280.8 |
| 471 | 2025-05-12 23:56:16 | smearer | 1 | 69583 | 8 | 1.250 | 55666.4 |
| 470 | 2025-05-12 06:35:56 | smearer | 3 | 134027 | 475 | 41.150 | 3257.0 |
| 469 | 2025-05-11 11:01:39 | smearer | 3 | 134027 | 475 | 51.520 | 2601.5 |
| 468 | 2025-05-11 06:13:20 | smearer | 3 | 134027 | 475 | 42.783 | 3132.7 |
| 467 | 2025-05-11 01:48:08 | smearer | 3 | 134027 | 475 | 31.953 | 4194.5 |
| 466 | 2025-05-09 16:47:56 | smearer | 3 | 134027 | 475 | 7.126 | 18808.2 |
| 465 | 2025-04-30 09:19:08 | smearer | 1 | 69583 | 8 | 6.093 | 11420.2 |
| 464 | 2025-04-22 07:29:05 | smearer | 3 | 134027 | 475 | 36.703 | 3651.7 |
| 463 | 2025-04-21 22:46:16 | smearer | 2 | 107671 | 53 | 3.376 | 31893.1 |
| 462 | 2025-04-21 17:23:16 | smearer | 1 | 69583 | 8 | 8.280 | 8403.7 |
| 461 | 2025-04-20 04:29:56 | smearer | 1 | 69583 | 8 | 3.436 | 20251.2 |
| 460 | 2025-04-19 21:12:53 | smearer | 1 | 69583 | 8 | 5.080 | 13697.4 |
| 459 | 2025-03-30 01:53:22 | smearer | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 458 | 2025-03-26 03:24:32 | smearer | 1 | 69583 | 8 | 5.780 | 12038.6 |
| 457 | 2025-03-19 21:57:11 | smearer | 1 | 69583 | 8 | 3.546 | 19623.0 |
| 456 | 2025-03-09 12:08:22 | smearer | 2 | 107671 | 53 | 16.156 | 6664.5 |
| 455 | 2025-03-07 23:27:31 | smearer | 1 | 69583 | 8 | 6.906 | 10075.7 |
| 454 | 2025-02-24 17:58:02 | smearer | 2 | 107671 | 53 | 16.156 | 6664.5 |
| 453 | 2025-02-24 17:57:51 | smearer | 1 | 69583 | 8 | 2.593 | 26834.9 |
| 452 | 2025-02-24 14:58:38 | smearer | 3 | 134027 | 475 | 18.063 | 7420.0 |
| 451 | 2025-02-24 12:18:14 | smearer | 3 | 134027 | 475 | 27.410 | 4889.7 |
| 450 | 2025-02-24 01:31:46 | smearer | 3 | 134027 | 475 | 31.313 | 4280.2 |
| 449 | 2025-02-24 01:31:44 | smearer | 2 | 107671 | 53 | 15.080 | 7140.0 |
| 448 | 2025-02-24 01:14:28 | smearer | 1 | 69583 | 8 | 4.876 | 14270.5 |
| 447 | 2025-02-10 16:06:53 | smearer | 1 | 69583 | 8 | 5.360 | 12981.9 |
| 446 | 2025-02-10 13:13:32 | smearer | 1 | 69583 | 8 | 3.940 | 17660.7 |
| 445 | 2025-01-19 12:06:47 | smearer | 1 | 69583 | 8 | 3.533 | 19695.2 |
| 444 | 2025-01-15 08:12:02 | smearer | 1 | 69583 | 8 | 3.090 | 22518.8 |
| 443 | 2025-01-07 21:18:53 | smearer | 1 | 69583 | 8 | 5.876 | 11841.9 |
| 442 | 2025-01-01 19:18:33 | smearer | 1 | 69583 | 8 | 8.436 | 8248.3 |
| 441 | 2024-12-17 18:10:47 | smearer | 3 | 134027 | 475 | 30.346 | 4416.6 |
| 440 | 2024-12-17 12:49:08 | smearer | 3 | 134027 | 475 | 29.000 | 4621.6 |
| 439 | 2024-12-16 16:59:51 | smearer | 3 | 134027 | 475 | 25.873 | 5180.2 |
| 438 | 2024-12-16 07:12:54 | smearer | 3 | 134027 | 475 | 24.563 | 5456.5 |
| 437 | 2024-12-16 07:12:41 | smearer | 2 | 107671 | 53 | 13.326 | 8079.8 |
| 436 | 2024-12-16 07:10:45 | smearer | 1 | 69583 | 8 | 3.783 | 18393.6 |
| 435 | 2024-12-08 05:12:32 | smearer | 1 | 69583 | 8 | 6.000 | 11597.2 |