History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"texts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
456 | 2024-05-06 21:48:10 | texts | 1 | 28756 | 8 | 0.516 | 55728.7 |
455 | 2024-05-04 02:05:35 | texts | 1 | 28756 | 8 | 0.530 | 54256.6 |
454 | 2024-04-29 22:30:26 | texts | 1 | 28756 | 8 | 0.640 | 44931.3 |
453 | 2024-04-29 16:39:17 | texts | 1 | 28756 | 8 | 0.516 | 55728.7 |
452 | 2024-04-24 15:45:15 | texts | 1 | 28756 | 8 | 1.593 | 18051.5 |
451 | 2024-04-14 23:50:36 | texts | 2 | 53800 | 161 | 5.736 | 9379.4 |
450 | 2024-04-14 23:45:32 | texts | 1 | 28756 | 8 | 0.593 | 48492.4 |
449 | 2024-04-14 23:44:53 | texts | 1 | 28756 | 8 | 1.283 | 22413.1 |
448 | 2024-04-03 02:47:20 | texts | 1 | 28756 | 8 | 0.626 | 45936.1 |
447 | 2024-03-30 20:54:42 | texts | 2 | 53800 | 161 | 6.203 | 8673.2 |
446 | 2024-03-30 20:47:32 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
445 | 2024-03-29 06:41:28 | texts | 2 | 53800 | 161 | 2.513 | 21408.7 |
444 | 2024-03-29 06:41:23 | texts | 1 | 28756 | 8 | 0.546 | 52666.7 |
443 | 2024-03-29 06:41:10 | texts | 2 | 53800 | 161 | 1.703 | 31591.3 |
442 | 2024-03-29 06:40:43 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
441 | 2024-03-23 21:56:35 | texts | 1 | 28756 | 8 | 0.423 | 67981.1 |
440 | 2024-03-15 09:48:56 | texts | 1 | 28756 | 8 | 0.796 | 36125.6 |
439 | 2024-02-28 05:32:01 | texts | 2 | 53800 | 161 | 1.766 | 30464.3 |
438 | 2024-02-28 02:57:03 | texts | 2 | 53800 | 161 | 3.530 | 15240.8 |
437 | 2024-02-28 02:56:57 | texts | 1 | 28756 | 8 | 0.530 | 54256.6 |
436 | 2024-01-28 23:19:09 | texts | 1 | 28756 | 8 | 0.470 | 61183.0 |
435 | 2024-01-28 23:03:35 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
434 | 2024-01-15 00:58:46 | texts | 2 | 53800 | 161 | 1.406 | 38264.6 |
433 | 2023-12-30 04:14:37 | texts | 2 | 53800 | 161 | 1.596 | 33709.3 |
432 | 2023-12-19 18:27:32 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
431 | 2023-12-08 11:56:41 | texts | 1 | 28756 | 8 | 0.530 | 54256.6 |
430 | 2023-12-04 05:38:00 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
429 | 2023-12-04 05:37:59 | texts | 1 | 28756 | 8 | 0.470 | 61183.0 |
428 | 2023-12-02 00:22:37 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
427 | 2023-11-28 02:19:49 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
426 | 2023-11-18 14:38:00 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
425 | 2023-11-16 09:02:47 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
424 | 2023-10-30 15:16:12 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
423 | 2023-10-23 18:52:06 | texts | 1 | 28756 | 8 | 0.483 | 59536.2 |
422 | 2023-10-22 18:00:19 | texts | 1 | 28756 | 8 | 0.470 | 61183.0 |
421 | 2023-10-11 16:00:11 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
420 | 2023-10-07 03:08:54 | texts | 1 | 28756 | 8 | 0.486 | 59168.7 |
419 | 2023-10-05 15:21:31 | texts | 1 | 28756 | 8 | 0.466 | 61708.2 |
418 | 2023-09-26 04:18:32 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
417 | 2023-09-23 13:31:34 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
416 | 2023-08-03 05:49:54 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
415 | 2023-07-25 09:00:23 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
414 | 2023-07-02 20:41:51 | texts | 1 | 28756 | 8 | 0.483 | 59536.2 |
413 | 2023-05-06 08:51:38 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
412 | 2023-03-22 14:10:42 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
411 | 2023-03-01 20:09:54 | texts | 1 | 28756 | 8 | 0.420 | 68466.7 |
410 | 2022-12-26 01:30:49 | texts | 1 | 28756 | 8 | 0.486 | 59168.7 |
409 | 2022-11-10 09:10:20 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
408 | 2022-09-15 20:13:32 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
407 | 2022-09-15 03:55:22 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
406 | 2022-07-03 21:54:25 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
405 | 2022-07-01 03:01:32 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
404 | 2022-03-08 04:12:34 | texts | 1 | 28756 | 8 | 0.640 | 44931.3 |
403 | 2022-02-27 17:27:53 | texts | 1 | 28756 | 8 | 0.470 | 61183.0 |
402 | 2021-12-18 15:26:36 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
401 | 2021-10-30 07:06:24 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
400 | 2021-10-27 17:59:43 | texts | 1 | 28756 | 8 | 0.530 | 54256.6 |
399 | 2021-09-15 23:18:03 | texts | 1 | 28756 | 8 | 0.486 | 59168.7 |
398 | 2021-08-29 10:17:10 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
397 | 2021-08-27 04:52:05 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
396 | 2021-07-16 13:50:57 | texts | 1 | 28756 | 8 | 0.470 | 61183.0 |
395 | 2021-06-07 16:06:53 | texts | 1 | 28756 | 8 | 0.953 | 30174.2 |
394 | 2021-04-13 19:32:12 | texts | 1 | 28756 | 8 | 0.516 | 55728.7 |
393 | 2021-03-16 11:36:29 | texts | 1 | 28756 | 8 | 0.530 | 54256.6 |
392 | 2020-12-28 15:19:36 | texts | 1 | 28756 | 8 | 0.546 | 52666.7 |
391 | 2020-12-27 12:27:18 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
390 | 2020-11-02 13:23:32 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
389 | 2020-10-15 19:35:39 | texts | 1 | 28756 | 8 | 0.486 | 59168.7 |
388 | 2020-10-14 13:32:40 | texts | 1 | 28756 | 8 | 0.720 | 39938.9 |
387 | 2020-09-23 21:14:40 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
386 | 2020-09-18 05:03:24 | texts | 1 | 28756 | 8 | 0.450 | 63902.2 |
385 | 2020-09-10 01:25:28 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
384 | 2020-08-27 03:28:02 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
383 | 2020-07-16 01:25:26 | texts | 1 | 28756 | 8 | 0.483 | 59536.2 |
382 | 2020-07-14 06:56:43 | texts | 1 | 28756 | 8 | 0.953 | 30174.2 |
381 | 2020-07-10 15:47:28 | texts | 1 | 28756 | 8 | 0.470 | 61183.0 |
380 | 2020-06-03 21:22:02 | texts | 1 | 28756 | 8 | 0.486 | 59168.7 |
379 | 2020-04-08 14:31:57 | texts | 1 | 28756 | 8 | 0.453 | 63479.0 |
378 | 2020-03-25 07:32:11 | texts | 1 | 28756 | 8 | 0.516 | 55728.7 |
377 | 2020-03-23 09:16:12 | texts | 1 | 28756 | 8 | 0.686 | 41918.4 |
376 | 2020-03-21 06:28:22 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
375 | 2020-03-21 06:20:07 | texts | 1 | 28756 | 8 | 0.516 | 55728.7 |
374 | 2020-03-20 20:08:11 | texts | 1 | 28756 | 8 | 0.483 | 59536.2 |
373 | 2020-03-18 00:51:15 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
372 | 2020-02-25 22:57:27 | texts | 1 | 28756 | 8 | 0.546 | 52666.7 |
371 | 2020-02-25 20:31:34 | texts | 1 | 28756 | 8 | 0.530 | 54256.6 |
370 | 2020-02-21 14:37:26 | texts | 1 | 28756 | 8 | 0.516 | 55728.7 |
369 | 2020-02-16 13:25:04 | texts | 1 | 28756 | 8 | 0.500 | 57512.0 |
368 | 2020-02-14 21:42:25 | texts | 1 | 28756 | 8 | 0.516 | 55728.7 |
367 | 2020-02-12 06:56:35 | texts | 1 | 28756 | 8 | 0.546 | 52666.7 |
366 | 2020-02-01 08:26:43 | texts | 1 | 28756 | 8 | 0.546 | 52666.7 |
365 | 2020-01-31 21:16:31 | texts | 1 | 28756 | 8 | 0.423 | 67981.1 |
364 | 2020-01-31 06:40:06 | texts | 1 | 28756 | 8 | 0.533 | 53951.2 |
363 | 2020-01-30 23:05:29 | texts | 1 | 28756 | 8 | 0.843 | 34111.5 |
362 | 2020-01-30 02:51:46 | texts | 1 | 28756 | 8 | 0.550 | 52283.6 |
361 | 2020-01-24 10:43:17 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
360 | 2020-01-21 21:03:49 | texts | 1 | 28756 | 8 | 1.156 | 24875.4 |
359 | 2020-01-12 09:47:14 | texts | 1 | 28756 | 8 | 1.080 | 26625.9 |
358 | 2020-01-11 16:11:01 | texts | 1 | 28756 | 8 | 0.436 | 65954.1 |
357 | 2020-01-10 13:56:26 | texts | 1 | 28756 | 8 | 0.483 | 59536.2 |