History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subfield"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 568 | 2025-11-29 23:17:33 | subfield | 1 | 82945 | 2 | 1.513 | 54821.5 |
| 567 | 2025-11-28 13:33:03 | subfield | 1 | 82945 | 2 | 1.326 | 62552.8 |
| 566 | 2025-11-23 03:59:15 | subfield | 4 | 161609 | 543 | 11.720 | 13789.2 |
| 565 | 2025-11-21 04:55:09 | subfield | 1 | 82945 | 2 | 1.626 | 51011.7 |
| 564 | 2025-11-19 02:23:20 | subfield | 1 | 82945 | 2 | 6.530 | 12702.1 |
| 563 | 2025-11-11 23:29:13 | subfield | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 562 | 2025-11-11 08:15:20 | subfield | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 561 | 2025-11-10 10:22:26 | subfield | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 560 | 2025-11-07 20:57:10 | subfield | 2 | 121059 | 6 | 4.203 | 28803.0 |
| 559 | 2025-11-07 04:15:49 | subfield | 1 | 82945 | 2 | 1.330 | 62364.7 |
| 558 | 2025-11-06 08:01:48 | subfield | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 557 | 2025-11-02 06:08:07 | subfield | 2 | 121059 | 6 | 3.563 | 33976.7 |
| 556 | 2025-11-01 21:26:04 | subfield | 3 | 146162 | 48 | 7.580 | 19282.6 |
| 555 | 2025-10-30 00:23:09 | subfield | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 554 | 2025-10-29 14:11:55 | subfield | 1 | 82945 | 2 | 1.440 | 57600.7 |
| 553 | 2025-10-23 13:39:21 | subfield | 4 | 161609 | 543 | 64.783 | 2494.6 |
| 552 | 2025-10-21 06:09:30 | subfield | 1 | 82945 | 2 | 3.750 | 22118.7 |
| 551 | 2025-10-19 03:29:12 | subfield | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 550 | 2025-10-17 09:30:02 | subfield | 4 | 161609 | 543 | 10.626 | 15208.8 |
| 549 | 2025-10-12 00:09:59 | subfield | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 548 | 2025-10-10 11:24:51 | subfield | 1 | 82945 | 2 | 2.826 | 29350.7 |
| 547 | 2025-10-10 01:07:59 | subfield | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 546 | 2025-10-07 05:29:08 | subfield | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 545 | 2025-10-06 09:03:39 | subfield | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 544 | 2025-10-04 22:23:24 | subfield | 1 | 82945 | 2 | 1.486 | 55817.6 |
| 543 | 2025-09-29 00:27:53 | subfield | 1 | 82945 | 2 | 2.313 | 35860.4 |
| 542 | 2025-09-28 14:33:15 | subfield | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 541 | 2025-09-19 06:23:31 | subfield | 1 | 82945 | 2 | 1.610 | 51518.6 |
| 540 | 2025-09-18 03:20:56 | subfield | 1 | 82945 | 2 | 1.486 | 55817.6 |
| 539 | 2025-09-16 02:49:59 | subfield | 3 | 146162 | 48 | 7.453 | 19611.2 |
| 538 | 2025-09-09 11:06:59 | subfield | 1 | 82945 | 2 | 1.560 | 53169.9 |
| 537 | 2025-09-06 18:05:24 | subfield | 3 | 146162 | 48 | 6.923 | 21112.5 |
| 536 | 2025-09-06 05:03:35 | subfield | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 535 | 2025-09-06 00:10:19 | subfield | 1 | 82945 | 2 | 2.186 | 37943.7 |
| 534 | 2025-08-29 00:09:54 | subfield | 1 | 82945 | 2 | 1.346 | 61623.3 |
| 533 | 2025-08-28 14:34:34 | subfield | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 532 | 2025-08-26 05:19:18 | subfield | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 531 | 2025-08-17 06:10:57 | subfield | 1 | 82945 | 2 | 3.646 | 22749.6 |
| 530 | 2025-08-17 03:34:29 | subfield | 1 | 82945 | 2 | 3.640 | 22787.1 |
| 529 | 2025-08-13 18:27:29 | subfield | 1 | 82945 | 2 | 7.626 | 10876.6 |
| 528 | 2025-08-12 21:58:29 | subfield | 1 | 82945 | 2 | 7.030 | 11798.7 |
| 527 | 2025-08-09 11:32:33 | subfield | 1 | 82945 | 2 | 5.110 | 16231.9 |
| 526 | 2025-08-05 03:34:09 | subfield | 2 | 121059 | 6 | 8.250 | 14673.8 |
| 525 | 2025-08-04 05:23:38 | subfield | 1 | 82945 | 2 | 3.563 | 23279.5 |
| 524 | 2025-08-03 05:29:44 | subfield | 1 | 82945 | 2 | 2.876 | 28840.4 |
| 523 | 2025-08-02 02:04:59 | subfield | 1 | 82945 | 2 | 3.343 | 24811.5 |
| 522 | 2025-07-24 11:52:43 | subfield | 1 | 82945 | 2 | 5.970 | 13893.6 |
| 521 | 2025-07-24 02:25:12 | subfield | 1 | 82945 | 2 | 7.893 | 10508.7 |
| 520 | 2025-07-17 19:15:47 | subfield | 1 | 82945 | 2 | 5.046 | 16437.8 |
| 519 | 2025-07-17 09:02:34 | subfield | 1 | 82945 | 2 | 3.843 | 21583.4 |
| 518 | 2025-07-08 14:29:11 | subfield | 1 | 82945 | 2 | 3.640 | 22787.1 |
| 517 | 2025-07-07 03:38:41 | subfield | 1 | 82945 | 2 | 6.686 | 12405.8 |
| 516 | 2025-06-26 11:28:56 | subfield | 1 | 82945 | 2 | 7.063 | 11743.6 |
| 515 | 2025-06-16 07:48:30 | subfield | 1 | 82945 | 2 | 6.376 | 13008.9 |
| 514 | 2025-06-10 23:55:27 | subfield | 3 | 146162 | 48 | 7.546 | 19369.5 |
| 513 | 2025-06-10 21:25:38 | subfield | 2 | 121059 | 6 | 21.266 | 5692.6 |
| 512 | 2025-06-05 03:46:52 | subfield | 1 | 82945 | 2 | 7.326 | 11322.0 |
| 511 | 2025-06-04 09:17:23 | subfield | 1 | 82945 | 2 | 6.423 | 12913.7 |
| 510 | 2025-05-26 11:12:50 | subfield | 1 | 82945 | 2 | 8.266 | 10034.5 |
| 509 | 2025-05-17 03:08:45 | subfield | 2 | 121059 | 6 | 17.050 | 7100.2 |
| 508 | 2025-05-15 08:08:01 | subfield | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 507 | 2025-05-14 08:45:45 | subfield | 2 | 121059 | 6 | 21.033 | 5755.7 |
| 506 | 2025-05-13 22:02:15 | subfield | 3 | 146162 | 48 | 39.286 | 3720.5 |
| 505 | 2025-05-13 04:02:39 | subfield | 3 | 146162 | 48 | 18.876 | 7743.3 |
| 504 | 2025-05-08 14:09:50 | subfield | 1 | 82945 | 2 | 4.890 | 16962.2 |
| 503 | 2025-05-04 14:50:44 | subfield | 2 | 121059 | 6 | 35.423 | 3417.5 |
| 502 | 2025-05-04 10:29:24 | subfield | 4 | 161609 | 543 | 49.003 | 3297.9 |
| 501 | 2025-05-02 19:15:55 | subfield | 3 | 146162 | 48 | 7.283 | 20068.9 |
| 500 | 2025-05-02 00:23:04 | subfield | 1 | 82945 | 2 | 6.903 | 12015.8 |
| 499 | 2025-05-01 20:30:46 | subfield | 3 | 146162 | 48 | 43.470 | 3362.4 |
| 498 | 2025-04-30 21:42:51 | subfield | 3 | 146162 | 48 | 38.223 | 3823.9 |
| 497 | 2025-04-30 08:45:56 | subfield | 1 | 82945 | 2 | 8.796 | 9429.9 |
| 496 | 2025-04-30 03:55:13 | subfield | 3 | 146162 | 48 | 28.126 | 5196.7 |
| 495 | 2025-04-29 05:29:06 | subfield | 3 | 146162 | 48 | 36.280 | 4028.7 |
| 494 | 2025-04-27 23:24:44 | subfield | 3 | 146162 | 48 | 36.423 | 4012.9 |
| 493 | 2025-04-26 07:21:19 | subfield | 3 | 146162 | 48 | 37.906 | 3855.9 |
| 492 | 2025-04-25 21:03:44 | subfield | 4 | 161609 | 543 | 71.333 | 2265.6 |
| 491 | 2025-04-25 10:50:00 | subfield | 1 | 82945 | 2 | 6.923 | 11981.1 |
| 490 | 2025-04-14 07:34:46 | subfield | 1 | 82945 | 2 | 6.580 | 12605.6 |
| 489 | 2025-03-31 16:35:43 | subfield | 1 | 82945 | 2 | 10.546 | 7865.1 |
| 488 | 2025-03-27 10:55:08 | subfield | 1 | 82945 | 2 | 6.203 | 13371.8 |
| 487 | 2025-03-20 13:14:00 | subfield | 1 | 82945 | 2 | 6.093 | 13613.2 |
| 486 | 2025-03-11 15:32:45 | subfield | 1 | 82945 | 2 | 4.686 | 17700.6 |
| 485 | 2025-03-03 19:44:42 | subfield | 1 | 82945 | 2 | 6.563 | 12638.3 |
| 484 | 2025-02-03 22:35:15 | subfield | 1 | 82945 | 2 | 5.296 | 15661.8 |
| 483 | 2025-02-01 10:09:10 | subfield | 2 | 121059 | 6 | 18.966 | 6382.9 |
| 482 | 2025-01-29 18:48:09 | subfield | 4 | 161609 | 543 | 20.593 | 7847.8 |
| 481 | 2025-01-29 15:33:46 | subfield | 4 | 161609 | 543 | 51.643 | 3129.3 |
| 480 | 2025-01-29 02:32:58 | subfield | 4 | 161609 | 543 | 78.036 | 2071.0 |
| 479 | 2025-01-28 23:56:05 | subfield | 4 | 161609 | 543 | 52.050 | 3104.9 |
| 478 | 2025-01-28 23:56:04 | subfield | 2 | 121059 | 6 | 18.063 | 6702.0 |
| 477 | 2025-01-28 23:55:48 | subfield | 1 | 82945 | 2 | 7.466 | 11109.7 |
| 476 | 2025-01-25 02:40:15 | subfield | 1 | 82945 | 2 | 3.813 | 21753.2 |
| 475 | 2025-01-04 18:51:20 | subfield | 3 | 146162 | 48 | 6.406 | 22816.4 |
| 474 | 2024-12-29 15:57:39 | subfield | 3 | 146162 | 48 | 32.266 | 4529.9 |
| 473 | 2024-12-28 21:03:39 | subfield | 2 | 121059 | 6 | 3.640 | 33258.0 |
| 472 | 2024-12-28 21:03:34 | subfield | 1 | 82945 | 2 | 1.420 | 58412.0 |
| 471 | 2024-12-28 20:05:37 | subfield | 4 | 161609 | 543 | 77.803 | 2077.2 |
| 470 | 2024-12-28 16:27:28 | subfield | 4 | 161609 | 543 | 58.646 | 2755.7 |
| 469 | 2024-12-28 15:40:45 | subfield | 4 | 161609 | 543 | 31.270 | 5168.2 |