History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lancer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 569 | 2025-10-22 12:42:03 | lancer | 1 | 48755 | 13 | 0.940 | 51867.0 |
| 568 | 2025-10-03 22:51:44 | lancer | 1 | 48755 | 13 | 0.783 | 62266.9 |
| 567 | 2025-09-21 14:48:26 | lancer | 1 | 48755 | 13 | 0.893 | 54596.9 |
| 566 | 2025-09-14 19:00:28 | lancer | 2 | 82551 | 164 | 8.033 | 10276.5 |
| 565 | 2025-09-14 10:17:53 | lancer | 1 | 48755 | 13 | 0.890 | 54780.9 |
| 564 | 2025-08-31 16:01:01 | lancer | 2 | 82551 | 164 | 2.233 | 36968.7 |
| 563 | 2025-08-22 01:56:51 | lancer | 1 | 48755 | 13 | 2.326 | 20960.9 |
| 562 | 2025-08-21 09:08:31 | lancer | 1 | 48755 | 13 | 3.766 | 12946.1 |
| 561 | 2025-08-19 23:15:09 | lancer | 2 | 82551 | 164 | 2.563 | 32208.7 |
| 560 | 2025-08-19 22:58:03 | lancer | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 559 | 2025-08-19 20:37:00 | lancer | 1 | 48755 | 13 | 0.920 | 52994.6 |
| 558 | 2025-08-11 08:16:24 | lancer | 1 | 48755 | 13 | 1.126 | 43299.3 |
| 557 | 2025-08-09 14:59:01 | lancer | 1 | 48755 | 13 | 4.310 | 11312.1 |
| 556 | 2025-08-04 09:11:23 | lancer | 1 | 48755 | 13 | 3.546 | 13749.3 |
| 555 | 2025-08-04 04:15:39 | lancer | 2 | 82551 | 164 | 6.343 | 13014.5 |
| 554 | 2025-08-04 00:44:34 | lancer | 1 | 48755 | 13 | 2.030 | 24017.2 |
| 553 | 2025-08-03 04:03:29 | lancer | 2 | 82551 | 164 | 7.233 | 11413.1 |
| 552 | 2025-07-31 14:13:15 | lancer | 1 | 48755 | 13 | 2.063 | 23633.1 |
| 551 | 2025-07-31 06:18:56 | lancer | 1 | 48755 | 13 | 1.390 | 35075.5 |
| 550 | 2025-07-28 02:36:21 | lancer | 2 | 82551 | 164 | 5.216 | 15826.5 |
| 549 | 2025-07-23 14:35:59 | lancer | 1 | 48755 | 13 | 5.690 | 8568.5 |
| 548 | 2025-07-22 15:59:10 | lancer | 1 | 48755 | 13 | 1.736 | 28084.7 |
| 547 | 2025-07-18 12:11:52 | lancer | 1 | 48755 | 13 | 3.346 | 14571.1 |
| 546 | 2025-07-18 01:43:07 | lancer | 1 | 48755 | 13 | 2.203 | 22131.2 |
| 545 | 2025-07-13 03:14:57 | lancer | 1 | 48755 | 13 | 0.860 | 56691.9 |
| 544 | 2025-07-08 06:46:05 | lancer | 1 | 48755 | 13 | 4.156 | 11731.2 |
| 543 | 2025-07-07 14:49:27 | lancer | 1 | 48755 | 13 | 5.843 | 8344.2 |
| 542 | 2025-07-07 12:58:50 | lancer | 1 | 48755 | 13 | 4.800 | 10157.3 |
| 541 | 2025-07-05 00:20:25 | lancer | 1 | 48755 | 13 | 4.403 | 11073.1 |
| 540 | 2025-07-04 10:25:02 | lancer | 1 | 48755 | 13 | 0.876 | 55656.4 |
| 539 | 2025-07-02 08:48:28 | lancer | 1 | 48755 | 13 | 3.406 | 14314.4 |
| 538 | 2025-06-28 20:14:53 | lancer | 2 | 82551 | 164 | 2.673 | 30883.3 |
| 537 | 2025-06-27 13:10:57 | lancer | 1 | 48755 | 13 | 1.953 | 24964.2 |
| 536 | 2025-06-27 08:23:51 | lancer | 2 | 82551 | 164 | 14.063 | 5870.1 |
| 535 | 2025-06-23 03:09:55 | lancer | 1 | 48755 | 13 | 0.763 | 63899.1 |
| 534 | 2025-06-23 01:24:15 | lancer | 1 | 48755 | 13 | 6.313 | 7723.0 |
| 533 | 2025-06-21 16:21:25 | lancer | 1 | 48755 | 13 | 3.126 | 15596.6 |
| 532 | 2025-06-18 11:06:27 | lancer | 1 | 48755 | 13 | 6.296 | 7743.8 |
| 531 | 2025-06-18 01:05:05 | lancer | 1 | 48755 | 13 | 2.686 | 18151.5 |
| 530 | 2025-06-06 14:32:06 | lancer | 1 | 48755 | 13 | 3.830 | 12729.8 |
| 529 | 2025-06-04 09:16:24 | lancer | 1 | 48755 | 13 | 1.953 | 24964.2 |
| 528 | 2025-06-04 00:28:01 | lancer | 1 | 48755 | 13 | 3.376 | 14441.6 |
| 527 | 2025-05-30 09:40:48 | lancer | 1 | 48755 | 13 | 4.190 | 11636.0 |
| 526 | 2025-05-27 04:24:15 | lancer | 1 | 48755 | 13 | 2.623 | 18587.5 |
| 525 | 2025-05-23 05:16:38 | lancer | 1 | 48755 | 13 | 4.313 | 11304.2 |
| 524 | 2025-05-23 03:58:55 | lancer | 1 | 48755 | 13 | 5.046 | 9662.1 |
| 523 | 2025-05-18 17:28:18 | lancer | 2 | 82551 | 164 | 12.783 | 6457.9 |
| 522 | 2025-05-18 07:36:52 | lancer | 2 | 82551 | 164 | 9.080 | 9091.5 |
| 521 | 2025-05-18 00:08:03 | lancer | 1 | 48755 | 13 | 4.953 | 9843.5 |
| 520 | 2025-05-17 14:13:42 | lancer | 1 | 48755 | 13 | 0.876 | 55656.4 |
| 519 | 2025-05-17 08:11:23 | lancer | 2 | 82551 | 164 | 6.076 | 13586.4 |
| 518 | 2025-05-16 23:48:19 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 517 | 2025-05-15 10:50:01 | lancer | 1 | 48755 | 13 | 3.530 | 13811.6 |
| 516 | 2025-05-08 09:46:23 | lancer | 2 | 82551 | 164 | 6.783 | 12170.3 |
| 515 | 2025-05-08 02:39:29 | lancer | 2 | 82551 | 164 | 12.876 | 6411.2 |
| 514 | 2025-05-07 05:44:23 | lancer | 1 | 48755 | 13 | 0.813 | 59969.2 |
| 513 | 2025-05-05 20:01:31 | lancer | 2 | 82551 | 164 | 10.783 | 7655.7 |
| 512 | 2025-05-04 09:07:35 | lancer | 1 | 48755 | 13 | 2.110 | 23106.6 |
| 511 | 2025-05-02 23:59:07 | lancer | 1 | 48755 | 13 | 6.216 | 7843.5 |
| 510 | 2025-05-02 08:58:37 | lancer | 1 | 48755 | 13 | 4.373 | 11149.1 |
| 509 | 2025-05-02 06:49:06 | lancer | 1 | 48755 | 13 | 2.080 | 23439.9 |
| 508 | 2025-04-29 11:47:02 | lancer | 2 | 82551 | 164 | 2.643 | 31233.8 |
| 507 | 2025-04-17 23:04:04 | lancer | 1 | 48755 | 13 | 2.126 | 22932.7 |
| 506 | 2025-04-13 14:32:29 | lancer | 1 | 48755 | 13 | 0.766 | 63648.8 |
| 505 | 2025-04-08 13:20:20 | lancer | 1 | 48755 | 13 | 4.486 | 10868.3 |
| 504 | 2025-04-07 05:31:03 | lancer | 1 | 48755 | 13 | 2.173 | 22436.7 |
| 503 | 2025-04-07 05:18:49 | lancer | 1 | 48755 | 13 | 2.110 | 23106.6 |
| 502 | 2025-04-07 05:15:35 | lancer | 1 | 48755 | 13 | 1.953 | 24964.2 |
| 501 | 2025-04-07 05:08:20 | lancer | 1 | 48755 | 13 | 2.126 | 22932.7 |
| 500 | 2025-04-06 08:47:22 | lancer | 2 | 82551 | 164 | 12.330 | 6695.1 |
| 499 | 2025-04-04 15:53:21 | lancer | 2 | 82551 | 164 | 6.426 | 12846.4 |
| 498 | 2025-04-04 14:28:32 | lancer | 1 | 48755 | 13 | 4.393 | 11098.3 |
| 497 | 2025-04-04 02:13:15 | lancer | 2 | 82551 | 164 | 8.266 | 9986.8 |
| 496 | 2025-04-03 20:00:58 | lancer | 2 | 82551 | 164 | 8.766 | 9417.2 |
| 495 | 2025-04-03 00:11:54 | lancer | 2 | 82551 | 164 | 6.860 | 12033.7 |
| 494 | 2025-04-03 00:04:20 | lancer | 2 | 82551 | 164 | 2.563 | 32208.7 |
| 493 | 2025-04-02 09:19:46 | lancer | 2 | 82551 | 164 | 18.296 | 4512.0 |
| 492 | 2025-04-01 23:51:34 | lancer | 1 | 48755 | 13 | 3.610 | 13505.5 |
| 491 | 2025-03-31 11:25:21 | lancer | 1 | 48755 | 13 | 4.030 | 12098.0 |
| 490 | 2025-03-31 09:43:39 | lancer | 1 | 48755 | 13 | 6.046 | 8064.0 |
| 489 | 2025-03-17 19:02:59 | lancer | 1 | 48755 | 13 | 4.266 | 11428.7 |
| 488 | 2025-03-17 00:09:05 | lancer | 1 | 48755 | 13 | 6.390 | 7629.9 |
| 487 | 2025-03-14 16:04:42 | lancer | 1 | 48755 | 13 | 0.750 | 65006.7 |
| 486 | 2025-03-07 19:57:05 | lancer | 1 | 48755 | 13 | 4.546 | 10724.8 |
| 485 | 2025-03-06 16:09:50 | lancer | 2 | 82551 | 164 | 12.453 | 6629.0 |
| 484 | 2025-03-06 04:36:59 | lancer | 2 | 82551 | 164 | 6.796 | 12147.0 |
| 483 | 2025-03-05 10:26:34 | lancer | 1 | 48755 | 13 | 4.173 | 11683.4 |
| 482 | 2025-03-01 14:41:13 | lancer | 1 | 48755 | 13 | 4.216 | 11564.3 |
| 481 | 2025-02-28 00:46:26 | lancer | 1 | 48755 | 13 | 3.253 | 14987.7 |
| 480 | 2025-02-27 23:02:09 | lancer | 1 | 48755 | 13 | 5.860 | 8320.0 |
| 479 | 2025-02-18 18:33:08 | lancer | 2 | 82551 | 164 | 12.733 | 6483.2 |
| 478 | 2025-02-18 10:11:28 | lancer | 2 | 82551 | 164 | 12.720 | 6489.9 |
| 477 | 2025-02-17 09:25:07 | lancer | 2 | 82551 | 164 | 11.656 | 7082.3 |
| 476 | 2025-01-28 07:57:36 | lancer | 1 | 48755 | 13 | 1.623 | 30040.0 |
| 475 | 2025-01-01 01:17:41 | lancer | 1 | 48755 | 13 | 4.873 | 10005.1 |
| 474 | 2025-01-01 01:17:23 | lancer | 1 | 48755 | 13 | 6.766 | 7205.9 |
| 473 | 2025-01-01 01:17:13 | lancer | 1 | 48755 | 13 | 6.436 | 7575.4 |
| 472 | 2024-12-29 10:13:43 | lancer | 1 | 48755 | 13 | 5.063 | 9629.7 |
| 471 | 2024-12-29 08:33:00 | lancer | 1 | 48755 | 13 | 2.170 | 22467.7 |
| 470 | 2024-12-28 20:44:50 | lancer | 1 | 48755 | 13 | 2.173 | 22436.7 |