History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"emitters"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 613 | 2024-05-04 10:37:01 | emitters | 2 | 121059 | 50 | 4.143 | 29220.1 |
| 612 | 2024-05-04 10:36:41 | emitters | 3 | 146162 | 358 | 7.860 | 18595.7 |
| 611 | 2024-05-01 23:08:38 | emitters | 2 | 121059 | 50 | 3.606 | 33571.5 |
| 610 | 2024-05-01 00:22:10 | emitters | 2 | 121059 | 50 | 7.876 | 15370.6 |
| 609 | 2024-04-30 08:07:53 | emitters | 3 | 146162 | 358 | 10.283 | 14213.9 |
| 608 | 2024-04-28 16:05:34 | emitters | 2 | 121059 | 50 | 4.203 | 28803.0 |
| 607 | 2024-04-28 16:05:09 | emitters | 3 | 146162 | 358 | 7.936 | 18417.6 |
| 606 | 2024-04-27 21:32:08 | emitters | 2 | 121059 | 50 | 8.986 | 13472.0 |
| 605 | 2024-04-27 21:30:22 | emitters | 1 | 82945 | 5 | 2.483 | 33405.2 |
| 604 | 2024-04-27 15:02:22 | emitters | 3 | 146162 | 358 | 7.623 | 19173.8 |
| 603 | 2024-04-27 13:53:10 | emitters | 3 | 146162 | 358 | 12.970 | 11269.2 |
| 602 | 2024-04-27 08:59:46 | emitters | 3 | 146162 | 358 | 9.766 | 14966.4 |
| 601 | 2024-04-06 10:27:29 | emitters | 1 | 82945 | 5 | 3.953 | 20982.8 |
| 600 | 2024-03-29 23:45:40 | emitters | 2 | 121059 | 50 | 4.420 | 27388.9 |
| 599 | 2024-03-29 21:55:45 | emitters | 1 | 82945 | 5 | 2.953 | 28088.4 |
| 598 | 2024-03-29 05:50:24 | emitters | 2 | 121059 | 50 | 15.126 | 8003.4 |
| 597 | 2024-03-28 22:11:00 | emitters | 3 | 146162 | 358 | 12.140 | 12039.7 |
| 596 | 2024-03-28 11:26:09 | emitters | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 595 | 2024-03-28 11:25:47 | emitters | 3 | 146162 | 358 | 7.530 | 19410.6 |
| 594 | 2024-03-28 11:25:47 | emitters | 2 | 121059 | 50 | 3.766 | 32145.2 |
| 593 | 2024-03-28 11:25:42 | emitters | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 592 | 2024-03-03 15:26:11 | emitters | 1 | 82945 | 5 | 4.763 | 17414.4 |
| 591 | 2024-02-28 12:35:50 | emitters | 1 | 82945 | 5 | 2.170 | 38223.5 |
| 590 | 2024-02-08 09:56:09 | emitters | 2 | 121059 | 50 | 11.110 | 10896.4 |
| 589 | 2024-02-05 04:12:14 | emitters | 2 | 121059 | 50 | 7.860 | 15401.9 |
| 588 | 2024-02-05 04:11:53 | emitters | 3 | 146162 | 358 | 8.076 | 18098.3 |
| 587 | 2024-02-04 21:19:50 | emitters | 2 | 121059 | 50 | 4.016 | 30144.2 |
| 586 | 2024-02-04 06:46:42 | emitters | 2 | 121059 | 50 | 6.436 | 18809.7 |
| 585 | 2024-02-03 16:56:54 | emitters | 3 | 146162 | 358 | 6.736 | 21698.6 |
| 584 | 2024-01-21 12:07:05 | emitters | 3 | 146162 | 358 | 6.483 | 22545.4 |
| 583 | 2024-01-15 01:21:59 | emitters | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 582 | 2023-12-22 14:25:32 | emitters | 3 | 146162 | 358 | 7.406 | 19735.6 |
| 581 | 2023-12-22 14:25:33 | emitters | 2 | 121059 | 50 | 3.720 | 32542.7 |
| 580 | 2023-11-22 13:19:20 | emitters | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 579 | 2023-11-21 20:27:46 | emitters | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 578 | 2023-11-12 04:45:14 | emitters | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 577 | 2023-11-11 00:38:22 | emitters | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 576 | 2023-11-05 12:09:51 | emitters | 1 | 82945 | 5 | 1.826 | 45424.4 |
| 575 | 2023-10-19 06:13:22 | emitters | 1 | 82945 | 5 | 2.953 | 28088.4 |
| 574 | 2023-08-30 10:14:08 | emitters | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 573 | 2023-07-27 17:38:06 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 572 | 2023-07-27 08:17:16 | emitters | 3 | 146162 | 358 | 7.423 | 19690.4 |
| 571 | 2023-07-13 07:00:56 | emitters | 3 | 146162 | 358 | 12.156 | 12023.9 |
| 570 | 2023-06-04 02:30:27 | emitters | 1 | 82945 | 5 | 1.236 | 67107.6 |
| 569 | 2023-05-29 13:46:19 | emitters | 3 | 146162 | 358 | 6.563 | 22270.6 |
| 568 | 2023-05-01 05:20:32 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 567 | 2023-04-26 20:37:32 | emitters | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 566 | 2023-03-28 09:37:43 | emitters | 1 | 82945 | 5 | 1.236 | 67107.6 |
| 565 | 2023-03-20 01:55:23 | emitters | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 564 | 2023-03-13 21:19:16 | emitters | 3 | 146162 | 358 | 7.453 | 19611.2 |
| 563 | 2023-03-04 13:59:08 | emitters | 3 | 146162 | 358 | 6.123 | 23871.0 |
| 562 | 2023-01-19 23:21:59 | emitters | 3 | 146162 | 358 | 6.546 | 22328.4 |
| 561 | 2023-01-14 12:06:17 | emitters | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 560 | 2023-01-11 09:03:46 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 559 | 2023-01-10 11:42:20 | emitters | 3 | 146162 | 358 | 6.220 | 23498.7 |
| 558 | 2023-01-05 09:44:26 | emitters | 3 | 146162 | 358 | 6.843 | 21359.3 |
| 557 | 2022-12-18 15:19:14 | emitters | 3 | 146162 | 358 | 6.186 | 23627.9 |
| 556 | 2022-12-10 10:53:52 | emitters | 3 | 146162 | 358 | 7.186 | 20339.8 |
| 555 | 2022-12-05 23:18:08 | emitters | 3 | 146162 | 358 | 6.483 | 22545.4 |
| 554 | 2022-11-12 19:54:34 | emitters | 3 | 146162 | 358 | 6.140 | 23804.9 |
| 553 | 2022-10-29 05:06:39 | emitters | 3 | 146162 | 358 | 7.580 | 19282.6 |
| 552 | 2022-10-25 13:18:24 | emitters | 3 | 146162 | 358 | 6.533 | 22372.9 |
| 551 | 2022-10-20 00:40:28 | emitters | 3 | 146162 | 358 | 7.123 | 20519.7 |
| 550 | 2022-10-19 01:12:44 | emitters | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 549 | 2022-10-01 11:25:08 | emitters | 3 | 146162 | 358 | 6.436 | 22710.1 |
| 548 | 2022-09-30 12:40:54 | emitters | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 547 | 2022-09-26 21:44:54 | emitters | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 546 | 2022-09-18 01:30:51 | emitters | 3 | 146162 | 358 | 6.250 | 23385.9 |
| 545 | 2022-09-06 07:58:43 | emitters | 3 | 146162 | 358 | 6.766 | 21602.4 |
| 544 | 2022-08-18 04:46:27 | emitters | 3 | 146162 | 358 | 6.750 | 21653.6 |
| 543 | 2022-08-14 05:25:48 | emitters | 3 | 146162 | 358 | 6.203 | 23563.1 |
| 542 | 2022-08-13 10:35:17 | emitters | 3 | 146162 | 358 | 6.360 | 22981.4 |
| 541 | 2022-07-28 10:00:40 | emitters | 3 | 146162 | 358 | 7.143 | 20462.3 |
| 540 | 2022-06-28 08:15:52 | emitters | 3 | 146162 | 358 | 6.423 | 22756.0 |
| 539 | 2022-06-19 03:04:37 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 538 | 2022-06-18 19:36:00 | emitters | 1 | 82945 | 5 | 1.220 | 67987.7 |
| 537 | 2022-06-09 22:34:59 | emitters | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 536 | 2022-06-06 16:33:22 | emitters | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 535 | 2022-06-02 08:52:16 | emitters | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 534 | 2022-05-06 14:29:00 | emitters | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 533 | 2022-02-26 09:28:31 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 532 | 2022-02-22 23:32:59 | emitters | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 531 | 2022-02-16 14:06:12 | emitters | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 530 | 2021-12-05 20:52:26 | emitters | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 529 | 2021-12-03 19:03:58 | emitters | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 528 | 2021-11-18 03:56:05 | emitters | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 527 | 2021-10-29 14:45:12 | emitters | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 526 | 2021-09-03 14:16:57 | emitters | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 525 | 2021-08-18 15:36:59 | emitters | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 524 | 2021-07-28 11:19:07 | emitters | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 523 | 2021-07-23 06:25:54 | emitters | 3 | 146162 | 358 | 7.233 | 20207.7 |
| 522 | 2021-06-26 18:20:02 | emitters | 1 | 82945 | 5 | 1.643 | 50483.9 |
| 521 | 2021-05-15 15:41:01 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 520 | 2021-05-14 16:29:43 | emitters | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 519 | 2021-05-13 08:13:21 | emitters | 3 | 146162 | 358 | 7.140 | 20470.9 |
| 518 | 2021-05-09 12:38:02 | emitters | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 517 | 2021-02-25 03:53:27 | emitters | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 516 | 2021-02-21 06:45:11 | emitters | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 515 | 2021-02-19 02:35:04 | emitters | 3 | 146162 | 358 | 8.110 | 18022.4 |
| 514 | 2021-02-11 16:25:59 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |