History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sniff"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
441 | 2024-03-06 20:54:08 | sniff | 1 | 28756 | 7 | 1.110 | 25906.3 |
440 | 2024-03-05 18:35:05 | sniff | 3 | 83667 | 568 | 13.843 | 6044.0 |
439 | 2024-03-05 18:34:55 | sniff | 2 | 53800 | 55 | 6.440 | 8354.0 |
438 | 2024-03-04 18:37:13 | sniff | 3 | 83667 | 568 | 14.580 | 5738.5 |
437 | 2024-03-04 18:37:16 | sniff | 2 | 53800 | 55 | 3.250 | 16553.8 |
436 | 2024-03-01 12:53:05 | sniff | 1 | 28756 | 7 | 0.436 | 65954.1 |
435 | 2024-02-28 13:41:52 | sniff | 2 | 53800 | 55 | 1.736 | 30990.8 |
434 | 2024-02-28 13:41:30 | sniff | 3 | 83667 | 568 | 3.906 | 21420.1 |
433 | 2024-02-26 10:27:13 | sniff | 3 | 83667 | 568 | 7.093 | 11795.7 |
432 | 2024-02-25 19:20:32 | sniff | 1 | 28756 | 7 | 0.470 | 61183.0 |
431 | 2024-02-22 10:30:59 | sniff | 2 | 53800 | 55 | 1.670 | 32215.6 |
430 | 2024-02-22 10:30:35 | sniff | 3 | 83667 | 568 | 6.173 | 13553.7 |
429 | 2024-02-19 22:41:19 | sniff | 1 | 28756 | 7 | 2.156 | 13337.7 |
428 | 2024-02-19 05:57:27 | sniff | 3 | 83667 | 568 | 4.516 | 18526.8 |
427 | 2024-02-03 17:30:35 | sniff | 1 | 28756 | 7 | 0.546 | 52666.7 |
426 | 2024-01-29 02:48:59 | sniff | 1 | 28756 | 7 | 0.530 | 54256.6 |
425 | 2024-01-26 04:49:29 | sniff | 1 | 28756 | 7 | 0.453 | 63479.0 |
424 | 2024-01-17 11:53:22 | sniff | 1 | 28756 | 7 | 0.453 | 63479.0 |
423 | 2024-01-13 19:11:42 | sniff | 1 | 28756 | 7 | 0.486 | 59168.7 |
422 | 2023-12-13 16:59:40 | sniff | 2 | 53800 | 55 | 1.593 | 33772.8 |
421 | 2023-12-03 06:17:18 | sniff | 1 | 28756 | 7 | 0.593 | 48492.4 |
420 | 2023-11-28 18:22:30 | sniff | 2 | 53800 | 55 | 1.390 | 38705.0 |
419 | 2023-11-25 16:17:28 | sniff | 2 | 53800 | 55 | 1.576 | 34137.1 |
418 | 2023-11-25 03:58:31 | sniff | 3 | 83667 | 568 | 3.813 | 21942.6 |
417 | 2023-11-16 14:55:23 | sniff | 3 | 83667 | 568 | 3.440 | 24321.8 |
416 | 2023-11-15 04:46:26 | sniff | 3 | 83667 | 568 | 3.546 | 23594.8 |
415 | 2023-11-15 04:46:24 | sniff | 2 | 53800 | 55 | 1.590 | 33836.5 |
414 | 2023-11-10 21:26:06 | sniff | 1 | 28756 | 7 | 1.033 | 27837.4 |
413 | 2023-11-09 08:02:27 | sniff | 2 | 53800 | 55 | 1.406 | 38264.6 |
412 | 2023-11-09 08:02:15 | sniff | 3 | 83667 | 568 | 3.300 | 25353.6 |
411 | 2023-11-08 15:33:31 | sniff | 1 | 28756 | 7 | 0.440 | 65354.5 |
410 | 2023-10-27 15:23:27 | sniff | 3 | 83667 | 568 | 9.140 | 9153.9 |
409 | 2023-10-27 15:20:19 | sniff | 1 | 28756 | 7 | 0.470 | 61183.0 |
408 | 2023-10-21 15:40:35 | sniff | 3 | 83667 | 568 | 4.046 | 20678.9 |
407 | 2023-10-21 15:40:36 | sniff | 2 | 53800 | 55 | 2.423 | 22203.9 |
406 | 2023-10-21 08:37:06 | sniff | 1 | 28756 | 7 | 0.513 | 56054.6 |
405 | 2023-10-16 23:59:04 | sniff | 1 | 28756 | 7 | 0.466 | 61708.2 |
404 | 2023-10-13 17:33:59 | sniff | 1 | 28756 | 7 | 0.450 | 63902.2 |
403 | 2023-10-04 11:08:06 | sniff | 1 | 28756 | 7 | 0.500 | 57512.0 |
402 | 2023-09-19 15:14:40 | sniff | 2 | 53800 | 55 | 1.686 | 31909.8 |
401 | 2023-09-19 15:01:48 | sniff | 1 | 28756 | 7 | 0.436 | 65954.1 |
400 | 2023-09-19 14:54:39 | sniff | 3 | 83667 | 568 | 4.393 | 19045.5 |
399 | 2023-09-18 08:28:56 | sniff | 1 | 28756 | 7 | 0.440 | 65354.5 |
398 | 2023-09-16 13:22:18 | sniff | 3 | 83667 | 568 | 3.813 | 21942.6 |
397 | 2023-09-16 13:22:13 | sniff | 2 | 53800 | 55 | 1.423 | 37807.4 |
396 | 2023-09-13 15:52:24 | sniff | 2 | 53800 | 55 | 1.360 | 39558.8 |
395 | 2023-09-10 16:38:13 | sniff | 1 | 28756 | 7 | 0.470 | 61183.0 |
394 | 2023-09-07 06:21:32 | sniff | 1 | 28756 | 7 | 0.440 | 65354.5 |
393 | 2023-08-19 02:18:41 | sniff | 3 | 83667 | 568 | 4.173 | 20049.6 |
392 | 2023-07-08 10:54:04 | sniff | 1 | 28756 | 7 | 0.436 | 65954.1 |
391 | 2023-06-11 22:05:51 | sniff | 2 | 53800 | 55 | 1.376 | 39098.8 |
390 | 2023-05-07 09:32:39 | sniff | 1 | 28756 | 7 | 0.500 | 57512.0 |
389 | 2023-04-26 10:47:01 | sniff | 3 | 83667 | 568 | 3.326 | 25155.4 |
388 | 2023-04-16 13:12:07 | sniff | 1 | 28756 | 7 | 0.420 | 68466.7 |
387 | 2023-03-12 13:32:51 | sniff | 2 | 53800 | 55 | 1.343 | 40059.6 |
386 | 2023-02-06 12:51:40 | sniff | 1 | 28756 | 7 | 0.486 | 59168.7 |
385 | 2023-02-04 03:32:06 | sniff | 3 | 83667 | 568 | 6.516 | 12840.2 |
384 | 2023-01-30 11:16:17 | sniff | 3 | 83667 | 568 | 3.280 | 25508.2 |
383 | 2023-01-10 02:58:10 | sniff | 1 | 28756 | 7 | 0.483 | 59536.2 |
382 | 2022-12-17 03:11:43 | sniff | 2 | 53800 | 55 | 1.360 | 39558.8 |
381 | 2022-12-13 14:28:43 | sniff | 3 | 83667 | 568 | 3.300 | 25353.6 |
380 | 2022-12-10 06:29:00 | sniff | 3 | 83667 | 568 | 4.203 | 19906.5 |
379 | 2022-12-09 13:22:55 | sniff | 3 | 83667 | 568 | 3.796 | 22040.8 |
378 | 2022-12-06 10:52:27 | sniff | 1 | 28756 | 7 | 0.436 | 65954.1 |
377 | 2022-11-13 07:21:23 | sniff | 3 | 83667 | 568 | 3.703 | 22594.4 |
376 | 2022-09-04 20:33:10 | sniff | 1 | 28756 | 7 | 0.436 | 65954.1 |
375 | 2022-08-09 17:45:13 | sniff | 2 | 53800 | 55 | 1.346 | 39970.3 |
374 | 2022-08-02 14:27:16 | sniff | 1 | 28756 | 7 | 0.563 | 51076.4 |
373 | 2022-05-15 00:25:12 | sniff | 3 | 83667 | 568 | 3.373 | 24804.9 |
372 | 2022-04-21 18:19:10 | sniff | 1 | 28756 | 7 | 0.686 | 41918.4 |
371 | 2022-03-29 23:50:55 | sniff | 1 | 28756 | 7 | 0.826 | 34813.6 |
370 | 2022-03-27 20:44:44 | sniff | 1 | 28756 | 7 | 0.470 | 61183.0 |
369 | 2022-03-15 03:09:00 | sniff | 2 | 53800 | 55 | 2.140 | 25140.2 |
368 | 2022-01-14 10:37:44 | sniff | 3 | 83667 | 568 | 3.283 | 25484.9 |
367 | 2021-12-31 14:40:14 | sniff | 1 | 28756 | 7 | 0.530 | 54256.6 |
366 | 2021-12-29 11:45:39 | sniff | 1 | 28756 | 7 | 0.610 | 47141.0 |
365 | 2021-12-27 00:56:36 | sniff | 1 | 28756 | 7 | 0.486 | 59168.7 |
364 | 2021-11-01 02:31:19 | sniff | 1 | 28756 | 7 | 0.563 | 51076.4 |
363 | 2021-10-03 07:14:26 | sniff | 1 | 28756 | 7 | 0.436 | 65954.1 |
362 | 2021-09-20 17:32:35 | sniff | 1 | 28756 | 7 | 0.483 | 59536.2 |
361 | 2021-09-19 10:56:08 | sniff | 1 | 28756 | 7 | 0.550 | 52283.6 |
360 | 2021-09-13 09:18:47 | sniff | 1 | 28756 | 7 | 0.486 | 59168.7 |
359 | 2021-09-10 06:07:40 | sniff | 1 | 28756 | 7 | 0.500 | 57512.0 |
358 | 2021-06-06 00:19:04 | sniff | 1 | 28756 | 7 | 0.483 | 59536.2 |
357 | 2021-06-02 19:57:27 | sniff | 1 | 28756 | 7 | 0.470 | 61183.0 |
356 | 2021-04-29 09:47:38 | sniff | 1 | 28756 | 7 | 0.440 | 65354.5 |
355 | 2021-03-28 23:44:44 | sniff | 1 | 28756 | 7 | 0.520 | 55300.0 |
354 | 2021-02-28 06:51:19 | sniff | 1 | 28756 | 7 | 0.436 | 65954.1 |
353 | 2021-02-06 22:41:41 | sniff | 1 | 28756 | 7 | 0.486 | 59168.7 |
352 | 2021-01-12 18:32:59 | sniff | 1 | 28756 | 7 | 0.453 | 63479.0 |
351 | 2020-11-23 17:11:18 | sniff | 1 | 28756 | 7 | 0.483 | 59536.2 |
350 | 2020-11-18 07:44:27 | sniff | 1 | 28756 | 7 | 0.580 | 49579.3 |
349 | 2020-11-11 19:01:57 | sniff | 1 | 28756 | 7 | 0.516 | 55728.7 |
348 | 2020-08-09 21:10:00 | sniff | 1 | 28756 | 7 | 0.483 | 59536.2 |
347 | 2020-07-20 03:30:02 | sniff | 1 | 28756 | 7 | 0.516 | 55728.7 |
346 | 2020-05-05 11:26:25 | sniff | 1 | 28756 | 7 | 0.470 | 61183.0 |
345 | 2020-03-27 05:58:11 | sniff | 1 | 28756 | 7 | 0.533 | 53951.2 |
344 | 2020-03-27 03:30:36 | sniff | 1 | 28756 | 7 | 0.530 | 54256.6 |
343 | 2020-03-25 02:57:58 | sniff | 1 | 28756 | 7 | 0.453 | 63479.0 |
342 | 2020-03-23 04:17:47 | sniff | 1 | 28756 | 7 | 1.050 | 27386.7 |