History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lineage"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 605 | 2024-04-24 16:14:58 | lineage | 1 | 69583 | 5 | 1.593 | 43680.5 |
| 604 | 2024-04-17 00:17:36 | lineage | 1 | 69583 | 5 | 3.110 | 22374.0 |
| 603 | 2024-04-16 23:12:31 | lineage | 1 | 69583 | 5 | 3.376 | 20611.1 |
| 602 | 2024-04-16 23:01:18 | lineage | 1 | 69583 | 5 | 1.686 | 41271.1 |
| 601 | 2024-02-12 17:37:35 | lineage | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 600 | 2024-01-12 18:08:43 | lineage | 3 | 134027 | 227 | 6.190 | 21652.2 |
| 599 | 2024-01-12 18:08:42 | lineage | 2 | 107671 | 24 | 3.343 | 32207.9 |
| 598 | 2024-01-10 16:39:43 | lineage | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 597 | 2023-12-21 17:49:19 | lineage | 2 | 107671 | 24 | 2.876 | 37437.8 |
| 596 | 2023-12-16 03:31:11 | lineage | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 595 | 2023-12-07 11:37:23 | lineage | 2 | 107671 | 24 | 3.596 | 29941.9 |
| 594 | 2023-12-07 11:37:18 | lineage | 3 | 134027 | 227 | 7.686 | 17437.8 |
| 593 | 2023-11-27 01:23:53 | lineage | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 592 | 2023-11-15 22:26:07 | lineage | 1 | 69583 | 5 | 1.033 | 67360.1 |
| 591 | 2023-11-11 02:11:39 | lineage | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 590 | 2023-11-09 18:59:38 | lineage | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 589 | 2023-11-04 00:35:06 | lineage | 1 | 69583 | 5 | 2.516 | 27656.2 |
| 588 | 2023-10-14 08:11:00 | lineage | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 587 | 2023-10-13 23:35:24 | lineage | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 586 | 2023-09-22 16:31:02 | lineage | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 585 | 2023-09-22 08:06:31 | lineage | 2 | 107671 | 24 | 2.860 | 37647.2 |
| 584 | 2023-08-27 02:32:06 | lineage | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 583 | 2023-07-01 17:57:44 | lineage | 2 | 107671 | 24 | 2.876 | 37437.8 |
| 582 | 2023-06-23 09:34:46 | lineage | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 581 | 2023-05-30 21:06:07 | lineage | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 580 | 2023-03-29 11:04:31 | lineage | 2 | 107671 | 24 | 2.750 | 39153.1 |
| 579 | 2023-03-24 16:03:45 | lineage | 1 | 69583 | 5 | 1.033 | 67360.1 |
| 578 | 2023-03-04 15:22:52 | lineage | 1 | 69583 | 5 | 1.016 | 68487.2 |
| 577 | 2023-01-08 18:25:14 | lineage | 1 | 69583 | 5 | 1.153 | 60349.5 |
| 576 | 2022-12-26 11:35:56 | lineage | 2 | 107671 | 24 | 3.093 | 34811.2 |
| 575 | 2022-11-16 00:23:00 | lineage | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 574 | 2022-10-09 20:07:03 | lineage | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 573 | 2022-08-26 16:53:36 | lineage | 2 | 107671 | 24 | 3.170 | 33965.6 |
| 572 | 2022-07-26 19:32:35 | lineage | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 571 | 2022-06-01 01:42:30 | lineage | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 570 | 2022-04-01 06:51:55 | lineage | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 569 | 2022-02-15 09:53:32 | lineage | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 568 | 2022-01-10 15:49:23 | lineage | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 567 | 2021-12-17 17:11:16 | lineage | 1 | 69583 | 5 | 2.470 | 28171.3 |
| 566 | 2021-12-02 16:01:46 | lineage | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 565 | 2021-11-30 14:07:02 | lineage | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 564 | 2021-10-10 01:36:23 | lineage | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 563 | 2021-09-18 21:29:31 | lineage | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 562 | 2021-09-07 05:53:49 | lineage | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 561 | 2021-06-07 22:32:42 | lineage | 3 | 134027 | 227 | 6.830 | 19623.3 |
| 560 | 2021-06-06 07:24:56 | lineage | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 559 | 2021-06-03 02:44:50 | lineage | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 558 | 2021-05-21 16:38:30 | lineage | 1 | 69583 | 5 | 1.050 | 66269.5 |
| 557 | 2021-04-22 08:34:25 | lineage | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 556 | 2021-04-12 20:23:21 | lineage | 3 | 134027 | 227 | 13.033 | 10283.7 |
| 555 | 2021-03-25 09:01:14 | lineage | 3 | 134027 | 227 | 5.826 | 23005.0 |
| 554 | 2021-03-24 16:28:18 | lineage | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 553 | 2021-02-28 15:31:12 | lineage | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 552 | 2021-02-19 17:50:50 | lineage | 3 | 134027 | 227 | 6.906 | 19407.3 |
| 551 | 2021-02-03 00:16:21 | lineage | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 550 | 2021-01-08 12:07:57 | lineage | 3 | 134027 | 227 | 5.766 | 23244.4 |
| 549 | 2021-01-07 08:22:22 | lineage | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 548 | 2020-12-10 03:34:35 | lineage | 3 | 134027 | 227 | 5.860 | 22871.5 |
| 547 | 2020-11-24 03:21:31 | lineage | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 546 | 2020-11-14 14:43:04 | lineage | 1 | 69583 | 5 | 1.050 | 66269.5 |
| 545 | 2020-10-31 23:49:26 | lineage | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 544 | 2020-10-22 09:35:16 | lineage | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 543 | 2020-10-16 10:22:38 | lineage | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 542 | 2020-10-12 22:29:13 | lineage | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 541 | 2020-08-27 00:37:24 | lineage | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 540 | 2020-08-24 02:34:10 | lineage | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 539 | 2020-08-21 07:14:06 | lineage | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 538 | 2020-08-20 06:10:45 | lineage | 1 | 69583 | 5 | 1.546 | 45008.4 |
| 537 | 2020-08-19 06:32:23 | lineage | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 536 | 2020-08-15 10:51:47 | lineage | 3 | 134027 | 227 | 6.046 | 22167.9 |
| 535 | 2020-07-31 03:51:25 | lineage | 1 | 69583 | 5 | 2.126 | 32729.5 |
| 534 | 2020-05-25 19:25:00 | lineage | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 533 | 2020-05-18 00:54:18 | lineage | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 532 | 2020-03-29 00:51:22 | lineage | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 531 | 2020-03-23 16:28:08 | lineage | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 530 | 2020-03-23 13:25:59 | lineage | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 529 | 2020-03-20 10:32:33 | lineage | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 528 | 2020-03-01 09:05:49 | lineage | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 527 | 2020-02-24 11:44:59 | lineage | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 526 | 2020-02-23 10:23:21 | lineage | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 525 | 2020-02-15 04:21:46 | lineage | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 524 | 2020-02-09 10:29:12 | lineage | 1 | 69583 | 5 | 2.440 | 28517.6 |
| 523 | 2020-02-06 23:33:05 | lineage | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 522 | 2020-02-04 11:59:36 | lineage | 1 | 69583 | 5 | 2.690 | 25867.3 |
| 521 | 2020-02-03 06:32:28 | lineage | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 520 | 2020-02-03 04:23:49 | lineage | 1 | 69583 | 5 | 3.750 | 18555.5 |
| 519 | 2020-01-28 06:14:27 | lineage | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 518 | 2020-01-27 12:19:37 | lineage | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 517 | 2020-01-17 03:33:28 | lineage | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 516 | 2020-01-15 12:38:00 | lineage | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 515 | 2020-01-15 05:00:40 | lineage | 1 | 69583 | 5 | 3.860 | 18026.7 |
| 514 | 2020-01-12 20:34:26 | lineage | 1 | 69583 | 5 | 1.390 | 50059.7 |
| 513 | 2020-01-07 03:30:02 | lineage | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 512 | 2019-12-28 00:27:59 | lineage | 1 | 69583 | 5 | 1.610 | 43219.3 |
| 511 | 2019-12-27 04:06:02 | lineage | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 510 | 2019-12-27 01:44:25 | lineage | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 509 | 2019-12-27 00:25:31 | lineage | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 508 | 2019-11-29 05:47:01 | lineage | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 507 | 2019-11-15 06:23:34 | lineage | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 506 | 2019-11-14 04:15:14 | lineage | 3 | 134027 | 227 | 6.470 | 20715.1 |