History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gnats"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
458 | 2024-05-02 14:55:57 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
457 | 2024-04-30 19:09:00 | gnats | 1 | 28756 | 7 | 1.093 | 26309.2 |
456 | 2024-04-28 08:52:35 | gnats | 1 | 28756 | 7 | 0.576 | 49923.6 |
455 | 2024-04-02 22:51:36 | gnats | 2 | 53800 | 169 | 1.860 | 28924.7 |
454 | 2024-04-02 20:56:16 | gnats | 1 | 28756 | 7 | 0.466 | 61708.2 |
453 | 2024-03-31 11:12:41 | gnats | 2 | 53800 | 169 | 1.626 | 33087.3 |
452 | 2024-03-31 11:12:34 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
451 | 2024-03-31 11:12:25 | gnats | 2 | 53800 | 169 | 1.593 | 33772.8 |
450 | 2024-03-31 10:01:02 | gnats | 2 | 53800 | 169 | 4.720 | 11398.3 |
449 | 2024-03-31 08:37:26 | gnats | 1 | 28756 | 7 | 0.530 | 54256.6 |
448 | 2024-03-29 01:09:00 | gnats | 1 | 28756 | 7 | 0.923 | 31154.9 |
447 | 2024-03-01 03:36:16 | gnats | 1 | 28756 | 7 | 1.000 | 28756.0 |
446 | 2024-02-27 20:15:42 | gnats | 1 | 28756 | 7 | 0.546 | 52666.7 |
445 | 2024-02-21 20:06:56 | gnats | 1 | 28756 | 7 | 1.046 | 27491.4 |
444 | 2024-01-28 19:14:49 | gnats | 1 | 28756 | 7 | 0.626 | 45936.1 |
443 | 2024-01-24 13:51:30 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
442 | 2024-01-03 23:19:31 | gnats | 2 | 53800 | 169 | 1.736 | 30990.8 |
441 | 2023-12-31 17:50:11 | gnats | 2 | 53800 | 169 | 2.720 | 19779.4 |
440 | 2023-12-24 17:53:53 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
439 | 2023-12-16 04:28:55 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
438 | 2023-12-07 17:23:05 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
437 | 2023-12-07 17:23:04 | gnats | 1 | 28756 | 7 | 0.563 | 51076.4 |
436 | 2023-12-07 02:04:48 | gnats | 1 | 28756 | 7 | 0.516 | 55728.7 |
435 | 2023-12-07 02:04:48 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
434 | 2023-11-27 08:05:35 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
433 | 2023-11-21 17:48:33 | gnats | 1 | 28756 | 7 | 0.466 | 61708.2 |
432 | 2023-11-20 23:46:37 | gnats | 1 | 28756 | 7 | 0.470 | 61183.0 |
431 | 2023-11-19 22:02:35 | gnats | 1 | 28756 | 7 | 0.450 | 63902.2 |
430 | 2023-11-13 08:50:22 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
429 | 2023-11-03 19:35:33 | gnats | 1 | 28756 | 7 | 0.486 | 59168.7 |
428 | 2023-10-31 06:58:35 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
427 | 2023-10-22 13:15:59 | gnats | 1 | 28756 | 7 | 0.466 | 61708.2 |
426 | 2023-10-20 16:59:46 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
425 | 2023-10-14 22:12:21 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
424 | 2023-10-05 14:52:50 | gnats | 1 | 28756 | 7 | 0.420 | 68466.7 |
423 | 2023-09-26 08:21:48 | gnats | 1 | 28756 | 7 | 0.440 | 65354.5 |
422 | 2023-09-13 14:35:18 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
421 | 2023-09-07 05:52:42 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
420 | 2023-08-03 05:12:33 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
419 | 2023-06-11 04:40:00 | gnats | 1 | 28756 | 7 | 0.936 | 30722.2 |
418 | 2023-04-29 09:55:54 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
417 | 2023-03-28 14:23:22 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
416 | 2023-01-17 03:03:26 | gnats | 1 | 28756 | 7 | 0.466 | 61708.2 |
415 | 2023-01-11 17:51:03 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
414 | 2022-10-20 17:21:42 | gnats | 1 | 28756 | 7 | 0.420 | 68466.7 |
413 | 2022-09-29 10:33:25 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
412 | 2022-09-18 13:05:14 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
411 | 2022-08-23 15:21:44 | gnats | 1 | 28756 | 7 | 0.423 | 67981.1 |
410 | 2022-06-25 21:50:50 | gnats | 1 | 28756 | 7 | 0.420 | 68466.7 |
409 | 2022-06-16 22:54:11 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
408 | 2022-06-16 03:21:34 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
407 | 2022-06-11 03:03:09 | gnats | 1 | 28756 | 7 | 0.420 | 68466.7 |
406 | 2022-04-26 02:43:37 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
405 | 2022-03-04 04:44:49 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
404 | 2022-02-28 19:01:42 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
403 | 2022-02-23 02:05:29 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
402 | 2022-02-20 21:16:24 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
401 | 2021-12-10 00:56:52 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
400 | 2021-11-23 23:38:36 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
399 | 2021-10-21 11:12:03 | gnats | 1 | 28756 | 7 | 0.533 | 53951.2 |
398 | 2021-10-19 09:24:58 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
397 | 2021-09-13 15:02:30 | gnats | 1 | 28756 | 7 | 0.466 | 61708.2 |
396 | 2021-08-24 09:15:53 | gnats | 1 | 28756 | 7 | 0.470 | 61183.0 |
395 | 2021-08-20 22:37:58 | gnats | 1 | 28756 | 7 | 0.423 | 67981.1 |
394 | 2021-08-13 22:48:43 | gnats | 1 | 28756 | 7 | 0.530 | 54256.6 |
393 | 2021-08-11 18:16:21 | gnats | 1 | 28756 | 7 | 0.440 | 65354.5 |
392 | 2021-05-20 08:16:26 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
391 | 2021-02-17 16:47:15 | gnats | 1 | 28756 | 7 | 0.466 | 61708.2 |
390 | 2021-02-12 06:49:34 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
389 | 2020-11-13 11:15:47 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
388 | 2020-10-16 09:56:37 | gnats | 1 | 28756 | 7 | 0.440 | 65354.5 |
387 | 2020-10-09 21:01:45 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
386 | 2020-09-14 11:10:24 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
385 | 2020-08-22 18:05:30 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
384 | 2020-08-09 11:52:58 | gnats | 1 | 28756 | 7 | 0.470 | 61183.0 |
383 | 2020-07-28 04:56:55 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
382 | 2020-05-08 06:51:00 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
381 | 2020-04-07 22:55:59 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
380 | 2020-03-25 09:47:27 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
379 | 2020-03-25 05:34:50 | gnats | 1 | 28756 | 7 | 0.513 | 56054.6 |
378 | 2020-03-23 13:08:24 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
377 | 2020-03-22 12:21:57 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
376 | 2020-03-21 01:33:08 | gnats | 1 | 28756 | 7 | 0.486 | 59168.7 |
375 | 2020-03-18 15:37:06 | gnats | 1 | 28756 | 7 | 0.483 | 59536.2 |
374 | 2020-03-18 05:12:16 | gnats | 1 | 28756 | 7 | 0.486 | 59168.7 |
373 | 2020-02-24 10:59:22 | gnats | 1 | 28756 | 7 | 1.080 | 26625.9 |
372 | 2020-02-18 18:14:18 | gnats | 1 | 28756 | 7 | 1.000 | 28756.0 |
371 | 2020-02-17 01:04:06 | gnats | 1 | 28756 | 7 | 1.016 | 28303.1 |
370 | 2020-02-11 15:08:41 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
369 | 2020-02-08 09:15:54 | gnats | 1 | 28756 | 7 | 0.486 | 59168.7 |
368 | 2020-02-05 17:09:23 | gnats | 1 | 28756 | 7 | 0.453 | 63479.0 |
367 | 2020-02-02 04:35:36 | gnats | 1 | 28756 | 7 | 0.486 | 59168.7 |
366 | 2020-01-30 20:57:58 | gnats | 1 | 28756 | 7 | 1.156 | 24875.4 |
365 | 2020-01-29 06:29:55 | gnats | 1 | 28756 | 7 | 1.080 | 26625.9 |
364 | 2020-01-29 00:25:16 | gnats | 1 | 28756 | 7 | 0.436 | 65954.1 |
363 | 2020-01-28 20:01:14 | gnats | 1 | 28756 | 7 | 0.500 | 57512.0 |
362 | 2020-01-22 19:08:50 | gnats | 1 | 28756 | 7 | 0.686 | 41918.4 |
361 | 2020-01-22 06:04:47 | gnats | 1 | 28756 | 7 | 1.016 | 28303.1 |
360 | 2020-01-20 21:06:12 | gnats | 1 | 28756 | 7 | 0.516 | 55728.7 |
359 | 2020-01-13 06:46:45 | gnats | 1 | 28756 | 7 | 0.513 | 56054.6 |