History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opticists"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 534 | 2025-10-07 02:39:00 | opticists | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 533 | 2025-10-06 19:59:43 | opticists | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 532 | 2025-09-28 21:45:27 | opticists | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 531 | 2025-09-25 05:53:58 | opticists | 1 | 81242 | 3 | 10.640 | 7635.5 |
| 530 | 2025-09-25 05:53:44 | opticists | 1 | 81242 | 3 | 8.140 | 9980.6 |
| 529 | 2025-09-25 05:53:35 | opticists | 1 | 81242 | 3 | 3.076 | 26411.6 |
| 528 | 2025-09-25 05:53:25 | opticists | 1 | 81242 | 3 | 4.813 | 16879.7 |
| 527 | 2025-09-08 12:39:16 | opticists | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 526 | 2025-09-06 22:14:13 | opticists | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 525 | 2025-09-01 01:30:40 | opticists | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 524 | 2025-08-31 03:03:18 | opticists | 3 | 148641 | 35 | 6.983 | 21286.1 |
| 523 | 2025-08-30 07:07:49 | opticists | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 522 | 2025-08-25 19:48:06 | opticists | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 521 | 2025-08-25 02:01:51 | opticists | 3 | 148641 | 35 | 24.830 | 5986.3 |
| 520 | 2025-08-24 21:20:02 | opticists | 2 | 121436 | 9 | 10.563 | 11496.4 |
| 519 | 2025-08-24 12:30:20 | opticists | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 518 | 2025-08-21 07:22:59 | opticists | 3 | 148641 | 35 | 22.626 | 6569.5 |
| 517 | 2025-08-20 22:04:12 | opticists | 2 | 121436 | 9 | 8.596 | 14127.0 |
| 516 | 2025-08-20 13:40:13 | opticists | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 515 | 2025-08-19 12:24:58 | opticists | 1 | 81242 | 3 | 5.406 | 15028.1 |
| 514 | 2025-08-15 09:38:59 | opticists | 1 | 81242 | 3 | 2.826 | 28748.1 |
| 513 | 2025-08-14 15:38:12 | opticists | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 512 | 2025-08-08 11:04:22 | opticists | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 511 | 2025-07-26 23:00:43 | opticists | 1 | 81242 | 3 | 5.390 | 15072.7 |
| 510 | 2025-07-25 06:31:21 | opticists | 1 | 81242 | 3 | 2.500 | 32496.8 |
| 509 | 2025-07-24 19:00:13 | opticists | 1 | 81242 | 3 | 4.906 | 16559.7 |
| 508 | 2025-07-24 11:01:40 | opticists | 1 | 81242 | 3 | 6.470 | 12556.7 |
| 507 | 2025-07-23 21:15:51 | opticists | 1 | 81242 | 3 | 3.313 | 24522.2 |
| 506 | 2025-07-17 14:03:09 | opticists | 3 | 148641 | 35 | 35.596 | 4175.8 |
| 505 | 2025-07-13 21:40:23 | opticists | 3 | 148641 | 35 | 28.830 | 5155.8 |
| 504 | 2025-07-13 00:27:10 | opticists | 1 | 81242 | 3 | 5.576 | 14569.9 |
| 503 | 2025-07-02 12:54:54 | opticists | 1 | 81242 | 3 | 6.533 | 12435.6 |
| 502 | 2025-06-29 05:57:34 | opticists | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 501 | 2025-06-18 18:16:04 | opticists | 1 | 81242 | 3 | 8.050 | 10092.2 |
| 500 | 2025-06-18 13:37:18 | opticists | 1 | 81242 | 3 | 6.140 | 13231.6 |
| 499 | 2025-06-16 11:51:53 | opticists | 3 | 148641 | 35 | 35.596 | 4175.8 |
| 498 | 2025-06-15 21:00:31 | opticists | 2 | 121436 | 9 | 17.250 | 7039.8 |
| 497 | 2025-06-15 08:27:37 | opticists | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 496 | 2025-06-06 14:36:36 | opticists | 1 | 81242 | 3 | 6.860 | 11842.9 |
| 495 | 2025-06-06 13:05:44 | opticists | 3 | 148641 | 35 | 31.140 | 4773.3 |
| 494 | 2025-06-06 00:44:47 | opticists | 2 | 121436 | 9 | 10.860 | 11182.0 |
| 493 | 2025-06-04 21:19:13 | opticists | 3 | 148641 | 35 | 36.910 | 4027.1 |
| 492 | 2025-06-04 19:43:07 | opticists | 4 | 165329 | 287 | 54.766 | 3018.8 |
| 491 | 2025-06-02 14:39:00 | opticists | 2 | 121436 | 9 | 15.143 | 8019.3 |
| 490 | 2025-06-02 14:11:57 | opticists | 4 | 165329 | 287 | 51.456 | 3213.0 |
| 489 | 2025-05-31 17:45:43 | opticists | 2 | 121436 | 9 | 17.830 | 6810.8 |
| 488 | 2025-05-31 17:33:36 | opticists | 4 | 165329 | 287 | 62.943 | 2626.6 |
| 487 | 2025-05-31 11:45:18 | opticists | 3 | 148641 | 35 | 21.453 | 6928.7 |
| 486 | 2025-05-28 13:22:02 | opticists | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 485 | 2025-05-26 20:50:16 | opticists | 3 | 148641 | 35 | 27.280 | 5448.7 |
| 484 | 2025-05-22 23:44:55 | opticists | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 483 | 2025-05-21 11:14:14 | opticists | 3 | 148641 | 35 | 15.783 | 9417.8 |
| 482 | 2025-05-17 23:51:43 | opticists | 1 | 81242 | 3 | 4.483 | 18122.2 |
| 481 | 2025-05-15 20:56:53 | opticists | 2 | 121436 | 9 | 17.783 | 6828.8 |
| 480 | 2025-05-15 08:40:51 | opticists | 1 | 81242 | 3 | 5.283 | 15378.0 |
| 479 | 2025-05-08 13:55:47 | opticists | 1 | 81242 | 3 | 3.143 | 25848.6 |
| 478 | 2025-05-04 13:28:55 | opticists | 1 | 81242 | 3 | 7.486 | 10852.5 |
| 477 | 2025-05-03 14:42:22 | opticists | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 476 | 2025-05-03 08:07:19 | opticists | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 475 | 2025-04-23 22:14:53 | opticists | 2 | 121436 | 9 | 19.940 | 6090.1 |
| 474 | 2025-04-19 12:03:54 | opticists | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 473 | 2025-04-14 08:13:45 | opticists | 1 | 81242 | 3 | 3.220 | 25230.4 |
| 472 | 2025-04-11 17:50:18 | opticists | 3 | 148641 | 35 | 39.176 | 3794.2 |
| 471 | 2025-04-09 07:20:58 | opticists | 3 | 148641 | 35 | 30.890 | 4811.9 |
| 470 | 2025-04-05 06:37:00 | opticists | 3 | 148641 | 35 | 33.470 | 4441.0 |
| 469 | 2025-04-02 01:49:57 | opticists | 3 | 148641 | 35 | 37.973 | 3914.4 |
| 468 | 2025-04-01 22:51:34 | opticists | 1 | 81242 | 3 | 6.686 | 12151.1 |
| 467 | 2025-04-01 16:45:45 | opticists | 1 | 81242 | 3 | 1.440 | 56418.1 |
| 466 | 2025-04-01 15:25:08 | opticists | 1 | 81242 | 3 | 6.563 | 12378.8 |
| 465 | 2025-03-31 19:37:15 | opticists | 2 | 121436 | 9 | 12.280 | 9888.9 |
| 464 | 2025-03-31 03:49:54 | opticists | 3 | 148641 | 35 | 38.456 | 3865.2 |
| 463 | 2025-03-29 21:34:10 | opticists | 4 | 165329 | 287 | 59.986 | 2756.1 |
| 462 | 2025-03-29 08:02:02 | opticists | 4 | 165329 | 287 | 81.363 | 2032.0 |
| 461 | 2025-03-29 01:33:54 | opticists | 4 | 165329 | 287 | 61.863 | 2672.5 |
| 460 | 2025-03-26 17:07:05 | opticists | 2 | 121436 | 9 | 8.860 | 13706.1 |
| 459 | 2025-03-26 16:41:56 | opticists | 4 | 165329 | 287 | 53.596 | 3084.7 |
| 458 | 2025-03-24 18:10:31 | opticists | 3 | 148641 | 35 | 6.830 | 21763.0 |
| 457 | 2025-03-16 03:30:58 | opticists | 1 | 81242 | 3 | 6.720 | 12089.6 |
| 456 | 2025-03-15 04:52:53 | opticists | 1 | 81242 | 3 | 3.576 | 22718.7 |
| 455 | 2025-03-13 07:15:04 | opticists | 3 | 148641 | 35 | 29.033 | 5119.7 |
| 454 | 2025-02-26 08:19:45 | opticists | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 453 | 2025-02-25 03:42:49 | opticists | 1 | 81242 | 3 | 3.873 | 20976.5 |
| 452 | 2025-02-16 03:47:05 | opticists | 3 | 148641 | 35 | 18.690 | 7953.0 |
| 451 | 2025-02-16 02:34:16 | opticists | 3 | 148641 | 35 | 30.236 | 4916.0 |
| 450 | 2025-02-13 16:50:22 | opticists | 3 | 148641 | 35 | 36.126 | 4114.5 |
| 449 | 2025-02-11 10:50:45 | opticists | 3 | 148641 | 35 | 44.220 | 3361.4 |
| 448 | 2025-02-09 08:22:37 | opticists | 1 | 81242 | 3 | 9.486 | 8564.4 |
| 447 | 2025-02-08 09:42:11 | opticists | 3 | 148641 | 35 | 30.456 | 4880.5 |
| 446 | 2025-02-06 15:23:18 | opticists | 3 | 148641 | 35 | 18.733 | 7934.7 |
| 445 | 2025-02-04 04:20:26 | opticists | 3 | 148641 | 35 | 45.363 | 3276.7 |
| 444 | 2025-02-04 03:35:57 | opticists | 3 | 148641 | 35 | 30.766 | 4831.3 |
| 443 | 2025-02-04 03:35:58 | opticists | 2 | 121436 | 9 | 15.580 | 7794.4 |
| 442 | 2025-02-04 03:35:21 | opticists | 1 | 81242 | 3 | 3.516 | 23106.4 |
| 441 | 2025-02-03 21:45:03 | opticists | 4 | 165329 | 287 | 65.340 | 2530.3 |
| 440 | 2025-02-02 11:32:50 | opticists | 2 | 121436 | 9 | 17.946 | 6766.7 |
| 439 | 2025-02-02 11:30:44 | opticists | 1 | 81242 | 3 | 3.770 | 21549.6 |
| 438 | 2025-01-27 22:22:31 | opticists | 4 | 165329 | 287 | 47.516 | 3479.4 |
| 437 | 2025-01-24 23:26:18 | opticists | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 436 | 2025-01-07 07:36:14 | opticists | 3 | 148641 | 35 | 17.360 | 8562.3 |
| 435 | 2025-01-06 17:55:50 | opticists | 1 | 81242 | 3 | 5.516 | 14728.4 |