History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"optic"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
449 | 2024-04-06 19:16:36 | optic | 1 | 28756 | 4 | 0.563 | 51076.4 |
448 | 2024-04-03 05:41:14 | optic | 3 | 83667 | 547 | 12.126 | 6899.8 |
447 | 2024-04-03 05:41:14 | optic | 2 | 53800 | 44 | 1.923 | 27977.1 |
446 | 2024-04-03 05:36:29 | optic | 1 | 28756 | 4 | 0.516 | 55728.7 |
445 | 2024-03-31 16:14:05 | optic | 2 | 53800 | 44 | 3.343 | 16093.3 |
444 | 2024-03-31 16:14:05 | optic | 1 | 28756 | 4 | 0.530 | 54256.6 |
443 | 2024-03-31 16:13:41 | optic | 3 | 83667 | 547 | 5.093 | 16427.8 |
442 | 2024-03-31 10:06:37 | optic | 3 | 83667 | 547 | 11.393 | 7343.7 |
441 | 2024-03-31 10:06:35 | optic | 2 | 53800 | 44 | 1.936 | 27789.3 |
440 | 2024-03-31 08:28:29 | optic | 1 | 28756 | 4 | 0.530 | 54256.6 |
439 | 2024-03-29 08:52:27 | optic | 1 | 28756 | 4 | 0.546 | 52666.7 |
438 | 2024-03-15 22:41:52 | optic | 1 | 28756 | 4 | 1.063 | 27051.7 |
437 | 2024-03-15 14:37:44 | optic | 3 | 83667 | 547 | 8.716 | 9599.2 |
436 | 2024-03-03 21:37:11 | optic | 1 | 28756 | 4 | 0.466 | 61708.2 |
435 | 2024-03-01 06:51:17 | optic | 1 | 28756 | 4 | 0.533 | 53951.2 |
434 | 2024-02-28 04:07:42 | optic | 2 | 53800 | 44 | 1.796 | 29955.5 |
433 | 2024-02-28 04:07:14 | optic | 3 | 83667 | 547 | 8.640 | 9683.7 |
432 | 2024-02-28 03:55:09 | optic | 3 | 83667 | 547 | 5.703 | 14670.7 |
431 | 2024-02-28 03:55:12 | optic | 2 | 53800 | 44 | 2.030 | 26502.5 |
430 | 2024-02-28 03:55:03 | optic | 1 | 28756 | 4 | 0.516 | 55728.7 |
429 | 2024-02-13 21:46:37 | optic | 1 | 28756 | 4 | 1.576 | 18246.2 |
428 | 2024-02-12 11:35:14 | optic | 2 | 53800 | 44 | 3.580 | 15027.9 |
427 | 2024-01-29 03:07:49 | optic | 1 | 28756 | 4 | 0.483 | 59536.2 |
426 | 2024-01-28 21:39:11 | optic | 1 | 28756 | 4 | 0.470 | 61183.0 |
425 | 2024-01-24 23:25:28 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
424 | 2024-01-23 19:06:25 | optic | 1 | 28756 | 4 | 0.483 | 59536.2 |
423 | 2024-01-15 04:22:12 | optic | 3 | 83667 | 547 | 3.296 | 25384.4 |
422 | 2024-01-13 02:40:34 | optic | 1 | 28756 | 4 | 0.500 | 57512.0 |
421 | 2024-01-08 06:31:39 | optic | 2 | 53800 | 44 | 1.656 | 32487.9 |
420 | 2024-01-05 11:50:57 | optic | 3 | 83667 | 547 | 3.860 | 21675.4 |
419 | 2024-01-05 11:50:55 | optic | 2 | 53800 | 44 | 1.546 | 34799.5 |
418 | 2023-12-16 03:38:54 | optic | 1 | 28756 | 4 | 0.470 | 61183.0 |
417 | 2023-11-27 08:14:36 | optic | 3 | 83667 | 547 | 3.406 | 24564.6 |
416 | 2023-11-21 01:17:12 | optic | 1 | 28756 | 4 | 0.453 | 63479.0 |
415 | 2023-11-18 10:28:52 | optic | 2 | 53800 | 44 | 1.343 | 40059.6 |
414 | 2023-11-18 10:28:48 | optic | 3 | 83667 | 547 | 3.250 | 25743.7 |
413 | 2023-11-17 03:44:51 | optic | 1 | 28756 | 4 | 0.423 | 67981.1 |
412 | 2023-11-15 23:51:29 | optic | 2 | 53800 | 44 | 1.593 | 33772.8 |
411 | 2023-11-14 09:44:19 | optic | 1 | 28756 | 4 | 0.486 | 59168.7 |
410 | 2023-11-12 19:47:21 | optic | 1 | 28756 | 4 | 0.516 | 55728.7 |
409 | 2023-11-03 13:31:28 | optic | 1 | 28756 | 4 | 0.500 | 57512.0 |
408 | 2023-10-23 17:53:29 | optic | 3 | 83667 | 547 | 4.143 | 20194.8 |
407 | 2023-10-23 17:53:23 | optic | 2 | 53800 | 44 | 1.593 | 33772.8 |
406 | 2023-10-23 11:26:58 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
405 | 2023-10-21 15:39:35 | optic | 1 | 28756 | 4 | 0.516 | 55728.7 |
404 | 2023-10-18 19:39:17 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
403 | 2023-10-14 14:19:53 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
402 | 2023-10-05 22:03:10 | optic | 1 | 28756 | 4 | 0.576 | 49923.6 |
401 | 2023-10-02 13:03:25 | optic | 1 | 28756 | 4 | 0.440 | 65354.5 |
400 | 2023-09-24 11:17:51 | optic | 1 | 28756 | 4 | 0.470 | 61183.0 |
399 | 2023-09-14 11:09:41 | optic | 1 | 28756 | 4 | 0.500 | 57512.0 |
398 | 2023-09-08 01:55:31 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
397 | 2023-08-27 04:01:27 | optic | 3 | 83667 | 547 | 3.720 | 22491.1 |
396 | 2023-08-17 13:24:53 | optic | 2 | 53800 | 44 | 1.466 | 36698.5 |
395 | 2023-06-15 13:58:57 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
394 | 2023-06-12 06:49:24 | optic | 1 | 28756 | 4 | 0.453 | 63479.0 |
393 | 2023-06-10 13:35:08 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
392 | 2023-05-31 08:42:59 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
391 | 2023-05-12 04:46:21 | optic | 3 | 83667 | 547 | 3.436 | 24350.1 |
390 | 2023-04-30 18:35:41 | optic | 2 | 53800 | 44 | 1.516 | 35488.1 |
389 | 2023-03-28 07:37:20 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
388 | 2023-03-03 06:08:56 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
387 | 2023-02-17 00:09:58 | optic | 3 | 83667 | 547 | 3.250 | 25743.7 |
386 | 2023-02-08 11:54:52 | optic | 2 | 53800 | 44 | 1.313 | 40974.9 |
385 | 2023-01-11 23:07:54 | optic | 1 | 28756 | 4 | 0.533 | 53951.2 |
384 | 2022-11-30 05:36:01 | optic | 3 | 83667 | 547 | 3.190 | 26227.9 |
383 | 2022-11-20 08:14:46 | optic | 2 | 53800 | 44 | 1.330 | 40451.1 |
382 | 2022-11-07 09:42:32 | optic | 1 | 28756 | 4 | 0.593 | 48492.4 |
381 | 2022-10-23 04:54:25 | optic | 1 | 28756 | 4 | 0.546 | 52666.7 |
380 | 2022-09-18 04:48:05 | optic | 1 | 28756 | 4 | 0.453 | 63479.0 |
379 | 2022-08-23 09:26:10 | optic | 1 | 28756 | 4 | 0.483 | 59536.2 |
378 | 2022-08-07 12:53:48 | optic | 1 | 28756 | 4 | 0.423 | 67981.1 |
377 | 2022-07-21 16:00:52 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
376 | 2022-07-17 22:44:52 | optic | 1 | 28756 | 4 | 0.483 | 59536.2 |
375 | 2022-07-07 06:12:33 | optic | 3 | 83667 | 547 | 3.280 | 25508.2 |
374 | 2022-06-25 17:16:12 | optic | 1 | 28756 | 4 | 0.466 | 61708.2 |
373 | 2022-06-23 21:38:08 | optic | 2 | 53800 | 44 | 1.326 | 40573.2 |
372 | 2022-04-28 22:09:06 | optic | 1 | 28756 | 4 | 0.483 | 59536.2 |
371 | 2022-03-30 20:44:53 | optic | 1 | 28756 | 4 | 0.656 | 43835.4 |
370 | 2022-02-14 01:03:35 | optic | 3 | 83667 | 547 | 3.310 | 25277.0 |
369 | 2022-02-04 08:34:02 | optic | 1 | 28756 | 4 | 0.440 | 65354.5 |
368 | 2021-12-15 19:01:31 | optic | 1 | 28756 | 4 | 0.500 | 57512.0 |
367 | 2021-12-09 22:46:01 | optic | 1 | 28756 | 4 | 0.440 | 65354.5 |
366 | 2021-12-06 16:26:57 | optic | 1 | 28756 | 4 | 0.423 | 67981.1 |
365 | 2021-11-28 05:20:07 | optic | 2 | 53800 | 44 | 1.406 | 38264.6 |
364 | 2021-11-12 16:43:17 | optic | 3 | 83667 | 547 | 3.750 | 22311.2 |
363 | 2021-11-01 07:59:32 | optic | 1 | 28756 | 4 | 0.436 | 65954.1 |
362 | 2021-09-18 15:39:27 | optic | 1 | 28756 | 4 | 0.440 | 65354.5 |
361 | 2021-08-30 07:58:10 | optic | 1 | 28756 | 4 | 0.470 | 61183.0 |
360 | 2021-08-29 23:12:49 | optic | 1 | 28756 | 4 | 0.466 | 61708.2 |
359 | 2021-08-24 17:03:17 | optic | 2 | 53800 | 44 | 1.513 | 35558.5 |
358 | 2021-06-15 15:57:06 | optic | 1 | 28756 | 4 | 0.516 | 55728.7 |
357 | 2021-05-29 15:21:52 | optic | 1 | 28756 | 4 | 0.513 | 56054.6 |
356 | 2021-05-24 21:49:01 | optic | 1 | 28756 | 4 | 0.513 | 56054.6 |
355 | 2021-05-02 14:31:30 | optic | 1 | 28756 | 4 | 0.563 | 51076.4 |
354 | 2021-04-28 07:25:19 | optic | 1 | 28756 | 4 | 0.513 | 56054.6 |
353 | 2021-02-26 20:46:20 | optic | 1 | 28756 | 4 | 0.500 | 57512.0 |
352 | 2021-01-11 11:09:50 | optic | 1 | 28756 | 4 | 0.533 | 53951.2 |
351 | 2020-12-31 07:09:45 | optic | 1 | 28756 | 4 | 0.470 | 61183.0 |
350 | 2020-11-26 23:19:32 | optic | 1 | 28756 | 4 | 0.453 | 63479.0 |