History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"echovirus"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
138 | 2024-04-22 20:33:17 | echovirus | 3 | 148641 | 16 | 18.796 | 7908.1 |
137 | 2024-04-22 20:33:23 | echovirus | 2 | 121436 | 2 | 4.736 | 25641.0 |
136 | 2024-04-22 20:33:01 | echovirus | 1 | 81242 | 1 | 1.360 | 59736.8 |
135 | 2024-04-19 02:50:07 | echovirus | 1 | 81242 | 1 | 1.390 | 58447.5 |
134 | 2024-04-17 21:04:51 | echovirus | 1 | 81242 | 1 | 5.410 | 15017.0 |
133 | 2024-04-06 17:44:42 | echovirus | 1 | 81242 | 1 | 1.656 | 49059.2 |
132 | 2024-03-31 19:30:18 | echovirus | 1 | 81242 | 1 | 1.500 | 54161.3 |
131 | 2024-03-27 15:27:17 | echovirus | 4 | 165329 | 109 | 12.406 | 13326.5 |
130 | 2024-03-27 02:59:17 | echovirus | 4 | 165329 | 109 | 31.016 | 5330.4 |
129 | 2024-03-26 19:46:22 | echovirus | 4 | 165329 | 109 | 42.816 | 3861.4 |
128 | 2024-03-26 19:46:12 | echovirus | 3 | 148641 | 16 | 13.810 | 10763.3 |
127 | 2024-03-25 00:29:39 | echovirus | 4 | 165329 | 109 | 17.126 | 9653.7 |
126 | 2024-03-25 00:29:48 | echovirus | 2 | 121436 | 2 | 7.373 | 16470.4 |
125 | 2024-03-25 00:29:43 | echovirus | 3 | 148641 | 16 | 8.170 | 18193.5 |
124 | 2024-03-25 00:29:23 | echovirus | 1 | 81242 | 1 | 1.440 | 56418.1 |
123 | 2024-03-11 22:05:02 | echovirus | 1 | 81242 | 1 | 4.780 | 16996.2 |
122 | 2024-03-07 20:59:29 | echovirus | 1 | 81242 | 1 | 3.050 | 26636.7 |
121 | 2024-03-06 08:31:22 | echovirus | 1 | 81242 | 1 | 1.576 | 51549.5 |
120 | 2024-02-19 21:32:32 | echovirus | 2 | 121436 | 2 | 6.406 | 18956.6 |
119 | 2024-02-19 16:42:52 | echovirus | 3 | 148641 | 16 | 8.313 | 17880.5 |
118 | 2024-02-19 15:27:57 | echovirus | 1 | 81242 | 1 | 3.003 | 27053.6 |
117 | 2024-02-08 23:38:57 | echovirus | 4 | 165329 | 109 | 38.173 | 4331.0 |
116 | 2024-02-08 23:38:58 | echovirus | 2 | 121436 | 2 | 4.000 | 30359.0 |
115 | 2024-02-08 23:38:28 | echovirus | 3 | 148641 | 16 | 10.393 | 14302.0 |
114 | 2024-02-08 23:37:13 | echovirus | 1 | 81242 | 1 | 1.330 | 61084.2 |
113 | 2024-02-01 05:42:44 | echovirus | 1 | 81242 | 1 | 1.373 | 59171.2 |
112 | 2024-02-01 00:33:24 | echovirus | 1 | 81242 | 1 | 1.330 | 61084.2 |
111 | 2024-01-01 03:37:20 | echovirus | 1 | 81242 | 1 | 1.343 | 60492.9 |
110 | 2023-12-27 05:28:14 | echovirus | 1 | 81242 | 1 | 1.423 | 57092.1 |
109 | 2023-12-22 23:06:21 | echovirus | 1 | 81242 | 1 | 1.266 | 64172.2 |
108 | 2023-10-19 07:33:00 | echovirus | 1 | 81242 | 1 | 1.360 | 59736.8 |
107 | 2023-10-11 06:01:51 | echovirus | 1 | 81242 | 1 | 1.673 | 48560.7 |
106 | 2023-08-08 02:16:47 | echovirus | 1 | 81242 | 1 | 1.233 | 65889.7 |
105 | 2023-05-03 10:45:04 | echovirus | 1 | 81242 | 1 | 1.233 | 65889.7 |
104 | 2023-02-27 09:35:29 | echovirus | 1 | 81242 | 1 | 1.423 | 57092.1 |
103 | 2022-12-23 23:16:34 | echovirus | 1 | 81242 | 1 | 1.203 | 67532.8 |
102 | 2022-09-07 04:01:17 | echovirus | 1 | 81242 | 1 | 1.470 | 55266.7 |
101 | 2022-09-05 00:44:26 | echovirus | 1 | 81242 | 1 | 1.220 | 66591.8 |
100 | 2022-05-19 22:40:48 | echovirus | 1 | 81242 | 1 | 1.250 | 64993.6 |
99 | 2022-04-13 23:58:27 | echovirus | 1 | 81242 | 1 | 1.513 | 53696.0 |
98 | 2022-01-11 21:04:24 | echovirus | 1 | 81242 | 1 | 1.453 | 55913.3 |
97 | 2021-11-09 21:46:01 | echovirus | 1 | 81242 | 1 | 1.220 | 66591.8 |
96 | 2021-11-07 20:39:51 | echovirus | 1 | 81242 | 1 | 1.390 | 58447.5 |
95 | 2021-10-12 04:26:45 | echovirus | 1 | 81242 | 1 | 1.343 | 60492.9 |
94 | 2021-09-07 22:07:21 | echovirus | 1 | 81242 | 1 | 2.563 | 31698.0 |
93 | 2021-04-14 10:15:15 | echovirus | 1 | 81242 | 1 | 1.296 | 62686.7 |
92 | 2021-04-11 18:05:25 | echovirus | 4 | 165329 | 109 | 15.316 | 10794.5 |
91 | 2021-03-15 16:23:48 | echovirus | 4 | 165329 | 109 | 12.236 | 13511.7 |
90 | 2021-02-20 23:46:23 | echovirus | 1 | 81242 | 1 | 1.343 | 60492.9 |
89 | 2021-01-28 00:06:45 | echovirus | 1 | 81242 | 1 | 1.330 | 61084.2 |
88 | 2021-01-25 22:12:18 | echovirus | 4 | 165329 | 109 | 10.530 | 15700.8 |
87 | 2020-12-30 06:33:17 | echovirus | 1 | 81242 | 1 | 1.233 | 65889.7 |
86 | 2020-11-08 11:59:26 | echovirus | 1 | 81242 | 1 | 1.313 | 61875.1 |
85 | 2020-11-06 21:56:33 | echovirus | 1 | 81242 | 1 | 1.250 | 64993.6 |
84 | 2020-04-23 05:21:40 | echovirus | 1 | 81242 | 1 | 1.250 | 64993.6 |
83 | 2020-03-28 20:37:16 | echovirus | 1 | 81242 | 1 | 1.376 | 59042.2 |
82 | 2020-03-24 13:11:27 | echovirus | 1 | 81242 | 1 | 1.826 | 44491.8 |
81 | 2020-03-24 11:15:59 | echovirus | 1 | 81242 | 1 | 1.623 | 50056.7 |
80 | 2020-03-21 16:09:06 | echovirus | 1 | 81242 | 1 | 1.356 | 59913.0 |
79 | 2020-02-18 15:35:00 | echovirus | 1 | 81242 | 1 | 1.670 | 48647.9 |
78 | 2020-02-18 12:47:29 | echovirus | 1 | 81242 | 1 | 2.483 | 32719.3 |
77 | 2020-02-13 00:51:32 | echovirus | 1 | 81242 | 1 | 3.110 | 26122.8 |
76 | 2020-02-08 15:23:09 | echovirus | 1 | 81242 | 1 | 3.186 | 25499.7 |
75 | 2020-02-07 05:07:10 | echovirus | 4 | 165329 | 109 | 18.126 | 9121.1 |
74 | 2020-02-06 20:57:23 | echovirus | 4 | 165329 | 109 | 14.860 | 11125.8 |
73 | 2020-02-05 18:51:03 | echovirus | 3 | 148641 | 16 | 14.423 | 10305.8 |
72 | 2020-02-05 18:50:29 | echovirus | 2 | 121436 | 2 | 5.920 | 20512.8 |
71 | 2020-02-05 18:08:19 | echovirus | 4 | 165329 | 109 | 12.096 | 13668.1 |
70 | 2020-02-05 15:37:48 | echovirus | 1 | 81242 | 1 | 2.063 | 39380.5 |
69 | 2020-02-05 02:52:00 | echovirus | 3 | 148641 | 16 | 10.750 | 13827.1 |
68 | 2020-02-05 02:48:51 | echovirus | 4 | 165329 | 109 | 19.640 | 8418.0 |
67 | 2020-02-05 02:17:11 | echovirus | 2 | 121436 | 2 | 8.060 | 15066.5 |
66 | 2020-02-04 20:36:52 | echovirus | 1 | 81242 | 1 | 1.623 | 50056.7 |
65 | 2020-02-02 08:31:20 | echovirus | 1 | 81242 | 1 | 2.703 | 30056.2 |
64 | 2020-01-18 12:15:00 | echovirus | 1 | 81242 | 1 | 1.546 | 52549.8 |
63 | 2020-01-10 14:34:00 | echovirus | 1 | 81242 | 1 | 1.500 | 54161.3 |
62 | 2020-01-04 23:00:12 | echovirus | 1 | 81242 | 1 | 2.406 | 33766.4 |
61 | 2019-12-22 07:46:57 | echovirus | 1 | 81242 | 1 | 1.326 | 61268.5 |
60 | 2019-12-01 16:38:26 | echovirus | 1 | 81242 | 1 | 1.420 | 57212.7 |
59 | 2019-11-03 02:56:17 | echovirus | 1 | 81242 | 1 | 1.233 | 65889.7 |
58 | 2019-08-27 03:51:24 | echovirus | 1 | 81242 | 1 | 1.326 | 61268.5 |
57 | 2019-05-05 11:15:25 | echovirus | 1 | 81242 | 1 | 1.233 | 65889.7 |
56 | 2019-02-26 01:29:34 | echovirus | 1 | 81242 | 1 | 1.193 | 68098.9 |
55 | 2019-02-07 04:09:04 | echovirus | 1 | 81242 | 1 | 1.390 | 58447.5 |
54 | 2018-12-27 07:46:31 | echovirus | 1 | 81242 | 1 | 1.386 | 58616.2 |
53 | 2018-08-03 17:50:55 | echovirus | 1 | 81242 | 1 | 1.326 | 61268.5 |
52 | 2018-04-26 14:06:09 | echovirus | 1 | 81242 | 1 | 1.456 | 55798.1 |
51 | 2018-01-03 15:42:29 | echovirus | 1 | 81242 | 1 | 1.746 | 46530.4 |
50 | 2017-11-12 17:19:50 | echovirus | 1 | 81242 | 1 | 2.276 | 35695.1 |
49 | 2017-10-27 00:20:01 | echovirus | 1 | 81242 | 1 | 1.920 | 42313.5 |
48 | 2017-08-20 01:13:07 | echovirus | 1 | 81242 | 1 | 2.223 | 36546.1 |
47 | 2017-08-07 17:38:49 | echovirus | 1 | 81242 | 1 | 1.736 | 46798.4 |
46 | 2017-06-02 08:57:06 | echovirus | 1 | 81242 | 1 | 1.686 | 48186.2 |
45 | 2017-04-23 12:12:28 | echovirus | 1 | 81242 | 1 | 1.526 | 53238.5 |
44 | 2017-04-08 07:56:50 | echovirus | 1 | 81242 | 1 | 2.046 | 39707.7 |
43 | 2016-12-19 11:29:01 | echovirus | 1 | 81242 | 1 | 1.733 | 46879.4 |
42 | 2016-11-09 20:48:31 | echovirus | 1 | 81242 | 1 | 3.813 | 21306.6 |
41 | 2016-07-28 02:45:03 | echovirus | 4 | 165329 | 109 | 16.980 | 9736.7 |
40 | 2016-07-27 23:31:29 | echovirus | 3 | 148641 | 16 | 10.316 | 14408.8 |
39 | 2016-07-27 09:59:43 | echovirus | 2 | 121436 | 2 | 5.703 | 21293.4 |