History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lighthouse"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 396 | 2026-02-19 16:54:32 | lighthouse | 1 | 67641 | 2 | 5.063 | 13359.9 |
| 395 | 2026-02-17 10:03:31 | lighthouse | 1 | 67641 | 2 | 1.126 | 60071.9 |
| 394 | 2026-02-16 03:30:01 | lighthouse | 1 | 67641 | 2 | 1.500 | 45094.0 |
| 393 | 2026-02-15 05:21:30 | lighthouse | 4 | 161450 | 68 | 27.016 | 5976.1 |
| 392 | 2026-02-14 20:03:07 | lighthouse | 1 | 67641 | 2 | 1.126 | 60071.9 |
| 391 | 2026-02-14 16:08:34 | lighthouse | 1 | 67641 | 2 | 5.703 | 11860.6 |
| 390 | 2026-02-12 22:43:43 | lighthouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
| 389 | 2026-02-12 05:38:27 | lighthouse | 1 | 67641 | 2 | 2.500 | 27056.4 |
| 388 | 2026-02-08 22:29:12 | lighthouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
| 387 | 2026-02-08 18:20:38 | lighthouse | 1 | 67641 | 2 | 1.016 | 66575.8 |
| 386 | 2026-02-08 06:59:10 | lighthouse | 2 | 108824 | 2 | 3.000 | 36274.7 |
| 385 | 2026-02-06 19:57:43 | lighthouse | 2 | 108824 | 2 | 2.796 | 38921.3 |
| 384 | 2026-02-06 14:30:30 | lighthouse | 5 | 173545 | 369 | 20.440 | 8490.5 |
| 383 | 2026-02-06 13:07:45 | lighthouse | 2 | 108824 | 2 | 2.580 | 42179.8 |
| 382 | 2026-02-06 12:38:17 | lighthouse | 1 | 67641 | 2 | 1.266 | 53428.9 |
| 381 | 2026-02-05 19:37:43 | lighthouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
| 380 | 2026-02-05 00:40:01 | lighthouse | 2 | 108824 | 2 | 2.623 | 41488.4 |
| 379 | 2026-02-03 19:37:03 | lighthouse | 2 | 108824 | 2 | 11.080 | 9821.7 |
| 378 | 2026-01-30 19:11:10 | lighthouse | 2 | 108824 | 2 | 2.796 | 38921.3 |
| 377 | 2026-01-25 07:50:37 | lighthouse | 3 | 140603 | 5 | 8.326 | 16887.2 |
| 376 | 2026-01-21 18:15:51 | lighthouse | 1 | 67641 | 2 | 1.470 | 46014.3 |
| 375 | 2026-01-19 23:54:20 | lighthouse | 4 | 161450 | 68 | 10.610 | 15216.8 |
| 374 | 2026-01-18 08:38:32 | lighthouse | 1 | 67641 | 2 | 1.170 | 57812.8 |
| 373 | 2026-01-14 18:48:13 | lighthouse | 3 | 140603 | 5 | 25.360 | 5544.3 |
| 372 | 2026-01-13 15:04:09 | lighthouse | 3 | 140603 | 5 | 31.473 | 4467.4 |
| 371 | 2026-01-11 06:35:15 | lighthouse | 1 | 67641 | 2 | 1.280 | 52844.5 |
| 370 | 2025-12-30 08:23:52 | lighthouse | 1 | 67641 | 2 | 1.143 | 59178.5 |
| 369 | 2025-12-30 08:22:45 | lighthouse | 1 | 67641 | 2 | 1.173 | 57665.0 |
| 368 | 2025-12-28 21:49:28 | lighthouse | 1 | 67641 | 2 | 1.123 | 60232.4 |
| 367 | 2025-12-28 19:28:30 | lighthouse | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 366 | 2025-12-24 01:58:58 | lighthouse | 1 | 67641 | 2 | 2.250 | 30062.7 |
| 365 | 2025-12-18 21:22:52 | lighthouse | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 364 | 2025-12-11 22:38:05 | lighthouse | 4 | 161450 | 68 | 47.706 | 3384.3 |
| 363 | 2025-11-27 04:16:15 | lighthouse | 4 | 161450 | 68 | 12.063 | 13383.9 |
| 362 | 2025-11-06 14:56:00 | lighthouse | 4 | 161450 | 68 | 10.923 | 14780.7 |
| 361 | 2025-11-04 22:24:04 | lighthouse | 3 | 140603 | 5 | 5.860 | 23993.7 |
| 360 | 2025-11-03 03:24:49 | lighthouse | 1 | 67641 | 2 | 1.126 | 60071.9 |
| 359 | 2025-10-21 04:57:08 | lighthouse | 1 | 67641 | 2 | 4.126 | 16393.8 |
| 358 | 2025-10-21 04:48:36 | lighthouse | 1 | 67641 | 2 | 2.970 | 22774.7 |
| 357 | 2025-09-26 20:40:42 | lighthouse | 1 | 67641 | 2 | 1.106 | 61158.2 |
| 356 | 2025-09-11 10:00:09 | lighthouse | 2 | 108824 | 2 | 3.080 | 35332.5 |
| 355 | 2025-09-10 09:38:15 | lighthouse | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 354 | 2025-08-28 18:34:11 | lighthouse | 1 | 67641 | 2 | 1.220 | 55443.4 |
| 353 | 2025-08-27 22:28:52 | lighthouse | 1 | 67641 | 2 | 1.656 | 40846.0 |
| 352 | 2025-08-27 12:46:37 | lighthouse | 1 | 67641 | 2 | 4.576 | 14781.7 |
| 351 | 2025-08-17 14:57:32 | lighthouse | 1 | 67641 | 2 | 2.326 | 29080.4 |
| 350 | 2025-08-04 07:23:21 | lighthouse | 1 | 67641 | 2 | 2.453 | 27574.8 |
| 349 | 2025-07-24 13:21:40 | lighthouse | 1 | 67641 | 2 | 2.483 | 27241.6 |
| 348 | 2025-07-16 14:05:10 | lighthouse | 1 | 67641 | 2 | 2.233 | 30291.5 |
| 347 | 2025-07-13 10:51:48 | lighthouse | 1 | 67641 | 2 | 1.593 | 42461.4 |
| 346 | 2025-07-10 20:11:10 | lighthouse | 1 | 67641 | 2 | 3.656 | 18501.4 |
| 345 | 2025-06-18 13:42:26 | lighthouse | 1 | 67641 | 2 | 2.593 | 26086.0 |
| 344 | 2025-06-09 22:49:22 | lighthouse | 1 | 67641 | 2 | 5.626 | 12022.9 |
| 343 | 2025-05-30 12:17:02 | lighthouse | 2 | 108824 | 2 | 8.750 | 12437.0 |
| 342 | 2025-05-29 13:14:13 | lighthouse | 4 | 161450 | 68 | 52.206 | 3092.6 |
| 341 | 2025-05-28 00:17:50 | lighthouse | 1 | 67641 | 2 | 1.143 | 59178.5 |
| 340 | 2025-05-12 09:43:17 | lighthouse | 3 | 140603 | 5 | 18.893 | 7442.1 |
| 339 | 2025-05-12 01:56:37 | lighthouse | 2 | 108824 | 2 | 10.360 | 10504.2 |
| 338 | 2025-05-11 11:14:56 | lighthouse | 1 | 67641 | 2 | 1.906 | 35488.5 |
| 337 | 2025-05-10 04:57:51 | lighthouse | 1 | 67641 | 2 | 3.093 | 21869.1 |
| 336 | 2025-05-05 23:34:43 | lighthouse | 4 | 161450 | 68 | 66.160 | 2440.3 |
| 335 | 2025-04-22 21:27:47 | lighthouse | 4 | 161450 | 68 | 29.813 | 5415.4 |
| 334 | 2025-04-22 21:10:46 | lighthouse | 1 | 67641 | 2 | 3.343 | 20233.6 |
| 333 | 2025-04-17 22:45:22 | lighthouse | 1 | 67641 | 2 | 2.983 | 22675.5 |
| 332 | 2025-04-09 16:41:48 | lighthouse | 4 | 161450 | 68 | 36.503 | 4422.9 |
| 331 | 2025-04-09 12:16:05 | lighthouse | 2 | 108824 | 2 | 19.186 | 5672.1 |
| 330 | 2025-04-08 16:43:45 | lighthouse | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 329 | 2025-04-07 08:26:51 | lighthouse | 4 | 161450 | 68 | 51.566 | 3130.9 |
| 328 | 2025-04-03 23:31:10 | lighthouse | 4 | 161450 | 68 | 46.440 | 3476.5 |
| 327 | 2025-04-02 13:23:10 | lighthouse | 4 | 161450 | 68 | 53.003 | 3046.1 |
| 326 | 2025-04-02 01:53:28 | lighthouse | 2 | 108824 | 2 | 12.376 | 8793.1 |
| 325 | 2025-04-01 09:58:27 | lighthouse | 3 | 140603 | 5 | 6.423 | 21890.5 |
| 324 | 2025-03-18 10:16:38 | lighthouse | 1 | 67641 | 2 | 3.360 | 20131.3 |
| 323 | 2025-03-10 02:44:13 | lighthouse | 1 | 67641 | 2 | 5.783 | 11696.5 |
| 322 | 2025-03-02 12:42:02 | lighthouse | 3 | 140603 | 5 | 20.783 | 6765.3 |
| 321 | 2025-03-02 12:41:33 | lighthouse | 2 | 108824 | 2 | 12.923 | 8421.0 |
| 320 | 2025-03-02 12:40:12 | lighthouse | 1 | 67641 | 2 | 5.110 | 13237.0 |
| 319 | 2025-02-21 17:21:07 | lighthouse | 3 | 140603 | 5 | 33.893 | 4148.4 |
| 318 | 2025-02-21 17:20:46 | lighthouse | 3 | 140603 | 5 | 27.330 | 5144.6 |
| 317 | 2025-02-21 17:20:41 | lighthouse | 3 | 140603 | 5 | 26.410 | 5323.9 |
| 316 | 2025-02-21 17:20:52 | lighthouse | 2 | 108824 | 2 | 15.126 | 7194.5 |
| 315 | 2025-02-21 17:18:05 | lighthouse | 1 | 67641 | 2 | 2.143 | 31563.7 |
| 314 | 2025-02-01 04:48:12 | lighthouse | 1 | 67641 | 2 | 5.593 | 12093.9 |
| 313 | 2025-01-24 09:38:25 | lighthouse | 3 | 140603 | 5 | 31.920 | 4404.9 |
| 312 | 2025-01-20 20:57:55 | lighthouse | 2 | 108824 | 2 | 14.530 | 7489.6 |
| 311 | 2025-01-20 20:57:38 | lighthouse | 3 | 140603 | 5 | 30.973 | 4539.5 |
| 310 | 2025-01-20 20:57:38 | lighthouse | 3 | 140603 | 5 | 27.770 | 5063.1 |
| 309 | 2025-01-20 20:54:16 | lighthouse | 1 | 67641 | 2 | 2.546 | 26567.6 |
| 308 | 2025-01-20 20:35:59 | lighthouse | 3 | 140603 | 5 | 30.893 | 4551.3 |
| 307 | 2025-01-20 20:36:07 | lighthouse | 2 | 108824 | 2 | 18.206 | 5977.4 |
| 306 | 2025-01-20 20:35:43 | lighthouse | 3 | 140603 | 5 | 28.280 | 4971.8 |
| 305 | 2025-01-20 20:35:41 | lighthouse | 3 | 140603 | 5 | 23.050 | 6099.9 |
| 304 | 2025-01-20 20:34:45 | lighthouse | 1 | 67641 | 2 | 5.156 | 13118.9 |
| 303 | 2025-01-08 08:30:55 | lighthouse | 2 | 108824 | 2 | 14.890 | 7308.5 |
| 302 | 2025-01-08 08:30:41 | lighthouse | 1 | 67641 | 2 | 5.263 | 12852.2 |
| 301 | 2025-01-08 08:28:56 | lighthouse | 3 | 140603 | 5 | 31.610 | 4448.1 |
| 300 | 2025-01-08 02:38:03 | lighthouse | 3 | 140603 | 5 | 40.763 | 3449.3 |
| 299 | 2024-12-31 01:54:07 | lighthouse | 3 | 140603 | 5 | 35.613 | 3948.1 |
| 298 | 2024-12-18 07:53:34 | lighthouse | 3 | 140603 | 5 | 31.096 | 4521.6 |
| 297 | 2024-12-18 07:53:27 | lighthouse | 2 | 108824 | 2 | 14.126 | 7703.8 |