History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"officers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 555 | 2025-11-14 22:00:50 | officers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 554 | 2025-10-20 01:02:36 | officers | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 553 | 2025-10-09 03:35:35 | officers | 1 | 82945 | 3 | 1.606 | 51646.9 |
| 552 | 2025-10-01 19:53:00 | officers | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 551 | 2025-09-20 04:22:46 | officers | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 550 | 2025-08-27 09:15:25 | officers | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 549 | 2025-08-22 03:38:53 | officers | 1 | 82945 | 3 | 2.156 | 38471.7 |
| 548 | 2025-08-02 23:39:27 | officers | 2 | 121059 | 10 | 25.030 | 4836.6 |
| 547 | 2025-08-01 20:16:56 | officers | 1 | 82945 | 3 | 5.750 | 14425.2 |
| 546 | 2025-07-31 21:36:25 | officers | 1 | 82945 | 3 | 6.220 | 13335.2 |
| 545 | 2025-07-28 10:55:38 | officers | 2 | 121059 | 10 | 10.766 | 11244.6 |
| 544 | 2025-07-27 09:25:48 | officers | 1 | 82945 | 3 | 3.580 | 23169.0 |
| 543 | 2025-07-25 08:09:08 | officers | 1 | 82945 | 3 | 3.280 | 25288.1 |
| 542 | 2025-07-15 04:39:25 | officers | 1 | 82945 | 3 | 9.080 | 9134.9 |
| 541 | 2025-07-14 12:50:09 | officers | 1 | 82945 | 3 | 7.126 | 11639.8 |
| 540 | 2025-07-11 15:23:33 | officers | 1 | 82945 | 3 | 7.453 | 11129.1 |
| 539 | 2025-06-24 01:27:47 | officers | 1 | 82945 | 3 | 9.313 | 8906.4 |
| 538 | 2025-06-23 08:55:38 | officers | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 537 | 2025-06-19 14:33:13 | officers | 4 | 161609 | 972 | 11.860 | 13626.4 |
| 536 | 2025-06-19 03:08:14 | officers | 4 | 161609 | 972 | 13.516 | 11956.9 |
| 535 | 2025-06-18 21:24:17 | officers | 4 | 161609 | 972 | 12.566 | 12860.8 |
| 534 | 2025-06-14 15:36:39 | officers | 1 | 82945 | 3 | 9.860 | 8412.3 |
| 533 | 2025-06-14 04:13:22 | officers | 1 | 82945 | 3 | 3.530 | 23497.2 |
| 532 | 2025-06-12 04:59:07 | officers | 1 | 82945 | 3 | 4.516 | 18366.9 |
| 531 | 2025-06-11 05:11:58 | officers | 1 | 82945 | 3 | 7.033 | 11793.7 |
| 530 | 2025-06-11 02:10:28 | officers | 4 | 161609 | 972 | 41.236 | 3919.1 |
| 529 | 2025-06-11 01:36:41 | officers | 4 | 161609 | 972 | 18.656 | 8662.6 |
| 528 | 2025-06-10 08:07:56 | officers | 4 | 161609 | 972 | 60.283 | 2680.8 |
| 527 | 2025-06-10 07:23:19 | officers | 4 | 161609 | 972 | 74.193 | 2178.2 |
| 526 | 2025-06-09 10:15:48 | officers | 4 | 161609 | 972 | 20.516 | 7877.2 |
| 525 | 2025-06-02 02:22:29 | officers | 1 | 82945 | 3 | 13.766 | 6025.4 |
| 524 | 2025-05-30 15:13:40 | officers | 1 | 82945 | 3 | 6.826 | 12151.3 |
| 523 | 2025-05-23 06:12:13 | officers | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 522 | 2025-05-20 13:36:21 | officers | 1 | 82945 | 3 | 6.343 | 13076.6 |
| 521 | 2025-05-20 10:38:38 | officers | 1 | 82945 | 3 | 9.610 | 8631.1 |
| 520 | 2025-05-19 21:04:35 | officers | 1 | 82945 | 3 | 11.780 | 7041.2 |
| 519 | 2025-05-14 19:53:21 | officers | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 518 | 2025-05-14 19:05:16 | officers | 1 | 82945 | 3 | 6.813 | 12174.5 |
| 517 | 2025-05-14 13:07:53 | officers | 1 | 82945 | 3 | 4.393 | 18881.2 |
| 516 | 2025-05-12 03:13:32 | officers | 1 | 82945 | 3 | 6.516 | 12729.4 |
| 515 | 2025-05-10 07:22:06 | officers | 4 | 161609 | 972 | 79.020 | 2045.2 |
| 514 | 2025-05-09 08:20:08 | officers | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 513 | 2025-05-09 01:30:46 | officers | 4 | 161609 | 972 | 67.456 | 2395.8 |
| 512 | 2025-05-08 10:20:18 | officers | 4 | 161609 | 972 | 50.143 | 3223.0 |
| 511 | 2025-05-07 20:04:36 | officers | 4 | 161609 | 972 | 65.176 | 2479.6 |
| 510 | 2025-05-07 02:25:23 | officers | 4 | 161609 | 972 | 14.203 | 11378.5 |
| 509 | 2025-05-06 08:40:08 | officers | 4 | 161609 | 972 | 58.610 | 2757.4 |
| 508 | 2025-05-06 00:29:00 | officers | 4 | 161609 | 972 | 47.360 | 3412.4 |
| 507 | 2025-05-04 23:31:25 | officers | 4 | 161609 | 972 | 55.223 | 2926.5 |
| 506 | 2025-05-03 23:29:21 | officers | 4 | 161609 | 972 | 66.803 | 2419.2 |
| 505 | 2025-04-29 14:24:53 | officers | 3 | 146162 | 84 | 7.483 | 19532.5 |
| 504 | 2025-04-27 15:23:10 | officers | 3 | 146162 | 84 | 6.060 | 24119.1 |
| 503 | 2025-04-24 16:54:46 | officers | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 502 | 2025-04-23 10:06:34 | officers | 2 | 121059 | 10 | 16.140 | 7500.6 |
| 501 | 2025-04-21 17:48:06 | officers | 3 | 146162 | 84 | 28.890 | 5059.3 |
| 500 | 2025-04-21 17:47:50 | officers | 2 | 121059 | 10 | 11.216 | 10793.4 |
| 499 | 2025-04-20 14:02:26 | officers | 3 | 146162 | 84 | 22.000 | 6643.7 |
| 498 | 2025-04-20 12:09:49 | officers | 1 | 82945 | 3 | 5.080 | 16327.8 |
| 497 | 2025-04-19 06:19:57 | officers | 3 | 146162 | 84 | 7.326 | 19951.1 |
| 496 | 2025-04-14 12:21:51 | officers | 1 | 82945 | 3 | 7.453 | 11129.1 |
| 495 | 2025-04-14 08:53:34 | officers | 1 | 82945 | 3 | 6.393 | 12974.3 |
| 494 | 2025-04-11 15:35:39 | officers | 1 | 82945 | 3 | 9.843 | 8426.8 |
| 493 | 2025-04-11 03:24:32 | officers | 1 | 82945 | 3 | 5.423 | 15295.0 |
| 492 | 2025-04-08 01:33:04 | officers | 4 | 161609 | 972 | 79.160 | 2041.5 |
| 491 | 2025-04-06 07:42:57 | officers | 4 | 161609 | 972 | 33.313 | 4851.2 |
| 490 | 2025-04-06 02:30:55 | officers | 3 | 146162 | 84 | 28.940 | 5050.5 |
| 489 | 2025-04-04 07:58:26 | officers | 3 | 146162 | 84 | 34.596 | 4224.8 |
| 488 | 2025-04-03 23:30:17 | officers | 4 | 161609 | 972 | 55.983 | 2886.8 |
| 487 | 2025-04-03 08:46:41 | officers | 1 | 82945 | 3 | 3.326 | 24938.4 |
| 486 | 2025-03-25 17:10:38 | officers | 3 | 146162 | 84 | 22.096 | 6614.9 |
| 485 | 2025-03-20 14:52:42 | officers | 1 | 82945 | 3 | 6.546 | 12671.1 |
| 484 | 2025-03-20 11:50:07 | officers | 3 | 146162 | 84 | 30.050 | 4864.0 |
| 483 | 2025-03-17 07:40:20 | officers | 3 | 146162 | 84 | 34.686 | 4213.9 |
| 482 | 2025-03-16 06:13:22 | officers | 3 | 146162 | 84 | 34.966 | 4180.1 |
| 481 | 2025-03-15 06:22:24 | officers | 3 | 146162 | 84 | 30.403 | 4807.5 |
| 480 | 2025-03-15 06:21:45 | officers | 1 | 82945 | 3 | 6.266 | 13237.3 |
| 479 | 2025-03-14 23:24:42 | officers | 1 | 82945 | 3 | 5.750 | 14425.2 |
| 478 | 2025-03-13 19:52:37 | officers | 4 | 161609 | 972 | 49.533 | 3262.7 |
| 477 | 2025-03-08 20:56:19 | officers | 2 | 121059 | 10 | 18.970 | 6381.6 |
| 476 | 2025-03-04 18:56:28 | officers | 3 | 146162 | 84 | 22.703 | 6438.0 |
| 475 | 2025-03-04 02:48:19 | officers | 3 | 146162 | 84 | 33.283 | 4391.5 |
| 474 | 2025-03-04 02:48:03 | officers | 2 | 121059 | 10 | 14.813 | 8172.5 |
| 473 | 2025-03-04 02:47:54 | officers | 1 | 82945 | 3 | 6.860 | 12091.1 |
| 472 | 2025-03-01 14:46:09 | officers | 1 | 82945 | 3 | 10.140 | 8180.0 |
| 471 | 2025-03-01 02:55:11 | officers | 3 | 146162 | 84 | 42.253 | 3459.2 |
| 470 | 2025-02-27 09:04:38 | officers | 4 | 161609 | 972 | 42.536 | 3799.3 |
| 469 | 2025-02-25 06:15:19 | officers | 4 | 161609 | 972 | 64.363 | 2510.9 |
| 468 | 2025-02-25 01:14:27 | officers | 4 | 161609 | 972 | 54.673 | 2955.9 |
| 467 | 2025-02-24 15:44:16 | officers | 4 | 161609 | 972 | 14.033 | 11516.4 |
| 466 | 2025-02-16 05:49:33 | officers | 4 | 161609 | 972 | 59.580 | 2712.5 |
| 465 | 2025-02-11 20:24:07 | officers | 3 | 146162 | 84 | 21.436 | 6818.5 |
| 464 | 2025-02-08 13:20:33 | officers | 3 | 146162 | 84 | 10.280 | 14218.1 |
| 463 | 2025-02-07 16:37:09 | officers | 1 | 82945 | 3 | 7.140 | 11616.9 |
| 462 | 2025-02-05 12:58:35 | officers | 3 | 146162 | 84 | 18.580 | 7866.6 |
| 461 | 2025-02-04 21:28:32 | officers | 1 | 82945 | 3 | 3.016 | 27501.7 |
| 460 | 2025-02-01 20:34:01 | officers | 1 | 82945 | 3 | 4.050 | 20480.2 |
| 459 | 2025-01-27 16:09:28 | officers | 2 | 121059 | 10 | 17.580 | 6886.2 |
| 458 | 2025-01-26 20:16:20 | officers | 2 | 121059 | 10 | 12.720 | 9517.2 |
| 457 | 2025-01-26 20:16:20 | officers | 1 | 82945 | 3 | 3.373 | 24590.9 |
| 456 | 2025-01-24 23:23:08 | officers | 3 | 146162 | 84 | 6.546 | 22328.4 |