History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oligomer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
223 | 2024-04-25 22:21:40 | oligomer | 3 | 146162 | 23 | 21.376 | 6837.7 |
222 | 2024-04-25 22:21:48 | oligomer | 1 | 82945 | 2 | 3.203 | 25896.0 |
221 | 2024-04-25 22:21:44 | oligomer | 2 | 121059 | 3 | 5.953 | 20335.8 |
220 | 2024-04-19 10:38:46 | oligomer | 2 | 121059 | 3 | 9.703 | 12476.5 |
219 | 2024-04-19 09:18:47 | oligomer | 1 | 82945 | 2 | 1.970 | 42104.1 |
218 | 2024-04-16 00:34:23 | oligomer | 2 | 121059 | 3 | 3.173 | 38152.9 |
217 | 2024-04-13 15:41:55 | oligomer | 1 | 82945 | 2 | 1.483 | 55930.5 |
216 | 2024-04-11 06:47:37 | oligomer | 2 | 121059 | 3 | 3.296 | 36729.1 |
215 | 2024-04-11 06:47:35 | oligomer | 1 | 82945 | 2 | 1.250 | 66356.0 |
214 | 2024-04-11 01:41:47 | oligomer | 3 | 146162 | 23 | 7.783 | 18779.6 |
213 | 2024-04-09 23:29:27 | oligomer | 3 | 146162 | 23 | 19.160 | 7628.5 |
212 | 2024-04-09 19:14:12 | oligomer | 4 | 161609 | 501 | 25.190 | 6415.6 |
211 | 2024-04-08 18:52:31 | oligomer | 4 | 161609 | 501 | 44.410 | 3639.0 |
210 | 2024-04-08 16:22:09 | oligomer | 4 | 161609 | 501 | 37.893 | 4264.9 |
209 | 2024-04-08 14:37:49 | oligomer | 1 | 82945 | 2 | 3.126 | 26533.9 |
208 | 2024-04-08 14:37:38 | oligomer | 4 | 161609 | 501 | 13.733 | 11767.9 |
207 | 2024-04-08 14:37:39 | oligomer | 3 | 146162 | 23 | 8.453 | 17291.1 |
206 | 2024-04-08 14:37:40 | oligomer | 2 | 121059 | 3 | 4.343 | 27874.5 |
205 | 2024-03-19 08:57:04 | oligomer | 2 | 121059 | 3 | 9.876 | 12257.9 |
204 | 2024-03-19 08:56:01 | oligomer | 1 | 82945 | 2 | 3.673 | 22582.4 |
203 | 2024-03-13 17:18:17 | oligomer | 3 | 146162 | 23 | 16.063 | 9099.3 |
202 | 2024-03-13 17:18:17 | oligomer | 2 | 121059 | 3 | 7.783 | 15554.3 |
201 | 2024-03-13 17:18:14 | oligomer | 1 | 82945 | 2 | 2.703 | 30686.3 |
200 | 2024-03-12 03:47:27 | oligomer | 2 | 121059 | 3 | 4.313 | 28068.4 |
199 | 2024-03-12 03:47:25 | oligomer | 1 | 82945 | 2 | 1.593 | 52068.4 |
198 | 2024-03-11 22:45:19 | oligomer | 3 | 146162 | 23 | 16.923 | 8636.9 |
197 | 2024-03-11 12:21:02 | oligomer | 3 | 146162 | 23 | 14.983 | 9755.2 |
196 | 2024-03-11 12:21:01 | oligomer | 2 | 121059 | 3 | 3.983 | 30393.9 |
195 | 2024-03-11 12:20:50 | oligomer | 1 | 82945 | 2 | 1.483 | 55930.5 |
194 | 2024-03-08 22:45:09 | oligomer | 4 | 161609 | 501 | 14.173 | 11402.6 |
193 | 2024-03-07 04:24:34 | oligomer | 4 | 161609 | 501 | 27.440 | 5889.5 |
192 | 2024-03-06 07:35:35 | oligomer | 4 | 161609 | 501 | 33.643 | 4803.6 |
191 | 2024-03-05 20:15:42 | oligomer | 3 | 146162 | 23 | 25.393 | 5756.0 |
190 | 2024-03-05 10:53:26 | oligomer | 4 | 161609 | 501 | 12.843 | 12583.4 |
189 | 2024-03-05 10:53:24 | oligomer | 3 | 146162 | 23 | 7.313 | 19986.6 |
188 | 2024-03-05 10:53:25 | oligomer | 2 | 121059 | 3 | 3.750 | 32282.4 |
187 | 2024-03-05 10:53:22 | oligomer | 1 | 82945 | 2 | 1.423 | 58288.8 |
186 | 2024-02-09 15:55:39 | oligomer | 4 | 161609 | 501 | 11.766 | 13735.3 |
185 | 2024-02-08 12:18:46 | oligomer | 2 | 121059 | 3 | 12.986 | 9322.3 |
184 | 2024-02-06 17:35:42 | oligomer | 3 | 146162 | 23 | 8.406 | 17387.8 |
183 | 2024-02-06 17:35:38 | oligomer | 2 | 121059 | 3 | 3.813 | 31749.0 |
182 | 2024-02-06 17:35:34 | oligomer | 1 | 82945 | 2 | 1.456 | 56967.7 |
181 | 2024-02-02 06:39:07 | oligomer | 1 | 82945 | 2 | 1.233 | 67270.9 |
180 | 2024-02-01 01:37:16 | oligomer | 1 | 82945 | 2 | 1.423 | 58288.8 |
179 | 2024-02-01 01:37:15 | oligomer | 1 | 82945 | 2 | 1.423 | 58288.8 |
178 | 2024-02-01 01:37:12 | oligomer | 2 | 121059 | 3 | 3.530 | 34294.3 |
177 | 2024-01-28 14:20:59 | oligomer | 4 | 161609 | 501 | 11.893 | 13588.6 |
176 | 2024-01-28 14:21:03 | oligomer | 2 | 121059 | 3 | 3.576 | 33853.2 |
175 | 2024-01-28 14:19:59 | oligomer | 3 | 146162 | 23 | 6.250 | 23385.9 |
174 | 2024-01-24 17:35:39 | oligomer | 3 | 146162 | 23 | 10.050 | 14543.5 |
173 | 2023-12-31 04:43:55 | oligomer | 1 | 82945 | 2 | 1.280 | 64800.8 |
172 | 2023-12-29 21:02:45 | oligomer | 1 | 82945 | 2 | 2.906 | 28542.7 |
171 | 2023-12-25 22:31:28 | oligomer | 4 | 161609 | 501 | 16.766 | 9639.1 |
170 | 2023-12-22 17:42:36 | oligomer | 4 | 161609 | 501 | 14.093 | 11467.3 |
169 | 2023-12-17 08:16:03 | oligomer | 1 | 82945 | 2 | 1.296 | 64000.8 |
168 | 2023-12-11 11:19:17 | oligomer | 2 | 121059 | 3 | 3.076 | 39356.0 |
167 | 2023-11-12 23:52:21 | oligomer | 4 | 161609 | 501 | 10.360 | 15599.3 |
166 | 2023-11-04 09:25:25 | oligomer | 3 | 146162 | 23 | 7.390 | 19778.3 |
165 | 2023-11-02 10:44:00 | oligomer | 1 | 82945 | 2 | 1.453 | 57085.3 |
164 | 2023-10-20 12:41:59 | oligomer | 1 | 82945 | 2 | 1.423 | 58288.8 |
163 | 2023-10-07 02:31:54 | oligomer | 4 | 161609 | 501 | 15.266 | 10586.2 |
162 | 2023-09-12 00:41:44 | oligomer | 4 | 161609 | 501 | 15.156 | 10663.0 |
161 | 2023-09-09 05:33:07 | oligomer | 2 | 121059 | 3 | 3.826 | 31641.1 |
160 | 2023-08-16 14:05:35 | oligomer | 4 | 161609 | 501 | 10.390 | 15554.3 |
159 | 2023-08-16 13:11:05 | oligomer | 1 | 82945 | 2 | 1.250 | 66356.0 |
158 | 2023-08-09 07:40:34 | oligomer | 3 | 146162 | 23 | 6.220 | 23498.7 |
157 | 2023-05-25 04:41:12 | oligomer | 2 | 121059 | 3 | 3.140 | 38553.8 |
156 | 2023-05-21 02:10:30 | oligomer | 1 | 82945 | 2 | 1.250 | 66356.0 |
155 | 2023-04-27 20:38:17 | oligomer | 4 | 161609 | 501 | 10.250 | 15766.7 |
154 | 2023-04-24 02:54:50 | oligomer | 3 | 146162 | 23 | 6.063 | 24107.2 |
153 | 2023-03-16 14:12:01 | oligomer | 1 | 82945 | 2 | 1.250 | 66356.0 |
152 | 2023-03-04 05:24:15 | oligomer | 2 | 121059 | 3 | 3.470 | 34887.3 |
151 | 2023-01-31 18:24:52 | oligomer | 4 | 161609 | 501 | 16.373 | 9870.5 |
150 | 2023-01-30 12:13:12 | oligomer | 3 | 146162 | 23 | 6.686 | 21860.9 |
149 | 2023-01-04 21:20:53 | oligomer | 1 | 82945 | 2 | 1.233 | 67270.9 |
148 | 2022-12-28 00:31:31 | oligomer | 1 | 82945 | 2 | 1.376 | 60279.8 |
147 | 2022-12-11 07:39:54 | oligomer | 2 | 121059 | 3 | 3.563 | 33976.7 |
146 | 2022-12-02 23:44:08 | oligomer | 1 | 82945 | 2 | 1.373 | 60411.5 |
145 | 2022-11-26 05:00:42 | oligomer | 1 | 82945 | 2 | 1.346 | 61623.3 |
144 | 2022-11-22 13:59:54 | oligomer | 1 | 82945 | 2 | 1.406 | 58993.6 |
143 | 2022-11-12 03:34:47 | oligomer | 3 | 146162 | 23 | 6.343 | 23043.0 |
142 | 2022-11-11 16:01:21 | oligomer | 4 | 161609 | 501 | 11.266 | 14344.8 |
141 | 2022-09-28 23:14:57 | oligomer | 1 | 82945 | 2 | 1.360 | 60989.0 |
140 | 2022-07-13 16:47:31 | oligomer | 2 | 121059 | 3 | 3.186 | 37997.2 |
139 | 2022-06-14 08:29:52 | oligomer | 3 | 146162 | 23 | 6.110 | 23921.8 |
138 | 2022-06-12 03:43:51 | oligomer | 4 | 161609 | 501 | 10.346 | 15620.4 |
137 | 2022-05-09 11:31:08 | oligomer | 1 | 82945 | 2 | 1.846 | 44932.3 |
136 | 2022-05-07 07:36:41 | oligomer | 1 | 82945 | 2 | 1.326 | 62552.8 |
135 | 2022-02-22 09:30:33 | oligomer | 2 | 121059 | 3 | 3.703 | 32692.1 |
134 | 2022-01-24 02:50:19 | oligomer | 1 | 82945 | 2 | 1.390 | 59672.7 |
133 | 2021-12-09 10:22:38 | oligomer | 2 | 121059 | 3 | 3.983 | 30393.9 |
132 | 2021-11-17 12:29:39 | oligomer | 1 | 82945 | 2 | 1.453 | 57085.3 |
131 | 2021-10-03 05:04:29 | oligomer | 1 | 82945 | 2 | 1.233 | 67270.9 |
130 | 2021-10-01 01:59:24 | oligomer | 1 | 82945 | 2 | 1.406 | 58993.6 |
129 | 2021-08-23 01:37:29 | oligomer | 1 | 82945 | 2 | 1.376 | 60279.8 |
128 | 2021-08-20 21:37:49 | oligomer | 1 | 82945 | 2 | 1.516 | 54713.1 |
127 | 2021-06-12 12:53:41 | oligomer | 3 | 146162 | 23 | 7.233 | 20207.7 |
126 | 2021-05-29 15:05:12 | oligomer | 1 | 82945 | 2 | 1.466 | 56579.1 |
125 | 2021-03-21 22:48:01 | oligomer | 3 | 146162 | 23 | 7.686 | 19016.7 |
124 | 2021-03-17 17:10:22 | oligomer | 1 | 82945 | 2 | 1.470 | 56425.2 |