History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subspecies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
248 | 2025-09-04 16:45:08 | subspecies | 2 | 108824 | 3 | 3.076 | 35378.4 |
247 | 2025-08-28 19:34:24 | subspecies | 1 | 67641 | 1 | 1.220 | 55443.4 |
246 | 2025-08-17 07:36:15 | subspecies | 2 | 108824 | 3 | 8.046 | 13525.2 |
245 | 2025-08-17 00:48:03 | subspecies | 3 | 140603 | 17 | 17.530 | 8020.7 |
244 | 2025-08-16 15:22:53 | subspecies | 1 | 67641 | 1 | 2.313 | 29243.8 |
243 | 2025-08-12 14:41:18 | subspecies | 4 | 161450 | 115 | 21.783 | 7411.7 |
242 | 2025-08-11 11:29:45 | subspecies | 4 | 161450 | 115 | 55.706 | 2898.3 |
241 | 2025-08-11 11:29:29 | subspecies | 4 | 161450 | 115 | 55.940 | 2886.1 |
240 | 2025-08-07 09:36:03 | subspecies | 4 | 161450 | 115 | 45.876 | 3519.3 |
239 | 2025-08-04 21:36:24 | subspecies | 4 | 161450 | 115 | 27.423 | 5887.4 |
238 | 2025-07-26 22:54:40 | subspecies | 1 | 67641 | 1 | 5.310 | 12738.4 |
237 | 2025-07-24 01:39:16 | subspecies | 1 | 67641 | 1 | 6.766 | 9997.2 |
236 | 2025-07-20 08:41:12 | subspecies | 1 | 67641 | 1 | 1.263 | 53555.8 |
235 | 2025-06-10 16:00:30 | subspecies | 1 | 67641 | 1 | 3.686 | 18350.8 |
234 | 2025-06-05 06:37:51 | subspecies | 1 | 67641 | 1 | 5.780 | 11702.6 |
233 | 2025-05-07 19:51:11 | subspecies | 1 | 67641 | 1 | 5.533 | 12225.0 |
232 | 2025-04-18 15:10:53 | subspecies | 1 | 67641 | 1 | 4.830 | 14004.3 |
231 | 2025-02-28 22:02:35 | subspecies | 1 | 67641 | 1 | 5.936 | 11395.0 |
230 | 2025-02-13 04:46:38 | subspecies | 3 | 140603 | 17 | 22.313 | 6301.4 |
229 | 2025-02-12 22:41:50 | subspecies | 3 | 140603 | 17 | 32.876 | 4276.8 |
228 | 2025-02-12 22:41:50 | subspecies | 2 | 108824 | 3 | 10.686 | 10183.8 |
227 | 2025-02-12 22:41:09 | subspecies | 1 | 67641 | 1 | 6.406 | 10559.0 |
226 | 2025-02-05 22:39:21 | subspecies | 1 | 67641 | 1 | 1.190 | 56841.2 |
225 | 2025-01-17 08:13:34 | subspecies | 1 | 67641 | 1 | 8.686 | 7787.4 |
224 | 2025-01-08 10:12:33 | subspecies | 3 | 140603 | 17 | 35.266 | 3986.9 |
223 | 2025-01-07 14:58:36 | subspecies | 3 | 140603 | 17 | 42.423 | 3314.3 |
222 | 2025-01-06 10:56:42 | subspecies | 3 | 140603 | 17 | 30.156 | 4662.5 |
221 | 2025-01-06 10:56:46 | subspecies | 2 | 108824 | 3 | 19.766 | 5505.6 |
220 | 2025-01-06 10:56:10 | subspecies | 3 | 140603 | 17 | 39.440 | 3565.0 |
219 | 2025-01-06 10:55:43 | subspecies | 1 | 67641 | 1 | 5.266 | 12844.9 |
218 | 2025-01-05 22:41:35 | subspecies | 1 | 67641 | 1 | 1.173 | 57665.0 |
217 | 2024-12-04 07:33:02 | subspecies | 1 | 67641 | 1 | 4.343 | 15574.7 |
216 | 2024-11-09 14:16:30 | subspecies | 1 | 67641 | 1 | 2.873 | 23543.7 |
215 | 2024-11-03 13:08:40 | subspecies | 1 | 67641 | 1 | 5.280 | 12810.8 |
214 | 2024-10-30 13:18:25 | subspecies | 1 | 67641 | 1 | 5.360 | 12619.6 |
213 | 2024-09-22 11:02:42 | subspecies | 1 | 67641 | 1 | 5.093 | 13281.2 |
212 | 2024-09-17 17:33:06 | subspecies | 3 | 140603 | 17 | 46.283 | 3037.9 |
211 | 2024-09-14 02:05:22 | subspecies | 4 | 161450 | 115 | 120.593 | 1338.8 |
210 | 2024-09-10 21:01:42 | subspecies | 1 | 67641 | 1 | 14.470 | 4674.6 |
209 | 2024-09-10 14:20:21 | subspecies | 4 | 161450 | 115 | 105.930 | 1524.1 |
208 | 2024-09-08 14:46:08 | subspecies | 3 | 140603 | 17 | 24.393 | 5764.1 |
207 | 2024-09-08 03:35:53 | subspecies | 4 | 161450 | 115 | 87.786 | 1839.1 |
206 | 2024-09-08 03:35:55 | subspecies | 3 | 140603 | 17 | 68.830 | 2042.8 |
205 | 2024-09-08 03:35:54 | subspecies | 2 | 108824 | 3 | 17.843 | 6099.0 |
204 | 2024-09-08 03:33:21 | subspecies | 1 | 67641 | 1 | 6.440 | 10503.3 |
203 | 2024-09-01 00:09:29 | subspecies | 1 | 67641 | 1 | 9.500 | 7120.1 |
202 | 2024-08-31 08:48:23 | subspecies | 1 | 67641 | 1 | 12.453 | 5431.7 |
201 | 2024-08-31 08:48:04 | subspecies | 1 | 67641 | 1 | 12.470 | 5424.3 |
200 | 2024-08-04 02:13:31 | subspecies | 3 | 140603 | 17 | 24.690 | 5694.7 |
199 | 2024-08-04 02:13:36 | subspecies | 2 | 108824 | 3 | 9.953 | 10933.8 |
198 | 2024-08-04 02:10:58 | subspecies | 1 | 67641 | 1 | 1.220 | 55443.4 |
197 | 2024-07-11 02:23:48 | subspecies | 1 | 67641 | 1 | 6.003 | 11267.9 |
196 | 2024-07-10 15:05:50 | subspecies | 3 | 140603 | 17 | 37.300 | 3769.5 |
195 | 2024-07-10 15:05:51 | subspecies | 2 | 108824 | 3 | 9.733 | 11180.9 |
194 | 2024-07-10 15:05:36 | subspecies | 1 | 67641 | 1 | 3.873 | 17464.8 |
193 | 2024-07-08 17:11:10 | subspecies | 4 | 161450 | 115 | 49.100 | 3288.2 |
192 | 2024-07-07 18:15:50 | subspecies | 4 | 161450 | 115 | 36.800 | 4387.2 |
191 | 2024-07-07 08:27:03 | subspecies | 4 | 161450 | 115 | 49.660 | 3251.1 |
190 | 2024-07-06 06:12:59 | subspecies | 4 | 161450 | 115 | 23.190 | 6962.1 |
189 | 2024-07-05 08:23:56 | subspecies | 2 | 108824 | 3 | 9.440 | 11528.0 |
188 | 2024-07-05 08:23:17 | subspecies | 4 | 161450 | 115 | 34.550 | 4672.9 |
187 | 2024-07-05 08:22:13 | subspecies | 3 | 140603 | 17 | 27.156 | 5177.6 |
186 | 2024-07-05 08:21:50 | subspecies | 1 | 67641 | 1 | 5.030 | 13447.5 |
185 | 2024-06-26 11:03:09 | subspecies | 3 | 140603 | 17 | 47.066 | 2987.4 |
184 | 2024-06-26 11:03:15 | subspecies | 2 | 108824 | 3 | 10.313 | 10552.1 |
183 | 2024-06-26 10:59:06 | subspecies | 1 | 67641 | 1 | 2.173 | 31127.9 |
182 | 2024-06-13 11:33:04 | subspecies | 3 | 140603 | 17 | 33.423 | 4206.8 |
181 | 2024-06-11 20:59:55 | subspecies | 3 | 140603 | 17 | 16.863 | 8338.0 |
180 | 2024-06-11 06:55:12 | subspecies | 3 | 140603 | 17 | 31.363 | 4483.1 |
179 | 2024-06-07 03:03:26 | subspecies | 1 | 67641 | 1 | 1.940 | 34866.5 |
178 | 2024-05-28 22:51:58 | subspecies | 1 | 67641 | 1 | 3.890 | 17388.4 |
177 | 2024-05-25 01:20:12 | subspecies | 3 | 140603 | 17 | 15.310 | 9183.7 |
176 | 2024-05-25 01:20:16 | subspecies | 2 | 108824 | 3 | 7.170 | 15177.7 |
175 | 2024-05-25 01:18:18 | subspecies | 1 | 67641 | 1 | 3.080 | 21961.4 |
174 | 2024-05-09 23:19:37 | subspecies | 1 | 67641 | 1 | 1.156 | 58513.0 |
173 | 2024-05-08 05:21:03 | subspecies | 3 | 140603 | 17 | 22.346 | 6292.1 |
172 | 2024-05-08 05:21:02 | subspecies | 2 | 108824 | 3 | 10.623 | 10244.2 |
171 | 2024-05-08 05:19:31 | subspecies | 1 | 67641 | 1 | 1.080 | 62630.6 |
170 | 2024-04-25 01:21:49 | subspecies | 4 | 161450 | 115 | 18.656 | 8654.1 |
169 | 2024-04-24 19:21:48 | subspecies | 4 | 161450 | 115 | 38.566 | 4186.3 |
168 | 2024-04-22 11:42:35 | subspecies | 2 | 108824 | 3 | 15.343 | 7092.7 |
167 | 2024-04-22 11:41:44 | subspecies | 1 | 67641 | 1 | 3.923 | 17242.2 |
166 | 2024-04-22 11:41:29 | subspecies | 1 | 67641 | 1 | 3.046 | 22206.5 |
165 | 2024-04-22 11:41:15 | subspecies | 3 | 140603 | 17 | 5.750 | 24452.7 |
164 | 2024-04-20 17:26:52 | subspecies | 4 | 161450 | 115 | 37.220 | 4337.7 |
163 | 2024-04-20 11:05:37 | subspecies | 3 | 140603 | 17 | 25.066 | 5609.3 |
162 | 2024-04-20 11:05:27 | subspecies | 4 | 161450 | 115 | 33.923 | 4759.3 |
161 | 2024-04-20 11:05:37 | subspecies | 2 | 108824 | 3 | 6.313 | 17238.1 |
160 | 2024-04-20 11:01:56 | subspecies | 1 | 67641 | 1 | 1.956 | 34581.3 |
159 | 2024-04-15 18:02:12 | subspecies | 1 | 67641 | 1 | 2.530 | 26735.6 |
158 | 2024-03-26 06:09:06 | subspecies | 1 | 67641 | 1 | 1.096 | 61716.2 |
157 | 2024-03-26 06:06:21 | subspecies | 1 | 67641 | 1 | 1.236 | 54725.7 |
156 | 2024-02-23 22:10:33 | subspecies | 1 | 67641 | 1 | 1.186 | 57032.9 |
155 | 2024-02-17 20:00:44 | subspecies | 1 | 67641 | 1 | 2.873 | 23543.7 |
154 | 2024-02-05 15:51:49 | subspecies | 4 | 161450 | 115 | 19.250 | 8387.0 |
153 | 2024-02-04 14:31:53 | subspecies | 4 | 161450 | 115 | 14.456 | 11168.4 |
152 | 2024-02-04 14:31:51 | subspecies | 3 | 140603 | 17 | 10.513 | 13374.2 |
151 | 2024-02-04 14:31:55 | subspecies | 2 | 108824 | 3 | 3.596 | 30262.5 |
150 | 2024-02-04 14:25:29 | subspecies | 1 | 67641 | 1 | 2.483 | 27241.6 |
149 | 2024-01-25 16:20:19 | subspecies | 1 | 67641 | 1 | 1.016 | 66575.8 |