History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pistols"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 563 | 2025-10-27 05:59:07 | pistols | 2 | 107671 | 30 | 3.453 | 31181.9 |
| 562 | 2025-10-22 13:38:46 | pistols | 1 | 69583 | 7 | 6.033 | 11533.7 |
| 561 | 2025-10-21 16:10:37 | pistols | 2 | 107671 | 30 | 16.703 | 6446.2 |
| 560 | 2025-10-20 13:47:54 | pistols | 1 | 69583 | 7 | 2.266 | 30707.4 |
| 559 | 2025-10-09 14:28:55 | pistols | 1 | 69583 | 7 | 1.123 | 61961.7 |
| 558 | 2025-10-05 15:09:05 | pistols | 1 | 69583 | 7 | 1.393 | 49951.9 |
| 557 | 2025-09-07 15:50:32 | pistols | 1 | 69583 | 7 | 1.233 | 56433.9 |
| 556 | 2025-08-29 10:33:21 | pistols | 3 | 134027 | 333 | 6.440 | 20811.6 |
| 555 | 2025-08-26 21:26:31 | pistols | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 554 | 2025-08-17 10:03:21 | pistols | 1 | 69583 | 7 | 2.780 | 25029.9 |
| 553 | 2025-08-14 15:33:22 | pistols | 3 | 134027 | 333 | 7.266 | 18445.8 |
| 552 | 2025-08-12 06:54:00 | pistols | 1 | 69583 | 7 | 2.953 | 23563.5 |
| 551 | 2025-08-10 05:12:28 | pistols | 3 | 134027 | 333 | 17.466 | 7673.6 |
| 550 | 2025-08-09 14:16:55 | pistols | 2 | 107671 | 30 | 24.250 | 4440.0 |
| 549 | 2025-08-08 23:38:06 | pistols | 3 | 134027 | 333 | 22.813 | 5875.0 |
| 548 | 2025-08-08 04:11:04 | pistols | 3 | 134027 | 333 | 6.860 | 19537.5 |
| 547 | 2025-08-07 06:21:24 | pistols | 3 | 134027 | 333 | 17.436 | 7686.8 |
| 546 | 2025-08-05 07:56:36 | pistols | 3 | 134027 | 333 | 28.516 | 4700.1 |
| 545 | 2025-08-01 09:48:49 | pistols | 3 | 134027 | 333 | 32.426 | 4133.3 |
| 544 | 2025-08-01 08:11:07 | pistols | 1 | 69583 | 7 | 2.670 | 26061.0 |
| 543 | 2025-08-01 07:52:46 | pistols | 1 | 69583 | 7 | 6.046 | 11508.9 |
| 542 | 2025-07-31 12:07:04 | pistols | 1 | 69583 | 7 | 1.263 | 55093.4 |
| 541 | 2025-07-27 21:45:58 | pistols | 1 | 69583 | 7 | 5.093 | 13662.5 |
| 540 | 2025-07-23 02:22:02 | pistols | 1 | 69583 | 7 | 3.623 | 19205.9 |
| 539 | 2025-07-22 17:50:22 | pistols | 1 | 69583 | 7 | 5.500 | 12651.5 |
| 538 | 2025-07-19 06:20:05 | pistols | 1 | 69583 | 7 | 1.330 | 52318.0 |
| 537 | 2025-07-18 00:05:53 | pistols | 1 | 69583 | 7 | 5.876 | 11841.9 |
| 536 | 2025-07-17 10:22:40 | pistols | 1 | 69583 | 7 | 3.096 | 22475.1 |
| 535 | 2025-07-16 03:19:21 | pistols | 1 | 69583 | 7 | 4.123 | 16876.8 |
| 534 | 2025-07-11 09:39:10 | pistols | 1 | 69583 | 7 | 8.546 | 8142.2 |
| 533 | 2025-07-01 13:51:12 | pistols | 2 | 107671 | 30 | 2.953 | 36461.6 |
| 532 | 2025-06-30 13:03:56 | pistols | 1 | 69583 | 7 | 3.733 | 18640.0 |
| 531 | 2025-06-30 12:07:55 | pistols | 1 | 69583 | 7 | 3.453 | 20151.5 |
| 530 | 2025-06-24 09:46:01 | pistols | 3 | 134027 | 333 | 30.816 | 4349.3 |
| 529 | 2025-06-22 00:20:38 | pistols | 3 | 134027 | 333 | 49.770 | 2692.9 |
| 528 | 2025-06-21 21:35:06 | pistols | 1 | 69583 | 7 | 2.673 | 26031.8 |
| 527 | 2025-06-16 03:09:27 | pistols | 1 | 69583 | 7 | 2.986 | 23303.1 |
| 526 | 2025-06-15 23:38:53 | pistols | 1 | 69583 | 7 | 3.906 | 17814.4 |
| 525 | 2025-06-10 07:10:56 | pistols | 1 | 69583 | 7 | 4.360 | 15959.4 |
| 524 | 2025-06-08 11:11:38 | pistols | 1 | 69583 | 7 | 10.050 | 6923.7 |
| 523 | 2025-06-07 14:00:49 | pistols | 1 | 69583 | 7 | 2.970 | 23428.6 |
| 522 | 2025-06-04 03:00:58 | pistols | 3 | 134027 | 333 | 33.690 | 3978.2 |
| 521 | 2025-05-31 10:44:26 | pistols | 1 | 69583 | 7 | 5.266 | 13213.6 |
| 520 | 2025-05-30 01:43:19 | pistols | 3 | 134027 | 333 | 11.233 | 11931.5 |
| 519 | 2025-05-27 12:26:56 | pistols | 1 | 69583 | 7 | 8.953 | 7772.0 |
| 518 | 2025-05-26 22:36:11 | pistols | 3 | 134027 | 333 | 34.083 | 3932.4 |
| 517 | 2025-05-26 05:57:36 | pistols | 3 | 134027 | 333 | 39.970 | 3353.2 |
| 516 | 2025-05-25 09:02:49 | pistols | 3 | 134027 | 333 | 7.190 | 18640.8 |
| 515 | 2025-05-24 06:22:32 | pistols | 3 | 134027 | 333 | 50.693 | 2643.9 |
| 514 | 2025-05-22 10:56:09 | pistols | 3 | 134027 | 333 | 20.966 | 6392.6 |
| 513 | 2025-05-21 23:29:44 | pistols | 2 | 107671 | 30 | 24.360 | 4420.0 |
| 512 | 2025-05-20 21:21:22 | pistols | 1 | 69583 | 7 | 1.186 | 58670.3 |
| 511 | 2025-05-16 02:57:48 | pistols | 1 | 69583 | 7 | 3.970 | 17527.2 |
| 510 | 2025-05-10 07:05:26 | pistols | 1 | 69583 | 7 | 3.123 | 22280.8 |
| 509 | 2025-05-09 10:48:11 | pistols | 2 | 107671 | 30 | 4.670 | 23055.9 |
| 508 | 2025-05-04 11:01:31 | pistols | 1 | 69583 | 7 | 4.330 | 16070.0 |
| 507 | 2025-05-04 08:39:27 | pistols | 2 | 107671 | 30 | 8.696 | 12381.7 |
| 506 | 2025-05-03 13:41:09 | pistols | 1 | 69583 | 7 | 1.720 | 40455.2 |
| 505 | 2025-04-30 11:07:07 | pistols | 1 | 69583 | 7 | 4.250 | 16372.5 |
| 504 | 2025-04-30 00:16:25 | pistols | 1 | 69583 | 7 | 6.013 | 11572.1 |
| 503 | 2025-04-20 18:10:27 | pistols | 1 | 69583 | 7 | 1.250 | 55666.4 |
| 502 | 2025-04-19 20:56:18 | pistols | 1 | 69583 | 7 | 5.623 | 12374.7 |
| 501 | 2025-04-14 02:43:06 | pistols | 1 | 69583 | 7 | 5.813 | 11970.2 |
| 500 | 2025-04-08 06:28:31 | pistols | 1 | 69583 | 7 | 1.233 | 56433.9 |
| 499 | 2025-04-04 10:23:38 | pistols | 1 | 69583 | 7 | 2.763 | 25183.9 |
| 498 | 2025-03-31 16:00:09 | pistols | 1 | 69583 | 7 | 7.986 | 8713.1 |
| 497 | 2025-03-29 12:49:08 | pistols | 1 | 69583 | 7 | 8.593 | 8097.6 |
| 496 | 2025-03-27 02:20:59 | pistols | 1 | 69583 | 7 | 3.220 | 21609.6 |
| 495 | 2025-03-23 03:16:07 | pistols | 3 | 134027 | 333 | 30.080 | 4455.7 |
| 494 | 2025-03-22 06:44:23 | pistols | 3 | 134027 | 333 | 18.000 | 7445.9 |
| 493 | 2025-03-21 22:00:52 | pistols | 3 | 134027 | 333 | 33.906 | 3952.9 |
| 492 | 2025-03-20 09:41:08 | pistols | 3 | 134027 | 333 | 41.330 | 3242.9 |
| 491 | 2025-03-20 01:32:03 | pistols | 2 | 107671 | 30 | 19.123 | 5630.4 |
| 490 | 2025-03-18 22:10:06 | pistols | 1 | 69583 | 7 | 1.186 | 58670.3 |
| 489 | 2025-03-17 13:30:20 | pistols | 1 | 69583 | 7 | 5.390 | 12909.6 |
| 488 | 2025-03-15 00:17:45 | pistols | 1 | 69583 | 7 | 8.940 | 7783.3 |
| 487 | 2025-03-10 22:30:57 | pistols | 1 | 69583 | 7 | 2.796 | 24886.6 |
| 486 | 2025-03-08 17:58:21 | pistols | 1 | 69583 | 7 | 4.033 | 17253.4 |
| 485 | 2025-03-03 14:20:59 | pistols | 1 | 69583 | 7 | 5.516 | 12614.8 |
| 484 | 2025-02-24 18:33:43 | pistols | 1 | 69583 | 7 | 6.000 | 11597.2 |
| 483 | 2025-02-20 13:45:59 | pistols | 2 | 107671 | 30 | 17.593 | 6120.1 |
| 482 | 2025-02-20 00:28:11 | pistols | 3 | 134027 | 333 | 39.123 | 3425.8 |
| 481 | 2025-02-19 04:33:20 | pistols | 3 | 134027 | 333 | 18.080 | 7413.0 |
| 480 | 2025-02-18 20:58:03 | pistols | 3 | 134027 | 333 | 32.890 | 4075.0 |
| 479 | 2025-02-18 20:57:56 | pistols | 2 | 107671 | 30 | 21.353 | 5042.4 |
| 478 | 2025-02-18 20:56:41 | pistols | 1 | 69583 | 7 | 3.550 | 19600.8 |
| 477 | 2025-02-16 14:25:30 | pistols | 1 | 69583 | 7 | 5.546 | 12546.5 |
| 476 | 2025-02-10 04:15:32 | pistols | 1 | 69583 | 7 | 1.093 | 63662.4 |
| 475 | 2025-02-06 12:56:31 | pistols | 1 | 69583 | 7 | 5.236 | 13289.3 |
| 474 | 2025-01-06 15:01:09 | pistols | 1 | 69583 | 7 | 2.780 | 25029.9 |
| 473 | 2025-01-03 19:24:03 | pistols | 2 | 107671 | 30 | 3.466 | 31064.9 |
| 472 | 2024-12-30 14:16:13 | pistols | 2 | 107671 | 30 | 9.483 | 11354.1 |
| 471 | 2024-12-11 10:25:39 | pistols | 1 | 69583 | 7 | 6.330 | 10992.6 |
| 470 | 2024-12-09 16:21:28 | pistols | 3 | 134027 | 333 | 33.956 | 3947.1 |
| 469 | 2024-12-09 04:20:49 | pistols | 3 | 134027 | 333 | 32.843 | 4080.8 |
| 468 | 2024-12-09 01:01:23 | pistols | 3 | 134027 | 333 | 32.193 | 4163.2 |
| 467 | 2024-12-08 20:21:41 | pistols | 3 | 134027 | 333 | 34.453 | 3890.1 |
| 466 | 2024-12-08 20:21:41 | pistols | 2 | 107671 | 30 | 22.436 | 4799.0 |
| 465 | 2024-12-08 20:17:03 | pistols | 1 | 69583 | 7 | 3.046 | 22844.1 |
| 464 | 2024-11-11 02:01:50 | pistols | 2 | 107671 | 30 | 13.830 | 7785.3 |