History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"royalty"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 606 | 2024-05-12 11:12:59 | royalty | 1 | 69583 | 3 | 3.186 | 21840.2 |
| 605 | 2024-05-11 03:40:57 | royalty | 1 | 69583 | 3 | 4.233 | 16438.2 |
| 604 | 2024-04-20 15:03:28 | royalty | 4 | 151207 | 1068 | 23.750 | 6366.6 |
| 603 | 2024-04-17 19:03:57 | royalty | 4 | 151207 | 1068 | 58.970 | 2564.1 |
| 602 | 2024-04-17 13:13:45 | royalty | 4 | 151207 | 1068 | 14.876 | 10164.5 |
| 601 | 2024-04-15 22:48:33 | royalty | 4 | 151207 | 1068 | 43.000 | 3516.4 |
| 600 | 2024-04-15 21:39:15 | royalty | 4 | 151207 | 1068 | 26.313 | 5746.5 |
| 599 | 2024-04-15 21:17:57 | royalty | 4 | 151207 | 1068 | 22.190 | 6814.2 |
| 598 | 2024-04-08 10:15:54 | royalty | 1 | 69583 | 3 | 1.450 | 47988.3 |
| 597 | 2024-04-05 02:28:25 | royalty | 4 | 151207 | 1068 | 33.440 | 4521.7 |
| 596 | 2024-04-04 16:26:05 | royalty | 4 | 151207 | 1068 | 36.533 | 4138.9 |
| 595 | 2024-04-03 19:54:34 | royalty | 1 | 69583 | 3 | 5.783 | 12032.3 |
| 594 | 2024-03-28 23:45:09 | royalty | 1 | 69583 | 3 | 2.856 | 24363.8 |
| 593 | 2024-03-16 20:12:43 | royalty | 4 | 151207 | 1068 | 15.143 | 9985.3 |
| 592 | 2024-03-15 09:52:14 | royalty | 4 | 151207 | 1068 | 36.016 | 4198.3 |
| 591 | 2024-03-15 07:51:15 | royalty | 4 | 151207 | 1068 | 13.876 | 10897.0 |
| 590 | 2024-03-14 14:12:54 | royalty | 4 | 151207 | 1068 | 23.360 | 6472.9 |
| 589 | 2024-03-12 19:48:21 | royalty | 4 | 151207 | 1068 | 20.330 | 7437.6 |
| 588 | 2024-03-12 15:58:38 | royalty | 4 | 151207 | 1068 | 10.563 | 14314.8 |
| 587 | 2024-02-27 11:19:41 | royalty | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 586 | 2024-01-31 04:04:04 | royalty | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 585 | 2024-01-27 04:57:11 | royalty | 2 | 107671 | 7 | 3.000 | 35890.3 |
| 584 | 2024-01-27 04:56:55 | royalty | 3 | 134027 | 76 | 6.563 | 20421.6 |
| 583 | 2024-01-23 12:42:07 | royalty | 3 | 134027 | 76 | 18.156 | 7382.0 |
| 582 | 2024-01-22 19:42:51 | royalty | 4 | 151207 | 1068 | 27.406 | 5517.3 |
| 581 | 2024-01-22 18:41:01 | royalty | 4 | 151207 | 1068 | 14.970 | 10100.7 |
| 580 | 2024-01-20 14:10:36 | royalty | 4 | 151207 | 1068 | 11.503 | 13145.0 |
| 579 | 2023-12-02 13:32:30 | royalty | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 578 | 2023-11-28 18:58:41 | royalty | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 577 | 2023-11-25 05:01:54 | royalty | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 576 | 2023-11-24 08:04:39 | royalty | 1 | 69583 | 3 | 2.453 | 28366.5 |
| 575 | 2023-11-12 09:11:06 | royalty | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 574 | 2023-11-06 17:57:24 | royalty | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 573 | 2023-11-01 12:10:07 | royalty | 4 | 151207 | 1068 | 11.233 | 13461.0 |
| 572 | 2023-10-26 17:25:48 | royalty | 4 | 151207 | 1068 | 13.046 | 11590.3 |
| 571 | 2023-10-25 08:22:49 | royalty | 4 | 151207 | 1068 | 15.783 | 9580.4 |
| 570 | 2023-10-17 16:16:09 | royalty | 4 | 151207 | 1068 | 17.156 | 8813.7 |
| 569 | 2023-10-16 13:11:40 | royalty | 4 | 151207 | 1068 | 12.296 | 12297.3 |
| 568 | 2023-10-13 08:30:59 | royalty | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 567 | 2023-10-12 00:16:44 | royalty | 4 | 151207 | 1068 | 10.173 | 14863.6 |
| 566 | 2023-10-06 02:52:44 | royalty | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 565 | 2023-10-06 02:38:46 | royalty | 4 | 151207 | 1068 | 15.030 | 10060.3 |
| 564 | 2023-09-29 02:47:13 | royalty | 1 | 69583 | 3 | 1.720 | 40455.2 |
| 563 | 2023-09-28 17:50:52 | royalty | 4 | 151207 | 1068 | 12.033 | 12566.0 |
| 562 | 2023-09-23 22:26:13 | royalty | 4 | 151207 | 1068 | 13.986 | 10811.3 |
| 561 | 2023-09-18 23:43:04 | royalty | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 560 | 2023-09-15 02:56:50 | royalty | 4 | 151207 | 1068 | 11.593 | 13043.0 |
| 559 | 2023-09-10 05:47:57 | royalty | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 558 | 2023-08-07 09:41:24 | royalty | 4 | 151207 | 1068 | 10.110 | 14956.2 |
| 557 | 2023-07-06 19:38:34 | royalty | 1 | 69583 | 3 | 2.376 | 29285.8 |
| 556 | 2023-06-14 18:31:39 | royalty | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 555 | 2023-05-30 11:10:50 | royalty | 4 | 151207 | 1068 | 9.796 | 15435.6 |
| 554 | 2023-04-24 10:38:12 | royalty | 4 | 151207 | 1068 | 10.280 | 14708.9 |
| 553 | 2023-04-21 11:43:51 | royalty | 4 | 151207 | 1068 | 9.780 | 15460.8 |
| 552 | 2023-04-10 15:26:40 | royalty | 4 | 151207 | 1068 | 10.940 | 13821.5 |
| 551 | 2023-03-31 13:53:39 | royalty | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 550 | 2023-03-24 03:05:55 | royalty | 4 | 151207 | 1068 | 10.123 | 14937.0 |
| 549 | 2023-02-17 14:09:43 | royalty | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 548 | 2023-02-16 22:19:10 | royalty | 4 | 151207 | 1068 | 10.906 | 13864.6 |
| 547 | 2023-02-15 18:32:32 | royalty | 4 | 151207 | 1068 | 11.233 | 13461.0 |
| 546 | 2023-01-26 15:29:06 | royalty | 4 | 151207 | 1068 | 9.720 | 15556.3 |
| 545 | 2023-01-13 17:49:57 | royalty | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 544 | 2022-12-28 09:52:43 | royalty | 4 | 151207 | 1068 | 10.360 | 14595.3 |
| 543 | 2022-12-13 20:10:43 | royalty | 4 | 151207 | 1068 | 10.206 | 14815.5 |
| 542 | 2022-11-19 13:12:46 | royalty | 3 | 134027 | 76 | 5.733 | 23378.2 |
| 541 | 2022-11-12 04:28:57 | royalty | 4 | 151207 | 1068 | 10.720 | 14105.1 |
| 540 | 2022-11-11 16:00:53 | royalty | 4 | 151207 | 1068 | 12.000 | 12600.6 |
| 539 | 2022-11-10 06:14:35 | royalty | 4 | 151207 | 1068 | 10.733 | 14088.0 |
| 538 | 2022-11-08 20:39:33 | royalty | 4 | 151207 | 1068 | 22.796 | 6633.0 |
| 537 | 2022-10-26 09:23:41 | royalty | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 536 | 2022-10-06 14:06:50 | royalty | 4 | 151207 | 1068 | 9.953 | 15192.1 |
| 535 | 2022-09-25 05:23:29 | royalty | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 534 | 2022-09-10 15:25:03 | royalty | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 533 | 2022-09-01 16:37:04 | royalty | 4 | 151207 | 1068 | 10.186 | 14844.6 |
| 532 | 2022-08-31 03:15:43 | royalty | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 531 | 2022-06-23 00:59:59 | royalty | 3 | 134027 | 76 | 5.830 | 22989.2 |
| 530 | 2022-06-22 20:33:17 | royalty | 4 | 151207 | 1068 | 10.223 | 14790.9 |
| 529 | 2022-06-16 11:47:30 | royalty | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 528 | 2022-06-14 18:24:42 | royalty | 4 | 151207 | 1068 | 11.550 | 13091.5 |
| 527 | 2022-06-14 06:18:05 | royalty | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 526 | 2022-06-09 01:48:47 | royalty | 4 | 151207 | 1068 | 10.000 | 15120.7 |
| 525 | 2022-05-11 19:18:50 | royalty | 4 | 151207 | 1068 | 10.843 | 13945.1 |
| 524 | 2022-05-01 12:28:34 | royalty | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 523 | 2022-03-31 12:27:07 | royalty | 4 | 151207 | 1068 | 12.643 | 11959.7 |
| 522 | 2022-01-05 00:18:09 | royalty | 4 | 151207 | 1068 | 12.406 | 12188.2 |
| 521 | 2021-12-19 17:56:14 | royalty | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 520 | 2021-12-19 01:56:30 | royalty | 4 | 151207 | 1068 | 10.936 | 13826.5 |
| 519 | 2021-12-19 01:08:40 | royalty | 4 | 151207 | 1068 | 11.186 | 13517.5 |
| 518 | 2021-12-15 20:23:31 | royalty | 4 | 151207 | 1068 | 11.406 | 13256.8 |
| 517 | 2021-12-11 08:15:16 | royalty | 4 | 151207 | 1068 | 10.486 | 14419.9 |
| 516 | 2021-12-09 14:51:02 | royalty | 4 | 151207 | 1068 | 13.283 | 11383.5 |
| 515 | 2021-11-28 07:44:23 | royalty | 4 | 151207 | 1068 | 11.780 | 12835.9 |
| 514 | 2021-11-23 09:32:35 | royalty | 4 | 151207 | 1068 | 12.126 | 12469.7 |
| 513 | 2021-11-19 10:04:12 | royalty | 4 | 151207 | 1068 | 13.440 | 11250.5 |
| 512 | 2021-11-18 10:02:44 | royalty | 4 | 151207 | 1068 | 12.733 | 11875.2 |
| 511 | 2021-11-17 10:15:05 | royalty | 4 | 151207 | 1068 | 15.703 | 9629.2 |
| 510 | 2021-11-15 09:51:25 | royalty | 4 | 151207 | 1068 | 18.126 | 8342.0 |
| 509 | 2021-11-07 18:40:29 | royalty | 4 | 151207 | 1068 | 10.296 | 14686.0 |
| 508 | 2021-11-07 05:57:06 | royalty | 4 | 151207 | 1068 | 11.250 | 13440.6 |
| 507 | 2021-11-06 19:37:31 | royalty | 4 | 151207 | 1068 | 10.050 | 15045.5 |