History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sterling"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 509 | 2025-09-26 08:40:07 | sterling | 1 | 82945 | 5 | 1.673 | 49578.6 |
| 508 | 2025-09-11 06:38:38 | sterling | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 507 | 2025-09-06 22:18:09 | sterling | 2 | 121059 | 66 | 3.250 | 37248.9 |
| 506 | 2025-08-28 22:51:32 | sterling | 2 | 121059 | 66 | 3.423 | 35366.3 |
| 505 | 2025-08-28 02:11:56 | sterling | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 504 | 2025-08-22 18:16:44 | sterling | 1 | 82945 | 5 | 3.140 | 26415.6 |
| 503 | 2025-08-12 14:17:24 | sterling | 1 | 82945 | 5 | 3.576 | 23194.9 |
| 502 | 2025-08-10 10:43:37 | sterling | 3 | 146162 | 570 | 32.253 | 4531.7 |
| 501 | 2025-08-07 16:43:20 | sterling | 3 | 146162 | 570 | 17.140 | 8527.5 |
| 500 | 2025-08-05 12:26:15 | sterling | 3 | 146162 | 570 | 19.343 | 7556.3 |
| 499 | 2025-08-05 00:15:31 | sterling | 1 | 82945 | 5 | 5.330 | 15561.9 |
| 498 | 2025-08-04 08:02:16 | sterling | 1 | 82945 | 5 | 4.110 | 20181.3 |
| 497 | 2025-07-31 20:45:10 | sterling | 3 | 146162 | 570 | 18.440 | 7926.4 |
| 496 | 2025-07-28 06:58:43 | sterling | 3 | 146162 | 570 | 18.470 | 7913.5 |
| 495 | 2025-07-28 01:26:51 | sterling | 3 | 146162 | 570 | 33.796 | 4324.8 |
| 494 | 2025-07-27 04:25:22 | sterling | 3 | 146162 | 570 | 22.953 | 6367.9 |
| 493 | 2025-07-27 03:26:55 | sterling | 1 | 82945 | 5 | 3.296 | 25165.4 |
| 492 | 2025-07-25 02:16:00 | sterling | 1 | 82945 | 5 | 3.406 | 24352.6 |
| 491 | 2025-07-24 07:53:55 | sterling | 3 | 146162 | 570 | 39.453 | 3704.7 |
| 490 | 2025-07-23 17:46:39 | sterling | 1 | 82945 | 5 | 6.050 | 13709.9 |
| 489 | 2025-07-23 15:39:22 | sterling | 1 | 82945 | 5 | 4.123 | 20117.6 |
| 488 | 2025-07-23 10:23:07 | sterling | 1 | 82945 | 5 | 5.106 | 16244.6 |
| 487 | 2025-07-22 22:54:22 | sterling | 1 | 82945 | 5 | 5.893 | 14075.2 |
| 486 | 2025-07-21 09:27:31 | sterling | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 485 | 2025-07-15 22:49:15 | sterling | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 484 | 2025-07-06 14:29:29 | sterling | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 483 | 2025-07-02 16:13:59 | sterling | 1 | 82945 | 5 | 3.203 | 25896.0 |
| 482 | 2025-07-01 23:58:24 | sterling | 1 | 82945 | 5 | 4.940 | 16790.5 |
| 481 | 2025-06-27 14:56:08 | sterling | 2 | 121059 | 66 | 11.566 | 10466.8 |
| 480 | 2025-06-26 03:30:09 | sterling | 1 | 82945 | 5 | 7.096 | 11689.0 |
| 479 | 2025-06-24 18:14:18 | sterling | 2 | 121059 | 66 | 21.003 | 5763.9 |
| 478 | 2025-06-23 02:58:21 | sterling | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 477 | 2025-06-20 22:05:57 | sterling | 3 | 146162 | 570 | 25.766 | 5672.7 |
| 476 | 2025-06-20 11:34:25 | sterling | 2 | 121059 | 66 | 14.670 | 8252.1 |
| 475 | 2025-06-20 10:35:35 | sterling | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 474 | 2025-06-18 18:06:49 | sterling | 3 | 146162 | 570 | 32.110 | 4551.9 |
| 473 | 2025-06-14 07:25:25 | sterling | 3 | 146162 | 570 | 52.690 | 2774.0 |
| 472 | 2025-06-14 04:34:52 | sterling | 2 | 121059 | 66 | 22.096 | 5478.8 |
| 471 | 2025-06-14 01:18:24 | sterling | 1 | 82945 | 5 | 6.983 | 11878.1 |
| 470 | 2025-06-13 02:28:33 | sterling | 3 | 146162 | 570 | 22.000 | 6643.7 |
| 469 | 2025-06-12 15:22:35 | sterling | 3 | 146162 | 570 | 34.733 | 4208.2 |
| 468 | 2025-06-11 13:49:35 | sterling | 3 | 146162 | 570 | 20.203 | 7234.7 |
| 467 | 2025-06-11 03:22:07 | sterling | 2 | 121059 | 66 | 27.343 | 4427.4 |
| 466 | 2025-06-02 13:48:02 | sterling | 1 | 82945 | 5 | 10.830 | 7658.8 |
| 465 | 2025-05-26 03:50:26 | sterling | 1 | 82945 | 5 | 7.233 | 11467.6 |
| 464 | 2025-05-24 07:03:06 | sterling | 3 | 146162 | 570 | 27.906 | 5237.7 |
| 463 | 2025-05-22 19:30:42 | sterling | 2 | 121059 | 66 | 4.080 | 29671.3 |
| 462 | 2025-05-22 18:43:54 | sterling | 3 | 146162 | 570 | 7.390 | 19778.3 |
| 461 | 2025-05-21 03:53:14 | sterling | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 460 | 2025-05-20 02:32:26 | sterling | 1 | 82945 | 5 | 5.720 | 14500.9 |
| 459 | 2025-05-14 14:45:15 | sterling | 1 | 82945 | 5 | 7.500 | 11059.3 |
| 458 | 2025-05-13 07:34:05 | sterling | 3 | 146162 | 570 | 8.046 | 18165.8 |
| 457 | 2025-05-03 22:06:32 | sterling | 3 | 146162 | 570 | 34.923 | 4185.3 |
| 456 | 2025-05-02 07:46:06 | sterling | 2 | 121059 | 66 | 17.846 | 6783.5 |
| 455 | 2025-05-02 03:45:16 | sterling | 3 | 146162 | 570 | 49.126 | 2975.2 |
| 454 | 2025-05-01 13:04:54 | sterling | 1 | 82945 | 5 | 7.563 | 10967.2 |
| 453 | 2025-05-01 08:45:01 | sterling | 1 | 82945 | 5 | 3.610 | 22976.5 |
| 452 | 2025-04-30 00:01:34 | sterling | 1 | 82945 | 5 | 7.093 | 11693.9 |
| 451 | 2025-04-23 17:43:06 | sterling | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 450 | 2025-04-23 03:31:20 | sterling | 1 | 82945 | 5 | 9.453 | 8774.5 |
| 449 | 2025-04-20 01:50:09 | sterling | 1 | 82945 | 5 | 8.580 | 9667.2 |
| 448 | 2025-03-31 15:47:23 | sterling | 1 | 82945 | 5 | 8.046 | 10308.8 |
| 447 | 2025-03-20 03:22:35 | sterling | 1 | 82945 | 5 | 5.233 | 15850.4 |
| 446 | 2025-03-17 15:16:44 | sterling | 3 | 146162 | 570 | 27.173 | 5378.9 |
| 445 | 2025-03-16 12:35:19 | sterling | 3 | 146162 | 570 | 19.326 | 7563.0 |
| 444 | 2025-03-16 10:44:55 | sterling | 3 | 146162 | 570 | 22.250 | 6569.1 |
| 443 | 2025-03-12 16:29:36 | sterling | 1 | 82945 | 5 | 6.920 | 11986.3 |
| 442 | 2025-02-25 18:58:52 | sterling | 1 | 82945 | 5 | 7.016 | 11822.3 |
| 441 | 2025-02-25 12:18:37 | sterling | 1 | 82945 | 5 | 6.313 | 13138.8 |
| 440 | 2025-02-24 09:28:02 | sterling | 3 | 146162 | 570 | 38.816 | 3765.5 |
| 439 | 2025-02-24 03:58:31 | sterling | 3 | 146162 | 570 | 34.316 | 4259.3 |
| 438 | 2025-02-23 12:40:41 | sterling | 3 | 146162 | 570 | 38.113 | 3835.0 |
| 437 | 2025-02-22 22:35:54 | sterling | 3 | 146162 | 570 | 39.466 | 3703.5 |
| 436 | 2025-02-22 19:48:27 | sterling | 3 | 146162 | 570 | 38.936 | 3753.9 |
| 435 | 2025-02-15 13:37:47 | sterling | 1 | 82945 | 5 | 8.656 | 9582.4 |
| 434 | 2025-02-14 19:57:30 | sterling | 1 | 82945 | 5 | 11.423 | 7261.2 |
| 433 | 2025-02-09 09:09:23 | sterling | 1 | 82945 | 5 | 3.220 | 25759.3 |
| 432 | 2025-01-25 15:22:05 | sterling | 2 | 121059 | 66 | 3.830 | 31608.1 |
| 431 | 2025-01-24 18:02:01 | sterling | 3 | 146162 | 570 | 45.156 | 3236.8 |
| 430 | 2025-01-23 22:27:59 | sterling | 2 | 121059 | 66 | 15.596 | 7762.2 |
| 429 | 2025-01-23 16:21:58 | sterling | 2 | 121059 | 66 | 21.156 | 5722.2 |
| 428 | 2025-01-23 09:09:52 | sterling | 3 | 146162 | 570 | 37.910 | 3855.5 |
| 427 | 2025-01-22 07:08:03 | sterling | 3 | 146162 | 570 | 46.300 | 3156.8 |
| 426 | 2025-01-21 19:06:10 | sterling | 3 | 146162 | 570 | 41.163 | 3550.8 |
| 425 | 2025-01-21 19:06:17 | sterling | 2 | 121059 | 66 | 16.236 | 7456.2 |
| 424 | 2025-01-21 19:04:33 | sterling | 1 | 82945 | 5 | 3.483 | 23814.2 |
| 423 | 2025-01-12 06:04:06 | sterling | 1 | 82945 | 5 | 7.330 | 11315.8 |
| 422 | 2025-01-11 14:35:18 | sterling | 2 | 121059 | 66 | 18.486 | 6548.7 |
| 421 | 2025-01-11 06:02:03 | sterling | 1 | 82945 | 5 | 5.016 | 16536.1 |
| 420 | 2024-12-25 06:45:54 | sterling | 3 | 146162 | 570 | 29.440 | 4964.7 |
| 419 | 2024-12-24 06:40:41 | sterling | 2 | 121059 | 66 | 28.266 | 4282.8 |
| 418 | 2024-12-23 23:37:04 | sterling | 2 | 121059 | 66 | 5.016 | 24134.6 |
| 417 | 2024-12-21 08:33:09 | sterling | 2 | 121059 | 66 | 3.390 | 35710.6 |
| 416 | 2024-12-21 08:33:05 | sterling | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 415 | 2024-12-12 14:29:10 | sterling | 1 | 82945 | 5 | 6.923 | 11981.1 |
| 414 | 2024-12-08 16:41:08 | sterling | 3 | 146162 | 570 | 27.453 | 5324.1 |
| 413 | 2024-12-07 20:07:26 | sterling | 3 | 146162 | 570 | 19.923 | 7336.3 |
| 412 | 2024-12-05 20:36:41 | sterling | 3 | 146162 | 570 | 37.926 | 3853.9 |
| 411 | 2024-12-05 13:41:58 | sterling | 3 | 146162 | 570 | 29.516 | 4952.0 |
| 410 | 2024-12-05 13:42:00 | sterling | 2 | 121059 | 66 | 16.643 | 7273.9 |