History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"psyches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
263 | 2024-04-30 15:30:49 | psyches | 1 | 69583 | 5 | 1.393 | 49951.9 |
262 | 2024-04-22 23:08:36 | psyches | 1 | 69583 | 5 | 1.280 | 54361.7 |
261 | 2024-03-30 13:10:14 | psyches | 1 | 69583 | 5 | 2.140 | 32515.4 |
260 | 2024-03-04 14:34:07 | psyches | 1 | 69583 | 5 | 1.283 | 54234.6 |
259 | 2024-02-28 07:42:25 | psyches | 2 | 107671 | 25 | 8.203 | 13125.8 |
258 | 2024-02-28 07:42:11 | psyches | 3 | 134027 | 245 | 7.563 | 17721.4 |
257 | 2024-02-28 05:41:15 | psyches | 3 | 134027 | 245 | 9.033 | 14837.5 |
256 | 2024-02-28 05:41:14 | psyches | 2 | 107671 | 25 | 3.673 | 29314.2 |
255 | 2024-02-28 04:33:01 | psyches | 1 | 69583 | 5 | 1.360 | 51164.0 |
254 | 2024-02-13 09:14:31 | psyches | 3 | 134027 | 245 | 18.843 | 7112.8 |
253 | 2024-02-09 21:43:01 | psyches | 3 | 134027 | 245 | 16.580 | 8083.7 |
252 | 2024-02-08 20:16:10 | psyches | 3 | 134027 | 245 | 14.656 | 9144.9 |
251 | 2024-01-25 20:33:59 | psyches | 2 | 107671 | 25 | 3.080 | 34958.1 |
250 | 2024-01-25 20:33:35 | psyches | 3 | 134027 | 245 | 6.610 | 20276.4 |
249 | 2024-01-21 14:58:00 | psyches | 3 | 134027 | 245 | 6.656 | 20136.3 |
248 | 2024-01-21 14:57:58 | psyches | 2 | 107671 | 25 | 3.233 | 33303.7 |
247 | 2024-01-21 11:41:30 | psyches | 2 | 107671 | 25 | 3.280 | 32826.5 |
246 | 2024-01-09 18:52:32 | psyches | 1 | 69583 | 5 | 1.126 | 61796.6 |
245 | 2024-01-05 04:03:31 | psyches | 1 | 69583 | 5 | 1.140 | 61037.7 |
244 | 2023-12-15 20:06:23 | psyches | 1 | 69583 | 5 | 1.220 | 57035.2 |
243 | 2023-11-17 21:20:53 | psyches | 1 | 69583 | 5 | 2.236 | 31119.4 |
242 | 2023-11-05 00:40:42 | psyches | 1 | 69583 | 5 | 1.063 | 65459.1 |
241 | 2023-11-03 16:13:18 | psyches | 3 | 134027 | 245 | 6.076 | 22058.4 |
240 | 2023-11-03 16:13:20 | psyches | 2 | 107671 | 25 | 3.313 | 32499.5 |
239 | 2023-11-02 09:16:59 | psyches | 2 | 107671 | 25 | 2.720 | 39584.9 |
238 | 2023-10-27 03:33:12 | psyches | 1 | 69583 | 5 | 1.063 | 65459.1 |
237 | 2023-10-21 02:17:20 | psyches | 1 | 69583 | 5 | 1.186 | 58670.3 |
236 | 2023-09-26 02:26:38 | psyches | 1 | 69583 | 5 | 1.143 | 60877.5 |
235 | 2023-09-03 10:54:47 | psyches | 1 | 69583 | 5 | 1.186 | 58670.3 |
234 | 2023-08-21 20:45:16 | psyches | 1 | 69583 | 5 | 1.126 | 61796.6 |
233 | 2023-08-09 11:56:19 | psyches | 2 | 107671 | 25 | 2.780 | 38730.6 |
232 | 2023-05-23 02:44:19 | psyches | 1 | 69583 | 5 | 1.063 | 65459.1 |
231 | 2023-05-20 00:54:37 | psyches | 1 | 69583 | 5 | 1.043 | 66714.3 |
230 | 2023-05-07 02:19:52 | psyches | 1 | 69583 | 5 | 1.186 | 58670.3 |
229 | 2023-04-24 07:56:57 | psyches | 2 | 107671 | 25 | 4.530 | 23768.4 |
228 | 2023-03-20 18:07:07 | psyches | 1 | 69583 | 5 | 1.156 | 60192.9 |
227 | 2023-03-19 13:29:56 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
226 | 2023-01-28 21:49:23 | psyches | 2 | 107671 | 25 | 2.686 | 40086.0 |
225 | 2023-01-07 09:46:10 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
224 | 2023-01-06 03:03:53 | psyches | 1 | 69583 | 5 | 1.030 | 67556.3 |
223 | 2022-11-10 23:02:32 | psyches | 2 | 107671 | 25 | 2.813 | 38276.2 |
222 | 2022-10-04 06:47:22 | psyches | 1 | 69583 | 5 | 1.063 | 65459.1 |
221 | 2022-09-08 01:42:02 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
220 | 2022-05-24 03:52:14 | psyches | 2 | 107671 | 25 | 3.096 | 34777.5 |
219 | 2022-05-17 06:18:34 | psyches | 1 | 69583 | 5 | 1.096 | 63488.1 |
218 | 2022-05-09 16:42:58 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
217 | 2022-01-25 08:00:57 | psyches | 1 | 69583 | 5 | 2.330 | 29863.9 |
216 | 2021-12-27 12:53:02 | psyches | 1 | 69583 | 5 | 1.233 | 56433.9 |
215 | 2021-11-23 00:20:53 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
214 | 2021-10-05 14:26:04 | psyches | 1 | 69583 | 5 | 2.436 | 28564.4 |
213 | 2021-07-22 13:21:58 | psyches | 3 | 134027 | 245 | 5.453 | 24578.6 |
212 | 2021-07-15 00:47:41 | psyches | 1 | 69583 | 5 | 1.063 | 65459.1 |
211 | 2021-07-06 16:58:55 | psyches | 1 | 69583 | 5 | 1.216 | 57222.9 |
210 | 2021-07-05 05:21:56 | psyches | 1 | 69583 | 5 | 1.190 | 58473.1 |
209 | 2021-07-03 03:49:28 | psyches | 1 | 69583 | 5 | 1.096 | 63488.1 |
208 | 2021-05-31 14:12:28 | psyches | 3 | 134027 | 245 | 6.156 | 21771.8 |
207 | 2021-05-29 16:25:01 | psyches | 1 | 69583 | 5 | 1.170 | 59472.6 |
206 | 2021-05-18 19:58:22 | psyches | 1 | 69583 | 5 | 1.220 | 57035.2 |
205 | 2021-05-12 07:27:10 | psyches | 3 | 134027 | 245 | 5.686 | 23571.4 |
204 | 2021-05-04 05:25:52 | psyches | 1 | 69583 | 5 | 1.173 | 59320.5 |
203 | 2021-04-04 08:37:21 | psyches | 1 | 69583 | 5 | 1.250 | 55666.4 |
202 | 2021-04-02 16:22:32 | psyches | 1 | 69583 | 5 | 1.313 | 52995.4 |
201 | 2021-04-02 08:00:12 | psyches | 1 | 69583 | 5 | 2.563 | 27149.0 |
200 | 2021-02-12 14:42:58 | psyches | 1 | 69583 | 5 | 1.140 | 61037.7 |
199 | 2021-01-25 10:59:04 | psyches | 3 | 134027 | 245 | 6.376 | 21020.5 |
198 | 2021-01-17 09:26:41 | psyches | 1 | 69583 | 5 | 1.080 | 64428.7 |
197 | 2020-12-28 20:44:27 | psyches | 1 | 69583 | 5 | 1.076 | 64668.2 |
196 | 2020-12-27 09:36:10 | psyches | 3 | 134027 | 245 | 6.343 | 21129.9 |
195 | 2020-11-22 18:59:41 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
194 | 2020-11-20 03:27:00 | psyches | 3 | 134027 | 245 | 5.483 | 24444.1 |
193 | 2020-11-02 15:19:30 | psyches | 2 | 107671 | 25 | 3.690 | 29179.1 |
192 | 2020-10-28 17:35:25 | psyches | 1 | 69583 | 5 | 1.123 | 61961.7 |
191 | 2020-10-24 15:45:25 | psyches | 1 | 69583 | 5 | 1.170 | 59472.6 |
190 | 2020-09-25 10:14:42 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
189 | 2020-06-07 20:10:39 | psyches | 1 | 69583 | 5 | 1.266 | 54962.9 |
188 | 2020-03-30 02:29:18 | psyches | 1 | 69583 | 5 | 1.046 | 66522.9 |
187 | 2020-03-22 07:25:12 | psyches | 1 | 69583 | 5 | 1.313 | 52995.4 |
186 | 2020-03-03 10:39:34 | psyches | 1 | 69583 | 5 | 1.216 | 57222.9 |
185 | 2020-03-01 02:38:58 | psyches | 1 | 69583 | 5 | 2.033 | 34226.8 |
184 | 2020-02-29 23:58:41 | psyches | 1 | 69583 | 5 | 1.343 | 51811.6 |
183 | 2020-02-27 18:43:55 | psyches | 3 | 134027 | 245 | 6.800 | 19709.9 |
182 | 2020-02-27 17:45:19 | psyches | 3 | 134027 | 245 | 7.766 | 17258.2 |
181 | 2020-02-22 12:49:38 | psyches | 1 | 69583 | 5 | 2.503 | 27799.8 |
180 | 2020-02-19 03:43:06 | psyches | 1 | 69583 | 5 | 2.656 | 26198.4 |
179 | 2020-02-16 18:51:07 | psyches | 3 | 134027 | 245 | 9.283 | 14437.9 |
178 | 2020-02-15 08:43:00 | psyches | 3 | 134027 | 245 | 16.860 | 7949.4 |
177 | 2020-02-15 05:44:10 | psyches | 3 | 134027 | 245 | 12.846 | 10433.4 |
176 | 2020-02-15 00:16:26 | psyches | 3 | 134027 | 245 | 7.873 | 17023.6 |
175 | 2020-02-08 21:03:00 | psyches | 1 | 69583 | 5 | 2.890 | 24077.2 |
174 | 2020-02-03 16:31:55 | psyches | 1 | 69583 | 5 | 1.063 | 65459.1 |
173 | 2020-02-02 19:51:01 | psyches | 1 | 69583 | 5 | 2.203 | 31585.6 |
172 | 2020-01-29 06:45:34 | psyches | 1 | 69583 | 5 | 2.813 | 24736.2 |
171 | 2020-01-22 00:34:49 | psyches | 1 | 69583 | 5 | 1.296 | 53690.6 |
170 | 2020-01-20 10:28:54 | psyches | 1 | 69583 | 5 | 2.656 | 26198.4 |
169 | 2020-01-15 19:16:13 | psyches | 2 | 107671 | 25 | 2.970 | 36252.9 |
168 | 2020-01-15 12:38:43 | psyches | 3 | 134027 | 245 | 7.953 | 16852.4 |
167 | 2020-01-15 10:42:55 | psyches | 3 | 134027 | 245 | 6.453 | 20769.7 |
166 | 2020-01-15 06:26:36 | psyches | 3 | 134027 | 245 | 17.406 | 7700.0 |
165 | 2020-01-15 06:26:34 | psyches | 2 | 107671 | 25 | 10.966 | 9818.6 |
164 | 2020-01-15 00:17:59 | psyches | 1 | 69583 | 5 | 2.263 | 30748.1 |