History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lampion"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 559 | 2025-11-20 16:11:36 | lampion | 1 | 69583 | 6 | 1.580 | 44039.9 |
| 558 | 2025-11-17 00:40:09 | lampion | 1 | 69583 | 6 | 2.936 | 23699.9 |
| 557 | 2025-11-16 08:59:12 | lampion | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 556 | 2025-11-14 17:45:52 | lampion | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 555 | 2025-11-11 17:31:22 | lampion | 1 | 69583 | 6 | 1.263 | 55093.4 |
| 554 | 2025-11-09 06:20:49 | lampion | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 553 | 2025-11-08 01:01:38 | lampion | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 552 | 2025-10-31 10:58:13 | lampion | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 551 | 2025-10-25 13:53:13 | lampion | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 550 | 2025-10-23 08:02:09 | lampion | 1 | 69583 | 6 | 6.030 | 11539.5 |
| 549 | 2025-10-20 18:35:05 | lampion | 1 | 69583 | 6 | 3.456 | 20134.0 |
| 548 | 2025-10-14 00:32:27 | lampion | 1 | 69583 | 6 | 1.190 | 58473.1 |
| 547 | 2025-10-13 17:22:47 | lampion | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 546 | 2025-10-10 20:02:11 | lampion | 1 | 69583 | 6 | 1.326 | 52475.9 |
| 545 | 2025-10-01 03:16:29 | lampion | 2 | 107671 | 17 | 3.310 | 32529.0 |
| 544 | 2025-09-26 03:58:20 | lampion | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 543 | 2025-09-22 16:41:26 | lampion | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 542 | 2025-09-18 19:23:40 | lampion | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 541 | 2025-09-17 18:30:42 | lampion | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 540 | 2025-09-17 18:29:48 | lampion | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 539 | 2025-09-17 15:55:39 | lampion | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 538 | 2025-09-17 13:06:50 | lampion | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 537 | 2025-09-17 13:06:39 | lampion | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 536 | 2025-09-13 09:00:07 | lampion | 1 | 69583 | 6 | 1.236 | 56296.9 |
| 535 | 2025-08-31 22:14:19 | lampion | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 534 | 2025-08-29 12:35:07 | lampion | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 533 | 2025-08-28 13:30:26 | lampion | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 532 | 2025-08-25 00:37:26 | lampion | 1 | 69583 | 6 | 5.580 | 12470.1 |
| 531 | 2025-08-04 02:09:31 | lampion | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 530 | 2025-08-01 14:22:36 | lampion | 1 | 69583 | 6 | 2.980 | 23350.0 |
| 529 | 2025-07-25 06:06:47 | lampion | 1 | 69583 | 6 | 4.716 | 14754.7 |
| 528 | 2025-07-23 02:36:40 | lampion | 1 | 69583 | 6 | 2.923 | 23805.3 |
| 527 | 2025-07-19 08:17:07 | lampion | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 526 | 2025-07-19 04:40:31 | lampion | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 525 | 2025-07-14 14:07:22 | lampion | 1 | 69583 | 6 | 5.986 | 11624.3 |
| 524 | 2025-07-14 10:02:23 | lampion | 1 | 69583 | 6 | 2.890 | 24077.2 |
| 523 | 2025-07-05 04:48:01 | lampion | 1 | 69583 | 6 | 6.186 | 11248.5 |
| 522 | 2025-06-24 14:23:02 | lampion | 1 | 69583 | 6 | 5.390 | 12909.6 |
| 521 | 2025-06-22 09:06:00 | lampion | 1 | 69583 | 6 | 5.483 | 12690.7 |
| 520 | 2025-06-22 00:46:01 | lampion | 1 | 69583 | 6 | 6.660 | 10447.9 |
| 519 | 2025-06-12 13:03:31 | lampion | 1 | 69583 | 6 | 5.423 | 12831.1 |
| 518 | 2025-05-26 13:10:40 | lampion | 1 | 69583 | 6 | 8.750 | 7952.3 |
| 517 | 2025-05-22 01:17:20 | lampion | 1 | 69583 | 6 | 4.500 | 15462.9 |
| 516 | 2025-05-16 09:19:31 | lampion | 1 | 69583 | 6 | 6.643 | 10474.6 |
| 515 | 2025-05-11 10:03:21 | lampion | 1 | 69583 | 6 | 5.843 | 11908.8 |
| 514 | 2025-05-09 13:47:22 | lampion | 1 | 69583 | 6 | 3.423 | 20328.1 |
| 513 | 2025-05-06 10:23:55 | lampion | 3 | 134027 | 169 | 42.840 | 3128.5 |
| 512 | 2025-05-06 07:41:43 | lampion | 2 | 107671 | 17 | 20.156 | 5341.9 |
| 511 | 2025-05-04 11:12:00 | lampion | 2 | 107671 | 17 | 15.140 | 7111.7 |
| 510 | 2025-05-04 04:43:11 | lampion | 3 | 134027 | 169 | 49.630 | 2700.5 |
| 509 | 2025-05-03 13:11:16 | lampion | 1 | 69583 | 6 | 2.810 | 24762.6 |
| 508 | 2025-04-21 02:17:25 | lampion | 3 | 134027 | 169 | 38.033 | 3524.0 |
| 507 | 2025-04-20 00:46:59 | lampion | 1 | 69583 | 6 | 3.033 | 22942.0 |
| 506 | 2025-04-16 15:22:00 | lampion | 1 | 69583 | 6 | 4.203 | 16555.6 |
| 505 | 2025-04-11 16:49:08 | lampion | 1 | 69583 | 6 | 6.546 | 10629.9 |
| 504 | 2025-04-11 15:28:18 | lampion | 1 | 69583 | 6 | 5.546 | 12546.5 |
| 503 | 2025-04-02 13:11:50 | lampion | 1 | 69583 | 6 | 4.156 | 16742.8 |
| 502 | 2025-03-31 09:48:04 | lampion | 1 | 69583 | 6 | 5.656 | 12302.5 |
| 501 | 2025-03-20 02:18:17 | lampion | 1 | 69583 | 6 | 3.046 | 22844.1 |
| 500 | 2025-03-09 17:56:47 | lampion | 1 | 69583 | 6 | 6.000 | 11597.2 |
| 499 | 2025-03-09 16:53:10 | lampion | 3 | 134027 | 169 | 42.813 | 3130.5 |
| 498 | 2025-03-08 13:24:58 | lampion | 3 | 134027 | 169 | 32.083 | 4177.5 |
| 497 | 2025-03-05 09:16:52 | lampion | 1 | 69583 | 6 | 5.030 | 13833.6 |
| 496 | 2025-02-25 12:33:19 | lampion | 3 | 134027 | 169 | 31.720 | 4225.3 |
| 495 | 2025-02-25 07:50:38 | lampion | 3 | 134027 | 169 | 31.393 | 4269.3 |
| 494 | 2025-02-25 01:24:41 | lampion | 3 | 134027 | 169 | 30.453 | 4401.1 |
| 493 | 2025-02-24 19:52:02 | lampion | 3 | 134027 | 169 | 29.800 | 4497.6 |
| 492 | 2025-02-24 03:56:19 | lampion | 1 | 69583 | 6 | 3.846 | 18092.3 |
| 491 | 2025-02-21 13:36:47 | lampion | 1 | 69583 | 6 | 3.500 | 19880.9 |
| 490 | 2025-02-04 18:37:52 | lampion | 1 | 69583 | 6 | 5.953 | 11688.7 |
| 489 | 2025-02-04 06:00:20 | lampion | 1 | 69583 | 6 | 3.096 | 22475.1 |
| 488 | 2025-02-01 01:03:53 | lampion | 1 | 69583 | 6 | 4.296 | 16197.2 |
| 487 | 2025-01-24 14:30:00 | lampion | 3 | 134027 | 169 | 31.630 | 4237.3 |
| 486 | 2025-01-23 22:32:00 | lampion | 3 | 134027 | 169 | 23.050 | 5814.6 |
| 485 | 2025-01-21 20:04:20 | lampion | 1 | 69583 | 6 | 6.200 | 11223.1 |
| 484 | 2025-01-20 18:52:54 | lampion | 3 | 134027 | 169 | 33.160 | 4041.8 |
| 483 | 2025-01-19 18:20:23 | lampion | 3 | 134027 | 169 | 19.876 | 6743.2 |
| 482 | 2025-01-01 06:59:24 | lampion | 1 | 69583 | 6 | 5.800 | 11997.1 |
| 481 | 2024-12-08 09:07:24 | lampion | 3 | 134027 | 169 | 36.503 | 3671.7 |
| 480 | 2024-12-08 09:05:22 | lampion | 1 | 69583 | 6 | 5.876 | 11841.9 |
| 479 | 2024-12-07 00:14:07 | lampion | 3 | 134027 | 169 | 22.553 | 5942.8 |
| 478 | 2024-12-06 21:30:42 | lampion | 3 | 134027 | 169 | 16.720 | 8016.0 |
| 477 | 2024-11-29 07:53:39 | lampion | 1 | 69583 | 6 | 4.250 | 16372.5 |
| 476 | 2024-11-18 14:56:24 | lampion | 1 | 69583 | 6 | 6.140 | 11332.7 |
| 475 | 2024-11-16 19:29:14 | lampion | 3 | 134027 | 169 | 27.080 | 4949.3 |
| 474 | 2024-11-16 00:51:23 | lampion | 3 | 134027 | 169 | 30.140 | 4446.8 |
| 473 | 2024-11-15 00:04:17 | lampion | 3 | 134027 | 169 | 15.003 | 8933.3 |
| 472 | 2024-11-08 03:35:26 | lampion | 1 | 69583 | 6 | 5.750 | 12101.4 |
| 471 | 2024-10-25 08:27:45 | lampion | 3 | 134027 | 169 | 35.660 | 3758.5 |
| 470 | 2024-10-16 23:41:24 | lampion | 3 | 134027 | 169 | 36.750 | 3647.0 |
| 469 | 2024-10-16 16:00:29 | lampion | 3 | 134027 | 169 | 37.286 | 3594.6 |
| 468 | 2024-10-16 16:00:51 | lampion | 2 | 107671 | 17 | 13.683 | 7869.0 |
| 467 | 2024-10-16 16:00:16 | lampion | 1 | 69583 | 6 | 1.313 | 52995.4 |
| 466 | 2024-10-05 08:55:48 | lampion | 1 | 69583 | 6 | 12.753 | 5456.2 |
| 465 | 2024-10-03 22:47:51 | lampion | 1 | 69583 | 6 | 4.436 | 15686.0 |
| 464 | 2024-10-03 07:53:57 | lampion | 1 | 69583 | 6 | 12.050 | 5774.5 |
| 463 | 2024-09-24 23:25:07 | lampion | 1 | 69583 | 6 | 13.860 | 5020.4 |
| 462 | 2024-09-14 11:36:38 | lampion | 1 | 69583 | 6 | 8.266 | 8418.0 |
| 461 | 2024-08-31 07:31:06 | lampion | 1 | 69583 | 6 | 9.610 | 7240.7 |
| 460 | 2024-08-25 06:07:22 | lampion | 1 | 69583 | 6 | 4.703 | 14795.4 |