History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sconce"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 466 | 2024-04-05 17:35:53 | sconce | 1 | 48755 | 4 | 3.406 | 14314.4 |
| 465 | 2024-03-30 06:32:37 | sconce | 1 | 48755 | 4 | 0.970 | 50262.9 |
| 464 | 2024-03-28 15:53:00 | sconce | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 463 | 2024-03-06 23:09:27 | sconce | 1 | 48755 | 4 | 0.953 | 51159.5 |
| 462 | 2024-02-21 01:58:33 | sconce | 1 | 48755 | 4 | 1.953 | 24964.2 |
| 461 | 2024-02-04 13:59:17 | sconce | 1 | 48755 | 4 | 0.953 | 51159.5 |
| 460 | 2024-02-04 13:58:22 | sconce | 1 | 48755 | 4 | 2.106 | 23150.5 |
| 459 | 2024-01-30 05:41:46 | sconce | 2 | 82551 | 32 | 3.610 | 22867.3 |
| 458 | 2024-01-30 05:35:38 | sconce | 3 | 112716 | 465 | 4.890 | 23050.3 |
| 457 | 2024-01-29 13:19:25 | sconce | 2 | 82551 | 32 | 2.533 | 32590.2 |
| 456 | 2024-01-29 13:19:21 | sconce | 3 | 112716 | 465 | 5.423 | 20784.8 |
| 455 | 2024-01-29 13:19:17 | sconce | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 454 | 2024-01-15 05:40:05 | sconce | 3 | 112716 | 465 | 5.050 | 22320.0 |
| 453 | 2024-01-14 12:30:45 | sconce | 2 | 82551 | 32 | 2.530 | 32628.9 |
| 452 | 2024-01-08 17:38:02 | sconce | 3 | 112716 | 465 | 4.873 | 23130.7 |
| 451 | 2024-01-08 17:38:01 | sconce | 2 | 82551 | 32 | 2.373 | 34787.6 |
| 450 | 2023-12-31 10:07:04 | sconce | 3 | 112716 | 465 | 5.876 | 19182.4 |
| 449 | 2023-12-08 14:48:13 | sconce | 3 | 112716 | 465 | 5.796 | 19447.2 |
| 448 | 2023-12-08 14:48:10 | sconce | 2 | 82551 | 32 | 2.686 | 30733.8 |
| 447 | 2023-11-28 06:03:28 | sconce | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 446 | 2023-11-16 03:01:11 | sconce | 3 | 112716 | 465 | 5.516 | 20434.4 |
| 445 | 2023-11-16 03:01:14 | sconce | 2 | 82551 | 32 | 2.500 | 33020.4 |
| 444 | 2023-11-15 04:15:29 | sconce | 1 | 48755 | 4 | 0.856 | 56956.8 |
| 443 | 2023-11-13 03:13:49 | sconce | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 442 | 2023-11-11 06:15:17 | sconce | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 441 | 2023-10-21 11:03:05 | sconce | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 440 | 2023-10-18 16:12:16 | sconce | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 439 | 2023-10-14 20:46:35 | sconce | 1 | 48755 | 4 | 0.856 | 56956.8 |
| 438 | 2023-10-12 09:52:13 | sconce | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 437 | 2023-10-04 05:02:07 | sconce | 3 | 112716 | 465 | 4.643 | 24276.5 |
| 436 | 2023-09-29 05:20:48 | sconce | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 435 | 2023-09-23 06:53:14 | sconce | 1 | 48755 | 4 | 1.516 | 32160.3 |
| 434 | 2023-09-12 21:37:16 | sconce | 1 | 48755 | 4 | 0.966 | 50471.0 |
| 433 | 2023-07-15 09:12:46 | sconce | 3 | 112716 | 465 | 5.326 | 21163.3 |
| 432 | 2023-07-12 07:00:37 | sconce | 3 | 112716 | 465 | 10.640 | 10593.6 |
| 431 | 2023-06-27 23:18:50 | sconce | 3 | 112716 | 465 | 5.283 | 21335.6 |
| 430 | 2023-06-24 15:08:37 | sconce | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 429 | 2023-06-15 10:53:31 | sconce | 1 | 48755 | 4 | 0.923 | 52822.3 |
| 428 | 2023-04-26 11:03:22 | sconce | 3 | 112716 | 465 | 4.626 | 24365.8 |
| 427 | 2023-04-06 01:58:33 | sconce | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 426 | 2023-03-30 05:38:11 | sconce | 3 | 112716 | 465 | 5.266 | 21404.5 |
| 425 | 2023-03-27 10:26:09 | sconce | 3 | 112716 | 465 | 5.890 | 19136.8 |
| 424 | 2023-02-17 08:09:53 | sconce | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 423 | 2023-02-05 19:01:06 | sconce | 3 | 112716 | 465 | 5.280 | 21347.7 |
| 422 | 2023-01-21 10:58:32 | sconce | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 421 | 2023-01-07 22:32:10 | sconce | 3 | 112716 | 465 | 5.563 | 20261.7 |
| 420 | 2022-12-27 12:14:47 | sconce | 3 | 112716 | 465 | 5.516 | 20434.4 |
| 419 | 2022-12-20 12:13:24 | sconce | 3 | 112716 | 465 | 5.576 | 20214.5 |
| 418 | 2022-12-19 18:46:04 | sconce | 3 | 112716 | 465 | 5.076 | 22205.7 |
| 417 | 2022-12-11 07:42:45 | sconce | 3 | 112716 | 465 | 5.313 | 21215.1 |
| 416 | 2022-11-24 00:22:41 | sconce | 3 | 112716 | 465 | 5.060 | 22275.9 |
| 415 | 2022-11-18 11:29:40 | sconce | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 414 | 2022-11-14 13:14:43 | sconce | 3 | 112716 | 465 | 5.563 | 20261.7 |
| 413 | 2022-11-05 03:28:07 | sconce | 3 | 112716 | 465 | 4.703 | 23966.8 |
| 412 | 2022-11-03 11:38:03 | sconce | 3 | 112716 | 465 | 5.250 | 21469.7 |
| 411 | 2022-10-28 12:03:47 | sconce | 3 | 112716 | 465 | 5.330 | 21147.5 |
| 410 | 2022-10-16 19:25:07 | sconce | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 409 | 2022-09-29 17:29:37 | sconce | 3 | 112716 | 465 | 5.423 | 20784.8 |
| 408 | 2022-08-27 16:33:09 | sconce | 3 | 112716 | 465 | 4.673 | 24120.7 |
| 407 | 2022-08-25 08:33:02 | sconce | 3 | 112716 | 465 | 5.266 | 21404.5 |
| 406 | 2022-07-29 08:28:55 | sconce | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 405 | 2022-07-09 20:50:26 | sconce | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 404 | 2022-07-07 14:57:58 | sconce | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 403 | 2022-06-11 14:05:19 | sconce | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 402 | 2022-06-07 23:30:03 | sconce | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 401 | 2022-05-16 04:05:48 | sconce | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 400 | 2022-03-20 13:37:08 | sconce | 3 | 112716 | 465 | 4.640 | 24292.2 |
| 399 | 2022-03-12 13:27:29 | sconce | 3 | 112716 | 465 | 5.360 | 21029.1 |
| 398 | 2022-03-08 01:47:03 | sconce | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 397 | 2022-03-05 22:02:27 | sconce | 1 | 48755 | 4 | 0.923 | 52822.3 |
| 396 | 2022-02-07 06:59:10 | sconce | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 395 | 2021-12-16 10:19:56 | sconce | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 394 | 2021-12-07 13:31:28 | sconce | 3 | 112716 | 465 | 5.516 | 20434.4 |
| 393 | 2021-10-27 15:48:56 | sconce | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 392 | 2021-10-25 15:12:08 | sconce | 1 | 48755 | 4 | 0.920 | 52994.6 |
| 391 | 2021-10-14 08:04:41 | sconce | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 390 | 2021-09-13 16:25:45 | sconce | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 389 | 2021-08-27 02:47:30 | sconce | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 388 | 2021-07-13 06:47:23 | sconce | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 387 | 2021-06-22 19:58:27 | sconce | 3 | 112716 | 465 | 4.673 | 24120.7 |
| 386 | 2021-06-04 13:20:33 | sconce | 3 | 112716 | 465 | 5.343 | 21096.0 |
| 385 | 2021-05-26 21:16:48 | sconce | 3 | 112716 | 465 | 5.200 | 21676.2 |
| 384 | 2021-04-30 06:17:54 | sconce | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 383 | 2021-04-24 00:52:22 | sconce | 3 | 112716 | 465 | 5.253 | 21457.5 |
| 382 | 2021-04-09 19:09:10 | sconce | 1 | 48755 | 4 | 0.983 | 49598.2 |
| 381 | 2021-04-03 15:09:49 | sconce | 3 | 112716 | 465 | 4.626 | 24365.8 |
| 380 | 2021-03-29 15:38:53 | sconce | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 379 | 2021-02-12 00:20:32 | sconce | 3 | 112716 | 465 | 6.123 | 18408.6 |
| 378 | 2021-01-19 15:03:35 | sconce | 3 | 112716 | 465 | 4.763 | 23664.9 |
| 377 | 2021-01-13 09:28:31 | sconce | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 376 | 2020-12-27 20:25:22 | sconce | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 375 | 2020-11-03 15:38:07 | sconce | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 374 | 2020-10-21 04:43:54 | sconce | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 373 | 2020-10-18 16:57:03 | sconce | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 372 | 2020-10-16 03:16:33 | sconce | 3 | 112716 | 465 | 11.110 | 10145.5 |
| 371 | 2020-09-30 13:52:12 | sconce | 1 | 48755 | 4 | 1.466 | 33257.2 |
| 370 | 2020-09-24 06:01:55 | sconce | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 369 | 2020-08-20 14:13:00 | sconce | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 368 | 2020-08-04 21:23:09 | sconce | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 367 | 2020-06-09 21:44:10 | sconce | 1 | 48755 | 4 | 0.750 | 65006.7 |