History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piscary"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 605 | 2025-10-22 18:52:02 | piscary | 1 | 69583 | 1 | 2.826 | 24622.4 |
| 604 | 2025-10-16 03:07:40 | piscary | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 603 | 2025-10-14 17:23:06 | piscary | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 602 | 2025-10-14 06:59:30 | piscary | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 601 | 2025-10-09 14:05:47 | piscary | 1 | 69583 | 1 | 1.470 | 47335.4 |
| 600 | 2025-10-03 02:24:27 | piscary | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 599 | 2025-09-29 17:27:34 | piscary | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 598 | 2025-09-26 05:52:12 | piscary | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 597 | 2025-09-19 19:07:19 | piscary | 2 | 107671 | 9 | 4.016 | 26810.5 |
| 596 | 2025-09-18 22:24:50 | piscary | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 595 | 2025-09-18 02:45:36 | piscary | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 594 | 2025-09-09 10:26:29 | piscary | 1 | 69583 | 1 | 1.546 | 45008.4 |
| 593 | 2025-09-02 02:37:34 | piscary | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 592 | 2025-08-25 09:14:27 | piscary | 1 | 69583 | 1 | 5.376 | 12943.3 |
| 591 | 2025-08-18 16:48:53 | piscary | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 590 | 2025-08-04 00:51:23 | piscary | 1 | 69583 | 1 | 3.690 | 18857.2 |
| 589 | 2025-08-03 22:42:45 | piscary | 1 | 69583 | 1 | 3.660 | 19011.7 |
| 588 | 2025-08-03 02:23:29 | piscary | 1 | 69583 | 1 | 3.940 | 17660.7 |
| 587 | 2025-07-27 18:40:31 | piscary | 1 | 69583 | 1 | 4.440 | 15671.8 |
| 586 | 2025-07-24 05:11:00 | piscary | 1 | 69583 | 1 | 5.796 | 12005.3 |
| 585 | 2025-07-17 12:00:47 | piscary | 1 | 69583 | 1 | 6.503 | 10700.1 |
| 584 | 2025-07-17 02:12:09 | piscary | 1 | 69583 | 1 | 7.563 | 9200.4 |
| 583 | 2025-07-12 04:50:57 | piscary | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 582 | 2025-07-10 02:48:46 | piscary | 3 | 134027 | 116 | 25.330 | 5291.2 |
| 581 | 2025-07-08 19:07:30 | piscary | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 580 | 2025-07-08 11:35:13 | piscary | 1 | 69583 | 1 | 7.486 | 9295.1 |
| 579 | 2025-07-07 07:13:17 | piscary | 1 | 69583 | 1 | 3.406 | 20429.5 |
| 578 | 2025-07-05 02:23:33 | piscary | 3 | 134027 | 116 | 22.703 | 5903.5 |
| 577 | 2025-07-04 22:09:30 | piscary | 2 | 107671 | 9 | 24.533 | 4388.8 |
| 576 | 2025-07-03 21:47:41 | piscary | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 575 | 2025-06-28 00:58:31 | piscary | 1 | 69583 | 1 | 7.360 | 9454.2 |
| 574 | 2025-06-27 14:58:46 | piscary | 1 | 69583 | 1 | 6.016 | 11566.3 |
| 573 | 2025-06-26 08:03:51 | piscary | 1 | 69583 | 1 | 7.733 | 8998.2 |
| 572 | 2025-06-20 16:40:08 | piscary | 1 | 69583 | 1 | 5.796 | 12005.3 |
| 571 | 2025-06-14 01:20:44 | piscary | 1 | 69583 | 1 | 5.470 | 12720.8 |
| 570 | 2025-06-12 09:11:54 | piscary | 1 | 69583 | 1 | 2.890 | 24077.2 |
| 569 | 2025-06-10 00:49:17 | piscary | 1 | 69583 | 1 | 8.936 | 7786.8 |
| 568 | 2025-05-25 02:41:33 | piscary | 3 | 134027 | 116 | 7.266 | 18445.8 |
| 567 | 2025-05-24 23:42:09 | piscary | 2 | 107671 | 9 | 3.546 | 30364.1 |
| 566 | 2025-05-22 08:28:39 | piscary | 1 | 69583 | 1 | 7.106 | 9792.1 |
| 565 | 2025-05-14 01:47:49 | piscary | 1 | 69583 | 1 | 6.690 | 10401.0 |
| 564 | 2025-05-13 00:02:19 | piscary | 3 | 134027 | 116 | 30.766 | 4356.3 |
| 563 | 2025-05-12 08:15:01 | piscary | 3 | 134027 | 116 | 44.983 | 2979.5 |
| 562 | 2025-05-10 22:46:20 | piscary | 3 | 134027 | 116 | 60.770 | 2205.5 |
| 561 | 2025-05-09 09:13:45 | piscary | 1 | 69583 | 1 | 3.050 | 22814.1 |
| 560 | 2025-05-03 21:45:08 | piscary | 1 | 69583 | 1 | 5.986 | 11624.3 |
| 559 | 2025-04-22 06:24:45 | piscary | 1 | 69583 | 1 | 1.733 | 40151.8 |
| 558 | 2025-04-19 15:53:43 | piscary | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 557 | 2025-04-08 10:17:29 | piscary | 3 | 134027 | 116 | 28.596 | 4686.9 |
| 556 | 2025-04-08 09:26:18 | piscary | 3 | 134027 | 116 | 14.923 | 8981.2 |
| 555 | 2025-04-08 08:10:06 | piscary | 2 | 107671 | 9 | 12.550 | 8579.4 |
| 554 | 2025-04-07 10:45:34 | piscary | 1 | 69583 | 1 | 5.923 | 11747.9 |
| 553 | 2025-04-06 20:05:54 | piscary | 1 | 69583 | 1 | 9.016 | 7717.7 |
| 552 | 2025-04-02 01:50:03 | piscary | 2 | 107671 | 9 | 17.640 | 6103.8 |
| 551 | 2025-03-28 00:51:52 | piscary | 3 | 134027 | 116 | 25.830 | 5188.8 |
| 550 | 2025-03-27 13:25:51 | piscary | 3 | 134027 | 116 | 29.486 | 4545.4 |
| 549 | 2025-03-26 06:59:12 | piscary | 2 | 107671 | 9 | 3.016 | 35699.9 |
| 548 | 2025-03-25 22:43:01 | piscary | 3 | 134027 | 116 | 7.143 | 18763.4 |
| 547 | 2025-03-19 07:16:50 | piscary | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 546 | 2025-03-08 08:12:27 | piscary | 1 | 69583 | 1 | 5.216 | 13340.3 |
| 545 | 2025-03-07 08:07:36 | piscary | 3 | 134027 | 116 | 17.843 | 7511.5 |
| 544 | 2025-03-02 11:07:22 | piscary | 3 | 134027 | 116 | 23.736 | 5646.6 |
| 543 | 2025-02-28 06:11:11 | piscary | 3 | 134027 | 116 | 33.533 | 3996.9 |
| 542 | 2025-02-28 06:11:07 | piscary | 2 | 107671 | 9 | 13.903 | 7744.4 |
| 541 | 2025-02-27 05:43:58 | piscary | 1 | 69583 | 1 | 6.546 | 10629.9 |
| 540 | 2025-02-24 19:15:38 | piscary | 2 | 107671 | 9 | 24.376 | 4417.1 |
| 539 | 2025-02-23 23:56:39 | piscary | 3 | 134027 | 116 | 34.423 | 3893.5 |
| 538 | 2025-02-23 22:54:48 | piscary | 3 | 134027 | 116 | 42.126 | 3181.6 |
| 537 | 2025-02-23 22:28:18 | piscary | 3 | 134027 | 116 | 38.176 | 3510.8 |
| 536 | 2025-02-22 23:53:46 | piscary | 3 | 134027 | 116 | 29.673 | 4516.8 |
| 535 | 2025-02-22 23:53:42 | piscary | 2 | 107671 | 9 | 8.903 | 12093.8 |
| 534 | 2025-02-22 23:53:40 | piscary | 1 | 69583 | 1 | 3.126 | 22259.4 |
| 533 | 2025-02-22 10:06:53 | piscary | 1 | 69583 | 1 | 5.483 | 12690.7 |
| 532 | 2025-02-21 22:56:27 | piscary | 3 | 134027 | 116 | 35.546 | 3770.5 |
| 531 | 2025-02-10 15:23:59 | piscary | 2 | 107671 | 9 | 8.390 | 12833.3 |
| 530 | 2025-02-10 00:08:33 | piscary | 2 | 107671 | 9 | 16.436 | 6550.9 |
| 529 | 2025-02-10 00:08:17 | piscary | 1 | 69583 | 1 | 3.580 | 19436.6 |
| 528 | 2025-02-03 07:44:56 | piscary | 1 | 69583 | 1 | 8.376 | 8307.4 |
| 527 | 2025-01-19 06:32:04 | piscary | 3 | 134027 | 116 | 32.580 | 4113.8 |
| 526 | 2025-01-12 16:50:49 | piscary | 1 | 69583 | 1 | 3.966 | 17544.9 |
| 525 | 2025-01-03 17:19:45 | piscary | 3 | 134027 | 116 | 28.390 | 4720.9 |
| 524 | 2025-01-02 21:32:18 | piscary | 3 | 134027 | 116 | 43.330 | 3093.2 |
| 523 | 2025-01-02 21:32:20 | piscary | 2 | 107671 | 9 | 12.316 | 8742.4 |
| 522 | 2025-01-02 21:30:54 | piscary | 1 | 69583 | 1 | 5.813 | 11970.2 |
| 521 | 2025-01-01 17:13:34 | piscary | 1 | 69583 | 1 | 5.453 | 12760.5 |
| 520 | 2024-12-10 20:31:48 | piscary | 1 | 69583 | 1 | 6.940 | 10026.4 |
| 519 | 2024-12-02 13:36:57 | piscary | 2 | 107671 | 9 | 17.953 | 5997.4 |
| 518 | 2024-12-02 13:31:24 | piscary | 3 | 134027 | 116 | 7.390 | 18136.3 |
| 517 | 2024-12-01 09:06:27 | piscary | 3 | 134027 | 116 | 34.063 | 3934.7 |
| 516 | 2024-11-30 13:44:51 | piscary | 3 | 134027 | 116 | 35.380 | 3788.2 |
| 515 | 2024-11-30 13:44:53 | piscary | 2 | 107671 | 9 | 12.503 | 8611.6 |
| 514 | 2024-11-30 13:42:41 | piscary | 1 | 69583 | 1 | 2.890 | 24077.2 |
| 513 | 2024-11-10 15:37:42 | piscary | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 512 | 2024-10-28 05:06:04 | piscary | 1 | 69583 | 1 | 4.623 | 15051.5 |
| 511 | 2024-10-22 09:34:51 | piscary | 1 | 69583 | 1 | 8.766 | 7937.8 |
| 510 | 2024-10-21 20:22:33 | piscary | 1 | 69583 | 1 | 7.266 | 9576.5 |
| 509 | 2024-10-19 00:08:01 | piscary | 2 | 107671 | 9 | 16.623 | 6477.2 |
| 508 | 2024-10-18 16:36:53 | piscary | 1 | 69583 | 1 | 4.550 | 15293.0 |
| 507 | 2024-10-18 16:29:57 | piscary | 1 | 69583 | 1 | 3.780 | 18408.2 |
| 506 | 2024-10-18 16:24:18 | piscary | 2 | 107671 | 9 | 18.983 | 5672.0 |