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 |
| 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 |
| 524 | 2024-11-20 07:43:55 | pavement | 1 | 82945 | 2 | 8.656 | 9582.4 |
| 523 | 2024-11-18 09:00:39 | pavement | 3 | 146162 | 80 | 14.110 | 10358.8 |
| 522 | 2024-11-16 17:47:43 | pavement | 3 | 146162 | 80 | 30.626 | 4772.5 |
| 521 | 2024-11-16 09:58:02 | pavement | 3 | 146162 | 80 | 32.676 | 4473.1 |
| 520 | 2024-11-16 09:58:04 | pavement | 2 | 121059 | 12 | 18.893 | 6407.6 |
| 519 | 2024-11-16 09:57:55 | pavement | 1 | 82945 | 2 | 2.780 | 29836.3 |
| 518 | 2024-11-15 02:55:36 | pavement | 4 | 161609 | 640 | 62.113 | 2601.9 |
| 517 | 2024-11-13 20:27:10 | pavement | 4 | 161609 | 640 | 61.970 | 2607.9 |
| 516 | 2024-11-07 11:11:11 | pavement | 4 | 161609 | 640 | 43.516 | 3713.8 |
| 515 | 2024-11-07 11:11:16 | pavement | 1 | 82945 | 2 | 4.893 | 16951.8 |
| 514 | 2024-10-27 07:54:42 | pavement | 3 | 146162 | 80 | 7.533 | 19402.9 |
| 513 | 2024-10-27 07:54:43 | pavement | 2 | 121059 | 12 | 3.846 | 31476.6 |
| 512 | 2024-10-27 07:54:40 | pavement | 1 | 82945 | 2 | 1.280 | 64800.8 |
| 511 | 2024-10-25 22:00:48 | pavement | 1 | 82945 | 2 | 10.640 | 7795.6 |
| 510 | 2024-10-25 21:50:52 | pavement | 1 | 82945 | 2 | 3.783 | 21925.7 |
| 509 | 2024-10-25 21:41:48 | pavement | 3 | 146162 | 80 | 44.126 | 3312.4 |
| 508 | 2024-10-25 21:32:22 | pavement | 3 | 146162 | 80 | 34.860 | 4192.8 |
| 507 | 2024-10-25 21:29:54 | pavement | 1 | 82945 | 2 | 3.296 | 25165.4 |
| 506 | 2024-10-25 21:12:54 | pavement | 1 | 82945 | 2 | 7.436 | 11154.5 |
| 505 | 2024-10-16 12:15:30 | pavement | 2 | 121059 | 12 | 18.673 | 6483.1 |
| 504 | 2024-10-15 21:37:32 | pavement | 3 | 146162 | 80 | 43.563 | 3355.2 |
| 503 | 2024-10-15 21:37:28 | pavement | 2 | 121059 | 12 | 9.360 | 12933.7 |
| 502 | 2024-10-15 21:37:05 | pavement | 1 | 82945 | 2 | 6.736 | 12313.7 |
| 501 | 2024-10-15 14:12:15 | pavement | 3 | 146162 | 80 | 39.593 | 3691.6 |
| 500 | 2024-10-15 08:14:35 | pavement | 3 | 146162 | 80 | 38.503 | 3796.1 |
| 499 | 2024-10-15 01:58:36 | pavement | 3 | 146162 | 80 | 36.956 | 3955.0 |
| 498 | 2024-10-14 19:38:28 | pavement | 3 | 146162 | 80 | 47.923 | 3049.9 |
| 497 | 2024-10-14 12:07:31 | pavement | 3 | 146162 | 80 | 45.830 | 3189.2 |
| 496 | 2024-10-10 07:36:39 | pavement | 1 | 82945 | 2 | 4.703 | 17636.6 |
| 495 | 2024-09-13 09:53:58 | pavement | 2 | 121059 | 12 | 26.500 | 4568.3 |
| 494 | 2024-09-12 21:28:41 | pavement | 1 | 82945 | 2 | 15.330 | 5410.6 |
| 493 | 2024-09-12 19:21:01 | pavement | 3 | 146162 | 80 | 68.900 | 2121.4 |
| 492 | 2024-09-12 19:20:50 | pavement | 2 | 121059 | 12 | 40.080 | 3020.4 |
| 491 | 2024-09-10 17:30:10 | pavement | 3 | 146162 | 80 | 78.656 | 1858.2 |
| 490 | 2024-09-10 06:51:53 | pavement | 3 | 146162 | 80 | 76.083 | 1921.1 |
| 489 | 2024-09-10 06:51:42 | pavement | 3 | 146162 | 80 | 32.206 | 4538.3 |
| 488 | 2024-09-10 06:02:05 | pavement | 3 | 146162 | 80 | 77.490 | 1886.2 |
| 487 | 2024-09-09 23:05:38 | pavement | 4 | 161609 | 640 | 83.160 | 1943.4 |
| 486 | 2024-09-09 23:05:39 | pavement | 3 | 146162 | 80 | 60.130 | 2430.8 |
| 485 | 2024-09-09 23:05:40 | pavement | 2 | 121059 | 12 | 14.080 | 8597.9 |