History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aviated"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 636 | 2024-04-29 02:17:03 | aviated | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 635 | 2024-04-15 19:17:27 | aviated | 1 | 69583 | 3 | 2.656 | 26198.4 |
| 634 | 2024-03-28 13:37:23 | aviated | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 633 | 2024-03-22 11:38:37 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 632 | 2024-03-06 00:45:08 | aviated | 1 | 69583 | 3 | 3.530 | 19711.9 |
| 631 | 2024-03-02 16:25:55 | aviated | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 630 | 2024-01-17 22:52:59 | aviated | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 629 | 2024-01-14 13:56:40 | aviated | 3 | 134027 | 456 | 5.953 | 22514.2 |
| 628 | 2024-01-10 20:45:05 | aviated | 3 | 134027 | 456 | 6.406 | 20922.1 |
| 627 | 2024-01-06 13:14:16 | aviated | 3 | 134027 | 456 | 6.563 | 20421.6 |
| 626 | 2024-01-06 13:14:15 | aviated | 2 | 107671 | 33 | 3.376 | 31893.1 |
| 625 | 2024-01-05 01:11:11 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 624 | 2023-12-30 08:15:59 | aviated | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 623 | 2023-12-17 22:48:34 | aviated | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 622 | 2023-12-07 21:31:15 | aviated | 3 | 134027 | 456 | 8.923 | 15020.4 |
| 621 | 2023-12-07 21:31:13 | aviated | 2 | 107671 | 33 | 4.983 | 21607.7 |
| 620 | 2023-11-27 07:40:57 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 619 | 2023-11-23 05:55:16 | aviated | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 618 | 2023-11-21 20:31:59 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 617 | 2023-11-14 12:22:56 | aviated | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 616 | 2023-11-11 04:57:14 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 615 | 2023-10-23 05:39:30 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 614 | 2023-10-19 18:28:26 | aviated | 1 | 69583 | 3 | 2.373 | 29322.8 |
| 613 | 2023-10-19 06:17:13 | aviated | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 612 | 2023-09-29 18:20:45 | aviated | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 611 | 2023-09-29 14:16:16 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 610 | 2023-09-21 08:25:41 | aviated | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 609 | 2023-08-15 17:03:43 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 608 | 2023-08-06 23:37:35 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 607 | 2023-07-12 23:22:45 | aviated | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 606 | 2023-07-11 23:09:08 | aviated | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 605 | 2023-06-09 13:39:31 | aviated | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 604 | 2023-06-08 20:39:11 | aviated | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 603 | 2023-06-05 22:10:03 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 602 | 2023-06-05 02:16:10 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 601 | 2023-06-04 05:59:15 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 600 | 2023-06-01 23:21:45 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 599 | 2023-06-01 03:42:34 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 598 | 2023-05-31 10:27:14 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 597 | 2023-05-14 12:01:23 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 596 | 2023-05-12 12:38:44 | aviated | 1 | 69583 | 3 | 2.470 | 28171.3 |
| 595 | 2023-05-11 11:21:18 | aviated | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 594 | 2023-05-11 08:30:56 | aviated | 1 | 69583 | 3 | 1.043 | 66714.3 |
| 593 | 2023-05-10 18:11:49 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 592 | 2023-05-07 14:25:43 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 591 | 2023-05-06 14:30:24 | aviated | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 590 | 2023-05-05 06:45:01 | aviated | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 589 | 2023-05-04 16:38:04 | aviated | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 588 | 2023-04-29 10:01:13 | aviated | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 587 | 2023-03-08 15:51:14 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 586 | 2023-01-17 02:48:22 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 585 | 2023-01-13 10:01:01 | aviated | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 584 | 2022-12-29 09:58:35 | aviated | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 583 | 2022-09-25 20:21:12 | aviated | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 582 | 2022-09-17 08:41:08 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 581 | 2022-07-03 06:10:25 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 580 | 2022-06-12 10:51:59 | aviated | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 579 | 2022-03-03 20:32:43 | aviated | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 578 | 2022-02-25 08:48:19 | aviated | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 577 | 2021-12-16 11:36:50 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 576 | 2021-11-27 02:46:24 | aviated | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 575 | 2021-11-26 16:50:29 | aviated | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 574 | 2021-11-26 05:01:28 | aviated | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 573 | 2021-11-25 13:09:18 | aviated | 1 | 69583 | 3 | 2.470 | 28171.3 |
| 572 | 2021-11-17 05:06:52 | aviated | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 571 | 2021-11-15 14:04:23 | aviated | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 570 | 2021-11-07 00:26:50 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 569 | 2021-09-22 12:31:00 | aviated | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 568 | 2021-09-21 23:03:45 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 567 | 2021-09-21 07:33:47 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 566 | 2021-09-20 15:18:02 | aviated | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 565 | 2021-09-19 14:06:03 | aviated | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 564 | 2021-08-10 23:30:52 | aviated | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 563 | 2021-07-28 08:01:38 | aviated | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 562 | 2021-05-20 16:50:47 | aviated | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 561 | 2021-05-19 20:13:08 | aviated | 1 | 69583 | 3 | 2.610 | 26660.2 |
| 560 | 2021-05-19 14:35:24 | aviated | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 559 | 2021-05-18 20:32:58 | aviated | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 558 | 2021-05-18 06:16:48 | aviated | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 557 | 2021-05-18 03:06:34 | aviated | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 556 | 2021-05-17 05:36:43 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 555 | 2021-05-16 15:36:56 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 554 | 2021-05-15 23:03:33 | aviated | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 553 | 2021-05-10 01:45:44 | aviated | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 552 | 2021-05-06 17:02:30 | aviated | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 551 | 2021-05-03 18:23:28 | aviated | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 550 | 2021-04-19 13:12:37 | aviated | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 549 | 2021-04-17 02:52:06 | aviated | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 548 | 2021-04-16 15:04:49 | aviated | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 547 | 2021-04-15 17:01:13 | aviated | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 546 | 2021-04-14 23:57:09 | aviated | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 545 | 2021-04-11 01:59:33 | aviated | 1 | 69583 | 3 | 2.373 | 29322.8 |
| 544 | 2021-04-10 09:31:32 | aviated | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 543 | 2021-04-09 16:07:00 | aviated | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 542 | 2021-04-07 00:34:06 | aviated | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 541 | 2021-04-06 09:26:08 | aviated | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 540 | 2021-04-05 06:12:30 | aviated | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 539 | 2021-04-04 13:50:50 | aviated | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 538 | 2021-04-04 01:18:46 | aviated | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 537 | 2021-04-02 22:39:18 | aviated | 1 | 69583 | 3 | 1.156 | 60192.9 |