History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"provinces"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 620 | 2025-10-11 17:15:03 | provinces | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 619 | 2025-10-10 23:04:08 | provinces | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 618 | 2025-10-10 22:37:11 | provinces | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 617 | 2025-10-08 18:23:35 | provinces | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 616 | 2025-09-29 20:06:38 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 615 | 2025-09-29 16:19:26 | provinces | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 614 | 2025-09-22 22:47:14 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 613 | 2025-09-21 20:50:31 | provinces | 1 | 81242 | 2 | 1.530 | 53099.3 |
| 612 | 2025-09-10 17:00:06 | provinces | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 611 | 2025-09-10 17:00:06 | provinces | 1 | 81242 | 2 | 1.513 | 53696.0 |
| 610 | 2025-09-10 10:51:11 | provinces | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 609 | 2025-08-29 19:58:42 | provinces | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 608 | 2025-08-29 17:18:20 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 607 | 2025-08-25 02:36:32 | provinces | 1 | 81242 | 2 | 3.373 | 24086.0 |
| 606 | 2025-08-18 21:05:05 | provinces | 1 | 81242 | 2 | 3.280 | 24768.9 |
| 605 | 2025-08-02 15:29:59 | provinces | 1 | 81242 | 2 | 2.736 | 29693.7 |
| 604 | 2025-08-01 19:05:00 | provinces | 1 | 81242 | 2 | 6.440 | 12615.2 |
| 603 | 2025-07-31 00:41:21 | provinces | 1 | 81242 | 2 | 7.796 | 10421.0 |
| 602 | 2025-07-27 10:42:34 | provinces | 3 | 148641 | 82 | 19.236 | 7727.2 |
| 601 | 2025-07-27 09:54:15 | provinces | 3 | 148641 | 82 | 26.360 | 5638.9 |
| 600 | 2025-07-26 23:06:33 | provinces | 2 | 121436 | 9 | 15.140 | 8020.9 |
| 599 | 2025-07-26 21:22:01 | provinces | 3 | 148641 | 82 | 25.986 | 5720.0 |
| 598 | 2025-07-25 05:58:29 | provinces | 2 | 121436 | 9 | 9.470 | 12823.2 |
| 597 | 2025-07-25 03:49:01 | provinces | 3 | 148641 | 82 | 23.890 | 6221.9 |
| 596 | 2025-07-25 03:39:14 | provinces | 1 | 81242 | 2 | 2.920 | 27822.6 |
| 595 | 2025-07-25 02:13:15 | provinces | 3 | 148641 | 82 | 29.440 | 5048.9 |
| 594 | 2025-07-25 00:11:59 | provinces | 1 | 81242 | 2 | 6.173 | 13160.9 |
| 593 | 2025-07-23 11:43:24 | provinces | 1 | 81242 | 2 | 6.750 | 12035.9 |
| 592 | 2025-07-23 00:48:02 | provinces | 1 | 81242 | 2 | 5.906 | 13755.8 |
| 591 | 2025-07-22 09:52:41 | provinces | 1 | 81242 | 2 | 1.420 | 57212.7 |
| 590 | 2025-07-21 16:32:46 | provinces | 1 | 81242 | 2 | 1.466 | 55417.5 |
| 589 | 2025-07-07 17:10:15 | provinces | 1 | 81242 | 2 | 3.406 | 23852.6 |
| 588 | 2025-07-07 16:41:32 | provinces | 1 | 81242 | 2 | 4.360 | 18633.5 |
| 587 | 2025-07-04 19:48:29 | provinces | 2 | 121436 | 9 | 15.300 | 7937.0 |
| 586 | 2025-07-03 20:43:18 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 585 | 2025-06-25 23:47:18 | provinces | 1 | 81242 | 2 | 8.483 | 9577.0 |
| 584 | 2025-06-21 20:59:51 | provinces | 3 | 148641 | 82 | 26.156 | 5682.9 |
| 583 | 2025-06-20 20:57:42 | provinces | 3 | 148641 | 82 | 37.940 | 3917.8 |
| 582 | 2025-06-20 09:25:05 | provinces | 2 | 121436 | 9 | 17.296 | 7021.0 |
| 581 | 2025-06-20 02:28:05 | provinces | 3 | 148641 | 82 | 38.690 | 3841.8 |
| 580 | 2025-06-18 23:14:23 | provinces | 1 | 81242 | 2 | 1.580 | 51419.0 |
| 579 | 2025-06-02 16:03:41 | provinces | 1 | 81242 | 2 | 7.500 | 10832.3 |
| 578 | 2025-05-28 21:37:53 | provinces | 1 | 81242 | 2 | 3.436 | 23644.4 |
| 577 | 2025-05-24 03:08:39 | provinces | 1 | 81242 | 2 | 7.673 | 10588.0 |
| 576 | 2025-05-15 03:36:54 | provinces | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 575 | 2025-05-14 02:09:53 | provinces | 3 | 148641 | 82 | 22.050 | 6741.1 |
| 574 | 2025-05-12 10:47:00 | provinces | 3 | 148641 | 82 | 21.140 | 7031.3 |
| 573 | 2025-05-09 20:40:42 | provinces | 1 | 81242 | 2 | 6.970 | 11656.0 |
| 572 | 2025-05-06 09:50:26 | provinces | 3 | 148641 | 82 | 39.476 | 3765.4 |
| 571 | 2025-05-05 22:05:34 | provinces | 2 | 121436 | 9 | 18.936 | 6413.0 |
| 570 | 2025-05-04 22:52:42 | provinces | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 569 | 2025-04-25 12:44:21 | provinces | 3 | 148641 | 82 | 36.236 | 4102.0 |
| 568 | 2025-04-24 15:09:48 | provinces | 1 | 81242 | 2 | 10.186 | 7975.8 |
| 567 | 2025-04-23 02:43:40 | provinces | 1 | 81242 | 2 | 5.563 | 14604.0 |
| 566 | 2025-04-22 22:52:05 | provinces | 1 | 81242 | 2 | 10.156 | 7999.4 |
| 565 | 2025-04-11 23:17:10 | provinces | 1 | 81242 | 2 | 6.766 | 12007.4 |
| 564 | 2025-04-11 06:19:30 | provinces | 2 | 121436 | 9 | 12.406 | 9788.5 |
| 563 | 2025-04-11 01:26:06 | provinces | 3 | 148641 | 82 | 30.123 | 4934.5 |
| 562 | 2025-04-10 20:57:19 | provinces | 3 | 148641 | 82 | 30.863 | 4816.2 |
| 561 | 2025-04-09 10:40:54 | provinces | 3 | 148641 | 82 | 30.673 | 4846.0 |
| 560 | 2025-04-08 19:54:13 | provinces | 2 | 121436 | 9 | 23.876 | 5086.1 |
| 559 | 2025-04-07 20:19:46 | provinces | 1 | 81242 | 2 | 1.313 | 61875.1 |
| 558 | 2025-03-23 09:02:40 | provinces | 1 | 81242 | 2 | 6.250 | 12998.7 |
| 557 | 2025-03-23 04:31:03 | provinces | 1 | 81242 | 2 | 7.406 | 10969.8 |
| 556 | 2025-03-22 23:46:45 | provinces | 1 | 81242 | 2 | 10.173 | 7986.0 |
| 555 | 2025-03-19 23:50:00 | provinces | 1 | 81242 | 2 | 7.280 | 11159.6 |
| 554 | 2025-03-10 01:19:56 | provinces | 3 | 148641 | 82 | 36.330 | 4091.4 |
| 553 | 2025-03-09 10:24:30 | provinces | 2 | 121436 | 9 | 17.893 | 6786.8 |
| 552 | 2025-03-03 04:40:58 | provinces | 2 | 121436 | 9 | 16.783 | 7235.7 |
| 551 | 2025-02-25 03:39:00 | provinces | 3 | 148641 | 82 | 32.003 | 4644.6 |
| 550 | 2025-02-24 17:33:57 | provinces | 1 | 81242 | 2 | 3.440 | 23616.9 |
| 549 | 2025-02-23 07:54:34 | provinces | 3 | 148641 | 82 | 36.346 | 4089.6 |
| 548 | 2025-02-20 08:53:19 | provinces | 3 | 148641 | 82 | 35.313 | 4209.2 |
| 547 | 2025-02-19 14:58:13 | provinces | 1 | 81242 | 2 | 6.750 | 12035.9 |
| 546 | 2025-02-19 14:54:35 | provinces | 3 | 148641 | 82 | 66.063 | 2250.0 |
| 545 | 2025-02-18 19:49:17 | provinces | 3 | 148641 | 82 | 36.346 | 4089.6 |
| 544 | 2025-02-13 20:14:58 | provinces | 1 | 81242 | 2 | 3.610 | 22504.7 |
| 543 | 2025-02-12 11:38:01 | provinces | 3 | 148641 | 82 | 30.330 | 4900.8 |
| 542 | 2025-02-11 06:05:18 | provinces | 3 | 148641 | 82 | 38.046 | 3906.9 |
| 541 | 2025-02-06 14:30:57 | provinces | 4 | 165329 | 678 | 75.910 | 2178.0 |
| 540 | 2025-02-05 11:55:23 | provinces | 4 | 165329 | 678 | 78.160 | 2115.3 |
| 539 | 2025-02-03 13:42:09 | provinces | 4 | 165329 | 678 | 49.300 | 3353.5 |
| 538 | 2025-02-03 13:42:00 | provinces | 2 | 121436 | 9 | 16.690 | 7276.0 |
| 537 | 2025-01-17 19:37:13 | provinces | 3 | 148641 | 82 | 19.656 | 7562.1 |
| 536 | 2025-01-17 08:08:01 | provinces | 3 | 148641 | 82 | 37.440 | 3970.1 |
| 535 | 2025-01-15 19:30:24 | provinces | 3 | 148641 | 82 | 37.233 | 3992.2 |
| 534 | 2025-01-15 19:27:19 | provinces | 1 | 81242 | 2 | 3.700 | 21957.3 |
| 533 | 2025-01-14 23:26:56 | provinces | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 532 | 2025-01-07 21:14:21 | provinces | 4 | 165329 | 678 | 66.720 | 2478.0 |
| 531 | 2025-01-07 13:28:39 | provinces | 4 | 165329 | 678 | 62.160 | 2659.7 |
| 530 | 2025-01-06 08:30:19 | provinces | 4 | 165329 | 678 | 87.903 | 1880.8 |
| 529 | 2025-01-06 07:24:51 | provinces | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 528 | 2025-01-04 05:29:12 | provinces | 2 | 121436 | 9 | 18.436 | 6586.9 |
| 527 | 2025-01-04 05:28:47 | provinces | 3 | 148641 | 82 | 22.453 | 6620.1 |
| 526 | 2024-12-24 10:09:10 | provinces | 3 | 148641 | 82 | 32.546 | 4567.1 |
| 525 | 2024-12-23 04:35:56 | provinces | 1 | 81242 | 2 | 5.373 | 15120.4 |
| 524 | 2024-12-18 22:03:02 | provinces | 3 | 148641 | 82 | 29.233 | 5084.7 |
| 523 | 2024-12-17 23:57:40 | provinces | 3 | 148641 | 82 | 40.236 | 3694.2 |
| 522 | 2024-12-17 18:28:10 | provinces | 3 | 148641 | 82 | 35.580 | 4177.7 |
| 521 | 2024-12-17 13:29:26 | provinces | 3 | 148641 | 82 | 33.736 | 4406.0 |