History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clupeoid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
240 | 2024-05-05 18:50:24 | clupeoid | 2 | 121059 | 4 | 6.750 | 17934.7 |
239 | 2024-05-01 11:47:27 | clupeoid | 3 | 146162 | 16 | 18.313 | 7981.3 |
238 | 2024-05-01 10:26:17 | clupeoid | 3 | 146162 | 16 | 24.940 | 5860.5 |
237 | 2024-05-01 10:25:56 | clupeoid | 2 | 121059 | 4 | 10.593 | 11428.2 |
236 | 2024-05-01 10:24:13 | clupeoid | 1 | 82945 | 3 | 3.313 | 25036.2 |
235 | 2024-04-29 21:45:43 | clupeoid | 1 | 82945 | 3 | 2.953 | 28088.4 |
234 | 2024-04-29 21:45:03 | clupeoid | 3 | 146162 | 16 | 6.923 | 21112.5 |
233 | 2024-04-29 21:44:59 | clupeoid | 2 | 121059 | 4 | 3.470 | 34887.3 |
232 | 2024-04-11 11:16:10 | clupeoid | 3 | 146162 | 16 | 7.660 | 19081.2 |
231 | 2024-04-11 11:16:07 | clupeoid | 2 | 121059 | 4 | 7.360 | 16448.2 |
230 | 2024-04-11 11:15:52 | clupeoid | 1 | 82945 | 3 | 1.376 | 60279.8 |
229 | 2024-04-07 19:05:16 | clupeoid | 3 | 146162 | 16 | 16.813 | 8693.4 |
228 | 2024-04-07 19:05:14 | clupeoid | 2 | 121059 | 4 | 4.656 | 26000.6 |
227 | 2024-04-07 19:04:58 | clupeoid | 4 | 161609 | 291 | 17.220 | 9385.0 |
226 | 2024-04-07 15:24:04 | clupeoid | 4 | 161609 | 291 | 45.343 | 3564.1 |
225 | 2024-04-06 17:22:59 | clupeoid | 4 | 161609 | 291 | 31.910 | 5064.5 |
224 | 2024-04-05 00:47:21 | clupeoid | 4 | 161609 | 291 | 11.703 | 13809.2 |
223 | 2024-04-05 00:39:48 | clupeoid | 4 | 161609 | 291 | 17.330 | 9325.4 |
222 | 2024-04-05 00:39:53 | clupeoid | 3 | 146162 | 16 | 9.516 | 15359.6 |
221 | 2024-04-05 00:39:51 | clupeoid | 2 | 121059 | 4 | 9.000 | 13451.0 |
220 | 2024-04-05 00:39:50 | clupeoid | 1 | 82945 | 3 | 1.750 | 47397.1 |
219 | 2024-03-30 18:30:25 | clupeoid | 3 | 146162 | 16 | 8.406 | 17387.8 |
218 | 2024-03-30 18:30:24 | clupeoid | 2 | 121059 | 4 | 3.906 | 30993.1 |
217 | 2024-03-30 18:30:20 | clupeoid | 1 | 82945 | 3 | 2.483 | 33405.2 |
216 | 2024-03-30 09:34:25 | clupeoid | 1 | 82945 | 3 | 4.890 | 16962.2 |
215 | 2024-03-12 02:51:26 | clupeoid | 3 | 146162 | 16 | 24.610 | 5939.1 |
214 | 2024-03-12 02:51:25 | clupeoid | 2 | 121059 | 4 | 11.060 | 10945.7 |
213 | 2024-03-12 02:51:26 | clupeoid | 1 | 82945 | 3 | 4.890 | 16962.2 |
212 | 2024-03-11 03:35:10 | clupeoid | 3 | 146162 | 16 | 7.376 | 19815.9 |
211 | 2024-03-11 03:35:06 | clupeoid | 2 | 121059 | 4 | 3.936 | 30756.9 |
210 | 2024-03-11 03:35:02 | clupeoid | 1 | 82945 | 3 | 1.483 | 55930.5 |
209 | 2024-03-07 22:30:49 | clupeoid | 4 | 161609 | 291 | 20.376 | 7931.3 |
208 | 2024-03-05 18:26:40 | clupeoid | 3 | 146162 | 16 | 18.050 | 8097.6 |
207 | 2024-03-05 13:15:58 | clupeoid | 3 | 146162 | 16 | 8.000 | 18270.3 |
206 | 2024-03-05 13:15:57 | clupeoid | 2 | 121059 | 4 | 4.190 | 28892.4 |
205 | 2024-03-05 03:18:01 | clupeoid | 4 | 161609 | 291 | 30.250 | 5342.4 |
204 | 2024-03-04 09:37:32 | clupeoid | 4 | 161609 | 291 | 19.593 | 8248.3 |
203 | 2024-03-03 20:37:18 | clupeoid | 3 | 146162 | 16 | 13.203 | 11070.4 |
202 | 2024-03-03 20:37:17 | clupeoid | 4 | 161609 | 291 | 14.080 | 11477.9 |
201 | 2024-03-03 20:37:20 | clupeoid | 2 | 121059 | 4 | 4.486 | 26986.0 |
200 | 2024-03-03 20:37:13 | clupeoid | 1 | 82945 | 3 | 1.610 | 51518.6 |
199 | 2024-02-29 14:12:14 | clupeoid | 1 | 82945 | 3 | 3.080 | 26930.2 |
198 | 2024-02-26 02:20:25 | clupeoid | 1 | 82945 | 3 | 2.060 | 40264.6 |
197 | 2024-02-13 02:04:06 | clupeoid | 1 | 82945 | 3 | 1.356 | 61168.9 |
196 | 2024-02-11 16:47:54 | clupeoid | 1 | 82945 | 3 | 1.626 | 51011.7 |
195 | 2024-02-08 06:54:07 | clupeoid | 4 | 161609 | 291 | 11.736 | 13770.4 |
194 | 2024-02-07 09:04:34 | clupeoid | 3 | 146162 | 16 | 14.656 | 9972.8 |
193 | 2024-02-07 09:04:30 | clupeoid | 2 | 121059 | 4 | 3.766 | 32145.2 |
192 | 2024-02-07 09:04:26 | clupeoid | 1 | 82945 | 3 | 1.440 | 57600.7 |
191 | 2024-02-04 06:40:19 | clupeoid | 3 | 146162 | 16 | 14.266 | 10245.5 |
190 | 2024-02-04 06:40:23 | clupeoid | 2 | 121059 | 4 | 3.826 | 31641.1 |
189 | 2024-02-04 06:40:15 | clupeoid | 1 | 82945 | 3 | 1.530 | 54212.4 |
188 | 2024-02-01 00:49:16 | clupeoid | 2 | 121059 | 4 | 3.513 | 34460.3 |
187 | 2024-02-01 00:49:04 | clupeoid | 3 | 146162 | 16 | 7.750 | 18859.6 |
186 | 2024-01-31 08:47:34 | clupeoid | 4 | 161609 | 291 | 13.203 | 12240.3 |
185 | 2024-01-31 07:22:31 | clupeoid | 4 | 161609 | 291 | 13.940 | 11593.2 |
184 | 2024-01-31 05:39:15 | clupeoid | 4 | 161609 | 291 | 12.893 | 12534.6 |
183 | 2024-01-31 05:39:19 | clupeoid | 2 | 121059 | 4 | 7.656 | 15812.3 |
182 | 2024-01-31 05:39:11 | clupeoid | 3 | 146162 | 16 | 7.346 | 19896.8 |
181 | 2024-01-31 05:38:55 | clupeoid | 1 | 82945 | 3 | 1.500 | 55296.7 |
180 | 2024-01-17 19:43:48 | clupeoid | 1 | 82945 | 3 | 1.516 | 54713.1 |
179 | 2023-12-16 07:31:59 | clupeoid | 4 | 161609 | 291 | 20.750 | 7788.4 |
178 | 2023-12-16 07:05:49 | clupeoid | 4 | 161609 | 291 | 17.313 | 9334.5 |
177 | 2023-11-30 09:05:54 | clupeoid | 1 | 82945 | 3 | 1.296 | 64000.8 |
176 | 2023-11-23 21:54:41 | clupeoid | 1 | 82945 | 3 | 1.390 | 59672.7 |
175 | 2023-11-11 19:38:58 | clupeoid | 4 | 161609 | 291 | 13.766 | 11739.7 |
174 | 2023-10-14 22:33:31 | clupeoid | 1 | 82945 | 3 | 1.453 | 57085.3 |
173 | 2023-09-29 16:10:06 | clupeoid | 1 | 82945 | 3 | 1.483 | 55930.5 |
172 | 2023-09-29 13:47:43 | clupeoid | 1 | 82945 | 3 | 1.360 | 60989.0 |
171 | 2023-09-15 04:08:44 | clupeoid | 1 | 82945 | 3 | 1.420 | 58412.0 |
170 | 2023-09-11 08:52:24 | clupeoid | 1 | 82945 | 3 | 1.440 | 57600.7 |
169 | 2023-08-14 07:38:21 | clupeoid | 4 | 161609 | 291 | 10.280 | 15720.7 |
168 | 2023-07-15 10:01:40 | clupeoid | 1 | 82945 | 3 | 1.296 | 64000.8 |
167 | 2023-07-08 14:21:14 | clupeoid | 1 | 82945 | 3 | 1.266 | 65517.4 |
166 | 2023-06-29 18:59:55 | clupeoid | 1 | 82945 | 3 | 1.250 | 66356.0 |
165 | 2023-05-27 05:28:10 | clupeoid | 1 | 82945 | 3 | 1.266 | 65517.4 |
164 | 2023-04-25 16:37:13 | clupeoid | 4 | 161609 | 291 | 10.203 | 15839.4 |
163 | 2023-04-08 20:17:41 | clupeoid | 1 | 82945 | 3 | 1.456 | 56967.7 |
162 | 2023-01-31 07:49:29 | clupeoid | 1 | 82945 | 3 | 1.423 | 58288.8 |
161 | 2023-01-28 12:04:08 | clupeoid | 1 | 82945 | 3 | 1.250 | 66356.0 |
160 | 2023-01-28 01:36:51 | clupeoid | 4 | 161609 | 291 | 10.656 | 15166.0 |
159 | 2023-01-27 19:25:26 | clupeoid | 1 | 82945 | 3 | 1.266 | 65517.4 |
158 | 2023-01-20 16:37:19 | clupeoid | 4 | 161609 | 291 | 12.453 | 12977.5 |
157 | 2022-12-23 06:11:19 | clupeoid | 4 | 161609 | 291 | 10.373 | 15579.8 |
156 | 2022-11-26 15:16:06 | clupeoid | 1 | 82945 | 3 | 1.266 | 65517.4 |
155 | 2022-11-09 23:34:29 | clupeoid | 4 | 161609 | 291 | 10.343 | 15625.0 |
154 | 2022-09-21 20:20:29 | clupeoid | 1 | 82945 | 3 | 1.296 | 64000.8 |
153 | 2022-07-21 17:58:13 | clupeoid | 1 | 82945 | 3 | 1.406 | 58993.6 |
152 | 2022-05-15 21:23:20 | clupeoid | 1 | 82945 | 3 | 1.406 | 58993.6 |
151 | 2022-05-05 19:51:53 | clupeoid | 4 | 161609 | 291 | 11.190 | 14442.3 |
150 | 2022-03-21 03:35:42 | clupeoid | 1 | 82945 | 3 | 1.406 | 58993.6 |
149 | 2022-03-19 00:13:41 | clupeoid | 1 | 82945 | 3 | 1.423 | 58288.8 |
148 | 2022-01-11 07:32:56 | clupeoid | 1 | 82945 | 3 | 1.533 | 54106.3 |
147 | 2021-12-27 01:58:31 | clupeoid | 1 | 82945 | 3 | 1.360 | 60989.0 |
146 | 2021-12-24 23:27:30 | clupeoid | 1 | 82945 | 3 | 1.516 | 54713.1 |
145 | 2021-11-11 04:47:07 | clupeoid | 1 | 82945 | 3 | 1.500 | 55296.7 |
144 | 2021-09-28 17:23:23 | clupeoid | 1 | 82945 | 3 | 1.280 | 64800.8 |
143 | 2021-05-04 18:16:36 | clupeoid | 2 | 121059 | 4 | 3.763 | 32170.9 |
142 | 2021-04-30 21:23:17 | clupeoid | 1 | 82945 | 3 | 1.623 | 51106.0 |
141 | 2021-01-28 07:39:23 | clupeoid | 1 | 82945 | 3 | 1.280 | 64800.8 |