History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drummer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 608 | 2025-04-11 18:21:51 | drummer | 1 | 69583 | 5 | 4.300 | 16182.1 |
| 607 | 2025-04-11 03:01:58 | drummer | 1 | 69583 | 5 | 3.296 | 21111.3 |
| 606 | 2025-04-11 00:45:09 | drummer | 1 | 69583 | 5 | 7.236 | 9616.2 |
| 605 | 2025-04-03 17:03:21 | drummer | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 604 | 2025-03-31 01:55:22 | drummer | 1 | 69583 | 5 | 3.763 | 18491.4 |
| 603 | 2025-03-27 02:54:52 | drummer | 3 | 134027 | 315 | 35.546 | 3770.5 |
| 602 | 2025-03-25 08:58:10 | drummer | 3 | 134027 | 315 | 19.076 | 7025.9 |
| 601 | 2025-03-23 05:08:55 | drummer | 3 | 134027 | 315 | 50.846 | 2635.9 |
| 600 | 2025-03-22 03:40:40 | drummer | 3 | 134027 | 315 | 33.533 | 3996.9 |
| 599 | 2025-03-21 02:24:09 | drummer | 2 | 107671 | 41 | 17.156 | 6276.0 |
| 598 | 2025-03-21 01:03:27 | drummer | 3 | 134027 | 315 | 39.840 | 3364.1 |
| 597 | 2025-03-20 06:45:52 | drummer | 3 | 134027 | 315 | 24.533 | 5463.1 |
| 596 | 2025-03-19 11:42:39 | drummer | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 595 | 2025-03-13 03:10:37 | drummer | 1 | 69583 | 5 | 2.656 | 26198.4 |
| 594 | 2025-03-12 06:48:55 | drummer | 1 | 69583 | 5 | 5.530 | 12582.8 |
| 593 | 2025-02-23 11:00:02 | drummer | 1 | 69583 | 5 | 2.846 | 24449.4 |
| 592 | 2025-02-17 13:29:38 | drummer | 3 | 134027 | 315 | 32.123 | 4172.3 |
| 591 | 2025-02-11 05:46:53 | drummer | 1 | 69583 | 5 | 6.200 | 11223.1 |
| 590 | 2025-02-05 23:39:15 | drummer | 3 | 134027 | 315 | 29.346 | 4567.1 |
| 589 | 2025-02-05 21:26:48 | drummer | 2 | 107671 | 41 | 12.313 | 8744.5 |
| 588 | 2025-02-05 11:54:57 | drummer | 3 | 134027 | 315 | 34.940 | 3835.9 |
| 587 | 2025-02-05 06:44:53 | drummer | 3 | 134027 | 315 | 37.876 | 3538.6 |
| 586 | 2025-02-05 06:44:53 | drummer | 2 | 107671 | 41 | 15.716 | 6851.0 |
| 585 | 2025-02-05 06:25:52 | drummer | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 584 | 2025-02-04 18:34:23 | drummer | 1 | 69583 | 5 | 4.250 | 16372.5 |
| 583 | 2025-01-10 02:21:22 | drummer | 1 | 69583 | 5 | 4.733 | 14701.7 |
| 582 | 2025-01-05 19:02:06 | drummer | 3 | 134027 | 315 | 16.956 | 7904.4 |
| 581 | 2025-01-05 16:11:34 | drummer | 3 | 134027 | 315 | 30.266 | 4428.3 |
| 580 | 2025-01-05 11:08:38 | drummer | 3 | 134027 | 315 | 11.640 | 11514.3 |
| 579 | 2025-01-02 02:20:39 | drummer | 1 | 69583 | 5 | 3.500 | 19880.9 |
| 578 | 2024-12-26 12:27:56 | drummer | 3 | 134027 | 315 | 6.530 | 20524.8 |
| 577 | 2024-12-23 22:52:48 | drummer | 3 | 134027 | 315 | 36.766 | 3645.4 |
| 576 | 2024-12-04 20:20:39 | drummer | 3 | 134027 | 315 | 32.236 | 4157.7 |
| 575 | 2024-12-04 04:16:52 | drummer | 3 | 134027 | 315 | 27.846 | 4813.2 |
| 574 | 2024-12-03 23:32:00 | drummer | 3 | 134027 | 315 | 27.643 | 4848.5 |
| 573 | 2024-12-02 04:17:56 | drummer | 1 | 69583 | 5 | 5.516 | 12614.8 |
| 572 | 2024-11-25 12:16:20 | drummer | 3 | 134027 | 315 | 19.830 | 6758.8 |
| 571 | 2024-11-12 00:53:00 | drummer | 3 | 134027 | 315 | 5.876 | 22809.2 |
| 570 | 2024-11-04 20:10:23 | drummer | 3 | 134027 | 315 | 30.453 | 4401.1 |
| 569 | 2024-11-03 22:40:55 | drummer | 3 | 134027 | 315 | 28.660 | 4676.4 |
| 568 | 2024-11-02 17:35:02 | drummer | 3 | 134027 | 315 | 34.536 | 3880.8 |
| 567 | 2024-11-02 17:35:00 | drummer | 2 | 107671 | 41 | 23.050 | 4671.2 |
| 566 | 2024-11-02 07:36:39 | drummer | 3 | 134027 | 315 | 28.516 | 4700.1 |
| 565 | 2024-11-02 07:36:41 | drummer | 2 | 107671 | 41 | 15.626 | 6890.5 |
| 564 | 2024-11-02 07:35:43 | drummer | 1 | 69583 | 5 | 5.406 | 12871.4 |
| 563 | 2024-10-27 07:53:15 | drummer | 1 | 69583 | 5 | 3.060 | 22739.5 |
| 562 | 2024-10-24 11:01:04 | drummer | 1 | 69583 | 5 | 2.986 | 23303.1 |
| 561 | 2024-10-20 17:42:29 | drummer | 1 | 69583 | 5 | 5.530 | 12582.8 |
| 560 | 2024-10-01 13:41:45 | drummer | 1 | 69583 | 5 | 8.013 | 8683.8 |
| 559 | 2024-09-28 02:30:52 | drummer | 1 | 69583 | 5 | 16.906 | 4115.9 |
| 558 | 2024-09-21 15:28:26 | drummer | 3 | 134027 | 315 | 58.410 | 2294.6 |
| 557 | 2024-09-18 20:48:41 | drummer | 3 | 134027 | 315 | 44.253 | 3028.7 |
| 556 | 2024-09-18 12:02:13 | drummer | 3 | 134027 | 315 | 39.970 | 3353.2 |
| 555 | 2024-09-18 12:01:48 | drummer | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 554 | 2024-09-17 09:03:51 | drummer | 1 | 69583 | 5 | 8.470 | 8215.2 |
| 553 | 2024-08-27 02:50:48 | drummer | 1 | 69583 | 5 | 8.640 | 8053.6 |
| 552 | 2024-08-27 02:48:07 | drummer | 1 | 69583 | 5 | 8.940 | 7783.3 |
| 551 | 2024-08-14 01:20:38 | drummer | 1 | 69583 | 5 | 7.533 | 9237.1 |
| 550 | 2024-08-13 15:18:35 | drummer | 1 | 69583 | 5 | 4.013 | 17339.4 |
| 549 | 2024-08-13 09:55:16 | drummer | 1 | 69583 | 5 | 6.623 | 10506.3 |
| 548 | 2024-08-12 19:39:08 | drummer | 1 | 69583 | 5 | 4.436 | 15686.0 |
| 547 | 2024-08-08 22:55:01 | drummer | 2 | 107671 | 41 | 11.516 | 9349.7 |
| 546 | 2024-08-08 16:50:58 | drummer | 2 | 107671 | 41 | 6.373 | 16894.9 |
| 545 | 2024-08-07 17:47:26 | drummer | 3 | 134027 | 315 | 25.490 | 5258.0 |
| 544 | 2024-08-06 17:28:34 | drummer | 1 | 69583 | 5 | 4.546 | 15306.4 |
| 543 | 2024-08-06 17:27:44 | drummer | 2 | 107671 | 41 | 5.623 | 19148.3 |
| 542 | 2024-08-05 05:12:54 | drummer | 2 | 107671 | 41 | 6.533 | 16481.1 |
| 541 | 2024-07-31 04:19:50 | drummer | 3 | 134027 | 315 | 20.613 | 6502.1 |
| 540 | 2024-07-30 20:49:13 | drummer | 3 | 134027 | 315 | 26.176 | 5120.2 |
| 539 | 2024-07-30 18:49:50 | drummer | 2 | 107671 | 41 | 12.080 | 8913.2 |
| 538 | 2024-07-30 18:25:31 | drummer | 3 | 134027 | 315 | 15.910 | 8424.1 |
| 537 | 2024-07-30 17:36:22 | drummer | 3 | 134027 | 315 | 21.876 | 6126.7 |
| 536 | 2024-07-30 17:36:25 | drummer | 2 | 107671 | 41 | 12.313 | 8744.5 |
| 535 | 2024-07-26 20:56:29 | drummer | 1 | 69583 | 5 | 6.703 | 10380.9 |
| 534 | 2024-07-10 00:03:31 | drummer | 1 | 69583 | 5 | 4.563 | 15249.4 |
| 533 | 2024-07-07 04:42:55 | drummer | 1 | 69583 | 5 | 2.203 | 31585.6 |
| 532 | 2024-07-06 08:20:12 | drummer | 1 | 69583 | 5 | 1.873 | 37150.6 |
| 531 | 2024-07-01 19:35:34 | drummer | 1 | 69583 | 5 | 3.906 | 17814.4 |
| 530 | 2024-07-01 03:05:48 | drummer | 2 | 107671 | 41 | 12.563 | 8570.5 |
| 529 | 2024-07-01 02:49:41 | drummer | 1 | 69583 | 5 | 12.330 | 5643.4 |
| 528 | 2024-06-29 16:14:22 | drummer | 2 | 107671 | 41 | 7.110 | 15143.6 |
| 527 | 2024-06-29 16:14:15 | drummer | 1 | 69583 | 5 | 3.000 | 23194.3 |
| 526 | 2024-06-25 01:25:09 | drummer | 1 | 69583 | 5 | 2.936 | 23699.9 |
| 525 | 2024-06-21 22:29:07 | drummer | 1 | 69583 | 5 | 6.220 | 11187.0 |
| 524 | 2024-06-17 19:11:50 | drummer | 1 | 69583 | 5 | 6.203 | 11217.6 |
| 523 | 2024-06-06 15:53:11 | drummer | 3 | 134027 | 315 | 30.986 | 4325.4 |
| 522 | 2024-06-06 10:11:21 | drummer | 2 | 107671 | 41 | 4.453 | 24179.4 |
| 521 | 2024-06-06 10:09:21 | drummer | 3 | 134027 | 315 | 8.983 | 14920.1 |
| 520 | 2024-06-03 11:39:14 | drummer | 3 | 134027 | 315 | 26.580 | 5042.4 |
| 519 | 2024-06-02 01:43:43 | drummer | 2 | 107671 | 41 | 3.390 | 31761.4 |
| 518 | 2024-06-02 01:43:03 | drummer | 3 | 134027 | 315 | 6.673 | 20085.0 |
| 517 | 2024-06-01 22:07:07 | drummer | 3 | 134027 | 315 | 7.593 | 17651.4 |
| 516 | 2024-05-29 22:46:15 | drummer | 1 | 69583 | 5 | 3.563 | 19529.3 |
| 515 | 2024-05-16 14:37:47 | drummer | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 514 | 2024-05-05 18:41:21 | drummer | 3 | 134027 | 315 | 13.940 | 9614.6 |
| 513 | 2024-05-05 16:54:20 | drummer | 3 | 134027 | 315 | 11.623 | 11531.2 |
| 512 | 2024-05-05 01:41:04 | drummer | 3 | 134027 | 315 | 15.830 | 8466.6 |
| 511 | 2024-05-02 03:24:18 | drummer | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 510 | 2024-04-28 17:33:53 | drummer | 3 | 134027 | 315 | 9.623 | 13927.8 |
| 509 | 2024-04-27 20:25:05 | drummer | 3 | 134027 | 315 | 22.440 | 5972.7 |