History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"manhole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
474 | 2024-03-30 11:39:52 | manhole | 2 | 107671 | 19 | 3.186 | 33795.0 |
473 | 2024-03-03 11:08:40 | manhole | 1 | 69583 | 2 | 2.800 | 24851.1 |
472 | 2024-01-26 14:07:17 | manhole | 3 | 134027 | 215 | 7.550 | 17751.9 |
471 | 2024-01-26 11:39:04 | manhole | 3 | 134027 | 215 | 7.190 | 18640.8 |
470 | 2024-01-07 07:40:25 | manhole | 1 | 69583 | 2 | 1.203 | 57841.2 |
469 | 2024-01-05 16:26:19 | manhole | 3 | 134027 | 215 | 6.873 | 19500.5 |
468 | 2023-12-18 09:51:38 | manhole | 1 | 69583 | 2 | 1.093 | 63662.4 |
467 | 2023-12-08 04:54:52 | manhole | 1 | 69583 | 2 | 1.156 | 60192.9 |
466 | 2023-12-06 14:14:50 | manhole | 3 | 134027 | 215 | 6.140 | 21828.5 |
465 | 2023-12-06 14:14:47 | manhole | 2 | 107671 | 19 | 3.250 | 33129.5 |
464 | 2023-12-05 03:26:47 | manhole | 2 | 107671 | 19 | 3.330 | 32333.6 |
463 | 2023-11-25 09:42:32 | manhole | 2 | 107671 | 19 | 2.906 | 37051.3 |
462 | 2023-11-25 09:42:25 | manhole | 3 | 134027 | 215 | 5.826 | 23005.0 |
461 | 2023-11-17 09:48:55 | manhole | 1 | 69583 | 2 | 1.233 | 56433.9 |
460 | 2023-11-11 00:38:44 | manhole | 1 | 69583 | 2 | 1.063 | 65459.1 |
459 | 2023-11-07 00:25:42 | manhole | 3 | 134027 | 215 | 7.966 | 16824.9 |
458 | 2023-10-31 16:37:49 | manhole | 1 | 69583 | 2 | 1.076 | 64668.2 |
457 | 2023-10-21 23:43:43 | manhole | 1 | 69583 | 2 | 1.110 | 62687.4 |
456 | 2023-10-18 21:20:51 | manhole | 1 | 69583 | 2 | 1.076 | 64668.2 |
455 | 2023-09-25 10:08:30 | manhole | 1 | 69583 | 2 | 1.186 | 58670.3 |
454 | 2023-09-02 07:42:40 | manhole | 2 | 107671 | 19 | 2.940 | 36622.8 |
453 | 2023-08-25 08:45:13 | manhole | 1 | 69583 | 2 | 1.080 | 64428.7 |
452 | 2023-08-11 02:18:08 | manhole | 3 | 134027 | 215 | 6.596 | 20319.4 |
451 | 2023-07-23 16:40:19 | manhole | 1 | 69583 | 2 | 1.280 | 54361.7 |
450 | 2023-05-26 12:10:34 | manhole | 1 | 69583 | 2 | 1.283 | 54234.6 |
449 | 2023-05-21 01:26:10 | manhole | 2 | 107671 | 19 | 2.843 | 37872.3 |
448 | 2023-04-24 16:59:35 | manhole | 3 | 134027 | 215 | 5.733 | 23378.2 |
447 | 2023-04-08 07:43:46 | manhole | 1 | 69583 | 2 | 1.076 | 64668.2 |
446 | 2023-03-23 08:40:14 | manhole | 1 | 69583 | 2 | 1.076 | 64668.2 |
445 | 2023-03-01 13:38:53 | manhole | 2 | 107671 | 19 | 2.826 | 38100.1 |
444 | 2023-01-31 00:09:32 | manhole | 3 | 134027 | 215 | 5.843 | 22938.0 |
443 | 2023-01-17 08:52:27 | manhole | 1 | 69583 | 2 | 1.156 | 60192.9 |
442 | 2023-01-09 13:12:03 | manhole | 1 | 69583 | 2 | 1.313 | 52995.4 |
441 | 2022-12-19 08:00:54 | manhole | 1 | 69583 | 2 | 1.050 | 66269.5 |
440 | 2022-12-09 09:54:39 | manhole | 2 | 107671 | 19 | 2.830 | 38046.3 |
439 | 2022-11-12 06:14:59 | manhole | 3 | 134027 | 215 | 5.826 | 23005.0 |
438 | 2022-10-12 03:27:23 | manhole | 1 | 69583 | 2 | 1.093 | 63662.4 |
437 | 2022-08-19 05:14:16 | manhole | 1 | 69583 | 2 | 1.156 | 60192.9 |
436 | 2022-07-24 01:55:25 | manhole | 2 | 107671 | 19 | 2.843 | 37872.3 |
435 | 2022-06-02 15:40:27 | manhole | 1 | 69583 | 2 | 1.063 | 65459.1 |
434 | 2022-05-28 09:04:41 | manhole | 3 | 134027 | 215 | 5.720 | 23431.3 |
433 | 2022-05-16 08:06:52 | manhole | 1 | 69583 | 2 | 1.123 | 61961.7 |
432 | 2022-04-18 17:44:09 | manhole | 1 | 69583 | 2 | 1.296 | 53690.6 |
431 | 2022-02-12 13:20:12 | manhole | 1 | 69583 | 2 | 1.216 | 57222.9 |
430 | 2022-01-21 01:30:45 | manhole | 3 | 134027 | 215 | 6.686 | 20045.9 |
429 | 2021-12-30 12:17:31 | manhole | 1 | 69583 | 2 | 1.186 | 58670.3 |
428 | 2021-12-04 02:59:52 | manhole | 1 | 69583 | 2 | 1.220 | 57035.2 |
427 | 2021-10-13 14:10:10 | manhole | 1 | 69583 | 2 | 1.420 | 49002.1 |
426 | 2021-09-24 15:30:57 | manhole | 1 | 69583 | 2 | 1.250 | 55666.4 |
425 | 2021-09-23 10:39:27 | manhole | 1 | 69583 | 2 | 1.186 | 58670.3 |
424 | 2021-08-18 15:36:08 | manhole | 1 | 69583 | 2 | 1.140 | 61037.7 |
423 | 2021-08-16 10:45:29 | manhole | 1 | 69583 | 2 | 1.156 | 60192.9 |
422 | 2021-08-12 17:13:53 | manhole | 1 | 69583 | 2 | 1.233 | 56433.9 |
421 | 2021-07-28 14:08:26 | manhole | 2 | 107671 | 19 | 2.923 | 36835.8 |
420 | 2021-07-10 06:05:56 | manhole | 1 | 69583 | 2 | 1.096 | 63488.1 |
419 | 2021-06-20 08:50:01 | manhole | 1 | 69583 | 2 | 1.126 | 61796.6 |
418 | 2021-06-19 07:20:08 | manhole | 2 | 107671 | 19 | 2.970 | 36252.9 |
417 | 2021-06-17 02:32:02 | manhole | 1 | 69583 | 2 | 1.200 | 57985.8 |
416 | 2021-06-07 08:50:59 | manhole | 1 | 69583 | 2 | 1.203 | 57841.2 |
415 | 2021-05-13 13:20:05 | manhole | 1 | 69583 | 2 | 1.280 | 54361.7 |
414 | 2021-04-29 13:15:25 | manhole | 1 | 69583 | 2 | 1.283 | 54234.6 |
413 | 2021-04-12 11:03:23 | manhole | 1 | 69583 | 2 | 1.296 | 53690.6 |
412 | 2021-03-14 07:51:18 | manhole | 1 | 69583 | 2 | 1.093 | 63662.4 |
411 | 2021-01-26 09:37:52 | manhole | 1 | 69583 | 2 | 1.143 | 60877.5 |
410 | 2020-12-07 18:14:19 | manhole | 2 | 107671 | 19 | 3.250 | 33129.5 |
409 | 2020-12-03 08:43:31 | manhole | 1 | 69583 | 2 | 1.093 | 63662.4 |
408 | 2020-11-20 16:15:30 | manhole | 1 | 69583 | 2 | 1.093 | 63662.4 |
407 | 2020-11-18 08:54:23 | manhole | 1 | 69583 | 2 | 1.250 | 55666.4 |
406 | 2020-11-05 03:15:02 | manhole | 2 | 107671 | 19 | 3.063 | 35152.1 |
405 | 2020-11-01 11:44:29 | manhole | 1 | 69583 | 2 | 1.186 | 58670.3 |
404 | 2020-10-27 04:03:54 | manhole | 1 | 69583 | 2 | 1.093 | 63662.4 |
403 | 2020-10-22 23:22:05 | manhole | 1 | 69583 | 2 | 1.080 | 64428.7 |
402 | 2020-10-18 21:44:14 | manhole | 1 | 69583 | 2 | 1.063 | 65459.1 |
401 | 2020-10-14 11:19:06 | manhole | 1 | 69583 | 2 | 1.076 | 64668.2 |
400 | 2020-10-11 19:38:17 | manhole | 1 | 69583 | 2 | 1.076 | 64668.2 |
399 | 2020-10-11 11:25:59 | manhole | 1 | 69583 | 2 | 1.080 | 64428.7 |
398 | 2020-08-28 21:35:14 | manhole | 1 | 69583 | 2 | 1.203 | 57841.2 |
397 | 2020-08-25 16:59:26 | manhole | 1 | 69583 | 2 | 1.123 | 61961.7 |
396 | 2020-05-24 07:37:05 | manhole | 1 | 69583 | 2 | 1.173 | 59320.5 |
395 | 2020-03-29 07:10:20 | manhole | 1 | 69583 | 2 | 1.330 | 52318.0 |
394 | 2020-03-28 20:25:43 | manhole | 1 | 69583 | 2 | 1.216 | 57222.9 |
393 | 2020-03-24 13:59:51 | manhole | 1 | 69583 | 2 | 1.470 | 47335.4 |
392 | 2020-03-22 17:06:36 | manhole | 1 | 69583 | 2 | 1.266 | 54962.9 |
391 | 2020-03-20 17:28:30 | manhole | 1 | 69583 | 2 | 1.250 | 55666.4 |
390 | 2020-02-28 09:49:09 | manhole | 1 | 69583 | 2 | 2.546 | 27330.3 |
389 | 2020-02-25 17:37:48 | manhole | 1 | 69583 | 2 | 1.186 | 58670.3 |
388 | 2020-02-21 02:15:22 | manhole | 1 | 69583 | 2 | 1.280 | 54361.7 |
387 | 2020-02-18 09:48:06 | manhole | 1 | 69583 | 2 | 1.873 | 37150.6 |
386 | 2020-02-06 21:19:21 | manhole | 1 | 69583 | 2 | 1.250 | 55666.4 |
385 | 2020-02-05 11:47:48 | manhole | 1 | 69583 | 2 | 4.266 | 16311.1 |
384 | 2020-02-04 16:35:17 | manhole | 1 | 69583 | 2 | 2.750 | 25302.9 |
383 | 2020-01-31 12:19:15 | manhole | 1 | 69583 | 2 | 1.296 | 53690.6 |
382 | 2020-01-29 08:27:08 | manhole | 1 | 69583 | 2 | 1.376 | 50569.0 |
381 | 2020-01-24 17:42:55 | manhole | 1 | 69583 | 2 | 1.860 | 37410.2 |
380 | 2020-01-15 20:21:38 | manhole | 1 | 69583 | 2 | 2.606 | 26701.1 |
379 | 2020-01-15 00:56:29 | manhole | 1 | 69583 | 2 | 1.390 | 50059.7 |
378 | 2020-01-11 21:22:46 | manhole | 1 | 69583 | 2 | 1.750 | 39761.7 |
377 | 2020-01-07 15:39:03 | manhole | 1 | 69583 | 2 | 1.360 | 51164.0 |
376 | 2019-12-30 23:44:14 | manhole | 1 | 69583 | 2 | 1.360 | 51164.0 |
375 | 2019-12-26 20:58:52 | manhole | 1 | 69583 | 2 | 1.140 | 61037.7 |