History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
489 | 2024-04-27 05:53:07 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
488 | 2024-04-27 05:53:00 | canny | 2 | 53800 | 133 | 1.423 | 37807.4 |
487 | 2024-04-27 04:30:52 | canny | 2 | 53800 | 133 | 3.436 | 15657.7 |
486 | 2024-04-03 06:04:17 | canny | 1 | 28756 | 8 | 0.436 | 65954.1 |
485 | 2024-03-31 06:49:49 | canny | 2 | 53800 | 133 | 5.950 | 9042.0 |
484 | 2024-03-31 06:43:19 | canny | 1 | 28756 | 8 | 1.750 | 16432.0 |
483 | 2024-03-28 01:23:09 | canny | 1 | 28756 | 8 | 0.580 | 49579.3 |
482 | 2024-03-27 04:56:27 | canny | 1 | 28756 | 8 | 0.533 | 53951.2 |
481 | 2024-03-03 21:00:46 | canny | 1 | 28756 | 8 | 0.483 | 59536.2 |
480 | 2024-03-01 05:08:16 | canny | 1 | 28756 | 8 | 0.533 | 53951.2 |
479 | 2024-02-25 17:38:01 | canny | 1 | 28756 | 8 | 0.500 | 57512.0 |
478 | 2024-02-19 07:01:15 | canny | 1 | 28756 | 8 | 0.560 | 51350.0 |
477 | 2024-02-07 14:20:49 | canny | 2 | 53800 | 133 | 1.640 | 32804.9 |
476 | 2024-02-02 18:58:35 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
475 | 2024-01-28 19:47:47 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
474 | 2024-01-26 04:40:05 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
473 | 2023-12-27 17:57:14 | canny | 2 | 53800 | 133 | 1.406 | 38264.6 |
472 | 2023-12-05 14:51:50 | canny | 2 | 53800 | 133 | 1.626 | 33087.3 |
471 | 2023-12-02 17:34:36 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
470 | 2023-11-28 15:24:54 | canny | 1 | 28756 | 8 | 0.500 | 57512.0 |
469 | 2023-11-23 13:00:35 | canny | 2 | 53800 | 133 | 1.813 | 29674.6 |
468 | 2023-11-13 00:19:10 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
467 | 2023-11-09 14:55:24 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
466 | 2023-11-01 12:16:42 | canny | 1 | 28756 | 8 | 0.440 | 65354.5 |
465 | 2023-10-28 02:56:20 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
464 | 2023-10-20 17:38:39 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
463 | 2023-10-17 22:32:11 | canny | 1 | 28756 | 8 | 1.063 | 27051.7 |
462 | 2023-10-11 23:36:55 | canny | 1 | 28756 | 8 | 0.436 | 65954.1 |
461 | 2023-10-07 23:24:01 | canny | 1 | 28756 | 8 | 0.500 | 57512.0 |
460 | 2023-10-04 14:28:34 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
459 | 2023-10-02 04:43:01 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
458 | 2023-09-26 00:01:52 | canny | 1 | 28756 | 8 | 0.500 | 57512.0 |
457 | 2023-09-21 01:08:19 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
456 | 2023-09-17 15:19:25 | canny | 1 | 28756 | 8 | 0.546 | 52666.7 |
455 | 2023-07-20 16:06:12 | canny | 1 | 28756 | 8 | 0.456 | 63061.4 |
454 | 2023-06-26 17:38:25 | canny | 1 | 28756 | 8 | 0.440 | 65354.5 |
453 | 2023-04-09 03:59:31 | canny | 1 | 28756 | 8 | 0.500 | 57512.0 |
452 | 2023-04-05 15:12:39 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
451 | 2023-03-26 22:16:47 | canny | 1 | 28756 | 8 | 0.436 | 65954.1 |
450 | 2023-01-19 04:29:53 | canny | 1 | 28756 | 8 | 0.436 | 65954.1 |
449 | 2022-12-31 04:29:16 | canny | 1 | 28756 | 8 | 0.936 | 30722.2 |
448 | 2022-11-14 03:01:41 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
447 | 2022-09-16 17:15:53 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
446 | 2022-08-15 04:29:31 | canny | 1 | 28756 | 8 | 0.436 | 65954.1 |
445 | 2022-07-29 11:52:14 | canny | 1 | 28756 | 8 | 0.500 | 57512.0 |
444 | 2022-07-05 10:21:02 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
443 | 2022-07-03 05:03:40 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
442 | 2022-05-31 07:02:25 | canny | 1 | 28756 | 8 | 0.436 | 65954.1 |
441 | 2022-03-05 21:35:51 | canny | 1 | 28756 | 8 | 0.533 | 53951.2 |
440 | 2022-02-20 01:34:26 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
439 | 2022-02-16 17:27:07 | canny | 1 | 28756 | 8 | 0.546 | 52666.7 |
438 | 2021-12-18 12:36:47 | canny | 1 | 28756 | 8 | 0.516 | 55728.7 |
437 | 2021-12-16 09:34:11 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
436 | 2021-12-09 07:06:31 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
435 | 2021-11-15 11:40:41 | canny | 1 | 28756 | 8 | 0.486 | 59168.7 |
434 | 2021-11-08 18:12:25 | canny | 1 | 28756 | 8 | 0.516 | 55728.7 |
433 | 2021-10-25 14:16:50 | canny | 1 | 28756 | 8 | 0.533 | 53951.2 |
432 | 2021-10-23 13:13:03 | canny | 1 | 28756 | 8 | 0.513 | 56054.6 |
431 | 2021-09-15 19:24:51 | canny | 1 | 28756 | 8 | 0.516 | 55728.7 |
430 | 2021-09-13 16:00:37 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
429 | 2021-08-24 21:39:36 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
428 | 2021-08-09 03:16:34 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
427 | 2021-06-06 04:18:49 | canny | 1 | 28756 | 8 | 0.503 | 57169.0 |
426 | 2021-05-12 03:42:08 | canny | 1 | 28756 | 8 | 0.656 | 43835.4 |
425 | 2021-05-01 14:42:09 | canny | 1 | 28756 | 8 | 0.533 | 53951.2 |
424 | 2021-04-10 21:06:39 | canny | 1 | 28756 | 8 | 0.563 | 51076.4 |
423 | 2021-03-27 17:58:38 | canny | 2 | 53800 | 133 | 1.453 | 37026.8 |
422 | 2021-01-29 04:37:44 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
421 | 2021-01-27 17:43:04 | canny | 1 | 28756 | 8 | 0.516 | 55728.7 |
420 | 2021-01-27 02:26:21 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
419 | 2021-01-25 05:31:57 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
418 | 2020-12-12 16:44:14 | canny | 2 | 53800 | 133 | 1.406 | 38264.6 |
417 | 2020-10-26 21:26:54 | canny | 2 | 53800 | 133 | 1.643 | 32745.0 |
416 | 2020-10-26 10:00:57 | canny | 1 | 28756 | 8 | 0.486 | 59168.7 |
415 | 2020-10-13 07:17:47 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
414 | 2020-10-09 03:08:17 | canny | 1 | 28756 | 8 | 0.516 | 55728.7 |
413 | 2020-08-31 12:16:02 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
412 | 2020-08-28 17:02:40 | canny | 1 | 28756 | 8 | 0.533 | 53951.2 |
411 | 2020-08-24 23:53:04 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
410 | 2020-07-22 17:22:23 | canny | 1 | 28756 | 8 | 0.470 | 61183.0 |
409 | 2020-04-20 19:03:36 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
408 | 2020-03-26 05:56:02 | canny | 1 | 28756 | 8 | 0.513 | 56054.6 |
407 | 2020-03-25 04:09:38 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
406 | 2020-03-24 05:00:31 | canny | 1 | 28756 | 8 | 0.546 | 52666.7 |
405 | 2020-03-22 22:01:33 | canny | 1 | 28756 | 8 | 0.516 | 55728.7 |
404 | 2020-03-22 16:29:25 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
403 | 2020-03-22 10:14:38 | canny | 1 | 28756 | 8 | 0.456 | 63061.4 |
402 | 2020-03-21 04:14:48 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
401 | 2020-03-18 03:00:10 | canny | 1 | 28756 | 8 | 0.516 | 55728.7 |
400 | 2020-02-23 15:12:21 | canny | 1 | 28756 | 8 | 0.563 | 51076.4 |
399 | 2020-02-23 12:53:51 | canny | 1 | 28756 | 8 | 0.530 | 54256.6 |
398 | 2020-02-23 10:52:03 | canny | 1 | 28756 | 8 | 0.546 | 52666.7 |
397 | 2020-02-18 20:33:50 | canny | 1 | 28756 | 8 | 0.593 | 48492.4 |
396 | 2020-02-16 10:55:58 | canny | 1 | 28756 | 8 | 0.453 | 63479.0 |
395 | 2020-02-11 14:26:27 | canny | 1 | 28756 | 8 | 0.593 | 48492.4 |
394 | 2020-02-08 14:20:40 | canny | 1 | 28756 | 8 | 0.640 | 44931.3 |
393 | 2020-02-02 01:26:53 | canny | 1 | 28756 | 8 | 0.560 | 51350.0 |
392 | 2020-01-30 23:43:35 | canny | 1 | 28756 | 8 | 0.783 | 36725.4 |
391 | 2020-01-29 05:04:02 | canny | 1 | 28756 | 8 | 0.500 | 57512.0 |
390 | 2020-01-23 20:04:08 | canny | 1 | 28756 | 8 | 1.186 | 24246.2 |