History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preplan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
465 | 2024-04-03 04:37:29 | preplan | 3 | 134027 | 169 | 9.890 | 13551.8 |
464 | 2024-04-03 01:04:05 | preplan | 3 | 134027 | 169 | 14.346 | 9342.5 |
463 | 2024-04-02 07:06:28 | preplan | 1 | 69583 | 4 | 1.156 | 60192.9 |
462 | 2024-03-31 10:43:53 | preplan | 1 | 69583 | 4 | 2.813 | 24736.2 |
461 | 2024-03-31 09:32:42 | preplan | 3 | 134027 | 169 | 22.000 | 6092.1 |
460 | 2024-03-29 18:20:51 | preplan | 1 | 69583 | 4 | 1.170 | 59472.6 |
459 | 2024-03-28 23:56:53 | preplan | 2 | 107671 | 17 | 8.953 | 12026.2 |
458 | 2024-03-28 20:56:18 | preplan | 3 | 134027 | 169 | 24.766 | 5411.7 |
457 | 2024-03-27 19:01:49 | preplan | 2 | 107671 | 17 | 3.483 | 30913.3 |
456 | 2024-03-27 19:01:37 | preplan | 2 | 107671 | 17 | 7.123 | 15116.0 |
455 | 2024-03-27 19:01:33 | preplan | 3 | 134027 | 169 | 7.703 | 17399.3 |
454 | 2024-03-27 19:01:29 | preplan | 1 | 69583 | 4 | 1.346 | 51696.1 |
453 | 2024-03-27 19:01:13 | preplan | 3 | 134027 | 169 | 7.076 | 18941.1 |
452 | 2024-03-27 15:56:42 | preplan | 3 | 134027 | 169 | 6.123 | 21889.1 |
451 | 2024-03-12 15:05:01 | preplan | 2 | 107671 | 17 | 2.923 | 36835.8 |
450 | 2024-01-03 00:57:57 | preplan | 3 | 134027 | 169 | 12.296 | 10900.0 |
449 | 2024-01-03 00:57:59 | preplan | 2 | 107671 | 17 | 3.763 | 28613.1 |
448 | 2023-12-24 17:11:56 | preplan | 1 | 69583 | 4 | 1.360 | 51164.0 |
447 | 2023-12-14 11:14:17 | preplan | 3 | 134027 | 169 | 6.796 | 19721.5 |
446 | 2023-12-14 11:14:15 | preplan | 2 | 107671 | 17 | 3.326 | 32372.5 |
445 | 2023-12-04 12:36:55 | preplan | 3 | 134027 | 169 | 7.456 | 17975.7 |
444 | 2023-12-04 12:21:43 | preplan | 3 | 134027 | 169 | 7.360 | 18210.2 |
443 | 2023-12-04 11:47:37 | preplan | 3 | 134027 | 169 | 7.296 | 18369.9 |
442 | 2023-12-01 11:13:08 | preplan | 3 | 134027 | 169 | 6.783 | 19759.3 |
441 | 2023-11-24 20:15:43 | preplan | 2 | 107671 | 17 | 3.500 | 30763.1 |
440 | 2023-11-14 16:19:40 | preplan | 1 | 69583 | 4 | 1.076 | 64668.2 |
439 | 2023-11-11 10:37:39 | preplan | 1 | 69583 | 4 | 1.093 | 63662.4 |
438 | 2023-11-09 00:46:37 | preplan | 1 | 69583 | 4 | 1.296 | 53690.6 |
437 | 2023-11-02 13:02:39 | preplan | 3 | 134027 | 169 | 6.390 | 20974.5 |
436 | 2023-11-02 13:02:37 | preplan | 2 | 107671 | 17 | 2.983 | 36094.9 |
435 | 2023-10-20 22:28:19 | preplan | 1 | 69583 | 4 | 1.236 | 56296.9 |
434 | 2023-10-18 05:13:24 | preplan | 1 | 69583 | 4 | 1.190 | 58473.1 |
433 | 2023-10-14 07:45:19 | preplan | 1 | 69583 | 4 | 1.110 | 62687.4 |
432 | 2023-10-04 13:20:50 | preplan | 1 | 69583 | 4 | 1.093 | 63662.4 |
431 | 2023-09-23 12:22:06 | preplan | 1 | 69583 | 4 | 1.076 | 64668.2 |
430 | 2023-09-12 06:46:20 | preplan | 1 | 69583 | 4 | 1.080 | 64428.7 |
429 | 2023-08-31 05:23:36 | preplan | 3 | 134027 | 169 | 6.750 | 19855.9 |
428 | 2023-08-24 19:19:49 | preplan | 2 | 107671 | 17 | 3.046 | 35348.3 |
427 | 2023-08-18 20:46:48 | preplan | 1 | 69583 | 4 | 1.313 | 52995.4 |
426 | 2023-05-11 02:49:03 | preplan | 3 | 134027 | 169 | 5.826 | 23005.0 |
425 | 2023-05-09 02:25:06 | preplan | 2 | 107671 | 17 | 2.780 | 38730.6 |
424 | 2023-04-27 06:11:32 | preplan | 1 | 69583 | 4 | 1.203 | 57841.2 |
423 | 2023-02-19 23:55:22 | preplan | 3 | 134027 | 169 | 5.720 | 23431.3 |
422 | 2023-02-16 18:46:03 | preplan | 2 | 107671 | 17 | 3.140 | 34290.1 |
421 | 2023-01-07 11:32:57 | preplan | 1 | 69583 | 4 | 1.063 | 65459.1 |
420 | 2023-01-03 17:31:09 | preplan | 1 | 69583 | 4 | 1.060 | 65644.3 |
419 | 2022-11-30 22:15:07 | preplan | 3 | 134027 | 169 | 7.763 | 17264.8 |
418 | 2022-11-28 15:28:11 | preplan | 2 | 107671 | 17 | 2.920 | 36873.6 |
417 | 2022-09-16 01:08:44 | preplan | 1 | 69583 | 4 | 1.093 | 63662.4 |
416 | 2022-09-02 12:45:12 | preplan | 1 | 69583 | 4 | 1.110 | 62687.4 |
415 | 2022-07-08 20:31:01 | preplan | 3 | 134027 | 169 | 5.826 | 23005.0 |
414 | 2022-07-07 23:18:07 | preplan | 2 | 107671 | 17 | 2.843 | 37872.3 |
413 | 2022-06-06 15:36:31 | preplan | 1 | 69583 | 4 | 1.110 | 62687.4 |
412 | 2022-04-30 00:18:53 | preplan | 1 | 69583 | 4 | 1.203 | 57841.2 |
411 | 2022-04-29 18:39:51 | preplan | 1 | 69583 | 4 | 1.063 | 65459.1 |
410 | 2022-04-26 07:23:10 | preplan | 1 | 69583 | 4 | 1.106 | 62914.1 |
409 | 2022-01-21 22:16:16 | preplan | 1 | 69583 | 4 | 1.216 | 57222.9 |
408 | 2022-01-09 19:02:24 | preplan | 1 | 69583 | 4 | 1.343 | 51811.6 |
407 | 2021-12-31 19:38:29 | preplan | 2 | 107671 | 17 | 4.656 | 23125.2 |
406 | 2021-12-31 08:58:30 | preplan | 2 | 107671 | 17 | 3.406 | 31612.2 |
405 | 2021-12-30 15:25:54 | preplan | 2 | 107671 | 17 | 3.050 | 35302.0 |
404 | 2021-12-30 00:58:32 | preplan | 2 | 107671 | 17 | 3.420 | 31482.7 |
403 | 2021-12-29 14:07:44 | preplan | 2 | 107671 | 17 | 3.623 | 29718.7 |
402 | 2021-12-29 05:11:41 | preplan | 2 | 107671 | 17 | 3.500 | 30763.1 |
401 | 2021-12-28 13:29:28 | preplan | 2 | 107671 | 17 | 6.233 | 17274.3 |
400 | 2021-12-27 17:18:30 | preplan | 2 | 107671 | 17 | 3.530 | 30501.7 |
399 | 2021-12-27 00:31:19 | preplan | 2 | 107671 | 17 | 4.093 | 26306.1 |
398 | 2021-12-26 13:45:43 | preplan | 2 | 107671 | 17 | 3.250 | 33129.5 |
397 | 2021-12-26 04:56:57 | preplan | 2 | 107671 | 17 | 3.063 | 35152.1 |
396 | 2021-12-25 12:40:46 | preplan | 2 | 107671 | 17 | 3.546 | 30364.1 |
395 | 2021-12-24 23:58:45 | preplan | 2 | 107671 | 17 | 3.110 | 34620.9 |
394 | 2021-12-24 10:16:10 | preplan | 2 | 107671 | 17 | 3.393 | 31733.3 |
393 | 2021-12-24 03:05:21 | preplan | 2 | 107671 | 17 | 3.236 | 33272.9 |
392 | 2021-12-11 18:00:48 | preplan | 1 | 69583 | 4 | 1.250 | 55666.4 |
391 | 2021-12-11 09:52:16 | preplan | 1 | 69583 | 4 | 2.750 | 25302.9 |
390 | 2021-12-10 19:11:25 | preplan | 1 | 69583 | 4 | 1.096 | 63488.1 |
389 | 2021-12-10 10:19:41 | preplan | 1 | 69583 | 4 | 1.313 | 52995.4 |
388 | 2021-12-10 01:20:29 | preplan | 1 | 69583 | 4 | 1.080 | 64428.7 |
387 | 2021-12-09 16:43:07 | preplan | 1 | 69583 | 4 | 1.300 | 53525.4 |
386 | 2021-12-09 01:33:05 | preplan | 1 | 69583 | 4 | 1.216 | 57222.9 |
385 | 2021-12-08 15:17:46 | preplan | 1 | 69583 | 4 | 1.233 | 56433.9 |
384 | 2021-12-08 05:38:47 | preplan | 1 | 69583 | 4 | 1.063 | 65459.1 |
383 | 2021-12-06 04:44:43 | preplan | 1 | 69583 | 4 | 1.076 | 64668.2 |
382 | 2021-11-24 17:06:37 | preplan | 2 | 107671 | 17 | 3.450 | 31209.0 |
381 | 2021-11-23 14:23:28 | preplan | 2 | 107671 | 17 | 3.000 | 35890.3 |
380 | 2021-11-22 17:29:07 | preplan | 2 | 107671 | 17 | 3.343 | 32207.9 |
379 | 2021-11-15 19:01:05 | preplan | 2 | 107671 | 17 | 3.033 | 35499.8 |
378 | 2021-11-15 10:43:01 | preplan | 2 | 107671 | 17 | 3.390 | 31761.4 |
377 | 2021-11-14 18:31:58 | preplan | 2 | 107671 | 17 | 3.000 | 35890.3 |
376 | 2021-11-14 10:10:08 | preplan | 2 | 107671 | 17 | 3.283 | 32796.5 |
375 | 2021-11-13 19:54:59 | preplan | 2 | 107671 | 17 | 3.610 | 29825.8 |
374 | 2021-11-13 11:44:11 | preplan | 2 | 107671 | 17 | 3.453 | 31181.9 |
373 | 2021-11-12 22:35:28 | preplan | 2 | 107671 | 17 | 2.873 | 37476.9 |
372 | 2021-11-12 09:06:10 | preplan | 2 | 107671 | 17 | 3.450 | 31209.0 |
371 | 2021-11-11 15:42:02 | preplan | 2 | 107671 | 17 | 3.233 | 33303.7 |
370 | 2021-11-11 06:21:14 | preplan | 2 | 107671 | 17 | 2.923 | 36835.8 |
369 | 2021-11-10 05:47:36 | preplan | 1 | 69583 | 4 | 1.126 | 61796.6 |
368 | 2021-11-08 12:46:41 | preplan | 1 | 69583 | 4 | 1.153 | 60349.5 |
367 | 2021-10-30 12:27:09 | preplan | 1 | 69583 | 4 | 1.060 | 65644.3 |
366 | 2021-10-29 11:06:44 | preplan | 1 | 69583 | 4 | 1.266 | 54962.9 |