History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"psych"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-03-18 20:54:23 | psych | 2 | 53800 | 26 | 2.436 | 22085.4 |
280 | 2024-03-10 05:24:57 | psych | 1 | 28756 | 4 | 1.296 | 22188.3 |
279 | 2024-03-07 23:37:25 | psych | 3 | 83667 | 296 | 5.923 | 14125.8 |
278 | 2024-03-07 23:37:17 | psych | 2 | 53800 | 26 | 3.110 | 17299.0 |
277 | 2024-03-07 23:37:05 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
276 | 2024-03-01 12:21:41 | psych | 1 | 28756 | 4 | 0.423 | 67981.1 |
275 | 2024-02-28 07:42:30 | psych | 1 | 28756 | 4 | 0.610 | 47141.0 |
274 | 2024-02-04 00:34:31 | psych | 1 | 28756 | 4 | 0.470 | 61183.0 |
273 | 2024-01-29 14:28:55 | psych | 1 | 28756 | 4 | 0.500 | 57512.0 |
272 | 2024-01-29 07:00:29 | psych | 1 | 28756 | 4 | 0.856 | 33593.5 |
271 | 2024-01-16 09:05:46 | psych | 3 | 83667 | 296 | 3.233 | 25879.1 |
270 | 2024-01-11 07:32:02 | psych | 2 | 53800 | 26 | 1.606 | 33499.4 |
269 | 2024-01-08 11:20:10 | psych | 3 | 83667 | 296 | 3.436 | 24350.1 |
268 | 2024-01-03 03:27:32 | psych | 1 | 28756 | 4 | 0.513 | 56054.6 |
267 | 2023-12-11 14:15:33 | psych | 3 | 83667 | 296 | 3.173 | 26368.4 |
266 | 2023-12-04 11:12:04 | psych | 1 | 28756 | 4 | 0.470 | 61183.0 |
265 | 2023-12-04 11:12:03 | psych | 1 | 28756 | 4 | 0.466 | 61708.2 |
264 | 2023-12-01 03:46:59 | psych | 2 | 53800 | 26 | 1.343 | 40059.6 |
263 | 2023-11-29 23:48:51 | psych | 1 | 28756 | 4 | 0.466 | 61708.2 |
262 | 2023-11-23 02:38:04 | psych | 1 | 28756 | 4 | 0.483 | 59536.2 |
261 | 2023-11-16 03:40:28 | psych | 2 | 53800 | 26 | 1.546 | 34799.5 |
260 | 2023-11-16 03:40:25 | psych | 3 | 83667 | 296 | 3.546 | 23594.8 |
259 | 2023-11-05 00:35:10 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
258 | 2023-11-03 15:02:06 | psych | 1 | 28756 | 4 | 0.486 | 59168.7 |
257 | 2023-10-24 01:51:24 | psych | 1 | 28756 | 4 | 0.530 | 54256.6 |
256 | 2023-10-21 13:32:36 | psych | 1 | 28756 | 4 | 0.466 | 61708.2 |
255 | 2023-10-07 10:44:36 | psych | 1 | 28756 | 4 | 0.673 | 42728.1 |
254 | 2023-09-26 21:50:41 | psych | 3 | 83667 | 296 | 3.220 | 25983.5 |
253 | 2023-09-14 02:53:21 | psych | 1 | 28756 | 4 | 0.483 | 59536.2 |
252 | 2023-09-10 21:15:21 | psych | 3 | 83667 | 296 | 3.143 | 26620.1 |
251 | 2023-08-30 15:39:53 | psych | 2 | 53800 | 26 | 1.500 | 35866.7 |
250 | 2023-08-20 00:28:38 | psych | 1 | 28756 | 4 | 0.423 | 67981.1 |
249 | 2023-08-12 17:57:29 | psych | 1 | 28756 | 4 | 0.440 | 65354.5 |
248 | 2023-06-01 23:29:47 | psych | 3 | 83667 | 296 | 3.173 | 26368.4 |
247 | 2023-05-21 20:45:43 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
246 | 2023-05-20 10:51:57 | psych | 2 | 53800 | 26 | 1.530 | 35163.4 |
245 | 2023-05-07 03:00:43 | psych | 1 | 28756 | 4 | 0.420 | 68466.7 |
244 | 2023-03-22 19:28:32 | psych | 1 | 28756 | 4 | 0.876 | 32826.5 |
243 | 2023-03-15 00:26:26 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
242 | 2023-03-08 02:41:44 | psych | 3 | 83667 | 296 | 3.576 | 23396.8 |
241 | 2023-03-01 06:38:56 | psych | 2 | 53800 | 26 | 1.296 | 41512.3 |
240 | 2023-01-03 19:33:57 | psych | 1 | 28756 | 4 | 1.016 | 28303.1 |
239 | 2022-12-14 06:35:05 | psych | 3 | 83667 | 296 | 3.110 | 26902.6 |
238 | 2022-12-10 21:55:21 | psych | 2 | 53800 | 26 | 1.313 | 40974.9 |
237 | 2022-12-09 10:57:13 | psych | 3 | 83667 | 296 | 3.483 | 24021.5 |
236 | 2022-11-25 08:46:01 | psych | 1 | 28756 | 4 | 0.466 | 61708.2 |
235 | 2022-10-23 10:00:40 | psych | 3 | 83667 | 296 | 3.110 | 26902.6 |
234 | 2022-10-21 21:35:58 | psych | 3 | 83667 | 296 | 3.593 | 23286.1 |
233 | 2022-09-28 23:42:26 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
232 | 2022-09-20 15:58:48 | psych | 3 | 83667 | 296 | 3.106 | 26937.2 |
231 | 2022-09-18 06:55:34 | psych | 3 | 83667 | 296 | 3.640 | 22985.4 |
230 | 2022-09-01 09:27:20 | psych | 1 | 28756 | 4 | 0.470 | 61183.0 |
229 | 2022-08-03 13:28:30 | psych | 3 | 83667 | 296 | 4.563 | 18336.0 |
228 | 2022-07-30 11:44:31 | psych | 2 | 53800 | 26 | 1.330 | 40451.1 |
227 | 2022-05-17 23:05:39 | psych | 1 | 28756 | 4 | 0.466 | 61708.2 |
226 | 2021-12-09 08:03:59 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
225 | 2021-07-25 10:27:16 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
224 | 2021-05-17 01:19:48 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
223 | 2021-05-15 16:16:29 | psych | 1 | 28756 | 4 | 0.440 | 65354.5 |
222 | 2021-02-22 16:45:23 | psych | 1 | 28756 | 4 | 0.486 | 59168.7 |
221 | 2021-01-28 09:17:33 | psych | 1 | 28756 | 4 | 0.440 | 65354.5 |
220 | 2020-12-30 16:42:25 | psych | 1 | 28756 | 4 | 0.440 | 65354.5 |
219 | 2020-10-06 13:13:58 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
218 | 2020-08-28 13:44:30 | psych | 1 | 28756 | 4 | 0.580 | 49579.3 |
217 | 2020-08-18 06:00:23 | psych | 1 | 28756 | 4 | 0.453 | 63479.0 |
216 | 2020-07-30 20:35:10 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
215 | 2020-03-28 08:41:42 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
214 | 2020-03-27 21:07:48 | psych | 1 | 28756 | 4 | 0.500 | 57512.0 |
213 | 2020-03-24 08:08:35 | psych | 1 | 28756 | 4 | 0.733 | 39230.6 |
212 | 2020-03-23 21:58:37 | psych | 1 | 28756 | 4 | 0.470 | 61183.0 |
211 | 2020-03-23 02:03:53 | psych | 1 | 28756 | 4 | 0.513 | 56054.6 |
210 | 2020-03-18 18:58:20 | psych | 1 | 28756 | 4 | 0.440 | 65354.5 |
209 | 2020-03-13 08:05:03 | psych | 1 | 28756 | 4 | 0.440 | 65354.5 |
208 | 2020-02-17 19:50:12 | psych | 1 | 28756 | 4 | 1.033 | 27837.4 |
207 | 2020-02-15 03:14:03 | psych | 1 | 28756 | 4 | 0.546 | 52666.7 |
206 | 2020-02-11 23:45:22 | psych | 1 | 28756 | 4 | 0.500 | 57512.0 |
205 | 2020-02-06 07:58:47 | psych | 1 | 28756 | 4 | 0.530 | 54256.6 |
204 | 2020-02-05 13:58:30 | psych | 1 | 28756 | 4 | 0.843 | 34111.5 |
203 | 2020-01-30 13:15:09 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
202 | 2020-01-20 14:34:08 | psych | 1 | 28756 | 4 | 0.640 | 44931.3 |
201 | 2020-01-19 04:34:23 | psych | 1 | 28756 | 4 | 1.360 | 21144.1 |
200 | 2020-01-17 01:26:42 | psych | 1 | 28756 | 4 | 0.530 | 54256.6 |
199 | 2020-01-11 23:58:39 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
198 | 2020-01-07 01:48:32 | psych | 1 | 28756 | 4 | 0.533 | 53951.2 |
197 | 2019-12-28 23:26:23 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
196 | 2019-12-27 04:37:00 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
195 | 2019-12-26 23:15:55 | psych | 1 | 28756 | 4 | 0.906 | 31739.5 |
194 | 2019-12-25 04:21:26 | psych | 1 | 28756 | 4 | 0.516 | 55728.7 |
193 | 2019-12-15 12:43:27 | psych | 1 | 28756 | 4 | 0.483 | 59536.2 |
192 | 2019-12-01 17:57:51 | psych | 1 | 28756 | 4 | 0.436 | 65954.1 |
191 | 2019-11-22 16:25:15 | psych | 1 | 28756 | 4 | 0.483 | 59536.2 |
190 | 2019-08-30 07:32:40 | psych | 1 | 28756 | 4 | 0.403 | 71354.8 |
189 | 2019-08-26 14:57:07 | psych | 1 | 28756 | 4 | 0.433 | 66411.1 |
188 | 2019-06-04 10:58:32 | psych | 1 | 28756 | 4 | 0.443 | 64912.0 |
187 | 2019-05-21 07:35:50 | psych | 1 | 28756 | 4 | 0.536 | 53649.3 |
186 | 2019-02-28 07:21:39 | psych | 1 | 28756 | 4 | 0.416 | 69125.0 |
185 | 2019-02-26 16:48:44 | psych | 1 | 28756 | 4 | 0.463 | 62108.0 |
184 | 2019-02-24 20:03:03 | psych | 1 | 28756 | 4 | 0.426 | 67502.3 |
183 | 2019-02-23 01:51:42 | psych | 1 | 28756 | 4 | 0.520 | 55300.0 |
182 | 2019-02-19 17:36:02 | psych | 1 | 28756 | 4 | 0.460 | 62513.0 |