History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crispate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 638 | 2025-10-19 23:02:32 | crispate | 1 | 82945 | 3 | 2.343 | 35401.2 |
| 637 | 2025-10-01 05:43:29 | crispate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 636 | 2025-09-19 08:53:00 | crispate | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 635 | 2025-09-13 10:56:20 | crispate | 3 | 146162 | 81 | 8.376 | 17450.1 |
| 634 | 2025-09-09 15:57:03 | crispate | 3 | 146162 | 81 | 7.610 | 19206.6 |
| 633 | 2025-09-09 13:19:16 | crispate | 3 | 146162 | 81 | 6.610 | 22112.3 |
| 632 | 2025-09-09 12:34:52 | crispate | 3 | 146162 | 81 | 6.970 | 20970.2 |
| 631 | 2025-09-09 05:35:42 | crispate | 2 | 121059 | 8 | 3.533 | 34265.2 |
| 630 | 2025-09-09 02:02:56 | crispate | 2 | 121059 | 8 | 4.500 | 26902.0 |
| 629 | 2025-09-07 21:20:46 | crispate | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 628 | 2025-08-21 14:56:40 | crispate | 1 | 82945 | 3 | 4.250 | 19516.5 |
| 627 | 2025-08-10 16:48:09 | crispate | 1 | 82945 | 3 | 3.546 | 23391.1 |
| 626 | 2025-08-07 08:38:22 | crispate | 4 | 161609 | 751 | 35.203 | 4590.8 |
| 625 | 2025-08-01 08:06:51 | crispate | 1 | 82945 | 3 | 3.343 | 24811.5 |
| 624 | 2025-08-01 04:32:57 | crispate | 4 | 161609 | 751 | 55.220 | 2926.6 |
| 623 | 2025-07-31 21:02:35 | crispate | 4 | 161609 | 751 | 59.936 | 2696.4 |
| 622 | 2025-07-30 12:27:11 | crispate | 4 | 161609 | 751 | 29.860 | 5412.2 |
| 621 | 2025-07-30 00:56:28 | crispate | 4 | 161609 | 751 | 36.186 | 4466.1 |
| 620 | 2025-07-26 23:43:15 | crispate | 2 | 121059 | 8 | 13.406 | 9030.2 |
| 619 | 2025-07-23 10:52:34 | crispate | 1 | 82945 | 3 | 5.486 | 15119.4 |
| 618 | 2025-07-23 06:54:52 | crispate | 1 | 82945 | 3 | 7.093 | 11693.9 |
| 617 | 2025-07-22 22:53:33 | crispate | 4 | 161609 | 751 | 33.483 | 4826.6 |
| 616 | 2025-07-19 10:54:46 | crispate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 615 | 2025-07-18 23:57:43 | crispate | 3 | 146162 | 81 | 7.140 | 20470.9 |
| 614 | 2025-07-18 16:55:12 | crispate | 4 | 161609 | 751 | 75.410 | 2143.1 |
| 613 | 2025-07-16 18:14:35 | crispate | 2 | 121059 | 8 | 3.530 | 34294.3 |
| 612 | 2025-07-15 16:40:23 | crispate | 3 | 146162 | 81 | 7.656 | 19091.2 |
| 611 | 2025-07-15 15:05:46 | crispate | 2 | 121059 | 8 | 3.983 | 30393.9 |
| 610 | 2025-07-13 14:16:40 | crispate | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 609 | 2025-07-11 21:30:28 | crispate | 3 | 146162 | 81 | 25.940 | 5634.6 |
| 608 | 2025-07-09 06:43:50 | crispate | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 607 | 2025-07-07 08:37:49 | crispate | 3 | 146162 | 81 | 19.843 | 7365.9 |
| 606 | 2025-07-04 06:02:45 | crispate | 1 | 82945 | 3 | 10.780 | 7694.3 |
| 605 | 2025-07-01 01:34:18 | crispate | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 604 | 2025-06-30 21:30:56 | crispate | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 603 | 2025-06-25 15:29:11 | crispate | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 602 | 2025-06-24 16:14:33 | crispate | 1 | 82945 | 3 | 6.826 | 12151.3 |
| 601 | 2025-06-14 20:26:25 | crispate | 3 | 146162 | 81 | 37.190 | 3930.1 |
| 600 | 2025-06-14 07:37:06 | crispate | 3 | 146162 | 81 | 19.350 | 7553.6 |
| 599 | 2025-06-12 11:29:29 | crispate | 2 | 121059 | 8 | 20.390 | 5937.2 |
| 598 | 2025-06-12 11:17:55 | crispate | 3 | 146162 | 81 | 42.283 | 3456.8 |
| 597 | 2025-06-12 01:18:09 | crispate | 1 | 82945 | 3 | 3.373 | 24590.9 |
| 596 | 2025-06-11 14:03:45 | crispate | 1 | 82945 | 3 | 2.500 | 33178.0 |
| 595 | 2025-06-11 04:12:33 | crispate | 3 | 146162 | 81 | 37.923 | 3854.2 |
| 594 | 2025-05-30 09:51:09 | crispate | 3 | 146162 | 81 | 48.846 | 2992.3 |
| 593 | 2025-05-27 18:59:19 | crispate | 2 | 121059 | 8 | 19.003 | 6370.5 |
| 592 | 2025-05-27 18:30:32 | crispate | 3 | 146162 | 81 | 7.266 | 20115.9 |
| 591 | 2025-05-25 17:38:40 | crispate | 1 | 82945 | 3 | 3.796 | 21850.6 |
| 590 | 2025-05-25 13:03:03 | crispate | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 589 | 2025-05-24 16:03:37 | crispate | 1 | 82945 | 3 | 8.580 | 9667.2 |
| 588 | 2025-05-20 01:41:23 | crispate | 2 | 121059 | 8 | 13.876 | 8724.3 |
| 587 | 2025-05-19 07:08:00 | crispate | 1 | 82945 | 3 | 1.610 | 51518.6 |
| 586 | 2025-05-19 05:42:27 | crispate | 4 | 161609 | 751 | 37.000 | 4367.8 |
| 585 | 2025-05-17 18:49:04 | crispate | 4 | 161609 | 751 | 13.983 | 11557.5 |
| 584 | 2025-05-16 06:27:45 | crispate | 4 | 161609 | 751 | 58.066 | 2783.2 |
| 583 | 2025-05-16 03:36:24 | crispate | 4 | 161609 | 751 | 49.220 | 3283.4 |
| 582 | 2025-05-15 04:11:59 | crispate | 4 | 161609 | 751 | 51.643 | 3129.3 |
| 581 | 2025-05-14 22:04:32 | crispate | 4 | 161609 | 751 | 42.470 | 3805.3 |
| 580 | 2025-05-14 16:18:20 | crispate | 4 | 161609 | 751 | 54.066 | 2989.1 |
| 579 | 2025-05-14 14:55:47 | crispate | 4 | 161609 | 751 | 64.436 | 2508.1 |
| 578 | 2025-05-12 04:44:45 | crispate | 4 | 161609 | 751 | 66.840 | 2417.8 |
| 577 | 2025-05-11 21:30:20 | crispate | 4 | 161609 | 751 | 49.143 | 3288.5 |
| 576 | 2025-05-10 01:47:51 | crispate | 1 | 82945 | 3 | 9.000 | 9216.1 |
| 575 | 2025-05-06 21:58:57 | crispate | 3 | 146162 | 81 | 7.003 | 20871.3 |
| 574 | 2025-04-27 19:46:52 | crispate | 3 | 146162 | 81 | 7.170 | 20385.2 |
| 573 | 2025-04-26 04:42:42 | crispate | 3 | 146162 | 81 | 55.440 | 2636.4 |
| 572 | 2025-04-23 17:10:38 | crispate | 1 | 82945 | 3 | 6.970 | 11900.3 |
| 571 | 2025-04-23 15:27:06 | crispate | 1 | 82945 | 3 | 6.686 | 12405.8 |
| 570 | 2025-04-17 16:02:38 | crispate | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 569 | 2025-04-17 13:05:27 | crispate | 3 | 146162 | 81 | 13.486 | 10838.1 |
| 568 | 2025-04-16 06:12:14 | crispate | 3 | 146162 | 81 | 32.190 | 4540.6 |
| 567 | 2025-04-15 09:38:05 | crispate | 3 | 146162 | 81 | 22.096 | 6614.9 |
| 566 | 2025-04-14 22:10:00 | crispate | 4 | 161609 | 751 | 60.673 | 2663.6 |
| 565 | 2025-04-14 15:41:24 | crispate | 4 | 161609 | 751 | 46.050 | 3509.4 |
| 564 | 2025-04-14 06:23:26 | crispate | 4 | 161609 | 751 | 55.236 | 2925.8 |
| 563 | 2025-04-14 04:58:19 | crispate | 4 | 161609 | 751 | 37.830 | 4272.0 |
| 562 | 2025-04-12 15:07:28 | crispate | 4 | 161609 | 751 | 79.240 | 2039.5 |
| 561 | 2025-04-10 10:07:12 | crispate | 3 | 146162 | 81 | 8.626 | 16944.4 |
| 560 | 2025-04-09 01:38:40 | crispate | 3 | 146162 | 81 | 38.580 | 3788.5 |
| 559 | 2025-04-08 05:55:39 | crispate | 3 | 146162 | 81 | 44.080 | 3315.8 |
| 558 | 2025-04-07 01:36:19 | crispate | 3 | 146162 | 81 | 48.953 | 2985.8 |
| 557 | 2025-04-06 01:02:05 | crispate | 1 | 82945 | 3 | 6.873 | 12068.2 |
| 556 | 2025-04-02 13:48:11 | crispate | 1 | 82945 | 3 | 4.500 | 18432.2 |
| 555 | 2025-04-02 00:45:06 | crispate | 1 | 82945 | 3 | 7.453 | 11129.1 |
| 554 | 2025-03-19 16:19:26 | crispate | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 553 | 2025-03-18 20:28:10 | crispate | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 552 | 2025-03-17 21:32:34 | crispate | 3 | 146162 | 81 | 33.440 | 4370.9 |
| 551 | 2025-03-12 21:43:28 | crispate | 3 | 146162 | 81 | 34.956 | 4181.3 |
| 550 | 2025-03-12 16:35:50 | crispate | 1 | 82945 | 3 | 7.156 | 11591.0 |
| 549 | 2025-03-02 19:14:01 | crispate | 1 | 82945 | 3 | 7.673 | 10810.0 |
| 548 | 2025-03-02 07:01:13 | crispate | 4 | 161609 | 751 | 80.626 | 2004.4 |
| 547 | 2025-03-02 02:02:30 | crispate | 3 | 146162 | 81 | 28.736 | 5086.4 |
| 546 | 2025-03-01 18:21:02 | crispate | 1 | 82945 | 3 | 10.343 | 8019.4 |
| 545 | 2025-03-01 17:20:30 | crispate | 3 | 146162 | 81 | 36.596 | 3993.9 |
| 544 | 2025-03-01 16:09:37 | crispate | 4 | 161609 | 751 | 63.033 | 2563.9 |
| 543 | 2025-03-01 16:09:36 | crispate | 3 | 146162 | 81 | 42.720 | 3421.4 |
| 542 | 2025-03-01 16:09:34 | crispate | 2 | 121059 | 8 | 10.016 | 12086.6 |
| 541 | 2025-03-01 16:09:17 | crispate | 1 | 82945 | 3 | 3.626 | 22875.1 |
| 540 | 2025-02-27 01:49:36 | crispate | 3 | 146162 | 81 | 24.266 | 6023.3 |
| 539 | 2025-02-24 06:50:46 | crispate | 3 | 146162 | 81 | 36.143 | 4044.0 |