History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"materials"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 591 | 2026-04-15 05:52:48 | materials | 1 | 81242 | 3 | 4.203 | 19329.5 |
| 590 | 2026-04-07 12:03:56 | materials | 3 | 148641 | 81 | 18.923 | 7855.0 |
| 589 | 2026-04-06 21:34:49 | materials | 4 | 165329 | 645 | 70.003 | 2361.7 |
| 588 | 2026-04-01 01:56:59 | materials | 1 | 81242 | 3 | 7.670 | 10592.2 |
| 587 | 2026-03-31 05:20:40 | materials | 1 | 81242 | 3 | 7.096 | 11449.0 |
| 586 | 2026-03-26 07:56:24 | materials | 1 | 81242 | 3 | 4.186 | 19408.0 |
| 585 | 2026-03-24 16:53:37 | materials | 4 | 165329 | 645 | 91.613 | 1804.6 |
| 584 | 2026-03-24 08:45:28 | materials | 4 | 165329 | 645 | 77.236 | 2140.6 |
| 583 | 2026-03-24 02:07:39 | materials | 4 | 165329 | 645 | 68.063 | 2429.1 |
| 582 | 2026-03-21 05:54:51 | materials | 4 | 165329 | 645 | 34.970 | 4727.7 |
| 581 | 2026-03-19 16:41:43 | materials | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 580 | 2026-03-17 02:36:43 | materials | 4 | 165329 | 645 | 27.483 | 6015.7 |
| 579 | 2026-03-14 13:45:15 | materials | 4 | 165329 | 645 | 54.453 | 3036.2 |
| 578 | 2026-03-13 09:25:26 | materials | 4 | 165329 | 645 | 69.143 | 2391.1 |
| 577 | 2026-03-10 07:37:15 | materials | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 576 | 2026-03-09 20:22:20 | materials | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 575 | 2026-03-05 08:51:05 | materials | 4 | 165329 | 645 | 24.296 | 6804.8 |
| 574 | 2026-03-01 18:55:59 | materials | 4 | 165329 | 645 | 12.860 | 12856.1 |
| 573 | 2026-03-01 03:36:03 | materials | 3 | 148641 | 81 | 7.643 | 19448.0 |
| 572 | 2026-02-27 04:24:21 | materials | 4 | 165329 | 645 | 80.483 | 2054.2 |
| 571 | 2026-02-22 14:13:51 | materials | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 570 | 2026-02-12 01:43:25 | materials | 4 | 165329 | 645 | 30.143 | 5484.8 |
| 569 | 2026-02-10 18:14:55 | materials | 1 | 81242 | 3 | 2.813 | 28880.9 |
| 568 | 2026-02-10 11:28:18 | materials | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 567 | 2026-02-09 20:20:01 | materials | 2 | 121436 | 13 | 9.626 | 12615.4 |
| 566 | 2026-02-08 01:05:45 | materials | 4 | 165329 | 645 | 15.266 | 10829.9 |
| 565 | 2026-02-07 20:25:55 | materials | 4 | 165329 | 645 | 14.156 | 11679.1 |
| 564 | 2026-02-07 08:15:04 | materials | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 563 | 2026-02-02 23:31:24 | materials | 3 | 148641 | 81 | 20.110 | 7391.4 |
| 562 | 2026-02-01 18:27:20 | materials | 4 | 165329 | 645 | 65.206 | 2535.5 |
| 561 | 2026-02-01 00:52:05 | materials | 2 | 121436 | 13 | 3.766 | 32245.4 |
| 560 | 2026-01-28 11:51:32 | materials | 3 | 148641 | 81 | 23.500 | 6325.1 |
| 559 | 2026-01-28 07:07:08 | materials | 4 | 165329 | 645 | 13.420 | 12319.6 |
| 558 | 2026-01-27 17:09:40 | materials | 3 | 148641 | 81 | 10.533 | 14111.9 |
| 557 | 2026-01-26 18:02:14 | materials | 4 | 165329 | 645 | 16.483 | 10030.3 |
| 556 | 2026-01-26 13:37:15 | materials | 4 | 165329 | 645 | 69.066 | 2393.8 |
| 555 | 2026-01-25 23:58:52 | materials | 2 | 121436 | 13 | 3.593 | 33797.9 |
| 554 | 2026-01-25 15:31:49 | materials | 4 | 165329 | 645 | 14.263 | 11591.5 |
| 553 | 2026-01-25 15:30:48 | materials | 4 | 165329 | 645 | 20.143 | 8207.8 |
| 552 | 2026-01-23 20:19:20 | materials | 4 | 165329 | 645 | 13.876 | 11914.7 |
| 551 | 2026-01-23 03:08:40 | materials | 4 | 165329 | 645 | 31.753 | 5206.7 |
| 550 | 2026-01-23 02:34:20 | materials | 4 | 165329 | 645 | 13.576 | 12178.0 |
| 549 | 2026-01-22 07:30:09 | materials | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 548 | 2026-01-21 19:29:16 | materials | 1 | 81242 | 3 | 3.890 | 20884.8 |
| 547 | 2026-01-20 14:07:18 | materials | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 546 | 2026-01-20 14:06:27 | materials | 1 | 81242 | 3 | 3.186 | 25499.7 |
| 545 | 2026-01-19 07:34:15 | materials | 2 | 121436 | 13 | 4.986 | 24355.4 |
| 544 | 2026-01-19 05:15:15 | materials | 2 | 121436 | 13 | 3.936 | 30852.6 |
| 543 | 2026-01-16 14:43:04 | materials | 2 | 121436 | 13 | 3.830 | 31706.5 |
| 542 | 2026-01-16 04:53:55 | materials | 2 | 121436 | 13 | 3.360 | 36141.7 |
| 541 | 2026-01-15 01:12:10 | materials | 2 | 121436 | 13 | 3.623 | 33518.1 |
| 540 | 2026-01-14 16:34:29 | materials | 2 | 121436 | 13 | 6.063 | 20029.0 |
| 539 | 2026-01-11 20:22:22 | materials | 3 | 148641 | 81 | 26.250 | 5662.5 |
| 538 | 2026-01-11 20:13:53 | materials | 3 | 148641 | 81 | 9.953 | 14934.3 |
| 537 | 2026-01-10 14:13:25 | materials | 3 | 148641 | 81 | 8.266 | 17982.2 |
| 536 | 2025-12-26 23:25:29 | materials | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 535 | 2025-12-26 18:45:51 | materials | 1 | 81242 | 3 | 1.560 | 52078.2 |
| 534 | 2025-12-20 00:10:17 | materials | 3 | 148641 | 81 | 19.160 | 7757.9 |
| 533 | 2025-12-15 20:33:16 | materials | 3 | 148641 | 81 | 27.910 | 5325.7 |
| 532 | 2025-11-29 23:22:15 | materials | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 531 | 2025-11-27 13:29:31 | materials | 1 | 81242 | 3 | 2.046 | 39707.7 |
| 530 | 2025-11-26 15:29:25 | materials | 2 | 121436 | 13 | 3.626 | 33490.3 |
| 529 | 2025-11-25 19:51:41 | materials | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 528 | 2025-11-24 13:34:10 | materials | 1 | 81242 | 3 | 1.640 | 49537.8 |
| 527 | 2025-11-24 10:03:38 | materials | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 526 | 2025-11-15 19:45:11 | materials | 1 | 81242 | 3 | 2.626 | 30937.5 |
| 525 | 2025-11-08 10:49:45 | materials | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 524 | 2025-10-30 23:17:23 | materials | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 523 | 2025-10-29 01:40:15 | materials | 1 | 81242 | 3 | 1.560 | 52078.2 |
| 522 | 2025-10-28 00:36:11 | materials | 1 | 81242 | 3 | 1.450 | 56029.0 |
| 521 | 2025-10-27 14:38:24 | materials | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 520 | 2025-10-25 13:19:30 | materials | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 519 | 2025-10-16 01:53:55 | materials | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 518 | 2025-09-29 13:24:13 | materials | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 517 | 2025-09-26 14:10:58 | materials | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 516 | 2025-09-25 00:21:26 | materials | 1 | 81242 | 3 | 3.233 | 25129.0 |
| 515 | 2025-09-24 23:34:49 | materials | 1 | 81242 | 3 | 4.690 | 17322.4 |
| 514 | 2025-09-24 20:55:20 | materials | 1 | 81242 | 3 | 1.533 | 52995.4 |
| 513 | 2025-09-23 21:25:55 | materials | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 512 | 2025-09-23 14:29:08 | materials | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 511 | 2025-09-23 10:59:50 | materials | 2 | 121436 | 13 | 3.326 | 36511.1 |
| 510 | 2025-09-22 13:17:02 | materials | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 509 | 2025-09-21 23:18:11 | materials | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 508 | 2025-09-10 14:36:00 | materials | 2 | 121436 | 13 | 3.250 | 37364.9 |
| 507 | 2025-09-09 18:04:36 | materials | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 506 | 2025-08-30 02:09:45 | materials | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 505 | 2025-08-25 16:31:40 | materials | 1 | 81242 | 3 | 5.013 | 16206.3 |
| 504 | 2025-08-17 13:02:11 | materials | 1 | 81242 | 3 | 3.293 | 24671.1 |
| 503 | 2025-08-11 21:58:23 | materials | 3 | 148641 | 81 | 17.390 | 8547.5 |
| 502 | 2025-08-11 13:11:06 | materials | 1 | 81242 | 3 | 3.423 | 23734.2 |
| 501 | 2025-08-11 10:31:33 | materials | 3 | 148641 | 81 | 38.003 | 3911.3 |
| 500 | 2025-08-11 10:24:15 | materials | 2 | 121436 | 13 | 18.046 | 6729.2 |
| 499 | 2025-08-08 23:26:42 | materials | 1 | 81242 | 3 | 1.640 | 49537.8 |
| 498 | 2025-08-05 14:49:52 | materials | 1 | 81242 | 3 | 3.360 | 24179.2 |
| 497 | 2025-08-03 23:52:14 | materials | 1 | 81242 | 3 | 6.063 | 13399.6 |
| 496 | 2025-07-27 00:27:33 | materials | 1 | 81242 | 3 | 3.360 | 24179.2 |
| 495 | 2025-07-25 09:54:34 | materials | 1 | 81242 | 3 | 2.953 | 27511.7 |
| 494 | 2025-07-24 02:22:20 | materials | 1 | 81242 | 3 | 7.610 | 10675.7 |
| 493 | 2025-07-22 21:55:05 | materials | 1 | 81242 | 3 | 3.266 | 24875.1 |
| 492 | 2025-07-17 21:48:11 | materials | 1 | 81242 | 3 | 3.156 | 25742.1 |