History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"quakes"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 618 | 2024-04-27 14:47:02 | quakes | 1 | 48755 | 5 | 1.906 | 25579.7 |
| 617 | 2024-04-26 06:21:49 | quakes | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 616 | 2024-04-03 09:27:12 | quakes | 3 | 112716 | 1024 | 10.390 | 10848.5 |
| 615 | 2024-04-03 09:27:14 | quakes | 2 | 82551 | 65 | 5.343 | 15450.3 |
| 614 | 2024-04-03 09:26:58 | quakes | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 613 | 2024-03-05 23:09:42 | quakes | 2 | 82551 | 65 | 7.643 | 10800.9 |
| 612 | 2024-03-05 16:54:43 | quakes | 3 | 112716 | 1024 | 7.250 | 15547.0 |
| 611 | 2024-03-05 03:27:30 | quakes | 3 | 112716 | 1024 | 13.140 | 8578.1 |
| 610 | 2024-03-05 00:08:57 | quakes | 2 | 82551 | 65 | 5.170 | 15967.3 |
| 609 | 2024-03-05 00:08:57 | quakes | 2 | 82551 | 65 | 2.656 | 31080.9 |
| 608 | 2024-03-05 00:08:55 | quakes | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 607 | 2024-03-05 00:08:16 | quakes | 3 | 112716 | 1024 | 6.236 | 18075.0 |
| 606 | 2024-03-04 18:18:59 | quakes | 3 | 112716 | 1024 | 8.330 | 13531.3 |
| 605 | 2024-03-04 07:45:26 | quakes | 2 | 82551 | 65 | 7.986 | 10337.0 |
| 604 | 2024-03-04 07:45:25 | quakes | 3 | 112716 | 1024 | 6.783 | 16617.4 |
| 603 | 2024-03-04 07:45:22 | quakes | 1 | 48755 | 5 | 0.903 | 53992.2 |
| 602 | 2024-02-27 04:46:22 | quakes | 1 | 48755 | 5 | 1.470 | 33166.7 |
| 601 | 2024-01-29 15:11:39 | quakes | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 600 | 2024-01-18 11:37:25 | quakes | 2 | 82551 | 65 | 2.046 | 40347.5 |
| 599 | 2024-01-06 16:09:43 | quakes | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 598 | 2024-01-03 04:54:09 | quakes | 2 | 82551 | 65 | 2.703 | 30540.5 |
| 597 | 2023-12-08 13:13:26 | quakes | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 596 | 2023-12-08 13:13:25 | quakes | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 595 | 2023-12-08 13:08:36 | quakes | 1 | 48755 | 5 | 2.670 | 18260.3 |
| 594 | 2023-12-05 13:33:57 | quakes | 3 | 112716 | 1024 | 5.763 | 19558.6 |
| 593 | 2023-12-05 13:33:55 | quakes | 2 | 82551 | 65 | 6.203 | 13308.2 |
| 592 | 2023-11-23 11:54:19 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 591 | 2023-11-10 23:59:20 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 590 | 2023-11-04 11:32:45 | quakes | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 589 | 2023-11-03 19:11:28 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 588 | 2023-10-30 22:11:08 | quakes | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 587 | 2023-10-30 03:05:29 | quakes | 2 | 82551 | 65 | 2.063 | 40015.0 |
| 586 | 2023-10-26 09:37:52 | quakes | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 585 | 2023-10-24 21:43:58 | quakes | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 584 | 2023-10-15 19:28:23 | quakes | 1 | 48755 | 5 | 1.486 | 32809.6 |
| 583 | 2023-10-07 15:55:48 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 582 | 2023-10-04 22:26:20 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 581 | 2023-09-26 01:05:27 | quakes | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 580 | 2023-09-13 17:10:57 | quakes | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 579 | 2023-08-23 12:46:11 | quakes | 1 | 48755 | 5 | 1.500 | 32503.3 |
| 578 | 2023-08-06 10:16:42 | quakes | 2 | 82551 | 65 | 2.093 | 39441.5 |
| 577 | 2023-06-17 10:21:31 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 576 | 2023-05-26 13:38:14 | quakes | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 575 | 2023-04-30 18:39:34 | quakes | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 574 | 2023-04-19 05:16:21 | quakes | 2 | 82551 | 65 | 2.046 | 40347.5 |
| 573 | 2023-03-21 07:20:24 | quakes | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 572 | 2023-03-08 11:30:38 | quakes | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 571 | 2023-01-21 21:58:12 | quakes | 2 | 82551 | 65 | 2.000 | 41275.5 |
| 570 | 2023-01-06 17:21:47 | quakes | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 569 | 2022-11-16 14:03:00 | quakes | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 568 | 2022-11-02 22:05:11 | quakes | 2 | 82551 | 65 | 2.140 | 38575.2 |
| 567 | 2022-10-05 08:43:57 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 566 | 2022-09-18 04:22:09 | quakes | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 565 | 2022-08-23 09:10:00 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 564 | 2022-07-27 10:04:16 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 563 | 2022-06-25 17:06:11 | quakes | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 562 | 2022-06-04 16:39:44 | quakes | 2 | 82551 | 65 | 2.063 | 40015.0 |
| 561 | 2022-05-21 22:56:30 | quakes | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 560 | 2022-04-05 06:54:42 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 559 | 2022-04-01 20:11:04 | quakes | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 558 | 2022-02-07 15:03:11 | quakes | 1 | 48755 | 5 | 0.700 | 69650.0 |
| 557 | 2022-02-05 12:11:04 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 556 | 2022-01-28 05:42:07 | quakes | 2 | 82551 | 65 | 2.170 | 38041.9 |
| 555 | 2022-01-23 16:00:58 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 554 | 2022-01-22 20:21:02 | quakes | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 553 | 2022-01-21 12:40:25 | quakes | 1 | 48755 | 5 | 1.656 | 29441.4 |
| 552 | 2022-01-20 10:58:05 | quakes | 1 | 48755 | 5 | 1.016 | 47987.2 |
| 551 | 2022-01-19 17:30:42 | quakes | 1 | 48755 | 5 | 1.670 | 29194.6 |
| 550 | 2022-01-18 17:51:03 | quakes | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 549 | 2022-01-13 04:29:44 | quakes | 1 | 48755 | 5 | 1.436 | 33951.9 |
| 548 | 2022-01-12 13:29:06 | quakes | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 547 | 2022-01-12 04:35:04 | quakes | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 546 | 2022-01-11 12:35:21 | quakes | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 545 | 2022-01-10 18:52:09 | quakes | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 544 | 2022-01-10 09:58:04 | quakes | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 543 | 2022-01-09 19:01:14 | quakes | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 542 | 2022-01-05 10:53:07 | quakes | 2 | 82551 | 65 | 2.266 | 36430.3 |
| 541 | 2021-12-24 15:02:27 | quakes | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 540 | 2021-12-14 04:52:23 | quakes | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 539 | 2021-12-13 19:13:43 | quakes | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 538 | 2021-12-13 07:43:10 | quakes | 1 | 48755 | 5 | 1.610 | 30282.6 |
| 537 | 2021-12-12 16:36:42 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 536 | 2021-12-12 06:39:34 | quakes | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 535 | 2021-12-07 22:22:06 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 534 | 2021-12-07 12:37:26 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 533 | 2021-12-07 01:16:20 | quakes | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 532 | 2021-12-06 15:45:46 | quakes | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 531 | 2021-12-06 12:26:47 | quakes | 2 | 82551 | 65 | 2.626 | 31436.0 |
| 530 | 2021-12-06 01:51:05 | quakes | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 529 | 2021-12-05 16:50:14 | quakes | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 528 | 2021-11-25 05:02:59 | quakes | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 527 | 2021-11-19 06:05:22 | quakes | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 526 | 2021-11-15 03:40:00 | quakes | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 525 | 2021-11-15 03:38:10 | quakes | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 524 | 2021-11-14 04:38:00 | quakes | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 523 | 2021-11-13 04:04:57 | quakes | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 522 | 2021-11-12 07:58:01 | quakes | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 521 | 2021-11-11 06:24:00 | quakes | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 520 | 2021-10-29 18:12:43 | quakes | 2 | 82551 | 65 | 2.000 | 41275.5 |
| 519 | 2021-10-27 07:58:26 | quakes | 1 | 48755 | 5 | 0.703 | 69352.8 |