History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rotten"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 650 | 2024-04-04 19:36:24 | rotten | 3 | 112716 | 788 | 6.736 | 16733.4 |
| 649 | 2024-04-04 05:44:42 | rotten | 3 | 112716 | 788 | 10.626 | 10607.6 |
| 648 | 2024-03-31 06:27:39 | rotten | 1 | 48755 | 7 | 1.860 | 26212.4 |
| 647 | 2024-03-31 06:07:35 | rotten | 3 | 112716 | 788 | 11.923 | 9453.7 |
| 646 | 2024-03-30 20:10:50 | rotten | 3 | 112716 | 788 | 12.096 | 9318.5 |
| 645 | 2024-03-30 02:24:14 | rotten | 3 | 112716 | 788 | 6.486 | 17378.4 |
| 644 | 2024-03-29 20:57:52 | rotten | 1 | 48755 | 7 | 0.906 | 53813.5 |
| 643 | 2024-03-07 00:51:31 | rotten | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 642 | 2024-03-02 04:20:32 | rotten | 3 | 112716 | 788 | 14.813 | 7609.3 |
| 641 | 2024-02-28 06:50:02 | rotten | 2 | 82551 | 81 | 5.843 | 14128.2 |
| 640 | 2024-02-28 06:49:23 | rotten | 3 | 112716 | 788 | 6.876 | 16392.7 |
| 639 | 2024-02-27 10:48:18 | rotten | 2 | 82551 | 81 | 2.376 | 34743.7 |
| 638 | 2024-02-27 10:47:51 | rotten | 3 | 112716 | 788 | 5.800 | 19433.8 |
| 637 | 2024-02-26 01:42:45 | rotten | 3 | 112716 | 788 | 7.750 | 14544.0 |
| 636 | 2024-02-26 01:42:46 | rotten | 2 | 82551 | 81 | 4.326 | 19082.5 |
| 635 | 2024-02-26 01:42:39 | rotten | 1 | 48755 | 7 | 1.906 | 25579.7 |
| 634 | 2024-01-26 23:12:33 | rotten | 1 | 48755 | 7 | 1.876 | 25988.8 |
| 633 | 2023-12-20 20:03:09 | rotten | 3 | 112716 | 788 | 5.076 | 22205.7 |
| 632 | 2023-12-20 20:03:08 | rotten | 2 | 82551 | 81 | 2.390 | 34540.2 |
| 631 | 2023-12-20 19:02:16 | rotten | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 630 | 2023-12-10 01:26:35 | rotten | 3 | 112716 | 788 | 5.673 | 19868.9 |
| 629 | 2023-12-10 01:26:36 | rotten | 2 | 82551 | 81 | 2.640 | 31269.3 |
| 628 | 2023-12-07 15:59:10 | rotten | 3 | 112716 | 788 | 5.200 | 21676.2 |
| 627 | 2023-12-07 15:59:04 | rotten | 3 | 112716 | 788 | 5.673 | 19868.9 |
| 626 | 2023-12-07 15:49:44 | rotten | 3 | 112716 | 788 | 13.016 | 8659.8 |
| 625 | 2023-12-04 19:43:24 | rotten | 3 | 112716 | 788 | 5.250 | 21469.7 |
| 624 | 2023-11-29 19:31:50 | rotten | 3 | 112716 | 788 | 5.156 | 21861.1 |
| 623 | 2023-11-29 19:31:52 | rotten | 2 | 82551 | 81 | 2.470 | 33421.5 |
| 622 | 2023-11-12 09:24:58 | rotten | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 621 | 2023-11-10 23:15:51 | rotten | 1 | 48755 | 7 | 0.810 | 60191.4 |
| 620 | 2023-11-02 17:18:32 | rotten | 3 | 112716 | 788 | 6.846 | 16464.5 |
| 619 | 2023-11-02 02:19:12 | rotten | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 618 | 2023-10-30 10:14:50 | rotten | 2 | 82551 | 81 | 2.530 | 32628.9 |
| 617 | 2023-10-28 19:15:39 | rotten | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 616 | 2023-10-27 16:22:02 | rotten | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 615 | 2023-10-20 18:05:08 | rotten | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 614 | 2023-10-19 22:57:56 | rotten | 2 | 82551 | 81 | 2.346 | 35188.0 |
| 613 | 2023-10-17 23:55:28 | rotten | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 612 | 2023-10-16 21:14:07 | rotten | 3 | 112716 | 788 | 6.656 | 16934.5 |
| 611 | 2023-10-15 17:58:48 | rotten | 3 | 112716 | 788 | 6.326 | 17817.9 |
| 610 | 2023-10-15 17:58:47 | rotten | 2 | 82551 | 81 | 2.923 | 28241.9 |
| 609 | 2023-10-10 22:52:31 | rotten | 1 | 48755 | 7 | 0.923 | 52822.3 |
| 608 | 2023-10-06 23:15:46 | rotten | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 607 | 2023-10-04 12:28:41 | rotten | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 606 | 2023-09-28 02:23:56 | rotten | 2 | 82551 | 81 | 5.343 | 15450.3 |
| 605 | 2023-09-23 09:18:43 | rotten | 1 | 48755 | 7 | 0.810 | 60191.4 |
| 604 | 2023-09-22 23:42:16 | rotten | 3 | 112716 | 788 | 8.516 | 13235.8 |
| 603 | 2023-09-20 17:50:52 | rotten | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 602 | 2023-09-17 05:32:14 | rotten | 3 | 112716 | 788 | 13.780 | 8179.7 |
| 601 | 2023-08-31 21:52:25 | rotten | 3 | 112716 | 788 | 6.156 | 18309.9 |
| 600 | 2023-08-02 13:35:14 | rotten | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 599 | 2023-07-26 10:22:46 | rotten | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 598 | 2023-07-13 18:53:35 | rotten | 3 | 112716 | 788 | 4.830 | 23336.6 |
| 597 | 2023-06-17 07:53:25 | rotten | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 596 | 2023-05-18 05:39:10 | rotten | 3 | 112716 | 788 | 4.860 | 23192.6 |
| 595 | 2023-05-16 13:50:51 | rotten | 3 | 112716 | 788 | 5.626 | 20034.8 |
| 594 | 2023-04-29 18:31:44 | rotten | 1 | 48755 | 7 | 0.856 | 56956.8 |
| 593 | 2023-04-29 04:13:27 | rotten | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 592 | 2023-02-22 04:09:09 | rotten | 3 | 112716 | 788 | 4.780 | 23580.8 |
| 591 | 2023-02-20 19:44:23 | rotten | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 590 | 2023-02-19 09:33:29 | rotten | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 589 | 2022-12-18 19:20:01 | rotten | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 588 | 2022-12-02 13:49:07 | rotten | 3 | 112716 | 788 | 5.530 | 20382.6 |
| 587 | 2022-10-11 12:16:51 | rotten | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 586 | 2022-09-02 13:10:12 | rotten | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 585 | 2022-09-02 10:02:44 | rotten | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 584 | 2022-08-31 19:47:04 | rotten | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 583 | 2022-05-30 21:56:25 | rotten | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 582 | 2022-04-17 18:58:03 | rotten | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 581 | 2022-04-17 10:21:14 | rotten | 3 | 112716 | 788 | 4.906 | 22975.1 |
| 580 | 2022-04-15 15:14:53 | rotten | 1 | 48755 | 7 | 0.970 | 50262.9 |
| 579 | 2022-03-31 09:02:38 | rotten | 1 | 48755 | 7 | 1.126 | 43299.3 |
| 578 | 2022-03-30 13:28:56 | rotten | 1 | 48755 | 7 | 0.983 | 49598.2 |
| 577 | 2022-03-29 16:21:34 | rotten | 1 | 48755 | 7 | 1.060 | 45995.3 |
| 576 | 2022-03-28 23:02:29 | rotten | 1 | 48755 | 7 | 1.030 | 47335.0 |
| 575 | 2022-03-27 15:33:04 | rotten | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 574 | 2022-03-26 23:22:50 | rotten | 1 | 48755 | 7 | 0.810 | 60191.4 |
| 573 | 2022-01-22 17:40:53 | rotten | 1 | 48755 | 7 | 0.923 | 52822.3 |
| 572 | 2022-01-21 20:20:46 | rotten | 1 | 48755 | 7 | 0.893 | 54596.9 |
| 571 | 2022-01-21 09:52:54 | rotten | 1 | 48755 | 7 | 1.060 | 45995.3 |
| 570 | 2022-01-20 22:35:19 | rotten | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 569 | 2022-01-20 13:54:29 | rotten | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 568 | 2022-01-20 03:07:29 | rotten | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 567 | 2022-01-19 18:07:46 | rotten | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 566 | 2022-01-19 08:27:31 | rotten | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 565 | 2022-01-18 18:09:31 | rotten | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 564 | 2022-01-18 02:21:20 | rotten | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 563 | 2022-01-07 03:19:34 | rotten | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 562 | 2021-12-17 10:08:11 | rotten | 1 | 48755 | 7 | 0.906 | 53813.5 |
| 561 | 2021-12-17 02:46:08 | rotten | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 560 | 2021-12-16 14:28:11 | rotten | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 559 | 2021-12-16 03:35:57 | rotten | 1 | 48755 | 7 | 1.093 | 44606.6 |
| 558 | 2021-12-15 10:07:45 | rotten | 1 | 48755 | 7 | 0.970 | 50262.9 |
| 557 | 2021-12-14 14:03:59 | rotten | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 556 | 2021-11-15 20:11:52 | rotten | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 555 | 2021-11-15 08:28:25 | rotten | 1 | 48755 | 7 | 1.903 | 25620.1 |
| 554 | 2021-11-14 17:35:15 | rotten | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 553 | 2021-11-14 07:46:51 | rotten | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 552 | 2021-11-13 16:55:43 | rotten | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 551 | 2021-11-13 09:31:10 | rotten | 1 | 48755 | 7 | 0.826 | 59025.4 |