History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"enterer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 630 | 2024-04-27 06:53:12 | enterer | 1 | 69583 | 3 | 1.876 | 37091.2 |
| 629 | 2024-04-25 19:41:33 | enterer | 3 | 134027 | 343 | 14.236 | 9414.7 |
| 628 | 2024-04-25 19:34:22 | enterer | 2 | 107671 | 37 | 3.390 | 31761.4 |
| 627 | 2024-04-25 19:23:53 | enterer | 3 | 134027 | 343 | 6.733 | 19906.0 |
| 626 | 2024-04-25 08:47:00 | enterer | 3 | 134027 | 343 | 16.813 | 7971.6 |
| 625 | 2024-04-24 19:25:58 | enterer | 2 | 107671 | 37 | 10.360 | 10393.0 |
| 624 | 2024-04-24 17:49:15 | enterer | 3 | 134027 | 343 | 8.296 | 16155.6 |
| 623 | 2024-04-22 17:52:05 | enterer | 3 | 134027 | 343 | 25.626 | 5230.1 |
| 622 | 2024-04-22 17:52:08 | enterer | 2 | 107671 | 37 | 7.266 | 14818.5 |
| 621 | 2024-04-22 16:53:38 | enterer | 1 | 69583 | 3 | 2.453 | 28366.5 |
| 620 | 2024-04-21 16:33:52 | enterer | 1 | 69583 | 3 | 4.766 | 14599.9 |
| 619 | 2024-04-21 06:44:48 | enterer | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 618 | 2024-04-21 06:31:23 | enterer | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 617 | 2024-04-20 17:19:35 | enterer | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 616 | 2024-04-19 20:57:18 | enterer | 1 | 69583 | 3 | 1.970 | 35321.3 |
| 615 | 2024-04-17 18:21:27 | enterer | 1 | 69583 | 3 | 1.466 | 47464.5 |
| 614 | 2024-04-16 04:41:44 | enterer | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 613 | 2024-04-15 02:55:05 | enterer | 1 | 69583 | 3 | 4.533 | 15350.3 |
| 612 | 2024-04-13 08:24:44 | enterer | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 611 | 2024-04-12 20:20:44 | enterer | 1 | 69583 | 3 | 2.093 | 33245.6 |
| 610 | 2024-04-12 08:39:26 | enterer | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 609 | 2024-04-11 18:58:28 | enterer | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 608 | 2024-04-11 08:36:50 | enterer | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 607 | 2024-04-02 18:52:39 | enterer | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 606 | 2024-04-01 19:13:46 | enterer | 1 | 69583 | 3 | 1.453 | 47889.2 |
| 605 | 2024-03-31 19:29:47 | enterer | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 604 | 2024-03-28 19:39:14 | enterer | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 603 | 2024-03-24 13:20:51 | enterer | 1 | 69583 | 3 | 2.703 | 25742.9 |
| 602 | 2024-03-24 03:39:41 | enterer | 1 | 69583 | 3 | 4.186 | 16622.8 |
| 601 | 2024-03-23 13:21:00 | enterer | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 600 | 2024-03-23 02:50:50 | enterer | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 599 | 2024-03-17 04:36:25 | enterer | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 598 | 2024-03-16 15:59:16 | enterer | 1 | 69583 | 3 | 3.750 | 18555.5 |
| 597 | 2024-03-16 05:24:07 | enterer | 1 | 69583 | 3 | 3.233 | 21522.7 |
| 596 | 2024-03-15 16:25:50 | enterer | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 595 | 2024-03-15 04:47:51 | enterer | 1 | 69583 | 3 | 4.250 | 16372.5 |
| 594 | 2024-03-14 13:45:40 | enterer | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 593 | 2024-03-14 05:11:26 | enterer | 1 | 69583 | 3 | 3.046 | 22844.1 |
| 592 | 2024-03-12 13:44:25 | enterer | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 591 | 2024-03-07 21:18:24 | enterer | 1 | 69583 | 3 | 1.593 | 43680.5 |
| 590 | 2024-03-07 20:41:08 | enterer | 1 | 69583 | 3 | 2.660 | 26159.0 |
| 589 | 2024-03-07 10:34:32 | enterer | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 588 | 2024-03-07 02:13:22 | enterer | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 587 | 2024-03-06 21:13:03 | enterer | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 586 | 2024-03-06 09:58:36 | enterer | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 585 | 2024-03-05 21:04:05 | enterer | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 584 | 2024-03-05 08:20:20 | enterer | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 583 | 2024-03-04 06:51:20 | enterer | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 582 | 2024-03-03 14:52:10 | enterer | 1 | 69583 | 3 | 2.890 | 24077.2 |
| 581 | 2024-03-02 14:46:14 | enterer | 1 | 69583 | 3 | 4.500 | 15462.9 |
| 580 | 2024-03-01 14:38:50 | enterer | 1 | 69583 | 3 | 5.390 | 12909.6 |
| 579 | 2024-02-29 15:43:06 | enterer | 2 | 107671 | 37 | 3.546 | 30364.1 |
| 578 | 2024-02-29 15:42:49 | enterer | 3 | 134027 | 343 | 6.313 | 21230.3 |
| 577 | 2024-02-28 08:31:26 | enterer | 1 | 69583 | 3 | 2.800 | 24851.1 |
| 576 | 2024-02-28 08:26:46 | enterer | 3 | 134027 | 343 | 14.330 | 9352.9 |
| 575 | 2024-02-28 08:23:25 | enterer | 2 | 107671 | 37 | 8.580 | 12549.1 |
| 574 | 2024-02-27 17:12:56 | enterer | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 573 | 2024-02-27 09:10:00 | enterer | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 572 | 2024-02-26 10:55:32 | enterer | 2 | 107671 | 37 | 4.453 | 24179.4 |
| 571 | 2024-02-26 10:53:33 | enterer | 3 | 134027 | 343 | 7.343 | 18252.3 |
| 570 | 2024-02-26 08:32:32 | enterer | 1 | 69583 | 3 | 1.640 | 42428.7 |
| 569 | 2024-02-25 09:13:55 | enterer | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 568 | 2024-02-24 11:08:53 | enterer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 567 | 2024-02-23 23:16:15 | enterer | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 566 | 2024-02-22 23:08:00 | enterer | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 565 | 2024-02-22 11:59:33 | enterer | 3 | 134027 | 343 | 23.503 | 5702.5 |
| 564 | 2024-02-21 23:38:30 | enterer | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 563 | 2024-02-21 11:25:00 | enterer | 1 | 69583 | 3 | 1.876 | 37091.2 |
| 562 | 2024-02-20 22:56:43 | enterer | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 561 | 2024-02-20 11:33:37 | enterer | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 560 | 2024-02-19 23:18:08 | enterer | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 559 | 2024-02-11 14:53:30 | enterer | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 558 | 2024-02-11 06:10:54 | enterer | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 557 | 2024-02-10 14:51:15 | enterer | 1 | 69583 | 3 | 4.410 | 15778.5 |
| 556 | 2024-02-10 06:28:30 | enterer | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 555 | 2024-02-09 14:46:02 | enterer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 554 | 2024-02-01 11:41:27 | enterer | 1 | 69583 | 3 | 2.156 | 32274.1 |
| 553 | 2024-02-01 02:33:28 | enterer | 1 | 69583 | 3 | 2.470 | 28171.3 |
| 552 | 2024-01-31 11:46:44 | enterer | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 551 | 2024-01-30 11:28:10 | enterer | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 550 | 2024-01-27 02:27:17 | enterer | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 549 | 2024-01-20 20:28:59 | enterer | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 548 | 2024-01-20 08:43:01 | enterer | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 547 | 2024-01-19 09:29:44 | enterer | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 546 | 2024-01-10 17:58:15 | enterer | 1 | 69583 | 3 | 1.206 | 57697.3 |
| 545 | 2024-01-10 08:48:19 | enterer | 1 | 69583 | 3 | 1.206 | 57697.3 |
| 544 | 2024-01-09 08:30:33 | enterer | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 543 | 2023-12-08 07:53:50 | enterer | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 542 | 2023-11-30 12:06:50 | enterer | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 541 | 2023-11-19 03:46:41 | enterer | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 540 | 2023-11-17 11:08:53 | enterer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 539 | 2023-10-26 17:08:00 | enterer | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 538 | 2023-10-23 03:56:52 | enterer | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 537 | 2023-10-17 04:34:04 | enterer | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 536 | 2023-09-26 01:28:50 | enterer | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 535 | 2023-09-23 08:28:01 | enterer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 534 | 2023-09-21 13:55:00 | enterer | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 533 | 2023-08-14 16:40:52 | enterer | 3 | 134027 | 343 | 6.330 | 21173.3 |
| 532 | 2023-08-09 01:05:16 | enterer | 3 | 134027 | 343 | 7.763 | 17264.8 |
| 531 | 2023-07-16 16:54:33 | enterer | 1 | 69583 | 3 | 1.060 | 65644.3 |