History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knothole"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 407 | 2025-10-18 06:19:32 | knothole | 1 | 82945 | 2 | 1.440 | 57600.7 |
| 406 | 2025-10-18 02:30:00 | knothole | 1 | 82945 | 2 | 1.283 | 64649.3 |
| 405 | 2025-09-19 22:48:09 | knothole | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 404 | 2025-09-04 09:08:03 | knothole | 1 | 82945 | 2 | 1.373 | 60411.5 |
| 403 | 2025-08-31 06:51:30 | knothole | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 402 | 2025-08-18 03:15:56 | knothole | 3 | 146162 | 32 | 7.313 | 19986.6 |
| 401 | 2025-08-17 22:28:45 | knothole | 3 | 146162 | 32 | 36.156 | 4042.5 |
| 400 | 2025-08-14 03:36:51 | knothole | 2 | 121059 | 6 | 7.906 | 15312.3 |
| 399 | 2025-08-08 06:41:29 | knothole | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 398 | 2025-07-26 00:24:45 | knothole | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 397 | 2025-07-25 08:24:57 | knothole | 1 | 82945 | 2 | 3.140 | 26415.6 |
| 396 | 2025-07-25 01:16:10 | knothole | 1 | 82945 | 2 | 3.236 | 25632.0 |
| 395 | 2025-07-24 07:00:54 | knothole | 1 | 82945 | 2 | 8.610 | 9633.6 |
| 394 | 2025-07-24 01:07:12 | knothole | 1 | 82945 | 2 | 5.406 | 15343.1 |
| 393 | 2025-07-22 09:01:34 | knothole | 3 | 146162 | 32 | 10.203 | 14325.4 |
| 392 | 2025-07-21 08:35:19 | knothole | 3 | 146162 | 32 | 7.406 | 19735.6 |
| 391 | 2025-07-20 01:34:02 | knothole | 3 | 146162 | 32 | 7.203 | 20291.8 |
| 390 | 2025-07-16 01:09:17 | knothole | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 389 | 2025-07-13 18:19:55 | knothole | 3 | 146162 | 32 | 8.640 | 16916.9 |
| 388 | 2025-07-08 14:03:50 | knothole | 1 | 82945 | 2 | 6.406 | 12948.0 |
| 387 | 2025-07-07 16:26:46 | knothole | 1 | 82945 | 2 | 3.890 | 21322.6 |
| 386 | 2025-07-06 17:00:06 | knothole | 3 | 146162 | 32 | 18.703 | 7814.9 |
| 385 | 2025-07-01 18:42:08 | knothole | 3 | 146162 | 32 | 6.830 | 21400.0 |
| 384 | 2025-06-18 06:51:34 | knothole | 1 | 82945 | 2 | 8.186 | 10132.5 |
| 383 | 2025-06-16 12:33:44 | knothole | 1 | 82945 | 2 | 6.640 | 12491.7 |
| 382 | 2025-06-15 05:38:49 | knothole | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 381 | 2025-06-12 00:20:19 | knothole | 1 | 82945 | 2 | 7.626 | 10876.6 |
| 380 | 2025-06-10 09:05:58 | knothole | 3 | 146162 | 32 | 43.486 | 3361.1 |
| 379 | 2025-06-06 00:39:02 | knothole | 1 | 82945 | 2 | 4.156 | 19957.9 |
| 378 | 2025-06-05 03:32:27 | knothole | 1 | 82945 | 2 | 8.130 | 10202.3 |
| 377 | 2025-06-03 12:32:07 | knothole | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 376 | 2025-06-01 22:32:14 | knothole | 1 | 82945 | 2 | 6.580 | 12605.6 |
| 375 | 2025-05-29 01:02:44 | knothole | 1 | 82945 | 2 | 4.156 | 19957.9 |
| 374 | 2025-05-28 07:03:18 | knothole | 1 | 82945 | 2 | 4.583 | 18098.4 |
| 373 | 2025-05-26 13:26:00 | knothole | 1 | 82945 | 2 | 5.563 | 14910.1 |
| 372 | 2025-05-15 12:38:03 | knothole | 3 | 146162 | 32 | 7.156 | 20425.1 |
| 371 | 2025-05-11 05:05:12 | knothole | 1 | 82945 | 2 | 6.500 | 12760.8 |
| 370 | 2025-05-10 00:24:40 | knothole | 1 | 82945 | 2 | 4.326 | 19173.6 |
| 369 | 2025-05-07 16:03:14 | knothole | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 368 | 2025-04-30 22:23:16 | knothole | 1 | 82945 | 2 | 10.033 | 8267.2 |
| 367 | 2025-04-21 05:16:02 | knothole | 3 | 146162 | 32 | 65.456 | 2233.0 |
| 366 | 2025-04-18 22:52:44 | knothole | 3 | 146162 | 32 | 36.203 | 4037.3 |
| 365 | 2025-04-16 16:20:02 | knothole | 3 | 146162 | 32 | 36.456 | 4009.3 |
| 364 | 2025-04-13 18:32:26 | knothole | 3 | 146162 | 32 | 6.763 | 21612.0 |
| 363 | 2025-03-26 01:08:26 | knothole | 1 | 82945 | 2 | 6.310 | 13145.0 |
| 362 | 2025-03-13 06:15:58 | knothole | 1 | 82945 | 2 | 10.736 | 7725.9 |
| 361 | 2025-03-10 23:54:53 | knothole | 1 | 82945 | 2 | 1.813 | 45750.1 |
| 360 | 2025-03-05 07:08:59 | knothole | 1 | 82945 | 2 | 6.046 | 13719.0 |
| 359 | 2025-03-04 15:38:59 | knothole | 1 | 82945 | 2 | 6.313 | 13138.8 |
| 358 | 2025-02-28 00:55:00 | knothole | 1 | 82945 | 2 | 2.936 | 28251.0 |
| 357 | 2025-02-08 09:48:56 | knothole | 4 | 161609 | 289 | 79.006 | 2045.5 |
| 356 | 2025-02-07 19:49:12 | knothole | 3 | 146162 | 32 | 29.003 | 5039.5 |
| 355 | 2025-02-06 13:32:12 | knothole | 4 | 161609 | 289 | 49.470 | 3266.8 |
| 354 | 2025-02-06 13:31:51 | knothole | 3 | 146162 | 32 | 43.796 | 3337.3 |
| 353 | 2025-02-06 06:50:44 | knothole | 2 | 121059 | 6 | 7.766 | 15588.3 |
| 352 | 2025-02-06 06:50:29 | knothole | 4 | 161609 | 289 | 20.720 | 7799.7 |
| 351 | 2025-02-06 06:50:33 | knothole | 3 | 146162 | 32 | 15.843 | 9225.7 |
| 350 | 2025-02-06 06:50:21 | knothole | 1 | 82945 | 2 | 2.670 | 31065.5 |
| 349 | 2025-01-27 23:43:25 | knothole | 1 | 82945 | 2 | 4.393 | 18881.2 |
| 348 | 2025-01-21 23:28:58 | knothole | 1 | 82945 | 2 | 6.436 | 12887.7 |
| 347 | 2024-12-21 11:06:25 | knothole | 1 | 82945 | 2 | 7.953 | 10429.4 |
| 346 | 2024-12-10 08:11:34 | knothole | 1 | 82945 | 2 | 3.190 | 26001.6 |
| 345 | 2024-11-30 00:50:29 | knothole | 2 | 121059 | 6 | 18.643 | 6493.5 |
| 344 | 2024-11-30 00:49:51 | knothole | 1 | 82945 | 2 | 6.060 | 13687.3 |
| 343 | 2024-11-28 17:42:30 | knothole | 4 | 161609 | 289 | 21.156 | 7638.9 |
| 342 | 2024-11-28 17:42:31 | knothole | 2 | 121059 | 6 | 4.736 | 25561.4 |
| 341 | 2024-11-28 17:41:28 | knothole | 3 | 146162 | 32 | 8.033 | 18195.2 |
| 340 | 2024-11-26 16:22:48 | knothole | 3 | 146162 | 32 | 7.233 | 20207.7 |
| 339 | 2024-11-21 02:42:41 | knothole | 3 | 146162 | 32 | 52.080 | 2806.5 |
| 338 | 2024-11-20 17:25:51 | knothole | 3 | 146162 | 32 | 18.296 | 7988.7 |
| 337 | 2024-11-20 17:25:53 | knothole | 3 | 146162 | 32 | 12.250 | 11931.6 |
| 336 | 2024-11-20 17:25:52 | knothole | 2 | 121059 | 6 | 6.970 | 17368.6 |
| 335 | 2024-11-17 21:12:57 | knothole | 1 | 82945 | 2 | 4.500 | 18432.2 |
| 334 | 2024-11-09 16:07:10 | knothole | 1 | 82945 | 2 | 9.313 | 8906.4 |
| 333 | 2024-10-30 22:41:13 | knothole | 1 | 82945 | 2 | 1.393 | 59544.1 |
| 332 | 2024-10-17 00:53:41 | knothole | 3 | 146162 | 32 | 60.423 | 2419.0 |
| 331 | 2024-10-17 00:53:36 | knothole | 2 | 121059 | 6 | 15.906 | 7610.9 |
| 330 | 2024-10-12 20:06:05 | knothole | 3 | 146162 | 32 | 27.390 | 5336.3 |
| 329 | 2024-10-12 20:06:05 | knothole | 2 | 121059 | 6 | 15.643 | 7738.9 |
| 328 | 2024-10-12 20:05:49 | knothole | 1 | 82945 | 2 | 6.266 | 13237.3 |
| 327 | 2024-10-11 03:30:46 | knothole | 4 | 161609 | 289 | 30.610 | 5279.6 |
| 326 | 2024-10-10 21:26:10 | knothole | 3 | 146162 | 32 | 28.706 | 5091.7 |
| 325 | 2024-10-10 14:56:03 | knothole | 4 | 161609 | 289 | 55.186 | 2928.4 |
| 324 | 2024-10-10 09:07:45 | knothole | 4 | 161609 | 289 | 61.690 | 2619.7 |
| 323 | 2024-10-10 06:11:20 | knothole | 4 | 161609 | 289 | 31.300 | 5163.2 |
| 322 | 2024-10-10 06:11:25 | knothole | 3 | 146162 | 32 | 22.703 | 6438.0 |
| 321 | 2024-10-10 06:11:26 | knothole | 2 | 121059 | 6 | 16.703 | 7247.7 |
| 320 | 2024-10-10 06:10:02 | knothole | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 319 | 2024-10-07 20:14:55 | knothole | 1 | 82945 | 2 | 7.813 | 10616.3 |
| 318 | 2024-09-30 21:34:27 | knothole | 1 | 82945 | 2 | 10.080 | 8228.7 |
| 317 | 2024-08-16 15:47:44 | knothole | 1 | 82945 | 2 | 9.156 | 9059.1 |
| 316 | 2024-08-15 06:25:27 | knothole | 1 | 82945 | 2 | 14.156 | 5859.4 |
| 315 | 2024-08-13 05:23:42 | knothole | 1 | 82945 | 2 | 5.783 | 14342.9 |
| 314 | 2024-08-01 08:58:48 | knothole | 1 | 82945 | 2 | 2.203 | 37650.9 |
| 313 | 2024-07-18 02:58:16 | knothole | 1 | 82945 | 2 | 5.906 | 14044.2 |
| 312 | 2024-07-16 06:15:03 | knothole | 1 | 82945 | 2 | 9.016 | 9199.8 |
| 311 | 2024-07-08 03:06:20 | knothole | 1 | 82945 | 2 | 7.390 | 11224.0 |
| 310 | 2024-06-30 18:12:29 | knothole | 1 | 82945 | 2 | 5.406 | 15343.1 |
| 309 | 2024-06-24 10:17:51 | knothole | 1 | 82945 | 2 | 4.096 | 20250.2 |
| 308 | 2024-06-20 00:10:57 | knothole | 1 | 82945 | 2 | 6.530 | 12702.1 |