History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asafoetida"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 605 | 2025-10-01 11:26:58 | asafoetida | 2 | 108824 | 4 | 3.483 | 31244.3 |
| 604 | 2025-10-01 10:23:33 | asafoetida | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 603 | 2025-08-30 06:13:49 | asafoetida | 2 | 108824 | 4 | 3.156 | 34481.6 |
| 602 | 2025-08-19 00:24:11 | asafoetida | 1 | 67641 | 3 | 2.233 | 30291.5 |
| 601 | 2025-08-14 23:00:38 | asafoetida | 1 | 67641 | 3 | 8.143 | 8306.6 |
| 600 | 2025-07-25 12:11:32 | asafoetida | 1 | 67641 | 3 | 4.063 | 16648.0 |
| 599 | 2025-07-25 04:38:52 | asafoetida | 1 | 67641 | 3 | 5.810 | 11642.2 |
| 598 | 2025-07-23 07:41:10 | asafoetida | 1 | 67641 | 3 | 5.110 | 13237.0 |
| 597 | 2025-06-08 19:24:55 | asafoetida | 2 | 108824 | 4 | 11.470 | 9487.7 |
| 596 | 2025-05-07 20:31:21 | asafoetida | 3 | 140603 | 4 | 33.096 | 4248.3 |
| 595 | 2025-04-15 09:36:59 | asafoetida | 1 | 67641 | 3 | 5.486 | 12329.7 |
| 594 | 2025-03-20 07:11:56 | asafoetida | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 593 | 2025-03-05 00:36:04 | asafoetida | 1 | 67641 | 3 | 6.673 | 10136.5 |
| 592 | 2025-02-28 04:30:15 | asafoetida | 1 | 67641 | 3 | 2.516 | 26884.3 |
| 591 | 2025-02-10 00:18:49 | asafoetida | 4 | 161450 | 7 | 62.566 | 2580.5 |
| 590 | 2025-02-10 00:18:41 | asafoetida | 4 | 161450 | 7 | 64.833 | 2490.2 |
| 589 | 2025-02-10 00:18:41 | asafoetida | 3 | 140603 | 4 | 30.173 | 4659.9 |
| 588 | 2025-02-10 00:18:38 | asafoetida | 2 | 108824 | 4 | 13.703 | 7941.6 |
| 587 | 2025-02-10 00:16:52 | asafoetida | 1 | 67641 | 3 | 5.420 | 12479.9 |
| 586 | 2025-01-27 07:33:00 | asafoetida | 3 | 140603 | 4 | 24.830 | 5662.6 |
| 585 | 2025-01-27 07:32:53 | asafoetida | 3 | 140603 | 4 | 24.283 | 5790.2 |
| 584 | 2025-01-27 07:32:59 | asafoetida | 2 | 108824 | 4 | 7.813 | 13928.6 |
| 583 | 2025-01-27 07:32:40 | asafoetida | 3 | 140603 | 4 | 24.956 | 5634.0 |
| 582 | 2025-01-27 07:31:08 | asafoetida | 1 | 67641 | 3 | 2.966 | 22805.5 |
| 581 | 2025-01-10 22:13:06 | asafoetida | 1 | 67641 | 3 | 5.423 | 12473.0 |
| 580 | 2025-01-10 17:13:54 | asafoetida | 1 | 67641 | 3 | 5.360 | 12619.6 |
| 579 | 2025-01-07 05:59:38 | asafoetida | 4 | 161450 | 7 | 55.830 | 2891.8 |
| 578 | 2025-01-07 05:59:39 | asafoetida | 3 | 140603 | 4 | 36.863 | 3814.2 |
| 577 | 2025-01-07 05:59:39 | asafoetida | 2 | 108824 | 4 | 21.470 | 5068.7 |
| 576 | 2025-01-07 05:58:59 | asafoetida | 1 | 67641 | 3 | 6.953 | 9728.3 |
| 575 | 2024-12-12 03:39:30 | asafoetida | 1 | 67641 | 3 | 4.736 | 14282.3 |
| 574 | 2024-12-05 06:18:49 | asafoetida | 1 | 67641 | 3 | 5.296 | 12772.1 |
| 573 | 2024-11-20 13:11:54 | asafoetida | 3 | 140603 | 4 | 14.110 | 9964.8 |
| 572 | 2024-11-18 05:00:31 | asafoetida | 3 | 140603 | 4 | 44.486 | 3160.6 |
| 571 | 2024-11-18 05:00:30 | asafoetida | 3 | 140603 | 4 | 31.986 | 4395.8 |
| 570 | 2024-11-18 05:00:13 | asafoetida | 3 | 140603 | 4 | 28.296 | 4969.0 |
| 569 | 2024-11-18 05:00:21 | asafoetida | 2 | 108824 | 4 | 15.610 | 6971.4 |
| 568 | 2024-11-18 04:56:23 | asafoetida | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 567 | 2024-11-16 23:46:37 | asafoetida | 3 | 140603 | 4 | 30.346 | 4633.3 |
| 566 | 2024-11-16 23:46:22 | asafoetida | 4 | 161450 | 7 | 43.040 | 3751.2 |
| 565 | 2024-11-16 23:46:31 | asafoetida | 2 | 108824 | 4 | 20.190 | 5390.0 |
| 564 | 2024-11-16 23:26:36 | asafoetida | 1 | 67641 | 3 | 7.796 | 8676.4 |
| 563 | 2024-11-04 09:08:52 | asafoetida | 3 | 140603 | 4 | 29.206 | 4814.2 |
| 562 | 2024-11-04 09:08:55 | asafoetida | 2 | 108824 | 4 | 15.970 | 6814.3 |
| 561 | 2024-11-04 09:08:39 | asafoetida | 3 | 140603 | 4 | 27.206 | 5168.1 |
| 560 | 2024-11-04 09:08:41 | asafoetida | 3 | 140603 | 4 | 23.533 | 5974.7 |
| 559 | 2024-11-04 09:04:52 | asafoetida | 1 | 67641 | 3 | 5.220 | 12958.0 |
| 558 | 2024-10-26 15:38:36 | asafoetida | 2 | 108824 | 4 | 11.750 | 9261.6 |
| 557 | 2024-10-26 15:30:23 | asafoetida | 3 | 140603 | 4 | 35.063 | 4010.0 |
| 556 | 2024-10-22 16:15:34 | asafoetida | 1 | 67641 | 3 | 8.326 | 8124.1 |
| 555 | 2024-10-22 16:15:36 | asafoetida | 1 | 67641 | 3 | 2.890 | 23405.2 |
| 554 | 2024-10-22 16:09:31 | asafoetida | 1 | 67641 | 3 | 5.046 | 13404.9 |
| 553 | 2024-10-22 16:02:40 | asafoetida | 1 | 67641 | 3 | 5.503 | 12291.7 |
| 552 | 2024-10-22 16:01:37 | asafoetida | 1 | 67641 | 3 | 2.983 | 22675.5 |
| 551 | 2024-10-21 20:40:07 | asafoetida | 3 | 140603 | 4 | 38.796 | 3624.2 |
| 550 | 2024-10-20 17:37:12 | asafoetida | 3 | 140603 | 4 | 39.906 | 3523.4 |
| 549 | 2024-10-15 14:03:31 | asafoetida | 3 | 140603 | 4 | 37.533 | 3746.1 |
| 548 | 2024-10-15 14:03:33 | asafoetida | 2 | 108824 | 4 | 15.720 | 6922.6 |
| 547 | 2024-10-15 14:02:09 | asafoetida | 1 | 67641 | 3 | 8.016 | 8438.2 |
| 546 | 2024-10-11 04:25:42 | asafoetida | 4 | 161450 | 7 | 64.113 | 2518.2 |
| 545 | 2024-10-11 04:25:43 | asafoetida | 3 | 140603 | 4 | 39.453 | 3563.8 |
| 544 | 2024-10-11 04:25:14 | asafoetida | 4 | 161450 | 7 | 56.380 | 2863.6 |
| 543 | 2024-10-11 04:25:45 | asafoetida | 2 | 108824 | 4 | 22.626 | 4809.7 |
| 542 | 2024-10-11 04:25:34 | asafoetida | 4 | 161450 | 7 | 29.206 | 5528.0 |
| 541 | 2024-10-11 04:23:12 | asafoetida | 1 | 67641 | 3 | 6.313 | 10714.6 |
| 540 | 2024-10-11 00:10:32 | asafoetida | 4 | 161450 | 7 | 84.740 | 1905.2 |
| 539 | 2024-09-10 02:15:13 | asafoetida | 4 | 161450 | 7 | 153.313 | 1053.1 |
| 538 | 2024-09-05 22:05:39 | asafoetida | 4 | 161450 | 7 | 107.256 | 1505.3 |
| 537 | 2024-09-05 13:53:52 | asafoetida | 4 | 161450 | 7 | 71.113 | 2270.3 |
| 536 | 2024-09-03 19:49:38 | asafoetida | 1 | 67641 | 3 | 4.686 | 14434.7 |
| 535 | 2024-08-22 19:50:09 | asafoetida | 1 | 67641 | 3 | 1.923 | 35174.7 |
| 534 | 2024-08-22 15:08:23 | asafoetida | 3 | 140603 | 4 | 6.486 | 21677.9 |
| 533 | 2024-08-19 00:24:38 | asafoetida | 3 | 140603 | 4 | 34.470 | 4079.0 |
| 532 | 2024-08-14 15:50:37 | asafoetida | 5 | 173545 | 63 | 157.196 | 1104.0 |
| 531 | 2024-08-14 15:50:52 | asafoetida | 5 | 173545 | 63 | 93.133 | 1863.4 |
| 530 | 2024-08-14 15:51:26 | asafoetida | 4 | 161450 | 7 | 55.550 | 2906.4 |
| 529 | 2024-08-14 15:51:01 | asafoetida | 3 | 140603 | 4 | 44.616 | 3151.4 |
| 528 | 2024-08-14 15:51:01 | asafoetida | 2 | 108824 | 4 | 21.906 | 4967.8 |
| 527 | 2024-08-14 15:43:43 | asafoetida | 1 | 67641 | 3 | 5.016 | 13485.0 |
| 526 | 2024-08-06 20:25:45 | asafoetida | 4 | 161450 | 7 | 21.813 | 7401.5 |
| 525 | 2024-08-06 20:25:34 | asafoetida | 3 | 140603 | 4 | 12.186 | 11538.1 |
| 524 | 2024-08-06 20:25:27 | asafoetida | 2 | 108824 | 4 | 6.013 | 18098.1 |
| 523 | 2024-08-05 00:28:34 | asafoetida | 4 | 161450 | 7 | 56.753 | 2844.8 |
| 522 | 2024-08-05 00:28:41 | asafoetida | 3 | 140603 | 4 | 20.423 | 6884.5 |
| 521 | 2024-08-05 00:28:41 | asafoetida | 2 | 108824 | 4 | 5.626 | 19343.1 |
| 520 | 2024-08-05 00:28:15 | asafoetida | 3 | 140603 | 4 | 25.953 | 5417.6 |
| 519 | 2024-08-05 00:28:16 | asafoetida | 3 | 140603 | 4 | 11.826 | 11889.3 |
| 518 | 2024-08-05 00:24:44 | asafoetida | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 517 | 2024-07-31 19:42:51 | asafoetida | 1 | 67641 | 3 | 3.000 | 22547.0 |
| 516 | 2024-07-27 23:44:40 | asafoetida | 3 | 140603 | 4 | 29.846 | 4710.9 |
| 515 | 2024-07-27 23:44:27 | asafoetida | 4 | 161450 | 7 | 34.830 | 4635.4 |
| 514 | 2024-07-27 23:44:32 | asafoetida | 2 | 108824 | 4 | 17.436 | 6241.3 |
| 513 | 2024-07-27 23:43:36 | asafoetida | 4 | 161450 | 7 | 62.626 | 2578.0 |
| 512 | 2024-07-27 23:43:39 | asafoetida | 4 | 161450 | 7 | 40.563 | 3980.2 |
| 511 | 2024-07-27 23:37:55 | asafoetida | 1 | 67641 | 3 | 3.470 | 19493.1 |
| 510 | 2024-07-14 19:23:46 | asafoetida | 1 | 67641 | 3 | 3.796 | 17819.0 |
| 509 | 2024-07-07 22:52:37 | asafoetida | 1 | 67641 | 3 | 3.126 | 21638.2 |
| 508 | 2024-07-05 16:17:14 | asafoetida | 3 | 140603 | 4 | 26.536 | 5298.6 |
| 507 | 2024-07-05 16:17:19 | asafoetida | 2 | 108824 | 4 | 12.753 | 8533.2 |
| 506 | 2024-07-05 16:16:25 | asafoetida | 1 | 67641 | 3 | 6.283 | 10765.7 |