History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sweaters"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 595 | 2024-05-06 19:40:15 | sweaters | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 594 | 2024-05-05 19:36:27 | sweaters | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 593 | 2024-05-05 19:34:47 | sweaters | 2 | 121059 | 62 | 6.860 | 17647.1 |
| 592 | 2024-05-03 19:21:29 | sweaters | 3 | 146162 | 515 | 11.813 | 12373.0 |
| 591 | 2024-05-02 23:37:56 | sweaters | 3 | 146162 | 515 | 20.143 | 7256.2 |
| 590 | 2024-05-02 03:44:46 | sweaters | 3 | 146162 | 515 | 12.563 | 11634.3 |
| 589 | 2024-05-01 13:02:26 | sweaters | 2 | 121059 | 62 | 4.483 | 27004.0 |
| 588 | 2024-05-01 13:01:39 | sweaters | 1 | 82945 | 5 | 3.313 | 25036.2 |
| 587 | 2024-05-01 13:01:18 | sweaters | 3 | 146162 | 515 | 7.703 | 18974.7 |
| 586 | 2024-04-29 20:30:29 | sweaters | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 585 | 2024-04-29 17:55:02 | sweaters | 3 | 146162 | 515 | 14.016 | 10428.2 |
| 584 | 2024-04-29 09:02:39 | sweaters | 3 | 146162 | 515 | 13.813 | 10581.5 |
| 583 | 2024-04-15 17:18:27 | sweaters | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 582 | 2024-04-05 18:59:36 | sweaters | 1 | 82945 | 5 | 3.640 | 22787.1 |
| 581 | 2024-03-30 00:07:56 | sweaters | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 580 | 2024-03-28 22:20:55 | sweaters | 2 | 121059 | 62 | 10.046 | 12050.5 |
| 579 | 2024-03-28 22:16:50 | sweaters | 1 | 82945 | 5 | 4.750 | 17462.1 |
| 578 | 2024-03-11 02:14:39 | sweaters | 2 | 121059 | 62 | 15.016 | 8062.0 |
| 577 | 2024-03-10 22:23:40 | sweaters | 3 | 146162 | 515 | 7.766 | 18820.8 |
| 576 | 2024-03-09 07:20:11 | sweaters | 3 | 146162 | 515 | 21.970 | 6652.8 |
| 575 | 2024-03-07 10:53:44 | sweaters | 3 | 146162 | 515 | 23.613 | 6189.9 |
| 574 | 2024-03-06 21:27:23 | sweaters | 3 | 146162 | 515 | 16.906 | 8645.6 |
| 573 | 2024-03-04 07:37:54 | sweaters | 1 | 82945 | 5 | 1.796 | 46183.2 |
| 572 | 2024-03-01 16:20:54 | sweaters | 1 | 82945 | 5 | 3.126 | 26533.9 |
| 571 | 2024-02-26 06:06:28 | sweaters | 1 | 82945 | 5 | 2.346 | 35355.9 |
| 570 | 2024-02-17 19:43:57 | sweaters | 3 | 146162 | 515 | 11.000 | 13287.5 |
| 569 | 2024-02-15 00:24:47 | sweaters | 2 | 121059 | 62 | 8.483 | 14270.8 |
| 568 | 2024-02-14 21:21:21 | sweaters | 3 | 146162 | 515 | 9.140 | 15991.5 |
| 567 | 2024-02-12 00:28:06 | sweaters | 3 | 146162 | 515 | 25.046 | 5835.7 |
| 566 | 2024-02-12 00:28:03 | sweaters | 2 | 121059 | 62 | 8.126 | 14897.7 |
| 565 | 2024-02-09 20:23:34 | sweaters | 2 | 121059 | 62 | 3.953 | 30624.6 |
| 564 | 2024-02-09 20:20:33 | sweaters | 3 | 146162 | 515 | 8.580 | 17035.2 |
| 563 | 2024-02-05 11:37:59 | sweaters | 3 | 146162 | 515 | 18.313 | 7981.3 |
| 562 | 2024-01-30 05:22:53 | sweaters | 3 | 146162 | 515 | 11.346 | 12882.2 |
| 561 | 2024-01-29 00:34:31 | sweaters | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 560 | 2024-01-15 06:33:14 | sweaters | 3 | 146162 | 515 | 8.296 | 17618.4 |
| 559 | 2024-01-09 10:56:36 | sweaters | 3 | 146162 | 515 | 6.923 | 21112.5 |
| 558 | 2023-12-29 17:30:58 | sweaters | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 557 | 2023-12-29 09:52:14 | sweaters | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 556 | 2023-12-12 10:01:28 | sweaters | 3 | 146162 | 515 | 8.500 | 17195.5 |
| 555 | 2023-12-12 10:01:31 | sweaters | 2 | 121059 | 62 | 3.876 | 31233.0 |
| 554 | 2023-12-12 00:20:10 | sweaters | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 553 | 2023-11-16 20:58:18 | sweaters | 3 | 146162 | 515 | 7.440 | 19645.4 |
| 552 | 2023-11-01 08:15:44 | sweaters | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 551 | 2023-10-28 14:51:21 | sweaters | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 550 | 2023-10-20 04:55:12 | sweaters | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 549 | 2023-10-18 11:14:02 | sweaters | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 548 | 2023-10-16 02:01:16 | sweaters | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 547 | 2023-10-08 05:35:57 | sweaters | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 546 | 2023-09-27 08:08:30 | sweaters | 1 | 82945 | 5 | 1.466 | 56579.1 |
| 545 | 2023-09-14 21:08:56 | sweaters | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 544 | 2023-09-03 10:48:22 | sweaters | 3 | 146162 | 515 | 6.173 | 23677.6 |
| 543 | 2023-08-20 21:28:18 | sweaters | 3 | 146162 | 515 | 7.360 | 19859.0 |
| 542 | 2023-08-18 09:46:16 | sweaters | 3 | 146162 | 515 | 6.610 | 22112.3 |
| 541 | 2023-08-14 22:40:50 | sweaters | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 540 | 2023-08-09 05:06:24 | sweaters | 3 | 146162 | 515 | 12.500 | 11693.0 |
| 539 | 2023-08-08 09:06:06 | sweaters | 3 | 146162 | 515 | 6.406 | 22816.4 |
| 538 | 2023-08-06 20:32:47 | sweaters | 3 | 146162 | 515 | 6.406 | 22816.4 |
| 537 | 2023-08-02 23:09:45 | sweaters | 3 | 146162 | 515 | 6.626 | 22058.9 |
| 536 | 2023-07-29 15:59:19 | sweaters | 3 | 146162 | 515 | 7.313 | 19986.6 |
| 535 | 2023-07-15 15:40:51 | sweaters | 3 | 146162 | 515 | 6.843 | 21359.3 |
| 534 | 2023-07-14 18:25:30 | sweaters | 3 | 146162 | 515 | 7.106 | 20568.8 |
| 533 | 2023-07-01 23:36:38 | sweaters | 3 | 146162 | 515 | 6.796 | 21507.1 |
| 532 | 2023-06-23 00:05:48 | sweaters | 3 | 146162 | 515 | 7.296 | 20033.2 |
| 531 | 2023-05-31 12:21:25 | sweaters | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 530 | 2023-05-15 16:13:55 | sweaters | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 529 | 2023-05-01 05:08:40 | sweaters | 3 | 146162 | 515 | 6.923 | 21112.5 |
| 528 | 2023-03-11 12:46:36 | sweaters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 527 | 2023-02-10 16:22:26 | sweaters | 3 | 146162 | 515 | 6.186 | 23627.9 |
| 526 | 2023-02-06 14:21:47 | sweaters | 3 | 146162 | 515 | 6.156 | 23743.0 |
| 525 | 2023-02-04 03:29:46 | sweaters | 3 | 146162 | 515 | 7.266 | 20115.9 |
| 524 | 2023-01-29 00:23:36 | sweaters | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 523 | 2023-01-01 09:16:21 | sweaters | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 522 | 2022-12-13 09:18:12 | sweaters | 3 | 146162 | 515 | 7.516 | 19446.8 |
| 521 | 2022-11-18 17:47:55 | sweaters | 3 | 146162 | 515 | 6.266 | 23326.2 |
| 520 | 2022-09-26 14:27:09 | sweaters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 519 | 2022-09-19 05:49:20 | sweaters | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 518 | 2022-09-10 22:08:14 | sweaters | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 517 | 2022-08-15 05:58:07 | sweaters | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 516 | 2022-07-29 13:13:56 | sweaters | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 515 | 2022-07-29 07:53:47 | sweaters | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 514 | 2022-07-19 16:08:17 | sweaters | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 513 | 2022-07-18 01:14:02 | sweaters | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 512 | 2022-07-17 08:08:12 | sweaters | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 511 | 2022-07-12 05:03:33 | sweaters | 2 | 121059 | 62 | 7.986 | 15158.9 |
| 510 | 2022-07-11 10:26:51 | sweaters | 2 | 121059 | 62 | 6.656 | 18188.0 |
| 509 | 2022-07-10 16:52:23 | sweaters | 2 | 121059 | 62 | 4.143 | 29220.1 |
| 508 | 2022-07-10 12:11:04 | sweaters | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 507 | 2022-07-09 03:36:34 | sweaters | 2 | 121059 | 62 | 7.983 | 15164.6 |
| 506 | 2022-07-08 09:00:39 | sweaters | 2 | 121059 | 62 | 3.686 | 32842.9 |
| 505 | 2022-07-07 15:12:32 | sweaters | 2 | 121059 | 62 | 3.830 | 31608.1 |
| 504 | 2022-07-06 04:45:53 | sweaters | 2 | 121059 | 62 | 3.626 | 33386.4 |
| 503 | 2022-07-05 06:33:27 | sweaters | 2 | 121059 | 62 | 4.143 | 29220.1 |
| 502 | 2022-07-04 17:48:04 | sweaters | 2 | 121059 | 62 | 3.920 | 30882.4 |
| 501 | 2022-07-04 06:21:33 | sweaters | 2 | 121059 | 62 | 3.126 | 38726.5 |
| 500 | 2022-07-03 16:28:52 | sweaters | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 499 | 2022-07-03 05:43:50 | sweaters | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 498 | 2022-07-03 04:33:06 | sweaters | 2 | 121059 | 62 | 3.920 | 30882.4 |
| 497 | 2022-07-02 21:12:09 | sweaters | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 496 | 2022-07-02 04:25:34 | sweaters | 2 | 121059 | 62 | 3.890 | 31120.6 |