History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stanch"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 591 | 2025-10-07 09:25:58 | stanch | 2 | 82551 | 43 | 2.263 | 36478.6 |
| 590 | 2025-09-04 02:52:46 | stanch | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 589 | 2025-08-28 03:55:13 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 588 | 2025-08-27 04:47:28 | stanch | 1 | 48755 | 5 | 1.000 | 48755.0 |
| 587 | 2025-08-27 02:01:28 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 586 | 2025-08-25 09:50:34 | stanch | 1 | 48755 | 5 | 4.046 | 12050.2 |
| 585 | 2025-08-19 12:00:06 | stanch | 1 | 48755 | 5 | 4.796 | 10165.8 |
| 584 | 2025-08-11 06:16:11 | stanch | 2 | 82551 | 43 | 6.466 | 12766.9 |
| 583 | 2025-08-10 19:34:45 | stanch | 1 | 48755 | 5 | 2.703 | 18037.4 |
| 582 | 2025-08-09 18:55:48 | stanch | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 581 | 2025-08-05 22:19:13 | stanch | 2 | 82551 | 43 | 10.156 | 8128.3 |
| 580 | 2025-08-04 11:15:40 | stanch | 1 | 48755 | 5 | 3.796 | 12843.8 |
| 579 | 2025-08-04 09:58:20 | stanch | 3 | 112716 | 450 | 19.956 | 5648.2 |
| 578 | 2025-08-01 12:56:44 | stanch | 3 | 112716 | 450 | 19.626 | 5743.2 |
| 577 | 2025-07-31 11:35:42 | stanch | 1 | 48755 | 5 | 1.673 | 29142.3 |
| 576 | 2025-07-31 08:59:15 | stanch | 3 | 112716 | 450 | 28.203 | 3996.6 |
| 575 | 2025-07-29 22:05:01 | stanch | 3 | 112716 | 450 | 18.233 | 6182.0 |
| 574 | 2025-07-29 17:27:19 | stanch | 1 | 48755 | 5 | 2.140 | 22782.7 |
| 573 | 2025-07-28 20:20:05 | stanch | 3 | 112716 | 450 | 14.203 | 7936.1 |
| 572 | 2025-07-27 08:26:18 | stanch | 1 | 48755 | 5 | 2.016 | 24184.0 |
| 571 | 2025-07-24 15:07:30 | stanch | 1 | 48755 | 5 | 4.030 | 12098.0 |
| 570 | 2025-07-24 01:07:17 | stanch | 3 | 112716 | 450 | 17.440 | 6463.1 |
| 569 | 2025-07-23 19:01:06 | stanch | 3 | 112716 | 450 | 24.533 | 4594.5 |
| 568 | 2025-07-23 03:33:31 | stanch | 1 | 48755 | 5 | 2.076 | 23485.1 |
| 567 | 2025-07-22 09:59:01 | stanch | 1 | 48755 | 5 | 2.406 | 20263.9 |
| 566 | 2025-07-21 23:41:04 | stanch | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 565 | 2025-07-19 14:38:42 | stanch | 3 | 112716 | 450 | 5.440 | 20719.9 |
| 564 | 2025-07-11 05:05:26 | stanch | 2 | 82551 | 43 | 18.846 | 4380.3 |
| 563 | 2025-07-08 17:39:15 | stanch | 1 | 48755 | 5 | 0.793 | 61481.7 |
| 562 | 2025-06-29 17:41:58 | stanch | 1 | 48755 | 5 | 2.076 | 23485.1 |
| 561 | 2025-06-27 07:18:06 | stanch | 1 | 48755 | 5 | 4.013 | 12149.3 |
| 560 | 2025-06-27 00:23:58 | stanch | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 559 | 2025-06-26 00:29:31 | stanch | 1 | 48755 | 5 | 6.360 | 7665.9 |
| 558 | 2025-06-25 00:34:03 | stanch | 1 | 48755 | 5 | 1.640 | 29728.7 |
| 557 | 2025-06-23 00:17:28 | stanch | 1 | 48755 | 5 | 1.406 | 34676.4 |
| 556 | 2025-06-20 01:18:05 | stanch | 3 | 112716 | 450 | 23.403 | 4816.3 |
| 555 | 2025-06-18 09:40:02 | stanch | 3 | 112716 | 450 | 22.123 | 5095.0 |
| 554 | 2025-06-16 10:48:06 | stanch | 1 | 48755 | 5 | 4.186 | 11647.2 |
| 553 | 2025-06-16 04:56:57 | stanch | 1 | 48755 | 5 | 3.920 | 12437.5 |
| 552 | 2025-06-15 20:25:30 | stanch | 3 | 112716 | 450 | 17.423 | 6469.4 |
| 551 | 2025-06-14 21:25:13 | stanch | 3 | 112716 | 450 | 29.376 | 3837.0 |
| 550 | 2025-06-13 02:35:01 | stanch | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 549 | 2025-06-09 13:15:54 | stanch | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 548 | 2025-06-01 11:55:51 | stanch | 3 | 112716 | 450 | 27.800 | 4054.5 |
| 547 | 2025-05-31 12:18:01 | stanch | 3 | 112716 | 450 | 16.330 | 6902.4 |
| 546 | 2025-05-30 20:07:08 | stanch | 3 | 112716 | 450 | 26.046 | 4327.6 |
| 545 | 2025-05-30 16:49:49 | stanch | 1 | 48755 | 5 | 4.110 | 11862.5 |
| 544 | 2025-05-29 16:32:54 | stanch | 1 | 48755 | 5 | 6.530 | 7466.3 |
| 543 | 2025-05-27 19:30:12 | stanch | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 542 | 2025-05-23 20:26:58 | stanch | 1 | 48755 | 5 | 0.986 | 49447.3 |
| 541 | 2025-05-19 19:30:42 | stanch | 1 | 48755 | 5 | 5.470 | 8913.2 |
| 540 | 2025-05-18 10:07:29 | stanch | 3 | 112716 | 450 | 23.830 | 4730.0 |
| 539 | 2025-05-18 01:17:01 | stanch | 3 | 112716 | 450 | 17.190 | 6557.1 |
| 538 | 2025-05-16 12:15:59 | stanch | 1 | 48755 | 5 | 4.983 | 9784.3 |
| 537 | 2025-05-15 19:49:51 | stanch | 3 | 112716 | 450 | 17.300 | 6515.4 |
| 536 | 2025-05-14 15:15:05 | stanch | 3 | 112716 | 450 | 34.390 | 3277.6 |
| 535 | 2025-05-14 10:42:28 | stanch | 1 | 48755 | 5 | 3.796 | 12843.8 |
| 534 | 2025-05-13 03:02:51 | stanch | 1 | 48755 | 5 | 1.500 | 32503.3 |
| 533 | 2025-05-12 05:42:04 | stanch | 2 | 82551 | 43 | 10.216 | 8080.6 |
| 532 | 2025-05-11 06:17:16 | stanch | 2 | 82551 | 43 | 13.123 | 6290.6 |
| 531 | 2025-05-09 09:07:14 | stanch | 2 | 82551 | 43 | 2.593 | 31836.1 |
| 530 | 2025-05-08 17:48:49 | stanch | 1 | 48755 | 5 | 2.626 | 18566.3 |
| 529 | 2025-04-28 16:35:39 | stanch | 1 | 48755 | 5 | 4.126 | 11816.5 |
| 528 | 2025-04-16 18:00:10 | stanch | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 527 | 2025-04-16 11:06:19 | stanch | 1 | 48755 | 5 | 4.876 | 9999.0 |
| 526 | 2025-04-15 14:36:28 | stanch | 2 | 82551 | 43 | 7.186 | 11487.8 |
| 525 | 2025-04-15 05:34:44 | stanch | 3 | 112716 | 450 | 33.440 | 3370.7 |
| 524 | 2025-04-14 14:56:37 | stanch | 2 | 82551 | 43 | 12.596 | 6553.7 |
| 523 | 2025-04-14 14:19:28 | stanch | 3 | 112716 | 450 | 22.390 | 5034.2 |
| 522 | 2025-04-14 05:06:08 | stanch | 1 | 48755 | 5 | 5.923 | 8231.5 |
| 521 | 2025-04-13 02:40:42 | stanch | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 520 | 2025-04-11 09:52:27 | stanch | 1 | 48755 | 5 | 2.283 | 21355.7 |
| 519 | 2025-04-09 05:34:39 | stanch | 2 | 82551 | 43 | 16.046 | 5144.6 |
| 518 | 2025-04-08 16:33:38 | stanch | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 517 | 2025-04-05 08:58:08 | stanch | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 516 | 2025-03-27 18:47:28 | stanch | 1 | 48755 | 5 | 2.330 | 20924.9 |
| 515 | 2025-03-22 23:25:54 | stanch | 2 | 82551 | 43 | 13.563 | 6086.5 |
| 514 | 2025-03-21 09:49:27 | stanch | 2 | 82551 | 43 | 10.453 | 7897.4 |
| 513 | 2025-03-20 09:21:48 | stanch | 3 | 112716 | 450 | 34.203 | 3295.5 |
| 512 | 2025-03-18 20:20:39 | stanch | 3 | 112716 | 450 | 5.406 | 20850.2 |
| 511 | 2025-03-17 08:51:35 | stanch | 3 | 112716 | 450 | 28.110 | 4009.8 |
| 510 | 2025-03-17 04:33:58 | stanch | 1 | 48755 | 5 | 2.890 | 16870.2 |
| 509 | 2025-03-16 16:03:15 | stanch | 3 | 112716 | 450 | 27.406 | 4112.8 |
| 508 | 2025-03-14 19:20:23 | stanch | 3 | 112716 | 450 | 27.660 | 4075.1 |
| 507 | 2025-03-14 16:30:02 | stanch | 1 | 48755 | 5 | 6.123 | 7962.6 |
| 506 | 2025-03-14 16:29:53 | stanch | 2 | 82551 | 43 | 13.686 | 6031.8 |
| 505 | 2025-03-14 16:29:53 | stanch | 3 | 112716 | 450 | 13.890 | 8114.9 |
| 504 | 2025-03-13 22:00:16 | stanch | 1 | 48755 | 5 | 3.750 | 13001.3 |
| 503 | 2025-03-09 10:18:46 | stanch | 1 | 48755 | 5 | 3.970 | 12280.9 |
| 502 | 2025-03-06 06:04:09 | stanch | 1 | 48755 | 5 | 3.780 | 12898.1 |
| 501 | 2025-02-26 15:32:03 | stanch | 1 | 48755 | 5 | 3.126 | 15596.6 |
| 500 | 2025-02-24 09:14:04 | stanch | 1 | 48755 | 5 | 2.483 | 19635.5 |
| 499 | 2025-02-07 13:51:39 | stanch | 1 | 48755 | 5 | 3.750 | 13001.3 |
| 498 | 2025-02-06 16:50:02 | stanch | 1 | 48755 | 5 | 3.203 | 15221.7 |
| 497 | 2025-01-26 17:33:54 | stanch | 2 | 82551 | 43 | 9.080 | 9091.5 |
| 496 | 2025-01-26 15:27:29 | stanch | 2 | 82551 | 43 | 16.110 | 5124.2 |
| 495 | 2025-01-26 14:23:56 | stanch | 2 | 82551 | 43 | 2.156 | 38289.0 |
| 494 | 2025-01-26 14:23:40 | stanch | 3 | 112716 | 450 | 5.783 | 19490.9 |
| 493 | 2025-01-26 13:28:21 | stanch | 3 | 112716 | 450 | 31.596 | 3567.4 |
| 492 | 2025-01-26 12:52:19 | stanch | 3 | 112716 | 450 | 44.456 | 2535.5 |