History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sampled"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 591 | 2024-04-21 07:49:22 | sampled | 1 | 69583 | 4 | 2.263 | 30748.1 |
| 590 | 2024-04-14 00:59:35 | sampled | 1 | 69583 | 4 | 3.733 | 18640.0 |
| 589 | 2024-04-14 00:56:22 | sampled | 1 | 69583 | 4 | 3.750 | 18555.5 |
| 588 | 2024-03-30 16:29:30 | sampled | 1 | 69583 | 4 | 3.593 | 19366.3 |
| 587 | 2024-03-28 07:35:37 | sampled | 1 | 69583 | 4 | 1.360 | 51164.0 |
| 586 | 2024-03-17 20:01:52 | sampled | 1 | 69583 | 4 | 1.423 | 48898.8 |
| 585 | 2024-03-07 23:27:29 | sampled | 3 | 134027 | 574 | 15.360 | 8725.7 |
| 584 | 2024-03-07 22:25:21 | sampled | 3 | 134027 | 574 | 13.940 | 9614.6 |
| 583 | 2024-03-07 00:06:25 | sampled | 1 | 69583 | 4 | 3.733 | 18640.0 |
| 582 | 2024-02-23 23:39:41 | sampled | 2 | 107671 | 48 | 7.186 | 14983.4 |
| 581 | 2024-02-23 23:38:42 | sampled | 3 | 134027 | 574 | 8.003 | 16747.1 |
| 580 | 2024-02-17 06:06:52 | sampled | 2 | 107671 | 48 | 4.110 | 26197.3 |
| 579 | 2024-02-14 20:23:15 | sampled | 3 | 134027 | 574 | 24.906 | 5381.3 |
| 578 | 2024-02-14 20:23:14 | sampled | 2 | 107671 | 48 | 5.390 | 19976.1 |
| 577 | 2024-02-14 18:45:06 | sampled | 1 | 69583 | 4 | 1.373 | 50679.5 |
| 576 | 2024-02-05 08:04:59 | sampled | 3 | 134027 | 574 | 15.910 | 8424.1 |
| 575 | 2024-02-05 07:54:22 | sampled | 3 | 134027 | 574 | 17.266 | 7762.5 |
| 574 | 2024-01-30 22:25:35 | sampled | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 573 | 2024-01-22 10:58:08 | sampled | 1 | 69583 | 4 | 4.236 | 16426.6 |
| 572 | 2024-01-10 06:55:33 | sampled | 3 | 134027 | 574 | 6.673 | 20085.0 |
| 571 | 2024-01-10 06:55:32 | sampled | 2 | 107671 | 48 | 3.220 | 33438.2 |
| 570 | 2024-01-09 02:18:52 | sampled | 2 | 107671 | 48 | 3.000 | 35890.3 |
| 569 | 2024-01-04 18:41:11 | sampled | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 568 | 2023-12-28 16:59:36 | sampled | 3 | 134027 | 574 | 8.110 | 16526.1 |
| 567 | 2023-12-27 01:27:22 | sampled | 3 | 134027 | 574 | 5.903 | 22704.9 |
| 566 | 2023-12-05 12:34:16 | sampled | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 565 | 2023-11-26 06:54:26 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 564 | 2023-11-16 22:46:18 | sampled | 1 | 69583 | 4 | 1.826 | 38106.8 |
| 563 | 2023-10-31 21:13:55 | sampled | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 562 | 2023-10-30 09:16:25 | sampled | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 561 | 2023-10-01 05:36:42 | sampled | 3 | 134027 | 574 | 14.373 | 9324.9 |
| 560 | 2023-09-29 12:51:04 | sampled | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 559 | 2023-09-29 09:16:53 | sampled | 3 | 134027 | 574 | 6.360 | 21073.4 |
| 558 | 2023-09-29 09:16:55 | sampled | 2 | 107671 | 48 | 3.390 | 31761.4 |
| 557 | 2023-09-29 05:46:38 | sampled | 3 | 134027 | 574 | 6.673 | 20085.0 |
| 556 | 2023-09-25 19:05:37 | sampled | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 555 | 2023-09-15 02:49:33 | sampled | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 554 | 2023-09-11 11:39:23 | sampled | 1 | 69583 | 4 | 1.423 | 48898.8 |
| 553 | 2023-08-19 03:47:35 | sampled | 3 | 134027 | 574 | 5.906 | 22693.4 |
| 552 | 2023-08-11 05:05:09 | sampled | 3 | 134027 | 574 | 6.436 | 20824.6 |
| 551 | 2023-07-10 17:53:02 | sampled | 3 | 134027 | 574 | 6.860 | 19537.5 |
| 550 | 2023-06-23 23:01:14 | sampled | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 549 | 2023-05-22 10:24:01 | sampled | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 548 | 2023-04-07 20:08:53 | sampled | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 547 | 2023-03-28 03:12:16 | sampled | 3 | 134027 | 574 | 7.156 | 18729.3 |
| 546 | 2023-01-29 19:50:02 | sampled | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 545 | 2023-01-18 23:19:30 | sampled | 3 | 134027 | 574 | 6.656 | 20136.3 |
| 544 | 2023-01-13 14:51:11 | sampled | 3 | 134027 | 574 | 6.003 | 22326.7 |
| 543 | 2022-12-25 22:23:26 | sampled | 3 | 134027 | 574 | 5.753 | 23296.9 |
| 542 | 2022-11-29 12:15:25 | sampled | 3 | 134027 | 574 | 11.643 | 11511.4 |
| 541 | 2022-11-03 19:20:50 | sampled | 3 | 134027 | 574 | 6.253 | 21434.0 |
| 540 | 2022-10-04 16:56:00 | sampled | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 539 | 2022-08-29 01:29:26 | sampled | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 538 | 2022-08-25 02:28:36 | sampled | 3 | 134027 | 574 | 6.296 | 21287.6 |
| 537 | 2022-08-18 18:38:31 | sampled | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 536 | 2022-06-17 10:19:58 | sampled | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 535 | 2022-06-10 15:53:06 | sampled | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 534 | 2022-06-04 10:36:24 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 533 | 2022-05-28 04:46:02 | sampled | 3 | 134027 | 574 | 6.126 | 21878.4 |
| 532 | 2022-05-28 01:12:56 | sampled | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 531 | 2022-05-22 21:38:23 | sampled | 3 | 134027 | 574 | 6.093 | 21996.9 |
| 530 | 2022-05-22 19:09:37 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 529 | 2022-04-27 03:06:05 | sampled | 3 | 134027 | 574 | 6.033 | 22215.6 |
| 528 | 2022-02-04 04:30:37 | sampled | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 527 | 2022-01-30 03:02:03 | sampled | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 526 | 2021-12-16 22:10:16 | sampled | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 525 | 2021-12-14 20:37:16 | sampled | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 524 | 2021-10-10 02:06:00 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 523 | 2021-07-23 05:33:12 | sampled | 3 | 134027 | 574 | 6.656 | 20136.3 |
| 522 | 2021-07-17 05:33:26 | sampled | 3 | 134027 | 574 | 6.000 | 22337.8 |
| 521 | 2021-07-08 05:22:40 | sampled | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 520 | 2021-07-05 22:11:49 | sampled | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 519 | 2021-06-07 00:23:45 | sampled | 3 | 134027 | 574 | 5.940 | 22563.5 |
| 518 | 2021-06-06 19:18:10 | sampled | 3 | 134027 | 574 | 6.983 | 19193.3 |
| 517 | 2021-06-06 14:23:10 | sampled | 3 | 134027 | 574 | 7.030 | 19065.0 |
| 516 | 2021-06-06 08:57:11 | sampled | 3 | 134027 | 574 | 7.373 | 18178.1 |
| 515 | 2021-06-05 20:03:57 | sampled | 3 | 134027 | 574 | 7.080 | 18930.4 |
| 514 | 2021-06-05 18:10:47 | sampled | 3 | 134027 | 574 | 14.236 | 9414.7 |
| 513 | 2021-06-05 10:03:56 | sampled | 3 | 134027 | 574 | 7.360 | 18210.2 |
| 512 | 2021-06-05 08:17:57 | sampled | 3 | 134027 | 574 | 7.203 | 18607.1 |
| 511 | 2021-06-04 19:26:19 | sampled | 3 | 134027 | 574 | 7.110 | 18850.5 |
| 510 | 2021-06-04 12:01:41 | sampled | 3 | 134027 | 574 | 6.720 | 19944.5 |
| 509 | 2021-06-04 04:49:49 | sampled | 3 | 134027 | 574 | 6.250 | 21444.3 |
| 508 | 2021-06-01 03:17:06 | sampled | 3 | 134027 | 574 | 7.326 | 18294.7 |
| 507 | 2021-05-31 16:46:16 | sampled | 3 | 134027 | 574 | 6.170 | 21722.4 |
| 506 | 2021-05-31 12:43:19 | sampled | 3 | 134027 | 574 | 6.750 | 19855.9 |
| 505 | 2021-05-31 06:45:28 | sampled | 3 | 134027 | 574 | 6.360 | 21073.4 |
| 504 | 2021-05-30 16:08:17 | sampled | 3 | 134027 | 574 | 7.310 | 18334.7 |
| 503 | 2021-05-30 15:05:35 | sampled | 3 | 134027 | 574 | 6.140 | 21828.5 |
| 502 | 2021-05-30 09:08:05 | sampled | 3 | 134027 | 574 | 6.190 | 21652.2 |
| 501 | 2021-05-30 08:26:17 | sampled | 3 | 134027 | 574 | 6.673 | 20085.0 |
| 500 | 2021-05-29 19:34:38 | sampled | 3 | 134027 | 574 | 5.800 | 23108.1 |
| 499 | 2021-05-29 06:17:25 | sampled | 3 | 134027 | 574 | 6.826 | 19634.8 |
| 498 | 2021-05-28 09:26:28 | sampled | 3 | 134027 | 574 | 6.076 | 22058.4 |
| 497 | 2021-05-28 01:10:21 | sampled | 3 | 134027 | 574 | 6.750 | 19855.9 |
| 496 | 2021-05-27 20:41:46 | sampled | 3 | 134027 | 574 | 7.190 | 18640.8 |
| 495 | 2021-05-27 13:23:50 | sampled | 3 | 134027 | 574 | 7.126 | 18808.2 |
| 494 | 2021-05-27 13:09:12 | sampled | 3 | 134027 | 574 | 7.326 | 18294.7 |
| 493 | 2021-05-27 06:21:24 | sampled | 3 | 134027 | 574 | 5.810 | 23068.3 |
| 492 | 2021-05-26 23:45:25 | sampled | 3 | 134027 | 574 | 6.783 | 19759.3 |