History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"testa"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
476 | 2024-04-27 08:16:01 | testa | 1 | 28756 | 9 | 0.483 | 59536.2 |
475 | 2024-04-26 12:02:36 | testa | 1 | 28756 | 9 | 0.530 | 54256.6 |
474 | 2024-04-02 20:34:06 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
473 | 2024-03-31 03:18:18 | testa | 1 | 28756 | 9 | 0.466 | 61708.2 |
472 | 2024-03-29 03:03:05 | testa | 2 | 53800 | 103 | 1.750 | 30742.9 |
471 | 2024-03-28 19:53:29 | testa | 1 | 28756 | 9 | 0.513 | 56054.6 |
470 | 2024-03-28 19:53:18 | testa | 2 | 53800 | 103 | 1.703 | 31591.3 |
469 | 2024-03-28 19:53:14 | testa | 1 | 28756 | 9 | 0.563 | 51076.4 |
468 | 2024-03-05 10:00:47 | testa | 1 | 28756 | 9 | 0.580 | 49579.3 |
467 | 2024-03-02 18:00:32 | testa | 2 | 53800 | 103 | 6.170 | 8719.6 |
466 | 2024-03-02 17:54:16 | testa | 1 | 28756 | 9 | 1.030 | 27918.4 |
465 | 2024-03-01 11:58:29 | testa | 2 | 53800 | 103 | 1.580 | 34050.6 |
464 | 2024-02-27 19:31:19 | testa | 2 | 53800 | 103 | 1.953 | 27547.4 |
463 | 2024-02-26 09:50:30 | testa | 2 | 53800 | 103 | 1.753 | 30690.2 |
462 | 2024-02-26 09:50:25 | testa | 1 | 28756 | 9 | 0.580 | 49579.3 |
461 | 2024-02-01 11:21:01 | testa | 1 | 28756 | 9 | 0.466 | 61708.2 |
460 | 2024-01-28 21:23:00 | testa | 1 | 28756 | 9 | 0.483 | 59536.2 |
459 | 2024-01-27 05:51:57 | testa | 1 | 28756 | 9 | 0.513 | 56054.6 |
458 | 2024-01-15 13:32:52 | testa | 2 | 53800 | 103 | 1.860 | 28924.7 |
457 | 2024-01-08 00:21:37 | testa | 1 | 28756 | 9 | 0.466 | 61708.2 |
456 | 2024-01-07 11:13:30 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
455 | 2023-12-19 22:11:55 | testa | 1 | 28756 | 9 | 0.450 | 63902.2 |
454 | 2023-12-11 05:53:03 | testa | 2 | 53800 | 103 | 1.516 | 35488.1 |
453 | 2023-12-06 10:29:21 | testa | 2 | 53800 | 103 | 1.406 | 38264.6 |
452 | 2023-12-04 05:36:09 | testa | 1 | 28756 | 9 | 0.546 | 52666.7 |
451 | 2023-12-04 05:36:08 | testa | 1 | 28756 | 9 | 0.546 | 52666.7 |
450 | 2023-11-20 22:24:44 | testa | 2 | 53800 | 103 | 1.420 | 37887.3 |
449 | 2023-11-16 09:02:18 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
448 | 2023-11-15 16:48:58 | testa | 1 | 28756 | 9 | 0.470 | 61183.0 |
447 | 2023-11-11 07:46:03 | testa | 1 | 28756 | 9 | 0.440 | 65354.5 |
446 | 2023-11-07 08:00:52 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
445 | 2023-10-28 20:35:03 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
444 | 2023-10-28 03:56:41 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
443 | 2023-10-27 02:58:16 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
442 | 2023-10-23 03:05:23 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
441 | 2023-10-19 22:28:52 | testa | 1 | 28756 | 9 | 0.513 | 56054.6 |
440 | 2023-10-11 15:59:39 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
439 | 2023-10-05 03:31:49 | testa | 1 | 28756 | 9 | 0.530 | 54256.6 |
438 | 2023-09-26 09:02:50 | testa | 1 | 28756 | 9 | 0.440 | 65354.5 |
437 | 2023-09-26 02:10:39 | testa | 1 | 28756 | 9 | 0.516 | 55728.7 |
436 | 2023-09-01 22:53:35 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
435 | 2023-08-24 23:34:02 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
434 | 2023-08-23 10:51:19 | testa | 1 | 28756 | 9 | 0.513 | 56054.6 |
433 | 2023-08-22 01:00:16 | testa | 2 | 53800 | 103 | 1.373 | 39184.3 |
432 | 2023-05-22 13:44:16 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
431 | 2023-05-05 08:23:01 | testa | 1 | 28756 | 9 | 0.486 | 59168.7 |
430 | 2023-05-04 02:26:39 | testa | 2 | 53800 | 103 | 1.626 | 33087.3 |
429 | 2023-03-20 03:57:52 | testa | 1 | 28756 | 9 | 0.486 | 59168.7 |
428 | 2023-02-09 04:53:55 | testa | 2 | 53800 | 103 | 1.376 | 39098.8 |
427 | 2023-01-11 20:17:37 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
426 | 2023-01-07 03:27:18 | testa | 1 | 28756 | 9 | 0.483 | 59536.2 |
425 | 2022-11-20 23:15:30 | testa | 2 | 53800 | 103 | 1.593 | 33772.8 |
424 | 2022-10-02 06:34:55 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
423 | 2022-09-03 01:34:05 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
422 | 2022-09-02 06:25:07 | testa | 1 | 28756 | 9 | 0.530 | 54256.6 |
421 | 2022-08-30 19:39:05 | testa | 1 | 28756 | 9 | 0.440 | 65354.5 |
420 | 2022-08-15 03:03:43 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
419 | 2022-08-14 18:43:38 | testa | 1 | 28756 | 9 | 0.546 | 52666.7 |
418 | 2022-07-29 10:31:59 | testa | 1 | 28756 | 9 | 0.486 | 59168.7 |
417 | 2022-06-24 09:31:19 | testa | 2 | 53800 | 103 | 1.376 | 39098.8 |
416 | 2022-06-17 14:46:55 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
415 | 2022-05-17 15:05:36 | testa | 1 | 28756 | 9 | 0.580 | 49579.3 |
414 | 2022-04-16 11:22:23 | testa | 1 | 28756 | 9 | 0.486 | 59168.7 |
413 | 2022-02-07 22:05:21 | testa | 2 | 53800 | 103 | 1.436 | 37465.2 |
412 | 2022-02-03 11:21:43 | testa | 1 | 28756 | 9 | 0.530 | 54256.6 |
411 | 2021-12-28 11:03:57 | testa | 1 | 28756 | 9 | 0.516 | 55728.7 |
410 | 2021-11-27 09:24:28 | testa | 1 | 28756 | 9 | 0.486 | 59168.7 |
409 | 2021-11-13 02:03:31 | testa | 2 | 53800 | 103 | 1.656 | 32487.9 |
408 | 2021-10-11 00:18:03 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
407 | 2021-09-15 19:56:05 | testa | 2 | 53800 | 103 | 1.626 | 33087.3 |
406 | 2021-09-05 05:04:06 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
405 | 2021-09-04 17:07:15 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
404 | 2021-09-02 11:39:40 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
403 | 2021-09-01 21:28:27 | testa | 1 | 28756 | 9 | 0.940 | 30591.5 |
402 | 2021-08-15 23:07:57 | testa | 1 | 28756 | 9 | 0.500 | 57512.0 |
401 | 2021-05-27 10:16:41 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
400 | 2021-05-01 15:59:02 | testa | 1 | 28756 | 9 | 0.516 | 55728.7 |
399 | 2021-03-30 22:27:06 | testa | 1 | 28756 | 9 | 1.030 | 27918.4 |
398 | 2021-02-08 16:56:01 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
397 | 2021-01-14 13:21:53 | testa | 1 | 28756 | 9 | 0.466 | 61708.2 |
396 | 2020-11-01 06:19:17 | testa | 1 | 28756 | 9 | 0.440 | 65354.5 |
395 | 2020-10-23 21:48:34 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
394 | 2020-10-17 22:46:49 | testa | 1 | 28756 | 9 | 0.440 | 65354.5 |
393 | 2020-10-16 08:44:57 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
392 | 2020-10-03 19:25:31 | testa | 1 | 28756 | 9 | 0.440 | 65354.5 |
391 | 2020-08-01 04:29:44 | testa | 1 | 28756 | 9 | 0.530 | 54256.6 |
390 | 2020-07-15 09:42:29 | testa | 1 | 28756 | 9 | 0.450 | 63902.2 |
389 | 2020-04-25 09:49:52 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
388 | 2020-03-24 23:08:17 | testa | 1 | 28756 | 9 | 0.483 | 59536.2 |
387 | 2020-03-24 14:47:51 | testa | 1 | 28756 | 9 | 1.000 | 28756.0 |
386 | 2020-03-22 09:36:18 | testa | 1 | 28756 | 9 | 0.533 | 53951.2 |
385 | 2020-03-21 23:16:19 | testa | 1 | 28756 | 9 | 1.033 | 27837.4 |
384 | 2020-03-21 05:43:55 | testa | 1 | 28756 | 9 | 0.530 | 54256.6 |
383 | 2020-03-18 00:45:27 | testa | 1 | 28756 | 9 | 0.453 | 63479.0 |
382 | 2020-03-13 13:53:38 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
381 | 2020-02-25 06:26:05 | testa | 1 | 28756 | 9 | 1.110 | 25906.3 |
380 | 2020-02-24 10:34:18 | testa | 1 | 28756 | 9 | 0.436 | 65954.1 |
379 | 2020-02-18 15:17:52 | testa | 1 | 28756 | 9 | 0.546 | 52666.7 |
378 | 2020-02-12 21:08:45 | testa | 1 | 28756 | 9 | 0.576 | 49923.6 |
377 | 2020-02-10 14:57:31 | testa | 1 | 28756 | 9 | 1.156 | 24875.4 |