History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dunning"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 623 | 2024-04-20 14:36:23 | dunning | 1 | 69583 | 15 | 1.936 | 35941.6 |
| 622 | 2024-04-20 14:22:14 | dunning | 1 | 69583 | 15 | 1.313 | 52995.4 |
| 621 | 2024-04-20 14:15:45 | dunning | 1 | 69583 | 15 | 2.470 | 28171.3 |
| 620 | 2024-03-30 07:13:11 | dunning | 1 | 69583 | 15 | 2.673 | 26031.8 |
| 619 | 2024-03-28 06:30:52 | dunning | 1 | 69583 | 15 | 1.203 | 57841.2 |
| 618 | 2024-02-29 01:10:28 | dunning | 1 | 69583 | 15 | 1.220 | 57035.2 |
| 617 | 2024-01-27 01:06:47 | dunning | 1 | 69583 | 15 | 1.156 | 60192.9 |
| 616 | 2024-01-19 05:43:31 | dunning | 3 | 134027 | 744 | 5.623 | 23835.5 |
| 615 | 2023-12-19 08:21:33 | dunning | 3 | 134027 | 744 | 6.623 | 20236.6 |
| 614 | 2023-12-15 10:32:29 | dunning | 1 | 69583 | 15 | 1.236 | 56296.9 |
| 613 | 2023-12-12 05:32:59 | dunning | 3 | 134027 | 744 | 6.610 | 20276.4 |
| 612 | 2023-12-12 05:32:56 | dunning | 2 | 107671 | 91 | 3.046 | 35348.3 |
| 611 | 2023-11-22 15:13:33 | dunning | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 610 | 2023-11-20 10:20:15 | dunning | 1 | 69583 | 15 | 1.156 | 60192.9 |
| 609 | 2023-11-11 01:52:34 | dunning | 1 | 69583 | 15 | 1.190 | 58473.1 |
| 608 | 2023-11-06 03:43:49 | dunning | 1 | 69583 | 15 | 1.236 | 56296.9 |
| 607 | 2023-11-03 22:54:41 | dunning | 1 | 69583 | 15 | 1.090 | 63837.6 |
| 606 | 2023-10-31 16:34:32 | dunning | 1 | 69583 | 15 | 1.216 | 57222.9 |
| 605 | 2023-10-31 07:31:18 | dunning | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 604 | 2023-10-29 11:10:04 | dunning | 3 | 134027 | 744 | 6.033 | 22215.6 |
| 603 | 2023-10-17 00:35:49 | dunning | 1 | 69583 | 15 | 1.143 | 60877.5 |
| 602 | 2023-10-16 00:35:15 | dunning | 3 | 134027 | 744 | 7.560 | 17728.4 |
| 601 | 2023-10-06 22:08:14 | dunning | 1 | 69583 | 15 | 1.190 | 58473.1 |
| 600 | 2023-10-06 19:19:33 | dunning | 3 | 134027 | 744 | 7.860 | 17051.8 |
| 599 | 2023-09-27 23:30:54 | dunning | 2 | 107671 | 91 | 2.890 | 37256.4 |
| 598 | 2023-09-27 23:30:27 | dunning | 3 | 134027 | 744 | 7.966 | 16824.9 |
| 597 | 2023-09-23 07:08:20 | dunning | 1 | 69583 | 15 | 1.250 | 55666.4 |
| 596 | 2023-09-19 18:55:22 | dunning | 1 | 69583 | 15 | 1.983 | 35089.8 |
| 595 | 2023-09-08 23:08:36 | dunning | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 594 | 2023-08-22 09:24:00 | dunning | 1 | 69583 | 15 | 1.173 | 59320.5 |
| 593 | 2023-08-07 00:06:20 | dunning | 3 | 134027 | 744 | 5.606 | 23907.8 |
| 592 | 2023-07-19 17:30:33 | dunning | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 591 | 2023-06-14 12:20:09 | dunning | 1 | 69583 | 15 | 1.140 | 61037.7 |
| 590 | 2023-04-16 07:19:56 | dunning | 3 | 134027 | 744 | 6.530 | 20524.8 |
| 589 | 2023-04-08 05:22:33 | dunning | 1 | 69583 | 15 | 1.030 | 67556.3 |
| 588 | 2023-03-31 08:02:12 | dunning | 1 | 69583 | 15 | 1.106 | 62914.1 |
| 587 | 2023-01-21 18:44:14 | dunning | 3 | 134027 | 744 | 5.563 | 24092.6 |
| 586 | 2023-01-13 10:33:31 | dunning | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 585 | 2023-01-12 22:23:49 | dunning | 1 | 69583 | 15 | 1.093 | 63662.4 |
| 584 | 2023-01-12 10:14:31 | dunning | 1 | 69583 | 15 | 1.140 | 61037.7 |
| 583 | 2023-01-11 20:58:26 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 582 | 2023-01-11 08:43:56 | dunning | 1 | 69583 | 15 | 1.030 | 67556.3 |
| 581 | 2023-01-02 23:30:33 | dunning | 1 | 69583 | 15 | 1.280 | 54361.7 |
| 580 | 2023-01-01 07:51:15 | dunning | 3 | 134027 | 744 | 6.516 | 20568.9 |
| 579 | 2022-11-20 09:20:01 | dunning | 3 | 134027 | 744 | 5.610 | 23890.7 |
| 578 | 2022-11-19 00:58:07 | dunning | 3 | 134027 | 744 | 6.453 | 20769.7 |
| 577 | 2022-11-16 22:34:32 | dunning | 3 | 134027 | 744 | 5.796 | 23124.1 |
| 576 | 2022-11-12 01:11:57 | dunning | 1 | 69583 | 15 | 1.330 | 52318.0 |
| 575 | 2022-11-11 13:25:38 | dunning | 1 | 69583 | 15 | 1.203 | 57841.2 |
| 574 | 2022-11-03 02:06:52 | dunning | 3 | 134027 | 744 | 5.626 | 23822.8 |
| 573 | 2022-10-28 14:52:37 | dunning | 1 | 69583 | 15 | 1.033 | 67360.1 |
| 572 | 2022-10-25 15:30:42 | dunning | 3 | 134027 | 744 | 6.343 | 21129.9 |
| 571 | 2022-10-14 15:46:44 | dunning | 3 | 134027 | 744 | 5.533 | 24223.2 |
| 570 | 2022-10-04 15:00:47 | dunning | 3 | 134027 | 744 | 5.843 | 22938.0 |
| 569 | 2022-09-19 09:30:28 | dunning | 1 | 69583 | 15 | 1.156 | 60192.9 |
| 568 | 2022-09-11 18:28:31 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 567 | 2022-09-10 22:52:31 | dunning | 3 | 134027 | 744 | 5.983 | 22401.3 |
| 566 | 2022-08-08 07:49:04 | dunning | 3 | 134027 | 744 | 5.970 | 22450.1 |
| 565 | 2022-07-30 08:52:42 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 564 | 2022-07-02 23:58:58 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 563 | 2022-06-26 06:42:32 | dunning | 1 | 69583 | 15 | 1.140 | 61037.7 |
| 562 | 2022-06-24 22:28:28 | dunning | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 561 | 2022-06-17 02:02:11 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 560 | 2022-06-14 23:13:29 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 559 | 2022-06-04 19:18:44 | dunning | 3 | 134027 | 744 | 5.546 | 24166.4 |
| 558 | 2022-06-02 15:14:20 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 557 | 2022-02-19 05:39:54 | dunning | 1 | 69583 | 15 | 1.046 | 66522.9 |
| 556 | 2022-02-18 01:10:25 | dunning | 1 | 69583 | 15 | 1.143 | 60877.5 |
| 555 | 2022-02-12 21:59:04 | dunning | 1 | 69583 | 15 | 1.110 | 62687.4 |
| 554 | 2022-02-12 13:33:38 | dunning | 1 | 69583 | 15 | 1.203 | 57841.2 |
| 553 | 2022-02-11 22:08:27 | dunning | 1 | 69583 | 15 | 1.236 | 56296.9 |
| 552 | 2022-02-06 17:42:36 | dunning | 1 | 69583 | 15 | 1.216 | 57222.9 |
| 551 | 2022-02-06 04:47:29 | dunning | 1 | 69583 | 15 | 1.313 | 52995.4 |
| 550 | 2022-02-05 07:47:41 | dunning | 1 | 69583 | 15 | 1.076 | 64668.2 |
| 549 | 2022-02-04 10:50:27 | dunning | 1 | 69583 | 15 | 1.110 | 62687.4 |
| 548 | 2022-02-03 19:46:48 | dunning | 1 | 69583 | 15 | 1.190 | 58473.1 |
| 547 | 2022-02-03 07:18:08 | dunning | 1 | 69583 | 15 | 1.080 | 64428.7 |
| 546 | 2022-02-02 20:23:47 | dunning | 1 | 69583 | 15 | 1.233 | 56433.9 |
| 545 | 2022-02-02 03:44:20 | dunning | 1 | 69583 | 15 | 1.140 | 61037.7 |
| 544 | 2022-02-01 15:59:11 | dunning | 1 | 69583 | 15 | 2.453 | 28366.5 |
| 543 | 2022-02-01 02:43:31 | dunning | 1 | 69583 | 15 | 1.123 | 61961.7 |
| 542 | 2022-01-31 12:44:16 | dunning | 1 | 69583 | 15 | 1.360 | 51164.0 |
| 541 | 2022-01-31 00:35:06 | dunning | 1 | 69583 | 15 | 1.173 | 59320.5 |
| 540 | 2022-01-30 12:01:57 | dunning | 1 | 69583 | 15 | 1.266 | 54962.9 |
| 539 | 2022-01-29 22:05:05 | dunning | 1 | 69583 | 15 | 1.156 | 60192.9 |
| 538 | 2022-01-29 04:31:55 | dunning | 1 | 69583 | 15 | 1.170 | 59472.6 |
| 537 | 2022-01-28 16:11:40 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 536 | 2022-01-28 01:15:40 | dunning | 1 | 69583 | 15 | 1.233 | 56433.9 |
| 535 | 2022-01-27 06:17:40 | dunning | 1 | 69583 | 15 | 1.220 | 57035.2 |
| 534 | 2022-01-26 22:28:10 | dunning | 1 | 69583 | 15 | 1.170 | 59472.6 |
| 533 | 2022-01-26 11:14:55 | dunning | 1 | 69583 | 15 | 1.093 | 63662.4 |
| 532 | 2022-01-26 03:11:27 | dunning | 3 | 134027 | 744 | 7.016 | 19103.1 |
| 531 | 2022-01-25 17:36:43 | dunning | 1 | 69583 | 15 | 1.060 | 65644.3 |
| 530 | 2022-01-25 05:38:19 | dunning | 1 | 69583 | 15 | 1.233 | 56433.9 |
| 529 | 2022-01-24 11:19:28 | dunning | 1 | 69583 | 15 | 1.186 | 58670.3 |
| 528 | 2022-01-23 22:16:47 | dunning | 3 | 134027 | 744 | 5.670 | 23637.9 |
| 527 | 2022-01-23 21:25:54 | dunning | 1 | 69583 | 15 | 1.233 | 56433.9 |
| 526 | 2022-01-21 16:28:34 | dunning | 1 | 69583 | 15 | 1.063 | 65459.1 |
| 525 | 2022-01-21 04:45:44 | dunning | 1 | 69583 | 15 | 1.343 | 51811.6 |
| 524 | 2022-01-20 18:49:26 | dunning | 1 | 69583 | 15 | 1.233 | 56433.9 |