History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clowns"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 580 | 2024-12-27 11:43:17 | clowns | 3 | 112716 | 764 | 27.350 | 4121.2 |
| 579 | 2024-12-27 09:51:44 | clowns | 2 | 82551 | 72 | 12.470 | 6620.0 |
| 578 | 2024-12-27 09:17:03 | clowns | 2 | 82551 | 72 | 11.296 | 7308.0 |
| 577 | 2024-12-27 09:16:31 | clowns | 3 | 112716 | 764 | 5.720 | 19705.6 |
| 576 | 2024-12-27 05:59:36 | clowns | 3 | 112716 | 764 | 29.113 | 3871.7 |
| 575 | 2024-12-27 05:55:17 | clowns | 3 | 112716 | 764 | 31.453 | 3583.6 |
| 574 | 2024-12-27 05:04:33 | clowns | 3 | 112716 | 764 | 42.300 | 2664.7 |
| 573 | 2024-12-25 15:45:46 | clowns | 1 | 48755 | 4 | 2.173 | 22436.7 |
| 572 | 2024-12-04 19:46:07 | clowns | 1 | 48755 | 4 | 2.530 | 19270.8 |
| 571 | 2024-11-27 01:50:08 | clowns | 1 | 48755 | 4 | 4.970 | 9809.9 |
| 570 | 2024-11-24 22:36:58 | clowns | 1 | 48755 | 4 | 2.706 | 18017.4 |
| 569 | 2024-11-14 03:02:48 | clowns | 3 | 112716 | 764 | 31.453 | 3583.6 |
| 568 | 2024-11-13 13:32:10 | clowns | 3 | 112716 | 764 | 20.893 | 5394.9 |
| 567 | 2024-11-13 13:32:12 | clowns | 2 | 82551 | 72 | 17.423 | 4738.0 |
| 566 | 2024-11-12 18:23:25 | clowns | 2 | 82551 | 72 | 2.716 | 30394.3 |
| 565 | 2024-11-12 18:22:54 | clowns | 3 | 112716 | 764 | 5.466 | 20621.3 |
| 564 | 2024-11-12 16:50:03 | clowns | 3 | 112716 | 764 | 25.483 | 4423.2 |
| 563 | 2024-11-12 16:50:09 | clowns | 2 | 82551 | 72 | 12.080 | 6833.7 |
| 562 | 2024-11-12 13:02:43 | clowns | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 561 | 2024-10-30 05:51:39 | clowns | 1 | 48755 | 4 | 5.846 | 8339.9 |
| 560 | 2024-10-28 04:02:16 | clowns | 1 | 48755 | 4 | 3.983 | 12240.8 |
| 559 | 2024-10-25 18:55:04 | clowns | 1 | 48755 | 4 | 3.410 | 14297.7 |
| 558 | 2024-10-21 16:52:27 | clowns | 1 | 48755 | 4 | 2.860 | 17047.2 |
| 557 | 2024-10-13 13:17:46 | clowns | 1 | 48755 | 4 | 2.360 | 20658.9 |
| 556 | 2024-10-08 06:43:08 | clowns | 1 | 48755 | 4 | 9.236 | 5278.8 |
| 555 | 2024-10-06 08:10:04 | clowns | 3 | 112716 | 764 | 27.686 | 4071.2 |
| 554 | 2024-09-30 10:50:44 | clowns | 2 | 82551 | 72 | 12.640 | 6530.9 |
| 553 | 2024-09-30 08:38:58 | clowns | 3 | 112716 | 764 | 21.076 | 5348.1 |
| 552 | 2024-09-29 21:56:20 | clowns | 3 | 112716 | 764 | 22.893 | 4923.6 |
| 551 | 2024-09-29 18:11:40 | clowns | 3 | 112716 | 764 | 46.643 | 2416.6 |
| 550 | 2024-09-29 18:11:41 | clowns | 2 | 82551 | 72 | 22.046 | 3744.5 |
| 549 | 2024-09-29 18:10:52 | clowns | 1 | 48755 | 4 | 3.186 | 15302.9 |
| 548 | 2024-09-08 07:23:07 | clowns | 1 | 48755 | 4 | 7.343 | 6639.7 |
| 547 | 2024-08-30 10:47:29 | clowns | 1 | 48755 | 4 | 6.783 | 7187.8 |
| 546 | 2024-08-29 17:52:54 | clowns | 1 | 48755 | 4 | 7.280 | 6697.1 |
| 545 | 2024-08-27 20:23:08 | clowns | 1 | 48755 | 4 | 5.953 | 8190.0 |
| 544 | 2024-08-27 19:54:07 | clowns | 1 | 48755 | 4 | 4.376 | 11141.5 |
| 543 | 2024-08-19 23:50:10 | clowns | 1 | 48755 | 4 | 3.483 | 13998.0 |
| 542 | 2024-08-14 09:28:58 | clowns | 1 | 48755 | 4 | 7.000 | 6965.0 |
| 541 | 2024-08-11 00:51:47 | clowns | 1 | 48755 | 4 | 3.096 | 15747.7 |
| 540 | 2024-08-06 05:00:36 | clowns | 1 | 48755 | 4 | 3.156 | 15448.4 |
| 539 | 2024-07-31 01:22:53 | clowns | 1 | 48755 | 4 | 2.970 | 16415.8 |
| 538 | 2024-07-28 07:52:23 | clowns | 1 | 48755 | 4 | 3.483 | 13998.0 |
| 537 | 2024-07-27 10:46:46 | clowns | 1 | 48755 | 4 | 5.453 | 8940.9 |
| 536 | 2024-07-21 17:29:47 | clowns | 1 | 48755 | 4 | 1.750 | 27860.0 |
| 535 | 2024-07-12 15:14:39 | clowns | 1 | 48755 | 4 | 2.813 | 17332.0 |
| 534 | 2024-07-06 12:30:09 | clowns | 1 | 48755 | 4 | 3.186 | 15302.9 |
| 533 | 2024-06-30 16:12:29 | clowns | 1 | 48755 | 4 | 2.843 | 17149.1 |
| 532 | 2024-06-28 07:29:49 | clowns | 1 | 48755 | 4 | 2.033 | 23981.8 |
| 531 | 2024-06-27 07:51:56 | clowns | 1 | 48755 | 4 | 4.483 | 10875.5 |
| 530 | 2024-06-10 05:21:15 | clowns | 1 | 48755 | 4 | 4.046 | 12050.2 |
| 529 | 2024-06-06 03:50:38 | clowns | 1 | 48755 | 4 | 4.483 | 10875.5 |
| 528 | 2024-06-06 03:49:58 | clowns | 2 | 82551 | 72 | 5.190 | 15905.8 |
| 527 | 2024-05-29 06:55:50 | clowns | 1 | 48755 | 4 | 4.266 | 11428.7 |
| 526 | 2024-05-27 13:42:54 | clowns | 1 | 48755 | 4 | 3.813 | 12786.5 |
| 525 | 2024-05-21 05:15:00 | clowns | 2 | 82551 | 72 | 4.580 | 18024.2 |
| 524 | 2024-05-11 19:09:09 | clowns | 3 | 112716 | 764 | 9.953 | 11324.8 |
| 523 | 2024-05-11 14:32:38 | clowns | 3 | 112716 | 764 | 18.890 | 5967.0 |
| 522 | 2024-05-11 11:36:04 | clowns | 1 | 48755 | 4 | 1.000 | 48755.0 |
| 521 | 2024-05-09 14:26:19 | clowns | 2 | 82551 | 72 | 5.216 | 15826.5 |
| 520 | 2024-05-09 14:25:19 | clowns | 3 | 112716 | 764 | 6.093 | 18499.3 |
| 519 | 2024-05-08 16:59:53 | clowns | 3 | 112716 | 764 | 11.410 | 9878.7 |
| 518 | 2024-05-08 00:10:41 | clowns | 1 | 48755 | 4 | 1.953 | 24964.2 |
| 517 | 2024-05-08 00:10:28 | clowns | 3 | 112716 | 764 | 11.580 | 9733.7 |
| 516 | 2024-05-08 00:10:31 | clowns | 2 | 82551 | 72 | 5.733 | 14399.3 |
| 515 | 2024-05-08 00:10:27 | clowns | 1 | 48755 | 4 | 1.310 | 37217.6 |
| 514 | 2024-05-05 15:44:51 | clowns | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 513 | 2024-05-04 00:44:36 | clowns | 2 | 82551 | 72 | 2.466 | 33475.7 |
| 512 | 2024-05-04 00:43:57 | clowns | 3 | 112716 | 764 | 6.203 | 18171.2 |
| 511 | 2024-05-03 13:10:46 | clowns | 3 | 112716 | 764 | 5.516 | 20434.4 |
| 510 | 2024-05-02 20:13:03 | clowns | 1 | 48755 | 4 | 1.000 | 48755.0 |
| 509 | 2024-04-27 04:18:50 | clowns | 1 | 48755 | 4 | 1.720 | 28345.9 |
| 508 | 2024-04-11 07:27:10 | clowns | 2 | 82551 | 72 | 4.703 | 17552.8 |
| 507 | 2024-04-11 07:26:32 | clowns | 3 | 112716 | 764 | 5.456 | 20659.1 |
| 506 | 2024-04-08 21:59:30 | clowns | 2 | 82551 | 72 | 4.190 | 19701.9 |
| 505 | 2024-04-08 16:26:33 | clowns | 3 | 112716 | 764 | 13.750 | 8197.5 |
| 504 | 2024-04-08 06:22:08 | clowns | 3 | 112716 | 764 | 6.160 | 18298.1 |
| 503 | 2024-04-08 06:22:07 | clowns | 2 | 82551 | 72 | 5.360 | 15401.3 |
| 502 | 2024-04-07 17:27:33 | clowns | 3 | 112716 | 764 | 14.283 | 7891.6 |
| 501 | 2024-04-07 17:27:32 | clowns | 2 | 82551 | 72 | 3.140 | 26290.1 |
| 500 | 2024-04-07 17:27:29 | clowns | 1 | 48755 | 4 | 2.950 | 16527.1 |
| 499 | 2024-04-06 12:16:25 | clowns | 3 | 112716 | 764 | 8.126 | 13871.0 |
| 498 | 2024-04-06 12:16:24 | clowns | 2 | 82551 | 72 | 3.593 | 22975.5 |
| 497 | 2024-04-06 12:16:23 | clowns | 1 | 48755 | 4 | 3.000 | 16251.7 |
| 496 | 2024-03-11 04:19:08 | clowns | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 495 | 2024-01-21 09:14:55 | clowns | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 494 | 2023-12-24 19:36:35 | clowns | 3 | 112716 | 764 | 9.876 | 11413.1 |
| 493 | 2023-11-22 23:30:20 | clowns | 1 | 48755 | 4 | 1.486 | 32809.6 |
| 492 | 2023-11-20 13:34:47 | clowns | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 491 | 2023-11-20 05:30:55 | clowns | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 490 | 2023-11-19 04:39:03 | clowns | 2 | 82551 | 72 | 5.300 | 15575.7 |
| 489 | 2023-11-11 05:54:32 | clowns | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 488 | 2023-11-04 11:39:29 | clowns | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 487 | 2023-10-29 23:49:09 | clowns | 2 | 82551 | 72 | 2.403 | 34353.3 |
| 486 | 2023-10-26 18:13:10 | clowns | 3 | 112716 | 764 | 5.733 | 19660.9 |
| 485 | 2023-10-25 13:22:55 | clowns | 3 | 112716 | 764 | 4.706 | 23951.6 |
| 484 | 2023-10-25 13:22:53 | clowns | 2 | 82551 | 72 | 2.326 | 35490.5 |
| 483 | 2023-10-19 19:02:09 | clowns | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 482 | 2023-10-19 12:29:02 | clowns | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 481 | 2023-10-11 12:26:48 | clowns | 1 | 48755 | 4 | 0.890 | 54780.9 |