History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shawn"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
435 | 2024-04-23 22:43:11 | shawn | 1 | 28756 | 10 | 1.250 | 23004.8 |
434 | 2024-04-23 01:52:18 | shawn | 2 | 53800 | 114 | 1.923 | 27977.1 |
433 | 2024-04-05 17:27:23 | shawn | 2 | 53800 | 114 | 2.186 | 24611.2 |
432 | 2024-04-05 17:15:38 | shawn | 1 | 28756 | 10 | 0.656 | 43835.4 |
431 | 2024-03-31 10:03:09 | shawn | 2 | 53800 | 114 | 3.766 | 14285.7 |
430 | 2024-03-31 08:30:59 | shawn | 1 | 28756 | 10 | 0.673 | 42728.1 |
429 | 2024-03-28 18:50:25 | shawn | 2 | 53800 | 114 | 5.313 | 10126.1 |
428 | 2024-03-28 18:16:21 | shawn | 1 | 28756 | 10 | 1.123 | 25606.4 |
427 | 2024-03-04 09:37:45 | shawn | 2 | 53800 | 114 | 5.703 | 9433.6 |
426 | 2024-03-04 06:40:38 | shawn | 1 | 28756 | 10 | 0.530 | 54256.6 |
425 | 2024-03-01 07:29:32 | shawn | 1 | 28756 | 10 | 0.513 | 56054.6 |
424 | 2024-02-26 22:54:07 | shawn | 2 | 53800 | 114 | 3.550 | 15154.9 |
423 | 2024-02-26 19:31:35 | shawn | 1 | 28756 | 10 | 0.533 | 53951.2 |
422 | 2024-02-03 03:37:35 | shawn | 1 | 28756 | 10 | 1.063 | 27051.7 |
421 | 2024-01-28 22:25:00 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
420 | 2024-01-21 07:06:25 | shawn | 1 | 28756 | 10 | 0.450 | 63902.2 |
419 | 2023-12-25 03:15:27 | shawn | 2 | 53800 | 114 | 1.483 | 36277.8 |
418 | 2023-12-16 10:21:42 | shawn | 2 | 53800 | 114 | 1.423 | 37807.4 |
417 | 2023-11-19 10:58:46 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
416 | 2023-11-17 13:47:55 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
415 | 2023-11-12 08:30:01 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
414 | 2023-11-05 17:41:48 | shawn | 1 | 28756 | 10 | 0.530 | 54256.6 |
413 | 2023-10-31 03:29:59 | shawn | 1 | 28756 | 10 | 0.546 | 52666.7 |
412 | 2023-10-20 15:41:40 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
411 | 2023-10-13 13:45:42 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
410 | 2023-10-07 22:24:43 | shawn | 1 | 28756 | 10 | 0.436 | 65954.1 |
409 | 2023-10-06 02:33:27 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
408 | 2023-09-26 15:16:42 | shawn | 2 | 53800 | 114 | 1.670 | 32215.6 |
407 | 2023-09-19 15:49:41 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
406 | 2023-09-16 09:35:31 | shawn | 2 | 53800 | 114 | 1.576 | 34137.1 |
405 | 2023-09-11 19:13:35 | shawn | 1 | 28756 | 10 | 0.466 | 61708.2 |
404 | 2023-09-04 15:59:43 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
403 | 2023-06-19 23:42:02 | shawn | 2 | 53800 | 114 | 1.656 | 32487.9 |
402 | 2023-06-11 06:23:21 | shawn | 1 | 28756 | 10 | 0.513 | 56054.6 |
401 | 2023-06-11 03:37:24 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
400 | 2023-03-30 15:15:20 | shawn | 1 | 28756 | 10 | 0.513 | 56054.6 |
399 | 2023-03-17 21:40:15 | shawn | 2 | 53800 | 114 | 1.373 | 39184.3 |
398 | 2023-02-19 18:28:04 | shawn | 1 | 28756 | 10 | 0.436 | 65954.1 |
397 | 2023-01-13 01:31:11 | shawn | 1 | 28756 | 10 | 0.450 | 63902.2 |
396 | 2022-12-20 10:51:40 | shawn | 2 | 53800 | 114 | 1.376 | 39098.8 |
395 | 2022-11-02 18:09:37 | shawn | 1 | 28756 | 10 | 0.440 | 65354.5 |
394 | 2022-10-19 07:47:21 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
393 | 2022-09-10 22:28:09 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
392 | 2022-08-20 00:37:13 | shawn | 2 | 53800 | 114 | 1.420 | 37887.3 |
391 | 2022-07-29 07:32:48 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
390 | 2022-07-18 02:57:52 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
389 | 2022-07-04 07:43:21 | shawn | 2 | 53800 | 114 | 1.453 | 37026.8 |
388 | 2022-07-03 16:35:06 | shawn | 1 | 28756 | 10 | 0.470 | 61183.0 |
387 | 2022-07-03 06:25:48 | shawn | 1 | 28756 | 10 | 0.516 | 55728.7 |
386 | 2022-06-22 04:02:54 | shawn | 1 | 28756 | 10 | 0.450 | 63902.2 |
385 | 2022-06-10 11:34:10 | shawn | 1 | 28756 | 10 | 0.466 | 61708.2 |
384 | 2022-06-09 02:22:41 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
383 | 2022-03-03 17:41:53 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
382 | 2022-02-06 04:41:50 | shawn | 1 | 28756 | 10 | 0.516 | 55728.7 |
381 | 2022-01-02 07:23:45 | shawn | 1 | 28756 | 10 | 0.530 | 54256.6 |
380 | 2021-10-10 02:07:22 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
379 | 2021-09-20 01:51:22 | shawn | 1 | 28756 | 10 | 0.470 | 61183.0 |
378 | 2021-09-04 22:03:45 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
377 | 2021-07-08 05:24:44 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
376 | 2021-05-25 11:39:27 | shawn | 1 | 28756 | 10 | 0.513 | 56054.6 |
375 | 2021-04-08 10:06:00 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
374 | 2021-04-04 06:13:52 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
373 | 2021-02-24 17:07:21 | shawn | 1 | 28756 | 10 | 0.450 | 63902.2 |
372 | 2021-02-18 21:14:56 | shawn | 1 | 28756 | 10 | 0.546 | 52666.7 |
371 | 2021-01-12 13:40:08 | shawn | 1 | 28756 | 10 | 0.470 | 61183.0 |
370 | 2020-12-30 05:51:50 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
369 | 2020-12-24 17:14:32 | shawn | 1 | 28756 | 10 | 0.466 | 61708.2 |
368 | 2020-11-06 07:31:55 | shawn | 1 | 28756 | 10 | 0.513 | 56054.6 |
367 | 2020-10-22 19:26:12 | shawn | 1 | 28756 | 10 | 0.466 | 61708.2 |
366 | 2020-09-30 00:03:52 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
365 | 2020-09-26 22:57:52 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
364 | 2020-09-09 12:26:52 | shawn | 1 | 28756 | 10 | 0.530 | 54256.6 |
363 | 2020-09-03 11:50:38 | shawn | 1 | 28756 | 10 | 0.626 | 45936.1 |
362 | 2020-08-28 18:32:43 | shawn | 1 | 28756 | 10 | 0.436 | 65954.1 |
361 | 2020-08-25 12:33:08 | shawn | 1 | 28756 | 10 | 0.513 | 56054.6 |
360 | 2020-08-08 01:13:21 | shawn | 1 | 28756 | 10 | 0.466 | 61708.2 |
359 | 2020-08-04 18:32:48 | shawn | 1 | 28756 | 10 | 0.470 | 61183.0 |
358 | 2020-08-01 11:31:02 | shawn | 1 | 28756 | 10 | 0.470 | 61183.0 |
357 | 2020-06-14 23:41:01 | shawn | 1 | 28756 | 10 | 0.483 | 59536.2 |
356 | 2020-06-12 00:05:01 | shawn | 1 | 28756 | 10 | 0.470 | 61183.0 |
355 | 2020-04-26 10:04:40 | shawn | 1 | 28756 | 10 | 0.436 | 65954.1 |
354 | 2020-03-25 12:00:33 | shawn | 1 | 28756 | 10 | 0.546 | 52666.7 |
353 | 2020-03-23 16:03:27 | shawn | 1 | 28756 | 10 | 0.466 | 61708.2 |
352 | 2020-03-21 23:34:11 | shawn | 1 | 28756 | 10 | 0.453 | 63479.0 |
351 | 2020-03-21 23:11:46 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
350 | 2020-03-21 01:21:05 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
349 | 2020-03-17 20:07:36 | shawn | 1 | 28756 | 10 | 0.530 | 54256.6 |
348 | 2020-03-04 14:10:37 | shawn | 1 | 28756 | 10 | 0.623 | 46157.3 |
347 | 2020-03-01 16:46:36 | shawn | 1 | 28756 | 10 | 0.500 | 57512.0 |
346 | 2020-02-25 23:15:39 | shawn | 1 | 28756 | 10 | 1.173 | 24514.9 |
345 | 2020-02-25 21:29:16 | shawn | 1 | 28756 | 10 | 0.516 | 55728.7 |
344 | 2020-02-25 02:53:52 | shawn | 1 | 28756 | 10 | 0.576 | 49923.6 |
343 | 2020-02-22 22:29:04 | shawn | 1 | 28756 | 10 | 0.516 | 55728.7 |
342 | 2020-02-21 15:26:17 | shawn | 1 | 28756 | 10 | 0.596 | 48248.3 |
341 | 2020-02-15 04:41:55 | shawn | 1 | 28756 | 10 | 0.593 | 48492.4 |
340 | 2020-02-12 06:49:16 | shawn | 1 | 28756 | 10 | 1.686 | 17055.8 |
339 | 2020-01-31 10:27:59 | shawn | 1 | 28756 | 10 | 0.533 | 53951.2 |
338 | 2020-01-31 05:26:11 | shawn | 1 | 28756 | 10 | 1.076 | 26724.9 |
337 | 2020-01-29 23:38:14 | shawn | 1 | 28756 | 10 | 0.513 | 56054.6 |
336 | 2020-01-29 18:08:08 | shawn | 1 | 28756 | 10 | 0.530 | 54256.6 |