History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pecten"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 595 | 2024-04-30 02:13:51 | pecten | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 594 | 2024-03-30 20:10:05 | pecten | 3 | 112716 | 618 | 19.173 | 5878.9 |
| 593 | 2024-03-30 05:36:57 | pecten | 3 | 112716 | 618 | 10.953 | 10290.9 |
| 592 | 2024-03-29 19:50:53 | pecten | 1 | 48755 | 3 | 1.060 | 45995.3 |
| 591 | 2024-03-28 07:29:05 | pecten | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 590 | 2024-03-28 07:28:58 | pecten | 3 | 112716 | 618 | 6.186 | 18221.1 |
| 589 | 2024-03-28 07:28:59 | pecten | 2 | 82551 | 33 | 4.766 | 17320.8 |
| 588 | 2024-03-28 07:28:55 | pecten | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 587 | 2024-02-26 03:48:01 | pecten | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 586 | 2024-01-26 23:50:53 | pecten | 1 | 48755 | 3 | 1.500 | 32503.3 |
| 585 | 2024-01-08 01:44:15 | pecten | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 584 | 2023-12-21 03:47:32 | pecten | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 583 | 2023-12-11 04:05:13 | pecten | 2 | 82551 | 33 | 2.486 | 33206.4 |
| 582 | 2023-11-30 09:40:17 | pecten | 3 | 112716 | 618 | 5.253 | 21457.5 |
| 581 | 2023-11-30 09:40:13 | pecten | 2 | 82551 | 33 | 2.216 | 37252.3 |
| 580 | 2023-11-26 06:10:08 | pecten | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 579 | 2023-11-14 13:02:28 | pecten | 3 | 112716 | 618 | 5.563 | 20261.7 |
| 578 | 2023-11-11 18:08:05 | pecten | 2 | 82551 | 33 | 2.530 | 32628.9 |
| 577 | 2023-11-11 13:13:35 | pecten | 3 | 112716 | 618 | 6.093 | 18499.3 |
| 576 | 2023-11-11 07:35:57 | pecten | 1 | 48755 | 3 | 1.610 | 30282.6 |
| 575 | 2023-11-11 00:10:24 | pecten | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 574 | 2023-11-10 05:14:09 | pecten | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 573 | 2023-11-07 09:30:44 | pecten | 3 | 112716 | 618 | 6.796 | 16585.6 |
| 572 | 2023-11-07 09:30:34 | pecten | 3 | 112716 | 618 | 10.063 | 11201.0 |
| 571 | 2023-11-07 09:30:28 | pecten | 2 | 82551 | 33 | 2.626 | 31436.0 |
| 570 | 2023-11-07 09:29:34 | pecten | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 569 | 2023-10-30 12:35:26 | pecten | 2 | 82551 | 33 | 2.483 | 33246.5 |
| 568 | 2023-10-30 12:35:15 | pecten | 3 | 112716 | 618 | 4.876 | 23116.5 |
| 567 | 2023-10-27 16:57:03 | pecten | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 566 | 2023-10-20 19:29:29 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 565 | 2023-10-18 00:01:41 | pecten | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 564 | 2023-10-11 19:14:51 | pecten | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 563 | 2023-10-08 08:16:17 | pecten | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 562 | 2023-10-04 12:42:33 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 561 | 2023-09-28 23:30:01 | pecten | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 560 | 2023-09-24 02:57:31 | pecten | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 559 | 2023-08-03 11:11:23 | pecten | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 558 | 2023-07-11 14:13:46 | pecten | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 557 | 2023-04-30 04:54:47 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 556 | 2023-03-20 18:18:46 | pecten | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 555 | 2023-02-21 10:38:07 | pecten | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 554 | 2022-12-19 01:51:01 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 553 | 2022-11-29 07:23:38 | pecten | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 552 | 2022-11-26 00:48:11 | pecten | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 551 | 2022-09-02 13:35:20 | pecten | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 550 | 2022-08-31 08:20:35 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 549 | 2022-08-02 10:10:37 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 548 | 2022-07-29 13:39:40 | pecten | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 547 | 2022-07-02 11:25:56 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 546 | 2022-04-27 03:49:43 | pecten | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 545 | 2022-04-13 16:13:42 | pecten | 1 | 48755 | 3 | 1.313 | 37132.5 |
| 544 | 2022-03-28 10:38:25 | pecten | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 543 | 2022-01-11 12:50:34 | pecten | 1 | 48755 | 3 | 0.940 | 51867.0 |
| 542 | 2021-12-12 19:34:45 | pecten | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 541 | 2021-12-07 16:58:05 | pecten | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 540 | 2021-11-19 22:09:35 | pecten | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 539 | 2021-11-17 19:59:46 | pecten | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 538 | 2021-10-01 10:01:40 | pecten | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 537 | 2021-09-29 08:13:10 | pecten | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 536 | 2021-09-10 00:44:20 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 535 | 2021-08-28 00:55:19 | pecten | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 534 | 2021-05-27 06:40:09 | pecten | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 533 | 2021-04-23 23:33:54 | pecten | 1 | 48755 | 3 | 1.860 | 26212.4 |
| 532 | 2021-03-26 00:22:42 | pecten | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 531 | 2021-02-28 05:04:22 | pecten | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 530 | 2021-02-21 23:26:24 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 529 | 2020-11-18 20:51:16 | pecten | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 528 | 2020-11-14 14:48:08 | pecten | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 527 | 2020-10-23 06:09:40 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 526 | 2020-10-21 17:32:34 | pecten | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 525 | 2020-10-14 14:00:38 | pecten | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 524 | 2020-10-14 00:09:58 | pecten | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 523 | 2020-08-25 05:47:47 | pecten | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 522 | 2020-08-15 18:51:46 | pecten | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 521 | 2020-08-09 03:18:52 | pecten | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 520 | 2020-05-14 12:06:29 | pecten | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 519 | 2020-03-27 21:20:32 | pecten | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 518 | 2020-03-26 10:17:43 | pecten | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 517 | 2020-03-25 04:48:54 | pecten | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 516 | 2020-03-24 19:15:16 | pecten | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 515 | 2020-03-24 02:35:37 | pecten | 1 | 48755 | 3 | 1.860 | 26212.4 |
| 514 | 2020-03-22 15:22:33 | pecten | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 513 | 2020-03-20 03:02:51 | pecten | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 512 | 2020-02-28 16:47:33 | pecten | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 511 | 2020-02-25 01:16:55 | pecten | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 510 | 2020-02-17 11:55:34 | pecten | 1 | 48755 | 3 | 1.830 | 26642.1 |
| 509 | 2020-02-08 23:49:43 | pecten | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 508 | 2020-02-06 14:29:09 | pecten | 1 | 48755 | 3 | 1.046 | 46610.9 |
| 507 | 2020-02-06 02:09:26 | pecten | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 506 | 2020-02-04 16:43:33 | pecten | 1 | 48755 | 3 | 2.750 | 17729.1 |
| 505 | 2020-02-02 21:54:16 | pecten | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 504 | 2020-01-29 10:03:27 | pecten | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 503 | 2020-01-27 22:59:22 | pecten | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 502 | 2020-01-23 22:35:26 | pecten | 1 | 48755 | 3 | 1.750 | 27860.0 |
| 501 | 2020-01-15 11:36:49 | pecten | 1 | 48755 | 3 | 0.986 | 49447.3 |
| 500 | 2020-01-15 06:17:05 | pecten | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 499 | 2020-01-12 11:13:13 | pecten | 1 | 48755 | 3 | 1.000 | 48755.0 |
| 498 | 2020-01-07 15:25:48 | pecten | 1 | 48755 | 3 | 1.890 | 25796.3 |
| 497 | 2019-12-27 05:37:59 | pecten | 1 | 48755 | 3 | 1.890 | 25796.3 |
| 496 | 2019-12-27 03:26:56 | pecten | 1 | 48755 | 3 | 0.890 | 54780.9 |