History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"porthole"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 519 | 2025-12-03 15:29:32 | porthole | 2 | 121059 | 12 | 4.046 | 29920.7 |
| 518 | 2025-11-17 04:33:48 | porthole | 1 | 82945 | 4 | 1.486 | 55817.6 |
| 517 | 2025-11-05 21:29:07 | porthole | 1 | 82945 | 4 | 5.796 | 14310.7 |
| 516 | 2025-11-02 17:20:56 | porthole | 1 | 82945 | 4 | 1.466 | 56579.1 |
| 515 | 2025-10-26 16:28:00 | porthole | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 514 | 2025-10-21 05:25:41 | porthole | 1 | 82945 | 4 | 3.826 | 21679.3 |
| 513 | 2025-09-08 02:52:05 | porthole | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 512 | 2025-08-10 16:46:31 | porthole | 1 | 82945 | 4 | 3.610 | 22976.5 |
| 511 | 2025-08-09 10:02:22 | porthole | 1 | 82945 | 4 | 8.826 | 9397.8 |
| 510 | 2025-08-07 18:49:50 | porthole | 1 | 82945 | 4 | 3.373 | 24590.9 |
| 509 | 2025-08-05 21:43:19 | porthole | 1 | 82945 | 4 | 3.046 | 27230.8 |
| 508 | 2025-08-04 10:23:37 | porthole | 1 | 82945 | 4 | 6.970 | 11900.3 |
| 507 | 2025-08-01 06:20:17 | porthole | 3 | 146162 | 79 | 50.283 | 2906.8 |
| 506 | 2025-07-30 16:55:56 | porthole | 2 | 121059 | 12 | 19.800 | 6114.1 |
| 505 | 2025-07-24 00:45:50 | porthole | 1 | 82945 | 4 | 3.516 | 23590.7 |
| 504 | 2025-07-22 11:48:17 | porthole | 1 | 82945 | 4 | 6.500 | 12760.8 |
| 503 | 2025-07-20 17:49:38 | porthole | 2 | 121059 | 12 | 4.313 | 28068.4 |
| 502 | 2025-07-20 17:34:38 | porthole | 3 | 146162 | 79 | 8.046 | 18165.8 |
| 501 | 2025-07-13 08:09:40 | porthole | 1 | 82945 | 4 | 1.560 | 53169.9 |
| 500 | 2025-07-09 07:47:46 | porthole | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 499 | 2025-07-07 10:20:50 | porthole | 1 | 82945 | 4 | 5.393 | 15380.1 |
| 498 | 2025-07-04 11:02:58 | porthole | 1 | 82945 | 4 | 5.873 | 14123.1 |
| 497 | 2025-07-04 00:56:39 | porthole | 1 | 82945 | 4 | 7.110 | 11666.0 |
| 496 | 2025-07-03 01:08:28 | porthole | 2 | 121059 | 12 | 22.800 | 5309.6 |
| 495 | 2025-07-01 21:45:08 | porthole | 1 | 82945 | 4 | 7.716 | 10749.7 |
| 494 | 2025-06-29 09:45:10 | porthole | 1 | 82945 | 4 | 1.750 | 47397.1 |
| 493 | 2025-06-28 04:43:42 | porthole | 3 | 146162 | 79 | 47.693 | 3064.6 |
| 492 | 2025-06-27 11:01:11 | porthole | 3 | 146162 | 79 | 34.033 | 4294.7 |
| 491 | 2025-06-24 06:25:30 | porthole | 3 | 146162 | 79 | 47.533 | 3075.0 |
| 490 | 2025-06-22 04:09:11 | porthole | 1 | 82945 | 4 | 7.783 | 10657.2 |
| 489 | 2025-06-20 13:16:37 | porthole | 2 | 121059 | 12 | 3.563 | 33976.7 |
| 488 | 2025-06-17 20:31:51 | porthole | 3 | 146162 | 79 | 36.643 | 3988.8 |
| 487 | 2025-06-17 08:29:52 | porthole | 3 | 146162 | 79 | 8.470 | 17256.4 |
| 486 | 2025-06-17 07:01:06 | porthole | 2 | 121059 | 12 | 4.110 | 29454.7 |
| 485 | 2025-06-16 11:57:34 | porthole | 2 | 121059 | 12 | 19.780 | 6120.3 |
| 484 | 2025-06-15 21:07:29 | porthole | 2 | 121059 | 12 | 22.686 | 5336.3 |
| 483 | 2025-06-15 18:48:14 | porthole | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 482 | 2025-06-13 23:23:30 | porthole | 2 | 121059 | 12 | 17.313 | 6992.4 |
| 481 | 2025-06-13 21:20:20 | porthole | 3 | 146162 | 79 | 26.766 | 5460.7 |
| 480 | 2025-06-13 07:25:15 | porthole | 1 | 82945 | 4 | 2.466 | 33635.4 |
| 479 | 2025-06-11 16:17:38 | porthole | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 478 | 2025-06-08 17:50:43 | porthole | 1 | 82945 | 4 | 5.736 | 14460.4 |
| 477 | 2025-06-07 10:15:04 | porthole | 4 | 161609 | 688 | 14.876 | 10863.7 |
| 476 | 2025-06-02 18:16:30 | porthole | 4 | 161609 | 688 | 13.156 | 12284.1 |
| 475 | 2025-06-01 20:48:50 | porthole | 4 | 161609 | 688 | 46.096 | 3505.9 |
| 474 | 2025-05-31 17:44:13 | porthole | 4 | 161609 | 688 | 62.863 | 2570.8 |
| 473 | 2025-05-30 11:06:38 | porthole | 2 | 121059 | 12 | 16.546 | 7316.5 |
| 472 | 2025-05-30 09:06:15 | porthole | 1 | 82945 | 4 | 9.736 | 8519.4 |
| 471 | 2025-05-29 06:12:15 | porthole | 4 | 161609 | 688 | 57.270 | 2821.9 |
| 470 | 2025-05-28 14:12:47 | porthole | 3 | 146162 | 79 | 16.656 | 8775.3 |
| 469 | 2025-05-28 10:03:39 | porthole | 2 | 121059 | 12 | 7.423 | 16308.6 |
| 468 | 2025-05-27 15:18:38 | porthole | 1 | 82945 | 4 | 4.843 | 17126.8 |
| 467 | 2025-05-25 19:56:28 | porthole | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 466 | 2025-05-25 14:04:32 | porthole | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 465 | 2025-05-24 21:26:13 | porthole | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 464 | 2025-05-24 15:34:21 | porthole | 1 | 82945 | 4 | 7.406 | 11199.7 |
| 463 | 2025-05-19 07:25:26 | porthole | 1 | 82945 | 4 | 2.953 | 28088.4 |
| 462 | 2025-05-17 20:22:28 | porthole | 3 | 146162 | 79 | 41.270 | 3541.6 |
| 461 | 2025-05-13 05:26:31 | porthole | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 460 | 2025-05-11 23:43:49 | porthole | 1 | 82945 | 4 | 10.250 | 8092.2 |
| 459 | 2025-05-11 21:09:29 | porthole | 3 | 146162 | 79 | 39.873 | 3665.7 |
| 458 | 2025-05-11 07:35:49 | porthole | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 457 | 2025-05-05 23:12:13 | porthole | 1 | 82945 | 4 | 7.236 | 11462.8 |
| 456 | 2025-05-05 06:19:47 | porthole | 2 | 121059 | 12 | 9.406 | 12870.4 |
| 455 | 2025-05-03 19:04:54 | porthole | 1 | 82945 | 4 | 3.143 | 26390.4 |
| 454 | 2025-05-01 08:56:12 | porthole | 1 | 82945 | 4 | 5.983 | 13863.4 |
| 453 | 2025-04-29 10:48:14 | porthole | 2 | 121059 | 12 | 20.206 | 5991.2 |
| 452 | 2025-04-28 08:42:01 | porthole | 3 | 146162 | 79 | 41.223 | 3545.6 |
| 451 | 2025-04-27 09:28:50 | porthole | 2 | 121059 | 12 | 3.763 | 32170.9 |
| 450 | 2025-04-26 14:55:12 | porthole | 1 | 82945 | 4 | 7.703 | 10767.9 |
| 449 | 2025-04-26 03:48:31 | porthole | 3 | 146162 | 79 | 44.203 | 3306.6 |
| 448 | 2025-04-25 09:08:28 | porthole | 1 | 82945 | 4 | 1.420 | 58412.0 |
| 447 | 2025-04-24 12:36:40 | porthole | 3 | 146162 | 79 | 34.346 | 4255.6 |
| 446 | 2025-04-21 14:12:46 | porthole | 1 | 82945 | 4 | 6.906 | 12010.6 |
| 445 | 2025-04-08 08:33:26 | porthole | 3 | 146162 | 79 | 41.486 | 3523.2 |
| 444 | 2025-04-06 23:13:58 | porthole | 3 | 146162 | 79 | 42.940 | 3403.9 |
| 443 | 2025-04-06 07:22:10 | porthole | 1 | 82945 | 4 | 6.906 | 12010.6 |
| 442 | 2025-04-03 02:12:04 | porthole | 3 | 146162 | 79 | 25.876 | 5648.6 |
| 441 | 2025-03-26 04:33:04 | porthole | 3 | 146162 | 79 | 29.750 | 4913.0 |
| 440 | 2025-03-23 05:06:21 | porthole | 2 | 121059 | 12 | 13.546 | 8936.9 |
| 439 | 2025-03-23 04:17:35 | porthole | 3 | 146162 | 79 | 33.626 | 4346.7 |
| 438 | 2025-03-22 20:55:58 | porthole | 1 | 82945 | 4 | 3.750 | 22118.7 |
| 437 | 2025-03-22 11:20:20 | porthole | 1 | 82945 | 4 | 4.440 | 18681.3 |
| 436 | 2025-03-20 16:51:20 | porthole | 1 | 82945 | 4 | 3.373 | 24590.9 |
| 435 | 2025-03-13 04:24:29 | porthole | 3 | 146162 | 79 | 37.316 | 3916.9 |
| 434 | 2025-03-13 03:56:24 | porthole | 1 | 82945 | 4 | 3.500 | 23698.6 |
| 433 | 2025-03-13 00:48:34 | porthole | 3 | 146162 | 79 | 38.926 | 3754.9 |
| 432 | 2025-03-05 12:44:16 | porthole | 3 | 146162 | 79 | 32.126 | 4549.6 |
| 431 | 2025-03-05 08:42:11 | porthole | 1 | 82945 | 4 | 5.296 | 15661.8 |
| 430 | 2025-03-05 08:41:13 | porthole | 3 | 146162 | 79 | 37.270 | 3921.7 |
| 429 | 2025-03-05 08:41:11 | porthole | 2 | 121059 | 12 | 12.250 | 9882.4 |
| 428 | 2025-03-01 23:11:36 | porthole | 1 | 82945 | 4 | 7.236 | 11462.8 |
| 427 | 2025-02-24 11:04:49 | porthole | 4 | 161609 | 688 | 55.333 | 2920.7 |
| 426 | 2025-02-21 11:28:09 | porthole | 4 | 161609 | 688 | 64.083 | 2521.9 |
| 425 | 2025-02-21 01:47:45 | porthole | 4 | 161609 | 688 | 65.253 | 2476.7 |
| 424 | 2025-02-20 13:18:36 | porthole | 4 | 161609 | 688 | 56.830 | 2843.7 |
| 423 | 2025-02-20 11:00:09 | porthole | 4 | 161609 | 688 | 53.973 | 2994.3 |
| 422 | 2025-02-17 10:58:24 | porthole | 4 | 161609 | 688 | 68.583 | 2356.4 |
| 421 | 2025-02-08 14:44:44 | porthole | 1 | 82945 | 4 | 10.656 | 7783.9 |
| 420 | 2025-02-06 23:55:54 | porthole | 1 | 82945 | 4 | 4.503 | 18419.9 |