History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lights"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 611 | 2024-04-14 22:51:17 | lights | 2 | 82551 | 88 | 6.766 | 12200.9 |
| 610 | 2024-04-14 22:50:00 | lights | 3 | 112716 | 570 | 7.030 | 16033.6 |
| 609 | 2024-04-11 03:46:28 | lights | 3 | 112716 | 570 | 5.563 | 20261.7 |
| 608 | 2024-04-08 23:16:25 | lights | 2 | 82551 | 88 | 4.533 | 18211.1 |
| 607 | 2024-04-08 23:16:01 | lights | 3 | 112716 | 570 | 5.513 | 20445.5 |
| 606 | 2024-04-08 07:39:47 | lights | 2 | 82551 | 88 | 4.860 | 16985.8 |
| 605 | 2024-04-08 07:37:43 | lights | 3 | 112716 | 570 | 6.500 | 17340.9 |
| 604 | 2024-04-07 18:22:10 | lights | 3 | 112716 | 570 | 16.283 | 6922.3 |
| 603 | 2024-04-03 07:15:05 | lights | 1 | 48755 | 19 | 1.890 | 25796.3 |
| 602 | 2024-03-29 22:26:22 | lights | 1 | 48755 | 19 | 2.873 | 16970.1 |
| 601 | 2024-03-04 00:24:43 | lights | 1 | 48755 | 19 | 2.860 | 17047.2 |
| 600 | 2024-02-03 18:32:47 | lights | 1 | 48755 | 19 | 0.733 | 66514.3 |
| 599 | 2024-01-29 17:37:35 | lights | 3 | 112716 | 570 | 9.453 | 11923.8 |
| 598 | 2024-01-29 13:56:02 | lights | 2 | 82551 | 88 | 2.466 | 33475.7 |
| 597 | 2024-01-29 13:49:02 | lights | 3 | 112716 | 570 | 5.750 | 19602.8 |
| 596 | 2024-01-26 10:44:19 | lights | 3 | 112716 | 570 | 6.076 | 18551.0 |
| 595 | 2024-01-18 12:13:02 | lights | 3 | 112716 | 570 | 4.640 | 24292.2 |
| 594 | 2024-01-18 12:12:49 | lights | 2 | 82551 | 88 | 2.216 | 37252.3 |
| 593 | 2023-12-22 06:17:43 | lights | 2 | 82551 | 88 | 2.110 | 39123.7 |
| 592 | 2023-12-13 01:37:45 | lights | 1 | 48755 | 19 | 1.720 | 28345.9 |
| 591 | 2023-12-12 19:14:59 | lights | 1 | 48755 | 19 | 0.843 | 57835.1 |
| 590 | 2023-12-07 09:56:33 | lights | 3 | 112716 | 570 | 4.890 | 23050.3 |
| 589 | 2023-12-06 12:20:10 | lights | 3 | 112716 | 570 | 5.016 | 22471.3 |
| 588 | 2023-12-06 12:20:11 | lights | 2 | 82551 | 88 | 2.436 | 33887.9 |
| 587 | 2023-11-26 05:41:50 | lights | 1 | 48755 | 19 | 0.736 | 66243.2 |
| 586 | 2023-11-17 21:09:14 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 585 | 2023-11-11 19:45:50 | lights | 1 | 48755 | 19 | 0.826 | 59025.4 |
| 584 | 2023-11-10 17:48:25 | lights | 1 | 48755 | 19 | 0.800 | 60943.8 |
| 583 | 2023-11-04 08:36:52 | lights | 1 | 48755 | 19 | 0.733 | 66514.3 |
| 582 | 2023-11-03 15:09:10 | lights | 1 | 48755 | 19 | 0.766 | 63648.8 |
| 581 | 2023-10-26 13:38:18 | lights | 1 | 48755 | 19 | 0.826 | 59025.4 |
| 580 | 2023-10-17 20:26:18 | lights | 1 | 48755 | 19 | 0.733 | 66514.3 |
| 579 | 2023-10-13 03:16:34 | lights | 1 | 48755 | 19 | 0.736 | 66243.2 |
| 578 | 2023-09-26 01:17:37 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 577 | 2023-09-23 03:03:08 | lights | 2 | 82551 | 88 | 2.360 | 34979.2 |
| 576 | 2023-09-14 03:05:14 | lights | 1 | 48755 | 19 | 0.796 | 61250.0 |
| 575 | 2023-09-12 02:46:14 | lights | 1 | 48755 | 19 | 0.843 | 57835.1 |
| 574 | 2023-09-04 15:13:32 | lights | 3 | 112716 | 570 | 4.656 | 24208.8 |
| 573 | 2023-08-02 00:02:03 | lights | 1 | 48755 | 19 | 0.843 | 57835.1 |
| 572 | 2023-07-02 11:23:37 | lights | 2 | 82551 | 88 | 2.376 | 34743.7 |
| 571 | 2023-06-25 17:06:27 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 570 | 2023-05-26 06:50:16 | lights | 3 | 112716 | 570 | 4.246 | 26546.4 |
| 569 | 2023-04-20 21:36:04 | lights | 1 | 48755 | 19 | 0.826 | 59025.4 |
| 568 | 2023-04-07 00:03:54 | lights | 1 | 48755 | 19 | 0.766 | 63648.8 |
| 567 | 2023-03-30 03:27:36 | lights | 3 | 112716 | 570 | 4.576 | 24632.0 |
| 566 | 2023-03-25 11:22:17 | lights | 3 | 112716 | 570 | 4.656 | 24208.8 |
| 565 | 2023-03-23 11:29:03 | lights | 2 | 82551 | 88 | 2.313 | 35690.0 |
| 564 | 2023-03-05 09:39:46 | lights | 3 | 112716 | 570 | 4.920 | 22909.8 |
| 563 | 2023-01-21 14:52:21 | lights | 1 | 48755 | 19 | 0.796 | 61250.0 |
| 562 | 2023-01-04 18:20:47 | lights | 1 | 48755 | 19 | 0.720 | 67715.3 |
| 561 | 2022-12-22 14:46:56 | lights | 2 | 82551 | 88 | 2.076 | 39764.5 |
| 560 | 2022-12-11 23:37:04 | lights | 3 | 112716 | 570 | 4.690 | 24033.3 |
| 559 | 2022-11-18 15:51:47 | lights | 1 | 48755 | 19 | 0.780 | 62506.4 |
| 558 | 2022-09-19 21:26:50 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 557 | 2022-09-18 15:54:13 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 556 | 2022-09-17 19:03:53 | lights | 1 | 48755 | 19 | 0.813 | 59969.2 |
| 555 | 2022-09-17 12:42:57 | lights | 1 | 48755 | 19 | 0.733 | 66514.3 |
| 554 | 2022-09-12 11:53:36 | lights | 1 | 48755 | 19 | 0.783 | 62266.9 |
| 553 | 2022-08-20 04:29:36 | lights | 2 | 82551 | 88 | 2.153 | 38342.3 |
| 552 | 2022-08-14 04:37:30 | lights | 1 | 48755 | 19 | 0.720 | 67715.3 |
| 551 | 2022-08-07 03:46:35 | lights | 1 | 48755 | 19 | 0.766 | 63648.8 |
| 550 | 2022-07-30 04:27:13 | lights | 1 | 48755 | 19 | 0.813 | 59969.2 |
| 549 | 2022-07-29 20:52:00 | lights | 3 | 112716 | 570 | 4.626 | 24365.8 |
| 548 | 2022-07-12 12:56:02 | lights | 1 | 48755 | 19 | 0.830 | 58741.0 |
| 547 | 2022-07-11 19:47:22 | lights | 1 | 48755 | 19 | 0.733 | 66514.3 |
| 546 | 2022-07-11 07:49:59 | lights | 3 | 112716 | 570 | 4.953 | 22757.1 |
| 545 | 2022-07-10 05:08:49 | lights | 1 | 48755 | 19 | 0.796 | 61250.0 |
| 544 | 2022-07-09 11:32:48 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 543 | 2022-07-09 03:16:13 | lights | 1 | 48755 | 19 | 0.720 | 67715.3 |
| 542 | 2022-07-08 15:14:21 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 541 | 2022-07-08 00:07:44 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 540 | 2022-07-06 12:28:00 | lights | 1 | 48755 | 19 | 0.830 | 58741.0 |
| 539 | 2022-07-05 13:27:18 | lights | 1 | 48755 | 19 | 0.810 | 60191.4 |
| 538 | 2022-07-03 11:45:16 | lights | 1 | 48755 | 19 | 0.826 | 59025.4 |
| 537 | 2022-07-03 11:30:39 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 536 | 2022-07-03 07:27:51 | lights | 3 | 112716 | 570 | 5.296 | 21283.2 |
| 535 | 2022-07-02 23:02:55 | lights | 1 | 48755 | 19 | 0.733 | 66514.3 |
| 534 | 2022-07-02 09:51:16 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 533 | 2022-07-01 13:22:49 | lights | 1 | 48755 | 19 | 0.796 | 61250.0 |
| 532 | 2022-06-30 21:31:49 | lights | 1 | 48755 | 19 | 0.813 | 59969.2 |
| 531 | 2022-06-26 09:16:23 | lights | 3 | 112716 | 570 | 4.766 | 23650.0 |
| 530 | 2022-06-16 11:29:52 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |
| 529 | 2022-06-15 17:12:02 | lights | 1 | 48755 | 19 | 0.780 | 62506.4 |
| 528 | 2022-05-26 03:29:20 | lights | 1 | 48755 | 19 | 0.733 | 66514.3 |
| 527 | 2022-05-25 14:14:44 | lights | 1 | 48755 | 19 | 0.796 | 61250.0 |
| 526 | 2022-03-07 09:53:57 | lights | 1 | 48755 | 19 | 1.283 | 38000.8 |
| 525 | 2022-02-13 05:05:03 | lights | 1 | 48755 | 19 | 0.843 | 57835.1 |
| 524 | 2022-02-10 10:46:31 | lights | 1 | 48755 | 19 | 0.780 | 62506.4 |
| 523 | 2021-12-24 05:14:04 | lights | 1 | 48755 | 19 | 0.843 | 57835.1 |
| 522 | 2021-11-18 09:32:41 | lights | 1 | 48755 | 19 | 0.813 | 59969.2 |
| 521 | 2021-11-17 19:30:00 | lights | 1 | 48755 | 19 | 0.920 | 52994.6 |
| 520 | 2021-11-06 04:14:38 | lights | 1 | 48755 | 19 | 0.826 | 59025.4 |
| 519 | 2021-10-29 00:48:54 | lights | 1 | 48755 | 19 | 0.923 | 52822.3 |
| 518 | 2021-09-19 10:37:50 | lights | 1 | 48755 | 19 | 0.856 | 56956.8 |
| 517 | 2021-09-17 07:10:02 | lights | 1 | 48755 | 19 | 0.953 | 51159.5 |
| 516 | 2021-08-19 20:59:54 | lights | 1 | 48755 | 19 | 0.813 | 59969.2 |
| 515 | 2021-08-17 17:07:34 | lights | 1 | 48755 | 19 | 1.656 | 29441.4 |
| 514 | 2021-08-06 11:43:30 | lights | 1 | 48755 | 19 | 0.763 | 63899.1 |
| 513 | 2021-07-28 08:21:27 | lights | 2 | 82551 | 88 | 2.483 | 33246.5 |
| 512 | 2021-07-26 17:30:34 | lights | 1 | 48755 | 19 | 0.750 | 65006.7 |