History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gastrea"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
454 | 2024-04-27 13:08:48 | gastrea | 1 | 69583 | 3 | 1.453 | 47889.2 |
453 | 2024-04-27 01:15:16 | gastrea | 3 | 134027 | 201 | 17.643 | 7596.6 |
452 | 2024-04-07 18:20:57 | gastrea | 1 | 69583 | 3 | 1.233 | 56433.9 |
451 | 2024-04-06 07:35:35 | gastrea | 3 | 134027 | 201 | 16.376 | 8184.4 |
450 | 2024-04-06 07:13:19 | gastrea | 3 | 134027 | 201 | 17.610 | 7610.8 |
449 | 2024-03-29 11:01:28 | gastrea | 2 | 107671 | 12 | 3.813 | 28237.9 |
448 | 2024-03-29 11:01:16 | gastrea | 3 | 134027 | 201 | 7.406 | 18097.1 |
447 | 2024-03-27 12:44:16 | gastrea | 1 | 69583 | 3 | 2.736 | 25432.4 |
446 | 2024-03-27 12:43:45 | gastrea | 3 | 134027 | 201 | 18.110 | 7400.7 |
445 | 2024-03-27 06:12:17 | gastrea | 2 | 107671 | 12 | 3.546 | 30364.1 |
444 | 2024-03-27 06:09:57 | gastrea | 3 | 134027 | 201 | 5.923 | 22628.2 |
443 | 2024-03-23 13:43:28 | gastrea | 3 | 134027 | 201 | 5.720 | 23431.3 |
442 | 2024-02-07 11:37:06 | gastrea | 3 | 134027 | 201 | 6.046 | 22167.9 |
441 | 2024-02-07 11:37:02 | gastrea | 2 | 107671 | 12 | 3.313 | 32499.5 |
440 | 2024-02-06 02:30:38 | gastrea | 2 | 107671 | 12 | 3.173 | 33933.5 |
439 | 2024-02-06 02:30:02 | gastrea | 3 | 134027 | 201 | 7.126 | 18808.2 |
438 | 2024-02-05 23:18:14 | gastrea | 3 | 134027 | 201 | 8.766 | 15289.4 |
437 | 2024-02-05 21:31:58 | gastrea | 3 | 134027 | 201 | 7.326 | 18294.7 |
436 | 2024-02-05 21:31:53 | gastrea | 2 | 107671 | 12 | 3.093 | 34811.2 |
435 | 2024-01-23 15:56:50 | gastrea | 1 | 69583 | 3 | 4.000 | 17395.8 |
434 | 2024-01-08 20:26:53 | gastrea | 1 | 69583 | 3 | 1.220 | 57035.2 |
433 | 2023-12-28 00:25:29 | gastrea | 2 | 107671 | 12 | 3.233 | 33303.7 |
432 | 2023-12-26 04:43:04 | gastrea | 1 | 69583 | 3 | 1.076 | 64668.2 |
431 | 2023-11-21 23:29:50 | gastrea | 3 | 134027 | 201 | 6.623 | 20236.6 |
430 | 2023-11-19 03:47:24 | gastrea | 1 | 69583 | 3 | 1.203 | 57841.2 |
429 | 2023-11-18 09:15:16 | gastrea | 1 | 69583 | 3 | 1.186 | 58670.3 |
428 | 2023-11-17 05:35:43 | gastrea | 1 | 69583 | 3 | 1.096 | 63488.1 |
427 | 2023-11-09 13:50:49 | gastrea | 1 | 69583 | 3 | 1.236 | 56296.9 |
426 | 2023-10-12 21:18:48 | gastrea | 1 | 69583 | 3 | 1.156 | 60192.9 |
425 | 2023-09-29 22:16:23 | gastrea | 2 | 107671 | 12 | 2.970 | 36252.9 |
424 | 2023-09-09 14:10:46 | gastrea | 1 | 69583 | 3 | 1.046 | 66522.9 |
423 | 2023-08-22 04:44:32 | gastrea | 1 | 69583 | 3 | 1.063 | 65459.1 |
422 | 2023-08-22 04:13:32 | gastrea | 3 | 134027 | 201 | 5.813 | 23056.4 |
421 | 2023-08-07 03:00:10 | gastrea | 1 | 69583 | 3 | 1.076 | 64668.2 |
420 | 2023-07-11 23:50:16 | gastrea | 2 | 107671 | 12 | 2.810 | 38317.1 |
419 | 2023-07-04 15:00:05 | gastrea | 1 | 69583 | 3 | 1.140 | 61037.7 |
418 | 2023-05-16 21:07:02 | gastrea | 1 | 69583 | 3 | 1.106 | 62914.1 |
417 | 2023-05-12 12:40:44 | gastrea | 3 | 134027 | 201 | 7.593 | 17651.4 |
416 | 2023-05-05 11:41:38 | gastrea | 3 | 134027 | 201 | 5.703 | 23501.1 |
415 | 2023-05-05 02:54:52 | gastrea | 1 | 69583 | 3 | 1.173 | 59320.5 |
414 | 2023-03-28 13:22:41 | gastrea | 2 | 107671 | 12 | 3.063 | 35152.1 |
413 | 2023-03-24 07:13:30 | gastrea | 3 | 134027 | 201 | 6.703 | 19995.1 |
412 | 2023-02-26 23:24:44 | gastrea | 1 | 69583 | 3 | 1.153 | 60349.5 |
411 | 2023-02-11 14:48:30 | gastrea | 3 | 134027 | 201 | 6.873 | 19500.5 |
410 | 2023-01-27 11:07:43 | gastrea | 1 | 69583 | 3 | 1.263 | 55093.4 |
409 | 2023-01-21 14:24:59 | gastrea | 1 | 69583 | 3 | 1.596 | 43598.4 |
408 | 2022-12-24 21:35:32 | gastrea | 2 | 107671 | 12 | 2.813 | 38276.2 |
407 | 2022-12-23 18:15:31 | gastrea | 1 | 69583 | 3 | 1.173 | 59320.5 |
406 | 2022-12-09 07:51:21 | gastrea | 1 | 69583 | 3 | 1.170 | 59472.6 |
405 | 2022-12-07 11:23:36 | gastrea | 1 | 69583 | 3 | 1.156 | 60192.9 |
404 | 2022-11-22 07:23:02 | gastrea | 3 | 134027 | 201 | 7.046 | 19021.7 |
403 | 2022-11-22 04:52:49 | gastrea | 1 | 69583 | 3 | 1.203 | 57841.2 |
402 | 2022-11-15 09:00:36 | gastrea | 1 | 69583 | 3 | 1.313 | 52995.4 |
401 | 2022-11-08 04:34:52 | gastrea | 1 | 69583 | 3 | 1.063 | 65459.1 |
400 | 2022-09-25 02:39:32 | gastrea | 1 | 69583 | 3 | 1.123 | 61961.7 |
399 | 2022-09-09 02:08:07 | gastrea | 1 | 69583 | 3 | 1.046 | 66522.9 |
398 | 2022-08-25 03:23:17 | gastrea | 2 | 107671 | 12 | 2.830 | 38046.3 |
397 | 2022-07-11 05:35:55 | gastrea | 1 | 69583 | 3 | 1.080 | 64428.7 |
396 | 2022-06-26 23:23:18 | gastrea | 3 | 134027 | 201 | 5.750 | 23309.0 |
395 | 2022-05-22 11:42:42 | gastrea | 1 | 69583 | 3 | 1.076 | 64668.2 |
394 | 2022-05-19 02:02:39 | gastrea | 1 | 69583 | 3 | 1.076 | 64668.2 |
393 | 2022-04-18 02:34:47 | gastrea | 1 | 69583 | 3 | 1.233 | 56433.9 |
392 | 2022-04-15 22:11:53 | gastrea | 1 | 69583 | 3 | 1.060 | 65644.3 |
391 | 2022-04-06 12:51:56 | gastrea | 2 | 107671 | 12 | 3.626 | 29694.2 |
390 | 2022-01-27 21:06:10 | gastrea | 1 | 69583 | 3 | 1.110 | 62687.4 |
389 | 2022-01-24 14:32:35 | gastrea | 1 | 69583 | 3 | 1.296 | 53690.6 |
388 | 2022-01-22 10:33:53 | gastrea | 1 | 69583 | 3 | 1.060 | 65644.3 |
387 | 2022-01-06 05:44:34 | gastrea | 1 | 69583 | 3 | 1.140 | 61037.7 |
386 | 2021-11-27 19:57:15 | gastrea | 1 | 69583 | 3 | 1.076 | 64668.2 |
385 | 2021-10-14 11:08:00 | gastrea | 1 | 69583 | 3 | 1.063 | 65459.1 |
384 | 2021-10-11 04:38:02 | gastrea | 1 | 69583 | 3 | 1.173 | 59320.5 |
383 | 2021-07-09 14:51:54 | gastrea | 1 | 69583 | 3 | 1.093 | 63662.4 |
382 | 2021-04-15 02:29:06 | gastrea | 1 | 69583 | 3 | 1.313 | 52995.4 |
381 | 2021-04-05 18:17:43 | gastrea | 1 | 69583 | 3 | 1.156 | 60192.9 |
380 | 2021-04-01 14:08:12 | gastrea | 1 | 69583 | 3 | 1.186 | 58670.3 |
379 | 2021-01-28 05:46:24 | gastrea | 1 | 69583 | 3 | 1.063 | 65459.1 |
378 | 2020-12-30 12:59:34 | gastrea | 1 | 69583 | 3 | 1.063 | 65459.1 |
377 | 2020-12-24 07:56:44 | gastrea | 1 | 69583 | 3 | 1.093 | 63662.4 |
376 | 2020-12-20 17:05:59 | gastrea | 1 | 69583 | 3 | 1.076 | 64668.2 |
375 | 2020-10-20 18:00:00 | gastrea | 1 | 69583 | 3 | 1.233 | 56433.9 |
374 | 2020-10-13 13:06:40 | gastrea | 1 | 69583 | 3 | 1.173 | 59320.5 |
373 | 2020-10-10 14:49:20 | gastrea | 1 | 69583 | 3 | 1.126 | 61796.6 |
372 | 2020-09-16 17:58:52 | gastrea | 1 | 69583 | 3 | 1.063 | 65459.1 |
371 | 2020-07-26 06:40:03 | gastrea | 1 | 69583 | 3 | 1.093 | 63662.4 |
370 | 2020-06-07 02:51:01 | gastrea | 1 | 69583 | 3 | 1.203 | 57841.2 |
369 | 2020-03-28 23:41:16 | gastrea | 1 | 69583 | 3 | 1.280 | 54361.7 |
368 | 2020-03-21 18:30:42 | gastrea | 1 | 69583 | 3 | 1.266 | 54962.9 |
367 | 2020-03-06 22:55:27 | gastrea | 1 | 69583 | 3 | 1.080 | 64428.7 |
366 | 2020-03-05 14:13:32 | gastrea | 1 | 69583 | 3 | 1.063 | 65459.1 |
365 | 2020-02-28 07:53:51 | gastrea | 3 | 134027 | 201 | 8.953 | 14970.1 |
364 | 2020-02-28 03:58:42 | gastrea | 3 | 134027 | 201 | 15.830 | 8466.6 |
363 | 2020-02-23 00:57:35 | gastrea | 1 | 69583 | 3 | 2.360 | 29484.3 |
362 | 2020-02-18 21:47:36 | gastrea | 1 | 69583 | 3 | 1.296 | 53690.6 |
361 | 2020-02-12 18:41:29 | gastrea | 1 | 69583 | 3 | 4.266 | 16311.1 |
360 | 2020-02-12 14:19:23 | gastrea | 1 | 69583 | 3 | 1.216 | 57222.9 |
359 | 2020-02-11 22:35:25 | gastrea | 1 | 69583 | 3 | 1.373 | 50679.5 |
358 | 2020-02-11 14:56:18 | gastrea | 3 | 134027 | 201 | 12.516 | 10708.5 |
357 | 2020-02-11 05:50:41 | gastrea | 3 | 134027 | 201 | 6.593 | 20328.7 |
356 | 2020-02-10 21:04:12 | gastrea | 3 | 134027 | 201 | 7.656 | 17506.1 |
355 | 2020-02-03 10:21:08 | gastrea | 1 | 69583 | 3 | 3.153 | 22068.8 |