History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subsect"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
291 | 2024-04-27 10:05:40 | subsect | 1 | 69583 | 4 | 1.280 | 54361.7 |
290 | 2024-04-27 03:57:53 | subsect | 3 | 134027 | 120 | 8.203 | 16338.8 |
289 | 2024-04-27 03:27:14 | subsect | 2 | 107671 | 20 | 7.156 | 15046.3 |
288 | 2024-04-26 15:44:49 | subsect | 2 | 107671 | 20 | 2.783 | 38688.8 |
287 | 2024-04-26 15:44:32 | subsect | 3 | 134027 | 120 | 6.326 | 21186.7 |
286 | 2024-04-26 03:07:08 | subsect | 1 | 69583 | 4 | 1.173 | 59320.5 |
285 | 2024-04-26 03:07:04 | subsect | 2 | 107671 | 20 | 3.140 | 34290.1 |
284 | 2024-04-26 03:07:00 | subsect | 3 | 134027 | 120 | 7.096 | 18887.7 |
283 | 2024-04-19 01:36:52 | subsect | 1 | 69583 | 4 | 1.296 | 53690.6 |
282 | 2024-03-30 09:46:04 | subsect | 1 | 69583 | 4 | 3.106 | 22402.8 |
281 | 2024-03-26 18:53:42 | subsect | 2 | 107671 | 20 | 2.953 | 36461.6 |
280 | 2024-03-26 18:53:05 | subsect | 3 | 134027 | 120 | 6.126 | 21878.4 |
279 | 2024-03-23 09:40:26 | subsect | 2 | 107671 | 20 | 3.546 | 30364.1 |
278 | 2024-03-23 09:39:39 | subsect | 3 | 134027 | 120 | 7.280 | 18410.3 |
277 | 2024-03-19 19:06:59 | subsect | 2 | 107671 | 20 | 3.500 | 30763.1 |
276 | 2024-03-19 15:33:35 | subsect | 3 | 134027 | 120 | 15.576 | 8604.7 |
275 | 2024-03-18 20:22:55 | subsect | 2 | 107671 | 20 | 3.690 | 29179.1 |
274 | 2024-03-18 20:22:39 | subsect | 3 | 134027 | 120 | 7.983 | 16789.1 |
273 | 2024-03-18 11:08:15 | subsect | 2 | 107671 | 20 | 9.986 | 10782.2 |
272 | 2024-03-18 11:07:58 | subsect | 3 | 134027 | 120 | 5.970 | 22450.1 |
271 | 2024-03-18 09:48:04 | subsect | 2 | 107671 | 20 | 11.876 | 9066.3 |
270 | 2024-03-18 09:47:59 | subsect | 3 | 134027 | 120 | 11.080 | 12096.3 |
269 | 2024-03-18 09:47:38 | subsect | 1 | 69583 | 4 | 4.266 | 16311.1 |
268 | 2024-03-05 12:35:07 | subsect | 1 | 69583 | 4 | 1.936 | 35941.6 |
267 | 2024-02-14 17:11:49 | subsect | 1 | 69583 | 4 | 3.893 | 17873.9 |
266 | 2024-01-31 04:49:51 | subsect | 2 | 107671 | 20 | 3.343 | 32207.9 |
265 | 2024-01-31 04:46:19 | subsect | 3 | 134027 | 120 | 7.250 | 18486.5 |
264 | 2024-01-30 03:55:41 | subsect | 3 | 134027 | 120 | 6.983 | 19193.3 |
263 | 2024-01-08 19:43:45 | subsect | 1 | 69583 | 4 | 1.313 | 52995.4 |
262 | 2024-01-03 00:13:03 | subsect | 1 | 69583 | 4 | 1.343 | 51811.6 |
261 | 2023-12-28 05:24:01 | subsect | 3 | 134027 | 120 | 5.670 | 23637.9 |
260 | 2023-11-22 09:02:51 | subsect | 1 | 69583 | 4 | 1.110 | 62687.4 |
259 | 2023-11-09 10:28:04 | subsect | 1 | 69583 | 4 | 1.203 | 57841.2 |
258 | 2023-11-06 11:18:28 | subsect | 1 | 69583 | 4 | 1.170 | 59472.6 |
257 | 2023-11-03 17:05:09 | subsect | 1 | 69583 | 4 | 1.123 | 61961.7 |
256 | 2023-10-25 17:11:35 | subsect | 1 | 69583 | 4 | 1.093 | 63662.4 |
255 | 2023-10-07 12:14:23 | subsect | 1 | 69583 | 4 | 1.093 | 63662.4 |
254 | 2023-10-02 17:26:33 | subsect | 1 | 69583 | 4 | 1.123 | 61961.7 |
253 | 2023-10-02 01:13:03 | subsect | 3 | 134027 | 120 | 5.660 | 23679.7 |
252 | 2023-08-20 10:16:14 | subsect | 1 | 69583 | 4 | 1.296 | 53690.6 |
251 | 2023-07-12 07:29:42 | subsect | 3 | 134027 | 120 | 6.890 | 19452.4 |
250 | 2023-05-27 02:54:34 | subsect | 1 | 69583 | 4 | 1.076 | 64668.2 |
249 | 2023-05-21 04:01:52 | subsect | 1 | 69583 | 4 | 1.076 | 64668.2 |
248 | 2023-03-31 08:51:54 | subsect | 3 | 134027 | 120 | 5.843 | 22938.0 |
247 | 2023-03-16 09:29:34 | subsect | 1 | 69583 | 4 | 1.063 | 65459.1 |
246 | 2023-01-24 01:40:09 | subsect | 1 | 69583 | 4 | 1.076 | 64668.2 |
245 | 2023-01-02 23:10:27 | subsect | 1 | 69583 | 4 | 1.076 | 64668.2 |
244 | 2022-12-28 04:02:45 | subsect | 3 | 134027 | 120 | 5.546 | 24166.4 |
243 | 2022-11-25 01:37:52 | subsect | 1 | 69583 | 4 | 1.093 | 63662.4 |
242 | 2022-09-21 06:42:11 | subsect | 1 | 69583 | 4 | 1.076 | 64668.2 |
241 | 2022-09-18 03:29:25 | subsect | 1 | 69583 | 4 | 1.106 | 62914.1 |
240 | 2022-08-29 04:14:26 | subsect | 3 | 134027 | 120 | 5.640 | 23763.7 |
239 | 2022-06-30 03:09:04 | subsect | 2 | 107671 | 20 | 2.766 | 38926.6 |
238 | 2022-05-09 00:58:48 | subsect | 1 | 69583 | 4 | 1.110 | 62687.4 |
237 | 2022-05-04 08:42:44 | subsect | 1 | 69583 | 4 | 1.156 | 60192.9 |
236 | 2022-01-25 11:38:45 | subsect | 1 | 69583 | 4 | 1.110 | 62687.4 |
235 | 2022-01-07 22:51:52 | subsect | 1 | 69583 | 4 | 1.360 | 51164.0 |
234 | 2021-11-16 18:24:01 | subsect | 1 | 69583 | 4 | 1.126 | 61796.6 |
233 | 2021-10-14 21:57:09 | subsect | 1 | 69583 | 4 | 1.280 | 54361.7 |
232 | 2021-09-19 00:50:53 | subsect | 1 | 69583 | 4 | 1.203 | 57841.2 |
231 | 2021-06-15 22:00:04 | subsect | 1 | 69583 | 4 | 1.203 | 57841.2 |
230 | 2021-05-19 15:13:24 | subsect | 1 | 69583 | 4 | 1.220 | 57035.2 |
229 | 2021-04-19 12:18:17 | subsect | 1 | 69583 | 4 | 1.330 | 52318.0 |
228 | 2021-04-12 08:03:03 | subsect | 2 | 107671 | 20 | 2.876 | 37437.8 |
227 | 2021-04-12 00:47:34 | subsect | 3 | 134027 | 120 | 6.253 | 21434.0 |
226 | 2021-03-22 09:25:27 | subsect | 1 | 69583 | 4 | 1.126 | 61796.6 |
225 | 2021-03-16 12:59:28 | subsect | 1 | 69583 | 4 | 1.406 | 49490.0 |
224 | 2021-01-29 10:24:06 | subsect | 1 | 69583 | 4 | 1.110 | 62687.4 |
223 | 2021-01-28 17:26:44 | subsect | 1 | 69583 | 4 | 1.123 | 61961.7 |
222 | 2021-01-26 17:45:04 | subsect | 1 | 69583 | 4 | 1.110 | 62687.4 |
221 | 2021-01-26 05:38:49 | subsect | 1 | 69583 | 4 | 1.216 | 57222.9 |
220 | 2021-01-04 09:20:14 | subsect | 1 | 69583 | 4 | 1.106 | 62914.1 |
219 | 2020-12-13 13:31:55 | subsect | 1 | 69583 | 4 | 1.080 | 64428.7 |
218 | 2020-12-07 08:24:24 | subsect | 1 | 69583 | 4 | 1.096 | 63488.1 |
217 | 2020-11-05 12:27:39 | subsect | 1 | 69583 | 4 | 1.280 | 54361.7 |
216 | 2020-10-26 03:09:35 | subsect | 1 | 69583 | 4 | 2.470 | 28171.3 |
215 | 2020-10-18 10:10:45 | subsect | 1 | 69583 | 4 | 1.186 | 58670.3 |
214 | 2020-10-15 16:13:56 | subsect | 1 | 69583 | 4 | 1.123 | 61961.7 |
213 | 2020-10-12 00:34:04 | subsect | 1 | 69583 | 4 | 1.250 | 55666.4 |
212 | 2020-09-16 10:22:13 | subsect | 1 | 69583 | 4 | 1.190 | 58473.1 |
211 | 2020-09-13 07:09:44 | subsect | 1 | 69583 | 4 | 1.093 | 63662.4 |
210 | 2020-06-17 04:14:17 | subsect | 1 | 69583 | 4 | 1.110 | 62687.4 |
209 | 2020-05-26 04:04:15 | subsect | 1 | 69583 | 4 | 1.216 | 57222.9 |
208 | 2020-03-30 08:57:45 | subsect | 1 | 69583 | 4 | 1.250 | 55666.4 |
207 | 2020-03-29 02:22:33 | subsect | 1 | 69583 | 4 | 1.313 | 52995.4 |
206 | 2020-03-26 23:00:49 | subsect | 1 | 69583 | 4 | 1.266 | 54962.9 |
205 | 2020-03-22 14:02:35 | subsect | 1 | 69583 | 4 | 1.390 | 50059.7 |
204 | 2020-03-21 07:49:15 | subsect | 1 | 69583 | 4 | 1.280 | 54361.7 |
203 | 2020-03-04 21:44:02 | subsect | 1 | 69583 | 4 | 1.076 | 64668.2 |
202 | 2020-03-04 09:17:02 | subsect | 3 | 134027 | 120 | 7.296 | 18369.9 |
201 | 2020-03-01 00:39:42 | subsect | 3 | 134027 | 120 | 12.690 | 10561.6 |
200 | 2020-02-24 09:31:28 | subsect | 1 | 69583 | 4 | 1.330 | 52318.0 |
199 | 2020-02-17 02:01:06 | subsect | 1 | 69583 | 4 | 1.406 | 49490.0 |
198 | 2020-02-12 01:46:21 | subsect | 1 | 69583 | 4 | 1.343 | 51811.6 |
197 | 2020-02-11 06:01:46 | subsect | 1 | 69583 | 4 | 2.500 | 27833.2 |
196 | 2020-02-06 02:23:51 | subsect | 1 | 69583 | 4 | 2.876 | 24194.4 |
195 | 2020-02-01 08:58:51 | subsect | 1 | 69583 | 4 | 2.453 | 28366.5 |
194 | 2020-02-01 04:30:08 | subsect | 1 | 69583 | 4 | 1.266 | 54962.9 |
193 | 2020-01-25 20:03:14 | subsect | 3 | 134027 | 120 | 7.346 | 18244.9 |
192 | 2020-01-25 18:18:52 | subsect | 3 | 134027 | 120 | 7.703 | 17399.3 |