History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
480 | 2024-05-04 02:16:59 | perry | 1 | 28756 | 14 | 0.530 | 54256.6 |
479 | 2024-05-03 23:15:56 | perry | 1 | 28756 | 14 | 1.703 | 16885.5 |
478 | 2024-04-29 12:37:04 | perry | 1 | 28756 | 14 | 0.516 | 55728.7 |
477 | 2024-04-26 16:50:35 | perry | 1 | 28756 | 14 | 0.530 | 54256.6 |
476 | 2024-04-12 15:38:14 | perry | 2 | 53800 | 124 | 4.063 | 13241.4 |
475 | 2024-04-12 15:36:34 | perry | 2 | 53800 | 124 | 3.923 | 13714.0 |
474 | 2024-04-08 16:32:32 | perry | 1 | 28756 | 14 | 1.000 | 28756.0 |
473 | 2024-04-07 23:17:24 | perry | 1 | 28756 | 14 | 1.153 | 24940.2 |
472 | 2024-04-07 23:14:52 | perry | 1 | 28756 | 14 | 1.140 | 25224.6 |
471 | 2024-04-03 02:58:00 | perry | 2 | 53800 | 124 | 4.143 | 12985.8 |
470 | 2024-04-03 02:40:27 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
469 | 2024-03-31 03:25:35 | perry | 1 | 28756 | 14 | 0.580 | 49579.3 |
468 | 2024-03-29 05:41:51 | perry | 1 | 28756 | 14 | 0.580 | 49579.3 |
467 | 2024-03-29 01:20:22 | perry | 2 | 53800 | 124 | 3.126 | 17210.5 |
466 | 2024-03-29 01:15:24 | perry | 1 | 28756 | 14 | 0.546 | 52666.7 |
465 | 2024-03-08 19:08:19 | perry | 1 | 28756 | 14 | 1.156 | 24875.4 |
464 | 2024-03-03 20:51:12 | perry | 1 | 28756 | 14 | 0.546 | 52666.7 |
463 | 2024-03-01 01:46:20 | perry | 1 | 28756 | 14 | 0.530 | 54256.6 |
462 | 2024-02-27 20:10:56 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
461 | 2024-02-06 22:16:17 | perry | 1 | 28756 | 14 | 0.516 | 55728.7 |
460 | 2024-02-02 18:48:15 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
459 | 2024-01-28 18:10:05 | perry | 1 | 28756 | 14 | 0.593 | 48492.4 |
458 | 2024-01-09 17:02:16 | perry | 2 | 53800 | 124 | 1.466 | 36698.5 |
457 | 2024-01-07 18:03:01 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
456 | 2023-12-27 07:33:31 | perry | 1 | 28756 | 14 | 0.483 | 59536.2 |
455 | 2023-12-13 11:30:01 | perry | 2 | 53800 | 124 | 1.500 | 35866.7 |
454 | 2023-11-21 20:41:52 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
453 | 2023-11-20 12:20:53 | perry | 1 | 28756 | 14 | 0.563 | 51076.4 |
452 | 2023-11-16 06:08:00 | perry | 1 | 28756 | 14 | 0.513 | 56054.6 |
451 | 2023-11-03 14:51:51 | perry | 1 | 28756 | 14 | 0.513 | 56054.6 |
450 | 2023-10-23 18:53:48 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
449 | 2023-10-19 18:52:36 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
448 | 2023-10-16 13:58:59 | perry | 1 | 28756 | 14 | 0.440 | 65354.5 |
447 | 2023-10-15 18:47:55 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
446 | 2023-10-04 15:00:19 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
445 | 2023-09-24 18:55:45 | perry | 2 | 53800 | 124 | 1.376 | 39098.8 |
444 | 2023-09-22 17:43:40 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
443 | 2023-09-19 12:01:09 | perry | 1 | 28756 | 14 | 0.983 | 29253.3 |
442 | 2023-09-10 19:35:35 | perry | 2 | 53800 | 124 | 1.610 | 33416.1 |
441 | 2023-08-11 06:31:00 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
440 | 2023-07-23 10:55:16 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
439 | 2023-05-26 14:03:10 | perry | 2 | 53800 | 124 | 1.360 | 39558.8 |
438 | 2023-05-12 11:37:24 | perry | 1 | 28756 | 14 | 0.483 | 59536.2 |
437 | 2023-03-31 14:04:44 | perry | 1 | 28756 | 14 | 0.470 | 61183.0 |
436 | 2023-03-06 11:57:56 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
435 | 2023-03-05 07:32:20 | perry | 2 | 53800 | 124 | 1.360 | 39558.8 |
434 | 2023-01-06 17:00:57 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
433 | 2022-12-30 00:19:11 | perry | 1 | 28756 | 14 | 0.440 | 65354.5 |
432 | 2022-12-28 12:51:48 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
431 | 2022-12-12 03:28:59 | perry | 2 | 53800 | 124 | 1.563 | 34421.0 |
430 | 2022-12-09 11:18:02 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
429 | 2022-09-20 07:16:12 | perry | 1 | 28756 | 14 | 0.483 | 59536.2 |
428 | 2022-08-12 12:01:23 | perry | 1 | 28756 | 14 | 0.440 | 65354.5 |
427 | 2022-07-13 08:37:41 | perry | 2 | 53800 | 124 | 1.483 | 36277.8 |
426 | 2022-04-30 01:29:15 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
425 | 2022-04-11 12:09:15 | perry | 1 | 28756 | 14 | 0.513 | 56054.6 |
424 | 2022-04-08 01:16:00 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
423 | 2022-02-19 22:24:36 | perry | 2 | 53800 | 124 | 1.610 | 33416.1 |
422 | 2022-02-17 19:16:57 | perry | 2 | 53800 | 124 | 1.393 | 38621.7 |
421 | 2022-01-21 07:47:56 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
420 | 2021-12-17 14:56:43 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
419 | 2021-11-14 20:10:06 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
418 | 2021-11-14 05:53:14 | perry | 2 | 53800 | 124 | 1.403 | 38346.4 |
417 | 2021-11-12 18:34:21 | perry | 1 | 28756 | 14 | 0.623 | 46157.3 |
416 | 2021-10-04 16:00:26 | perry | 1 | 28756 | 14 | 0.516 | 55728.7 |
415 | 2021-10-02 12:54:49 | perry | 1 | 28756 | 14 | 0.440 | 65354.5 |
414 | 2021-09-17 00:09:39 | perry | 2 | 53800 | 124 | 1.563 | 34421.0 |
413 | 2021-09-07 03:38:19 | perry | 1 | 28756 | 14 | 0.486 | 59168.7 |
412 | 2021-08-28 21:45:06 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
411 | 2021-08-15 04:35:45 | perry | 2 | 53800 | 124 | 1.376 | 39098.8 |
410 | 2021-08-13 16:14:01 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
409 | 2021-06-06 04:44:34 | perry | 1 | 28756 | 14 | 0.456 | 63061.4 |
408 | 2021-06-03 00:02:42 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
407 | 2021-05-20 06:58:43 | perry | 1 | 28756 | 14 | 0.516 | 55728.7 |
406 | 2021-04-20 11:48:23 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
405 | 2021-02-28 12:16:41 | perry | 1 | 28756 | 14 | 0.470 | 61183.0 |
404 | 2021-02-25 12:38:40 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
403 | 2021-02-21 16:54:59 | perry | 1 | 28756 | 14 | 0.486 | 59168.7 |
402 | 2020-12-07 23:41:17 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
401 | 2020-11-28 16:20:48 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
400 | 2020-10-18 08:44:03 | perry | 1 | 28756 | 14 | 0.470 | 61183.0 |
399 | 2020-10-16 13:21:43 | perry | 1 | 28756 | 14 | 0.456 | 63061.4 |
398 | 2020-10-15 14:51:41 | perry | 1 | 28756 | 14 | 0.516 | 55728.7 |
397 | 2020-10-09 08:16:08 | perry | 2 | 53800 | 124 | 1.390 | 38705.0 |
396 | 2020-09-27 00:16:40 | perry | 1 | 28756 | 14 | 0.513 | 56054.6 |
395 | 2020-09-10 06:58:47 | perry | 1 | 28756 | 14 | 0.453 | 63479.0 |
394 | 2020-09-04 15:11:37 | perry | 1 | 28756 | 14 | 0.486 | 59168.7 |
393 | 2020-08-29 23:40:23 | perry | 1 | 28756 | 14 | 0.436 | 65954.1 |
392 | 2020-08-25 12:35:44 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
391 | 2020-07-20 23:55:37 | perry | 1 | 28756 | 14 | 0.470 | 61183.0 |
390 | 2020-07-20 17:40:21 | perry | 1 | 28756 | 14 | 0.543 | 52957.6 |
389 | 2020-06-16 17:18:19 | perry | 1 | 28756 | 14 | 0.533 | 53951.2 |
388 | 2020-05-24 02:51:18 | perry | 1 | 28756 | 14 | 0.483 | 59536.2 |
387 | 2020-03-27 08:17:22 | perry | 1 | 28756 | 14 | 0.483 | 59536.2 |
386 | 2020-03-25 00:23:26 | perry | 1 | 28756 | 14 | 0.486 | 59168.7 |
385 | 2020-03-24 08:23:37 | perry | 1 | 28756 | 14 | 0.470 | 61183.0 |
384 | 2020-03-22 09:33:57 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
383 | 2020-03-21 16:28:58 | perry | 1 | 28756 | 14 | 0.483 | 59536.2 |
382 | 2020-03-21 02:39:50 | perry | 1 | 28756 | 14 | 0.500 | 57512.0 |
381 | 2020-03-18 01:55:06 | perry | 1 | 28756 | 14 | 0.466 | 61708.2 |