History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trainers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 606 | 2024-04-25 14:37:04 | trainers | 3 | 146162 | 520 | 8.343 | 17519.1 |
| 605 | 2024-04-22 16:55:46 | trainers | 3 | 146162 | 520 | 9.923 | 14729.6 |
| 604 | 2024-04-20 23:09:45 | trainers | 1 | 82945 | 7 | 4.986 | 16635.6 |
| 603 | 2024-04-20 23:09:24 | trainers | 3 | 146162 | 520 | 18.703 | 7814.9 |
| 602 | 2024-04-20 23:09:35 | trainers | 1 | 82945 | 7 | 2.173 | 38170.7 |
| 601 | 2024-04-20 23:09:25 | trainers | 2 | 121059 | 43 | 5.420 | 22335.6 |
| 600 | 2024-04-08 05:29:03 | trainers | 1 | 82945 | 7 | 3.140 | 26415.6 |
| 599 | 2024-04-06 07:25:28 | trainers | 1 | 82945 | 7 | 1.563 | 53067.8 |
| 598 | 2024-03-25 05:15:14 | trainers | 2 | 121059 | 43 | 3.780 | 32026.2 |
| 597 | 2024-03-25 05:14:01 | trainers | 3 | 146162 | 520 | 7.953 | 18378.2 |
| 596 | 2024-03-23 06:46:59 | trainers | 3 | 146162 | 520 | 7.376 | 19815.9 |
| 595 | 2024-03-23 06:46:50 | trainers | 2 | 121059 | 43 | 4.016 | 30144.2 |
| 594 | 2024-03-22 01:02:02 | trainers | 2 | 121059 | 43 | 4.000 | 30264.8 |
| 593 | 2024-03-19 08:24:13 | trainers | 2 | 121059 | 43 | 5.156 | 23479.2 |
| 592 | 2024-03-19 08:21:56 | trainers | 3 | 146162 | 520 | 8.063 | 18127.5 |
| 591 | 2024-03-18 07:55:12 | trainers | 3 | 146162 | 520 | 7.250 | 20160.3 |
| 590 | 2024-03-18 07:55:10 | trainers | 2 | 121059 | 43 | 3.830 | 31608.1 |
| 589 | 2024-03-18 07:55:06 | trainers | 1 | 82945 | 7 | 1.550 | 53512.9 |
| 588 | 2024-03-07 20:38:36 | trainers | 1 | 82945 | 7 | 1.516 | 54713.1 |
| 587 | 2024-03-04 23:16:16 | trainers | 1 | 82945 | 7 | 1.640 | 50576.2 |
| 586 | 2024-02-28 06:59:33 | trainers | 1 | 82945 | 7 | 1.623 | 51106.0 |
| 585 | 2024-02-21 12:00:01 | trainers | 3 | 146162 | 520 | 9.686 | 15090.0 |
| 584 | 2024-02-21 09:07:12 | trainers | 3 | 146162 | 520 | 25.156 | 5810.2 |
| 583 | 2024-02-17 21:03:49 | trainers | 2 | 121059 | 43 | 4.936 | 24525.7 |
| 582 | 2024-02-17 20:50:34 | trainers | 3 | 146162 | 520 | 8.546 | 17103.0 |
| 581 | 2024-02-14 19:52:33 | trainers | 3 | 146162 | 520 | 7.843 | 18636.0 |
| 580 | 2024-02-14 19:52:34 | trainers | 2 | 121059 | 43 | 4.296 | 28179.5 |
| 579 | 2024-02-14 19:52:26 | trainers | 1 | 82945 | 7 | 1.483 | 55930.5 |
| 578 | 2024-01-30 22:46:35 | trainers | 1 | 82945 | 7 | 1.233 | 67270.9 |
| 577 | 2024-01-08 00:53:17 | trainers | 1 | 82945 | 7 | 1.560 | 53169.9 |
| 576 | 2023-12-30 12:13:52 | trainers | 3 | 146162 | 520 | 6.796 | 21507.1 |
| 575 | 2023-12-30 12:13:53 | trainers | 2 | 121059 | 43 | 3.593 | 33693.0 |
| 574 | 2023-12-29 01:22:16 | trainers | 3 | 146162 | 520 | 6.530 | 22383.2 |
| 573 | 2023-12-10 22:53:44 | trainers | 1 | 82945 | 7 | 1.813 | 45750.1 |
| 572 | 2023-12-10 00:58:58 | trainers | 1 | 82945 | 7 | 1.533 | 54106.3 |
| 571 | 2023-11-30 22:09:32 | trainers | 2 | 121059 | 43 | 3.470 | 34887.3 |
| 570 | 2023-11-27 16:09:38 | trainers | 1 | 82945 | 7 | 1.406 | 58993.6 |
| 569 | 2023-11-10 07:22:52 | trainers | 1 | 82945 | 7 | 1.406 | 58993.6 |
| 568 | 2023-10-30 16:23:41 | trainers | 1 | 82945 | 7 | 1.406 | 58993.6 |
| 567 | 2023-10-09 17:18:12 | trainers | 1 | 82945 | 7 | 2.516 | 32967.0 |
| 566 | 2023-10-09 09:32:01 | trainers | 3 | 146162 | 520 | 7.983 | 18309.2 |
| 565 | 2023-10-02 02:39:39 | trainers | 3 | 146162 | 520 | 6.343 | 23043.0 |
| 564 | 2023-09-24 13:11:25 | trainers | 1 | 82945 | 7 | 1.483 | 55930.5 |
| 563 | 2023-09-23 11:25:43 | trainers | 1 | 82945 | 7 | 1.356 | 61168.9 |
| 562 | 2023-08-29 00:51:09 | trainers | 2 | 121059 | 43 | 3.373 | 35890.6 |
| 561 | 2023-07-24 02:22:12 | trainers | 1 | 82945 | 7 | 1.266 | 65517.4 |
| 560 | 2023-07-20 19:26:50 | trainers | 1 | 82945 | 7 | 1.250 | 66356.0 |
| 559 | 2023-07-13 04:20:05 | trainers | 3 | 146162 | 520 | 6.343 | 23043.0 |
| 558 | 2023-05-16 10:28:31 | trainers | 2 | 121059 | 43 | 3.406 | 35542.9 |
| 557 | 2023-04-22 18:54:35 | trainers | 1 | 82945 | 7 | 1.280 | 64800.8 |
| 556 | 2023-04-04 23:40:39 | trainers | 1 | 82945 | 7 | 1.436 | 57761.1 |
| 555 | 2023-03-30 12:07:03 | trainers | 3 | 146162 | 520 | 6.376 | 22923.8 |
| 554 | 2023-02-24 06:43:56 | trainers | 2 | 121059 | 43 | 3.156 | 38358.4 |
| 553 | 2023-02-13 07:35:29 | trainers | 1 | 82945 | 7 | 1.250 | 66356.0 |
| 552 | 2022-12-27 07:29:23 | trainers | 3 | 146162 | 520 | 7.686 | 19016.7 |
| 551 | 2022-12-16 10:46:29 | trainers | 1 | 82945 | 7 | 1.373 | 60411.5 |
| 550 | 2022-12-10 07:24:24 | trainers | 1 | 82945 | 7 | 1.266 | 65517.4 |
| 549 | 2022-12-05 18:39:28 | trainers | 2 | 121059 | 43 | 3.170 | 38189.0 |
| 548 | 2022-08-27 18:43:32 | trainers | 3 | 146162 | 520 | 7.626 | 19166.3 |
| 547 | 2022-08-23 10:22:35 | trainers | 1 | 82945 | 7 | 1.390 | 59672.7 |
| 546 | 2022-08-16 06:31:32 | trainers | 1 | 82945 | 7 | 1.393 | 59544.1 |
| 545 | 2022-08-13 21:50:43 | trainers | 1 | 82945 | 7 | 1.283 | 64649.3 |
| 544 | 2022-08-07 19:57:14 | trainers | 1 | 82945 | 7 | 1.283 | 64649.3 |
| 543 | 2022-04-15 16:00:38 | trainers | 1 | 82945 | 7 | 1.860 | 44594.1 |
| 542 | 2022-04-10 17:12:54 | trainers | 1 | 82945 | 7 | 1.296 | 64000.8 |
| 541 | 2022-04-09 06:48:53 | trainers | 1 | 82945 | 7 | 1.263 | 65673.0 |
| 540 | 2022-04-01 03:30:10 | trainers | 2 | 121059 | 43 | 4.000 | 30264.8 |
| 539 | 2022-03-20 15:28:45 | trainers | 3 | 146162 | 520 | 6.360 | 22981.4 |
| 538 | 2022-01-08 16:42:35 | trainers | 1 | 82945 | 7 | 1.563 | 53067.8 |
| 537 | 2022-01-06 13:44:11 | trainers | 1 | 82945 | 7 | 1.796 | 46183.2 |
| 536 | 2021-12-30 20:34:27 | trainers | 1 | 82945 | 7 | 1.313 | 63172.1 |
| 535 | 2021-12-27 16:47:11 | trainers | 1 | 82945 | 7 | 1.483 | 55930.5 |
| 534 | 2021-12-18 22:28:11 | trainers | 2 | 121059 | 43 | 4.050 | 29891.1 |
| 533 | 2021-11-06 22:03:17 | trainers | 1 | 82945 | 7 | 1.500 | 55296.7 |
| 532 | 2021-10-02 20:13:29 | trainers | 1 | 82945 | 7 | 1.406 | 58993.6 |
| 531 | 2021-09-30 17:44:48 | trainers | 1 | 82945 | 7 | 1.483 | 55930.5 |
| 530 | 2021-09-17 09:12:15 | trainers | 1 | 82945 | 7 | 1.470 | 56425.2 |
| 529 | 2021-09-14 03:56:49 | trainers | 1 | 82945 | 7 | 1.390 | 59672.7 |
| 528 | 2021-07-27 20:45:24 | trainers | 1 | 82945 | 7 | 1.263 | 65673.0 |
| 527 | 2021-06-10 01:55:44 | trainers | 1 | 82945 | 7 | 1.280 | 64800.8 |
| 526 | 2021-05-18 20:20:00 | trainers | 1 | 82945 | 7 | 1.513 | 54821.5 |
| 525 | 2021-04-18 20:41:21 | trainers | 1 | 82945 | 7 | 2.906 | 28542.7 |
| 524 | 2021-03-07 15:29:59 | trainers | 1 | 82945 | 7 | 2.843 | 29175.2 |
| 523 | 2021-02-21 10:28:37 | trainers | 1 | 82945 | 7 | 1.280 | 64800.8 |
| 522 | 2021-01-03 10:09:53 | trainers | 1 | 82945 | 7 | 1.440 | 57600.7 |
| 521 | 2020-12-03 20:17:10 | trainers | 1 | 82945 | 7 | 1.266 | 65517.4 |
| 520 | 2020-11-02 03:15:30 | trainers | 1 | 82945 | 7 | 1.453 | 57085.3 |
| 519 | 2020-10-21 23:25:40 | trainers | 1 | 82945 | 7 | 1.343 | 61761.0 |
| 518 | 2020-10-18 11:23:56 | trainers | 1 | 82945 | 7 | 1.266 | 65517.4 |
| 517 | 2020-10-14 18:07:16 | trainers | 1 | 82945 | 7 | 1.453 | 57085.3 |
| 516 | 2020-10-11 02:34:07 | trainers | 1 | 82945 | 7 | 2.580 | 32149.2 |
| 515 | 2020-08-22 21:54:22 | trainers | 1 | 82945 | 7 | 1.436 | 57761.1 |
| 514 | 2020-08-19 17:25:08 | trainers | 1 | 82945 | 7 | 1.453 | 57085.3 |
| 513 | 2020-07-19 10:47:53 | trainers | 1 | 82945 | 7 | 1.470 | 56425.2 |
| 512 | 2020-07-15 17:07:38 | trainers | 1 | 82945 | 7 | 1.330 | 62364.7 |
| 511 | 2020-05-18 11:17:26 | trainers | 1 | 82945 | 7 | 1.280 | 64800.8 |
| 510 | 2020-04-08 12:20:28 | trainers | 1 | 82945 | 7 | 1.436 | 57761.1 |
| 509 | 2020-03-29 22:58:25 | trainers | 1 | 82945 | 7 | 1.656 | 50087.6 |
| 508 | 2020-03-28 06:26:44 | trainers | 1 | 82945 | 7 | 1.423 | 58288.8 |
| 507 | 2020-03-22 02:34:04 | trainers | 1 | 82945 | 7 | 1.466 | 56579.1 |