History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crews"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
451 | 2024-04-02 22:19:11 | crews | 2 | 53800 | 178 | 1.906 | 28226.7 |
450 | 2024-04-02 21:41:23 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
449 | 2024-03-31 05:56:17 | crews | 2 | 53800 | 178 | 3.783 | 14221.5 |
448 | 2024-03-31 03:43:27 | crews | 1 | 28756 | 11 | 0.970 | 29645.4 |
447 | 2024-03-27 02:10:26 | crews | 1 | 28756 | 11 | 1.140 | 25224.6 |
446 | 2024-03-05 20:48:18 | crews | 1 | 28756 | 11 | 0.576 | 49923.6 |
445 | 2024-02-25 17:49:03 | crews | 1 | 28756 | 11 | 0.656 | 43835.4 |
444 | 2024-02-06 07:01:21 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
443 | 2024-02-02 11:14:36 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
442 | 2024-01-26 00:47:49 | crews | 1 | 28756 | 11 | 1.016 | 28303.1 |
441 | 2024-01-11 16:41:15 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
440 | 2023-11-25 03:54:41 | crews | 1 | 28756 | 11 | 0.453 | 63479.0 |
439 | 2023-11-24 08:27:49 | crews | 2 | 53800 | 178 | 1.390 | 38705.0 |
438 | 2023-11-24 04:39:46 | crews | 2 | 53800 | 178 | 1.576 | 34137.1 |
437 | 2023-11-22 03:53:33 | crews | 2 | 53800 | 178 | 1.626 | 33087.3 |
436 | 2023-11-09 16:01:31 | crews | 1 | 28756 | 11 | 0.486 | 59168.7 |
435 | 2023-11-09 02:26:50 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
434 | 2023-11-05 07:58:11 | crews | 1 | 28756 | 11 | 0.546 | 52666.7 |
433 | 2023-11-01 14:32:22 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
432 | 2023-10-27 08:03:59 | crews | 1 | 28756 | 11 | 0.470 | 61183.0 |
431 | 2023-10-23 19:28:46 | crews | 1 | 28756 | 11 | 0.546 | 52666.7 |
430 | 2023-10-19 09:23:26 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
429 | 2023-10-18 07:23:09 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
428 | 2023-10-12 01:52:54 | crews | 1 | 28756 | 11 | 0.486 | 59168.7 |
427 | 2023-10-05 04:17:55 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
426 | 2023-09-24 11:58:55 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
425 | 2023-09-21 00:47:30 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
424 | 2023-09-15 22:24:44 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
423 | 2023-08-27 00:06:27 | crews | 1 | 28756 | 11 | 0.846 | 33990.5 |
422 | 2023-07-12 16:17:08 | crews | 1 | 28756 | 11 | 0.440 | 65354.5 |
421 | 2023-05-28 03:47:27 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
420 | 2023-04-08 21:17:51 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
419 | 2023-03-24 02:50:18 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
418 | 2023-02-12 03:50:58 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
417 | 2023-01-17 08:42:03 | crews | 1 | 28756 | 11 | 1.016 | 28303.1 |
416 | 2023-01-08 13:19:56 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
415 | 2023-01-07 09:48:18 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
414 | 2023-01-03 15:55:40 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
413 | 2022-12-24 08:30:09 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
412 | 2022-12-02 14:16:22 | crews | 1 | 28756 | 11 | 0.486 | 59168.7 |
411 | 2022-11-29 13:12:56 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
410 | 2022-11-28 02:56:16 | crews | 1 | 28756 | 11 | 0.486 | 59168.7 |
409 | 2022-11-09 01:50:46 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
408 | 2022-10-06 18:46:52 | crews | 1 | 28756 | 11 | 0.593 | 48492.4 |
407 | 2022-09-20 01:12:23 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
406 | 2022-05-31 01:36:17 | crews | 1 | 28756 | 11 | 0.453 | 63479.0 |
405 | 2022-05-23 19:18:44 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
404 | 2022-05-21 14:06:10 | crews | 1 | 28756 | 11 | 0.456 | 63061.4 |
403 | 2022-02-16 11:59:44 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
402 | 2022-02-07 08:13:33 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
401 | 2021-11-29 01:01:02 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
400 | 2021-11-15 03:48:36 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
399 | 2021-11-13 05:48:54 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
398 | 2021-10-06 11:41:44 | crews | 1 | 28756 | 11 | 0.486 | 59168.7 |
397 | 2021-10-04 08:39:27 | crews | 1 | 28756 | 11 | 0.453 | 63479.0 |
396 | 2021-08-30 18:40:11 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
395 | 2021-08-15 15:22:53 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
394 | 2021-08-15 12:32:19 | crews | 1 | 28756 | 11 | 0.440 | 65354.5 |
393 | 2021-08-07 15:23:17 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
392 | 2021-07-19 14:20:24 | crews | 1 | 28756 | 11 | 0.453 | 63479.0 |
391 | 2021-06-22 20:22:11 | crews | 1 | 28756 | 11 | 0.470 | 61183.0 |
390 | 2021-05-14 23:42:13 | crews | 1 | 28756 | 11 | 0.513 | 56054.6 |
389 | 2021-05-08 21:16:01 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
388 | 2021-04-07 08:29:07 | crews | 1 | 28756 | 11 | 0.593 | 48492.4 |
387 | 2021-02-12 04:08:13 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
386 | 2021-02-11 23:41:26 | crews | 1 | 28756 | 11 | 0.470 | 61183.0 |
385 | 2021-02-07 02:47:15 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
384 | 2020-11-05 04:25:17 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
383 | 2020-10-30 16:21:19 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
382 | 2020-10-23 16:22:10 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
381 | 2020-10-11 11:16:33 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
380 | 2020-09-16 05:52:35 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
379 | 2020-08-19 04:16:23 | crews | 1 | 28756 | 11 | 0.453 | 63479.0 |
378 | 2020-08-01 08:45:35 | crews | 1 | 28756 | 11 | 0.453 | 63479.0 |
377 | 2020-07-11 19:23:42 | crews | 1 | 28756 | 11 | 0.453 | 63479.0 |
376 | 2020-04-29 21:31:24 | crews | 1 | 28756 | 11 | 0.436 | 65954.1 |
375 | 2020-03-29 21:10:30 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
374 | 2020-03-25 16:44:55 | crews | 1 | 28756 | 11 | 0.513 | 56054.6 |
373 | 2020-03-23 10:38:28 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
372 | 2020-03-22 09:41:49 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
371 | 2020-03-22 03:07:29 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
370 | 2020-03-21 07:22:44 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
369 | 2020-03-18 08:58:38 | crews | 1 | 28756 | 11 | 0.483 | 59536.2 |
368 | 2020-02-29 19:56:26 | crews | 1 | 28756 | 11 | 1.063 | 27051.7 |
367 | 2020-02-29 18:16:22 | crews | 1 | 28756 | 11 | 0.546 | 52666.7 |
366 | 2020-02-26 18:11:41 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
365 | 2020-02-21 07:23:06 | crews | 1 | 28756 | 11 | 1.170 | 24577.8 |
364 | 2020-02-14 00:25:43 | crews | 1 | 28756 | 11 | 0.580 | 49579.3 |
363 | 2020-02-13 04:48:09 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
362 | 2020-02-10 03:09:00 | crews | 1 | 28756 | 11 | 1.766 | 16283.1 |
361 | 2020-01-31 16:54:26 | crews | 1 | 28756 | 11 | 0.826 | 34813.6 |
360 | 2020-01-31 05:11:30 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
359 | 2020-01-30 14:43:28 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
358 | 2020-01-30 06:04:52 | crews | 1 | 28756 | 11 | 0.546 | 52666.7 |
357 | 2020-01-28 23:36:24 | crews | 1 | 28756 | 11 | 0.500 | 57512.0 |
356 | 2020-01-27 20:31:52 | crews | 1 | 28756 | 11 | 0.516 | 55728.7 |
355 | 2020-01-24 10:29:33 | crews | 1 | 28756 | 11 | 1.110 | 25906.3 |
354 | 2020-01-21 17:15:00 | crews | 1 | 28756 | 11 | 0.486 | 59168.7 |
353 | 2020-01-12 09:28:50 | crews | 1 | 28756 | 11 | 0.530 | 54256.6 |
352 | 2020-01-12 07:08:24 | crews | 1 | 28756 | 11 | 1.110 | 25906.3 |