History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asparkle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
495 | 2024-06-07 19:23:00 | asparkle | 1 | 82945 | 2 | 2.796 | 29665.6 |
494 | 2024-06-02 08:18:56 | asparkle | 3 | 146162 | 49 | 12.296 | 11887.0 |
493 | 2024-05-31 10:54:13 | asparkle | 3 | 146162 | 49 | 27.096 | 5394.2 |
492 | 2024-05-31 10:54:15 | asparkle | 2 | 121059 | 8 | 16.830 | 7193.0 |
491 | 2024-05-31 09:17:06 | asparkle | 1 | 82945 | 2 | 6.546 | 12671.1 |
490 | 2024-05-31 04:52:54 | asparkle | 1 | 82945 | 2 | 1.500 | 55296.7 |
489 | 2024-05-16 07:59:08 | asparkle | 2 | 121059 | 8 | 3.716 | 32577.8 |
488 | 2024-05-16 07:58:51 | asparkle | 3 | 146162 | 49 | 9.483 | 15413.1 |
487 | 2024-05-15 03:55:16 | asparkle | 2 | 121059 | 8 | 5.486 | 22066.9 |
486 | 2024-05-15 03:55:12 | asparkle | 3 | 146162 | 49 | 8.406 | 17387.8 |
485 | 2024-05-15 03:55:07 | asparkle | 1 | 82945 | 2 | 3.266 | 25396.5 |
484 | 2024-05-13 12:08:01 | asparkle | 2 | 121059 | 8 | 13.140 | 9213.0 |
483 | 2024-05-13 12:07:51 | asparkle | 3 | 146162 | 49 | 18.626 | 7847.2 |
482 | 2024-05-13 12:02:36 | asparkle | 1 | 82945 | 2 | 1.640 | 50576.2 |
481 | 2024-05-13 11:57:24 | asparkle | 4 | 161609 | 468 | 36.813 | 4390.0 |
480 | 2024-05-12 22:38:31 | asparkle | 1 | 82945 | 2 | 3.343 | 24811.5 |
479 | 2024-05-12 11:07:29 | asparkle | 4 | 161609 | 468 | 43.520 | 3713.4 |
478 | 2024-05-11 20:50:21 | asparkle | 4 | 161609 | 468 | 22.233 | 7268.9 |
477 | 2024-05-11 05:36:07 | asparkle | 4 | 161609 | 468 | 21.313 | 7582.6 |
476 | 2024-05-10 13:01:49 | asparkle | 2 | 121059 | 8 | 5.673 | 21339.5 |
475 | 2024-05-10 01:40:40 | asparkle | 4 | 161609 | 468 | 46.533 | 3473.0 |
474 | 2024-05-09 04:46:06 | asparkle | 1 | 82945 | 2 | 1.406 | 58993.6 |
473 | 2024-05-09 04:44:56 | asparkle | 4 | 161609 | 468 | 22.390 | 7217.9 |
472 | 2024-05-09 04:45:08 | asparkle | 1 | 82945 | 2 | 3.170 | 26165.6 |
471 | 2024-05-09 04:44:58 | asparkle | 3 | 146162 | 49 | 8.656 | 16885.6 |
470 | 2024-05-09 04:44:57 | asparkle | 2 | 121059 | 8 | 6.873 | 17613.7 |
469 | 2024-05-02 11:07:45 | asparkle | 1 | 82945 | 2 | 3.486 | 23793.7 |
468 | 2024-05-02 10:31:55 | asparkle | 3 | 146162 | 49 | 9.593 | 15236.3 |
467 | 2024-05-02 10:31:58 | asparkle | 2 | 121059 | 8 | 6.330 | 19124.6 |
466 | 2024-04-25 23:03:04 | asparkle | 2 | 121059 | 8 | 7.593 | 15943.5 |
465 | 2024-04-25 23:02:32 | asparkle | 3 | 146162 | 49 | 10.893 | 13418.0 |
464 | 2024-04-25 23:01:28 | asparkle | 1 | 82945 | 2 | 1.343 | 61761.0 |
463 | 2024-04-13 01:08:32 | asparkle | 2 | 121059 | 8 | 4.390 | 27576.1 |
462 | 2024-04-13 01:08:20 | asparkle | 3 | 146162 | 49 | 7.970 | 18339.0 |
461 | 2024-04-11 23:53:37 | asparkle | 4 | 161609 | 468 | 19.440 | 8313.2 |
460 | 2024-04-11 05:18:35 | asparkle | 3 | 146162 | 49 | 7.986 | 18302.3 |
459 | 2024-04-10 22:09:18 | asparkle | 4 | 161609 | 468 | 14.390 | 11230.6 |
458 | 2024-04-10 15:02:47 | asparkle | 2 | 121059 | 8 | 4.373 | 27683.3 |
457 | 2024-04-10 14:21:29 | asparkle | 3 | 146162 | 49 | 7.936 | 18417.6 |
456 | 2024-04-10 01:20:17 | asparkle | 4 | 161609 | 468 | 27.426 | 5892.5 |
455 | 2024-04-09 23:31:08 | asparkle | 4 | 161609 | 468 | 50.473 | 3201.9 |
454 | 2024-04-08 23:30:11 | asparkle | 1 | 82945 | 2 | 5.656 | 14665.0 |
453 | 2024-04-08 23:29:42 | asparkle | 4 | 161609 | 468 | 27.640 | 5846.9 |
452 | 2024-04-08 23:29:44 | asparkle | 3 | 146162 | 49 | 20.470 | 7140.3 |
451 | 2024-04-08 23:29:44 | asparkle | 2 | 121059 | 8 | 4.470 | 27082.6 |
450 | 2024-04-08 23:29:28 | asparkle | 1 | 82945 | 2 | 3.513 | 23610.9 |
449 | 2024-04-07 03:10:23 | asparkle | 1 | 82945 | 2 | 6.143 | 13502.4 |
448 | 2024-03-30 09:15:03 | asparkle | 1 | 82945 | 2 | 1.673 | 49578.6 |
447 | 2024-03-22 09:07:57 | asparkle | 2 | 121059 | 8 | 3.580 | 33815.4 |
446 | 2024-03-22 09:07:54 | asparkle | 1 | 82945 | 2 | 1.516 | 54713.1 |
445 | 2024-03-20 19:43:40 | asparkle | 3 | 146162 | 49 | 15.203 | 9614.0 |
444 | 2024-03-19 21:39:40 | asparkle | 3 | 146162 | 49 | 17.966 | 8135.5 |
443 | 2024-03-19 21:39:37 | asparkle | 2 | 121059 | 8 | 8.546 | 14165.6 |
442 | 2024-03-19 21:25:16 | asparkle | 1 | 82945 | 2 | 1.296 | 64000.8 |
441 | 2024-03-11 21:54:06 | asparkle | 3 | 146162 | 49 | 25.780 | 5669.6 |
440 | 2024-03-10 16:23:30 | asparkle | 1 | 82945 | 2 | 4.096 | 20250.2 |
439 | 2024-03-10 04:27:32 | asparkle | 3 | 146162 | 49 | 14.266 | 10245.5 |
438 | 2024-03-08 11:50:56 | asparkle | 4 | 161609 | 468 | 27.436 | 5890.4 |
437 | 2024-03-07 17:10:21 | asparkle | 4 | 161609 | 468 | 13.220 | 12224.6 |
436 | 2024-03-07 13:56:07 | asparkle | 4 | 161609 | 468 | 14.860 | 10875.4 |
435 | 2024-03-07 02:02:38 | asparkle | 3 | 146162 | 49 | 9.283 | 15745.1 |
434 | 2024-03-06 22:55:20 | asparkle | 4 | 161609 | 468 | 16.656 | 9702.7 |
433 | 2024-03-06 14:21:33 | asparkle | 1 | 82945 | 2 | 3.173 | 26140.9 |
432 | 2024-03-06 13:11:36 | asparkle | 4 | 161609 | 468 | 41.690 | 3876.4 |
431 | 2024-03-06 13:11:38 | asparkle | 3 | 146162 | 49 | 19.316 | 7566.9 |
430 | 2024-03-06 13:11:54 | asparkle | 1 | 82945 | 2 | 2.876 | 28840.4 |
429 | 2024-03-06 13:11:39 | asparkle | 2 | 121059 | 8 | 4.343 | 27874.5 |
428 | 2024-03-06 13:11:32 | asparkle | 1 | 82945 | 2 | 4.343 | 19098.5 |
427 | 2024-02-19 16:40:48 | asparkle | 1 | 82945 | 2 | 1.593 | 52068.4 |
426 | 2024-02-07 05:41:02 | asparkle | 2 | 121059 | 8 | 3.406 | 35542.9 |
425 | 2024-02-07 05:40:50 | asparkle | 3 | 146162 | 49 | 7.736 | 18893.7 |
424 | 2024-02-05 09:30:43 | asparkle | 3 | 146162 | 49 | 6.686 | 21860.9 |
423 | 2024-02-05 09:30:39 | asparkle | 2 | 121059 | 8 | 3.876 | 31233.0 |
422 | 2024-02-05 09:30:07 | asparkle | 4 | 161609 | 468 | 13.486 | 11983.5 |
421 | 2024-02-04 02:50:14 | asparkle | 1 | 82945 | 2 | 1.513 | 54821.5 |
420 | 2024-02-03 19:53:05 | asparkle | 1 | 82945 | 2 | 1.500 | 55296.7 |
419 | 2024-01-31 21:25:08 | asparkle | 2 | 121059 | 8 | 6.483 | 18673.3 |
418 | 2024-01-31 21:24:56 | asparkle | 3 | 146162 | 49 | 7.796 | 18748.3 |
417 | 2024-01-31 05:19:31 | asparkle | 3 | 146162 | 49 | 7.516 | 19446.8 |
416 | 2024-01-27 05:44:45 | asparkle | 3 | 146162 | 49 | 6.736 | 21698.6 |
415 | 2024-01-27 05:44:41 | asparkle | 1 | 82945 | 2 | 1.406 | 58993.6 |
414 | 2024-01-26 03:09:13 | asparkle | 4 | 161609 | 468 | 14.093 | 11467.3 |
413 | 2024-01-25 18:00:15 | asparkle | 2 | 121059 | 8 | 3.253 | 37214.6 |
412 | 2024-01-23 01:50:02 | asparkle | 4 | 161609 | 468 | 41.020 | 3939.8 |
411 | 2024-01-22 11:51:20 | asparkle | 4 | 161609 | 468 | 33.173 | 4871.7 |
410 | 2024-01-14 19:51:48 | asparkle | 4 | 161609 | 468 | 12.546 | 12881.3 |
409 | 2024-01-08 16:37:57 | asparkle | 4 | 161609 | 468 | 14.266 | 11328.3 |
408 | 2024-01-05 14:51:11 | asparkle | 1 | 82945 | 2 | 1.373 | 60411.5 |
407 | 2024-01-04 18:13:19 | asparkle | 1 | 82945 | 2 | 1.390 | 59672.7 |
406 | 2024-01-02 17:13:04 | asparkle | 1 | 82945 | 2 | 1.313 | 63172.1 |
405 | 2023-12-17 17:35:25 | asparkle | 3 | 146162 | 49 | 9.343 | 15644.0 |
404 | 2023-12-08 08:31:29 | asparkle | 3 | 146162 | 49 | 7.296 | 20033.2 |
403 | 2023-12-08 08:31:22 | asparkle | 3 | 146162 | 49 | 6.626 | 22058.9 |
402 | 2023-12-08 08:26:58 | asparkle | 3 | 146162 | 49 | 7.106 | 20568.8 |
401 | 2023-12-08 08:21:39 | asparkle | 3 | 146162 | 49 | 7.596 | 19242.0 |
400 | 2023-12-03 06:51:21 | asparkle | 3 | 146162 | 49 | 7.563 | 19325.9 |
399 | 2023-11-27 07:19:03 | asparkle | 1 | 82945 | 2 | 1.313 | 63172.1 |
398 | 2023-11-16 07:24:31 | asparkle | 4 | 161609 | 468 | 10.593 | 15256.2 |
397 | 2023-11-10 01:23:53 | asparkle | 3 | 146162 | 49 | 6.093 | 23988.5 |
396 | 2023-09-13 10:26:15 | asparkle | 1 | 82945 | 2 | 1.470 | 56425.2 |