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 |
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 |
459 | 2024-08-19 11:28:47 | lampion | 1 | 69583 | 6 | 3.860 | 18026.7 |
458 | 2024-08-17 20:05:59 | lampion | 1 | 69583 | 6 | 16.080 | 4327.3 |
457 | 2024-08-12 19:13:54 | lampion | 1 | 69583 | 6 | 8.470 | 8215.2 |
456 | 2024-08-09 06:21:22 | lampion | 3 | 134027 | 169 | 20.766 | 6454.2 |
455 | 2024-08-09 06:20:14 | lampion | 2 | 107671 | 17 | 8.266 | 13025.8 |
454 | 2024-08-08 14:22:11 | lampion | 2 | 107671 | 17 | 10.546 | 10209.7 |
453 | 2024-08-08 14:22:06 | lampion | 1 | 69583 | 6 | 2.856 | 24363.8 |
452 | 2024-08-02 08:03:02 | lampion | 1 | 69583 | 6 | 4.500 | 15462.9 |
451 | 2024-08-02 00:14:24 | lampion | 3 | 134027 | 169 | 35.846 | 3739.0 |
450 | 2024-08-01 12:43:45 | lampion | 3 | 134027 | 169 | 14.923 | 8981.2 |
449 | 2024-08-01 05:11:23 | lampion | 3 | 134027 | 169 | 30.266 | 4428.3 |
448 | 2024-08-01 04:29:14 | lampion | 3 | 134027 | 169 | 12.233 | 10956.2 |
447 | 2024-08-01 04:07:04 | lampion | 3 | 134027 | 169 | 27.033 | 4957.9 |
446 | 2024-07-29 19:46:14 | lampion | 1 | 69583 | 6 | 5.626 | 12368.1 |
445 | 2024-07-28 22:48:14 | lampion | 1 | 69583 | 6 | 2.360 | 29484.3 |
444 | 2024-07-26 18:48:03 | lampion | 1 | 69583 | 6 | 4.546 | 15306.4 |
443 | 2024-07-22 10:04:16 | lampion | 1 | 69583 | 6 | 2.390 | 29114.2 |
442 | 2024-07-06 20:36:13 | lampion | 1 | 69583 | 6 | 5.233 | 13297.0 |
441 | 2024-07-05 19:35:38 | lampion | 1 | 69583 | 6 | 1.860 | 37410.2 |
440 | 2024-07-03 17:34:36 | lampion | 1 | 69583 | 6 | 5.180 | 13433.0 |
439 | 2024-06-29 12:52:16 | lampion | 2 | 107671 | 17 | 4.673 | 23041.1 |
438 | 2024-06-10 20:07:29 | lampion | 1 | 69583 | 6 | 6.673 | 10427.5 |
437 | 2024-06-08 22:47:15 | lampion | 3 | 134027 | 169 | 29.580 | 4531.0 |
436 | 2024-06-06 06:56:33 | lampion | 3 | 134027 | 169 | 32.116 | 4173.2 |
435 | 2024-06-04 18:23:45 | lampion | 3 | 134027 | 169 | 27.873 | 4808.5 |
434 | 2024-06-04 18:09:56 | lampion | 3 | 134027 | 169 | 30.566 | 4384.8 |
433 | 2024-06-04 18:09:56 | lampion | 2 | 107671 | 17 | 17.843 | 6034.4 |
432 | 2024-06-04 18:09:50 | lampion | 1 | 69583 | 6 | 7.033 | 9893.8 |
431 | 2024-06-02 16:28:47 | lampion | 1 | 69583 | 6 | 3.830 | 18167.9 |
430 | 2024-06-01 02:00:46 | lampion | 1 | 69583 | 6 | 6.016 | 11566.3 |
429 | 2024-05-18 16:01:11 | lampion | 3 | 134027 | 169 | 15.296 | 8762.2 |
428 | 2024-05-11 20:23:10 | lampion | 3 | 134027 | 169 | 17.236 | 7776.0 |
427 | 2024-05-11 14:08:41 | lampion | 2 | 107671 | 17 | 11.313 | 9517.5 |
426 | 2024-05-11 14:08:39 | lampion | 3 | 134027 | 169 | 11.703 | 11452.4 |
425 | 2024-05-11 14:07:02 | lampion | 1 | 69583 | 6 | 1.420 | 49002.1 |
424 | 2024-05-11 01:01:43 | lampion | 1 | 69583 | 6 | 1.390 | 50059.7 |
423 | 2024-05-04 20:58:11 | lampion | 1 | 69583 | 6 | 2.690 | 25867.3 |