History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spanner"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
508 | 2024-04-19 01:42:00 | spanner | 1 | 69583 | 8 | 1.266 | 54962.9 |
507 | 2024-04-10 01:56:07 | spanner | 1 | 69583 | 8 | 2.170 | 32065.9 |
506 | 2024-03-28 19:48:14 | spanner | 1 | 69583 | 8 | 2.096 | 33198.0 |
505 | 2024-02-27 15:20:18 | spanner | 1 | 69583 | 8 | 1.250 | 55666.4 |
504 | 2024-01-29 18:53:10 | spanner | 1 | 69583 | 8 | 1.296 | 53690.6 |
503 | 2024-01-10 19:25:44 | spanner | 2 | 107671 | 74 | 2.936 | 36672.7 |
502 | 2024-01-08 01:19:54 | spanner | 1 | 69583 | 8 | 1.156 | 60192.9 |
501 | 2023-12-28 07:48:54 | spanner | 1 | 69583 | 8 | 1.233 | 56433.9 |
500 | 2023-12-25 08:43:37 | spanner | 3 | 134027 | 637 | 6.283 | 21331.7 |
499 | 2023-12-12 07:46:04 | spanner | 3 | 134027 | 637 | 6.500 | 20619.5 |
498 | 2023-12-11 10:27:25 | spanner | 2 | 107671 | 74 | 2.936 | 36672.7 |
497 | 2023-12-09 18:21:33 | spanner | 1 | 69583 | 8 | 1.920 | 36241.1 |
496 | 2023-11-28 06:30:21 | spanner | 1 | 69583 | 8 | 1.220 | 57035.2 |
495 | 2023-11-24 11:53:29 | spanner | 2 | 107671 | 74 | 3.186 | 33795.0 |
494 | 2023-11-15 17:19:16 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
493 | 2023-11-12 16:41:10 | spanner | 3 | 134027 | 637 | 6.063 | 22105.7 |
492 | 2023-11-11 05:46:22 | spanner | 1 | 69583 | 8 | 1.060 | 65644.3 |
491 | 2023-11-02 02:47:21 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
490 | 2023-10-21 23:21:38 | spanner | 2 | 107671 | 74 | 3.110 | 34620.9 |
489 | 2023-10-18 14:20:14 | spanner | 1 | 69583 | 8 | 1.250 | 55666.4 |
488 | 2023-10-16 04:44:25 | spanner | 2 | 107671 | 74 | 3.203 | 33615.7 |
487 | 2023-09-26 02:24:59 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
486 | 2023-09-23 08:26:34 | spanner | 1 | 69583 | 8 | 4.970 | 14000.6 |
485 | 2023-09-08 21:19:38 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
484 | 2023-08-14 16:39:45 | spanner | 1 | 69583 | 8 | 1.060 | 65644.3 |
483 | 2023-07-25 15:58:23 | spanner | 2 | 107671 | 74 | 2.860 | 37647.2 |
482 | 2023-05-19 12:40:31 | spanner | 1 | 69583 | 8 | 1.203 | 57841.2 |
481 | 2023-05-16 06:03:09 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
480 | 2023-05-16 02:48:16 | spanner | 1 | 69583 | 8 | 1.096 | 63488.1 |
479 | 2023-04-04 21:31:58 | spanner | 2 | 107671 | 74 | 2.783 | 38688.8 |
478 | 2023-03-09 19:23:10 | spanner | 1 | 69583 | 8 | 1.063 | 65459.1 |
477 | 2023-01-26 17:23:08 | spanner | 1 | 69583 | 8 | 1.140 | 61037.7 |
476 | 2023-01-01 19:55:15 | spanner | 2 | 107671 | 74 | 5.826 | 18481.1 |
475 | 2022-12-31 04:05:50 | spanner | 1 | 69583 | 8 | 1.080 | 64428.7 |
474 | 2022-10-01 14:24:40 | spanner | 1 | 69583 | 8 | 1.140 | 61037.7 |
473 | 2022-09-21 11:26:49 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
472 | 2022-09-06 00:11:34 | spanner | 2 | 107671 | 74 | 2.953 | 36461.6 |
471 | 2022-09-03 21:03:17 | spanner | 2 | 107671 | 74 | 2.873 | 37476.9 |
470 | 2022-08-29 00:03:39 | spanner | 1 | 69583 | 8 | 1.720 | 40455.2 |
469 | 2022-08-18 16:59:07 | spanner | 1 | 69583 | 8 | 1.190 | 58473.1 |
468 | 2022-07-26 11:29:20 | spanner | 1 | 69583 | 8 | 1.106 | 62914.1 |
467 | 2022-05-25 15:59:46 | spanner | 2 | 107671 | 74 | 3.373 | 31921.4 |
466 | 2022-05-25 05:46:00 | spanner | 1 | 69583 | 8 | 1.096 | 63488.1 |
465 | 2022-05-02 13:49:20 | spanner | 1 | 69583 | 8 | 1.123 | 61961.7 |
464 | 2022-04-24 07:25:30 | spanner | 2 | 107671 | 74 | 3.360 | 32044.9 |
463 | 2022-03-27 06:37:48 | spanner | 2 | 107671 | 74 | 3.453 | 31181.9 |
462 | 2022-01-27 03:33:31 | spanner | 1 | 69583 | 8 | 1.216 | 57222.9 |
461 | 2022-01-23 17:40:11 | spanner | 1 | 69583 | 8 | 1.236 | 56296.9 |
460 | 2022-01-23 16:09:55 | spanner | 1 | 69583 | 8 | 1.266 | 54962.9 |
459 | 2022-01-21 14:26:35 | spanner | 1 | 69583 | 8 | 1.296 | 53690.6 |
458 | 2021-12-16 05:04:19 | spanner | 2 | 107671 | 74 | 3.330 | 32333.6 |
457 | 2021-11-17 03:19:49 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
456 | 2021-10-09 03:46:30 | spanner | 1 | 69583 | 8 | 1.173 | 59320.5 |
455 | 2021-09-30 22:37:37 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
454 | 2021-09-11 11:44:50 | spanner | 1 | 69583 | 8 | 2.406 | 28920.6 |
453 | 2021-09-09 08:10:16 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
452 | 2021-08-24 20:53:31 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
451 | 2021-08-22 16:02:12 | spanner | 1 | 69583 | 8 | 1.220 | 57035.2 |
450 | 2021-07-06 08:51:01 | spanner | 1 | 69583 | 8 | 1.080 | 64428.7 |
449 | 2021-07-01 13:34:40 | spanner | 1 | 69583 | 8 | 1.156 | 60192.9 |
448 | 2021-06-13 21:09:37 | spanner | 1 | 69583 | 8 | 1.313 | 52995.4 |
447 | 2021-03-31 16:53:45 | spanner | 1 | 69583 | 8 | 2.533 | 27470.6 |
446 | 2021-03-24 01:42:02 | spanner | 1 | 69583 | 8 | 1.266 | 54962.9 |
445 | 2021-03-24 00:25:57 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
444 | 2021-02-26 08:28:36 | spanner | 1 | 69583 | 8 | 1.170 | 59472.6 |
443 | 2021-01-28 13:44:51 | spanner | 1 | 69583 | 8 | 1.343 | 51811.6 |
442 | 2021-01-06 17:24:45 | spanner | 1 | 69583 | 8 | 1.233 | 56433.9 |
441 | 2020-12-27 03:20:55 | spanner | 1 | 69583 | 8 | 1.200 | 57985.8 |
440 | 2020-12-08 21:58:15 | spanner | 1 | 69583 | 8 | 1.156 | 60192.9 |
439 | 2020-12-08 19:50:25 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
438 | 2020-11-05 21:29:54 | spanner | 1 | 69583 | 8 | 1.140 | 61037.7 |
437 | 2020-09-23 12:24:56 | spanner | 1 | 69583 | 8 | 1.080 | 64428.7 |
436 | 2020-07-19 12:50:53 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
435 | 2020-07-17 16:31:49 | spanner | 1 | 69583 | 8 | 1.140 | 61037.7 |
434 | 2020-06-17 19:32:33 | spanner | 1 | 69583 | 8 | 1.263 | 55093.4 |
433 | 2020-06-09 09:51:57 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
432 | 2020-06-06 11:45:04 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
431 | 2020-06-02 05:19:09 | spanner | 1 | 69583 | 8 | 1.203 | 57841.2 |
430 | 2020-06-01 05:55:53 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
429 | 2020-05-29 12:19:48 | spanner | 1 | 69583 | 8 | 1.203 | 57841.2 |
428 | 2020-05-28 12:26:57 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
427 | 2020-05-27 11:48:26 | spanner | 1 | 69583 | 8 | 1.140 | 61037.7 |
426 | 2020-05-24 03:58:53 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
425 | 2020-05-23 04:31:38 | spanner | 1 | 69583 | 8 | 1.233 | 56433.9 |
424 | 2020-05-20 11:36:58 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
423 | 2020-05-19 10:55:38 | spanner | 1 | 69583 | 8 | 1.266 | 54962.9 |
422 | 2020-05-16 06:19:08 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
421 | 2020-05-14 08:11:36 | spanner | 1 | 69583 | 8 | 1.203 | 57841.2 |
420 | 2020-05-13 14:08:54 | spanner | 1 | 69583 | 8 | 1.250 | 55666.4 |
419 | 2020-05-12 14:59:37 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
418 | 2020-05-11 15:38:17 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
417 | 2020-05-10 14:53:24 | spanner | 1 | 69583 | 8 | 1.076 | 64668.2 |
416 | 2020-05-09 14:50:41 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
415 | 2020-05-08 14:54:21 | spanner | 1 | 69583 | 8 | 1.093 | 63662.4 |
414 | 2020-05-07 14:12:08 | spanner | 1 | 69583 | 8 | 1.296 | 53690.6 |
413 | 2020-05-06 14:51:08 | spanner | 1 | 69583 | 8 | 1.186 | 58670.3 |
412 | 2020-05-04 14:19:39 | spanner | 1 | 69583 | 8 | 1.190 | 58473.1 |
411 | 2020-05-03 14:19:08 | spanner | 1 | 69583 | 8 | 1.123 | 61961.7 |
410 | 2020-05-02 14:54:39 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
409 | 2020-04-30 14:27:53 | spanner | 1 | 69583 | 8 | 1.233 | 56433.9 |