History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"confect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
460 | 2024-04-28 21:11:37 | confect | 2 | 107671 | 37 | 3.546 | 30364.1 |
459 | 2024-04-28 21:11:21 | confect | 3 | 134027 | 220 | 8.423 | 15912.0 |
458 | 2024-04-28 04:23:43 | confect | 2 | 107671 | 37 | 4.783 | 22511.2 |
457 | 2024-04-28 04:18:09 | confect | 3 | 134027 | 220 | 8.250 | 16245.7 |
456 | 2024-04-27 16:38:44 | confect | 1 | 69583 | 5 | 1.406 | 49490.0 |
455 | 2024-04-26 08:59:36 | confect | 3 | 134027 | 220 | 11.483 | 11671.8 |
454 | 2024-04-25 09:27:52 | confect | 3 | 134027 | 220 | 10.843 | 12360.7 |
453 | 2024-04-25 09:27:53 | confect | 2 | 107671 | 37 | 8.453 | 12737.6 |
452 | 2024-04-25 09:27:46 | confect | 1 | 69583 | 5 | 1.953 | 35628.8 |
451 | 2024-04-06 02:35:52 | confect | 1 | 69583 | 5 | 3.936 | 17678.6 |
450 | 2024-03-27 06:23:15 | confect | 1 | 69583 | 5 | 2.686 | 25905.8 |
449 | 2024-03-09 00:06:21 | confect | 2 | 107671 | 37 | 11.096 | 9703.6 |
448 | 2024-03-06 10:05:44 | confect | 2 | 107671 | 37 | 9.690 | 11111.6 |
447 | 2024-03-06 10:05:27 | confect | 3 | 134027 | 220 | 8.500 | 15767.9 |
446 | 2024-03-06 02:41:36 | confect | 3 | 134027 | 220 | 14.156 | 9467.9 |
445 | 2024-03-04 21:58:54 | confect | 3 | 134027 | 220 | 15.986 | 8384.0 |
444 | 2024-03-04 19:28:45 | confect | 3 | 134027 | 220 | 16.453 | 8146.1 |
443 | 2024-03-04 10:04:25 | confect | 3 | 134027 | 220 | 15.233 | 8798.5 |
442 | 2024-03-04 09:52:28 | confect | 1 | 69583 | 5 | 3.186 | 21840.2 |
441 | 2024-03-04 09:51:51 | confect | 3 | 134027 | 220 | 10.110 | 13256.9 |
440 | 2024-03-04 09:51:47 | confect | 2 | 107671 | 37 | 6.076 | 17720.7 |
439 | 2024-03-04 09:51:45 | confect | 1 | 69583 | 5 | 3.873 | 17966.2 |
438 | 2024-02-26 20:38:21 | confect | 1 | 69583 | 5 | 1.343 | 51811.6 |
437 | 2024-02-14 23:03:02 | confect | 1 | 69583 | 5 | 4.296 | 16197.2 |
436 | 2024-01-07 21:20:48 | confect | 2 | 107671 | 37 | 2.936 | 36672.7 |
435 | 2024-01-07 12:46:42 | confect | 1 | 69583 | 5 | 1.343 | 51811.6 |
434 | 2023-12-12 01:37:17 | confect | 1 | 69583 | 5 | 1.283 | 54234.6 |
433 | 2023-12-08 07:44:34 | confect | 1 | 69583 | 5 | 1.233 | 56433.9 |
432 | 2023-11-19 16:18:08 | confect | 1 | 69583 | 5 | 1.110 | 62687.4 |
431 | 2023-11-08 12:47:16 | confect | 1 | 69583 | 5 | 1.266 | 54962.9 |
430 | 2023-10-14 13:08:23 | confect | 2 | 107671 | 37 | 3.330 | 32333.6 |
429 | 2023-09-29 09:47:43 | confect | 1 | 69583 | 5 | 1.250 | 55666.4 |
428 | 2023-09-21 20:28:30 | confect | 1 | 69583 | 5 | 1.140 | 61037.7 |
427 | 2023-07-24 05:56:12 | confect | 2 | 107671 | 37 | 3.233 | 33303.7 |
426 | 2023-07-21 07:02:50 | confect | 1 | 69583 | 5 | 1.110 | 62687.4 |
425 | 2023-07-16 22:42:03 | confect | 1 | 69583 | 5 | 1.280 | 54361.7 |
424 | 2023-04-20 03:20:12 | confect | 1 | 69583 | 5 | 1.236 | 56296.9 |
423 | 2023-04-06 00:28:38 | confect | 1 | 69583 | 5 | 1.250 | 55666.4 |
422 | 2023-04-05 16:17:55 | confect | 2 | 107671 | 37 | 2.813 | 38276.2 |
421 | 2023-02-11 07:24:35 | confect | 1 | 69583 | 5 | 1.076 | 64668.2 |
420 | 2023-01-05 17:51:08 | confect | 2 | 107671 | 37 | 6.673 | 16135.3 |
419 | 2022-12-17 07:20:03 | confect | 1 | 69583 | 5 | 2.406 | 28920.6 |
418 | 2022-12-08 20:29:34 | confect | 1 | 69583 | 5 | 1.076 | 64668.2 |
417 | 2022-09-11 01:10:56 | confect | 2 | 107671 | 37 | 2.846 | 37832.4 |
416 | 2022-08-13 22:50:23 | confect | 1 | 69583 | 5 | 1.106 | 62914.1 |
415 | 2022-08-12 12:08:50 | confect | 1 | 69583 | 5 | 1.110 | 62687.4 |
414 | 2022-05-09 10:37:58 | confect | 1 | 69583 | 5 | 1.516 | 45899.1 |
413 | 2022-04-09 14:33:17 | confect | 1 | 69583 | 5 | 1.263 | 55093.4 |
412 | 2022-03-30 10:01:19 | confect | 1 | 69583 | 5 | 1.233 | 56433.9 |
411 | 2022-01-01 00:38:27 | confect | 1 | 69583 | 5 | 1.250 | 55666.4 |
410 | 2021-12-25 10:54:37 | confect | 1 | 69583 | 5 | 1.236 | 56296.9 |
409 | 2021-11-03 13:48:59 | confect | 1 | 69583 | 5 | 1.140 | 61037.7 |
408 | 2021-11-01 12:17:55 | confect | 1 | 69583 | 5 | 1.080 | 64428.7 |
407 | 2021-10-15 06:01:20 | confect | 1 | 69583 | 5 | 1.093 | 63662.4 |
406 | 2021-09-21 00:33:16 | confect | 1 | 69583 | 5 | 1.106 | 62914.1 |
405 | 2021-09-18 06:23:54 | confect | 1 | 69583 | 5 | 1.393 | 49951.9 |
404 | 2021-08-24 23:12:07 | confect | 1 | 69583 | 5 | 1.080 | 64428.7 |
403 | 2021-08-19 05:35:06 | confect | 1 | 69583 | 5 | 1.093 | 63662.4 |
402 | 2021-08-17 01:25:30 | confect | 1 | 69583 | 5 | 1.143 | 60877.5 |
401 | 2021-06-18 10:32:45 | confect | 1 | 69583 | 5 | 1.140 | 61037.7 |
400 | 2021-05-24 13:49:12 | confect | 1 | 69583 | 5 | 1.216 | 57222.9 |
399 | 2021-04-27 20:49:02 | confect | 1 | 69583 | 5 | 1.093 | 63662.4 |
398 | 2021-03-15 15:57:53 | confect | 1 | 69583 | 5 | 1.326 | 52475.9 |
397 | 2021-01-11 03:31:34 | confect | 1 | 69583 | 5 | 1.143 | 60877.5 |
396 | 2020-12-04 23:16:30 | confect | 1 | 69583 | 5 | 1.153 | 60349.5 |
395 | 2020-10-18 15:45:41 | confect | 1 | 69583 | 5 | 1.233 | 56433.9 |
394 | 2020-09-29 08:36:46 | confect | 1 | 69583 | 5 | 1.126 | 61796.6 |
393 | 2020-09-27 20:45:37 | confect | 1 | 69583 | 5 | 1.233 | 56433.9 |
392 | 2020-08-23 18:20:46 | confect | 1 | 69583 | 5 | 1.170 | 59472.6 |
391 | 2020-07-24 02:19:43 | confect | 1 | 69583 | 5 | 1.313 | 52995.4 |
390 | 2020-07-23 21:49:26 | confect | 1 | 69583 | 5 | 1.140 | 61037.7 |
389 | 2020-05-16 03:27:05 | confect | 1 | 69583 | 5 | 1.110 | 62687.4 |
388 | 2020-05-13 02:47:16 | confect | 1 | 69583 | 5 | 1.266 | 54962.9 |
387 | 2020-03-29 20:02:16 | confect | 1 | 69583 | 5 | 1.263 | 55093.4 |
386 | 2020-03-24 02:32:14 | confect | 1 | 69583 | 5 | 3.720 | 18705.1 |
385 | 2020-03-22 05:26:27 | confect | 1 | 69583 | 5 | 1.263 | 55093.4 |
384 | 2020-02-29 01:45:49 | confect | 1 | 69583 | 5 | 1.360 | 51164.0 |
383 | 2020-02-21 10:56:51 | confect | 1 | 69583 | 5 | 1.250 | 55666.4 |
382 | 2020-02-21 07:07:45 | confect | 1 | 69583 | 5 | 2.750 | 25302.9 |
381 | 2020-02-17 04:52:45 | confect | 1 | 69583 | 5 | 1.266 | 54962.9 |
380 | 2020-02-11 06:53:39 | confect | 1 | 69583 | 5 | 1.873 | 37150.6 |
379 | 2020-02-10 12:03:37 | confect | 1 | 69583 | 5 | 1.233 | 56433.9 |
378 | 2020-02-06 07:01:59 | confect | 1 | 69583 | 5 | 1.360 | 51164.0 |
377 | 2020-01-31 00:45:33 | confect | 1 | 69583 | 5 | 1.296 | 53690.6 |
376 | 2020-01-25 10:33:46 | confect | 1 | 69583 | 5 | 1.373 | 50679.5 |
375 | 2020-01-25 07:33:04 | confect | 1 | 69583 | 5 | 1.330 | 52318.0 |
374 | 2020-01-21 03:47:02 | confect | 1 | 69583 | 5 | 2.876 | 24194.4 |
373 | 2020-01-20 15:08:18 | confect | 1 | 69583 | 5 | 3.046 | 22844.1 |
372 | 2020-01-14 20:09:10 | confect | 1 | 69583 | 5 | 1.296 | 53690.6 |
371 | 2020-01-07 02:41:20 | confect | 1 | 69583 | 5 | 1.623 | 42873.1 |
370 | 2019-12-31 01:10:06 | confect | 1 | 69583 | 5 | 1.343 | 51811.6 |
369 | 2019-12-30 01:53:35 | confect | 1 | 69583 | 5 | 1.313 | 52995.4 |
368 | 2019-12-29 01:19:33 | confect | 1 | 69583 | 5 | 1.376 | 50569.0 |
367 | 2019-11-10 05:30:27 | confect | 1 | 69583 | 5 | 1.263 | 55093.4 |
366 | 2019-08-08 22:45:32 | confect | 1 | 69583 | 5 | 1.123 | 61961.7 |
365 | 2019-06-10 17:51:49 | confect | 1 | 69583 | 5 | 1.160 | 59985.3 |
364 | 2019-05-09 02:11:59 | confect | 1 | 69583 | 5 | 1.276 | 54532.1 |
363 | 2019-03-07 10:05:36 | confect | 1 | 69583 | 5 | 1.043 | 66714.3 |
362 | 2019-02-26 21:48:18 | confect | 1 | 69583 | 5 | 2.316 | 30044.5 |
361 | 2019-01-31 23:41:01 | confect | 1 | 69583 | 5 | 1.076 | 64668.2 |