History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"teacher"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
469 | 2024-04-27 10:35:49 | teacher | 1 | 69583 | 6 | 2.686 | 25905.8 |
468 | 2024-03-31 06:01:48 | teacher | 1 | 69583 | 6 | 1.623 | 42873.1 |
467 | 2024-03-20 02:14:19 | teacher | 1 | 69583 | 6 | 2.656 | 26198.4 |
466 | 2024-02-23 06:11:26 | teacher | 1 | 69583 | 6 | 1.280 | 54361.7 |
465 | 2024-01-27 17:22:35 | teacher | 3 | 134027 | 590 | 13.686 | 9793.0 |
464 | 2024-01-07 17:20:29 | teacher | 3 | 134027 | 590 | 5.843 | 22938.0 |
463 | 2023-12-29 03:13:45 | teacher | 3 | 134027 | 590 | 6.186 | 21666.2 |
462 | 2023-12-29 03:13:43 | teacher | 2 | 107671 | 65 | 3.313 | 32499.5 |
461 | 2023-12-26 22:42:13 | teacher | 1 | 69583 | 6 | 1.093 | 63662.4 |
460 | 2023-12-16 05:09:50 | teacher | 1 | 69583 | 6 | 1.096 | 63488.1 |
459 | 2023-12-06 14:51:25 | teacher | 1 | 69583 | 6 | 1.216 | 57222.9 |
458 | 2023-12-05 02:06:23 | teacher | 1 | 69583 | 6 | 1.190 | 58473.1 |
457 | 2023-11-13 19:35:02 | teacher | 1 | 69583 | 6 | 1.123 | 61961.7 |
456 | 2023-11-05 08:21:32 | teacher | 1 | 69583 | 6 | 1.123 | 61961.7 |
455 | 2023-10-22 14:26:12 | teacher | 1 | 69583 | 6 | 1.186 | 58670.3 |
454 | 2023-09-24 00:11:53 | teacher | 1 | 69583 | 6 | 1.326 | 52475.9 |
453 | 2023-09-21 01:51:28 | teacher | 1 | 69583 | 6 | 1.060 | 65644.3 |
452 | 2023-08-13 07:35:18 | teacher | 1 | 69583 | 6 | 1.093 | 63662.4 |
451 | 2023-07-16 16:47:15 | teacher | 1 | 69583 | 6 | 1.296 | 53690.6 |
450 | 2023-04-21 04:09:54 | teacher | 1 | 69583 | 6 | 1.063 | 65459.1 |
449 | 2023-04-19 10:44:50 | teacher | 1 | 69583 | 6 | 1.063 | 65459.1 |
448 | 2023-02-05 05:00:37 | teacher | 1 | 69583 | 6 | 1.063 | 65459.1 |
447 | 2023-01-01 06:46:14 | teacher | 1 | 69583 | 6 | 1.046 | 66522.9 |
446 | 2022-12-29 13:39:15 | teacher | 1 | 69583 | 6 | 1.173 | 59320.5 |
445 | 2022-12-08 02:44:43 | teacher | 2 | 107671 | 65 | 2.800 | 38453.9 |
444 | 2022-12-08 01:17:37 | teacher | 2 | 107671 | 65 | 3.173 | 33933.5 |
443 | 2022-12-04 06:56:17 | teacher | 1 | 69583 | 6 | 1.190 | 58473.1 |
442 | 2022-11-28 21:19:41 | teacher | 1 | 69583 | 6 | 1.173 | 59320.5 |
441 | 2022-11-28 04:21:23 | teacher | 1 | 69583 | 6 | 1.063 | 65459.1 |
440 | 2022-11-27 03:31:24 | teacher | 1 | 69583 | 6 | 1.096 | 63488.1 |
439 | 2022-10-30 15:22:07 | teacher | 2 | 107671 | 65 | 2.830 | 38046.3 |
438 | 2022-09-08 04:54:13 | teacher | 2 | 107671 | 65 | 2.936 | 36672.7 |
437 | 2022-09-01 11:22:50 | teacher | 2 | 107671 | 65 | 2.923 | 36835.8 |
436 | 2022-08-24 16:27:43 | teacher | 1 | 69583 | 6 | 1.186 | 58670.3 |
435 | 2022-07-30 02:57:37 | teacher | 1 | 69583 | 6 | 1.096 | 63488.1 |
434 | 2022-04-20 11:44:05 | teacher | 1 | 69583 | 6 | 1.096 | 63488.1 |
433 | 2022-04-17 02:28:20 | teacher | 1 | 69583 | 6 | 1.093 | 63662.4 |
432 | 2022-03-28 22:07:55 | teacher | 1 | 69583 | 6 | 1.360 | 51164.0 |
431 | 2022-01-01 16:06:47 | teacher | 1 | 69583 | 6 | 1.186 | 58670.3 |
430 | 2021-12-22 17:22:06 | teacher | 1 | 69583 | 6 | 2.580 | 26970.2 |
429 | 2021-12-15 07:01:39 | teacher | 1 | 69583 | 6 | 1.090 | 63837.6 |
428 | 2021-11-08 07:24:49 | teacher | 1 | 69583 | 6 | 1.203 | 57841.2 |
427 | 2021-10-28 19:05:48 | teacher | 1 | 69583 | 6 | 1.093 | 63662.4 |
426 | 2021-09-25 20:32:59 | teacher | 1 | 69583 | 6 | 1.216 | 57222.9 |
425 | 2021-09-20 18:44:45 | teacher | 1 | 69583 | 6 | 1.076 | 64668.2 |
424 | 2021-09-19 21:37:12 | teacher | 1 | 69583 | 6 | 1.250 | 55666.4 |
423 | 2021-09-13 06:36:07 | teacher | 1 | 69583 | 6 | 1.080 | 64428.7 |
422 | 2021-09-08 16:54:17 | teacher | 1 | 69583 | 6 | 1.266 | 54962.9 |
421 | 2021-09-05 19:07:00 | teacher | 1 | 69583 | 6 | 1.203 | 57841.2 |
420 | 2021-06-09 21:55:23 | teacher | 1 | 69583 | 6 | 1.140 | 61037.7 |
419 | 2021-06-01 17:24:33 | teacher | 1 | 69583 | 6 | 1.250 | 55666.4 |
418 | 2021-05-18 12:57:59 | teacher | 1 | 69583 | 6 | 2.250 | 30925.8 |
417 | 2021-04-03 06:10:48 | teacher | 1 | 69583 | 6 | 2.436 | 28564.4 |
416 | 2021-03-18 23:15:34 | teacher | 1 | 69583 | 6 | 1.266 | 54962.9 |
415 | 2021-03-02 13:43:43 | teacher | 1 | 69583 | 6 | 1.266 | 54962.9 |
414 | 2021-02-12 06:32:31 | teacher | 1 | 69583 | 6 | 1.096 | 63488.1 |
413 | 2020-12-31 07:22:13 | teacher | 1 | 69583 | 6 | 1.080 | 64428.7 |
412 | 2020-11-26 19:15:14 | teacher | 1 | 69583 | 6 | 1.076 | 64668.2 |
411 | 2020-10-29 10:52:19 | teacher | 1 | 69583 | 6 | 1.220 | 57035.2 |
410 | 2020-10-29 03:53:24 | teacher | 1 | 69583 | 6 | 1.280 | 54361.7 |
409 | 2020-10-21 18:29:39 | teacher | 1 | 69583 | 6 | 1.076 | 64668.2 |
408 | 2020-10-13 19:37:44 | teacher | 1 | 69583 | 6 | 2.140 | 32515.4 |
407 | 2020-10-03 22:58:12 | teacher | 1 | 69583 | 6 | 1.060 | 65644.3 |
406 | 2020-08-17 20:15:12 | teacher | 1 | 69583 | 6 | 1.110 | 62687.4 |
405 | 2020-07-21 17:15:00 | teacher | 1 | 69583 | 6 | 1.186 | 58670.3 |
404 | 2020-05-10 13:06:24 | teacher | 1 | 69583 | 6 | 1.063 | 65459.1 |
403 | 2020-04-18 17:23:28 | teacher | 1 | 69583 | 6 | 1.123 | 61961.7 |
402 | 2020-03-28 08:34:51 | teacher | 1 | 69583 | 6 | 1.373 | 50679.5 |
401 | 2020-03-27 17:36:27 | teacher | 1 | 69583 | 6 | 1.190 | 58473.1 |
400 | 2020-03-24 14:09:31 | teacher | 1 | 69583 | 6 | 1.343 | 51811.6 |
399 | 2020-03-22 13:34:23 | teacher | 1 | 69583 | 6 | 1.343 | 51811.6 |
398 | 2020-03-20 22:56:06 | teacher | 1 | 69583 | 6 | 1.110 | 62687.4 |
397 | 2020-02-28 00:36:32 | teacher | 1 | 69583 | 6 | 2.766 | 25156.5 |
396 | 2020-02-25 21:01:00 | teacher | 3 | 134027 | 590 | 7.826 | 17125.9 |
395 | 2020-02-23 03:33:23 | teacher | 1 | 69583 | 6 | 1.236 | 56296.9 |
394 | 2020-02-14 22:30:47 | teacher | 1 | 69583 | 6 | 1.390 | 50059.7 |
393 | 2020-02-12 06:05:25 | teacher | 3 | 134027 | 590 | 10.000 | 13402.7 |
392 | 2020-02-11 12:36:40 | teacher | 3 | 134027 | 590 | 6.720 | 19944.5 |
391 | 2020-02-09 14:49:58 | teacher | 3 | 134027 | 590 | 10.673 | 12557.6 |
390 | 2020-02-07 20:26:04 | teacher | 1 | 69583 | 6 | 1.343 | 51811.6 |
389 | 2020-02-06 00:35:06 | teacher | 1 | 69583 | 6 | 1.266 | 54962.9 |
388 | 2020-02-05 11:49:42 | teacher | 1 | 69583 | 6 | 3.483 | 19977.9 |
387 | 2020-02-05 00:23:12 | teacher | 1 | 69583 | 6 | 1.296 | 53690.6 |
386 | 2020-02-04 14:21:05 | teacher | 1 | 69583 | 6 | 2.766 | 25156.5 |
385 | 2020-01-31 17:47:19 | teacher | 3 | 134027 | 590 | 12.423 | 10788.6 |
384 | 2020-01-31 15:16:54 | teacher | 1 | 69583 | 6 | 3.736 | 18625.0 |
383 | 2020-01-31 13:20:13 | teacher | 3 | 134027 | 590 | 8.266 | 16214.3 |
382 | 2020-01-28 02:17:03 | teacher | 1 | 69583 | 6 | 2.546 | 27330.3 |
381 | 2020-01-24 00:37:19 | teacher | 1 | 69583 | 6 | 2.016 | 34515.4 |
380 | 2020-01-20 15:18:13 | teacher | 3 | 134027 | 590 | 21.656 | 6188.9 |
379 | 2020-01-19 15:42:26 | teacher | 3 | 134027 | 590 | 16.813 | 7971.6 |
378 | 2020-01-19 14:55:48 | teacher | 3 | 134027 | 590 | 9.406 | 14249.1 |
377 | 2020-01-16 17:19:55 | teacher | 3 | 134027 | 590 | 18.063 | 7420.0 |
376 | 2020-01-16 08:46:32 | teacher | 3 | 134027 | 590 | 7.250 | 18486.5 |
375 | 2020-01-15 20:10:40 | teacher | 1 | 69583 | 6 | 2.593 | 26834.9 |
374 | 2020-01-15 03:58:56 | teacher | 1 | 69583 | 6 | 2.673 | 26031.8 |
373 | 2020-01-12 11:19:57 | teacher | 2 | 107671 | 65 | 3.406 | 31612.2 |
372 | 2020-01-12 06:12:58 | teacher | 1 | 69583 | 6 | 2.030 | 34277.3 |
371 | 2020-01-08 04:57:57 | teacher | 1 | 69583 | 6 | 3.156 | 22047.8 |
370 | 2019-12-30 01:12:18 | teacher | 3 | 134027 | 590 | 6.170 | 21722.4 |