History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mayfly"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 547 | 2025-10-20 04:12:06 | mayfly | 1 | 48755 | 2 | 0.813 | 59969.2 |
| 546 | 2025-10-13 22:53:59 | mayfly | 1 | 48755 | 2 | 0.873 | 55847.7 |
| 545 | 2025-09-18 07:08:12 | mayfly | 1 | 48755 | 2 | 0.970 | 50262.9 |
| 544 | 2025-09-02 06:06:34 | mayfly | 1 | 48755 | 2 | 0.940 | 51867.0 |
| 543 | 2025-08-17 14:09:13 | mayfly | 1 | 48755 | 2 | 3.563 | 13683.7 |
| 542 | 2025-08-09 08:43:30 | mayfly | 1 | 48755 | 2 | 4.123 | 11825.1 |
| 541 | 2025-07-31 20:06:46 | mayfly | 3 | 112716 | 240 | 17.626 | 6394.9 |
| 540 | 2025-07-31 05:21:26 | mayfly | 1 | 48755 | 2 | 0.966 | 50471.0 |
| 539 | 2025-07-31 00:03:49 | mayfly | 1 | 48755 | 2 | 1.966 | 24799.1 |
| 538 | 2025-07-29 14:08:48 | mayfly | 3 | 112716 | 240 | 13.686 | 8235.9 |
| 537 | 2025-07-29 14:04:56 | mayfly | 2 | 82551 | 15 | 13.266 | 6222.7 |
| 536 | 2025-07-25 17:07:41 | mayfly | 1 | 48755 | 2 | 2.143 | 22750.8 |
| 535 | 2025-07-25 09:06:13 | mayfly | 1 | 48755 | 2 | 1.906 | 25579.7 |
| 534 | 2025-07-24 20:24:15 | mayfly | 1 | 48755 | 2 | 4.216 | 11564.3 |
| 533 | 2025-07-21 14:17:10 | mayfly | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 532 | 2025-07-16 05:40:57 | mayfly | 1 | 48755 | 2 | 1.986 | 24549.3 |
| 531 | 2025-07-07 14:23:15 | mayfly | 1 | 48755 | 2 | 4.250 | 11471.8 |
| 530 | 2025-07-07 08:17:57 | mayfly | 1 | 48755 | 2 | 3.016 | 16165.5 |
| 529 | 2025-06-20 12:45:53 | mayfly | 1 | 48755 | 2 | 4.580 | 10645.2 |
| 528 | 2025-06-16 05:04:03 | mayfly | 1 | 48755 | 2 | 3.923 | 12428.0 |
| 527 | 2025-06-14 10:06:37 | mayfly | 1 | 48755 | 2 | 3.983 | 12240.8 |
| 526 | 2025-06-14 05:38:08 | mayfly | 3 | 112716 | 240 | 18.970 | 5941.8 |
| 525 | 2025-06-13 13:48:09 | mayfly | 1 | 48755 | 2 | 1.783 | 27344.4 |
| 524 | 2025-06-12 06:44:02 | mayfly | 3 | 112716 | 240 | 16.643 | 6772.6 |
| 523 | 2025-06-12 01:06:35 | mayfly | 3 | 112716 | 240 | 23.203 | 4857.8 |
| 522 | 2025-06-10 19:36:15 | mayfly | 3 | 112716 | 240 | 5.733 | 19660.9 |
| 521 | 2025-06-08 23:23:33 | mayfly | 3 | 112716 | 240 | 5.986 | 18829.9 |
| 520 | 2025-06-08 09:34:14 | mayfly | 3 | 112716 | 240 | 14.300 | 7882.2 |
| 519 | 2025-06-07 13:35:35 | mayfly | 1 | 48755 | 2 | 0.843 | 57835.1 |
| 518 | 2025-06-07 07:29:08 | mayfly | 1 | 48755 | 2 | 2.016 | 24184.0 |
| 517 | 2025-05-28 01:41:54 | mayfly | 1 | 48755 | 2 | 0.890 | 54780.9 |
| 516 | 2025-05-27 22:57:44 | mayfly | 1 | 48755 | 2 | 0.763 | 63899.1 |
| 515 | 2025-05-27 20:18:56 | mayfly | 1 | 48755 | 2 | 1.766 | 27607.6 |
| 514 | 2025-05-26 09:12:58 | mayfly | 1 | 48755 | 2 | 3.780 | 12898.1 |
| 513 | 2025-05-15 22:22:25 | mayfly | 1 | 48755 | 2 | 5.026 | 9700.6 |
| 512 | 2025-05-14 13:50:05 | mayfly | 1 | 48755 | 2 | 2.203 | 22131.2 |
| 511 | 2025-05-11 04:52:16 | mayfly | 1 | 48755 | 2 | 0.890 | 54780.9 |
| 510 | 2025-05-06 14:26:51 | mayfly | 1 | 48755 | 2 | 2.720 | 17924.6 |
| 509 | 2025-05-03 04:40:41 | mayfly | 1 | 48755 | 2 | 5.063 | 9629.7 |
| 508 | 2025-05-02 21:30:42 | mayfly | 1 | 48755 | 2 | 6.046 | 8064.0 |
| 507 | 2025-04-18 12:35:09 | mayfly | 1 | 48755 | 2 | 3.953 | 12333.7 |
| 506 | 2025-04-05 21:39:32 | mayfly | 1 | 48755 | 2 | 4.500 | 10834.4 |
| 505 | 2025-03-31 09:30:08 | mayfly | 1 | 48755 | 2 | 2.373 | 20545.7 |
| 504 | 2025-03-27 06:20:31 | mayfly | 3 | 112716 | 240 | 29.346 | 3840.9 |
| 503 | 2025-03-27 03:58:32 | mayfly | 3 | 112716 | 240 | 27.626 | 4080.1 |
| 502 | 2025-03-25 07:49:42 | mayfly | 3 | 112716 | 240 | 30.003 | 3756.8 |
| 501 | 2025-03-23 22:35:58 | mayfly | 3 | 112716 | 240 | 19.490 | 5783.3 |
| 500 | 2025-03-18 03:17:50 | mayfly | 1 | 48755 | 2 | 4.156 | 11731.2 |
| 499 | 2025-03-17 15:44:13 | mayfly | 1 | 48755 | 2 | 3.546 | 13749.3 |
| 498 | 2025-03-12 20:19:58 | mayfly | 1 | 48755 | 2 | 3.716 | 13120.3 |
| 497 | 2025-03-12 01:16:09 | mayfly | 1 | 48755 | 2 | 4.860 | 10031.9 |
| 496 | 2025-03-09 06:03:09 | mayfly | 1 | 48755 | 2 | 2.156 | 22613.6 |
| 495 | 2025-03-05 19:54:11 | mayfly | 1 | 48755 | 2 | 2.453 | 19875.7 |
| 494 | 2025-02-27 06:51:50 | mayfly | 1 | 48755 | 2 | 4.360 | 11182.3 |
| 493 | 2025-02-27 06:51:11 | mayfly | 2 | 82551 | 15 | 5.936 | 13906.8 |
| 492 | 2025-02-18 21:32:11 | mayfly | 2 | 82551 | 15 | 10.423 | 7920.1 |
| 491 | 2025-02-18 21:31:12 | mayfly | 1 | 48755 | 2 | 4.123 | 11825.1 |
| 490 | 2025-02-17 07:19:36 | mayfly | 3 | 112716 | 240 | 26.983 | 4177.3 |
| 489 | 2025-02-17 00:30:59 | mayfly | 3 | 112716 | 240 | 27.720 | 4066.2 |
| 488 | 2025-02-16 15:46:32 | mayfly | 3 | 112716 | 240 | 25.220 | 4469.3 |
| 487 | 2025-02-15 22:05:29 | mayfly | 3 | 112716 | 240 | 24.720 | 4559.7 |
| 486 | 2025-02-15 13:54:40 | mayfly | 3 | 112716 | 240 | 19.130 | 5892.1 |
| 485 | 2025-02-15 09:12:24 | mayfly | 1 | 48755 | 2 | 6.343 | 7686.4 |
| 484 | 2025-02-06 12:39:06 | mayfly | 2 | 82551 | 15 | 6.406 | 12886.5 |
| 483 | 2025-02-06 12:16:53 | mayfly | 1 | 48755 | 2 | 0.796 | 61250.0 |
| 482 | 2025-01-30 14:54:40 | mayfly | 2 | 82551 | 15 | 12.843 | 6427.7 |
| 481 | 2025-01-30 14:54:28 | mayfly | 1 | 48755 | 2 | 4.016 | 12140.2 |
| 480 | 2025-01-26 01:18:10 | mayfly | 1 | 48755 | 2 | 4.796 | 10165.8 |
| 479 | 2025-01-16 03:43:33 | mayfly | 1 | 48755 | 2 | 3.580 | 13618.7 |
| 478 | 2025-01-15 04:49:57 | mayfly | 3 | 112716 | 240 | 27.423 | 4110.3 |
| 477 | 2025-01-15 03:33:57 | mayfly | 3 | 112716 | 240 | 22.280 | 5059.1 |
| 476 | 2025-01-14 07:18:34 | mayfly | 3 | 112716 | 240 | 27.986 | 4027.6 |
| 475 | 2025-01-14 05:02:39 | mayfly | 2 | 82551 | 15 | 7.360 | 11216.2 |
| 474 | 2025-01-14 04:29:33 | mayfly | 3 | 112716 | 240 | 5.860 | 19234.8 |
| 473 | 2025-01-06 18:37:21 | mayfly | 1 | 48755 | 2 | 3.140 | 15527.1 |
| 472 | 2024-12-31 10:59:53 | mayfly | 2 | 82551 | 15 | 10.796 | 7646.4 |
| 471 | 2024-12-31 10:59:17 | mayfly | 1 | 48755 | 2 | 1.656 | 29441.4 |
| 470 | 2024-12-26 09:15:57 | mayfly | 1 | 48755 | 2 | 2.173 | 22436.7 |
| 469 | 2024-12-15 14:07:50 | mayfly | 1 | 48755 | 2 | 2.156 | 22613.6 |
| 468 | 2024-12-13 23:13:03 | mayfly | 3 | 112716 | 240 | 26.440 | 4263.1 |
| 467 | 2024-12-12 22:36:56 | mayfly | 3 | 112716 | 240 | 6.936 | 16250.9 |
| 466 | 2024-12-10 23:32:21 | mayfly | 3 | 112716 | 240 | 26.906 | 4189.3 |
| 465 | 2024-12-08 05:26:52 | mayfly | 3 | 112716 | 240 | 14.753 | 7640.2 |
| 464 | 2024-12-06 22:29:59 | mayfly | 3 | 112716 | 240 | 32.033 | 3518.7 |
| 463 | 2024-12-05 22:06:55 | mayfly | 3 | 112716 | 240 | 12.940 | 8710.7 |
| 462 | 2024-12-05 18:30:38 | mayfly | 2 | 82551 | 15 | 2.830 | 29170.0 |
| 461 | 2024-12-04 06:08:02 | mayfly | 3 | 112716 | 240 | 14.376 | 7840.6 |
| 460 | 2024-12-04 00:35:42 | mayfly | 3 | 112716 | 240 | 32.846 | 3431.7 |
| 459 | 2024-12-03 22:42:50 | mayfly | 3 | 112716 | 240 | 12.860 | 8764.9 |
| 458 | 2024-12-02 20:05:28 | mayfly | 3 | 112716 | 240 | 25.970 | 4340.2 |
| 457 | 2024-12-02 17:13:47 | mayfly | 3 | 112716 | 240 | 26.283 | 4288.6 |
| 456 | 2024-12-02 17:13:46 | mayfly | 2 | 82551 | 15 | 8.126 | 10158.9 |
| 455 | 2024-12-02 17:13:43 | mayfly | 1 | 48755 | 2 | 3.936 | 12386.9 |
| 454 | 2024-11-25 11:04:43 | mayfly | 1 | 48755 | 2 | 2.456 | 19851.4 |
| 453 | 2024-11-14 18:45:02 | mayfly | 1 | 48755 | 2 | 3.170 | 15380.1 |
| 452 | 2024-11-03 14:44:02 | mayfly | 3 | 112716 | 240 | 30.190 | 3733.6 |
| 451 | 2024-11-03 07:01:24 | mayfly | 2 | 82551 | 15 | 11.906 | 6933.6 |
| 450 | 2024-11-01 23:56:51 | mayfly | 3 | 112716 | 240 | 27.640 | 4078.0 |
| 449 | 2024-11-01 10:44:13 | mayfly | 3 | 112716 | 240 | 41.313 | 2728.3 |
| 448 | 2024-11-01 09:11:28 | mayfly | 3 | 112716 | 240 | 26.783 | 4208.5 |