History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pavement"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 624 | 2025-10-28 08:05:07 | pavement | 4 | 161609 | 640 | 11.623 | 13904.2 |
| 623 | 2025-10-10 21:02:32 | pavement | 4 | 161609 | 640 | 11.156 | 14486.3 |
| 622 | 2025-10-04 15:28:46 | pavement | 4 | 161609 | 640 | 10.953 | 14754.8 |
| 621 | 2025-09-20 14:59:51 | pavement | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 620 | 2025-09-17 21:18:33 | pavement | 3 | 146162 | 80 | 23.986 | 6093.6 |
| 619 | 2025-09-13 04:42:04 | pavement | 3 | 146162 | 80 | 12.000 | 12180.2 |
| 618 | 2025-09-08 01:54:11 | pavement | 1 | 82945 | 2 | 1.300 | 63803.8 |
| 617 | 2025-08-27 03:35:41 | pavement | 1 | 82945 | 2 | 1.953 | 42470.6 |
| 616 | 2025-08-26 06:08:25 | pavement | 1 | 82945 | 2 | 3.470 | 23903.5 |
| 615 | 2025-08-05 19:55:08 | pavement | 3 | 146162 | 80 | 42.003 | 3479.8 |
| 614 | 2025-08-05 14:31:54 | pavement | 1 | 82945 | 2 | 5.670 | 14628.7 |
| 613 | 2025-08-05 13:20:01 | pavement | 3 | 146162 | 80 | 18.843 | 7756.8 |
| 612 | 2025-08-02 04:04:06 | pavement | 3 | 146162 | 80 | 25.283 | 5781.0 |
| 611 | 2025-08-01 05:10:21 | pavement | 1 | 82945 | 2 | 4.173 | 19876.6 |
| 610 | 2025-07-27 02:17:11 | pavement | 1 | 82945 | 2 | 3.370 | 24612.8 |
| 609 | 2025-07-26 05:18:34 | pavement | 3 | 146162 | 80 | 8.516 | 17163.2 |
| 608 | 2025-07-23 14:18:07 | pavement | 1 | 82945 | 2 | 7.360 | 11269.7 |
| 607 | 2025-07-22 09:23:26 | pavement | 1 | 82945 | 2 | 1.550 | 53512.9 |
| 606 | 2025-07-11 08:48:20 | pavement | 1 | 82945 | 2 | 4.203 | 19734.7 |
| 605 | 2025-07-11 02:15:11 | pavement | 2 | 121059 | 12 | 9.673 | 12515.1 |
| 604 | 2025-07-09 01:08:23 | pavement | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 603 | 2025-07-06 20:41:07 | pavement | 1 | 82945 | 2 | 4.373 | 18967.5 |
| 602 | 2025-06-30 18:02:29 | pavement | 3 | 146162 | 80 | 29.770 | 4909.7 |
| 601 | 2025-06-30 11:25:00 | pavement | 2 | 121059 | 12 | 12.360 | 9794.4 |
| 600 | 2025-06-29 16:04:32 | pavement | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 599 | 2025-06-28 21:32:10 | pavement | 3 | 146162 | 80 | 7.500 | 19488.3 |
| 598 | 2025-06-25 15:12:18 | pavement | 3 | 146162 | 80 | 10.610 | 13775.9 |
| 597 | 2025-06-24 15:04:15 | pavement | 1 | 82945 | 2 | 6.846 | 12115.8 |
| 596 | 2025-06-24 13:46:30 | pavement | 3 | 146162 | 80 | 54.176 | 2697.9 |
| 595 | 2025-06-24 02:54:35 | pavement | 1 | 82945 | 2 | 6.640 | 12491.7 |
| 594 | 2025-06-23 12:23:01 | pavement | 3 | 146162 | 80 | 53.286 | 2743.0 |
| 593 | 2025-06-20 15:05:31 | pavement | 3 | 146162 | 80 | 33.470 | 4367.0 |
| 592 | 2025-06-17 21:16:53 | pavement | 3 | 146162 | 80 | 25.203 | 5799.4 |
| 591 | 2025-06-13 18:55:38 | pavement | 1 | 82945 | 2 | 3.233 | 25655.7 |
| 590 | 2025-06-12 05:49:24 | pavement | 1 | 82945 | 2 | 5.873 | 14123.1 |
| 589 | 2025-06-04 01:36:40 | pavement | 1 | 82945 | 2 | 6.970 | 11900.3 |
| 588 | 2025-05-28 23:30:17 | pavement | 1 | 82945 | 2 | 6.796 | 12205.0 |
| 587 | 2025-05-28 13:00:17 | pavement | 1 | 82945 | 2 | 1.563 | 53067.8 |
| 586 | 2025-05-22 02:36:33 | pavement | 1 | 82945 | 2 | 6.673 | 12429.9 |
| 585 | 2025-05-12 02:47:06 | pavement | 1 | 82945 | 2 | 6.796 | 12205.0 |
| 584 | 2025-05-08 20:24:40 | pavement | 1 | 82945 | 2 | 7.253 | 11436.0 |
| 583 | 2025-04-23 05:59:55 | pavement | 1 | 82945 | 2 | 7.376 | 11245.3 |
| 582 | 2025-04-20 02:04:24 | pavement | 1 | 82945 | 2 | 4.936 | 16804.1 |
| 581 | 2025-04-15 04:31:57 | pavement | 1 | 82945 | 2 | 3.563 | 23279.5 |
| 580 | 2025-04-13 18:12:51 | pavement | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 579 | 2025-04-11 01:24:29 | pavement | 1 | 82945 | 2 | 5.440 | 15247.2 |
| 578 | 2025-04-09 03:28:59 | pavement | 1 | 82945 | 2 | 10.966 | 7563.8 |
| 577 | 2025-03-31 02:53:44 | pavement | 1 | 82945 | 2 | 7.500 | 11059.3 |
| 576 | 2025-03-25 15:14:52 | pavement | 3 | 146162 | 80 | 47.866 | 3053.6 |
| 575 | 2025-03-23 14:40:15 | pavement | 3 | 146162 | 80 | 18.656 | 7834.6 |
| 574 | 2025-03-21 14:41:48 | pavement | 3 | 146162 | 80 | 29.516 | 4952.0 |
| 573 | 2025-03-20 04:03:54 | pavement | 1 | 82945 | 2 | 5.750 | 14425.2 |
| 572 | 2025-03-19 21:17:57 | pavement | 3 | 146162 | 80 | 36.096 | 4049.3 |
| 571 | 2025-03-18 11:42:20 | pavement | 3 | 146162 | 80 | 26.563 | 5502.5 |
| 570 | 2025-03-13 01:07:51 | pavement | 1 | 82945 | 2 | 6.703 | 12374.3 |
| 569 | 2025-03-11 06:32:58 | pavement | 3 | 146162 | 80 | 37.983 | 3848.1 |
| 568 | 2025-03-09 15:29:53 | pavement | 2 | 121059 | 12 | 16.063 | 7536.5 |
| 567 | 2025-03-09 08:28:38 | pavement | 1 | 82945 | 2 | 6.830 | 12144.2 |
| 566 | 2025-03-08 17:52:22 | pavement | 3 | 146162 | 80 | 50.080 | 2918.6 |
| 565 | 2025-03-07 12:07:19 | pavement | 2 | 121059 | 12 | 17.940 | 6748.0 |
| 564 | 2025-03-07 12:04:21 | pavement | 1 | 82945 | 2 | 2.763 | 30019.9 |
| 563 | 2025-02-28 12:48:10 | pavement | 2 | 121059 | 12 | 9.546 | 12681.6 |
| 562 | 2025-02-28 12:47:31 | pavement | 1 | 82945 | 2 | 5.626 | 14743.2 |
| 561 | 2025-02-27 07:40:41 | pavement | 1 | 82945 | 2 | 5.123 | 16190.7 |
| 560 | 2025-02-26 09:56:08 | pavement | 1 | 82945 | 2 | 5.503 | 15072.7 |
| 559 | 2025-02-24 12:53:04 | pavement | 3 | 146162 | 80 | 32.970 | 4433.2 |
| 558 | 2025-02-21 11:34:47 | pavement | 3 | 146162 | 80 | 38.673 | 3779.4 |
| 557 | 2025-02-16 18:51:41 | pavement | 3 | 146162 | 80 | 30.360 | 4814.3 |
| 556 | 2025-02-12 17:17:12 | pavement | 3 | 146162 | 80 | 31.643 | 4619.1 |
| 555 | 2025-02-04 01:34:04 | pavement | 2 | 121059 | 12 | 3.360 | 36029.5 |
| 554 | 2025-02-02 04:30:41 | pavement | 3 | 146162 | 80 | 34.360 | 4253.8 |
| 553 | 2025-02-02 01:27:22 | pavement | 3 | 146162 | 80 | 57.476 | 2543.0 |
| 552 | 2025-02-02 01:27:53 | pavement | 2 | 121059 | 12 | 16.363 | 7398.3 |
| 551 | 2025-02-01 13:49:04 | pavement | 3 | 146162 | 80 | 31.960 | 4573.3 |
| 550 | 2025-02-01 13:49:03 | pavement | 2 | 121059 | 12 | 14.906 | 8121.5 |
| 549 | 2025-02-01 13:49:08 | pavement | 1 | 82945 | 2 | 6.766 | 12259.1 |
| 548 | 2025-01-29 03:06:04 | pavement | 1 | 82945 | 2 | 6.453 | 12853.7 |
| 547 | 2025-01-19 13:53:28 | pavement | 3 | 146162 | 80 | 19.050 | 7672.5 |
| 546 | 2025-01-19 13:53:29 | pavement | 2 | 121059 | 12 | 6.173 | 19611.0 |
| 545 | 2025-01-19 13:53:26 | pavement | 1 | 82945 | 2 | 1.576 | 52630.1 |
| 544 | 2025-01-17 07:23:20 | pavement | 4 | 161609 | 640 | 65.113 | 2482.0 |
| 543 | 2025-01-13 07:02:00 | pavement | 4 | 161609 | 640 | 78.630 | 2055.3 |
| 542 | 2025-01-06 21:25:02 | pavement | 4 | 161609 | 640 | 11.920 | 13557.8 |
| 541 | 2025-01-02 04:23:23 | pavement | 4 | 161609 | 640 | 62.003 | 2606.5 |
| 540 | 2024-12-28 10:45:00 | pavement | 2 | 121059 | 12 | 19.313 | 6268.3 |
| 539 | 2024-12-27 17:52:53 | pavement | 2 | 121059 | 12 | 8.393 | 14423.8 |
| 538 | 2024-12-27 17:52:52 | pavement | 1 | 82945 | 2 | 3.500 | 23698.6 |
| 537 | 2024-12-19 22:59:43 | pavement | 2 | 121059 | 12 | 3.720 | 32542.7 |
| 536 | 2024-12-19 17:25:35 | pavement | 3 | 146162 | 80 | 18.780 | 7782.9 |
| 535 | 2024-12-19 09:26:19 | pavement | 3 | 146162 | 80 | 32.860 | 4448.0 |
| 534 | 2024-12-19 03:15:01 | pavement | 3 | 146162 | 80 | 21.266 | 6873.0 |
| 533 | 2024-12-18 06:38:08 | pavement | 4 | 161609 | 640 | 82.363 | 1962.2 |
| 532 | 2024-12-17 17:33:22 | pavement | 1 | 82945 | 2 | 5.360 | 15474.8 |
| 531 | 2024-12-15 17:25:20 | pavement | 3 | 146162 | 80 | 13.436 | 10878.4 |
| 530 | 2024-12-14 07:21:50 | pavement | 3 | 146162 | 80 | 36.253 | 4031.7 |
| 529 | 2024-12-14 05:52:27 | pavement | 3 | 146162 | 80 | 34.096 | 4286.8 |
| 528 | 2024-12-11 21:31:09 | pavement | 3 | 146162 | 80 | 45.253 | 3229.9 |
| 527 | 2024-12-07 15:01:35 | pavement | 4 | 161609 | 640 | 60.520 | 2670.3 |
| 526 | 2024-12-01 02:57:40 | pavement | 4 | 161609 | 640 | 61.050 | 2647.2 |
| 525 | 2024-11-20 07:44:07 | pavement | 2 | 121059 | 12 | 8.376 | 14453.1 |