History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hound"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
449 | 2024-04-27 08:38:58 | hound | 1 | 28756 | 9 | 0.610 | 47141.0 |
448 | 2024-04-26 19:08:54 | hound | 1 | 28756 | 9 | 0.563 | 51076.4 |
447 | 2024-04-23 15:38:10 | hound | 1 | 28756 | 9 | 1.623 | 17717.8 |
446 | 2024-04-23 15:03:23 | hound | 1 | 28756 | 9 | 0.530 | 54256.6 |
445 | 2024-04-23 07:14:44 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
444 | 2024-04-05 18:37:20 | hound | 3 | 83667 | 1207 | 4.330 | 19322.6 |
443 | 2024-04-05 17:20:09 | hound | 3 | 83667 | 1207 | 6.953 | 12033.2 |
442 | 2024-04-05 17:20:10 | hound | 2 | 53800 | 85 | 2.096 | 25667.9 |
441 | 2024-04-05 17:18:12 | hound | 1 | 28756 | 9 | 0.876 | 32826.5 |
440 | 2024-03-31 15:13:38 | hound | 1 | 28756 | 9 | 1.050 | 27386.7 |
439 | 2024-03-29 21:02:09 | hound | 2 | 53800 | 85 | 1.623 | 33148.5 |
438 | 2024-03-29 21:01:49 | hound | 3 | 83667 | 1207 | 4.376 | 19119.5 |
437 | 2024-03-28 23:20:32 | hound | 3 | 83667 | 1207 | 3.970 | 21074.8 |
436 | 2024-03-28 23:20:33 | hound | 2 | 53800 | 85 | 1.640 | 32804.9 |
435 | 2024-03-28 23:20:24 | hound | 1 | 28756 | 9 | 0.546 | 52666.7 |
434 | 2024-03-28 23:20:03 | hound | 3 | 83667 | 1207 | 5.750 | 14550.8 |
433 | 2024-03-28 23:20:02 | hound | 2 | 53800 | 85 | 3.656 | 14715.5 |
432 | 2024-03-28 23:19:47 | hound | 1 | 28756 | 9 | 0.516 | 55728.7 |
431 | 2024-03-04 18:17:58 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
430 | 2024-03-01 12:18:52 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
429 | 2024-02-27 20:23:31 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
428 | 2024-02-03 18:38:59 | hound | 1 | 28756 | 9 | 0.986 | 29164.3 |
427 | 2024-02-01 09:42:49 | hound | 1 | 28756 | 9 | 1.060 | 27128.3 |
426 | 2024-01-29 07:21:12 | hound | 1 | 28756 | 9 | 0.546 | 52666.7 |
425 | 2024-01-28 20:22:45 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
424 | 2024-01-21 03:29:38 | hound | 1 | 28756 | 9 | 0.440 | 65354.5 |
423 | 2024-01-09 16:30:12 | hound | 3 | 83667 | 1207 | 4.126 | 20278.0 |
422 | 2024-01-09 16:30:08 | hound | 2 | 53800 | 85 | 1.733 | 31044.4 |
421 | 2023-12-30 18:08:10 | hound | 3 | 83667 | 1207 | 3.626 | 23074.2 |
420 | 2023-12-30 18:08:12 | hound | 2 | 53800 | 85 | 1.610 | 33416.1 |
419 | 2023-12-08 06:16:57 | hound | 2 | 53800 | 85 | 1.563 | 34421.0 |
418 | 2023-12-07 19:53:16 | hound | 3 | 83667 | 1207 | 3.310 | 25277.0 |
417 | 2023-12-07 19:53:12 | hound | 3 | 83667 | 1207 | 3.610 | 23176.5 |
416 | 2023-12-06 13:32:50 | hound | 3 | 83667 | 1207 | 3.346 | 25005.1 |
415 | 2023-11-26 21:42:04 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
414 | 2023-11-15 07:25:40 | hound | 1 | 28756 | 9 | 0.530 | 54256.6 |
413 | 2023-11-14 02:18:38 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
412 | 2023-11-03 14:32:27 | hound | 1 | 28756 | 9 | 0.516 | 55728.7 |
411 | 2023-10-28 04:09:45 | hound | 3 | 83667 | 1207 | 3.436 | 24350.1 |
410 | 2023-10-28 04:05:26 | hound | 2 | 53800 | 85 | 5.780 | 9308.0 |
409 | 2023-10-19 20:39:44 | hound | 1 | 28756 | 9 | 0.466 | 61708.2 |
408 | 2023-10-19 14:35:30 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
407 | 2023-10-14 13:26:55 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
406 | 2023-09-29 06:54:59 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
405 | 2023-09-27 00:48:25 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
404 | 2023-09-13 00:23:41 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
403 | 2023-06-17 22:19:05 | hound | 1 | 28756 | 9 | 0.470 | 61183.0 |
402 | 2023-06-13 07:32:15 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
401 | 2023-04-04 14:05:43 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
400 | 2023-02-25 07:50:48 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
399 | 2023-01-17 02:54:20 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
398 | 2022-11-12 23:56:42 | hound | 1 | 28756 | 9 | 0.530 | 54256.6 |
397 | 2022-11-08 11:12:08 | hound | 1 | 28756 | 9 | 0.533 | 53951.2 |
396 | 2022-11-04 23:26:10 | hound | 1 | 28756 | 9 | 0.440 | 65354.5 |
395 | 2022-07-19 02:33:17 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
394 | 2022-07-03 22:50:32 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
393 | 2022-05-18 15:37:04 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
392 | 2022-03-25 01:50:20 | hound | 1 | 28756 | 9 | 0.516 | 55728.7 |
391 | 2022-03-08 19:03:48 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
390 | 2021-12-19 06:34:06 | hound | 1 | 28756 | 9 | 0.466 | 61708.2 |
389 | 2021-12-17 03:24:27 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
388 | 2021-12-10 23:56:36 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
387 | 2021-10-24 06:21:18 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
386 | 2021-09-29 09:11:58 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
385 | 2021-09-06 22:20:38 | hound | 1 | 28756 | 9 | 0.486 | 59168.7 |
384 | 2021-06-26 20:36:46 | hound | 1 | 28756 | 9 | 0.486 | 59168.7 |
383 | 2021-06-05 22:32:25 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
382 | 2021-05-09 15:29:56 | hound | 1 | 28756 | 9 | 0.486 | 59168.7 |
381 | 2021-04-08 06:38:27 | hound | 1 | 28756 | 9 | 0.486 | 59168.7 |
380 | 2021-03-03 19:55:43 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
379 | 2021-02-22 01:12:59 | hound | 2 | 53800 | 85 | 1.546 | 34799.5 |
378 | 2021-01-23 05:43:25 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
377 | 2020-11-28 08:48:31 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
376 | 2020-11-14 07:24:53 | hound | 1 | 28756 | 9 | 0.470 | 61183.0 |
375 | 2020-10-03 06:16:02 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
374 | 2020-09-17 09:05:34 | hound | 1 | 28756 | 9 | 0.470 | 61183.0 |
373 | 2020-09-10 06:28:32 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
372 | 2020-09-05 03:36:40 | hound | 1 | 28756 | 9 | 0.440 | 65354.5 |
371 | 2020-09-02 01:38:25 | hound | 1 | 28756 | 9 | 0.450 | 63902.2 |
370 | 2020-08-28 21:10:37 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
369 | 2020-08-28 15:13:21 | hound | 1 | 28756 | 9 | 0.466 | 61708.2 |
368 | 2020-08-22 03:19:09 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
367 | 2020-07-27 02:46:14 | hound | 1 | 28756 | 9 | 0.470 | 61183.0 |
366 | 2020-07-25 02:29:06 | hound | 1 | 28756 | 9 | 0.470 | 61183.0 |
365 | 2020-05-20 19:41:53 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
364 | 2020-05-10 09:26:07 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
363 | 2020-04-02 11:02:58 | hound | 1 | 28756 | 9 | 0.483 | 59536.2 |
362 | 2020-03-26 03:29:45 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
361 | 2020-03-25 06:13:50 | hound | 1 | 28756 | 9 | 0.750 | 38341.3 |
360 | 2020-03-23 02:59:00 | hound | 1 | 28756 | 9 | 0.516 | 55728.7 |
359 | 2020-03-23 01:50:55 | hound | 1 | 28756 | 9 | 0.453 | 63479.0 |
358 | 2020-03-21 14:26:20 | hound | 1 | 28756 | 9 | 0.513 | 56054.6 |
357 | 2020-03-18 15:12:46 | hound | 1 | 28756 | 9 | 0.500 | 57512.0 |
356 | 2020-03-06 21:11:42 | hound | 1 | 28756 | 9 | 0.436 | 65954.1 |
355 | 2020-02-29 08:24:10 | hound | 1 | 28756 | 9 | 0.576 | 49923.6 |
354 | 2020-02-28 17:52:50 | hound | 1 | 28756 | 9 | 0.936 | 30722.2 |
353 | 2020-02-26 06:44:38 | hound | 1 | 28756 | 9 | 0.563 | 51076.4 |
352 | 2020-02-20 01:27:44 | hound | 1 | 28756 | 9 | 1.796 | 16011.1 |
351 | 2020-02-17 19:16:48 | hound | 1 | 28756 | 9 | 0.530 | 54256.6 |
350 | 2020-02-13 20:22:39 | hound | 1 | 28756 | 9 | 0.550 | 52283.6 |