History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ecotype"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 500 | 2025-12-05 12:13:05 | ecotype | 4 | 151207 | 635 | 11.203 | 13497.0 |
| 499 | 2025-12-04 05:27:48 | ecotype | 3 | 134027 | 67 | 6.513 | 20578.4 |
| 498 | 2025-11-28 12:22:09 | ecotype | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 497 | 2025-11-27 09:54:42 | ecotype | 1 | 69583 | 4 | 1.656 | 42018.7 |
| 496 | 2025-11-23 08:34:23 | ecotype | 1 | 69583 | 4 | 2.186 | 31831.2 |
| 495 | 2025-11-22 17:40:49 | ecotype | 1 | 69583 | 4 | 3.360 | 20709.2 |
| 494 | 2025-11-22 17:39:11 | ecotype | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 493 | 2025-11-20 00:43:36 | ecotype | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 492 | 2025-11-16 00:55:19 | ecotype | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 491 | 2025-11-05 18:06:51 | ecotype | 3 | 134027 | 67 | 6.703 | 19995.1 |
| 490 | 2025-11-02 04:05:03 | ecotype | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 489 | 2025-11-01 13:33:20 | ecotype | 1 | 69583 | 4 | 1.783 | 39025.8 |
| 488 | 2025-10-25 07:05:18 | ecotype | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 487 | 2025-10-23 11:40:07 | ecotype | 1 | 69583 | 4 | 3.953 | 17602.6 |
| 486 | 2025-10-22 08:23:53 | ecotype | 3 | 134027 | 67 | 17.886 | 7493.4 |
| 485 | 2025-10-21 07:40:54 | ecotype | 1 | 69583 | 4 | 2.860 | 24329.7 |
| 484 | 2025-10-21 02:05:20 | ecotype | 1 | 69583 | 4 | 2.453 | 28366.5 |
| 483 | 2025-10-20 23:00:09 | ecotype | 1 | 69583 | 4 | 8.076 | 8616.0 |
| 482 | 2025-10-20 22:59:37 | ecotype | 1 | 69583 | 4 | 8.906 | 7813.0 |
| 481 | 2025-10-20 22:59:08 | ecotype | 1 | 69583 | 4 | 5.983 | 11630.1 |
| 480 | 2025-10-16 23:38:45 | ecotype | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 479 | 2025-10-16 23:38:32 | ecotype | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 478 | 2025-10-08 08:36:00 | ecotype | 3 | 134027 | 67 | 6.390 | 20974.5 |
| 477 | 2025-09-25 00:02:27 | ecotype | 1 | 69583 | 4 | 3.593 | 19366.3 |
| 476 | 2025-09-25 00:01:50 | ecotype | 1 | 69583 | 4 | 5.546 | 12546.5 |
| 475 | 2025-09-16 18:19:12 | ecotype | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 474 | 2025-09-11 20:06:40 | ecotype | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 473 | 2025-09-11 01:34:53 | ecotype | 3 | 134027 | 67 | 6.656 | 20136.3 |
| 472 | 2025-09-05 00:10:54 | ecotype | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 471 | 2025-09-04 03:08:54 | ecotype | 2 | 107671 | 16 | 3.170 | 33965.6 |
| 470 | 2025-09-01 02:06:00 | ecotype | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 469 | 2025-08-28 14:00:30 | ecotype | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 468 | 2025-08-28 08:55:47 | ecotype | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 467 | 2025-07-27 12:14:33 | ecotype | 1 | 69583 | 4 | 6.640 | 10479.4 |
| 466 | 2025-07-25 10:36:45 | ecotype | 1 | 69583 | 4 | 4.186 | 16622.8 |
| 465 | 2025-07-24 10:50:49 | ecotype | 1 | 69583 | 4 | 2.780 | 25029.9 |
| 464 | 2025-07-18 10:39:44 | ecotype | 1 | 69583 | 4 | 2.813 | 24736.2 |
| 463 | 2025-07-07 03:37:07 | ecotype | 4 | 151207 | 635 | 37.066 | 4079.4 |
| 462 | 2025-07-06 01:04:57 | ecotype | 4 | 151207 | 635 | 22.343 | 6767.5 |
| 461 | 2025-07-05 08:56:32 | ecotype | 4 | 151207 | 635 | 66.706 | 2266.8 |
| 460 | 2025-07-05 05:58:40 | ecotype | 4 | 151207 | 635 | 52.116 | 2901.4 |
| 459 | 2025-07-04 04:40:56 | ecotype | 4 | 151207 | 635 | 41.530 | 3640.9 |
| 458 | 2025-07-03 22:12:43 | ecotype | 4 | 151207 | 635 | 20.110 | 7519.0 |
| 457 | 2025-07-02 03:21:07 | ecotype | 1 | 69583 | 4 | 6.390 | 10889.4 |
| 456 | 2025-06-26 11:43:23 | ecotype | 1 | 69583 | 4 | 9.346 | 7445.2 |
| 455 | 2025-06-23 13:39:27 | ecotype | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 454 | 2025-06-22 02:02:18 | ecotype | 2 | 107671 | 16 | 15.296 | 7039.2 |
| 453 | 2025-06-20 13:59:42 | ecotype | 1 | 69583 | 4 | 2.813 | 24736.2 |
| 452 | 2025-06-19 11:35:34 | ecotype | 2 | 107671 | 16 | 12.046 | 8938.3 |
| 451 | 2025-06-18 07:55:24 | ecotype | 1 | 69583 | 4 | 7.923 | 8782.4 |
| 450 | 2025-06-17 07:20:27 | ecotype | 2 | 107671 | 16 | 3.640 | 29579.9 |
| 449 | 2025-06-16 02:21:57 | ecotype | 3 | 134027 | 67 | 24.096 | 5562.2 |
| 448 | 2025-06-14 22:28:54 | ecotype | 3 | 134027 | 67 | 9.953 | 13466.0 |
| 447 | 2025-06-14 14:06:54 | ecotype | 1 | 69583 | 4 | 5.843 | 11908.8 |
| 446 | 2025-06-14 05:54:25 | ecotype | 3 | 134027 | 67 | 48.533 | 2761.6 |
| 445 | 2025-06-13 07:39:18 | ecotype | 2 | 107671 | 16 | 21.313 | 5051.9 |
| 444 | 2025-06-11 18:33:26 | ecotype | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 443 | 2025-06-11 15:06:38 | ecotype | 1 | 69583 | 4 | 3.373 | 20629.4 |
| 442 | 2025-06-10 11:43:26 | ecotype | 2 | 107671 | 16 | 16.753 | 6427.0 |
| 441 | 2025-06-10 11:22:49 | ecotype | 3 | 134027 | 67 | 34.390 | 3897.3 |
| 440 | 2025-06-04 17:54:13 | ecotype | 4 | 151207 | 635 | 62.203 | 2430.9 |
| 439 | 2025-06-03 13:38:23 | ecotype | 4 | 151207 | 635 | 46.706 | 3237.4 |
| 438 | 2025-06-02 14:00:35 | ecotype | 4 | 151207 | 635 | 44.160 | 3424.1 |
| 437 | 2025-06-01 02:29:08 | ecotype | 4 | 151207 | 635 | 56.340 | 2683.8 |
| 436 | 2025-05-31 14:11:22 | ecotype | 4 | 151207 | 635 | 44.486 | 3399.0 |
| 435 | 2025-05-30 23:04:49 | ecotype | 1 | 69583 | 4 | 7.173 | 9700.7 |
| 434 | 2025-05-30 15:04:32 | ecotype | 1 | 69583 | 4 | 3.843 | 18106.4 |
| 433 | 2025-05-28 21:52:30 | ecotype | 4 | 151207 | 635 | 41.473 | 3645.9 |
| 432 | 2025-05-24 18:14:22 | ecotype | 1 | 69583 | 4 | 3.046 | 22844.1 |
| 431 | 2025-05-23 11:51:18 | ecotype | 4 | 151207 | 635 | 53.173 | 2843.7 |
| 430 | 2025-05-22 11:34:32 | ecotype | 1 | 69583 | 4 | 6.250 | 11133.3 |
| 429 | 2025-05-21 16:59:21 | ecotype | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 428 | 2025-05-16 14:04:21 | ecotype | 1 | 69583 | 4 | 8.596 | 8094.8 |
| 427 | 2025-05-14 10:13:20 | ecotype | 1 | 69583 | 4 | 6.106 | 11395.8 |
| 426 | 2025-05-04 01:29:20 | ecotype | 4 | 151207 | 635 | 48.543 | 3114.9 |
| 425 | 2025-05-03 10:59:16 | ecotype | 3 | 134027 | 67 | 7.096 | 18887.7 |
| 424 | 2025-05-02 14:04:15 | ecotype | 4 | 151207 | 635 | 58.863 | 2568.8 |
| 423 | 2025-05-02 11:39:09 | ecotype | 2 | 107671 | 16 | 17.846 | 6033.3 |
| 422 | 2025-05-01 11:25:27 | ecotype | 3 | 134027 | 67 | 8.096 | 16554.7 |
| 421 | 2025-04-29 13:15:24 | ecotype | 3 | 134027 | 67 | 5.843 | 22938.0 |
| 420 | 2025-04-19 21:03:58 | ecotype | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 419 | 2025-04-14 09:27:30 | ecotype | 1 | 69583 | 4 | 8.576 | 8113.7 |
| 418 | 2025-04-11 14:32:09 | ecotype | 1 | 69583 | 4 | 4.923 | 14134.3 |
| 417 | 2025-03-26 19:03:08 | ecotype | 3 | 134027 | 67 | 14.156 | 9467.9 |
| 416 | 2025-03-15 19:57:08 | ecotype | 1 | 69583 | 4 | 5.983 | 11630.1 |
| 415 | 2025-03-07 12:30:43 | ecotype | 3 | 134027 | 67 | 32.346 | 4143.5 |
| 414 | 2025-03-06 05:09:29 | ecotype | 3 | 134027 | 67 | 34.376 | 3898.9 |
| 413 | 2025-03-05 19:19:56 | ecotype | 3 | 134027 | 67 | 52.486 | 2553.6 |
| 412 | 2025-03-04 19:19:16 | ecotype | 3 | 134027 | 67 | 38.516 | 3479.8 |
| 411 | 2025-03-04 19:19:14 | ecotype | 3 | 134027 | 67 | 33.550 | 3994.8 |
| 410 | 2025-03-04 19:19:06 | ecotype | 2 | 107671 | 16 | 16.203 | 6645.1 |
| 409 | 2025-03-04 19:17:36 | ecotype | 1 | 69583 | 4 | 4.420 | 15742.8 |
| 408 | 2025-03-04 03:48:08 | ecotype | 1 | 69583 | 4 | 4.953 | 14048.7 |
| 407 | 2025-02-27 02:46:22 | ecotype | 1 | 69583 | 4 | 3.033 | 22942.0 |
| 406 | 2025-02-26 16:57:57 | ecotype | 1 | 69583 | 4 | 6.203 | 11217.6 |
| 405 | 2025-02-05 19:35:17 | ecotype | 2 | 107671 | 16 | 16.046 | 6710.1 |
| 404 | 2025-02-03 02:48:59 | ecotype | 3 | 134027 | 67 | 32.406 | 4135.9 |
| 403 | 2025-02-02 06:29:02 | ecotype | 3 | 134027 | 67 | 40.656 | 3296.6 |
| 402 | 2025-02-02 04:41:59 | ecotype | 3 | 134027 | 67 | 33.266 | 4028.9 |
| 401 | 2025-02-01 21:52:27 | ecotype | 3 | 134027 | 67 | 43.190 | 3103.2 |