History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spell"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
466 | 2024-04-03 04:35:17 | spell | 2 | 53800 | 111 | 3.000 | 17933.3 |
465 | 2024-04-03 04:21:16 | spell | 1 | 28756 | 13 | 0.576 | 49923.6 |
464 | 2024-03-31 02:44:32 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
463 | 2024-03-03 21:21:16 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
462 | 2024-02-25 19:16:33 | spell | 1 | 28756 | 13 | 0.466 | 61708.2 |
461 | 2024-02-03 03:44:31 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
460 | 2024-02-02 21:34:19 | spell | 1 | 28756 | 13 | 0.483 | 59536.2 |
459 | 2024-01-28 17:25:52 | spell | 1 | 28756 | 13 | 1.046 | 27491.4 |
458 | 2024-01-26 02:12:57 | spell | 1 | 28756 | 13 | 0.530 | 54256.6 |
457 | 2024-01-19 10:36:56 | spell | 2 | 53800 | 111 | 1.330 | 40451.1 |
456 | 2024-01-01 14:39:34 | spell | 1 | 28756 | 13 | 0.450 | 63902.2 |
455 | 2023-12-22 06:12:32 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
454 | 2023-12-02 16:56:06 | spell | 2 | 53800 | 111 | 1.440 | 37361.1 |
453 | 2023-11-27 11:16:41 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
452 | 2023-11-22 03:49:24 | spell | 2 | 53800 | 111 | 1.546 | 34799.5 |
451 | 2023-11-18 18:40:07 | spell | 1 | 28756 | 13 | 0.486 | 59168.7 |
450 | 2023-11-01 04:23:42 | spell | 2 | 53800 | 111 | 1.626 | 33087.3 |
449 | 2023-10-31 04:11:13 | spell | 2 | 53800 | 111 | 1.826 | 29463.3 |
448 | 2023-10-27 05:42:50 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
447 | 2023-10-22 06:17:47 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
446 | 2023-10-21 06:11:39 | spell | 1 | 28756 | 13 | 0.546 | 52666.7 |
445 | 2023-10-13 04:57:15 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
444 | 2023-10-05 14:03:26 | spell | 1 | 28756 | 13 | 0.470 | 61183.0 |
443 | 2023-09-26 19:37:24 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
442 | 2023-09-24 21:16:39 | spell | 1 | 28756 | 13 | 0.780 | 36866.7 |
441 | 2023-09-12 01:45:10 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
440 | 2023-08-27 01:25:33 | spell | 1 | 28756 | 13 | 0.486 | 59168.7 |
439 | 2023-08-26 17:32:35 | spell | 2 | 53800 | 111 | 1.610 | 33416.1 |
438 | 2023-08-07 19:09:54 | spell | 2 | 53800 | 111 | 1.580 | 34050.6 |
437 | 2023-06-25 05:15:52 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
436 | 2023-04-25 01:53:11 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
435 | 2023-04-18 17:55:42 | spell | 2 | 53800 | 111 | 1.686 | 31909.8 |
434 | 2023-04-06 11:44:41 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
433 | 2023-01-26 15:39:13 | spell | 2 | 53800 | 111 | 1.360 | 39558.8 |
432 | 2023-01-24 11:15:03 | spell | 2 | 53800 | 111 | 1.516 | 35488.1 |
431 | 2023-01-19 21:27:08 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
430 | 2023-01-17 08:31:14 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
429 | 2022-12-25 02:39:05 | spell | 1 | 28756 | 13 | 0.440 | 65354.5 |
428 | 2022-11-17 09:45:41 | spell | 1 | 28756 | 13 | 0.576 | 49923.6 |
427 | 2022-11-08 21:26:32 | spell | 2 | 53800 | 111 | 1.750 | 30742.9 |
426 | 2022-08-21 06:32:23 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
425 | 2022-08-01 16:43:41 | spell | 2 | 53800 | 111 | 1.470 | 36598.6 |
424 | 2022-07-29 05:09:34 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
423 | 2022-07-19 04:55:02 | spell | 2 | 53800 | 111 | 1.640 | 32804.9 |
422 | 2022-07-08 00:31:39 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
421 | 2022-05-11 19:07:43 | spell | 2 | 53800 | 111 | 1.466 | 36698.5 |
420 | 2022-04-20 16:41:06 | spell | 1 | 28756 | 13 | 0.673 | 42728.1 |
419 | 2022-03-10 14:57:40 | spell | 1 | 28756 | 13 | 0.720 | 39938.9 |
418 | 2022-03-08 11:17:14 | spell | 1 | 28756 | 13 | 0.546 | 52666.7 |
417 | 2022-01-09 04:05:27 | spell | 2 | 53800 | 111 | 1.466 | 36698.5 |
416 | 2021-12-26 02:22:31 | spell | 1 | 28756 | 13 | 0.513 | 56054.6 |
415 | 2021-12-18 22:03:27 | spell | 1 | 28756 | 13 | 0.533 | 53951.2 |
414 | 2021-10-23 22:34:04 | spell | 1 | 28756 | 13 | 0.516 | 55728.7 |
413 | 2021-09-14 02:12:24 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
412 | 2021-09-12 11:41:23 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
411 | 2021-08-27 12:24:21 | spell | 1 | 28756 | 13 | 0.986 | 29164.3 |
410 | 2021-06-12 06:24:55 | spell | 1 | 28756 | 13 | 0.466 | 61708.2 |
409 | 2021-05-09 14:09:50 | spell | 1 | 28756 | 13 | 0.516 | 55728.7 |
408 | 2021-03-12 20:40:11 | spell | 1 | 28756 | 13 | 0.530 | 54256.6 |
407 | 2020-12-09 16:29:08 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
406 | 2020-11-07 16:28:00 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
405 | 2020-10-15 09:48:06 | spell | 1 | 28756 | 13 | 0.450 | 63902.2 |
404 | 2020-09-27 10:36:49 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
403 | 2020-09-03 01:15:47 | spell | 1 | 28756 | 13 | 0.470 | 61183.0 |
402 | 2020-08-26 07:20:32 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
401 | 2020-08-23 09:40:57 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
400 | 2020-08-23 09:19:25 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
399 | 2020-08-12 18:04:29 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
398 | 2020-05-19 22:02:15 | spell | 1 | 28756 | 13 | 0.470 | 61183.0 |
397 | 2020-05-16 13:00:33 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
396 | 2020-03-29 22:39:37 | spell | 1 | 28756 | 13 | 0.546 | 52666.7 |
395 | 2020-03-27 14:53:43 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
394 | 2020-03-27 00:08:51 | spell | 1 | 28756 | 13 | 0.516 | 55728.7 |
393 | 2020-03-23 02:16:56 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
392 | 2020-03-21 16:07:37 | spell | 1 | 28756 | 13 | 0.500 | 57512.0 |
391 | 2020-03-18 15:44:39 | spell | 1 | 28756 | 13 | 0.466 | 61708.2 |
390 | 2020-03-16 19:23:58 | spell | 1 | 28756 | 13 | 0.436 | 65954.1 |
389 | 2020-03-02 19:09:39 | spell | 1 | 28756 | 13 | 0.486 | 59168.7 |
388 | 2020-03-01 08:42:54 | spell | 1 | 28756 | 13 | 1.046 | 27491.4 |
387 | 2020-03-01 07:49:15 | spell | 1 | 28756 | 13 | 0.563 | 51076.4 |
386 | 2020-02-23 02:54:44 | spell | 1 | 28756 | 13 | 0.563 | 51076.4 |
385 | 2020-02-21 06:44:47 | spell | 1 | 28756 | 13 | 0.530 | 54256.6 |
384 | 2020-02-14 21:04:33 | spell | 1 | 28756 | 13 | 1.156 | 24875.4 |
383 | 2020-02-14 16:53:19 | spell | 1 | 28756 | 13 | 0.546 | 52666.7 |
382 | 2020-02-11 06:01:09 | spell | 1 | 28756 | 13 | 1.673 | 17188.3 |
381 | 2020-02-11 02:17:49 | spell | 1 | 28756 | 13 | 0.546 | 52666.7 |
380 | 2020-01-31 16:20:37 | spell | 1 | 28756 | 13 | 0.720 | 39938.9 |
379 | 2020-01-31 03:29:02 | spell | 1 | 28756 | 13 | 0.576 | 49923.6 |
378 | 2020-01-31 02:12:21 | spell | 1 | 28756 | 13 | 1.000 | 28756.0 |
377 | 2020-01-24 19:08:45 | spell | 1 | 28756 | 13 | 0.546 | 52666.7 |
376 | 2020-01-24 13:38:36 | spell | 1 | 28756 | 13 | 1.123 | 25606.4 |
375 | 2020-01-21 19:39:26 | spell | 1 | 28756 | 13 | 1.000 | 28756.0 |
374 | 2020-01-12 23:13:21 | spell | 1 | 28756 | 13 | 0.813 | 35370.2 |
373 | 2020-01-12 10:28:07 | spell | 1 | 28756 | 13 | 1.110 | 25906.3 |
372 | 2020-01-08 08:17:04 | spell | 1 | 28756 | 13 | 1.123 | 25606.4 |
371 | 2020-01-03 10:19:17 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
370 | 2019-12-26 05:30:46 | spell | 1 | 28756 | 13 | 1.063 | 27051.7 |
369 | 2019-12-25 03:08:19 | spell | 1 | 28756 | 13 | 0.453 | 63479.0 |
368 | 2019-12-24 22:17:33 | spell | 1 | 28756 | 13 | 0.450 | 63902.2 |
367 | 2019-12-24 14:21:13 | spell | 1 | 28756 | 13 | 0.470 | 61183.0 |