History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sward"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
475 | 2024-04-20 14:24:21 | sward | 1 | 28756 | 11 | 0.860 | 33437.2 |
474 | 2024-04-20 14:16:45 | sward | 1 | 28756 | 11 | 0.546 | 52666.7 |
473 | 2024-04-20 13:58:18 | sward | 1 | 28756 | 11 | 1.076 | 26724.9 |
472 | 2024-04-18 15:14:43 | sward | 1 | 28756 | 11 | 1.486 | 19351.3 |
471 | 2024-04-17 03:00:12 | sward | 1 | 28756 | 11 | 0.466 | 61708.2 |
470 | 2024-04-03 15:35:21 | sward | 1 | 28756 | 11 | 1.063 | 27051.7 |
469 | 2024-04-03 15:35:02 | sward | 2 | 53800 | 157 | 5.326 | 10101.4 |
468 | 2024-04-03 15:34:50 | sward | 1 | 28756 | 11 | 1.186 | 24246.2 |
467 | 2024-03-31 03:39:36 | sward | 1 | 28756 | 11 | 1.060 | 27128.3 |
466 | 2024-03-29 08:40:47 | sward | 1 | 28756 | 11 | 0.560 | 51350.0 |
465 | 2024-03-04 09:41:24 | sward | 2 | 53800 | 157 | 1.906 | 28226.7 |
464 | 2024-03-04 06:39:15 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
463 | 2024-02-28 02:34:45 | sward | 1 | 28756 | 11 | 0.576 | 49923.6 |
462 | 2024-02-03 03:47:07 | sward | 1 | 28756 | 11 | 0.516 | 55728.7 |
461 | 2024-02-01 10:23:28 | sward | 1 | 28756 | 11 | 0.486 | 59168.7 |
460 | 2024-01-28 22:46:57 | sward | 1 | 28756 | 11 | 0.516 | 55728.7 |
459 | 2024-01-28 22:24:15 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
458 | 2024-01-18 08:42:52 | sward | 2 | 53800 | 157 | 1.390 | 38705.0 |
457 | 2024-01-12 19:54:31 | sward | 2 | 53800 | 157 | 1.360 | 39558.8 |
456 | 2023-12-29 08:31:16 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
455 | 2023-12-22 10:42:18 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
454 | 2023-12-04 14:52:40 | sward | 1 | 28756 | 11 | 0.483 | 59536.2 |
453 | 2023-12-04 14:52:39 | sward | 1 | 28756 | 11 | 0.440 | 65354.5 |
452 | 2023-11-27 09:05:31 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
451 | 2023-11-21 11:08:36 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
450 | 2023-11-18 16:07:33 | sward | 1 | 28756 | 11 | 0.470 | 61183.0 |
449 | 2023-11-18 03:06:17 | sward | 1 | 28756 | 11 | 0.466 | 61708.2 |
448 | 2023-11-11 12:06:30 | sward | 1 | 28756 | 11 | 0.876 | 32826.5 |
447 | 2023-10-22 13:36:30 | sward | 2 | 53800 | 157 | 1.423 | 37807.4 |
446 | 2023-10-20 06:39:39 | sward | 1 | 28756 | 11 | 0.483 | 59536.2 |
445 | 2023-10-18 00:30:17 | sward | 1 | 28756 | 11 | 0.466 | 61708.2 |
444 | 2023-10-11 16:50:08 | sward | 1 | 28756 | 11 | 0.483 | 59536.2 |
443 | 2023-10-05 17:27:41 | sward | 1 | 28756 | 11 | 0.513 | 56054.6 |
442 | 2023-09-27 05:11:23 | sward | 2 | 53800 | 157 | 1.546 | 34799.5 |
441 | 2023-09-25 00:27:16 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
440 | 2023-09-19 17:32:16 | sward | 1 | 28756 | 11 | 0.486 | 59168.7 |
439 | 2023-09-12 12:57:17 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
438 | 2023-09-12 08:13:36 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
437 | 2023-08-01 20:34:09 | sward | 2 | 53800 | 157 | 1.360 | 39558.8 |
436 | 2023-06-19 12:03:08 | sward | 1 | 28756 | 11 | 0.483 | 59536.2 |
435 | 2023-05-16 11:21:42 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
434 | 2023-05-12 21:26:38 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
433 | 2023-04-08 20:31:22 | sward | 2 | 53800 | 157 | 1.533 | 35094.6 |
432 | 2023-04-03 01:02:38 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
431 | 2023-01-15 22:53:26 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
430 | 2023-01-15 14:18:05 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
429 | 2023-01-04 10:59:21 | sward | 2 | 53800 | 157 | 1.343 | 40059.6 |
428 | 2022-11-04 18:49:50 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
427 | 2022-09-10 08:09:04 | sward | 1 | 28756 | 11 | 0.486 | 59168.7 |
426 | 2022-09-06 09:31:03 | sward | 2 | 53800 | 157 | 1.376 | 39098.8 |
425 | 2022-07-29 02:46:09 | sward | 1 | 28756 | 11 | 0.486 | 59168.7 |
424 | 2022-07-19 11:19:41 | sward | 2 | 53800 | 157 | 1.500 | 35866.7 |
423 | 2022-07-18 19:52:36 | sward | 1 | 28756 | 11 | 0.623 | 46157.3 |
422 | 2022-07-17 23:38:56 | sward | 1 | 28756 | 11 | 0.466 | 61708.2 |
421 | 2022-07-03 03:40:56 | sward | 1 | 28756 | 11 | 0.530 | 54256.6 |
420 | 2022-06-24 17:58:29 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
419 | 2022-06-08 23:27:03 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
418 | 2022-06-01 20:18:43 | sward | 2 | 53800 | 157 | 1.546 | 34799.5 |
417 | 2022-05-02 22:30:18 | sward | 2 | 53800 | 157 | 1.720 | 31279.1 |
416 | 2022-04-23 16:56:19 | sward | 1 | 28756 | 11 | 0.440 | 65354.5 |
415 | 2022-03-29 19:31:32 | sward | 2 | 53800 | 157 | 1.623 | 33148.5 |
414 | 2022-03-01 22:06:13 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
413 | 2022-01-01 00:14:06 | sward | 1 | 28756 | 11 | 0.533 | 53951.2 |
412 | 2021-12-16 17:53:26 | sward | 1 | 28756 | 11 | 0.486 | 59168.7 |
411 | 2021-12-14 12:39:43 | sward | 2 | 53800 | 157 | 1.530 | 35163.4 |
410 | 2021-12-12 10:39:22 | sward | 2 | 53800 | 157 | 1.766 | 30464.3 |
409 | 2021-10-25 20:59:30 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
408 | 2021-09-30 23:51:40 | sward | 2 | 53800 | 157 | 1.420 | 37887.3 |
407 | 2021-09-15 06:48:15 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
406 | 2021-09-11 20:30:44 | sward | 1 | 28756 | 11 | 0.516 | 55728.7 |
405 | 2021-08-25 05:41:44 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
404 | 2021-06-27 10:59:01 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
403 | 2021-06-15 07:15:29 | sward | 1 | 28756 | 11 | 0.533 | 53951.2 |
402 | 2021-06-09 00:05:15 | sward | 1 | 28756 | 11 | 0.486 | 59168.7 |
401 | 2021-03-20 11:48:24 | sward | 2 | 53800 | 157 | 1.580 | 34050.6 |
400 | 2021-03-15 22:16:19 | sward | 1 | 28756 | 11 | 0.530 | 54256.6 |
399 | 2021-02-20 20:32:03 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
398 | 2021-01-01 22:31:51 | sward | 2 | 53800 | 157 | 1.576 | 34137.1 |
397 | 2020-12-30 03:22:25 | sward | 1 | 28756 | 11 | 0.440 | 65354.5 |
396 | 2020-12-09 04:57:34 | sward | 1 | 28756 | 11 | 0.436 | 65954.1 |
395 | 2020-12-02 10:26:21 | sward | 1 | 28756 | 11 | 0.450 | 63902.2 |
394 | 2020-11-15 00:25:42 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
393 | 2020-11-02 06:29:36 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
392 | 2020-10-28 02:26:30 | sward | 2 | 53800 | 157 | 1.546 | 34799.5 |
391 | 2020-10-19 19:20:11 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
390 | 2020-10-17 20:13:23 | sward | 2 | 53800 | 157 | 1.483 | 36277.8 |
389 | 2020-10-05 11:44:37 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
388 | 2020-09-06 03:53:14 | sward | 1 | 28756 | 11 | 0.440 | 65354.5 |
387 | 2020-08-31 17:45:00 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
386 | 2020-08-19 19:08:21 | sward | 2 | 53800 | 157 | 1.436 | 37465.2 |
385 | 2020-08-10 02:49:01 | sward | 1 | 28756 | 11 | 0.466 | 61708.2 |
384 | 2020-08-02 04:15:46 | sward | 1 | 28756 | 11 | 0.516 | 55728.7 |
383 | 2020-07-29 06:54:16 | sward | 1 | 28756 | 11 | 0.516 | 55728.7 |
382 | 2020-07-26 12:09:26 | sward | 1 | 28756 | 11 | 0.466 | 61708.2 |
381 | 2020-05-31 19:03:37 | sward | 1 | 28756 | 11 | 0.500 | 57512.0 |
380 | 2020-04-21 06:40:45 | sward | 1 | 28756 | 11 | 0.453 | 63479.0 |
379 | 2020-04-01 19:12:55 | sward | 1 | 28756 | 11 | 0.483 | 59536.2 |
378 | 2020-03-25 12:03:34 | sward | 1 | 28756 | 11 | 0.546 | 52666.7 |
377 | 2020-03-24 17:30:47 | sward | 1 | 28756 | 11 | 0.546 | 52666.7 |
376 | 2020-03-23 12:29:40 | sward | 1 | 28756 | 11 | 0.516 | 55728.7 |