History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hamster"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 576 | 2025-12-02 14:29:06 | hamster | 3 | 134027 | 516 | 14.936 | 8973.4 |
| 575 | 2025-12-02 14:20:23 | hamster | 3 | 134027 | 516 | 6.346 | 21119.9 |
| 574 | 2025-12-02 14:07:40 | hamster | 3 | 134027 | 516 | 6.830 | 19623.3 |
| 573 | 2025-12-02 01:42:11 | hamster | 1 | 69583 | 3 | 8.813 | 7895.5 |
| 572 | 2025-12-01 08:50:43 | hamster | 2 | 107671 | 48 | 5.813 | 18522.4 |
| 571 | 2025-11-07 12:30:27 | hamster | 2 | 107671 | 48 | 3.456 | 31154.8 |
| 570 | 2025-11-04 14:40:15 | hamster | 2 | 107671 | 48 | 3.453 | 31181.9 |
| 569 | 2025-11-02 21:32:33 | hamster | 2 | 107671 | 48 | 3.126 | 34443.7 |
| 568 | 2025-10-19 09:37:23 | hamster | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 567 | 2025-10-18 20:13:01 | hamster | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 566 | 2025-10-18 06:25:41 | hamster | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 565 | 2025-10-11 16:09:54 | hamster | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 564 | 2025-09-24 03:29:30 | hamster | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 563 | 2025-09-05 23:00:55 | hamster | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 562 | 2025-09-05 02:00:20 | hamster | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 561 | 2025-08-25 13:28:02 | hamster | 1 | 69583 | 3 | 3.156 | 22047.8 |
| 560 | 2025-08-24 06:38:26 | hamster | 1 | 69583 | 3 | 5.563 | 12508.2 |
| 559 | 2025-08-15 08:50:25 | hamster | 1 | 69583 | 3 | 3.796 | 18330.6 |
| 558 | 2025-08-03 23:09:37 | hamster | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 557 | 2025-07-29 07:16:28 | hamster | 1 | 69583 | 3 | 6.826 | 10193.8 |
| 556 | 2025-07-28 00:13:43 | hamster | 2 | 107671 | 48 | 8.003 | 13453.8 |
| 555 | 2025-07-27 11:30:30 | hamster | 3 | 134027 | 516 | 38.253 | 3503.7 |
| 554 | 2025-07-27 10:10:13 | hamster | 2 | 107671 | 48 | 10.740 | 10025.2 |
| 553 | 2025-07-25 03:19:29 | hamster | 1 | 69583 | 3 | 3.530 | 19711.9 |
| 552 | 2025-07-24 10:15:28 | hamster | 1 | 69583 | 3 | 8.140 | 8548.3 |
| 551 | 2025-07-24 03:51:46 | hamster | 1 | 69583 | 3 | 3.310 | 21022.1 |
| 550 | 2025-07-22 18:20:28 | hamster | 1 | 69583 | 3 | 2.856 | 24363.8 |
| 549 | 2025-07-22 10:29:48 | hamster | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 548 | 2025-07-19 21:33:57 | hamster | 2 | 107671 | 48 | 4.750 | 22667.6 |
| 547 | 2025-07-15 20:22:22 | hamster | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 546 | 2025-07-14 07:35:12 | hamster | 1 | 69583 | 3 | 3.110 | 22374.0 |
| 545 | 2025-07-05 13:24:57 | hamster | 2 | 107671 | 48 | 16.046 | 6710.1 |
| 544 | 2025-07-04 13:54:03 | hamster | 1 | 69583 | 3 | 3.076 | 22621.3 |
| 543 | 2025-07-03 21:59:48 | hamster | 1 | 69583 | 3 | 3.033 | 22942.0 |
| 542 | 2025-07-01 22:46:11 | hamster | 3 | 134027 | 516 | 39.186 | 3420.3 |
| 541 | 2025-07-01 04:37:59 | hamster | 1 | 69583 | 3 | 1.453 | 47889.2 |
| 540 | 2025-06-22 04:27:49 | hamster | 1 | 69583 | 3 | 4.420 | 15742.8 |
| 539 | 2025-06-15 17:19:14 | hamster | 3 | 134027 | 516 | 5.936 | 22578.7 |
| 538 | 2025-06-14 09:55:20 | hamster | 3 | 134027 | 516 | 37.063 | 3616.2 |
| 537 | 2025-06-14 01:12:29 | hamster | 3 | 134027 | 516 | 50.220 | 2668.8 |
| 536 | 2025-06-12 07:52:25 | hamster | 3 | 134027 | 516 | 42.063 | 3186.3 |
| 535 | 2025-06-12 02:18:24 | hamster | 3 | 134027 | 516 | 31.643 | 4235.6 |
| 534 | 2025-06-10 15:05:40 | hamster | 3 | 134027 | 516 | 37.936 | 3533.0 |
| 533 | 2025-06-10 07:08:39 | hamster | 1 | 69583 | 3 | 4.406 | 15792.8 |
| 532 | 2025-06-03 21:25:46 | hamster | 1 | 69583 | 3 | 3.096 | 22475.1 |
| 531 | 2025-06-01 07:12:42 | hamster | 1 | 69583 | 3 | 2.983 | 23326.5 |
| 530 | 2025-05-20 13:58:22 | hamster | 1 | 69583 | 3 | 5.610 | 12403.4 |
| 529 | 2025-05-20 04:50:20 | hamster | 1 | 69583 | 3 | 4.970 | 14000.6 |
| 528 | 2025-05-14 06:35:29 | hamster | 1 | 69583 | 3 | 7.470 | 9315.0 |
| 527 | 2025-05-12 21:12:59 | hamster | 1 | 69583 | 3 | 5.376 | 12943.3 |
| 526 | 2025-05-11 13:50:43 | hamster | 1 | 69583 | 3 | 2.530 | 27503.2 |
| 525 | 2025-05-10 07:12:58 | hamster | 1 | 69583 | 3 | 3.686 | 18877.6 |
| 524 | 2025-05-09 16:47:11 | hamster | 3 | 134027 | 516 | 9.346 | 14340.6 |
| 523 | 2025-05-01 20:47:34 | hamster | 1 | 69583 | 3 | 6.220 | 11187.0 |
| 522 | 2025-04-28 20:43:36 | hamster | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 521 | 2025-04-21 02:02:33 | hamster | 3 | 134027 | 516 | 36.580 | 3663.9 |
| 520 | 2025-04-20 09:12:54 | hamster | 3 | 134027 | 516 | 33.300 | 4024.8 |
| 519 | 2025-04-20 03:59:14 | hamster | 1 | 69583 | 3 | 3.106 | 22402.8 |
| 518 | 2025-04-18 13:11:51 | hamster | 1 | 69583 | 3 | 3.250 | 21410.2 |
| 517 | 2025-04-18 00:08:39 | hamster | 3 | 134027 | 516 | 17.923 | 7477.9 |
| 516 | 2025-04-17 23:24:06 | hamster | 3 | 134027 | 516 | 39.233 | 3416.2 |
| 515 | 2025-04-16 08:27:10 | hamster | 3 | 134027 | 516 | 23.016 | 5823.2 |
| 514 | 2025-04-16 07:23:32 | hamster | 3 | 134027 | 516 | 39.640 | 3381.1 |
| 513 | 2025-04-14 19:08:28 | hamster | 3 | 134027 | 516 | 6.690 | 20033.9 |
| 512 | 2025-04-11 05:42:48 | hamster | 1 | 69583 | 3 | 9.140 | 7613.0 |
| 511 | 2025-04-03 10:02:17 | hamster | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 510 | 2025-03-30 21:47:01 | hamster | 1 | 69583 | 3 | 3.173 | 21929.7 |
| 509 | 2025-03-20 20:28:37 | hamster | 3 | 134027 | 516 | 30.330 | 4419.0 |
| 508 | 2025-03-19 21:22:41 | hamster | 2 | 107671 | 48 | 15.013 | 7171.9 |
| 507 | 2025-03-19 05:06:25 | hamster | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 506 | 2025-03-17 15:44:49 | hamster | 1 | 69583 | 3 | 8.140 | 8548.3 |
| 505 | 2025-03-13 04:03:20 | hamster | 1 | 69583 | 3 | 3.330 | 20895.8 |
| 504 | 2025-03-12 10:35:26 | hamster | 3 | 134027 | 516 | 46.313 | 2893.9 |
| 503 | 2025-03-11 08:22:35 | hamster | 3 | 134027 | 516 | 21.720 | 6170.7 |
| 502 | 2025-03-11 00:41:34 | hamster | 3 | 134027 | 516 | 31.786 | 4216.5 |
| 501 | 2025-03-10 21:07:43 | hamster | 2 | 107671 | 48 | 16.110 | 6683.5 |
| 500 | 2025-03-10 20:26:45 | hamster | 3 | 134027 | 516 | 18.376 | 7293.6 |
| 499 | 2025-03-10 18:07:27 | hamster | 3 | 134027 | 516 | 11.453 | 11702.3 |
| 498 | 2025-03-10 18:07:25 | hamster | 2 | 107671 | 48 | 4.393 | 24509.7 |
| 497 | 2025-03-10 18:07:20 | hamster | 1 | 69583 | 3 | 2.016 | 34515.4 |
| 496 | 2025-03-08 12:47:36 | hamster | 1 | 69583 | 3 | 3.203 | 21724.3 |
| 495 | 2025-03-03 19:26:38 | hamster | 2 | 107671 | 48 | 11.783 | 9137.8 |
| 494 | 2025-03-03 06:07:25 | hamster | 1 | 69583 | 3 | 3.123 | 22280.8 |
| 493 | 2025-02-24 21:15:17 | hamster | 1 | 69583 | 3 | 6.156 | 11303.3 |
| 492 | 2025-02-17 11:01:51 | hamster | 1 | 69583 | 3 | 5.050 | 13778.8 |
| 491 | 2025-02-07 03:16:27 | hamster | 1 | 69583 | 3 | 1.090 | 63837.6 |
| 490 | 2025-02-06 10:32:31 | hamster | 3 | 134027 | 516 | 20.046 | 6686.0 |
| 489 | 2025-02-05 19:16:01 | hamster | 3 | 134027 | 516 | 24.046 | 5573.8 |
| 488 | 2025-02-05 16:18:29 | hamster | 3 | 134027 | 516 | 36.300 | 3692.2 |
| 487 | 2025-02-05 15:29:35 | hamster | 3 | 134027 | 516 | 24.703 | 5425.5 |
| 486 | 2025-02-05 14:54:06 | hamster | 3 | 134027 | 516 | 27.143 | 4937.8 |
| 485 | 2025-01-23 07:46:08 | hamster | 1 | 69583 | 3 | 8.173 | 8513.8 |
| 484 | 2025-01-20 12:00:43 | hamster | 2 | 107671 | 48 | 16.610 | 6482.3 |
| 483 | 2025-01-20 12:00:27 | hamster | 1 | 69583 | 3 | 4.093 | 17000.5 |
| 482 | 2025-01-09 16:50:39 | hamster | 2 | 107671 | 48 | 24.846 | 4333.5 |
| 481 | 2024-12-27 09:48:56 | hamster | 3 | 134027 | 516 | 23.016 | 5823.2 |
| 480 | 2024-12-27 07:37:25 | hamster | 3 | 134027 | 516 | 45.643 | 2936.4 |
| 479 | 2024-12-26 05:46:29 | hamster | 3 | 134027 | 516 | 28.110 | 4767.9 |
| 478 | 2024-12-26 03:00:58 | hamster | 3 | 134027 | 516 | 31.503 | 4254.4 |
| 477 | 2024-12-26 03:00:57 | hamster | 2 | 107671 | 48 | 11.860 | 9078.5 |