History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"secretor"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 593 | 2025-10-24 10:32:30 | secretor | 1 | 82945 | 4 | 1.466 | 56579.1 |
| 592 | 2025-10-15 02:25:47 | secretor | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 591 | 2025-10-05 07:01:56 | secretor | 4 | 161609 | 584 | 11.940 | 13535.1 |
| 590 | 2025-10-04 15:53:22 | secretor | 3 | 146162 | 62 | 7.876 | 18557.9 |
| 589 | 2025-10-03 16:13:09 | secretor | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 588 | 2025-08-29 20:30:35 | secretor | 3 | 146162 | 62 | 6.920 | 21121.7 |
| 587 | 2025-08-27 06:05:43 | secretor | 1 | 82945 | 4 | 1.440 | 57600.7 |
| 586 | 2025-08-23 13:54:39 | secretor | 1 | 82945 | 4 | 8.326 | 9962.2 |
| 585 | 2025-08-22 23:10:00 | secretor | 3 | 146162 | 62 | 59.196 | 2469.1 |
| 584 | 2025-08-21 23:35:23 | secretor | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 583 | 2025-08-21 23:35:21 | secretor | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 582 | 2025-08-05 10:21:17 | secretor | 1 | 82945 | 4 | 3.263 | 25419.9 |
| 581 | 2025-08-04 22:07:37 | secretor | 1 | 82945 | 4 | 6.593 | 12580.8 |
| 580 | 2025-07-29 02:44:42 | secretor | 2 | 121059 | 15 | 9.720 | 12454.6 |
| 579 | 2025-07-25 07:21:27 | secretor | 1 | 82945 | 4 | 3.300 | 25134.8 |
| 578 | 2025-07-22 13:57:33 | secretor | 1 | 82945 | 4 | 3.893 | 21306.2 |
| 577 | 2025-07-22 03:10:39 | secretor | 1 | 82945 | 4 | 1.393 | 59544.1 |
| 576 | 2025-07-20 07:19:27 | secretor | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 575 | 2025-07-07 07:25:50 | secretor | 1 | 82945 | 4 | 4.406 | 18825.5 |
| 574 | 2025-07-05 14:43:20 | secretor | 1 | 82945 | 4 | 8.266 | 10034.5 |
| 573 | 2025-06-28 05:25:57 | secretor | 1 | 82945 | 4 | 5.876 | 14115.9 |
| 572 | 2025-06-23 19:35:12 | secretor | 1 | 82945 | 4 | 3.533 | 23477.2 |
| 571 | 2025-06-17 17:01:51 | secretor | 1 | 82945 | 4 | 1.513 | 54821.5 |
| 570 | 2025-06-14 11:45:00 | secretor | 1 | 82945 | 4 | 10.923 | 7593.6 |
| 569 | 2025-06-13 19:26:53 | secretor | 1 | 82945 | 4 | 4.890 | 16962.2 |
| 568 | 2025-06-10 17:02:49 | secretor | 1 | 82945 | 4 | 8.203 | 10111.5 |
| 567 | 2025-06-06 07:10:49 | secretor | 1 | 82945 | 4 | 6.170 | 13443.3 |
| 566 | 2025-06-05 09:47:56 | secretor | 2 | 121059 | 15 | 6.920 | 17494.1 |
| 565 | 2025-06-04 23:43:37 | secretor | 3 | 146162 | 62 | 40.266 | 3629.9 |
| 564 | 2025-06-04 10:47:27 | secretor | 1 | 82945 | 4 | 6.266 | 13237.3 |
| 563 | 2025-06-03 10:06:24 | secretor | 3 | 146162 | 62 | 15.643 | 9343.6 |
| 562 | 2025-06-03 08:03:34 | secretor | 2 | 121059 | 15 | 17.206 | 7035.9 |
| 561 | 2025-05-31 12:41:42 | secretor | 3 | 146162 | 62 | 23.406 | 6244.6 |
| 560 | 2025-05-31 01:47:29 | secretor | 1 | 82945 | 4 | 9.550 | 8685.3 |
| 559 | 2025-05-28 22:49:34 | secretor | 3 | 146162 | 62 | 22.893 | 6384.6 |
| 558 | 2025-05-26 17:42:13 | secretor | 3 | 146162 | 62 | 26.470 | 5521.8 |
| 557 | 2025-05-24 10:48:09 | secretor | 1 | 82945 | 4 | 6.046 | 13719.0 |
| 556 | 2025-05-21 16:31:16 | secretor | 1 | 82945 | 4 | 6.720 | 12343.0 |
| 555 | 2025-05-16 05:08:20 | secretor | 1 | 82945 | 4 | 4.593 | 18059.0 |
| 554 | 2025-05-04 11:27:20 | secretor | 1 | 82945 | 4 | 5.843 | 14195.6 |
| 553 | 2025-04-15 14:08:42 | secretor | 1 | 82945 | 4 | 7.016 | 11822.3 |
| 552 | 2025-03-29 14:04:53 | secretor | 1 | 82945 | 4 | 6.596 | 12575.0 |
| 551 | 2025-03-23 12:49:22 | secretor | 1 | 82945 | 4 | 10.186 | 8143.0 |
| 550 | 2025-03-20 08:46:36 | secretor | 1 | 82945 | 4 | 4.423 | 18753.1 |
| 549 | 2025-03-07 14:05:20 | secretor | 1 | 82945 | 4 | 7.296 | 11368.6 |
| 548 | 2025-02-25 21:58:04 | secretor | 1 | 82945 | 4 | 5.906 | 14044.2 |
| 547 | 2025-02-25 18:12:32 | secretor | 1 | 82945 | 4 | 3.673 | 22582.4 |
| 546 | 2025-02-05 20:16:47 | secretor | 3 | 146162 | 62 | 8.220 | 17781.3 |
| 545 | 2025-02-01 11:38:01 | secretor | 3 | 146162 | 62 | 7.110 | 20557.2 |
| 544 | 2025-01-28 11:34:55 | secretor | 3 | 146162 | 62 | 36.663 | 3986.6 |
| 543 | 2025-01-28 11:34:34 | secretor | 2 | 121059 | 15 | 17.626 | 6868.2 |
| 542 | 2025-01-27 22:29:21 | secretor | 3 | 146162 | 62 | 55.913 | 2614.1 |
| 541 | 2025-01-27 22:29:10 | secretor | 3 | 146162 | 62 | 30.690 | 4762.5 |
| 540 | 2025-01-27 22:29:08 | secretor | 2 | 121059 | 15 | 12.830 | 9435.6 |
| 539 | 2025-01-27 22:28:41 | secretor | 1 | 82945 | 4 | 6.343 | 13076.6 |
| 538 | 2025-01-26 18:52:59 | secretor | 1 | 82945 | 4 | 3.750 | 22118.7 |
| 537 | 2025-01-12 10:14:54 | secretor | 3 | 146162 | 62 | 35.223 | 4149.6 |
| 536 | 2025-01-05 12:24:19 | secretor | 2 | 121059 | 15 | 17.720 | 6831.8 |
| 535 | 2025-01-05 09:01:32 | secretor | 3 | 146162 | 62 | 15.953 | 9162.0 |
| 534 | 2025-01-03 14:27:19 | secretor | 2 | 121059 | 15 | 3.843 | 31501.2 |
| 533 | 2024-12-31 05:43:10 | secretor | 3 | 146162 | 62 | 39.673 | 3684.2 |
| 532 | 2024-12-28 06:21:54 | secretor | 3 | 146162 | 62 | 28.190 | 5184.9 |
| 531 | 2024-12-27 08:46:51 | secretor | 2 | 121059 | 15 | 3.593 | 33693.0 |
| 530 | 2024-12-27 07:20:27 | secretor | 3 | 146162 | 62 | 29.190 | 5007.3 |
| 529 | 2024-12-27 07:20:29 | secretor | 2 | 121059 | 15 | 12.143 | 9969.4 |
| 528 | 2024-12-27 07:20:14 | secretor | 3 | 146162 | 62 | 21.940 | 6661.9 |
| 527 | 2024-12-27 07:20:17 | secretor | 1 | 82945 | 4 | 6.563 | 12638.3 |
| 526 | 2024-12-27 02:53:09 | secretor | 1 | 82945 | 4 | 7.096 | 11689.0 |
| 525 | 2024-12-24 03:17:30 | secretor | 3 | 146162 | 62 | 40.236 | 3632.6 |
| 524 | 2024-12-23 18:09:16 | secretor | 3 | 146162 | 62 | 51.956 | 2813.2 |
| 523 | 2024-12-13 22:47:48 | secretor | 3 | 146162 | 62 | 39.723 | 3679.5 |
| 522 | 2024-12-06 00:50:06 | secretor | 1 | 82945 | 4 | 7.216 | 11494.6 |
| 521 | 2024-11-29 16:41:02 | secretor | 3 | 146162 | 62 | 41.940 | 3485.0 |
| 520 | 2024-11-29 15:23:04 | secretor | 3 | 146162 | 62 | 31.800 | 4596.3 |
| 519 | 2024-11-27 15:25:56 | secretor | 3 | 146162 | 62 | 7.093 | 20606.5 |
| 518 | 2024-11-27 00:52:21 | secretor | 3 | 146162 | 62 | 40.003 | 3653.8 |
| 517 | 2024-11-27 00:51:57 | secretor | 2 | 121059 | 15 | 18.830 | 6429.0 |
| 516 | 2024-11-27 00:51:55 | secretor | 1 | 82945 | 4 | 5.110 | 16231.9 |
| 515 | 2024-11-26 11:55:25 | secretor | 2 | 121059 | 15 | 14.580 | 8303.1 |
| 514 | 2024-11-26 11:55:15 | secretor | 1 | 82945 | 4 | 4.140 | 20035.0 |
| 513 | 2024-11-23 00:01:11 | secretor | 4 | 161609 | 584 | 87.880 | 1839.0 |
| 512 | 2024-11-22 11:06:52 | secretor | 4 | 161609 | 584 | 31.693 | 5099.2 |
| 511 | 2024-11-22 02:46:49 | secretor | 4 | 161609 | 584 | 66.143 | 2443.3 |
| 510 | 2024-11-21 21:38:10 | secretor | 4 | 161609 | 584 | 57.943 | 2789.1 |
| 509 | 2024-11-14 17:48:51 | secretor | 2 | 121059 | 15 | 18.936 | 6393.1 |
| 508 | 2024-11-14 17:47:23 | secretor | 1 | 82945 | 4 | 5.296 | 15661.8 |
| 507 | 2024-10-29 16:38:21 | secretor | 3 | 146162 | 62 | 21.890 | 6677.1 |
| 506 | 2024-10-28 15:56:45 | secretor | 3 | 146162 | 62 | 29.016 | 5037.3 |
| 505 | 2024-10-27 00:51:06 | secretor | 1 | 82945 | 4 | 5.876 | 14115.9 |
| 504 | 2024-10-23 13:08:50 | secretor | 3 | 146162 | 62 | 34.330 | 4257.6 |
| 503 | 2024-10-23 01:45:30 | secretor | 1 | 82945 | 4 | 3.750 | 22118.7 |
| 502 | 2024-10-23 01:23:00 | secretor | 1 | 82945 | 4 | 3.376 | 24569.0 |
| 501 | 2024-10-23 01:11:41 | secretor | 1 | 82945 | 4 | 7.263 | 11420.2 |
| 500 | 2024-10-23 01:05:10 | secretor | 1 | 82945 | 4 | 7.360 | 11269.7 |
| 499 | 2024-10-23 00:51:39 | secretor | 1 | 82945 | 4 | 7.343 | 11295.8 |
| 498 | 2024-10-23 00:47:12 | secretor | 1 | 82945 | 4 | 10.783 | 7692.2 |
| 497 | 2024-10-22 21:20:04 | secretor | 4 | 161609 | 584 | 72.270 | 2236.2 |
| 496 | 2024-10-22 21:20:02 | secretor | 3 | 146162 | 62 | 66.130 | 2210.2 |
| 495 | 2024-10-22 12:15:28 | secretor | 4 | 161609 | 584 | 58.420 | 2766.3 |
| 494 | 2024-10-22 02:19:21 | secretor | 4 | 161609 | 584 | 34.516 | 4682.1 |