History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"villa"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
504 | 2024-04-19 02:46:31 | villa | 1 | 28756 | 7 | 0.486 | 59168.7 |
503 | 2024-04-04 23:24:58 | villa | 1 | 28756 | 7 | 2.140 | 13437.4 |
502 | 2024-04-03 05:43:20 | villa | 2 | 53800 | 115 | 5.360 | 10037.3 |
501 | 2024-04-03 05:34:40 | villa | 1 | 28756 | 7 | 0.533 | 53951.2 |
500 | 2024-03-31 15:52:11 | villa | 1 | 28756 | 7 | 0.953 | 30174.2 |
499 | 2024-03-29 09:24:59 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
498 | 2024-03-03 21:44:57 | villa | 1 | 28756 | 7 | 0.420 | 68466.7 |
497 | 2024-03-01 12:11:19 | villa | 1 | 28756 | 7 | 0.423 | 67981.1 |
496 | 2024-02-28 07:26:23 | villa | 2 | 53800 | 115 | 1.593 | 33772.8 |
495 | 2024-02-28 07:26:19 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
494 | 2024-01-29 07:17:23 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
493 | 2024-01-29 06:00:25 | villa | 1 | 28756 | 7 | 0.423 | 67981.1 |
492 | 2024-01-17 09:29:35 | villa | 1 | 28756 | 7 | 0.423 | 67981.1 |
491 | 2024-01-11 00:45:38 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
490 | 2024-01-04 20:45:33 | villa | 2 | 53800 | 115 | 1.420 | 37887.3 |
489 | 2023-12-27 06:30:26 | villa | 2 | 53800 | 115 | 1.313 | 40974.9 |
488 | 2023-12-22 22:53:15 | villa | 2 | 53800 | 115 | 1.296 | 41512.3 |
487 | 2023-12-21 21:52:16 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
486 | 2023-12-03 12:37:33 | villa | 1 | 28756 | 7 | 0.516 | 55728.7 |
485 | 2023-12-03 12:37:32 | villa | 1 | 28756 | 7 | 0.533 | 53951.2 |
484 | 2023-11-29 12:04:45 | villa | 2 | 53800 | 115 | 1.376 | 39098.8 |
483 | 2023-11-26 17:17:45 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
482 | 2023-11-14 03:33:14 | villa | 1 | 28756 | 7 | 0.420 | 68466.7 |
481 | 2023-11-12 10:47:34 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
480 | 2023-10-30 06:57:54 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
479 | 2023-10-22 02:07:35 | villa | 1 | 28756 | 7 | 0.423 | 67981.1 |
478 | 2023-10-19 00:25:59 | villa | 1 | 28756 | 7 | 0.466 | 61708.2 |
477 | 2023-10-11 22:31:19 | villa | 1 | 28756 | 7 | 0.406 | 70827.6 |
476 | 2023-10-05 04:09:10 | villa | 1 | 28756 | 7 | 0.516 | 55728.7 |
475 | 2023-09-30 09:35:44 | villa | 2 | 53800 | 115 | 1.576 | 34137.1 |
474 | 2023-09-29 10:26:49 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
473 | 2023-09-28 18:47:09 | villa | 2 | 53800 | 115 | 3.343 | 16093.3 |
472 | 2023-09-24 03:55:14 | villa | 2 | 53800 | 115 | 1.796 | 29955.5 |
471 | 2023-09-01 16:11:45 | villa | 1 | 28756 | 7 | 0.420 | 68466.7 |
470 | 2023-09-01 08:07:59 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
469 | 2023-08-29 00:09:42 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
468 | 2023-06-30 16:55:16 | villa | 2 | 53800 | 115 | 1.483 | 36277.8 |
467 | 2023-06-04 10:55:16 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
466 | 2023-05-07 06:27:46 | villa | 1 | 28756 | 7 | 0.406 | 70827.6 |
465 | 2023-05-04 14:28:26 | villa | 1 | 28756 | 7 | 0.453 | 63479.0 |
464 | 2023-03-28 12:49:30 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
463 | 2023-03-22 02:03:01 | villa | 2 | 53800 | 115 | 1.330 | 40451.1 |
462 | 2023-03-21 11:39:38 | villa | 1 | 28756 | 7 | 0.440 | 65354.5 |
461 | 2023-01-14 20:31:21 | villa | 1 | 28756 | 7 | 0.403 | 71354.8 |
460 | 2023-01-11 13:12:44 | villa | 1 | 28756 | 7 | 0.420 | 68466.7 |
459 | 2022-12-22 09:28:56 | villa | 2 | 53800 | 115 | 1.343 | 40059.6 |
458 | 2022-10-21 21:09:05 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
457 | 2022-09-19 16:13:40 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
456 | 2022-09-18 12:05:47 | villa | 1 | 28756 | 7 | 0.453 | 63479.0 |
455 | 2022-09-12 06:23:01 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
454 | 2022-09-10 10:49:48 | villa | 1 | 28756 | 7 | 0.423 | 67981.1 |
453 | 2022-09-09 06:15:23 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
452 | 2022-09-05 17:03:29 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
451 | 2022-09-03 19:03:00 | villa | 1 | 28756 | 7 | 0.453 | 63479.0 |
450 | 2022-08-22 23:20:17 | villa | 1 | 28756 | 7 | 0.440 | 65354.5 |
449 | 2022-08-19 14:35:22 | villa | 2 | 53800 | 115 | 1.373 | 39184.3 |
448 | 2022-08-17 05:38:09 | villa | 2 | 53800 | 115 | 1.343 | 40059.6 |
447 | 2022-08-14 23:47:36 | villa | 1 | 28756 | 7 | 0.563 | 51076.4 |
446 | 2022-08-08 02:52:02 | villa | 2 | 53800 | 115 | 1.313 | 40974.9 |
445 | 2022-08-06 22:27:06 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
444 | 2022-07-17 17:53:36 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
443 | 2022-07-03 08:56:04 | villa | 1 | 28756 | 7 | 0.423 | 67981.1 |
442 | 2022-07-02 21:35:38 | villa | 1 | 28756 | 7 | 0.423 | 67981.1 |
441 | 2022-07-02 06:32:06 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
440 | 2022-06-12 12:45:30 | villa | 1 | 28756 | 7 | 0.450 | 63902.2 |
439 | 2022-05-19 13:31:45 | villa | 2 | 53800 | 115 | 1.406 | 38264.6 |
438 | 2022-04-22 15:28:53 | villa | 1 | 28756 | 7 | 0.533 | 53951.2 |
437 | 2022-03-08 21:33:02 | villa | 2 | 53800 | 115 | 1.640 | 32804.9 |
436 | 2022-03-05 01:42:45 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
435 | 2022-03-02 22:37:44 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
434 | 2022-01-31 16:02:48 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
433 | 2022-01-06 11:10:20 | villa | 1 | 28756 | 7 | 0.513 | 56054.6 |
432 | 2021-12-16 19:51:38 | villa | 1 | 28756 | 7 | 1.033 | 27837.4 |
431 | 2021-11-20 13:19:02 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
430 | 2021-10-10 10:27:01 | villa | 1 | 28756 | 7 | 0.420 | 68466.7 |
429 | 2021-09-20 18:19:52 | villa | 1 | 28756 | 7 | 0.533 | 53951.2 |
428 | 2021-09-08 12:43:01 | villa | 1 | 28756 | 7 | 0.440 | 65354.5 |
427 | 2021-08-24 01:56:48 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
426 | 2021-06-17 15:22:13 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
425 | 2021-03-18 08:07:48 | villa | 1 | 28756 | 7 | 1.000 | 28756.0 |
424 | 2020-12-15 09:12:08 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
423 | 2020-10-24 15:09:58 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
422 | 2020-10-16 05:36:55 | villa | 1 | 28756 | 7 | 0.420 | 68466.7 |
421 | 2020-09-15 02:49:12 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
420 | 2020-09-10 11:07:45 | villa | 1 | 28756 | 7 | 0.653 | 44036.8 |
419 | 2020-09-07 04:00:31 | villa | 1 | 28756 | 7 | 0.440 | 65354.5 |
418 | 2020-09-04 21:14:05 | villa | 1 | 28756 | 7 | 0.466 | 61708.2 |
417 | 2020-09-01 15:18:31 | villa | 1 | 28756 | 7 | 0.530 | 54256.6 |
416 | 2020-08-28 05:55:50 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
415 | 2020-06-21 14:39:54 | villa | 1 | 28756 | 7 | 0.546 | 52666.7 |
414 | 2020-06-02 23:50:17 | villa | 1 | 28756 | 7 | 0.420 | 68466.7 |
413 | 2020-05-30 21:15:09 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
412 | 2020-04-08 21:47:53 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
411 | 2020-03-25 22:48:05 | villa | 1 | 28756 | 7 | 0.483 | 59536.2 |
410 | 2020-03-25 12:07:33 | villa | 1 | 28756 | 7 | 0.486 | 59168.7 |
409 | 2020-03-23 19:22:52 | villa | 1 | 28756 | 7 | 0.516 | 55728.7 |
408 | 2020-03-22 11:19:18 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |
407 | 2020-03-21 12:06:47 | villa | 1 | 28756 | 7 | 0.436 | 65954.1 |
406 | 2020-03-18 16:24:45 | villa | 1 | 28756 | 7 | 0.470 | 61183.0 |
405 | 2020-02-26 22:13:43 | villa | 1 | 28756 | 7 | 0.500 | 57512.0 |