History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"partake"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
247 | 2024-03-08 23:47:45 | partake | 3 | 134027 | 246 | 15.906 | 8426.2 |
246 | 2024-03-07 23:59:17 | partake | 3 | 134027 | 246 | 11.783 | 11374.6 |
245 | 2024-03-07 19:18:45 | partake | 3 | 134027 | 246 | 11.656 | 11498.5 |
244 | 2024-03-07 15:11:33 | partake | 3 | 134027 | 246 | 8.453 | 15855.6 |
243 | 2024-03-07 15:11:37 | partake | 2 | 107671 | 19 | 3.390 | 31761.4 |
242 | 2024-03-07 13:30:27 | partake | 1 | 69583 | 5 | 1.390 | 50059.7 |
241 | 2024-02-09 04:13:32 | partake | 1 | 69583 | 5 | 1.420 | 49002.1 |
240 | 2024-01-05 04:38:57 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
239 | 2023-12-28 13:33:30 | partake | 2 | 107671 | 19 | 2.940 | 36622.8 |
238 | 2023-12-17 03:30:16 | partake | 1 | 69583 | 5 | 2.860 | 24329.7 |
237 | 2023-11-30 11:08:57 | partake | 1 | 69583 | 5 | 1.236 | 56296.9 |
236 | 2023-11-29 13:12:55 | partake | 1 | 69583 | 5 | 1.250 | 55666.4 |
235 | 2023-11-24 08:31:53 | partake | 1 | 69583 | 5 | 1.190 | 58473.1 |
234 | 2023-11-18 12:35:51 | partake | 1 | 69583 | 5 | 1.126 | 61796.6 |
233 | 2023-10-24 12:39:07 | partake | 1 | 69583 | 5 | 1.220 | 57035.2 |
232 | 2023-10-12 07:07:41 | partake | 1 | 69583 | 5 | 1.080 | 64428.7 |
231 | 2023-09-29 06:46:12 | partake | 2 | 107671 | 19 | 3.580 | 30075.7 |
230 | 2023-09-28 16:22:13 | partake | 1 | 69583 | 5 | 1.126 | 61796.6 |
229 | 2023-09-23 21:25:02 | partake | 1 | 69583 | 5 | 1.296 | 53690.6 |
228 | 2023-09-15 00:49:51 | partake | 1 | 69583 | 5 | 1.190 | 58473.1 |
227 | 2023-09-02 17:08:55 | partake | 1 | 69583 | 5 | 1.093 | 63662.4 |
226 | 2023-07-10 11:39:06 | partake | 2 | 107671 | 19 | 2.890 | 37256.4 |
225 | 2023-07-03 03:56:16 | partake | 1 | 69583 | 5 | 1.203 | 57841.2 |
224 | 2023-05-06 05:29:41 | partake | 1 | 69583 | 5 | 1.300 | 53525.4 |
223 | 2023-04-12 07:31:56 | partake | 1 | 69583 | 5 | 1.190 | 58473.1 |
222 | 2023-03-27 17:23:32 | partake | 2 | 107671 | 19 | 3.530 | 30501.7 |
221 | 2023-03-03 01:14:22 | partake | 1 | 69583 | 5 | 1.063 | 65459.1 |
220 | 2023-02-05 15:39:10 | partake | 1 | 69583 | 5 | 1.080 | 64428.7 |
219 | 2023-01-08 23:43:34 | partake | 1 | 69583 | 5 | 1.096 | 63488.1 |
218 | 2022-12-25 09:14:36 | partake | 2 | 107671 | 19 | 3.153 | 34148.7 |
217 | 2022-12-04 15:22:20 | partake | 1 | 69583 | 5 | 1.090 | 63837.6 |
216 | 2022-11-15 05:23:19 | partake | 1 | 69583 | 5 | 1.233 | 56433.9 |
215 | 2022-09-10 19:34:57 | partake | 1 | 69583 | 5 | 1.203 | 57841.2 |
214 | 2022-08-25 08:46:56 | partake | 2 | 107671 | 19 | 3.326 | 32372.5 |
213 | 2022-08-04 07:17:42 | partake | 1 | 69583 | 5 | 1.123 | 61961.7 |
212 | 2022-05-12 04:41:54 | partake | 1 | 69583 | 5 | 1.656 | 42018.7 |
211 | 2022-04-04 13:44:39 | partake | 2 | 107671 | 19 | 3.470 | 31029.1 |
210 | 2022-03-29 10:29:22 | partake | 1 | 69583 | 5 | 1.563 | 44518.9 |
209 | 2022-01-24 12:32:30 | partake | 1 | 69583 | 5 | 1.250 | 55666.4 |
208 | 2022-01-06 11:05:48 | partake | 1 | 69583 | 5 | 1.376 | 50569.0 |
207 | 2021-11-06 18:08:00 | partake | 1 | 69583 | 5 | 1.393 | 49951.9 |
206 | 2021-10-11 06:11:30 | partake | 1 | 69583 | 5 | 1.170 | 59472.6 |
205 | 2021-09-28 12:12:55 | partake | 1 | 69583 | 5 | 1.313 | 52995.4 |
204 | 2021-09-26 08:55:22 | partake | 1 | 69583 | 5 | 1.093 | 63662.4 |
203 | 2021-09-19 20:03:22 | partake | 1 | 69583 | 5 | 1.250 | 55666.4 |
202 | 2021-09-18 17:24:51 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
201 | 2021-09-11 20:04:19 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
200 | 2021-08-04 02:12:19 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
199 | 2021-07-09 16:58:05 | partake | 1 | 69583 | 5 | 1.203 | 57841.2 |
198 | 2021-07-06 08:07:09 | partake | 2 | 107671 | 19 | 3.423 | 31455.2 |
197 | 2021-05-22 06:56:44 | partake | 1 | 69583 | 5 | 1.123 | 61961.7 |
196 | 2021-04-20 21:05:31 | partake | 2 | 107671 | 19 | 6.033 | 17847.0 |
195 | 2021-04-05 20:30:08 | partake | 1 | 69583 | 5 | 1.203 | 57841.2 |
194 | 2021-04-01 16:11:27 | partake | 1 | 69583 | 5 | 1.096 | 63488.1 |
193 | 2021-03-25 07:43:48 | partake | 1 | 69583 | 5 | 1.376 | 50569.0 |
192 | 2021-02-26 07:43:49 | partake | 1 | 69583 | 5 | 1.140 | 61037.7 |
191 | 2021-02-01 20:55:08 | partake | 2 | 107671 | 19 | 3.356 | 32083.1 |
190 | 2021-01-08 09:06:47 | partake | 1 | 69583 | 5 | 1.123 | 61961.7 |
189 | 2020-12-24 10:21:02 | partake | 1 | 69583 | 5 | 1.080 | 64428.7 |
188 | 2020-10-27 21:00:27 | partake | 1 | 69583 | 5 | 1.220 | 57035.2 |
187 | 2020-10-12 10:33:31 | partake | 1 | 69583 | 5 | 1.266 | 54962.9 |
186 | 2020-09-27 06:22:32 | partake | 1 | 69583 | 5 | 1.220 | 57035.2 |
185 | 2020-09-24 12:21:30 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
184 | 2020-09-14 01:31:01 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
183 | 2020-08-28 09:26:40 | partake | 1 | 69583 | 5 | 1.126 | 61796.6 |
182 | 2020-08-16 10:00:02 | partake | 1 | 69583 | 5 | 1.126 | 61796.6 |
181 | 2020-06-07 04:06:57 | partake | 1 | 69583 | 5 | 1.250 | 55666.4 |
180 | 2020-03-29 16:53:25 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
179 | 2020-03-28 01:58:40 | partake | 1 | 69583 | 5 | 1.373 | 50679.5 |
178 | 2020-03-23 05:46:11 | partake | 1 | 69583 | 5 | 1.126 | 61796.6 |
177 | 2020-03-22 07:23:52 | partake | 1 | 69583 | 5 | 1.233 | 56433.9 |
176 | 2020-03-18 18:29:53 | partake | 1 | 69583 | 5 | 1.106 | 62914.1 |
175 | 2020-03-02 18:34:19 | partake | 1 | 69583 | 5 | 1.283 | 54234.6 |
174 | 2020-02-28 20:43:55 | partake | 1 | 69583 | 5 | 4.323 | 16096.0 |
173 | 2020-02-27 02:46:58 | partake | 1 | 69583 | 5 | 2.533 | 27470.6 |
172 | 2020-02-23 03:59:47 | partake | 1 | 69583 | 5 | 1.406 | 49490.0 |
171 | 2020-02-14 14:32:02 | partake | 1 | 69583 | 5 | 1.266 | 54962.9 |
170 | 2020-02-06 06:55:26 | partake | 1 | 69583 | 5 | 1.440 | 48321.5 |
169 | 2020-02-05 06:16:27 | partake | 1 | 69583 | 5 | 1.953 | 35628.8 |
168 | 2020-02-02 21:58:19 | partake | 1 | 69583 | 5 | 4.623 | 15051.5 |
167 | 2020-01-31 11:44:08 | partake | 1 | 69583 | 5 | 1.390 | 50059.7 |
166 | 2020-01-27 01:04:54 | partake | 1 | 69583 | 5 | 1.500 | 46388.7 |
165 | 2020-01-22 21:20:53 | partake | 1 | 69583 | 5 | 1.110 | 62687.4 |
164 | 2020-01-15 09:02:56 | partake | 1 | 69583 | 5 | 1.250 | 55666.4 |
163 | 2020-01-14 22:26:05 | partake | 1 | 69583 | 5 | 1.170 | 59472.6 |
162 | 2020-01-11 13:19:26 | partake | 1 | 69583 | 5 | 1.766 | 39401.5 |
161 | 2020-01-04 18:22:42 | partake | 1 | 69583 | 5 | 1.190 | 58473.1 |
160 | 2019-12-27 04:48:50 | partake | 1 | 69583 | 5 | 2.313 | 30083.4 |
159 | 2019-12-26 20:12:33 | partake | 1 | 69583 | 5 | 1.233 | 56433.9 |
158 | 2019-12-26 09:47:47 | partake | 1 | 69583 | 5 | 1.953 | 35628.8 |
157 | 2019-12-26 02:44:58 | partake | 1 | 69583 | 5 | 1.330 | 52318.0 |
156 | 2019-11-26 20:55:47 | partake | 1 | 69583 | 5 | 1.233 | 56433.9 |
155 | 2019-08-25 03:37:28 | partake | 1 | 69583 | 5 | 1.183 | 58819.1 |
154 | 2019-08-04 12:28:57 | partake | 1 | 69583 | 5 | 1.090 | 63837.6 |
153 | 2019-05-25 11:10:05 | partake | 1 | 69583 | 5 | 1.216 | 57222.9 |
152 | 2019-04-08 03:07:04 | partake | 1 | 69583 | 5 | 1.106 | 62914.1 |
151 | 2019-04-01 12:17:54 | partake | 1 | 69583 | 5 | 1.103 | 63085.2 |
150 | 2019-02-16 04:56:03 | partake | 1 | 69583 | 5 | 1.093 | 63662.4 |
149 | 2019-02-07 21:46:42 | partake | 1 | 69583 | 5 | 1.086 | 64072.7 |
148 | 2019-02-02 16:04:21 | partake | 1 | 69583 | 5 | 1.233 | 56433.9 |