History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"interstate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 485 | 2025-07-16 21:41:10 | interstate | 1 | 67641 | 4 | 2.890 | 23405.2 |
| 484 | 2025-07-11 06:57:24 | interstate | 1 | 67641 | 4 | 4.360 | 15514.0 |
| 483 | 2025-07-08 03:53:06 | interstate | 1 | 67641 | 4 | 5.173 | 13075.8 |
| 482 | 2025-07-06 23:59:07 | interstate | 1 | 67641 | 4 | 5.640 | 11993.1 |
| 481 | 2025-07-02 16:20:53 | interstate | 1 | 67641 | 4 | 5.283 | 12803.5 |
| 480 | 2025-06-27 05:09:55 | interstate | 1 | 67641 | 4 | 5.253 | 12876.6 |
| 479 | 2025-06-15 21:48:00 | interstate | 1 | 67641 | 4 | 5.500 | 12298.4 |
| 478 | 2025-06-10 00:37:46 | interstate | 1 | 67641 | 4 | 5.216 | 12968.0 |
| 477 | 2025-05-31 00:04:10 | interstate | 1 | 67641 | 4 | 5.140 | 13159.7 |
| 476 | 2025-05-26 05:32:49 | interstate | 1 | 67641 | 4 | 8.263 | 8186.0 |
| 475 | 2025-05-22 18:16:58 | interstate | 1 | 67641 | 4 | 7.063 | 9576.8 |
| 474 | 2025-05-22 01:32:00 | interstate | 1 | 67641 | 4 | 3.013 | 22449.7 |
| 473 | 2025-05-21 14:06:51 | interstate | 4 | 161450 | 292 | 44.063 | 3664.1 |
| 472 | 2025-05-20 12:46:15 | interstate | 4 | 161450 | 292 | 45.966 | 3512.4 |
| 471 | 2025-05-18 16:32:00 | interstate | 4 | 161450 | 292 | 64.613 | 2498.7 |
| 470 | 2025-05-18 12:12:28 | interstate | 4 | 161450 | 292 | 48.760 | 3311.1 |
| 469 | 2025-05-17 13:59:03 | interstate | 3 | 140603 | 56 | 22.813 | 6163.3 |
| 468 | 2025-05-17 10:11:04 | interstate | 2 | 108824 | 9 | 2.876 | 37838.7 |
| 467 | 2025-05-17 04:16:21 | interstate | 4 | 161450 | 292 | 68.666 | 2351.2 |
| 466 | 2025-05-15 21:39:26 | interstate | 1 | 67641 | 4 | 1.156 | 58513.0 |
| 465 | 2025-05-12 16:02:12 | interstate | 1 | 67641 | 4 | 3.576 | 18915.3 |
| 464 | 2025-05-06 00:27:56 | interstate | 1 | 67641 | 4 | 3.296 | 20522.1 |
| 463 | 2025-04-25 03:57:46 | interstate | 1 | 67641 | 4 | 2.516 | 26884.3 |
| 462 | 2025-04-11 16:18:57 | interstate | 1 | 67641 | 4 | 5.733 | 11798.5 |
| 461 | 2025-04-10 21:51:09 | interstate | 1 | 67641 | 4 | 5.736 | 11792.4 |
| 460 | 2025-03-29 02:03:26 | interstate | 1 | 67641 | 4 | 4.903 | 13795.8 |
| 459 | 2025-03-23 14:34:00 | interstate | 4 | 161450 | 292 | 64.800 | 2491.5 |
| 458 | 2025-03-23 13:39:32 | interstate | 3 | 140603 | 56 | 28.906 | 4864.1 |
| 457 | 2025-03-23 01:25:41 | interstate | 1 | 67641 | 4 | 5.626 | 12022.9 |
| 456 | 2025-03-22 04:56:26 | interstate | 1 | 67641 | 4 | 3.046 | 22206.5 |
| 455 | 2025-03-13 01:46:24 | interstate | 3 | 140603 | 56 | 36.140 | 3890.5 |
| 454 | 2025-03-11 22:36:14 | interstate | 4 | 161450 | 292 | 64.566 | 2500.5 |
| 453 | 2025-03-11 16:20:40 | interstate | 4 | 161450 | 292 | 45.376 | 3558.0 |
| 452 | 2025-03-11 16:20:33 | interstate | 2 | 108824 | 9 | 22.986 | 4734.4 |
| 451 | 2025-03-11 16:10:56 | interstate | 1 | 67641 | 4 | 3.406 | 19859.4 |
| 450 | 2025-03-11 13:18:16 | interstate | 3 | 140603 | 56 | 28.080 | 5007.2 |
| 449 | 2025-03-07 19:46:43 | interstate | 3 | 140603 | 56 | 33.253 | 4228.3 |
| 448 | 2025-03-07 06:32:42 | interstate | 3 | 140603 | 56 | 32.296 | 4353.6 |
| 447 | 2025-03-07 00:07:11 | interstate | 1 | 67641 | 4 | 4.156 | 16275.5 |
| 446 | 2025-03-02 10:25:26 | interstate | 1 | 67641 | 4 | 3.513 | 19254.5 |
| 445 | 2025-02-26 20:11:28 | interstate | 3 | 140603 | 56 | 38.520 | 3650.1 |
| 444 | 2025-02-26 20:11:27 | interstate | 3 | 140603 | 56 | 38.126 | 3687.9 |
| 443 | 2025-02-26 15:20:39 | interstate | 4 | 161450 | 292 | 60.220 | 2681.0 |
| 442 | 2025-02-26 15:20:38 | interstate | 3 | 140603 | 56 | 38.500 | 3652.0 |
| 441 | 2025-02-26 11:00:10 | interstate | 1 | 67641 | 4 | 1.140 | 59334.2 |
| 440 | 2025-02-19 23:49:20 | interstate | 1 | 67641 | 4 | 5.313 | 12731.2 |
| 439 | 2025-02-13 22:04:48 | interstate | 2 | 108824 | 9 | 7.606 | 14307.7 |
| 438 | 2025-02-09 15:04:59 | interstate | 2 | 108824 | 9 | 11.000 | 9893.1 |
| 437 | 2025-02-07 15:41:14 | interstate | 2 | 108824 | 9 | 7.830 | 13898.3 |
| 436 | 2025-02-04 04:29:45 | interstate | 4 | 161450 | 292 | 66.940 | 2411.9 |
| 435 | 2025-02-03 07:16:08 | interstate | 4 | 161450 | 292 | 60.566 | 2665.7 |
| 434 | 2025-02-03 07:16:11 | interstate | 2 | 108824 | 9 | 13.190 | 8250.5 |
| 433 | 2025-02-03 07:15:00 | interstate | 1 | 67641 | 4 | 2.830 | 23901.4 |
| 432 | 2025-01-31 08:14:33 | interstate | 3 | 140603 | 56 | 29.503 | 4765.7 |
| 431 | 2025-01-31 06:31:35 | interstate | 3 | 140603 | 56 | 55.206 | 2546.9 |
| 430 | 2025-01-30 06:55:38 | interstate | 3 | 140603 | 56 | 41.140 | 3417.7 |
| 429 | 2025-01-30 06:55:17 | interstate | 1 | 67641 | 4 | 3.296 | 20522.1 |
| 428 | 2025-01-26 08:28:55 | interstate | 3 | 140603 | 56 | 44.113 | 3187.3 |
| 427 | 2025-01-25 21:36:26 | interstate | 1 | 67641 | 4 | 1.016 | 66575.8 |
| 426 | 2025-01-16 18:18:38 | interstate | 1 | 67641 | 4 | 4.596 | 14717.4 |
| 425 | 2025-01-03 18:08:57 | interstate | 3 | 140603 | 56 | 41.910 | 3354.9 |
| 424 | 2025-01-03 17:45:45 | interstate | 2 | 108824 | 9 | 11.470 | 9487.7 |
| 423 | 2025-01-03 12:48:33 | interstate | 1 | 67641 | 4 | 3.923 | 17242.2 |
| 422 | 2025-01-01 17:44:02 | interstate | 2 | 108824 | 9 | 15.923 | 6834.4 |
| 421 | 2024-12-31 10:39:48 | interstate | 3 | 140603 | 56 | 34.126 | 4120.1 |
| 420 | 2024-12-31 06:47:01 | interstate | 3 | 140603 | 56 | 44.600 | 3152.5 |
| 419 | 2024-12-31 06:39:35 | interstate | 3 | 140603 | 56 | 31.500 | 4463.6 |
| 418 | 2024-12-31 06:39:21 | interstate | 3 | 140603 | 56 | 41.890 | 3356.5 |
| 417 | 2024-12-31 06:39:25 | interstate | 2 | 108824 | 9 | 23.000 | 4731.5 |
| 416 | 2024-12-31 06:35:33 | interstate | 1 | 67641 | 4 | 5.390 | 12549.4 |
| 415 | 2024-12-26 15:51:40 | interstate | 1 | 67641 | 4 | 1.126 | 60071.9 |
| 414 | 2024-12-12 04:59:20 | interstate | 1 | 67641 | 4 | 5.640 | 11993.1 |
| 413 | 2024-12-04 05:13:01 | interstate | 1 | 67641 | 4 | 8.220 | 8228.8 |
| 412 | 2024-11-27 05:02:28 | interstate | 3 | 140603 | 56 | 32.470 | 4330.2 |
| 411 | 2024-11-27 05:02:29 | interstate | 2 | 108824 | 9 | 15.533 | 7006.0 |
| 410 | 2024-11-26 07:56:33 | interstate | 1 | 67641 | 4 | 1.186 | 57032.9 |
| 409 | 2024-11-25 02:35:16 | interstate | 3 | 140603 | 56 | 43.643 | 3221.7 |
| 408 | 2024-11-23 20:38:09 | interstate | 3 | 140603 | 56 | 48.126 | 2921.6 |
| 407 | 2024-11-22 04:13:27 | interstate | 3 | 140603 | 56 | 40.736 | 3451.6 |
| 406 | 2024-11-21 06:52:36 | interstate | 3 | 140603 | 56 | 44.220 | 3179.6 |
| 405 | 2024-11-21 06:52:32 | interstate | 3 | 140603 | 56 | 30.456 | 4616.6 |
| 404 | 2024-11-21 06:52:42 | interstate | 2 | 108824 | 9 | 15.160 | 7178.4 |
| 403 | 2024-11-05 01:35:07 | interstate | 1 | 67641 | 4 | 5.186 | 13043.0 |
| 402 | 2024-11-03 16:44:07 | interstate | 2 | 108824 | 9 | 14.970 | 7269.5 |
| 401 | 2024-11-03 16:40:51 | interstate | 1 | 67641 | 4 | 1.313 | 51516.4 |
| 400 | 2024-11-02 12:30:58 | interstate | 1 | 67641 | 4 | 2.470 | 27385.0 |
| 399 | 2024-10-26 04:17:36 | interstate | 1 | 67641 | 4 | 8.356 | 8094.9 |
| 398 | 2024-10-26 04:12:50 | interstate | 1 | 67641 | 4 | 6.546 | 10333.2 |
| 397 | 2024-10-21 22:11:37 | interstate | 3 | 140603 | 56 | 30.390 | 4626.6 |
| 396 | 2024-10-21 12:57:37 | interstate | 2 | 108824 | 9 | 7.533 | 14446.3 |
| 395 | 2024-10-18 13:10:31 | interstate | 3 | 140603 | 56 | 32.300 | 4353.0 |
| 394 | 2024-10-18 02:41:09 | interstate | 3 | 140603 | 56 | 34.116 | 4121.3 |
| 393 | 2024-10-17 04:47:14 | interstate | 3 | 140603 | 56 | 20.720 | 6785.9 |
| 392 | 2024-10-16 18:30:02 | interstate | 3 | 140603 | 56 | 33.190 | 4236.3 |
| 391 | 2024-10-16 18:29:56 | interstate | 2 | 108824 | 9 | 7.576 | 14364.3 |
| 390 | 2024-10-15 02:04:36 | interstate | 1 | 67641 | 4 | 5.500 | 12298.4 |
| 389 | 2024-10-12 17:00:29 | interstate | 1 | 67641 | 4 | 2.050 | 32995.6 |
| 388 | 2024-10-11 08:54:24 | interstate | 4 | 161450 | 292 | 57.206 | 2822.3 |
| 387 | 2024-10-09 02:16:19 | interstate | 4 | 161450 | 292 | 54.003 | 2989.6 |
| 386 | 2024-10-08 02:58:54 | interstate | 4 | 161450 | 292 | 76.063 | 2122.6 |