History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subphylum"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
264 | 2025-09-08 22:10:00 | subphylum | 1 | 81242 | 1 | 1.406 | 57782.4 |
263 | 2025-08-01 07:53:38 | subphylum | 1 | 81242 | 1 | 4.860 | 16716.5 |
262 | 2025-07-24 08:45:45 | subphylum | 1 | 81242 | 1 | 5.343 | 15205.3 |
261 | 2025-07-24 02:21:08 | subphylum | 1 | 81242 | 1 | 8.546 | 9506.4 |
260 | 2025-06-21 10:28:59 | subphylum | 1 | 81242 | 1 | 6.186 | 13133.2 |
259 | 2025-06-13 19:07:20 | subphylum | 1 | 81242 | 1 | 1.500 | 54161.3 |
258 | 2025-03-23 21:55:51 | subphylum | 1 | 81242 | 1 | 3.736 | 21745.7 |
257 | 2025-03-20 00:00:37 | subphylum | 1 | 81242 | 1 | 6.830 | 11894.9 |
256 | 2025-03-15 21:24:09 | subphylum | 1 | 81242 | 1 | 5.766 | 14089.8 |
255 | 2025-01-24 19:03:24 | subphylum | 1 | 81242 | 1 | 1.373 | 59171.2 |
254 | 2025-01-14 07:56:44 | subphylum | 1 | 81242 | 1 | 5.610 | 14481.6 |
253 | 2025-01-14 02:18:25 | subphylum | 3 | 148641 | 4 | 34.206 | 4345.5 |
252 | 2025-01-14 02:18:26 | subphylum | 2 | 121436 | 3 | 17.823 | 6813.4 |
251 | 2025-01-14 02:17:26 | subphylum | 1 | 81242 | 1 | 7.076 | 11481.3 |
250 | 2025-01-08 14:18:40 | subphylum | 3 | 148641 | 4 | 42.940 | 3461.6 |
249 | 2025-01-08 14:19:01 | subphylum | 3 | 148641 | 4 | 18.813 | 7901.0 |
248 | 2025-01-08 14:18:34 | subphylum | 3 | 148641 | 4 | 40.020 | 3714.2 |
247 | 2025-01-08 14:18:34 | subphylum | 2 | 121436 | 3 | 11.470 | 10587.3 |
246 | 2024-12-26 04:53:46 | subphylum | 1 | 81242 | 1 | 7.233 | 11232.1 |
245 | 2024-12-14 08:06:08 | subphylum | 1 | 81242 | 1 | 1.406 | 57782.4 |
244 | 2024-12-11 09:06:01 | subphylum | 1 | 81242 | 1 | 6.796 | 11954.4 |
243 | 2024-11-26 13:27:56 | subphylum | 3 | 148641 | 4 | 35.423 | 4196.2 |
242 | 2024-11-18 17:42:39 | subphylum | 3 | 148641 | 4 | 33.566 | 4428.3 |
241 | 2024-11-18 17:42:37 | subphylum | 3 | 148641 | 4 | 35.220 | 4220.4 |
240 | 2024-11-18 17:42:34 | subphylum | 2 | 121436 | 3 | 15.643 | 7763.0 |
239 | 2024-11-18 17:42:01 | subphylum | 3 | 148641 | 4 | 36.313 | 4093.3 |
238 | 2024-11-16 11:53:37 | subphylum | 3 | 148641 | 4 | 39.690 | 3745.0 |
237 | 2024-11-16 11:53:36 | subphylum | 3 | 148641 | 4 | 36.330 | 4091.4 |
236 | 2024-11-14 03:13:22 | subphylum | 1 | 81242 | 1 | 9.876 | 8226.2 |
235 | 2024-11-13 18:18:22 | subphylum | 4 | 165329 | 18 | 57.330 | 2883.8 |
234 | 2024-11-13 18:18:19 | subphylum | 4 | 165329 | 18 | 54.880 | 3012.6 |
233 | 2024-11-13 18:18:20 | subphylum | 3 | 148641 | 4 | 33.343 | 4457.9 |
232 | 2024-11-13 18:18:19 | subphylum | 2 | 121436 | 3 | 20.173 | 6019.7 |
231 | 2024-11-13 17:12:32 | subphylum | 1 | 81242 | 1 | 1.296 | 62686.7 |
230 | 2024-10-03 22:50:44 | subphylum | 1 | 81242 | 1 | 5.126 | 15849.0 |
229 | 2024-08-31 19:43:08 | subphylum | 1 | 81242 | 1 | 10.873 | 7471.9 |
228 | 2024-08-11 15:46:45 | subphylum | 1 | 81242 | 1 | 6.956 | 11679.4 |
227 | 2024-08-08 22:35:26 | subphylum | 1 | 81242 | 1 | 5.623 | 14448.2 |
226 | 2024-07-18 05:04:02 | subphylum | 4 | 165329 | 18 | 40.473 | 4084.9 |
225 | 2024-07-08 01:09:27 | subphylum | 1 | 81242 | 1 | 6.593 | 12322.5 |
224 | 2024-07-07 17:17:04 | subphylum | 1 | 81242 | 1 | 7.093 | 11453.8 |
223 | 2024-07-02 13:05:15 | subphylum | 4 | 165329 | 18 | 52.550 | 3146.1 |
222 | 2024-07-01 03:18:11 | subphylum | 4 | 165329 | 18 | 43.376 | 3811.5 |
221 | 2024-06-30 20:49:13 | subphylum | 3 | 148641 | 4 | 24.970 | 5952.8 |
220 | 2024-06-30 16:54:23 | subphylum | 4 | 165329 | 18 | 59.736 | 2767.7 |
219 | 2024-06-30 16:54:25 | subphylum | 3 | 148641 | 4 | 34.330 | 4329.8 |
218 | 2024-06-30 16:54:26 | subphylum | 2 | 121436 | 3 | 13.156 | 9230.5 |
217 | 2024-06-30 16:52:26 | subphylum | 1 | 81242 | 1 | 4.813 | 16879.7 |
216 | 2024-06-26 14:17:36 | subphylum | 5 | 174418 | 246 | 51.873 | 3362.4 |
215 | 2024-06-19 15:32:51 | subphylum | 5 | 174418 | 246 | 56.973 | 3061.4 |
214 | 2024-06-19 10:38:05 | subphylum | 3 | 148641 | 4 | 26.970 | 5511.3 |
213 | 2024-06-16 17:16:16 | subphylum | 4 | 165329 | 18 | 22.830 | 7241.7 |
212 | 2024-06-16 10:58:06 | subphylum | 2 | 121436 | 3 | 19.330 | 6282.3 |
211 | 2024-06-05 12:29:33 | subphylum | 1 | 81242 | 1 | 1.500 | 54161.3 |
210 | 2024-06-04 08:15:12 | subphylum | 1 | 81242 | 1 | 1.376 | 59042.2 |
209 | 2024-06-02 17:26:57 | subphylum | 3 | 148641 | 4 | 6.810 | 21826.9 |
208 | 2024-05-30 12:09:22 | subphylum | 4 | 165329 | 18 | 42.440 | 3895.6 |
207 | 2024-05-27 14:59:19 | subphylum | 3 | 148641 | 4 | 8.453 | 17584.4 |
206 | 2024-05-27 14:59:20 | subphylum | 2 | 121436 | 3 | 7.016 | 17308.4 |
205 | 2024-05-27 14:59:08 | subphylum | 1 | 81242 | 1 | 2.093 | 38816.1 |
204 | 2024-05-27 11:19:33 | subphylum | 5 | 174418 | 246 | 40.596 | 4296.4 |
203 | 2024-05-27 02:04:16 | subphylum | 4 | 165329 | 18 | 18.110 | 9129.2 |
202 | 2024-05-26 09:57:33 | subphylum | 3 | 148641 | 4 | 22.813 | 6515.6 |
201 | 2024-05-26 09:57:35 | subphylum | 2 | 121436 | 3 | 13.516 | 8984.6 |
200 | 2024-05-26 09:57:01 | subphylum | 1 | 81242 | 1 | 3.673 | 22118.7 |
199 | 2024-05-26 09:54:45 | subphylum | 5 | 174418 | 246 | 48.173 | 3620.7 |
198 | 2024-05-26 07:18:24 | subphylum | 5 | 174418 | 246 | 54.813 | 3182.1 |
197 | 2024-05-26 07:18:30 | subphylum | 3 | 148641 | 4 | 15.470 | 9608.3 |
196 | 2024-05-26 07:18:28 | subphylum | 4 | 165329 | 18 | 16.626 | 9944.0 |
195 | 2024-05-26 07:18:30 | subphylum | 2 | 121436 | 3 | 12.440 | 9761.7 |
194 | 2024-05-26 07:18:01 | subphylum | 1 | 81242 | 1 | 4.423 | 18368.1 |
193 | 2024-05-06 02:58:51 | subphylum | 1 | 81242 | 1 | 1.580 | 51419.0 |
192 | 2024-05-05 23:53:23 | subphylum | 2 | 121436 | 3 | 4.046 | 30013.8 |
191 | 2024-05-04 08:12:11 | subphylum | 1 | 81242 | 1 | 1.423 | 57092.1 |
190 | 2024-05-03 13:44:39 | subphylum | 1 | 81242 | 1 | 1.530 | 53099.3 |
189 | 2024-04-28 22:45:25 | subphylum | 4 | 165329 | 18 | 22.686 | 7287.7 |
188 | 2024-04-26 06:07:12 | subphylum | 4 | 165329 | 18 | 11.596 | 14257.4 |
187 | 2024-04-19 16:24:08 | subphylum | 4 | 165329 | 18 | 33.720 | 4903.0 |
186 | 2024-04-14 12:20:59 | subphylum | 2 | 121436 | 3 | 14.563 | 8338.7 |
185 | 2024-04-14 12:20:32 | subphylum | 3 | 148641 | 4 | 25.066 | 5930.0 |
184 | 2024-04-14 12:20:01 | subphylum | 4 | 165329 | 18 | 29.643 | 5577.3 |
183 | 2024-04-14 12:19:23 | subphylum | 1 | 81242 | 1 | 4.000 | 20310.5 |
182 | 2024-04-11 06:41:16 | subphylum | 1 | 81242 | 1 | 3.110 | 26122.8 |
181 | 2024-04-01 19:10:38 | subphylum | 4 | 165329 | 18 | 44.440 | 3720.3 |
180 | 2024-03-31 10:41:48 | subphylum | 4 | 165329 | 18 | 37.956 | 4355.8 |
179 | 2024-03-28 06:59:04 | subphylum | 4 | 165329 | 18 | 11.296 | 14636.1 |
178 | 2024-03-14 16:49:35 | subphylum | 5 | 174418 | 246 | 43.110 | 4045.9 |
177 | 2024-03-11 17:26:24 | subphylum | 4 | 165329 | 18 | 29.580 | 5589.2 |
176 | 2024-03-11 14:38:11 | subphylum | 4 | 165329 | 18 | 35.456 | 4662.9 |
175 | 2024-03-11 08:27:42 | subphylum | 4 | 165329 | 18 | 32.956 | 5016.7 |
174 | 2024-03-11 08:09:12 | subphylum | 4 | 165329 | 18 | 44.550 | 3711.1 |
173 | 2024-03-11 08:09:08 | subphylum | 5 | 174418 | 246 | 44.080 | 3956.9 |
172 | 2024-03-11 08:09:39 | subphylum | 2 | 121436 | 3 | 11.783 | 10306.0 |
171 | 2024-03-11 08:09:18 | subphylum | 3 | 148641 | 4 | 13.373 | 11115.0 |
170 | 2024-03-11 08:07:40 | subphylum | 1 | 81242 | 1 | 2.966 | 27391.1 |
169 | 2024-03-11 02:15:29 | subphylum | 1 | 81242 | 1 | 1.640 | 49537.8 |
168 | 2024-02-28 22:15:11 | subphylum | 1 | 81242 | 1 | 1.513 | 53696.0 |
167 | 2024-02-26 22:50:24 | subphylum | 1 | 81242 | 1 | 1.546 | 52549.8 |
166 | 2024-02-09 19:15:40 | subphylum | 1 | 81242 | 1 | 4.800 | 16925.4 |
165 | 2024-02-05 17:14:38 | subphylum | 1 | 81242 | 1 | 1.393 | 58321.6 |