History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"streetlamps"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 563 | 2025-11-19 16:43:43 | streetlamps | 6 | 173545 | 980 | 21.453 | 8089.5 |
| 562 | 2025-11-02 16:13:14 | streetlamps | 6 | 173545 | 980 | 22.453 | 7729.3 |
| 561 | 2025-11-01 10:22:54 | streetlamps | 6 | 173545 | 980 | 22.750 | 7628.4 |
| 560 | 2025-10-31 22:53:34 | streetlamps | 6 | 173545 | 980 | 22.923 | 7570.8 |
| 559 | 2025-10-31 14:57:05 | streetlamps | 1 | 49908 | 2 | 0.940 | 53093.6 |
| 558 | 2025-10-31 14:55:38 | streetlamps | 1 | 49908 | 2 | 0.766 | 65154.0 |
| 557 | 2025-10-31 11:37:17 | streetlamps | 4 | 148819 | 17 | 11.066 | 13448.3 |
| 556 | 2025-10-31 11:02:46 | streetlamps | 6 | 173545 | 980 | 24.613 | 7050.9 |
| 555 | 2025-10-30 21:22:04 | streetlamps | 4 | 148819 | 17 | 9.203 | 16170.7 |
| 554 | 2025-10-30 08:14:15 | streetlamps | 1 | 49908 | 2 | 3.873 | 12886.1 |
| 553 | 2025-10-30 08:13:08 | streetlamps | 1 | 49908 | 2 | 4.156 | 12008.7 |
| 552 | 2025-10-30 08:12:10 | streetlamps | 1 | 49908 | 2 | 3.906 | 12777.3 |
| 551 | 2025-10-30 08:11:14 | streetlamps | 1 | 49908 | 2 | 5.623 | 8875.7 |
| 550 | 2025-10-30 07:43:14 | streetlamps | 1 | 49908 | 2 | 0.763 | 65410.2 |
| 549 | 2025-10-30 04:42:14 | streetlamps | 1 | 49908 | 2 | 0.843 | 59202.8 |
| 548 | 2025-10-29 17:06:22 | streetlamps | 4 | 148819 | 17 | 9.703 | 15337.4 |
| 547 | 2025-10-21 12:56:14 | streetlamps | 1 | 49908 | 2 | 2.640 | 18904.5 |
| 546 | 2025-10-21 12:55:59 | streetlamps | 1 | 49908 | 2 | 5.796 | 8610.8 |
| 545 | 2025-10-21 12:55:44 | streetlamps | 1 | 49908 | 2 | 4.093 | 12193.5 |
| 544 | 2025-10-21 12:55:32 | streetlamps | 1 | 49908 | 2 | 5.423 | 9203.0 |
| 543 | 2025-10-02 02:34:47 | streetlamps | 3 | 121633 | 3 | 5.296 | 22967.0 |
| 542 | 2025-10-01 19:06:39 | streetlamps | 5 | 164607 | 97 | 17.796 | 9249.7 |
| 541 | 2025-10-01 11:43:12 | streetlamps | 4 | 148819 | 17 | 9.093 | 16366.3 |
| 540 | 2025-09-10 12:03:11 | streetlamps | 1 | 49908 | 2 | 0.873 | 57168.4 |
| 539 | 2025-08-10 16:01:02 | streetlamps | 3 | 121633 | 3 | 21.676 | 5611.4 |
| 538 | 2025-08-10 15:18:30 | streetlamps | 2 | 86808 | 2 | 6.076 | 14287.0 |
| 537 | 2025-08-10 08:51:49 | streetlamps | 4 | 148819 | 17 | 23.093 | 6444.3 |
| 536 | 2025-08-08 23:00:30 | streetlamps | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 535 | 2025-07-25 05:32:12 | streetlamps | 1 | 49908 | 2 | 2.656 | 18790.7 |
| 534 | 2025-07-24 07:10:16 | streetlamps | 1 | 49908 | 2 | 5.686 | 8777.3 |
| 533 | 2025-07-19 05:06:23 | streetlamps | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 532 | 2025-06-14 08:02:37 | streetlamps | 1 | 49908 | 2 | 6.063 | 8231.6 |
| 531 | 2025-06-01 02:20:02 | streetlamps | 2 | 86808 | 2 | 11.673 | 7436.6 |
| 530 | 2025-05-29 06:08:50 | streetlamps | 1 | 49908 | 2 | 3.220 | 15499.4 |
| 529 | 2025-05-28 04:36:53 | streetlamps | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 528 | 2025-05-06 06:56:09 | streetlamps | 1 | 49908 | 2 | 1.843 | 27079.8 |
| 527 | 2025-03-25 18:20:15 | streetlamps | 3 | 121633 | 3 | 23.906 | 5088.0 |
| 526 | 2025-03-21 08:23:12 | streetlamps | 1 | 49908 | 2 | 3.576 | 13956.4 |
| 525 | 2025-03-14 18:42:37 | streetlamps | 1 | 49908 | 2 | 3.436 | 14525.0 |
| 524 | 2025-03-13 18:47:09 | streetlamps | 1 | 49908 | 2 | 4.453 | 11207.7 |
| 523 | 2025-02-27 02:38:32 | streetlamps | 4 | 148819 | 17 | 38.406 | 3874.9 |
| 522 | 2025-02-27 02:38:31 | streetlamps | 3 | 121633 | 3 | 27.703 | 4390.6 |
| 521 | 2025-02-27 02:38:27 | streetlamps | 2 | 86808 | 2 | 12.456 | 6969.2 |
| 520 | 2025-02-27 02:37:47 | streetlamps | 1 | 49908 | 2 | 5.563 | 8971.4 |
| 519 | 2025-02-24 11:28:24 | streetlamps | 4 | 148819 | 17 | 52.626 | 2827.9 |
| 518 | 2025-02-23 11:51:08 | streetlamps | 1 | 49908 | 2 | 4.013 | 12436.6 |
| 517 | 2025-02-23 04:48:24 | streetlamps | 4 | 148819 | 17 | 41.143 | 3617.1 |
| 516 | 2025-02-19 00:41:35 | streetlamps | 4 | 148819 | 17 | 49.253 | 3021.5 |
| 515 | 2025-02-19 00:41:27 | streetlamps | 4 | 148819 | 17 | 50.563 | 2943.2 |
| 514 | 2025-02-19 00:41:25 | streetlamps | 3 | 121633 | 3 | 26.486 | 4592.4 |
| 513 | 2025-02-19 00:41:14 | streetlamps | 2 | 86808 | 2 | 11.610 | 7477.0 |
| 512 | 2025-02-19 00:39:12 | streetlamps | 1 | 49908 | 2 | 2.800 | 17824.3 |
| 511 | 2025-02-14 23:54:51 | streetlamps | 1 | 49908 | 2 | 4.126 | 12096.0 |
| 510 | 2025-02-14 06:01:39 | streetlamps | 4 | 148819 | 17 | 49.943 | 2979.8 |
| 509 | 2025-01-27 08:24:59 | streetlamps | 3 | 121633 | 3 | 27.000 | 4504.9 |
| 507 | 2025-01-27 08:25:00 | streetlamps | 3 | 121633 | 3 | 25.906 | 4695.2 |
| 506 | 2025-01-27 08:24:59 | streetlamps | 2 | 86808 | 2 | 13.143 | 6604.9 |
| 505 | 2025-01-27 08:23:06 | streetlamps | 1 | 49908 | 2 | 2.220 | 22481.1 |
| 504 | 2025-01-16 14:38:01 | streetlamps | 3 | 121633 | 3 | 34.050 | 3572.2 |
| 503 | 2025-01-16 14:38:05 | streetlamps | 2 | 86808 | 2 | 12.813 | 6775.0 |
| 502 | 2025-01-16 14:36:27 | streetlamps | 4 | 148819 | 17 | 53.236 | 2795.5 |
| 501 | 2025-01-16 14:35:04 | streetlamps | 1 | 49908 | 2 | 5.456 | 9147.4 |
| 500 | 2025-01-16 05:50:39 | streetlamps | 4 | 148819 | 17 | 67.040 | 2219.9 |
| 499 | 2025-01-14 21:44:54 | streetlamps | 2 | 86808 | 2 | 14.376 | 6038.4 |
| 498 | 2025-01-14 21:42:03 | streetlamps | 1 | 49908 | 2 | 3.173 | 15729.0 |
| 497 | 2025-01-14 12:20:52 | streetlamps | 1 | 49908 | 2 | 4.156 | 12008.7 |
| 496 | 2025-01-11 04:00:29 | streetlamps | 4 | 148819 | 17 | 48.453 | 3071.4 |
| 495 | 2025-01-11 04:00:25 | streetlamps | 3 | 121633 | 3 | 18.860 | 6449.3 |
| 494 | 2025-01-09 09:36:44 | streetlamps | 4 | 148819 | 17 | 46.440 | 3204.5 |
| 493 | 2025-01-08 06:06:09 | streetlamps | 3 | 121633 | 3 | 27.736 | 4385.4 |
| 492 | 2024-12-25 01:11:58 | streetlamps | 3 | 121633 | 3 | 26.296 | 4625.5 |
| 491 | 2024-12-25 01:12:03 | streetlamps | 2 | 86808 | 2 | 12.190 | 7121.2 |
| 490 | 2024-12-25 01:09:13 | streetlamps | 1 | 49908 | 2 | 0.906 | 55086.1 |
| 489 | 2024-12-16 00:29:38 | streetlamps | 4 | 148819 | 17 | 63.020 | 2361.5 |
| 488 | 2024-12-13 00:31:55 | streetlamps | 4 | 148819 | 17 | 56.596 | 2629.5 |
| 487 | 2024-12-04 05:49:11 | streetlamps | 4 | 148819 | 17 | 47.940 | 3104.3 |
| 486 | 2024-12-01 21:46:20 | streetlamps | 3 | 121633 | 3 | 23.283 | 5224.1 |
| 485 | 2024-12-01 21:46:05 | streetlamps | 2 | 86808 | 2 | 11.750 | 7387.9 |
| 484 | 2024-12-01 21:45:34 | streetlamps | 3 | 121633 | 3 | 18.956 | 6416.6 |
| 483 | 2024-12-01 21:43:35 | streetlamps | 1 | 49908 | 2 | 1.936 | 25778.9 |
| 482 | 2024-12-01 21:16:02 | streetlamps | 1 | 49908 | 2 | 5.516 | 9047.9 |
| 481 | 2024-11-30 14:18:03 | streetlamps | 3 | 121633 | 3 | 33.220 | 3661.4 |
| 480 | 2024-11-19 06:21:38 | streetlamps | 3 | 121633 | 3 | 44.990 | 2703.6 |
| 479 | 2024-11-19 06:21:39 | streetlamps | 2 | 86808 | 2 | 21.783 | 3985.1 |
| 478 | 2024-11-19 06:07:13 | streetlamps | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 477 | 2024-11-07 15:58:26 | streetlamps | 3 | 121633 | 3 | 21.410 | 5681.1 |
| 476 | 2024-11-01 12:44:55 | streetlamps | 3 | 121633 | 3 | 39.940 | 3045.4 |
| 475 | 2024-11-01 12:44:55 | streetlamps | 2 | 86808 | 2 | 12.030 | 7216.0 |
| 474 | 2024-11-01 12:44:03 | streetlamps | 4 | 148819 | 17 | 49.736 | 2992.2 |
| 473 | 2024-11-01 12:43:42 | streetlamps | 1 | 49908 | 2 | 2.216 | 22521.7 |
| 472 | 2024-10-31 23:16:24 | streetlamps | 4 | 148819 | 17 | 33.533 | 4438.0 |
| 471 | 2024-10-31 22:36:55 | streetlamps | 4 | 148819 | 17 | 39.906 | 3729.2 |
| 470 | 2024-10-31 22:36:58 | streetlamps | 3 | 121633 | 3 | 27.423 | 4435.4 |
| 469 | 2024-10-31 22:36:57 | streetlamps | 2 | 86808 | 2 | 13.250 | 6551.5 |
| 468 | 2024-10-31 22:35:06 | streetlamps | 1 | 49908 | 2 | 4.123 | 12104.8 |
| 467 | 2024-10-29 01:53:59 | streetlamps | 4 | 148819 | 17 | 63.626 | 2339.0 |
| 466 | 2024-10-26 04:27:08 | streetlamps | 4 | 148819 | 17 | 40.313 | 3691.6 |
| 465 | 2024-10-24 05:57:46 | streetlamps | 1 | 49908 | 2 | 2.393 | 20855.8 |
| 464 | 2024-10-19 01:19:32 | streetlamps | 3 | 121633 | 3 | 27.796 | 4375.9 |