History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piquance"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 568 | 2025-10-29 10:02:40 | piquance | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 567 | 2025-10-17 19:27:10 | piquance | 1 | 82945 | 3 | 5.923 | 14003.9 |
| 566 | 2025-10-13 21:08:20 | piquance | 1 | 82945 | 3 | 2.313 | 35860.4 |
| 565 | 2025-10-02 05:33:20 | piquance | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 564 | 2025-09-06 17:24:51 | piquance | 1 | 82945 | 3 | 2.860 | 29001.7 |
| 563 | 2025-08-10 07:02:36 | piquance | 1 | 82945 | 3 | 3.580 | 23169.0 |
| 562 | 2025-07-27 20:50:48 | piquance | 2 | 121059 | 6 | 15.936 | 7596.6 |
| 561 | 2025-07-27 20:24:48 | piquance | 3 | 146162 | 31 | 16.640 | 8783.8 |
| 560 | 2025-07-26 14:28:34 | piquance | 1 | 82945 | 3 | 3.173 | 26140.9 |
| 559 | 2025-07-25 14:48:35 | piquance | 1 | 82945 | 3 | 3.576 | 23194.9 |
| 558 | 2025-07-24 19:53:55 | piquance | 1 | 82945 | 3 | 5.440 | 15247.2 |
| 557 | 2025-07-22 11:15:29 | piquance | 1 | 82945 | 3 | 5.020 | 16522.9 |
| 556 | 2025-07-07 23:09:32 | piquance | 1 | 82945 | 3 | 5.283 | 15700.4 |
| 555 | 2025-07-03 23:37:56 | piquance | 1 | 82945 | 3 | 3.733 | 22219.4 |
| 554 | 2025-06-18 15:57:57 | piquance | 1 | 82945 | 3 | 9.076 | 9138.9 |
| 553 | 2025-05-26 13:59:54 | piquance | 1 | 82945 | 3 | 10.376 | 7993.9 |
| 552 | 2025-04-24 01:15:58 | piquance | 3 | 146162 | 31 | 44.990 | 3248.8 |
| 551 | 2025-04-23 12:41:52 | piquance | 1 | 82945 | 3 | 10.263 | 8081.9 |
| 550 | 2025-04-22 19:40:59 | piquance | 2 | 121059 | 6 | 17.516 | 6911.3 |
| 549 | 2025-04-21 11:13:04 | piquance | 3 | 146162 | 31 | 49.713 | 2940.1 |
| 548 | 2025-04-21 03:39:46 | piquance | 2 | 121059 | 6 | 14.346 | 8438.5 |
| 547 | 2025-04-20 23:10:51 | piquance | 3 | 146162 | 31 | 45.066 | 3243.3 |
| 546 | 2025-04-20 21:27:10 | piquance | 2 | 121059 | 6 | 13.033 | 9288.7 |
| 545 | 2025-04-19 23:10:18 | piquance | 1 | 82945 | 3 | 6.953 | 11929.4 |
| 544 | 2025-04-18 15:37:10 | piquance | 1 | 82945 | 3 | 5.656 | 14665.0 |
| 543 | 2025-04-16 01:01:59 | piquance | 2 | 121059 | 6 | 15.470 | 7825.4 |
| 542 | 2025-04-15 20:17:43 | piquance | 3 | 146162 | 31 | 21.233 | 6883.7 |
| 541 | 2025-04-14 21:54:01 | piquance | 1 | 82945 | 3 | 4.610 | 17992.4 |
| 540 | 2025-04-09 11:18:35 | piquance | 1 | 82945 | 3 | 7.106 | 11672.5 |
| 539 | 2025-03-27 13:15:38 | piquance | 3 | 146162 | 31 | 41.486 | 3523.2 |
| 538 | 2025-03-24 08:06:52 | piquance | 3 | 146162 | 31 | 27.440 | 5326.6 |
| 537 | 2025-03-22 13:14:26 | piquance | 1 | 82945 | 3 | 6.546 | 12671.1 |
| 536 | 2025-03-21 14:06:23 | piquance | 3 | 146162 | 31 | 18.266 | 8001.9 |
| 535 | 2025-03-16 16:30:21 | piquance | 1 | 82945 | 3 | 5.126 | 16181.2 |
| 534 | 2025-03-11 10:56:07 | piquance | 3 | 146162 | 31 | 31.783 | 4598.7 |
| 533 | 2025-03-11 10:56:03 | piquance | 2 | 121059 | 6 | 17.626 | 6868.2 |
| 532 | 2025-03-11 10:55:05 | piquance | 1 | 82945 | 3 | 3.736 | 22201.6 |
| 531 | 2025-03-07 09:24:23 | piquance | 3 | 146162 | 31 | 36.546 | 3999.4 |
| 530 | 2025-03-07 09:07:49 | piquance | 3 | 146162 | 31 | 42.453 | 3442.9 |
| 529 | 2025-03-01 22:21:10 | piquance | 1 | 82945 | 3 | 4.343 | 19098.5 |
| 528 | 2025-02-24 00:32:08 | piquance | 1 | 82945 | 3 | 10.013 | 8283.7 |
| 527 | 2025-02-24 00:21:51 | piquance | 3 | 146162 | 31 | 7.296 | 20033.2 |
| 526 | 2025-02-24 00:21:50 | piquance | 3 | 146162 | 31 | 7.513 | 19454.5 |
| 525 | 2025-02-24 00:21:49 | piquance | 2 | 121059 | 6 | 4.063 | 29795.5 |
| 524 | 2025-02-23 23:52:03 | piquance | 3 | 146162 | 31 | 30.770 | 4750.1 |
| 523 | 2025-02-23 23:52:15 | piquance | 1 | 82945 | 3 | 5.376 | 15428.8 |
| 522 | 2025-02-23 23:52:01 | piquance | 3 | 146162 | 31 | 19.063 | 7667.3 |
| 521 | 2025-02-23 23:52:01 | piquance | 2 | 121059 | 6 | 17.640 | 6862.8 |
| 520 | 2025-02-07 08:05:22 | piquance | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 519 | 2025-02-01 13:10:08 | piquance | 3 | 146162 | 31 | 35.520 | 4114.9 |
| 518 | 2025-01-25 22:56:22 | piquance | 1 | 82945 | 3 | 3.203 | 25896.0 |
| 517 | 2025-01-25 22:55:18 | piquance | 2 | 121059 | 6 | 6.360 | 19034.4 |
| 516 | 2025-01-25 22:54:21 | piquance | 3 | 146162 | 31 | 6.546 | 22328.4 |
| 515 | 2025-01-24 10:50:25 | piquance | 4 | 161609 | 309 | 71.253 | 2268.1 |
| 514 | 2025-01-24 02:00:09 | piquance | 4 | 161609 | 309 | 57.113 | 2829.6 |
| 513 | 2025-01-23 20:09:35 | piquance | 4 | 161609 | 309 | 55.503 | 2911.7 |
| 512 | 2025-01-23 20:09:38 | piquance | 2 | 121059 | 6 | 14.080 | 8597.9 |
| 511 | 2025-01-23 20:07:44 | piquance | 3 | 146162 | 31 | 9.000 | 16240.2 |
| 510 | 2025-01-22 16:27:12 | piquance | 3 | 146162 | 31 | 23.686 | 6170.8 |
| 509 | 2025-01-22 16:26:56 | piquance | 2 | 121059 | 6 | 27.080 | 4470.4 |
| 508 | 2025-01-22 16:26:43 | piquance | 3 | 146162 | 31 | 39.720 | 3679.8 |
| 507 | 2025-01-22 16:26:34 | piquance | 1 | 82945 | 3 | 6.720 | 12343.0 |
| 506 | 2025-01-21 15:39:54 | piquance | 1 | 82945 | 3 | 7.970 | 10407.2 |
| 505 | 2025-01-16 18:16:21 | piquance | 1 | 82945 | 3 | 3.356 | 24715.4 |
| 504 | 2025-01-06 06:34:31 | piquance | 2 | 121059 | 6 | 18.080 | 6695.7 |
| 503 | 2025-01-06 06:34:35 | piquance | 1 | 82945 | 3 | 7.563 | 10967.2 |
| 502 | 2025-01-01 17:51:12 | piquance | 3 | 146162 | 31 | 42.720 | 3421.4 |
| 501 | 2024-12-27 08:13:26 | piquance | 1 | 82945 | 3 | 6.920 | 11986.3 |
| 500 | 2024-12-26 16:18:43 | piquance | 2 | 121059 | 6 | 14.346 | 8438.5 |
| 499 | 2024-12-26 15:37:10 | piquance | 3 | 146162 | 31 | 7.000 | 20880.3 |
| 498 | 2024-12-24 15:09:46 | piquance | 2 | 121059 | 6 | 15.453 | 7834.0 |
| 497 | 2024-12-19 17:16:16 | piquance | 3 | 146162 | 31 | 38.270 | 3819.2 |
| 496 | 2024-12-19 12:03:43 | piquance | 3 | 146162 | 31 | 30.083 | 4858.6 |
| 495 | 2024-12-19 12:03:45 | piquance | 2 | 121059 | 6 | 9.296 | 13022.7 |
| 494 | 2024-12-19 12:03:33 | piquance | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 493 | 2024-12-16 04:55:41 | piquance | 1 | 82945 | 3 | 8.890 | 9330.1 |
| 492 | 2024-12-09 07:52:29 | piquance | 4 | 161609 | 309 | 50.253 | 3215.9 |
| 491 | 2024-12-08 21:49:21 | piquance | 4 | 161609 | 309 | 12.533 | 12894.7 |
| 490 | 2024-12-07 13:10:44 | piquance | 4 | 161609 | 309 | 57.270 | 2821.9 |
| 489 | 2024-12-07 02:33:14 | piquance | 1 | 82945 | 3 | 6.360 | 13041.7 |
| 488 | 2024-12-06 11:32:17 | piquance | 4 | 161609 | 309 | 67.650 | 2388.9 |
| 487 | 2024-11-12 17:24:17 | piquance | 1 | 82945 | 3 | 5.190 | 15981.7 |
| 486 | 2024-11-11 12:10:04 | piquance | 2 | 121059 | 6 | 11.360 | 10656.6 |
| 485 | 2024-11-11 04:49:46 | piquance | 3 | 146162 | 31 | 20.360 | 7178.9 |
| 484 | 2024-11-08 14:59:05 | piquance | 3 | 146162 | 31 | 35.986 | 4061.6 |
| 483 | 2024-11-08 06:56:49 | piquance | 3 | 146162 | 31 | 34.986 | 4177.7 |
| 482 | 2024-11-08 03:28:09 | piquance | 4 | 161609 | 309 | 74.300 | 2175.1 |
| 481 | 2024-11-07 12:57:35 | piquance | 3 | 146162 | 31 | 21.270 | 6871.7 |
| 480 | 2024-11-07 09:35:32 | piquance | 4 | 161609 | 309 | 66.283 | 2438.2 |
| 479 | 2024-11-07 09:35:41 | piquance | 3 | 146162 | 31 | 39.076 | 3740.5 |
| 478 | 2024-11-07 09:35:39 | piquance | 2 | 121059 | 6 | 15.080 | 8027.8 |
| 477 | 2024-11-07 09:35:30 | piquance | 1 | 82945 | 3 | 9.016 | 9199.8 |
| 476 | 2024-11-06 08:56:38 | piquance | 1 | 82945 | 3 | 9.830 | 8437.9 |
| 475 | 2024-10-18 12:07:54 | piquance | 1 | 82945 | 3 | 7.606 | 10905.2 |
| 474 | 2024-10-09 21:56:30 | piquance | 1 | 82945 | 3 | 6.203 | 13371.8 |
| 473 | 2024-10-09 21:56:09 | piquance | 3 | 146162 | 31 | 20.516 | 7124.3 |
| 472 | 2024-10-08 14:26:51 | piquance | 3 | 146162 | 31 | 37.236 | 3925.3 |
| 471 | 2024-10-08 01:53:37 | piquance | 3 | 146162 | 31 | 10.593 | 13798.0 |
| 470 | 2024-10-08 01:53:35 | piquance | 2 | 121059 | 6 | 3.610 | 33534.3 |
| 469 | 2024-10-08 01:53:35 | piquance | 1 | 82945 | 3 | 1.500 | 55296.7 |