History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"soapy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 574 | 2024-04-13 17:27:19 | soapy | 1 | 28756 | 5 | 1.313 | 21901.0 |
| 573 | 2024-04-05 20:28:28 | soapy | 2 | 53800 | 90 | 1.876 | 28678.0 |
| 572 | 2024-04-05 20:24:48 | soapy | 3 | 83667 | 1471 | 4.750 | 17614.1 |
| 571 | 2024-04-05 17:26:09 | soapy | 3 | 83667 | 1471 | 13.830 | 6049.7 |
| 570 | 2024-04-05 17:26:09 | soapy | 2 | 53800 | 90 | 5.800 | 9275.9 |
| 569 | 2024-04-05 17:16:07 | soapy | 1 | 28756 | 5 | 0.593 | 48492.4 |
| 568 | 2024-03-31 03:22:41 | soapy | 1 | 28756 | 5 | 1.796 | 16011.1 |
| 567 | 2024-03-29 00:44:17 | soapy | 3 | 83667 | 1471 | 10.736 | 7793.1 |
| 566 | 2024-03-29 00:01:05 | soapy | 3 | 83667 | 1471 | 4.953 | 16892.2 |
| 565 | 2024-03-29 00:01:04 | soapy | 2 | 53800 | 90 | 4.016 | 13396.4 |
| 564 | 2024-03-28 23:06:06 | soapy | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 563 | 2024-03-14 18:55:37 | soapy | 1 | 28756 | 5 | 1.063 | 27051.7 |
| 562 | 2024-03-05 18:36:06 | soapy | 3 | 83667 | 1471 | 14.530 | 5758.2 |
| 561 | 2024-03-05 17:50:48 | soapy | 2 | 53800 | 90 | 5.343 | 10069.2 |
| 560 | 2024-03-04 18:30:01 | soapy | 3 | 83667 | 1471 | 14.326 | 5840.2 |
| 559 | 2024-03-04 18:30:00 | soapy | 2 | 53800 | 90 | 4.000 | 13450.0 |
| 558 | 2024-03-04 18:19:54 | soapy | 1 | 28756 | 5 | 1.106 | 26000.0 |
| 557 | 2024-03-01 00:58:12 | soapy | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 556 | 2024-02-28 16:50:47 | soapy | 1 | 28756 | 5 | 1.953 | 14724.0 |
| 555 | 2024-02-28 04:48:24 | soapy | 3 | 83667 | 1471 | 11.233 | 7448.3 |
| 554 | 2024-02-27 22:37:59 | soapy | 3 | 83667 | 1471 | 12.016 | 6963.0 |
| 553 | 2024-02-27 22:33:59 | soapy | 3 | 83667 | 1471 | 4.563 | 18336.0 |
| 552 | 2024-02-27 22:33:58 | soapy | 2 | 53800 | 90 | 3.373 | 15950.2 |
| 551 | 2024-02-27 20:54:05 | soapy | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 550 | 2024-02-03 17:21:51 | soapy | 1 | 28756 | 5 | 0.580 | 49579.3 |
| 549 | 2024-01-28 17:35:05 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 548 | 2024-01-17 13:45:46 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 547 | 2024-01-11 16:12:05 | soapy | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 546 | 2024-01-06 05:30:26 | soapy | 3 | 83667 | 1471 | 3.703 | 22594.4 |
| 545 | 2024-01-06 05:30:27 | soapy | 2 | 53800 | 90 | 1.626 | 33087.3 |
| 544 | 2024-01-01 22:31:33 | soapy | 3 | 83667 | 1471 | 3.890 | 21508.2 |
| 543 | 2023-11-20 21:17:14 | soapy | 1 | 28756 | 5 | 0.580 | 49579.3 |
| 542 | 2023-11-14 11:43:18 | soapy | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 541 | 2023-11-14 07:55:21 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 540 | 2023-11-04 03:37:36 | soapy | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 539 | 2023-10-23 02:39:06 | soapy | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 538 | 2023-10-19 21:59:37 | soapy | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 537 | 2023-10-13 14:08:33 | soapy | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 536 | 2023-10-06 22:42:14 | soapy | 3 | 83667 | 1471 | 3.580 | 23370.7 |
| 535 | 2023-10-05 02:41:20 | soapy | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 534 | 2023-09-26 13:19:30 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 533 | 2023-09-05 05:43:48 | soapy | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 532 | 2023-09-01 22:09:23 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 531 | 2023-07-18 01:10:09 | soapy | 3 | 83667 | 1471 | 3.890 | 21508.2 |
| 530 | 2023-06-30 15:35:00 | soapy | 3 | 83667 | 1471 | 4.080 | 20506.6 |
| 529 | 2023-06-06 01:11:04 | soapy | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 528 | 2023-05-17 05:41:12 | soapy | 1 | 28756 | 5 | 0.450 | 63902.2 |
| 527 | 2023-05-17 05:09:07 | soapy | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 526 | 2023-05-12 09:53:28 | soapy | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 525 | 2023-03-31 11:55:28 | soapy | 3 | 83667 | 1471 | 3.673 | 22778.9 |
| 524 | 2023-03-27 19:08:23 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 523 | 2023-01-19 04:48:43 | soapy | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 522 | 2023-01-12 18:22:46 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 521 | 2022-12-27 21:03:25 | soapy | 3 | 83667 | 1471 | 3.343 | 25027.5 |
| 520 | 2022-11-15 08:01:29 | soapy | 1 | 28756 | 5 | 0.593 | 48492.4 |
| 519 | 2022-11-15 03:46:32 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 518 | 2022-10-25 19:17:05 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 517 | 2022-09-17 01:58:29 | soapy | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 516 | 2022-09-01 19:17:23 | soapy | 3 | 83667 | 1471 | 3.453 | 24230.2 |
| 515 | 2022-08-29 00:02:56 | soapy | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 514 | 2022-08-27 00:31:26 | soapy | 3 | 83667 | 1471 | 3.406 | 24564.6 |
| 513 | 2022-08-18 16:57:48 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 512 | 2022-07-26 11:28:17 | soapy | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 511 | 2022-06-16 11:53:16 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 510 | 2022-06-14 06:41:09 | soapy | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 509 | 2022-06-07 09:50:15 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 508 | 2022-04-30 13:27:43 | soapy | 1 | 28756 | 5 | 0.560 | 51350.0 |
| 507 | 2022-02-15 07:40:27 | soapy | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 506 | 2022-02-13 03:48:43 | soapy | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 505 | 2022-01-03 18:45:10 | soapy | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 504 | 2021-12-25 17:48:05 | soapy | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 503 | 2021-11-30 12:45:43 | soapy | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 502 | 2021-11-21 03:46:54 | soapy | 3 | 83667 | 1471 | 4.890 | 17109.8 |
| 501 | 2021-10-10 19:25:18 | soapy | 3 | 83667 | 1471 | 3.953 | 21165.4 |
| 500 | 2021-10-10 00:10:24 | soapy | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 499 | 2021-09-14 20:32:45 | soapy | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 498 | 2021-09-12 09:30:01 | soapy | 3 | 83667 | 1471 | 3.563 | 23482.2 |
| 497 | 2021-09-01 08:44:07 | soapy | 1 | 28756 | 5 | 0.450 | 63902.2 |
| 496 | 2021-08-17 01:59:41 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 495 | 2021-08-04 17:45:24 | soapy | 3 | 83667 | 1471 | 3.610 | 23176.5 |
| 494 | 2021-07-29 21:44:42 | soapy | 3 | 83667 | 1471 | 3.326 | 25155.4 |
| 493 | 2021-07-26 09:18:11 | soapy | 3 | 83667 | 1471 | 3.796 | 22040.8 |
| 492 | 2021-07-16 14:54:26 | soapy | 2 | 53800 | 90 | 1.453 | 37026.8 |
| 491 | 2021-06-14 19:09:32 | soapy | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 490 | 2021-06-14 12:31:01 | soapy | 3 | 83667 | 1471 | 4.250 | 19686.4 |
| 489 | 2021-06-14 01:36:33 | soapy | 3 | 83667 | 1471 | 3.813 | 21942.6 |
| 488 | 2021-06-11 13:55:47 | soapy | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 487 | 2021-06-10 13:01:01 | soapy | 3 | 83667 | 1471 | 3.343 | 25027.5 |
| 486 | 2021-05-25 18:22:07 | soapy | 3 | 83667 | 1471 | 4.033 | 20745.6 |
| 485 | 2021-05-20 18:26:10 | soapy | 3 | 83667 | 1471 | 3.656 | 22884.8 |
| 484 | 2021-05-06 09:41:44 | soapy | 3 | 83667 | 1471 | 3.560 | 23502.0 |
| 483 | 2021-05-05 21:19:54 | soapy | 2 | 53800 | 90 | 1.720 | 31279.1 |
| 482 | 2021-04-22 12:20:58 | soapy | 3 | 83667 | 1471 | 4.253 | 19672.5 |
| 481 | 2021-04-20 20:16:26 | soapy | 3 | 83667 | 1471 | 3.813 | 21942.6 |
| 480 | 2021-04-16 23:43:50 | soapy | 3 | 83667 | 1471 | 3.576 | 23396.8 |
| 479 | 2021-03-23 16:16:24 | soapy | 3 | 83667 | 1471 | 4.110 | 20356.9 |
| 478 | 2021-03-20 21:39:00 | soapy | 1 | 28756 | 5 | 1.063 | 27051.7 |
| 477 | 2021-03-15 10:08:33 | soapy | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 476 | 2021-03-11 21:28:36 | soapy | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 475 | 2021-02-25 21:29:44 | soapy | 3 | 83667 | 1471 | 3.766 | 22216.4 |