History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lemons"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 595 | 2024-05-04 13:00:38 | lemons | 1 | 48755 | 5 | 1.593 | 30605.8 |
| 594 | 2024-04-27 04:44:31 | lemons | 1 | 48755 | 5 | 1.906 | 25579.7 |
| 593 | 2024-04-18 22:53:41 | lemons | 1 | 48755 | 5 | 1.063 | 45865.5 |
| 592 | 2024-03-31 14:17:27 | lemons | 3 | 112716 | 812 | 8.826 | 12770.9 |
| 591 | 2024-03-31 12:52:06 | lemons | 3 | 112716 | 812 | 6.703 | 16815.8 |
| 590 | 2024-03-31 12:41:24 | lemons | 3 | 112716 | 812 | 7.516 | 14996.8 |
| 589 | 2024-03-29 22:10:52 | lemons | 1 | 48755 | 5 | 1.983 | 24586.5 |
| 588 | 2024-02-29 05:40:54 | lemons | 1 | 48755 | 5 | 1.356 | 35955.0 |
| 587 | 2024-02-28 08:21:22 | lemons | 1 | 48755 | 5 | 1.843 | 26454.2 |
| 586 | 2024-01-21 18:24:23 | lemons | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 585 | 2023-12-31 02:19:16 | lemons | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 584 | 2023-12-15 19:37:29 | lemons | 3 | 112716 | 812 | 5.313 | 21215.1 |
| 583 | 2023-12-15 19:37:27 | lemons | 2 | 82551 | 65 | 2.440 | 33832.4 |
| 582 | 2023-12-05 00:44:29 | lemons | 3 | 112716 | 812 | 4.810 | 23433.7 |
| 581 | 2023-11-24 22:33:50 | lemons | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 580 | 2023-11-21 03:06:26 | lemons | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 579 | 2023-11-11 21:11:41 | lemons | 1 | 48755 | 5 | 1.766 | 27607.6 |
| 578 | 2023-11-07 01:20:42 | lemons | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 577 | 2023-11-04 03:33:05 | lemons | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 576 | 2023-11-01 03:42:55 | lemons | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 575 | 2023-10-31 21:17:03 | lemons | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 574 | 2023-10-29 12:29:12 | lemons | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 573 | 2023-10-21 15:18:45 | lemons | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 572 | 2023-10-20 20:35:21 | lemons | 3 | 112716 | 812 | 8.453 | 13334.4 |
| 571 | 2023-10-20 20:35:18 | lemons | 2 | 82551 | 65 | 2.873 | 28733.4 |
| 570 | 2023-10-19 15:04:16 | lemons | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 569 | 2023-10-17 07:14:35 | lemons | 2 | 82551 | 65 | 7.263 | 11366.0 |
| 568 | 2023-10-17 04:42:14 | lemons | 3 | 112716 | 812 | 9.893 | 11393.5 |
| 567 | 2023-10-16 01:44:52 | lemons | 2 | 82551 | 65 | 2.343 | 35233.0 |
| 566 | 2023-10-16 01:44:27 | lemons | 3 | 112716 | 812 | 5.436 | 20735.1 |
| 565 | 2023-10-10 19:54:31 | lemons | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 564 | 2023-09-24 00:35:53 | lemons | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 563 | 2023-09-14 13:03:06 | lemons | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 562 | 2023-09-03 03:29:16 | lemons | 3 | 112716 | 812 | 4.610 | 24450.3 |
| 561 | 2023-08-23 02:46:52 | lemons | 3 | 112716 | 812 | 4.780 | 23580.8 |
| 560 | 2023-08-20 18:37:40 | lemons | 3 | 112716 | 812 | 6.500 | 17340.9 |
| 559 | 2023-08-16 12:46:00 | lemons | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 558 | 2023-07-30 21:22:44 | lemons | 3 | 112716 | 812 | 4.813 | 23419.1 |
| 557 | 2023-07-30 05:04:54 | lemons | 3 | 112716 | 812 | 4.716 | 23900.8 |
| 556 | 2023-07-29 00:07:43 | lemons | 3 | 112716 | 812 | 5.640 | 19985.1 |
| 555 | 2023-07-27 11:30:28 | lemons | 3 | 112716 | 812 | 4.750 | 23729.7 |
| 554 | 2023-07-26 16:15:51 | lemons | 3 | 112716 | 812 | 5.550 | 20309.2 |
| 553 | 2023-07-25 03:56:34 | lemons | 3 | 112716 | 812 | 4.703 | 23966.8 |
| 552 | 2023-07-23 08:28:03 | lemons | 3 | 112716 | 812 | 4.873 | 23130.7 |
| 551 | 2023-07-21 05:55:46 | lemons | 3 | 112716 | 812 | 4.686 | 24053.8 |
| 550 | 2023-07-19 23:11:12 | lemons | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 549 | 2023-07-19 04:39:10 | lemons | 3 | 112716 | 812 | 5.580 | 20200.0 |
| 548 | 2023-07-11 21:52:23 | lemons | 3 | 112716 | 812 | 6.516 | 17298.3 |
| 547 | 2023-07-11 21:47:13 | lemons | 3 | 112716 | 812 | 5.546 | 20323.8 |
| 546 | 2023-07-10 15:43:26 | lemons | 3 | 112716 | 812 | 5.203 | 21663.7 |
| 545 | 2023-05-19 06:08:49 | lemons | 3 | 112716 | 812 | 4.290 | 26274.1 |
| 544 | 2023-05-15 21:12:28 | lemons | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 543 | 2023-04-12 21:53:47 | lemons | 3 | 112716 | 812 | 5.766 | 19548.4 |
| 542 | 2023-04-12 01:03:05 | lemons | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 541 | 2023-04-08 00:14:18 | lemons | 3 | 112716 | 812 | 5.406 | 20850.2 |
| 540 | 2023-04-06 12:07:17 | lemons | 3 | 112716 | 812 | 5.670 | 19879.4 |
| 539 | 2023-04-05 20:40:57 | lemons | 3 | 112716 | 812 | 5.406 | 20850.2 |
| 538 | 2023-04-05 03:25:26 | lemons | 3 | 112716 | 812 | 5.173 | 21789.3 |
| 537 | 2023-03-28 01:21:17 | lemons | 3 | 112716 | 812 | 5.033 | 22395.4 |
| 536 | 2023-03-11 19:28:16 | lemons | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 535 | 2023-02-26 02:08:07 | lemons | 3 | 112716 | 812 | 4.733 | 23814.9 |
| 534 | 2023-02-24 19:00:38 | lemons | 3 | 112716 | 812 | 10.080 | 11182.1 |
| 533 | 2023-02-20 10:24:24 | lemons | 3 | 112716 | 812 | 5.280 | 21347.7 |
| 532 | 2023-01-03 05:02:42 | lemons | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 531 | 2023-01-01 16:39:18 | lemons | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 530 | 2022-12-06 19:15:05 | lemons | 3 | 112716 | 812 | 5.283 | 21335.6 |
| 529 | 2022-09-19 14:39:46 | lemons | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 528 | 2022-09-19 09:18:14 | lemons | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 527 | 2022-09-18 08:34:20 | lemons | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 526 | 2022-08-07 01:14:07 | lemons | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 525 | 2022-06-25 18:59:29 | lemons | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 524 | 2022-06-16 01:16:20 | lemons | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 523 | 2022-05-30 16:16:06 | lemons | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 522 | 2022-05-09 09:03:23 | lemons | 3 | 112716 | 812 | 5.670 | 19879.4 |
| 521 | 2022-05-06 21:12:58 | lemons | 3 | 112716 | 812 | 5.736 | 19650.6 |
| 520 | 2022-05-05 15:22:25 | lemons | 3 | 112716 | 812 | 4.750 | 23729.7 |
| 519 | 2022-05-04 14:12:06 | lemons | 3 | 112716 | 812 | 5.266 | 21404.5 |
| 518 | 2022-05-03 14:42:04 | lemons | 3 | 112716 | 812 | 10.300 | 10943.3 |
| 517 | 2022-04-30 10:40:41 | lemons | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 516 | 2022-04-28 05:13:02 | lemons | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 515 | 2022-04-05 18:27:16 | lemons | 3 | 112716 | 812 | 5.063 | 22262.7 |
| 514 | 2022-04-03 15:26:29 | lemons | 3 | 112716 | 812 | 4.673 | 24120.7 |
| 513 | 2022-02-12 13:33:00 | lemons | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 512 | 2022-01-23 20:04:21 | lemons | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 511 | 2022-01-09 16:02:45 | lemons | 3 | 112716 | 812 | 5.330 | 21147.5 |
| 510 | 2022-01-08 23:14:59 | lemons | 3 | 112716 | 812 | 5.530 | 20382.6 |
| 509 | 2022-01-07 15:17:56 | lemons | 3 | 112716 | 812 | 6.126 | 18399.6 |
| 508 | 2021-12-17 20:34:47 | lemons | 3 | 112716 | 812 | 5.233 | 21539.5 |
| 507 | 2021-12-16 23:43:06 | lemons | 3 | 112716 | 812 | 9.890 | 11397.0 |
| 506 | 2021-12-15 01:11:39 | lemons | 3 | 112716 | 812 | 4.796 | 23502.1 |
| 505 | 2021-11-21 08:30:22 | lemons | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 504 | 2021-11-19 07:20:09 | lemons | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 503 | 2021-11-15 22:16:51 | lemons | 3 | 112716 | 812 | 5.313 | 21215.1 |
| 502 | 2021-11-14 21:00:45 | lemons | 3 | 112716 | 812 | 4.720 | 23880.5 |
| 501 | 2021-11-13 22:50:26 | lemons | 3 | 112716 | 812 | 5.233 | 21539.5 |
| 500 | 2021-11-11 17:56:18 | lemons | 3 | 112716 | 812 | 5.766 | 19548.4 |
| 499 | 2021-11-08 03:03:05 | lemons | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 498 | 2021-10-19 11:26:59 | lemons | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 497 | 2021-10-14 23:10:08 | lemons | 3 | 112716 | 812 | 5.330 | 21147.5 |
| 496 | 2021-10-12 19:54:03 | lemons | 1 | 48755 | 5 | 0.826 | 59025.4 |