History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"natch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
463 | 2024-04-06 13:46:09 | natch | 1 | 28756 | 12 | 0.563 | 51076.4 |
462 | 2024-03-31 07:46:34 | natch | 1 | 28756 | 12 | 0.483 | 59536.2 |
461 | 2024-03-30 14:03:25 | natch | 2 | 53800 | 79 | 1.843 | 29191.5 |
460 | 2024-03-30 14:02:27 | natch | 3 | 83667 | 767 | 4.686 | 17854.7 |
459 | 2024-03-29 01:36:29 | natch | 1 | 28756 | 12 | 1.700 | 16915.3 |
458 | 2024-03-25 02:22:01 | natch | 2 | 53800 | 79 | 1.656 | 32487.9 |
457 | 2024-03-25 02:21:37 | natch | 3 | 83667 | 767 | 3.703 | 22594.4 |
456 | 2024-03-20 02:21:21 | natch | 3 | 83667 | 767 | 6.780 | 12340.3 |
455 | 2024-03-20 02:21:22 | natch | 2 | 53800 | 79 | 3.610 | 14903.0 |
454 | 2024-03-20 02:21:10 | natch | 2 | 53800 | 79 | 1.766 | 30464.3 |
453 | 2024-03-20 02:21:11 | natch | 1 | 28756 | 12 | 1.093 | 26309.2 |
452 | 2024-03-20 02:20:46 | natch | 3 | 83667 | 767 | 4.596 | 18204.3 |
451 | 2024-03-07 10:47:20 | natch | 3 | 83667 | 767 | 7.000 | 11952.4 |
450 | 2024-03-07 10:47:18 | natch | 2 | 53800 | 79 | 3.310 | 16253.8 |
449 | 2024-03-07 06:42:19 | natch | 1 | 28756 | 12 | 0.530 | 54256.6 |
448 | 2024-03-05 22:29:52 | natch | 1 | 28756 | 12 | 1.233 | 23322.0 |
447 | 2024-03-01 04:05:00 | natch | 1 | 28756 | 12 | 0.686 | 41918.4 |
446 | 2024-02-27 20:31:43 | natch | 1 | 28756 | 12 | 0.513 | 56054.6 |
445 | 2024-02-05 19:21:02 | natch | 1 | 28756 | 12 | 0.530 | 54256.6 |
444 | 2024-02-03 17:52:35 | natch | 1 | 28756 | 12 | 0.516 | 55728.7 |
443 | 2024-01-11 17:34:17 | natch | 3 | 83667 | 767 | 3.813 | 21942.6 |
442 | 2024-01-01 17:46:21 | natch | 3 | 83667 | 767 | 4.093 | 20441.5 |
441 | 2024-01-01 17:46:20 | natch | 2 | 53800 | 79 | 1.690 | 31834.3 |
440 | 2024-01-01 04:25:19 | natch | 2 | 53800 | 79 | 1.420 | 37887.3 |
439 | 2023-12-20 05:47:03 | natch | 3 | 83667 | 767 | 3.313 | 25254.2 |
438 | 2023-12-20 05:47:01 | natch | 2 | 53800 | 79 | 1.390 | 38705.0 |
437 | 2023-11-30 19:00:24 | natch | 1 | 28756 | 12 | 0.500 | 57512.0 |
436 | 2023-11-27 09:33:12 | natch | 1 | 28756 | 12 | 0.436 | 65954.1 |
435 | 2023-11-14 16:29:04 | natch | 1 | 28756 | 12 | 0.500 | 57512.0 |
434 | 2023-11-11 21:39:28 | natch | 1 | 28756 | 12 | 0.436 | 65954.1 |
433 | 2023-11-03 11:23:58 | natch | 1 | 28756 | 12 | 0.486 | 59168.7 |
432 | 2023-10-22 13:49:22 | natch | 1 | 28756 | 12 | 0.513 | 56054.6 |
431 | 2023-10-19 23:08:28 | natch | 3 | 83667 | 767 | 4.576 | 18283.9 |
430 | 2023-10-18 18:53:49 | natch | 3 | 83667 | 767 | 6.953 | 12033.2 |
429 | 2023-10-17 07:43:38 | natch | 1 | 28756 | 12 | 1.156 | 24875.4 |
428 | 2023-10-17 06:42:44 | natch | 2 | 53800 | 79 | 1.576 | 34137.1 |
427 | 2023-10-16 20:14:10 | natch | 3 | 83667 | 767 | 9.550 | 8760.9 |
426 | 2023-10-15 20:13:24 | natch | 3 | 83667 | 767 | 3.343 | 25027.5 |
425 | 2023-10-10 23:06:27 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
424 | 2023-10-05 19:58:16 | natch | 1 | 28756 | 12 | 0.483 | 59536.2 |
423 | 2023-10-05 04:51:17 | natch | 2 | 53800 | 79 | 1.453 | 37026.8 |
422 | 2023-09-27 08:46:27 | natch | 1 | 28756 | 12 | 0.530 | 54256.6 |
421 | 2023-09-15 23:44:09 | natch | 1 | 28756 | 12 | 0.563 | 51076.4 |
420 | 2023-09-13 14:09:55 | natch | 1 | 28756 | 12 | 0.516 | 55728.7 |
419 | 2023-07-28 08:07:48 | natch | 3 | 83667 | 767 | 3.360 | 24900.9 |
418 | 2023-07-16 11:11:54 | natch | 2 | 53800 | 79 | 1.390 | 38705.0 |
417 | 2023-07-06 23:18:41 | natch | 1 | 28756 | 12 | 0.436 | 65954.1 |
416 | 2023-04-11 17:53:14 | natch | 1 | 28756 | 12 | 0.440 | 65354.5 |
415 | 2023-04-08 20:57:18 | natch | 3 | 83667 | 767 | 3.250 | 25743.7 |
414 | 2023-03-31 04:56:23 | natch | 2 | 53800 | 79 | 1.576 | 34137.1 |
413 | 2023-02-04 20:29:51 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
412 | 2023-01-30 11:26:09 | natch | 2 | 53800 | 79 | 1.356 | 39675.5 |
411 | 2023-01-14 09:00:05 | natch | 3 | 83667 | 767 | 3.283 | 25484.9 |
410 | 2022-12-27 17:27:13 | natch | 2 | 53800 | 79 | 1.376 | 39098.8 |
409 | 2022-12-02 19:56:52 | natch | 1 | 28756 | 12 | 0.500 | 57512.0 |
408 | 2022-11-25 03:54:50 | natch | 1 | 28756 | 12 | 0.483 | 59536.2 |
407 | 2022-10-18 16:27:08 | natch | 3 | 83667 | 767 | 3.500 | 23904.9 |
406 | 2022-09-12 01:28:41 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
405 | 2022-09-04 19:33:32 | natch | 2 | 53800 | 79 | 1.390 | 38705.0 |
404 | 2022-08-28 09:41:21 | natch | 2 | 53800 | 79 | 1.360 | 39558.8 |
403 | 2022-08-06 18:16:12 | natch | 1 | 28756 | 12 | 0.436 | 65954.1 |
402 | 2022-07-30 06:20:03 | natch | 1 | 28756 | 12 | 0.420 | 68466.7 |
401 | 2022-07-29 23:18:27 | natch | 1 | 28756 | 12 | 0.436 | 65954.1 |
400 | 2022-07-28 13:58:44 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
399 | 2022-07-27 21:05:42 | natch | 1 | 28756 | 12 | 0.440 | 65354.5 |
398 | 2022-05-19 10:39:28 | natch | 3 | 83667 | 767 | 3.720 | 22491.1 |
397 | 2022-05-16 05:39:22 | natch | 3 | 83667 | 767 | 3.376 | 24782.9 |
396 | 2022-05-16 04:32:00 | natch | 2 | 53800 | 79 | 1.546 | 34799.5 |
395 | 2022-04-12 00:09:37 | natch | 1 | 28756 | 12 | 0.516 | 55728.7 |
394 | 2022-03-20 09:50:19 | natch | 1 | 28756 | 12 | 0.486 | 59168.7 |
393 | 2022-02-06 10:14:28 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
392 | 2021-12-26 08:33:03 | natch | 1 | 28756 | 12 | 0.500 | 57512.0 |
391 | 2021-12-24 11:13:48 | natch | 1 | 28756 | 12 | 0.513 | 56054.6 |
390 | 2021-11-15 23:08:04 | natch | 1 | 28756 | 12 | 0.530 | 54256.6 |
389 | 2021-10-29 02:44:05 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
388 | 2021-09-20 12:29:30 | natch | 1 | 28756 | 12 | 0.533 | 53951.2 |
387 | 2021-09-17 10:17:18 | natch | 1 | 28756 | 12 | 0.563 | 51076.4 |
386 | 2021-09-02 02:05:59 | natch | 1 | 28756 | 12 | 0.470 | 61183.0 |
385 | 2021-06-27 21:10:07 | natch | 1 | 28756 | 12 | 0.500 | 57512.0 |
384 | 2021-06-17 09:26:54 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
383 | 2021-06-13 21:45:01 | natch | 1 | 28756 | 12 | 0.513 | 56054.6 |
382 | 2021-05-17 20:34:21 | natch | 3 | 83667 | 767 | 4.093 | 20441.5 |
381 | 2021-04-09 14:10:21 | natch | 1 | 28756 | 12 | 0.500 | 57512.0 |
380 | 2021-03-26 21:35:56 | natch | 2 | 53800 | 79 | 1.436 | 37465.2 |
379 | 2021-03-11 01:43:01 | natch | 1 | 28756 | 12 | 0.436 | 65954.1 |
378 | 2021-03-01 00:41:25 | natch | 2 | 53800 | 79 | 1.686 | 31909.8 |
377 | 2021-02-23 09:24:03 | natch | 3 | 83667 | 767 | 3.376 | 24782.9 |
376 | 2021-01-02 03:48:17 | natch | 3 | 83667 | 767 | 3.360 | 24900.9 |
375 | 2020-12-11 19:44:45 | natch | 2 | 53800 | 79 | 1.420 | 37887.3 |
374 | 2020-12-05 16:35:53 | natch | 3 | 83667 | 767 | 3.393 | 24658.7 |
373 | 2020-12-03 17:17:23 | natch | 1 | 28756 | 12 | 0.450 | 63902.2 |
372 | 2020-11-29 00:16:40 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
371 | 2020-11-05 12:41:15 | natch | 3 | 83667 | 767 | 3.596 | 23266.7 |
370 | 2020-11-01 08:01:29 | natch | 1 | 28756 | 12 | 0.513 | 56054.6 |
369 | 2020-10-31 07:16:55 | natch | 2 | 53800 | 79 | 1.436 | 37465.2 |
368 | 2020-10-24 20:09:32 | natch | 2 | 53800 | 79 | 1.436 | 37465.2 |
367 | 2020-10-24 03:05:59 | natch | 1 | 28756 | 12 | 0.453 | 63479.0 |
366 | 2020-10-22 01:00:16 | natch | 2 | 53800 | 79 | 1.420 | 37887.3 |
365 | 2020-10-11 10:07:59 | natch | 2 | 53800 | 79 | 1.610 | 33416.1 |
364 | 2020-09-30 16:46:46 | natch | 1 | 28756 | 12 | 0.470 | 61183.0 |