History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"advises"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
445 | 2024-04-16 20:20:39 | advises | 1 | 69583 | 8 | 1.330 | 52318.0 |
444 | 2024-04-08 13:48:11 | advises | 3 | 134027 | 359 | 7.313 | 18327.2 |
443 | 2024-04-08 03:44:56 | advises | 3 | 134027 | 359 | 18.750 | 7148.1 |
442 | 2024-04-05 03:21:27 | advises | 3 | 134027 | 359 | 14.080 | 9519.0 |
441 | 2024-04-05 00:12:02 | advises | 3 | 134027 | 359 | 7.923 | 16916.2 |
440 | 2024-03-29 03:25:46 | advises | 1 | 69583 | 8 | 2.143 | 32469.9 |
439 | 2024-03-02 15:42:10 | advises | 1 | 69583 | 8 | 2.470 | 28171.3 |
438 | 2024-02-10 21:08:43 | advises | 1 | 69583 | 8 | 1.233 | 56433.9 |
437 | 2024-02-04 23:52:59 | advises | 1 | 69583 | 8 | 1.216 | 57222.9 |
436 | 2024-01-10 14:55:56 | advises | 2 | 107671 | 30 | 2.986 | 36058.6 |
435 | 2023-12-08 08:16:47 | advises | 3 | 134027 | 359 | 5.533 | 24223.2 |
434 | 2023-11-27 17:42:27 | advises | 1 | 69583 | 8 | 1.076 | 64668.2 |
433 | 2023-11-25 05:38:36 | advises | 3 | 134027 | 359 | 6.296 | 21287.6 |
432 | 2023-11-25 05:38:32 | advises | 2 | 107671 | 30 | 3.080 | 34958.1 |
431 | 2023-11-21 21:53:57 | advises | 1 | 69583 | 8 | 1.110 | 62687.4 |
430 | 2023-11-21 00:08:25 | advises | 1 | 69583 | 8 | 1.140 | 61037.7 |
429 | 2023-10-27 08:55:25 | advises | 1 | 69583 | 8 | 1.300 | 53525.4 |
428 | 2023-10-23 10:40:05 | advises | 1 | 69583 | 8 | 1.220 | 57035.2 |
427 | 2023-10-23 00:12:52 | advises | 1 | 69583 | 8 | 1.233 | 56433.9 |
426 | 2023-10-17 12:13:02 | advises | 2 | 107671 | 30 | 3.656 | 29450.5 |
425 | 2023-10-15 19:41:59 | advises | 1 | 69583 | 8 | 1.080 | 64428.7 |
424 | 2023-10-06 10:09:04 | advises | 1 | 69583 | 8 | 1.203 | 57841.2 |
423 | 2023-09-29 02:02:55 | advises | 2 | 107671 | 30 | 2.796 | 38508.9 |
422 | 2023-09-26 01:19:49 | advises | 1 | 69583 | 8 | 1.300 | 53525.4 |
421 | 2023-09-24 09:19:13 | advises | 1 | 69583 | 8 | 1.220 | 57035.2 |
420 | 2023-09-14 01:56:18 | advises | 1 | 69583 | 8 | 1.076 | 64668.2 |
419 | 2023-09-12 01:29:01 | advises | 3 | 134027 | 359 | 14.890 | 9001.1 |
418 | 2023-09-05 16:17:01 | advises | 3 | 134027 | 359 | 6.546 | 20474.6 |
417 | 2023-07-28 06:04:30 | advises | 2 | 107671 | 30 | 2.716 | 39643.2 |
416 | 2023-07-13 16:45:02 | advises | 1 | 69583 | 8 | 1.060 | 65644.3 |
415 | 2023-06-15 04:22:38 | advises | 1 | 69583 | 8 | 1.046 | 66522.9 |
414 | 2023-05-17 22:00:03 | advises | 3 | 134027 | 359 | 5.580 | 24019.2 |
413 | 2023-04-18 08:02:07 | advises | 3 | 134027 | 359 | 6.360 | 21073.4 |
412 | 2023-04-07 14:42:09 | advises | 2 | 107671 | 30 | 2.796 | 38508.9 |
411 | 2023-04-02 09:09:18 | advises | 1 | 69583 | 8 | 1.063 | 65459.1 |
410 | 2023-03-29 21:38:42 | advises | 1 | 69583 | 8 | 1.153 | 60349.5 |
409 | 2023-03-21 09:25:00 | advises | 3 | 134027 | 359 | 11.186 | 11981.7 |
408 | 2023-03-12 11:50:22 | advises | 1 | 69583 | 8 | 1.143 | 60877.5 |
407 | 2023-02-25 07:11:04 | advises | 3 | 134027 | 359 | 5.406 | 24792.3 |
406 | 2023-01-14 09:16:21 | advises | 1 | 69583 | 8 | 1.050 | 66269.5 |
405 | 2023-01-12 00:48:11 | advises | 2 | 107671 | 30 | 2.733 | 39396.6 |
404 | 2022-12-28 04:33:48 | advises | 1 | 69583 | 8 | 1.046 | 66522.9 |
403 | 2022-12-07 14:25:01 | advises | 3 | 134027 | 359 | 5.453 | 24578.6 |
402 | 2022-11-03 16:49:18 | advises | 1 | 69583 | 8 | 1.170 | 59472.6 |
401 | 2022-10-13 23:19:30 | advises | 2 | 107671 | 30 | 3.203 | 33615.7 |
400 | 2022-09-14 00:30:30 | advises | 1 | 69583 | 8 | 1.250 | 55666.4 |
399 | 2022-09-13 19:03:58 | advises | 1 | 69583 | 8 | 1.080 | 64428.7 |
398 | 2022-08-28 00:39:08 | advises | 1 | 69583 | 8 | 1.046 | 66522.9 |
397 | 2022-07-20 17:46:38 | advises | 3 | 134027 | 359 | 5.546 | 24166.4 |
396 | 2022-06-24 03:38:51 | advises | 1 | 69583 | 8 | 1.153 | 60349.5 |
395 | 2022-06-05 16:18:07 | advises | 1 | 69583 | 8 | 1.063 | 65459.1 |
394 | 2022-05-25 11:11:07 | advises | 1 | 69583 | 8 | 1.110 | 62687.4 |
393 | 2022-05-15 04:40:09 | advises | 2 | 107671 | 30 | 2.800 | 38453.9 |
392 | 2022-03-03 12:18:43 | advises | 1 | 69583 | 8 | 1.126 | 61796.6 |
391 | 2022-02-28 20:59:41 | advises | 3 | 134027 | 359 | 7.093 | 18895.7 |
390 | 2022-02-13 20:37:54 | advises | 1 | 69583 | 8 | 1.186 | 58670.3 |
389 | 2022-01-23 07:22:41 | advises | 2 | 107671 | 30 | 3.123 | 34476.8 |
388 | 2021-12-18 07:00:34 | advises | 1 | 69583 | 8 | 1.140 | 61037.7 |
387 | 2021-11-08 17:05:21 | advises | 1 | 69583 | 8 | 1.373 | 50679.5 |
386 | 2021-11-06 00:54:16 | advises | 1 | 69583 | 8 | 1.080 | 64428.7 |
385 | 2021-08-06 08:21:27 | advises | 1 | 69583 | 8 | 1.216 | 57222.9 |
384 | 2021-05-26 10:23:15 | advises | 1 | 69583 | 8 | 1.266 | 54962.9 |
383 | 2021-05-02 07:45:05 | advises | 1 | 69583 | 8 | 1.220 | 57035.2 |
382 | 2021-02-23 19:09:31 | advises | 1 | 69583 | 8 | 1.190 | 58473.1 |
381 | 2021-02-18 06:54:41 | advises | 1 | 69583 | 8 | 1.203 | 57841.2 |
380 | 2021-01-30 18:39:04 | advises | 1 | 69583 | 8 | 1.076 | 64668.2 |
379 | 2021-01-30 00:27:47 | advises | 1 | 69583 | 8 | 2.343 | 29698.3 |
378 | 2021-01-02 20:43:43 | advises | 1 | 69583 | 8 | 1.076 | 64668.2 |
377 | 2020-11-23 11:05:08 | advises | 1 | 69583 | 8 | 1.076 | 64668.2 |
376 | 2020-11-02 12:19:05 | advises | 3 | 134027 | 359 | 6.923 | 19359.7 |
375 | 2020-11-02 12:19:01 | advises | 2 | 107671 | 30 | 3.313 | 32499.5 |
374 | 2020-11-02 12:19:00 | advises | 1 | 69583 | 8 | 1.093 | 63662.4 |
373 | 2020-10-30 17:21:53 | advises | 1 | 69583 | 8 | 1.076 | 64668.2 |
372 | 2020-10-27 08:08:56 | advises | 1 | 69583 | 8 | 1.203 | 57841.2 |
371 | 2020-10-18 09:52:40 | advises | 1 | 69583 | 8 | 1.093 | 63662.4 |
370 | 2020-10-18 03:26:23 | advises | 1 | 69583 | 8 | 1.080 | 64428.7 |
369 | 2020-09-23 18:42:07 | advises | 1 | 69583 | 8 | 1.060 | 65644.3 |
368 | 2020-08-31 07:30:21 | advises | 1 | 69583 | 8 | 2.483 | 28023.8 |
367 | 2020-07-28 01:51:43 | advises | 1 | 69583 | 8 | 1.250 | 55666.4 |
366 | 2020-07-26 16:08:20 | advises | 1 | 69583 | 8 | 1.126 | 61796.6 |
365 | 2020-05-28 12:45:08 | advises | 1 | 69583 | 8 | 1.190 | 58473.1 |
364 | 2020-04-24 10:11:40 | advises | 1 | 69583 | 8 | 1.063 | 65459.1 |
363 | 2020-03-29 15:02:54 | advises | 1 | 69583 | 8 | 1.266 | 54962.9 |
362 | 2020-03-25 19:01:54 | advises | 1 | 69583 | 8 | 1.203 | 57841.2 |
361 | 2020-03-24 16:56:23 | advises | 1 | 69583 | 8 | 1.076 | 64668.2 |
360 | 2020-03-21 02:55:33 | advises | 1 | 69583 | 8 | 1.093 | 63662.4 |
359 | 2020-02-27 23:51:55 | advises | 1 | 69583 | 8 | 2.436 | 28564.4 |
358 | 2020-02-27 22:36:17 | advises | 1 | 69583 | 8 | 1.123 | 61961.7 |
357 | 2020-02-23 18:21:13 | advises | 1 | 69583 | 8 | 1.080 | 64428.7 |
356 | 2020-02-22 07:31:16 | advises | 1 | 69583 | 8 | 1.390 | 50059.7 |
355 | 2020-02-17 23:37:51 | advises | 1 | 69583 | 8 | 1.846 | 37693.9 |
354 | 2020-02-16 19:49:33 | advises | 3 | 134027 | 359 | 16.736 | 8008.3 |
353 | 2020-02-10 18:01:40 | advises | 1 | 69583 | 8 | 1.220 | 57035.2 |
352 | 2020-02-10 17:20:40 | advises | 3 | 134027 | 359 | 7.983 | 16789.1 |
351 | 2020-02-10 16:53:02 | advises | 3 | 134027 | 359 | 16.503 | 8121.4 |
350 | 2020-02-10 15:31:52 | advises | 3 | 134027 | 359 | 15.843 | 8459.7 |
349 | 2020-02-10 06:27:55 | advises | 3 | 134027 | 359 | 8.580 | 15620.9 |
348 | 2020-02-09 17:23:43 | advises | 1 | 69583 | 8 | 1.280 | 54361.7 |
347 | 2020-02-05 00:35:01 | advises | 1 | 69583 | 8 | 1.140 | 61037.7 |
346 | 2020-02-04 02:57:18 | advises | 1 | 69583 | 8 | 1.280 | 54361.7 |