History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tecta"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
422 | 2024-04-26 22:31:17 | tecta | 3 | 83667 | 870 | 4.890 | 17109.8 |
421 | 2024-04-06 05:49:33 | tecta | 1 | 28756 | 4 | 1.063 | 27051.7 |
420 | 2024-03-31 16:11:49 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
419 | 2024-03-29 06:40:27 | tecta | 3 | 83667 | 870 | 7.686 | 10885.6 |
418 | 2024-03-29 06:40:33 | tecta | 2 | 53800 | 69 | 1.876 | 28678.0 |
417 | 2024-03-29 06:40:22 | tecta | 1 | 28756 | 4 | 0.533 | 53951.2 |
416 | 2024-03-08 22:00:46 | tecta | 1 | 28756 | 4 | 0.560 | 51350.0 |
415 | 2024-03-08 22:00:44 | tecta | 2 | 53800 | 69 | 1.796 | 29955.5 |
414 | 2024-03-08 22:00:10 | tecta | 3 | 83667 | 870 | 8.346 | 10024.8 |
413 | 2024-03-07 08:29:44 | tecta | 3 | 83667 | 870 | 8.440 | 9913.2 |
412 | 2024-03-07 08:29:44 | tecta | 2 | 53800 | 69 | 3.860 | 13937.8 |
411 | 2024-03-07 04:45:03 | tecta | 1 | 28756 | 4 | 1.110 | 25906.3 |
410 | 2024-03-01 11:41:44 | tecta | 1 | 28756 | 4 | 0.453 | 63479.0 |
409 | 2024-02-29 05:31:50 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
408 | 2024-02-28 02:27:53 | tecta | 1 | 28756 | 4 | 0.530 | 54256.6 |
407 | 2024-02-03 20:23:51 | tecta | 1 | 28756 | 4 | 0.533 | 53951.2 |
406 | 2024-01-29 01:05:33 | tecta | 1 | 28756 | 4 | 0.486 | 59168.7 |
405 | 2024-01-28 21:23:55 | tecta | 1 | 28756 | 4 | 0.470 | 61183.0 |
404 | 2024-01-20 08:53:56 | tecta | 1 | 28756 | 4 | 0.453 | 63479.0 |
403 | 2024-01-16 07:22:28 | tecta | 2 | 53800 | 69 | 1.580 | 34050.6 |
402 | 2023-12-29 16:45:23 | tecta | 3 | 83667 | 870 | 3.563 | 23482.2 |
401 | 2023-12-29 16:45:22 | tecta | 2 | 53800 | 69 | 1.623 | 33148.5 |
400 | 2023-12-24 13:01:15 | tecta | 3 | 83667 | 870 | 3.546 | 23594.8 |
399 | 2023-12-24 13:01:16 | tecta | 2 | 53800 | 69 | 1.593 | 33772.8 |
398 | 2023-12-12 19:05:31 | tecta | 2 | 53800 | 69 | 1.530 | 35163.4 |
397 | 2023-11-20 06:12:17 | tecta | 1 | 28756 | 4 | 0.530 | 54256.6 |
396 | 2023-11-15 20:39:53 | tecta | 1 | 28756 | 4 | 0.466 | 61708.2 |
395 | 2023-11-13 23:14:38 | tecta | 1 | 28756 | 4 | 0.516 | 55728.7 |
394 | 2023-11-12 03:12:41 | tecta | 1 | 28756 | 4 | 0.440 | 65354.5 |
393 | 2023-10-31 00:27:36 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
392 | 2023-10-28 14:56:25 | tecta | 2 | 53800 | 69 | 1.390 | 38705.0 |
391 | 2023-10-22 14:04:31 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
390 | 2023-10-13 17:17:17 | tecta | 1 | 28756 | 4 | 0.440 | 65354.5 |
389 | 2023-10-05 03:37:41 | tecta | 1 | 28756 | 4 | 0.563 | 51076.4 |
388 | 2023-10-04 00:43:41 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
387 | 2023-09-30 20:19:57 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
386 | 2023-09-26 08:20:18 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
385 | 2023-09-24 16:35:29 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
384 | 2023-09-03 06:05:20 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
383 | 2023-08-06 17:34:36 | tecta | 2 | 53800 | 69 | 1.373 | 39184.3 |
382 | 2023-06-07 03:35:45 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
381 | 2023-05-28 10:56:24 | tecta | 1 | 28756 | 4 | 0.890 | 32310.1 |
380 | 2023-04-17 15:54:06 | tecta | 2 | 53800 | 69 | 1.533 | 35094.6 |
379 | 2023-03-28 20:00:37 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
378 | 2023-01-24 04:39:54 | tecta | 2 | 53800 | 69 | 1.500 | 35866.7 |
377 | 2023-01-18 03:08:59 | tecta | 1 | 28756 | 4 | 0.470 | 61183.0 |
376 | 2023-01-11 14:53:14 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
375 | 2022-11-03 09:23:12 | tecta | 2 | 53800 | 69 | 1.406 | 38264.6 |
374 | 2022-10-14 21:48:00 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
373 | 2022-09-12 09:51:49 | tecta | 1 | 28756 | 4 | 0.440 | 65354.5 |
372 | 2022-09-08 19:40:05 | tecta | 1 | 28756 | 4 | 0.516 | 55728.7 |
371 | 2022-07-14 21:00:53 | tecta | 3 | 83667 | 870 | 3.466 | 24139.4 |
370 | 2022-06-05 18:39:55 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
369 | 2022-06-03 13:24:35 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
368 | 2022-05-18 03:14:21 | tecta | 2 | 53800 | 69 | 1.390 | 38705.0 |
367 | 2022-04-18 20:03:48 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
366 | 2022-02-11 06:08:59 | tecta | 1 | 28756 | 4 | 0.453 | 63479.0 |
365 | 2022-02-09 02:48:07 | tecta | 1 | 28756 | 4 | 0.440 | 65354.5 |
364 | 2021-12-14 17:08:48 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
363 | 2021-11-30 19:33:25 | tecta | 1 | 28756 | 4 | 0.546 | 52666.7 |
362 | 2021-10-12 07:58:41 | tecta | 1 | 28756 | 4 | 0.470 | 61183.0 |
361 | 2021-09-08 08:19:12 | tecta | 1 | 28756 | 4 | 0.466 | 61708.2 |
360 | 2021-09-06 03:28:33 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
359 | 2021-08-23 21:26:18 | tecta | 1 | 28756 | 4 | 0.440 | 65354.5 |
358 | 2021-08-21 20:45:16 | tecta | 1 | 28756 | 4 | 0.486 | 59168.7 |
357 | 2021-08-21 16:39:49 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
356 | 2021-06-29 21:51:55 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
355 | 2021-05-11 03:37:36 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
354 | 2021-04-27 20:26:18 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
353 | 2021-04-15 07:48:16 | tecta | 1 | 28756 | 4 | 0.563 | 51076.4 |
352 | 2021-04-11 07:48:22 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
351 | 2021-03-15 07:02:02 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
350 | 2021-01-10 19:34:39 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
349 | 2020-11-02 16:25:28 | tecta | 1 | 28756 | 4 | 0.530 | 54256.6 |
348 | 2020-10-23 11:26:25 | tecta | 1 | 28756 | 4 | 0.466 | 61708.2 |
347 | 2020-10-20 18:35:24 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
346 | 2020-10-18 06:30:28 | tecta | 1 | 28756 | 4 | 0.453 | 63479.0 |
345 | 2020-10-04 23:13:34 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
344 | 2020-09-08 08:54:06 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
343 | 2020-08-09 21:00:49 | tecta | 1 | 28756 | 4 | 0.453 | 63479.0 |
342 | 2020-06-17 11:50:47 | tecta | 1 | 28756 | 4 | 0.453 | 63479.0 |
341 | 2020-05-19 09:22:56 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
340 | 2020-03-25 07:03:53 | tecta | 1 | 28756 | 4 | 0.516 | 55728.7 |
339 | 2020-03-24 14:47:33 | tecta | 1 | 28756 | 4 | 0.546 | 52666.7 |
338 | 2020-03-22 09:36:16 | tecta | 1 | 28756 | 4 | 0.513 | 56054.6 |
337 | 2020-03-21 16:36:49 | tecta | 1 | 28756 | 4 | 0.453 | 63479.0 |
336 | 2020-03-21 06:53:16 | tecta | 1 | 28756 | 4 | 0.876 | 32826.5 |
335 | 2020-03-18 02:44:43 | tecta | 1 | 28756 | 4 | 0.483 | 59536.2 |
334 | 2020-03-15 12:37:21 | tecta | 1 | 28756 | 4 | 0.500 | 57512.0 |
333 | 2020-03-02 12:43:46 | tecta | 1 | 28756 | 4 | 0.436 | 65954.1 |
332 | 2020-02-27 04:03:43 | tecta | 1 | 28756 | 4 | 1.046 | 27491.4 |
331 | 2020-02-27 01:28:30 | tecta | 1 | 28756 | 4 | 1.123 | 25606.4 |
330 | 2020-02-23 05:13:48 | tecta | 1 | 28756 | 4 | 1.000 | 28756.0 |
329 | 2020-02-23 03:38:58 | tecta | 1 | 28756 | 4 | 0.563 | 51076.4 |
328 | 2020-02-21 01:33:53 | tecta | 1 | 28756 | 4 | 0.623 | 46157.3 |
327 | 2020-02-14 11:44:39 | tecta | 1 | 28756 | 4 | 1.110 | 25906.3 |
326 | 2020-02-10 08:25:11 | tecta | 1 | 28756 | 4 | 1.063 | 27051.7 |
325 | 2020-02-01 13:51:54 | tecta | 1 | 28756 | 4 | 0.923 | 31154.9 |
324 | 2020-01-31 00:21:08 | tecta | 1 | 28756 | 4 | 1.546 | 18600.3 |
323 | 2020-01-30 20:02:04 | tecta | 1 | 28756 | 4 | 1.046 | 27491.4 |