History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subfields"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
283 | 2025-05-06 05:36:56 | subfields | 1 | 81242 | 2 | 9.623 | 8442.5 |
282 | 2025-05-03 23:02:49 | subfields | 1 | 81242 | 2 | 5.610 | 14481.6 |
281 | 2025-04-26 14:47:04 | subfields | 1 | 81242 | 2 | 4.893 | 16603.7 |
280 | 2025-04-23 05:28:12 | subfields | 3 | 148641 | 28 | 27.626 | 5380.5 |
279 | 2025-04-21 01:29:18 | subfields | 3 | 148641 | 28 | 32.986 | 4506.2 |
278 | 2025-04-18 23:16:56 | subfields | 3 | 148641 | 28 | 28.300 | 5252.3 |
277 | 2025-04-01 22:52:36 | subfields | 1 | 81242 | 2 | 6.656 | 12205.8 |
276 | 2025-03-26 15:53:30 | subfields | 1 | 81242 | 2 | 6.640 | 12235.2 |
275 | 2025-03-21 02:13:27 | subfields | 3 | 148641 | 28 | 26.226 | 5667.7 |
274 | 2025-03-20 17:10:11 | subfields | 1 | 81242 | 2 | 7.393 | 10989.0 |
273 | 2025-03-19 21:17:32 | subfields | 1 | 81242 | 2 | 4.593 | 17688.2 |
272 | 2025-03-16 03:18:31 | subfields | 3 | 148641 | 28 | 41.563 | 3576.3 |
271 | 2025-03-14 02:39:28 | subfields | 1 | 81242 | 2 | 7.890 | 10296.8 |
270 | 2025-03-13 04:33:34 | subfields | 3 | 148641 | 28 | 32.986 | 4506.2 |
269 | 2025-03-11 16:00:15 | subfields | 1 | 81242 | 2 | 9.843 | 8253.8 |
268 | 2025-03-05 21:39:18 | subfields | 3 | 148641 | 28 | 20.583 | 7221.5 |
267 | 2025-02-10 06:37:43 | subfields | 1 | 81242 | 2 | 4.530 | 17934.2 |
266 | 2025-02-02 02:44:07 | subfields | 2 | 121436 | 4 | 19.236 | 6313.0 |
265 | 2025-02-02 02:43:57 | subfields | 3 | 148641 | 28 | 21.876 | 6794.7 |
264 | 2025-02-02 02:34:15 | subfields | 1 | 81242 | 2 | 1.390 | 58447.5 |
263 | 2025-02-01 10:09:08 | subfields | 1 | 81242 | 2 | 6.966 | 11662.6 |
262 | 2024-12-28 15:40:45 | subfields | 1 | 81242 | 2 | 6.856 | 11849.8 |
261 | 2024-12-21 09:54:33 | subfields | 1 | 81242 | 2 | 1.436 | 56575.2 |
260 | 2024-12-05 15:05:51 | subfields | 1 | 81242 | 2 | 6.890 | 11791.3 |
259 | 2024-11-27 22:46:34 | subfields | 1 | 81242 | 2 | 6.796 | 11954.4 |
258 | 2024-11-27 19:17:05 | subfields | 3 | 148641 | 28 | 42.880 | 3466.4 |
257 | 2024-11-18 06:24:43 | subfields | 2 | 121436 | 4 | 22.660 | 5359.0 |
256 | 2024-11-18 06:19:59 | subfields | 1 | 81242 | 2 | 6.690 | 12143.8 |
255 | 2024-11-17 18:45:52 | subfields | 3 | 148641 | 28 | 35.830 | 4148.5 |
254 | 2024-11-17 18:45:03 | subfields | 2 | 121436 | 4 | 27.706 | 4383.0 |
253 | 2024-11-10 02:12:54 | subfields | 1 | 81242 | 2 | 3.296 | 24648.7 |
252 | 2024-10-30 13:21:01 | subfields | 1 | 81242 | 2 | 5.906 | 13755.8 |
251 | 2024-10-29 06:42:18 | subfields | 3 | 148641 | 28 | 34.050 | 4365.4 |
250 | 2024-10-28 02:11:03 | subfields | 1 | 81242 | 2 | 6.576 | 12354.3 |
249 | 2024-10-26 09:40:20 | subfields | 3 | 148641 | 28 | 34.020 | 4369.2 |
248 | 2024-10-25 09:02:12 | subfields | 3 | 148641 | 28 | 45.190 | 3289.2 |
247 | 2024-10-24 09:31:03 | subfields | 3 | 148641 | 28 | 42.736 | 3478.1 |
246 | 2024-10-04 17:24:45 | subfields | 1 | 81242 | 2 | 11.580 | 7015.7 |
245 | 2024-09-23 11:08:46 | subfields | 1 | 81242 | 2 | 10.783 | 7534.3 |
244 | 2024-09-23 11:05:38 | subfields | 3 | 148641 | 28 | 58.050 | 2560.6 |
243 | 2024-09-23 11:05:08 | subfields | 3 | 148641 | 28 | 59.020 | 2518.5 |
242 | 2024-09-21 18:35:31 | subfields | 1 | 81242 | 2 | 9.643 | 8425.0 |
241 | 2024-09-20 18:28:20 | subfields | 3 | 148641 | 28 | 63.676 | 2334.3 |
240 | 2024-09-19 01:01:22 | subfields | 3 | 148641 | 28 | 51.550 | 2883.4 |
239 | 2024-09-18 23:36:04 | subfields | 4 | 165329 | 213 | 96.596 | 1711.6 |
238 | 2024-09-18 23:36:11 | subfields | 3 | 148641 | 28 | 76.893 | 1933.1 |
237 | 2024-09-18 23:13:43 | subfields | 1 | 81242 | 2 | 1.436 | 56575.2 |
236 | 2024-08-23 07:40:45 | subfields | 1 | 81242 | 2 | 4.423 | 18368.1 |
235 | 2024-08-23 06:39:26 | subfields | 2 | 121436 | 4 | 13.686 | 8873.0 |
234 | 2024-08-23 06:39:11 | subfields | 1 | 81242 | 2 | 7.046 | 11530.2 |
233 | 2024-08-07 19:14:07 | subfields | 3 | 148641 | 28 | 29.066 | 5113.9 |
232 | 2024-08-01 01:41:52 | subfields | 3 | 148641 | 28 | 27.970 | 5314.3 |
231 | 2024-07-28 14:10:21 | subfields | 3 | 148641 | 28 | 38.813 | 3829.7 |
230 | 2024-07-28 14:10:20 | subfields | 2 | 121436 | 4 | 13.190 | 9206.7 |
229 | 2024-07-28 14:09:04 | subfields | 1 | 81242 | 2 | 5.030 | 16151.5 |
228 | 2024-07-28 14:00:55 | subfields | 4 | 165329 | 213 | 36.300 | 4554.5 |
227 | 2024-07-26 10:17:05 | subfields | 4 | 165329 | 213 | 56.123 | 2945.8 |
226 | 2024-07-26 07:00:41 | subfields | 4 | 165329 | 213 | 50.173 | 3295.2 |
225 | 2024-07-24 18:37:04 | subfields | 4 | 165329 | 213 | 33.266 | 4969.9 |
224 | 2024-07-24 10:00:32 | subfields | 3 | 148641 | 28 | 27.906 | 5326.5 |
223 | 2024-07-24 10:00:29 | subfields | 4 | 165329 | 213 | 23.313 | 7091.7 |
222 | 2024-07-24 10:00:33 | subfields | 2 | 121436 | 4 | 19.953 | 6086.1 |
221 | 2024-07-24 09:57:38 | subfields | 1 | 81242 | 2 | 5.046 | 16100.3 |
220 | 2024-07-07 08:17:35 | subfields | 2 | 121436 | 4 | 8.610 | 14104.1 |
219 | 2024-07-07 08:16:11 | subfields | 1 | 81242 | 2 | 5.890 | 13793.2 |
218 | 2024-07-07 06:04:41 | subfields | 3 | 148641 | 28 | 19.016 | 7816.6 |
217 | 2024-07-05 22:13:44 | subfields | 3 | 148641 | 28 | 13.270 | 11201.3 |
216 | 2024-07-05 06:48:52 | subfields | 1 | 81242 | 2 | 4.563 | 17804.5 |
215 | 2024-07-05 06:11:48 | subfields | 2 | 121436 | 4 | 7.440 | 16322.0 |
214 | 2024-07-05 06:08:08 | subfields | 3 | 148641 | 28 | 30.080 | 4941.5 |
213 | 2024-07-05 06:07:13 | subfields | 3 | 148641 | 28 | 18.686 | 7954.7 |
212 | 2024-07-05 06:07:12 | subfields | 1 | 81242 | 2 | 5.736 | 14163.5 |
211 | 2024-07-05 06:07:04 | subfields | 1 | 81242 | 2 | 7.233 | 11232.1 |
210 | 2024-07-05 05:21:26 | subfields | 1 | 81242 | 2 | 6.516 | 12468.1 |
209 | 2024-07-05 04:39:57 | subfields | 1 | 81242 | 2 | 5.093 | 15951.7 |
208 | 2024-07-05 04:35:10 | subfields | 1 | 81242 | 2 | 7.486 | 10852.5 |
207 | 2024-06-25 23:34:36 | subfields | 3 | 148641 | 28 | 35.253 | 4216.4 |
206 | 2024-06-24 02:30:37 | subfields | 3 | 148641 | 28 | 29.906 | 4970.3 |
205 | 2024-06-23 03:25:34 | subfields | 1 | 81242 | 2 | 2.873 | 28277.8 |
204 | 2024-06-22 13:54:23 | subfields | 3 | 148641 | 28 | 36.830 | 4035.9 |
203 | 2024-06-21 01:44:20 | subfields | 3 | 148641 | 28 | 41.080 | 3618.3 |
202 | 2024-06-21 01:44:19 | subfields | 2 | 121436 | 4 | 12.170 | 9978.3 |
201 | 2024-06-21 01:12:16 | subfields | 1 | 81242 | 2 | 1.470 | 55266.7 |
200 | 2024-06-20 21:02:46 | subfields | 4 | 165329 | 213 | 47.330 | 3493.1 |
199 | 2024-06-19 03:56:24 | subfields | 4 | 165329 | 213 | 31.046 | 5325.3 |
198 | 2024-06-18 13:16:41 | subfields | 4 | 165329 | 213 | 55.106 | 3000.2 |
197 | 2024-06-18 07:15:03 | subfields | 4 | 165329 | 213 | 60.550 | 2730.5 |
196 | 2024-06-17 08:15:04 | subfields | 4 | 165329 | 213 | 17.580 | 9404.4 |
195 | 2024-05-19 15:44:28 | subfields | 4 | 165329 | 213 | 22.593 | 7317.7 |
194 | 2024-05-19 15:44:31 | subfields | 4 | 165329 | 213 | 16.783 | 9851.0 |
193 | 2024-05-16 22:57:49 | subfields | 3 | 148641 | 28 | 9.406 | 15802.8 |
192 | 2024-05-16 22:57:44 | subfields | 2 | 121436 | 4 | 8.123 | 14949.6 |
191 | 2024-05-16 22:56:26 | subfields | 1 | 81242 | 2 | 1.670 | 48647.9 |
190 | 2024-05-14 01:42:06 | subfields | 1 | 81242 | 2 | 2.330 | 34867.8 |
189 | 2024-05-13 20:20:10 | subfields | 4 | 165329 | 213 | 30.426 | 5433.8 |
188 | 2024-05-13 20:19:23 | subfields | 1 | 81242 | 2 | 5.360 | 15157.1 |
187 | 2024-05-11 21:05:45 | subfields | 1 | 81242 | 2 | 1.763 | 46081.7 |
186 | 2024-05-08 19:39:31 | subfields | 3 | 148641 | 28 | 24.423 | 6086.1 |
185 | 2024-05-08 19:39:32 | subfields | 2 | 121436 | 4 | 9.500 | 12782.7 |
184 | 2024-05-08 17:12:59 | subfields | 1 | 81242 | 2 | 3.046 | 26671.7 |