History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trapline"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 505 | 2025-10-12 15:37:22 | trapline | 3 | 146162 | 199 | 8.016 | 18233.8 |
| 504 | 2025-09-16 18:26:31 | trapline | 3 | 146162 | 199 | 7.406 | 19735.6 |
| 503 | 2025-09-12 19:21:22 | trapline | 3 | 146162 | 199 | 7.110 | 20557.2 |
| 502 | 2025-09-09 20:36:55 | trapline | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 501 | 2025-09-09 16:07:08 | trapline | 3 | 146162 | 199 | 9.050 | 16150.5 |
| 500 | 2025-08-27 08:33:42 | trapline | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 499 | 2025-08-25 03:50:41 | trapline | 1 | 82945 | 5 | 7.126 | 11639.8 |
| 498 | 2025-08-19 15:01:10 | trapline | 1 | 82945 | 5 | 3.966 | 20914.0 |
| 497 | 2025-08-18 22:55:00 | trapline | 3 | 146162 | 199 | 24.203 | 6039.0 |
| 496 | 2025-08-16 16:02:52 | trapline | 3 | 146162 | 199 | 7.173 | 20376.7 |
| 495 | 2025-08-14 23:23:09 | trapline | 1 | 82945 | 5 | 5.610 | 14785.2 |
| 494 | 2025-08-14 21:20:14 | trapline | 3 | 146162 | 199 | 30.406 | 4807.0 |
| 493 | 2025-08-13 07:26:15 | trapline | 3 | 146162 | 199 | 44.080 | 3315.8 |
| 492 | 2025-08-12 06:15:51 | trapline | 3 | 146162 | 199 | 17.576 | 8316.0 |
| 491 | 2025-08-05 17:16:08 | trapline | 1 | 82945 | 5 | 5.736 | 14460.4 |
| 490 | 2025-08-04 08:42:03 | trapline | 1 | 82945 | 5 | 4.843 | 17126.8 |
| 489 | 2025-08-02 03:40:10 | trapline | 1 | 82945 | 5 | 3.686 | 22502.7 |
| 488 | 2025-08-01 03:02:16 | trapline | 1 | 82945 | 5 | 5.906 | 14044.2 |
| 487 | 2025-07-27 08:55:25 | trapline | 1 | 82945 | 5 | 3.186 | 26034.2 |
| 486 | 2025-07-27 03:48:42 | trapline | 1 | 82945 | 5 | 9.423 | 8802.4 |
| 485 | 2025-07-26 12:16:28 | trapline | 1 | 82945 | 5 | 6.373 | 13015.1 |
| 484 | 2025-07-24 18:00:03 | trapline | 1 | 82945 | 5 | 3.170 | 26165.6 |
| 483 | 2025-07-23 01:13:27 | trapline | 1 | 82945 | 5 | 3.313 | 25036.2 |
| 482 | 2025-07-22 14:32:34 | trapline | 3 | 146162 | 199 | 31.093 | 4700.8 |
| 481 | 2025-07-17 22:02:59 | trapline | 1 | 82945 | 5 | 4.703 | 17636.6 |
| 480 | 2025-07-17 00:33:25 | trapline | 3 | 146162 | 199 | 18.593 | 7861.1 |
| 479 | 2025-07-15 17:06:36 | trapline | 1 | 82945 | 5 | 3.123 | 26559.4 |
| 478 | 2025-07-11 12:03:12 | trapline | 3 | 146162 | 199 | 36.236 | 4033.6 |
| 477 | 2025-07-11 00:58:56 | trapline | 2 | 121059 | 29 | 17.770 | 6812.5 |
| 476 | 2025-07-10 09:46:51 | trapline | 3 | 146162 | 199 | 8.343 | 17519.1 |
| 475 | 2025-07-07 15:24:59 | trapline | 1 | 82945 | 5 | 9.530 | 8703.6 |
| 474 | 2025-07-03 15:31:37 | trapline | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 473 | 2025-07-01 16:12:49 | trapline | 1 | 82945 | 5 | 1.403 | 59119.7 |
| 472 | 2025-06-30 09:06:45 | trapline | 1 | 82945 | 5 | 7.326 | 11322.0 |
| 471 | 2025-06-29 01:35:01 | trapline | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 470 | 2025-06-25 09:24:29 | trapline | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 469 | 2025-06-25 03:19:19 | trapline | 1 | 82945 | 5 | 5.750 | 14425.2 |
| 468 | 2025-06-24 01:50:32 | trapline | 1 | 82945 | 5 | 3.470 | 23903.5 |
| 467 | 2025-06-20 12:05:28 | trapline | 1 | 82945 | 5 | 7.390 | 11224.0 |
| 466 | 2025-06-12 23:45:22 | trapline | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 465 | 2025-06-06 10:51:54 | trapline | 3 | 146162 | 199 | 37.893 | 3857.2 |
| 464 | 2025-06-05 09:27:01 | trapline | 3 | 146162 | 199 | 37.276 | 3921.1 |
| 463 | 2025-06-03 13:46:20 | trapline | 3 | 146162 | 199 | 19.830 | 7370.8 |
| 462 | 2025-06-02 06:13:32 | trapline | 1 | 82945 | 5 | 5.126 | 16181.2 |
| 461 | 2025-06-01 07:58:07 | trapline | 1 | 82945 | 5 | 7.640 | 10856.7 |
| 460 | 2025-05-31 15:56:05 | trapline | 1 | 82945 | 5 | 7.423 | 11174.1 |
| 459 | 2025-05-30 16:06:44 | trapline | 1 | 82945 | 5 | 5.016 | 16536.1 |
| 458 | 2025-05-30 03:32:52 | trapline | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 457 | 2025-05-30 00:44:52 | trapline | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 456 | 2025-05-26 13:14:31 | trapline | 2 | 121059 | 29 | 10.546 | 11479.1 |
| 455 | 2025-05-26 08:13:01 | trapline | 1 | 82945 | 5 | 6.953 | 11929.4 |
| 454 | 2025-05-26 07:54:41 | trapline | 3 | 146162 | 199 | 39.610 | 3690.0 |
| 453 | 2025-05-25 03:58:09 | trapline | 1 | 82945 | 5 | 1.576 | 52630.1 |
| 452 | 2025-05-24 02:31:27 | trapline | 1 | 82945 | 5 | 9.610 | 8631.1 |
| 451 | 2025-05-20 08:34:50 | trapline | 1 | 82945 | 5 | 3.500 | 23698.6 |
| 450 | 2025-05-18 05:32:21 | trapline | 1 | 82945 | 5 | 8.440 | 9827.6 |
| 449 | 2025-05-14 16:31:14 | trapline | 1 | 82945 | 5 | 6.783 | 12228.4 |
| 448 | 2025-04-28 01:18:28 | trapline | 1 | 82945 | 5 | 7.423 | 11174.1 |
| 447 | 2025-04-23 02:06:07 | trapline | 1 | 82945 | 5 | 3.686 | 22502.7 |
| 446 | 2025-04-21 01:47:05 | trapline | 1 | 82945 | 5 | 3.783 | 21925.7 |
| 445 | 2025-03-31 05:02:13 | trapline | 1 | 82945 | 5 | 5.316 | 15602.9 |
| 444 | 2025-03-20 02:12:22 | trapline | 1 | 82945 | 5 | 6.690 | 12398.4 |
| 443 | 2025-03-20 00:44:33 | trapline | 1 | 82945 | 5 | 7.313 | 11342.1 |
| 442 | 2025-03-19 03:02:43 | trapline | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 441 | 2025-03-16 22:01:13 | trapline | 3 | 146162 | 199 | 37.050 | 3945.0 |
| 440 | 2025-03-16 18:17:36 | trapline | 1 | 82945 | 5 | 3.326 | 24938.4 |
| 439 | 2025-03-16 18:16:45 | trapline | 3 | 146162 | 199 | 37.520 | 3895.6 |
| 438 | 2025-03-16 18:15:23 | trapline | 3 | 146162 | 199 | 33.656 | 4342.8 |
| 437 | 2025-03-16 18:15:21 | trapline | 2 | 121059 | 29 | 24.076 | 5028.2 |
| 436 | 2025-03-16 15:27:16 | trapline | 3 | 146162 | 199 | 27.266 | 5360.6 |
| 435 | 2025-03-16 13:06:18 | trapline | 3 | 146162 | 199 | 30.550 | 4784.4 |
| 434 | 2025-03-15 20:17:00 | trapline | 3 | 146162 | 199 | 37.883 | 3858.2 |
| 433 | 2025-03-15 02:18:34 | trapline | 3 | 146162 | 199 | 37.673 | 3879.8 |
| 432 | 2025-02-27 16:49:36 | trapline | 1 | 82945 | 5 | 5.313 | 15611.7 |
| 431 | 2025-02-23 16:11:57 | trapline | 3 | 146162 | 199 | 28.953 | 5048.3 |
| 430 | 2025-02-15 01:08:04 | trapline | 1 | 82945 | 5 | 5.436 | 15258.5 |
| 429 | 2025-02-10 00:04:03 | trapline | 3 | 146162 | 199 | 35.440 | 4124.2 |
| 428 | 2025-02-08 07:45:51 | trapline | 1 | 82945 | 5 | 6.733 | 12319.2 |
| 427 | 2025-02-08 07:43:18 | trapline | 2 | 121059 | 29 | 15.516 | 7802.2 |
| 426 | 2025-02-06 12:34:38 | trapline | 3 | 146162 | 199 | 57.800 | 2528.8 |
| 425 | 2025-02-06 10:20:06 | trapline | 3 | 146162 | 199 | 18.766 | 7788.7 |
| 424 | 2025-02-05 20:29:54 | trapline | 3 | 146162 | 199 | 7.486 | 19524.7 |
| 423 | 2025-02-05 20:29:53 | trapline | 2 | 121059 | 29 | 3.843 | 31501.2 |
| 422 | 2025-02-05 20:29:52 | trapline | 1 | 82945 | 5 | 1.503 | 55186.3 |
| 421 | 2025-02-01 02:46:33 | trapline | 1 | 82945 | 5 | 3.703 | 22399.4 |
| 420 | 2025-01-08 16:09:54 | trapline | 3 | 146162 | 199 | 41.550 | 3517.7 |
| 419 | 2025-01-08 16:10:00 | trapline | 2 | 121059 | 29 | 26.846 | 4509.4 |
| 418 | 2025-01-08 13:15:52 | trapline | 2 | 121059 | 29 | 10.250 | 11810.6 |
| 417 | 2025-01-08 13:15:49 | trapline | 1 | 82945 | 5 | 3.983 | 20824.8 |
| 416 | 2025-01-06 13:56:18 | trapline | 3 | 146162 | 199 | 27.783 | 5260.8 |
| 415 | 2025-01-06 01:05:02 | trapline | 2 | 121059 | 29 | 5.796 | 20886.6 |
| 414 | 2025-01-06 00:34:51 | trapline | 3 | 146162 | 199 | 20.406 | 7162.7 |
| 413 | 2025-01-05 14:05:18 | trapline | 1 | 82945 | 5 | 3.393 | 24445.9 |
| 412 | 2025-01-05 13:07:37 | trapline | 3 | 146162 | 199 | 7.656 | 19091.2 |
| 411 | 2025-01-05 13:07:36 | trapline | 2 | 121059 | 29 | 3.906 | 30993.1 |
| 410 | 2024-12-09 21:21:33 | trapline | 1 | 82945 | 5 | 6.953 | 11929.4 |
| 409 | 2024-12-06 03:35:31 | trapline | 1 | 82945 | 5 | 6.876 | 12063.0 |
| 408 | 2024-11-29 10:04:36 | trapline | 1 | 82945 | 5 | 4.000 | 20736.3 |
| 407 | 2024-11-08 01:33:43 | trapline | 1 | 82945 | 5 | 5.703 | 14544.1 |
| 406 | 2024-11-06 00:13:21 | trapline | 1 | 82945 | 5 | 9.300 | 8918.8 |