History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"playful"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
246 | 2024-05-01 10:47:52 | playful | 1 | 69583 | 1 | 1.360 | 51164.0 |
245 | 2024-03-31 14:25:21 | playful | 1 | 69583 | 1 | 1.703 | 40859.1 |
244 | 2024-03-29 03:15:12 | playful | 1 | 69583 | 1 | 3.016 | 23071.3 |
243 | 2024-03-12 16:33:05 | playful | 1 | 69583 | 1 | 1.216 | 57222.9 |
242 | 2024-03-11 00:11:12 | playful | 4 | 151207 | 600 | 24.110 | 6271.5 |
241 | 2024-03-06 06:18:47 | playful | 1 | 69583 | 1 | 2.673 | 26031.8 |
240 | 2024-03-01 09:29:17 | playful | 4 | 151207 | 600 | 16.673 | 9069.0 |
239 | 2024-02-27 18:46:00 | playful | 1 | 69583 | 1 | 2.796 | 24886.6 |
238 | 2024-02-26 02:13:42 | playful | 4 | 151207 | 600 | 25.970 | 5822.4 |
237 | 2024-02-23 10:49:31 | playful | 4 | 151207 | 600 | 13.546 | 11162.5 |
236 | 2024-02-22 15:57:24 | playful | 4 | 151207 | 600 | 26.733 | 5656.2 |
235 | 2024-02-14 08:00:47 | playful | 4 | 151207 | 600 | 11.343 | 13330.4 |
234 | 2024-02-12 22:55:07 | playful | 1 | 69583 | 1 | 1.220 | 57035.2 |
233 | 2024-02-08 15:06:01 | playful | 4 | 151207 | 600 | 41.270 | 3663.8 |
232 | 2024-01-22 21:02:00 | playful | 3 | 134027 | 78 | 8.826 | 15185.5 |
231 | 2024-01-22 21:01:48 | playful | 2 | 107671 | 9 | 5.626 | 19138.1 |
230 | 2024-01-22 19:38:59 | playful | 4 | 151207 | 600 | 19.000 | 7958.3 |
229 | 2024-01-22 11:10:33 | playful | 4 | 151207 | 600 | 13.813 | 10946.7 |
228 | 2024-01-21 02:12:44 | playful | 4 | 151207 | 600 | 10.190 | 14838.8 |
227 | 2024-01-08 22:42:29 | playful | 2 | 107671 | 9 | 3.580 | 30075.7 |
226 | 2023-12-14 20:40:43 | playful | 1 | 69583 | 1 | 1.313 | 52995.4 |
225 | 2023-11-25 14:47:52 | playful | 1 | 69583 | 1 | 1.250 | 55666.4 |
224 | 2023-11-19 04:16:05 | playful | 4 | 151207 | 600 | 10.580 | 14291.8 |
223 | 2023-10-27 00:19:42 | playful | 1 | 69583 | 1 | 1.563 | 44518.9 |
222 | 2023-10-25 07:04:02 | playful | 1 | 69583 | 1 | 1.296 | 53690.6 |
221 | 2023-10-17 11:47:02 | playful | 2 | 107671 | 9 | 3.873 | 27800.4 |
220 | 2023-10-16 16:25:13 | playful | 1 | 69583 | 1 | 1.093 | 63662.4 |
219 | 2023-10-01 18:09:55 | playful | 1 | 69583 | 1 | 1.143 | 60877.5 |
218 | 2023-09-28 09:22:09 | playful | 1 | 69583 | 1 | 1.173 | 59320.5 |
217 | 2023-09-24 08:57:01 | playful | 1 | 69583 | 1 | 2.173 | 32021.6 |
216 | 2023-08-22 12:48:40 | playful | 1 | 69583 | 1 | 1.063 | 65459.1 |
215 | 2023-08-20 23:56:26 | playful | 4 | 151207 | 600 | 11.750 | 12868.7 |
214 | 2023-07-29 21:58:01 | playful | 1 | 69583 | 1 | 1.076 | 64668.2 |
213 | 2023-07-29 01:35:35 | playful | 2 | 107671 | 9 | 2.796 | 38508.9 |
212 | 2023-07-13 01:10:38 | playful | 1 | 69583 | 1 | 1.173 | 59320.5 |
211 | 2023-07-08 14:52:32 | playful | 1 | 69583 | 1 | 1.076 | 64668.2 |
210 | 2023-05-15 01:29:57 | playful | 1 | 69583 | 1 | 1.063 | 65459.1 |
209 | 2023-05-05 20:51:14 | playful | 4 | 151207 | 600 | 9.516 | 15889.8 |
208 | 2023-04-25 00:51:32 | playful | 1 | 69583 | 1 | 1.050 | 66269.5 |
207 | 2023-04-08 07:10:47 | playful | 2 | 107671 | 9 | 3.296 | 32667.2 |
206 | 2023-02-15 00:18:08 | playful | 1 | 69583 | 1 | 1.156 | 60192.9 |
205 | 2023-02-13 21:33:52 | playful | 4 | 151207 | 600 | 9.470 | 15966.9 |
204 | 2023-01-14 10:50:15 | playful | 1 | 69583 | 1 | 1.046 | 66522.9 |
203 | 2023-01-12 10:58:47 | playful | 2 | 107671 | 9 | 2.796 | 38508.9 |
202 | 2022-12-13 01:44:06 | playful | 1 | 69583 | 1 | 1.080 | 64428.7 |
201 | 2022-11-25 12:35:15 | playful | 1 | 69583 | 1 | 1.156 | 60192.9 |
200 | 2022-11-25 10:14:50 | playful | 4 | 151207 | 600 | 10.970 | 13783.7 |
199 | 2022-10-14 19:38:26 | playful | 2 | 107671 | 9 | 2.796 | 38508.9 |
198 | 2022-09-05 08:39:54 | playful | 1 | 69583 | 1 | 1.060 | 65644.3 |
197 | 2022-08-17 01:00:31 | playful | 1 | 69583 | 1 | 1.080 | 64428.7 |
196 | 2022-08-14 14:44:31 | playful | 1 | 69583 | 1 | 1.060 | 65644.3 |
195 | 2022-05-16 11:48:58 | playful | 2 | 107671 | 9 | 3.423 | 31455.2 |
194 | 2022-04-25 15:16:14 | playful | 4 | 151207 | 600 | 10.420 | 14511.2 |
193 | 2022-04-11 20:45:42 | playful | 1 | 69583 | 1 | 1.093 | 63662.4 |
192 | 2022-04-01 08:54:51 | playful | 1 | 69583 | 1 | 1.046 | 66522.9 |
191 | 2022-01-24 11:12:22 | playful | 1 | 69583 | 1 | 1.186 | 58670.3 |
190 | 2022-01-22 07:30:07 | playful | 1 | 69583 | 1 | 1.063 | 65459.1 |
189 | 2022-01-18 01:43:14 | playful | 2 | 107671 | 9 | 3.030 | 35535.0 |
188 | 2021-12-01 15:53:24 | playful | 1 | 69583 | 1 | 1.126 | 61796.6 |
187 | 2021-10-24 07:03:23 | playful | 2 | 107671 | 9 | 2.876 | 37437.8 |
186 | 2021-10-22 06:29:32 | playful | 2 | 107671 | 9 | 2.860 | 37647.2 |
185 | 2021-10-09 19:01:42 | playful | 1 | 69583 | 1 | 1.170 | 59472.6 |
184 | 2021-09-05 18:10:19 | playful | 2 | 107671 | 9 | 3.046 | 35348.3 |
183 | 2021-09-05 15:13:26 | playful | 1 | 69583 | 1 | 1.186 | 58670.3 |
182 | 2021-08-16 20:14:51 | playful | 1 | 69583 | 1 | 1.063 | 65459.1 |
181 | 2021-08-08 12:42:43 | playful | 1 | 69583 | 1 | 1.220 | 57035.2 |
180 | 2021-04-19 18:37:23 | playful | 1 | 69583 | 1 | 1.233 | 56433.9 |
179 | 2021-04-16 12:23:02 | playful | 1 | 69583 | 1 | 1.233 | 56433.9 |
178 | 2021-01-29 08:40:25 | playful | 1 | 69583 | 1 | 1.110 | 62687.4 |
177 | 2020-12-22 12:45:34 | playful | 1 | 69583 | 1 | 1.063 | 65459.1 |
176 | 2020-11-03 18:28:49 | playful | 1 | 69583 | 1 | 1.250 | 55666.4 |
175 | 2020-10-31 08:07:10 | playful | 1 | 69583 | 1 | 1.106 | 62914.1 |
174 | 2020-10-17 01:29:10 | playful | 1 | 69583 | 1 | 1.173 | 59320.5 |
173 | 2020-09-18 12:01:32 | playful | 1 | 69583 | 1 | 1.096 | 63488.1 |
172 | 2020-05-30 12:40:42 | playful | 1 | 69583 | 1 | 1.096 | 63488.1 |
171 | 2020-03-24 03:57:56 | playful | 1 | 69583 | 1 | 1.466 | 47464.5 |
170 | 2020-03-21 18:19:49 | playful | 1 | 69583 | 1 | 1.280 | 54361.7 |
169 | 2020-03-06 22:10:14 | playful | 1 | 69583 | 1 | 1.173 | 59320.5 |
168 | 2020-02-28 14:53:11 | playful | 4 | 151207 | 600 | 23.440 | 6450.8 |
167 | 2020-02-28 12:46:42 | playful | 4 | 151207 | 600 | 13.706 | 11032.2 |
166 | 2020-02-27 23:46:57 | playful | 4 | 151207 | 600 | 29.096 | 5196.8 |
165 | 2020-02-27 22:31:08 | playful | 4 | 151207 | 600 | 14.096 | 10726.9 |
164 | 2020-02-27 20:55:58 | playful | 4 | 151207 | 600 | 11.330 | 13345.7 |
163 | 2020-02-27 16:52:34 | playful | 4 | 151207 | 600 | 20.766 | 7281.5 |
162 | 2020-02-27 07:25:22 | playful | 1 | 69583 | 1 | 2.563 | 27149.0 |
161 | 2020-02-25 02:31:41 | playful | 1 | 69583 | 1 | 2.906 | 23944.6 |
160 | 2020-02-25 02:27:42 | playful | 1 | 69583 | 1 | 1.373 | 50679.5 |
159 | 2020-02-23 13:02:03 | playful | 1 | 69583 | 1 | 3.843 | 18106.4 |
158 | 2020-02-21 05:07:27 | playful | 1 | 69583 | 1 | 1.096 | 63488.1 |
157 | 2020-02-19 03:44:00 | playful | 1 | 69583 | 1 | 1.266 | 54962.9 |
156 | 2020-02-02 10:48:00 | playful | 1 | 69583 | 1 | 1.453 | 47889.2 |
155 | 2020-02-02 07:37:12 | playful | 1 | 69583 | 1 | 1.250 | 55666.4 |
154 | 2020-01-29 03:22:11 | playful | 1 | 69583 | 1 | 4.093 | 17000.5 |
153 | 2020-01-27 01:19:58 | playful | 1 | 69583 | 1 | 1.253 | 55533.1 |
152 | 2020-01-24 08:19:22 | playful | 1 | 69583 | 1 | 2.766 | 25156.5 |
151 | 2020-01-23 00:27:25 | playful | 1 | 69583 | 1 | 4.216 | 16504.5 |
150 | 2020-01-17 08:15:56 | playful | 4 | 151207 | 600 | 12.763 | 11847.3 |
149 | 2020-01-17 08:02:33 | playful | 4 | 151207 | 600 | 23.203 | 6516.7 |
148 | 2020-01-17 03:16:20 | playful | 3 | 134027 | 78 | 7.576 | 17691.0 |
147 | 2020-01-17 03:16:13 | playful | 4 | 151207 | 600 | 12.876 | 11743.3 |