History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hierarchy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 609 | 2025-07-19 10:06:00 | hierarchy | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 608 | 2025-07-15 15:49:44 | hierarchy | 3 | 148641 | 23 | 33.423 | 4447.3 |
| 607 | 2025-07-11 12:03:46 | hierarchy | 1 | 81242 | 3 | 5.813 | 13975.9 |
| 606 | 2025-07-09 16:58:59 | hierarchy | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 605 | 2025-06-29 21:58:15 | hierarchy | 3 | 148641 | 23 | 40.626 | 3658.8 |
| 604 | 2025-06-26 15:17:12 | hierarchy | 3 | 148641 | 23 | 37.173 | 3998.6 |
| 603 | 2025-06-23 17:23:22 | hierarchy | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 602 | 2025-06-23 04:15:42 | hierarchy | 3 | 148641 | 23 | 8.233 | 18054.3 |
| 601 | 2025-06-14 05:13:10 | hierarchy | 1 | 81242 | 3 | 7.020 | 11572.9 |
| 600 | 2025-06-13 19:30:12 | hierarchy | 1 | 81242 | 3 | 6.063 | 13399.6 |
| 599 | 2025-06-10 11:52:36 | hierarchy | 4 | 165329 | 95 | 63.296 | 2612.0 |
| 598 | 2025-06-07 21:00:50 | hierarchy | 4 | 165329 | 95 | 73.266 | 2256.6 |
| 597 | 2025-06-06 12:14:20 | hierarchy | 4 | 165329 | 95 | 49.110 | 3366.5 |
| 596 | 2025-06-06 06:12:08 | hierarchy | 4 | 165329 | 95 | 75.960 | 2176.5 |
| 595 | 2025-06-06 03:10:08 | hierarchy | 4 | 165329 | 95 | 48.296 | 3423.2 |
| 594 | 2025-06-05 21:54:31 | hierarchy | 4 | 165329 | 95 | 55.970 | 2953.9 |
| 593 | 2025-06-05 18:47:28 | hierarchy | 4 | 165329 | 95 | 18.940 | 8729.1 |
| 592 | 2025-06-05 13:22:30 | hierarchy | 4 | 165329 | 95 | 35.513 | 4655.5 |
| 591 | 2025-06-04 13:38:04 | hierarchy | 4 | 165329 | 95 | 50.033 | 3304.4 |
| 590 | 2025-06-04 11:51:58 | hierarchy | 4 | 165329 | 95 | 76.966 | 2148.1 |
| 589 | 2025-06-04 04:18:00 | hierarchy | 4 | 165329 | 95 | 48.793 | 3388.4 |
| 588 | 2025-06-03 20:43:53 | hierarchy | 5 | 174418 | 600 | 78.456 | 2223.1 |
| 587 | 2025-06-03 13:17:15 | hierarchy | 5 | 174418 | 600 | 48.850 | 3570.5 |
| 586 | 2025-06-01 07:13:49 | hierarchy | 4 | 165329 | 95 | 13.516 | 12232.1 |
| 585 | 2025-05-30 09:50:41 | hierarchy | 4 | 165329 | 95 | 65.083 | 2540.3 |
| 584 | 2025-05-29 11:17:07 | hierarchy | 1 | 81242 | 3 | 3.736 | 21745.7 |
| 583 | 2025-05-26 04:50:03 | hierarchy | 1 | 81242 | 3 | 6.780 | 11982.6 |
| 582 | 2025-05-10 20:45:29 | hierarchy | 1 | 81242 | 3 | 3.186 | 25499.7 |
| 581 | 2025-05-08 10:00:34 | hierarchy | 1 | 81242 | 3 | 3.313 | 24522.2 |
| 580 | 2025-05-08 06:15:19 | hierarchy | 2 | 121436 | 7 | 19.920 | 6096.2 |
| 579 | 2025-05-07 17:35:27 | hierarchy | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 578 | 2025-05-02 14:11:45 | hierarchy | 1 | 81242 | 3 | 11.373 | 7143.4 |
| 577 | 2025-05-01 19:40:55 | hierarchy | 3 | 148641 | 23 | 12.253 | 12131.0 |
| 576 | 2025-04-28 12:03:08 | hierarchy | 1 | 81242 | 3 | 7.030 | 11556.5 |
| 575 | 2025-04-26 17:52:27 | hierarchy | 3 | 148641 | 23 | 21.953 | 6770.9 |
| 574 | 2025-04-21 08:26:24 | hierarchy | 2 | 121436 | 7 | 12.143 | 10000.5 |
| 573 | 2025-04-20 20:34:14 | hierarchy | 2 | 121436 | 7 | 19.233 | 6313.9 |
| 572 | 2025-04-18 07:52:38 | hierarchy | 1 | 81242 | 3 | 5.953 | 13647.2 |
| 571 | 2025-04-07 14:50:29 | hierarchy | 3 | 148641 | 23 | 37.670 | 3945.9 |
| 570 | 2025-03-31 03:23:18 | hierarchy | 2 | 121436 | 7 | 12.190 | 9961.9 |
| 569 | 2025-03-31 02:21:39 | hierarchy | 3 | 148641 | 23 | 37.750 | 3937.5 |
| 568 | 2025-03-29 12:16:15 | hierarchy | 2 | 121436 | 7 | 9.440 | 12864.0 |
| 567 | 2025-03-28 21:38:37 | hierarchy | 3 | 148641 | 23 | 36.860 | 4032.6 |
| 566 | 2025-03-28 13:44:45 | hierarchy | 1 | 81242 | 3 | 6.533 | 12435.6 |
| 565 | 2025-03-25 03:51:44 | hierarchy | 1 | 81242 | 3 | 3.563 | 22801.6 |
| 564 | 2025-03-23 03:01:00 | hierarchy | 3 | 148641 | 23 | 21.780 | 6824.7 |
| 563 | 2025-03-22 13:22:05 | hierarchy | 3 | 148641 | 23 | 35.563 | 4179.7 |
| 562 | 2025-03-19 23:05:22 | hierarchy | 3 | 148641 | 23 | 40.206 | 3697.0 |
| 561 | 2025-03-14 10:02:23 | hierarchy | 4 | 165329 | 95 | 56.270 | 2938.1 |
| 560 | 2025-03-14 10:02:23 | hierarchy | 3 | 148641 | 23 | 49.223 | 3019.7 |
| 559 | 2025-03-14 10:02:22 | hierarchy | 2 | 121436 | 7 | 17.610 | 6895.9 |
| 558 | 2025-03-14 10:01:50 | hierarchy | 1 | 81242 | 3 | 5.283 | 15378.0 |
| 557 | 2025-03-13 16:08:10 | hierarchy | 1 | 81242 | 3 | 6.753 | 12030.5 |
| 556 | 2025-03-03 09:23:17 | hierarchy | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 555 | 2025-02-20 21:47:18 | hierarchy | 1 | 81242 | 3 | 8.610 | 9435.8 |
| 554 | 2025-02-18 12:40:46 | hierarchy | 1 | 81242 | 3 | 3.890 | 20884.8 |
| 553 | 2025-02-16 04:05:32 | hierarchy | 4 | 165329 | 95 | 71.690 | 2306.2 |
| 552 | 2025-02-15 06:01:28 | hierarchy | 4 | 165329 | 95 | 66.110 | 2500.8 |
| 551 | 2025-02-13 06:37:29 | hierarchy | 4 | 165329 | 95 | 81.396 | 2031.2 |
| 550 | 2025-02-11 21:41:32 | hierarchy | 1 | 81242 | 3 | 6.733 | 12066.2 |
| 549 | 2025-02-04 16:42:42 | hierarchy | 3 | 148641 | 23 | 12.156 | 12227.8 |
| 548 | 2025-02-03 17:17:52 | hierarchy | 3 | 148641 | 23 | 29.906 | 4970.3 |
| 547 | 2025-01-31 05:36:08 | hierarchy | 2 | 121436 | 7 | 16.983 | 7150.4 |
| 546 | 2025-01-31 05:35:43 | hierarchy | 3 | 148641 | 23 | 41.330 | 3596.4 |
| 545 | 2025-01-29 06:07:31 | hierarchy | 2 | 121436 | 7 | 17.280 | 7027.5 |
| 544 | 2025-01-25 05:34:58 | hierarchy | 3 | 148641 | 23 | 22.783 | 6524.2 |
| 543 | 2025-01-23 22:48:19 | hierarchy | 1 | 81242 | 3 | 4.453 | 18244.3 |
| 542 | 2025-01-18 18:59:08 | hierarchy | 3 | 148641 | 23 | 39.966 | 3719.2 |
| 541 | 2025-01-16 00:51:08 | hierarchy | 1 | 81242 | 3 | 3.856 | 21069.0 |
| 540 | 2025-01-11 12:22:26 | hierarchy | 4 | 165329 | 95 | 66.290 | 2494.0 |
| 539 | 2025-01-07 10:20:39 | hierarchy | 4 | 165329 | 95 | 67.130 | 2462.8 |
| 538 | 2025-01-07 04:54:02 | hierarchy | 4 | 165329 | 95 | 83.643 | 1976.6 |
| 537 | 2025-01-04 17:43:22 | hierarchy | 3 | 148641 | 23 | 18.613 | 7985.9 |
| 536 | 2025-01-04 17:43:11 | hierarchy | 2 | 121436 | 7 | 13.873 | 8753.4 |
| 535 | 2025-01-04 17:22:03 | hierarchy | 1 | 81242 | 3 | 5.690 | 14278.0 |
| 534 | 2025-01-01 03:52:42 | hierarchy | 3 | 148641 | 23 | 37.250 | 3990.4 |
| 533 | 2025-01-01 03:52:33 | hierarchy | 2 | 121436 | 7 | 10.766 | 11279.6 |
| 532 | 2024-12-27 00:22:53 | hierarchy | 1 | 81242 | 3 | 3.203 | 25364.3 |
| 531 | 2024-12-13 14:02:53 | hierarchy | 3 | 148641 | 23 | 34.610 | 4294.7 |
| 530 | 2024-12-13 14:02:55 | hierarchy | 2 | 121436 | 7 | 16.970 | 7155.9 |
| 529 | 2024-12-13 14:02:01 | hierarchy | 1 | 81242 | 3 | 4.263 | 19057.5 |
| 528 | 2024-12-09 22:09:14 | hierarchy | 3 | 148641 | 23 | 39.673 | 3746.7 |
| 527 | 2024-12-04 11:52:53 | hierarchy | 3 | 148641 | 23 | 25.330 | 5868.2 |
| 526 | 2024-12-01 09:33:43 | hierarchy | 4 | 165329 | 95 | 69.240 | 2387.8 |
| 525 | 2024-12-01 09:33:51 | hierarchy | 3 | 148641 | 23 | 38.313 | 3879.6 |
| 524 | 2024-12-01 09:33:47 | hierarchy | 2 | 121436 | 7 | 17.296 | 7021.0 |
| 523 | 2024-12-01 09:31:21 | hierarchy | 1 | 81242 | 3 | 8.813 | 9218.4 |
| 522 | 2024-11-29 13:57:53 | hierarchy | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 521 | 2024-11-29 09:34:42 | hierarchy | 4 | 165329 | 95 | 72.683 | 2274.7 |
| 520 | 2024-11-26 20:17:28 | hierarchy | 1 | 81242 | 3 | 6.640 | 12235.2 |
| 519 | 2024-11-25 14:28:23 | hierarchy | 4 | 165329 | 95 | 65.406 | 2527.7 |
| 518 | 2024-11-06 18:31:26 | hierarchy | 4 | 165329 | 95 | 47.816 | 3457.6 |
| 517 | 2024-11-06 18:30:57 | hierarchy | 1 | 81242 | 3 | 5.936 | 13686.3 |
| 516 | 2024-10-30 15:17:13 | hierarchy | 1 | 81242 | 3 | 3.626 | 22405.4 |
| 515 | 2024-10-29 16:34:55 | hierarchy | 4 | 165329 | 95 | 65.676 | 2517.3 |
| 514 | 2024-10-28 12:44:48 | hierarchy | 4 | 165329 | 95 | 109.210 | 1513.9 |
| 513 | 2024-10-25 19:48:09 | hierarchy | 4 | 165329 | 95 | 51.863 | 3187.8 |
| 512 | 2024-10-25 18:05:29 | hierarchy | 4 | 165329 | 95 | 103.053 | 1604.3 |
| 511 | 2024-10-25 18:05:30 | hierarchy | 4 | 165329 | 95 | 98.410 | 1680.0 |
| 510 | 2024-10-25 18:06:20 | hierarchy | 3 | 148641 | 23 | 24.376 | 6097.8 |