History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rancho"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 654 | 2025-10-21 14:02:10 | rancho | 3 | 112716 | 300 | 28.750 | 3920.6 |
| 653 | 2025-10-13 12:53:43 | rancho | 2 | 82551 | 32 | 2.690 | 30688.1 |
| 652 | 2025-10-11 10:08:32 | rancho | 3 | 112716 | 300 | 5.653 | 19939.1 |
| 651 | 2025-10-06 05:30:51 | rancho | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 650 | 2025-09-25 09:59:23 | rancho | 1 | 48755 | 4 | 2.640 | 18467.8 |
| 649 | 2025-09-25 09:58:54 | rancho | 1 | 48755 | 4 | 4.326 | 11270.2 |
| 648 | 2025-09-25 09:58:32 | rancho | 1 | 48755 | 4 | 4.153 | 11739.7 |
| 647 | 2025-09-25 09:58:01 | rancho | 1 | 48755 | 4 | 2.060 | 23667.5 |
| 646 | 2025-09-08 18:52:49 | rancho | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 645 | 2025-09-07 12:14:44 | rancho | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 644 | 2025-08-27 00:02:49 | rancho | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 643 | 2025-08-13 01:17:25 | rancho | 1 | 48755 | 4 | 2.720 | 17924.6 |
| 642 | 2025-08-01 03:02:13 | rancho | 1 | 48755 | 4 | 2.233 | 21833.9 |
| 641 | 2025-07-31 03:35:20 | rancho | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 640 | 2025-07-31 03:12:34 | rancho | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 639 | 2025-07-24 01:30:14 | rancho | 1 | 48755 | 4 | 5.956 | 8185.9 |
| 638 | 2025-07-23 20:40:17 | rancho | 1 | 48755 | 4 | 2.093 | 23294.3 |
| 637 | 2025-07-23 18:33:33 | rancho | 1 | 48755 | 4 | 5.643 | 8639.9 |
| 636 | 2025-07-23 04:34:48 | rancho | 1 | 48755 | 4 | 2.186 | 22303.3 |
| 635 | 2025-07-23 01:24:33 | rancho | 1 | 48755 | 4 | 3.080 | 15829.5 |
| 634 | 2025-07-22 12:11:23 | rancho | 1 | 48755 | 4 | 1.860 | 26212.4 |
| 633 | 2025-07-21 23:21:29 | rancho | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 632 | 2025-07-19 04:02:08 | rancho | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 631 | 2025-07-18 11:57:52 | rancho | 1 | 48755 | 4 | 4.330 | 11259.8 |
| 630 | 2025-07-08 01:51:30 | rancho | 1 | 48755 | 4 | 5.170 | 9430.4 |
| 629 | 2025-07-07 16:00:52 | rancho | 1 | 48755 | 4 | 7.140 | 6828.4 |
| 628 | 2025-07-05 17:17:36 | rancho | 1 | 48755 | 4 | 5.763 | 8460.0 |
| 627 | 2025-07-04 11:03:52 | rancho | 1 | 48755 | 4 | 3.733 | 13060.5 |
| 626 | 2025-07-01 06:28:45 | rancho | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 625 | 2025-06-29 02:00:59 | rancho | 1 | 48755 | 4 | 3.720 | 13106.2 |
| 624 | 2025-06-18 13:00:53 | rancho | 1 | 48755 | 4 | 4.250 | 11471.8 |
| 623 | 2025-06-17 09:03:03 | rancho | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 622 | 2025-06-13 00:13:41 | rancho | 1 | 48755 | 4 | 0.940 | 51867.0 |
| 621 | 2025-06-10 11:35:23 | rancho | 1 | 48755 | 4 | 2.110 | 23106.6 |
| 620 | 2025-06-10 02:23:19 | rancho | 1 | 48755 | 4 | 2.656 | 18356.6 |
| 619 | 2025-06-08 01:39:14 | rancho | 1 | 48755 | 4 | 2.203 | 22131.2 |
| 618 | 2025-06-07 15:24:49 | rancho | 1 | 48755 | 4 | 3.780 | 12898.1 |
| 617 | 2025-06-06 05:24:56 | rancho | 3 | 112716 | 300 | 45.173 | 2495.2 |
| 616 | 2025-05-31 21:42:18 | rancho | 2 | 82551 | 32 | 13.660 | 6043.3 |
| 615 | 2025-05-31 13:38:44 | rancho | 3 | 112716 | 300 | 25.953 | 4343.1 |
| 614 | 2025-05-29 01:22:02 | rancho | 1 | 48755 | 4 | 4.373 | 11149.1 |
| 613 | 2025-05-28 11:07:32 | rancho | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 612 | 2025-05-22 14:41:33 | rancho | 1 | 48755 | 4 | 3.986 | 12231.6 |
| 611 | 2025-05-14 09:29:42 | rancho | 2 | 82551 | 32 | 12.970 | 6364.8 |
| 610 | 2025-05-14 04:53:59 | rancho | 2 | 82551 | 32 | 19.220 | 4295.1 |
| 609 | 2025-05-14 01:10:02 | rancho | 3 | 112716 | 300 | 15.423 | 7308.3 |
| 608 | 2025-05-13 05:31:44 | rancho | 2 | 82551 | 32 | 12.063 | 6843.3 |
| 607 | 2025-05-13 00:04:31 | rancho | 1 | 48755 | 4 | 4.110 | 11862.5 |
| 606 | 2025-05-11 01:39:30 | rancho | 3 | 112716 | 300 | 30.486 | 3697.3 |
| 605 | 2025-05-10 23:18:16 | rancho | 3 | 112716 | 300 | 23.983 | 4699.8 |
| 604 | 2025-05-08 18:20:01 | rancho | 2 | 82551 | 32 | 13.156 | 6274.8 |
| 603 | 2025-05-08 17:22:52 | rancho | 3 | 112716 | 300 | 20.483 | 5502.9 |
| 602 | 2025-05-08 05:30:11 | rancho | 2 | 82551 | 32 | 17.143 | 4815.4 |
| 601 | 2025-05-07 14:46:54 | rancho | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 600 | 2025-05-07 00:49:31 | rancho | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 599 | 2025-05-04 22:51:49 | rancho | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 598 | 2025-04-23 00:52:07 | rancho | 1 | 48755 | 4 | 4.046 | 12050.2 |
| 597 | 2025-04-18 14:29:06 | rancho | 1 | 48755 | 4 | 1.703 | 28628.9 |
| 596 | 2025-04-11 00:05:59 | rancho | 1 | 48755 | 4 | 4.376 | 11141.5 |
| 595 | 2025-04-06 11:08:32 | rancho | 1 | 48755 | 4 | 3.533 | 13799.9 |
| 594 | 2025-04-02 14:53:03 | rancho | 1 | 48755 | 4 | 4.233 | 11517.8 |
| 593 | 2025-03-26 17:59:06 | rancho | 3 | 112716 | 300 | 28.096 | 4011.8 |
| 592 | 2025-03-23 05:13:05 | rancho | 3 | 112716 | 300 | 39.516 | 2852.4 |
| 591 | 2025-03-21 01:52:19 | rancho | 1 | 48755 | 4 | 4.126 | 11816.5 |
| 590 | 2025-03-17 15:45:39 | rancho | 1 | 48755 | 4 | 0.936 | 52088.7 |
| 589 | 2025-03-09 20:22:36 | rancho | 1 | 48755 | 4 | 2.266 | 21515.9 |
| 588 | 2025-03-06 21:30:28 | rancho | 1 | 48755 | 4 | 5.936 | 8213.4 |
| 587 | 2025-02-28 14:49:46 | rancho | 1 | 48755 | 4 | 4.470 | 10907.2 |
| 586 | 2025-02-27 05:31:57 | rancho | 1 | 48755 | 4 | 4.800 | 10157.3 |
| 585 | 2025-02-09 13:03:50 | rancho | 1 | 48755 | 4 | 2.250 | 21668.9 |
| 584 | 2025-02-04 14:00:15 | rancho | 3 | 112716 | 300 | 28.550 | 3948.0 |
| 583 | 2025-02-04 09:13:35 | rancho | 3 | 112716 | 300 | 24.860 | 4534.0 |
| 582 | 2025-02-02 01:19:06 | rancho | 3 | 112716 | 300 | 24.483 | 4603.8 |
| 581 | 2025-02-02 01:19:06 | rancho | 2 | 82551 | 32 | 13.156 | 6274.8 |
| 580 | 2025-02-01 12:04:11 | rancho | 3 | 112716 | 300 | 5.403 | 20861.7 |
| 579 | 2025-02-01 12:04:12 | rancho | 2 | 82551 | 32 | 2.563 | 32208.7 |
| 578 | 2025-02-01 12:04:07 | rancho | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 577 | 2025-01-27 21:07:32 | rancho | 2 | 82551 | 32 | 14.266 | 5786.6 |
| 576 | 2025-01-27 21:07:26 | rancho | 1 | 48755 | 4 | 4.736 | 10294.6 |
| 575 | 2025-01-27 03:26:59 | rancho | 1 | 48755 | 4 | 4.000 | 12188.8 |
| 574 | 2025-01-24 22:01:45 | rancho | 2 | 82551 | 32 | 12.936 | 6381.5 |
| 573 | 2025-01-21 05:09:48 | rancho | 2 | 82551 | 32 | 12.580 | 6562.1 |
| 572 | 2025-01-09 12:51:31 | rancho | 1 | 48755 | 4 | 4.326 | 11270.2 |
| 571 | 2025-01-03 08:50:25 | rancho | 3 | 112716 | 300 | 32.783 | 3438.2 |
| 570 | 2024-12-29 14:52:48 | rancho | 3 | 112716 | 300 | 30.676 | 3674.4 |
| 569 | 2024-12-29 11:30:55 | rancho | 3 | 112716 | 300 | 35.280 | 3194.9 |
| 568 | 2024-12-29 11:30:55 | rancho | 2 | 82551 | 32 | 18.750 | 4402.7 |
| 567 | 2024-12-29 10:41:33 | rancho | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 566 | 2024-12-27 08:22:01 | rancho | 1 | 48755 | 4 | 6.033 | 8081.4 |
| 565 | 2024-12-25 17:25:37 | rancho | 1 | 48755 | 4 | 4.873 | 10005.1 |
| 564 | 2024-12-15 16:24:07 | rancho | 2 | 82551 | 32 | 7.436 | 11101.5 |
| 563 | 2024-12-15 16:23:58 | rancho | 1 | 48755 | 4 | 1.593 | 30605.8 |
| 562 | 2024-12-04 01:58:56 | rancho | 1 | 48755 | 4 | 5.843 | 8344.2 |
| 561 | 2024-12-02 11:13:45 | rancho | 3 | 112716 | 300 | 24.796 | 4545.7 |
| 560 | 2024-12-01 12:36:05 | rancho | 3 | 112716 | 300 | 28.503 | 3954.5 |
| 559 | 2024-11-29 09:00:41 | rancho | 2 | 82551 | 32 | 6.843 | 12063.6 |
| 558 | 2024-11-29 08:48:51 | rancho | 3 | 112716 | 300 | 5.516 | 20434.4 |
| 557 | 2024-11-29 07:20:48 | rancho | 3 | 112716 | 300 | 29.360 | 3839.1 |
| 556 | 2024-11-29 07:20:49 | rancho | 2 | 82551 | 32 | 17.236 | 4789.5 |
| 555 | 2024-11-29 07:20:43 | rancho | 1 | 48755 | 4 | 2.216 | 22001.4 |