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 |
| 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 |
| 463 | 2024-11-10 14:15:01 | pistols | 1 | 69583 | 7 | 5.470 | 12720.8 |
| 462 | 2024-11-08 03:36:59 | pistols | 1 | 69583 | 7 | 3.470 | 20052.7 |
| 461 | 2024-11-06 10:56:49 | pistols | 3 | 134027 | 333 | 33.233 | 4032.9 |
| 460 | 2024-11-05 22:14:54 | pistols | 2 | 107671 | 30 | 14.483 | 7434.3 |
| 459 | 2024-11-05 16:44:24 | pistols | 3 | 134027 | 333 | 38.846 | 3450.2 |
| 458 | 2024-11-05 06:39:47 | pistols | 3 | 134027 | 333 | 34.736 | 3858.4 |
| 457 | 2024-11-04 21:04:39 | pistols | 3 | 134027 | 333 | 31.290 | 4283.4 |
| 456 | 2024-11-04 21:04:40 | pistols | 2 | 107671 | 30 | 14.606 | 7371.7 |
| 455 | 2024-11-04 21:04:35 | pistols | 1 | 69583 | 7 | 6.060 | 11482.3 |
| 454 | 2024-10-11 03:38:38 | pistols | 1 | 69583 | 7 | 2.780 | 25029.9 |
| 453 | 2024-10-05 08:37:38 | pistols | 1 | 69583 | 7 | 9.500 | 7324.5 |
| 452 | 2024-10-05 07:28:18 | pistols | 1 | 69583 | 7 | 13.800 | 5042.2 |
| 451 | 2024-09-09 14:48:25 | pistols | 1 | 69583 | 7 | 4.500 | 15462.9 |
| 450 | 2024-09-05 00:49:43 | pistols | 1 | 69583 | 7 | 7.470 | 9315.0 |
| 449 | 2024-08-29 17:19:50 | pistols | 1 | 69583 | 7 | 11.516 | 6042.3 |
| 448 | 2024-08-29 11:52:28 | pistols | 1 | 69583 | 7 | 3.470 | 20052.7 |
| 447 | 2024-08-24 19:22:25 | pistols | 1 | 69583 | 7 | 8.466 | 8219.1 |
| 446 | 2024-08-19 07:48:30 | pistols | 2 | 107671 | 30 | 25.203 | 4272.2 |
| 445 | 2024-08-15 18:39:37 | pistols | 1 | 69583 | 7 | 6.560 | 10607.2 |
| 444 | 2024-08-14 06:07:18 | pistols | 1 | 69583 | 7 | 7.046 | 9875.5 |
| 443 | 2024-07-31 20:23:38 | pistols | 3 | 134027 | 333 | 15.470 | 8663.7 |
| 442 | 2024-07-30 08:17:59 | pistols | 3 | 134027 | 333 | 12.893 | 10395.3 |
| 441 | 2024-07-30 06:56:31 | pistols | 2 | 107671 | 30 | 13.763 | 7823.2 |
| 440 | 2024-07-30 06:56:32 | pistols | 3 | 134027 | 333 | 12.470 | 10748.0 |
| 439 | 2024-07-30 06:56:10 | pistols | 1 | 69583 | 7 | 4.280 | 16257.7 |
| 438 | 2024-07-30 05:55:14 | pistols | 1 | 69583 | 7 | 4.186 | 16622.8 |
| 437 | 2024-07-27 17:50:02 | pistols | 1 | 69583 | 7 | 3.153 | 22068.8 |
| 436 | 2024-07-11 22:46:18 | pistols | 1 | 69583 | 7 | 3.233 | 21522.7 |
| 435 | 2024-07-06 02:47:04 | pistols | 1 | 69583 | 7 | 4.093 | 17000.5 |
| 434 | 2024-07-04 21:22:02 | pistols | 3 | 134027 | 333 | 33.203 | 4036.6 |
| 433 | 2024-06-30 15:17:43 | pistols | 1 | 69583 | 7 | 21.766 | 3196.9 |
| 432 | 2024-06-30 01:32:21 | pistols | 1 | 69583 | 7 | 4.936 | 14097.0 |
| 431 | 2024-06-26 20:13:37 | pistols | 3 | 134027 | 333 | 34.330 | 3904.1 |
| 430 | 2024-06-25 14:13:24 | pistols | 3 | 134027 | 333 | 20.783 | 6448.9 |
| 429 | 2024-06-25 09:07:40 | pistols | 3 | 134027 | 333 | 12.033 | 11138.3 |
| 428 | 2024-06-25 05:49:27 | pistols | 3 | 134027 | 333 | 35.300 | 3796.8 |
| 427 | 2024-06-25 05:49:28 | pistols | 2 | 107671 | 30 | 16.440 | 6549.3 |
| 426 | 2024-06-25 05:49:23 | pistols | 1 | 69583 | 7 | 5.406 | 12871.4 |
| 425 | 2024-06-18 08:58:16 | pistols | 1 | 69583 | 7 | 4.313 | 16133.3 |
| 424 | 2024-06-16 13:02:47 | pistols | 1 | 69583 | 7 | 4.376 | 15901.1 |
| 423 | 2024-06-07 05:07:35 | pistols | 1 | 69583 | 7 | 2.170 | 32065.9 |
| 422 | 2024-05-29 19:13:58 | pistols | 1 | 69583 | 7 | 6.606 | 10533.3 |
| 421 | 2024-05-05 16:08:32 | pistols | 1 | 69583 | 7 | 2.703 | 25742.9 |
| 420 | 2024-05-05 16:08:21 | pistols | 2 | 107671 | 30 | 7.156 | 15046.3 |
| 419 | 2024-05-04 20:02:59 | pistols | 2 | 107671 | 30 | 3.796 | 28364.3 |
| 418 | 2024-05-01 16:05:07 | pistols | 3 | 134027 | 333 | 13.110 | 10223.3 |
| 417 | 2024-05-01 09:20:26 | pistols | 3 | 134027 | 333 | 13.893 | 9647.1 |
| 416 | 2024-04-28 08:25:52 | pistols | 3 | 134027 | 333 | 15.890 | 8434.7 |
| 415 | 2024-04-27 00:48:27 | pistols | 3 | 134027 | 333 | 23.360 | 5737.5 |
| 414 | 2024-04-26 07:05:57 | pistols | 1 | 69583 | 7 | 4.423 | 15732.1 |
| 413 | 2024-04-25 08:46:30 | pistols | 1 | 69583 | 7 | 1.970 | 35321.3 |
| 412 | 2024-04-12 11:28:39 | pistols | 1 | 69583 | 7 | 5.030 | 13833.6 |
| 411 | 2024-04-02 18:51:45 | pistols | 3 | 134027 | 333 | 23.016 | 5823.2 |
| 410 | 2024-04-01 17:17:10 | pistols | 3 | 134027 | 333 | 16.436 | 8154.5 |
| 409 | 2024-04-01 12:51:45 | pistols | 3 | 134027 | 333 | 23.766 | 5639.4 |
| 408 | 2024-03-27 02:56:20 | pistols | 3 | 134027 | 333 | 11.423 | 11733.1 |
| 407 | 2024-03-27 02:56:15 | pistols | 2 | 107671 | 30 | 12.000 | 8972.6 |
| 406 | 2024-03-27 00:00:09 | pistols | 1 | 69583 | 7 | 1.046 | 66522.9 |
| 405 | 2024-03-05 01:00:27 | pistols | 3 | 134027 | 333 | 17.516 | 7651.7 |
| 404 | 2024-03-02 18:02:30 | pistols | 3 | 134027 | 333 | 17.486 | 7664.8 |