History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"suggest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
470 | 2024-03-17 03:07:26 | suggest | 1 | 69583 | 4 | 1.123 | 61961.7 |
469 | 2024-03-11 01:28:01 | suggest | 3 | 134027 | 288 | 13.030 | 10286.0 |
468 | 2024-03-07 17:01:13 | suggest | 3 | 134027 | 288 | 6.080 | 22043.9 |
467 | 2024-03-06 21:18:55 | suggest | 3 | 134027 | 288 | 22.456 | 5968.4 |
466 | 2024-03-06 12:05:26 | suggest | 3 | 134027 | 288 | 23.393 | 5729.4 |
465 | 2024-03-05 17:50:41 | suggest | 3 | 134027 | 288 | 16.440 | 8152.5 |
464 | 2024-03-05 11:13:24 | suggest | 3 | 134027 | 288 | 7.643 | 17535.9 |
463 | 2024-03-05 11:13:17 | suggest | 2 | 107671 | 24 | 3.780 | 28484.4 |
462 | 2024-03-05 01:05:25 | suggest | 2 | 107671 | 24 | 6.030 | 17855.9 |
461 | 2024-03-02 10:06:20 | suggest | 2 | 107671 | 24 | 11.530 | 9338.3 |
460 | 2024-02-25 20:53:24 | suggest | 2 | 107671 | 24 | 3.610 | 29825.8 |
459 | 2024-01-22 02:30:07 | suggest | 1 | 69583 | 4 | 1.076 | 64668.2 |
458 | 2023-12-28 07:35:01 | suggest | 1 | 69583 | 4 | 1.126 | 61796.6 |
457 | 2023-12-27 03:35:47 | suggest | 2 | 107671 | 24 | 7.250 | 14851.2 |
456 | 2023-12-16 14:38:57 | suggest | 3 | 134027 | 288 | 5.733 | 23378.2 |
455 | 2023-11-27 07:44:07 | suggest | 3 | 134027 | 288 | 5.923 | 22628.2 |
454 | 2023-11-23 03:06:25 | suggest | 1 | 69583 | 4 | 1.123 | 61961.7 |
453 | 2023-11-21 06:23:53 | suggest | 2 | 107671 | 24 | 2.876 | 37437.8 |
452 | 2023-11-19 10:06:37 | suggest | 1 | 69583 | 4 | 1.123 | 61961.7 |
451 | 2023-11-18 17:39:30 | suggest | 3 | 134027 | 288 | 6.263 | 21399.8 |
450 | 2023-11-12 19:42:46 | suggest | 1 | 69583 | 4 | 1.110 | 62687.4 |
449 | 2023-11-12 00:51:41 | suggest | 2 | 107671 | 24 | 3.643 | 29555.6 |
448 | 2023-11-06 11:24:02 | suggest | 1 | 69583 | 4 | 1.203 | 57841.2 |
447 | 2023-11-06 01:44:29 | suggest | 1 | 69583 | 4 | 1.110 | 62687.4 |
446 | 2023-11-05 08:03:01 | suggest | 2 | 107671 | 24 | 3.266 | 32967.2 |
445 | 2023-11-01 02:31:14 | suggest | 1 | 69583 | 4 | 1.296 | 53690.6 |
444 | 2023-10-21 14:15:26 | suggest | 3 | 134027 | 288 | 9.266 | 14464.4 |
443 | 2023-10-16 17:06:21 | suggest | 3 | 134027 | 288 | 5.673 | 23625.4 |
442 | 2023-09-28 09:53:12 | suggest | 1 | 69583 | 4 | 1.250 | 55666.4 |
441 | 2023-09-25 01:23:20 | suggest | 1 | 69583 | 4 | 1.076 | 64668.2 |
440 | 2023-09-06 02:26:32 | suggest | 1 | 69583 | 4 | 1.300 | 53525.4 |
439 | 2023-08-25 22:46:25 | suggest | 3 | 134027 | 288 | 5.796 | 23124.1 |
438 | 2023-08-22 00:28:25 | suggest | 2 | 107671 | 24 | 2.813 | 38276.2 |
437 | 2023-07-14 22:26:24 | suggest | 1 | 69583 | 4 | 1.156 | 60192.9 |
436 | 2023-06-12 21:54:23 | suggest | 1 | 69583 | 4 | 1.110 | 62687.4 |
435 | 2023-05-17 09:18:56 | suggest | 3 | 134027 | 288 | 5.500 | 24368.5 |
434 | 2023-05-12 05:34:45 | suggest | 3 | 134027 | 288 | 5.623 | 23835.5 |
433 | 2023-05-07 18:04:58 | suggest | 2 | 107671 | 24 | 2.810 | 38317.1 |
432 | 2023-04-01 08:55:31 | suggest | 1 | 69583 | 4 | 1.203 | 57841.2 |
431 | 2023-03-07 03:41:31 | suggest | 1 | 69583 | 4 | 1.126 | 61796.6 |
430 | 2023-02-19 00:41:49 | suggest | 3 | 134027 | 288 | 8.720 | 15370.1 |
429 | 2023-02-14 01:25:31 | suggest | 2 | 107671 | 24 | 2.766 | 38926.6 |
428 | 2023-01-16 00:17:03 | suggest | 1 | 69583 | 4 | 1.173 | 59320.5 |
427 | 2022-12-02 13:34:23 | suggest | 3 | 134027 | 288 | 5.546 | 24166.4 |
426 | 2022-11-25 03:39:56 | suggest | 2 | 107671 | 24 | 2.873 | 37476.9 |
425 | 2022-11-13 00:23:20 | suggest | 1 | 69583 | 4 | 1.076 | 64668.2 |
424 | 2022-10-28 09:05:22 | suggest | 1 | 69583 | 4 | 1.123 | 61961.7 |
423 | 2022-07-29 08:16:33 | suggest | 1 | 69583 | 4 | 1.110 | 62687.4 |
422 | 2022-07-03 19:38:43 | suggest | 1 | 69583 | 4 | 1.390 | 50059.7 |
421 | 2022-06-23 12:15:04 | suggest | 1 | 69583 | 4 | 1.170 | 59472.6 |
420 | 2022-06-19 18:25:35 | suggest | 1 | 69583 | 4 | 1.093 | 63662.4 |
419 | 2022-04-29 16:00:56 | suggest | 2 | 107671 | 24 | 4.373 | 24621.8 |
418 | 2022-04-22 20:31:55 | suggest | 3 | 134027 | 288 | 6.703 | 19995.1 |
417 | 2022-03-14 05:44:03 | suggest | 3 | 134027 | 288 | 6.206 | 21596.4 |
416 | 2022-03-04 08:58:01 | suggest | 1 | 69583 | 4 | 1.233 | 56433.9 |
415 | 2022-02-11 11:43:28 | suggest | 1 | 69583 | 4 | 1.296 | 53690.6 |
414 | 2022-02-07 23:39:38 | suggest | 1 | 69583 | 4 | 1.096 | 63488.1 |
413 | 2021-12-28 04:59:04 | suggest | 3 | 134027 | 288 | 5.750 | 23309.0 |
412 | 2021-12-19 04:08:22 | suggest | 1 | 69583 | 4 | 1.280 | 54361.7 |
411 | 2021-10-24 04:21:31 | suggest | 1 | 69583 | 4 | 1.296 | 53690.6 |
410 | 2021-10-15 00:44:25 | suggest | 1 | 69583 | 4 | 1.220 | 57035.2 |
409 | 2021-10-10 09:55:10 | suggest | 3 | 134027 | 288 | 6.843 | 19586.0 |
408 | 2021-10-05 06:15:07 | suggest | 3 | 134027 | 288 | 5.783 | 23176.0 |
407 | 2021-10-02 02:34:58 | suggest | 3 | 134027 | 288 | 7.453 | 17983.0 |
406 | 2021-09-27 04:06:00 | suggest | 1 | 69583 | 4 | 1.080 | 64428.7 |
405 | 2021-09-25 00:37:41 | suggest | 1 | 69583 | 4 | 1.076 | 64668.2 |
404 | 2021-09-21 10:30:18 | suggest | 1 | 69583 | 4 | 1.186 | 58670.3 |
403 | 2021-09-21 00:12:38 | suggest | 1 | 69583 | 4 | 1.266 | 54962.9 |
402 | 2021-09-20 06:59:05 | suggest | 1 | 69583 | 4 | 1.343 | 51811.6 |
401 | 2021-09-14 22:57:24 | suggest | 3 | 134027 | 288 | 6.406 | 20922.1 |
400 | 2021-09-14 04:57:58 | suggest | 1 | 69583 | 4 | 1.233 | 56433.9 |
399 | 2021-08-15 08:11:44 | suggest | 3 | 134027 | 288 | 5.860 | 22871.5 |
398 | 2021-08-11 10:01:40 | suggest | 3 | 134027 | 288 | 5.796 | 23124.1 |
397 | 2021-07-28 04:56:04 | suggest | 3 | 134027 | 288 | 6.110 | 21935.7 |
396 | 2021-07-27 08:07:29 | suggest | 3 | 134027 | 288 | 6.313 | 21230.3 |
395 | 2021-07-26 12:23:35 | suggest | 3 | 134027 | 288 | 6.470 | 20715.1 |
394 | 2021-07-24 04:53:32 | suggest | 3 | 134027 | 288 | 6.003 | 22326.7 |
393 | 2021-07-23 05:53:58 | suggest | 3 | 134027 | 288 | 6.876 | 19492.0 |
392 | 2021-07-22 05:18:19 | suggest | 3 | 134027 | 288 | 6.143 | 21817.8 |
391 | 2021-07-20 11:44:32 | suggest | 3 | 134027 | 288 | 5.800 | 23108.1 |
390 | 2021-07-19 02:13:29 | suggest | 3 | 134027 | 288 | 5.563 | 24092.6 |
389 | 2021-07-18 15:43:29 | suggest | 3 | 134027 | 288 | 6.500 | 20619.5 |
388 | 2021-07-17 00:55:22 | suggest | 3 | 134027 | 288 | 6.016 | 22278.4 |
387 | 2021-07-14 01:39:43 | suggest | 1 | 69583 | 4 | 1.233 | 56433.9 |
386 | 2021-07-10 19:38:04 | suggest | 3 | 134027 | 288 | 6.856 | 19548.9 |
385 | 2021-07-09 12:22:23 | suggest | 3 | 134027 | 288 | 6.530 | 20524.8 |
384 | 2021-07-08 17:11:44 | suggest | 3 | 134027 | 288 | 6.440 | 20811.6 |
383 | 2021-07-07 16:36:31 | suggest | 3 | 134027 | 288 | 5.796 | 23124.1 |
382 | 2021-07-05 20:20:52 | suggest | 3 | 134027 | 288 | 6.313 | 21230.3 |
381 | 2021-07-04 14:53:33 | suggest | 3 | 134027 | 288 | 6.846 | 19577.4 |
380 | 2021-07-02 15:49:38 | suggest | 3 | 134027 | 288 | 7.190 | 18640.8 |
379 | 2021-06-30 19:53:36 | suggest | 3 | 134027 | 288 | 6.970 | 19229.1 |
378 | 2021-06-26 19:41:18 | suggest | 3 | 134027 | 288 | 10.080 | 13296.3 |
377 | 2021-06-24 21:10:03 | suggest | 3 | 134027 | 288 | 11.486 | 11668.7 |
376 | 2021-06-23 19:43:57 | suggest | 3 | 134027 | 288 | 6.860 | 19537.5 |
375 | 2021-06-22 14:47:43 | suggest | 3 | 134027 | 288 | 6.876 | 19492.0 |
374 | 2021-04-19 23:31:42 | suggest | 3 | 134027 | 288 | 6.686 | 20045.9 |
373 | 2021-04-17 17:16:38 | suggest | 3 | 134027 | 288 | 6.860 | 19537.5 |
372 | 2021-04-10 19:11:24 | suggest | 1 | 69583 | 4 | 1.280 | 54361.7 |
371 | 2021-02-26 08:21:49 | suggest | 1 | 69583 | 4 | 1.110 | 62687.4 |