History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sonatas"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-03-18 22:38:59 | sonatas | 1 | 69583 | 2 | 2.843 | 24475.2 |
280 | 2024-03-02 00:44:27 | sonatas | 3 | 134027 | 296 | 7.046 | 19021.7 |
279 | 2024-02-29 02:39:28 | sonatas | 2 | 107671 | 16 | 3.610 | 29825.8 |
278 | 2024-02-29 02:39:11 | sonatas | 3 | 134027 | 296 | 7.530 | 17799.1 |
277 | 2024-02-28 08:56:34 | sonatas | 2 | 107671 | 16 | 4.046 | 26611.7 |
276 | 2024-02-26 18:08:31 | sonatas | 2 | 107671 | 16 | 7.080 | 15207.8 |
275 | 2024-02-26 18:08:08 | sonatas | 3 | 134027 | 296 | 8.000 | 16753.4 |
274 | 2024-02-25 10:26:30 | sonatas | 3 | 134027 | 296 | 8.483 | 15799.5 |
273 | 2024-02-17 17:05:50 | sonatas | 3 | 134027 | 296 | 7.546 | 17761.3 |
272 | 2024-02-17 17:05:51 | sonatas | 2 | 107671 | 16 | 3.750 | 28712.3 |
271 | 2024-02-17 12:24:21 | sonatas | 1 | 69583 | 2 | 1.376 | 50569.0 |
270 | 2024-02-09 12:47:48 | sonatas | 1 | 69583 | 2 | 1.220 | 57035.2 |
269 | 2024-01-12 20:02:28 | sonatas | 1 | 69583 | 2 | 1.110 | 62687.4 |
268 | 2024-01-12 05:48:52 | sonatas | 1 | 69583 | 2 | 1.236 | 56296.9 |
267 | 2023-11-23 03:07:42 | sonatas | 3 | 134027 | 296 | 6.390 | 20974.5 |
266 | 2023-11-23 03:07:40 | sonatas | 2 | 107671 | 16 | 3.123 | 34476.8 |
265 | 2023-11-22 15:55:15 | sonatas | 1 | 69583 | 2 | 1.203 | 57841.2 |
264 | 2023-11-06 07:30:30 | sonatas | 1 | 69583 | 2 | 1.143 | 60877.5 |
263 | 2023-10-22 11:31:45 | sonatas | 1 | 69583 | 2 | 1.080 | 64428.7 |
262 | 2023-10-17 22:27:27 | sonatas | 1 | 69583 | 2 | 1.110 | 62687.4 |
261 | 2023-10-14 03:15:29 | sonatas | 1 | 69583 | 2 | 1.093 | 63662.4 |
260 | 2023-09-17 20:43:27 | sonatas | 1 | 69583 | 2 | 1.093 | 63662.4 |
259 | 2023-08-28 10:00:00 | sonatas | 1 | 69583 | 2 | 1.203 | 57841.2 |
258 | 2023-08-25 00:53:12 | sonatas | 1 | 69583 | 2 | 1.093 | 63662.4 |
257 | 2023-06-01 23:05:13 | sonatas | 1 | 69583 | 2 | 1.076 | 64668.2 |
256 | 2023-05-15 00:21:50 | sonatas | 1 | 69583 | 2 | 1.110 | 62687.4 |
255 | 2023-03-26 06:32:46 | sonatas | 1 | 69583 | 2 | 1.093 | 63662.4 |
254 | 2023-01-14 08:43:35 | sonatas | 1 | 69583 | 2 | 1.126 | 61796.6 |
253 | 2023-01-09 17:42:48 | sonatas | 1 | 69583 | 2 | 1.080 | 64428.7 |
252 | 2022-10-11 21:59:39 | sonatas | 1 | 69583 | 2 | 1.170 | 59472.6 |
251 | 2022-09-02 00:44:09 | sonatas | 1 | 69583 | 2 | 1.203 | 57841.2 |
250 | 2022-07-19 14:47:52 | sonatas | 1 | 69583 | 2 | 1.076 | 64668.2 |
249 | 2022-07-18 16:43:16 | sonatas | 1 | 69583 | 2 | 1.123 | 61961.7 |
248 | 2022-06-01 14:04:10 | sonatas | 1 | 69583 | 2 | 1.093 | 63662.4 |
247 | 2022-04-11 19:08:39 | sonatas | 1 | 69583 | 2 | 1.170 | 59472.6 |
246 | 2022-02-13 15:28:47 | sonatas | 1 | 69583 | 2 | 1.233 | 56433.9 |
245 | 2021-12-08 21:20:50 | sonatas | 3 | 134027 | 296 | 13.393 | 10007.2 |
244 | 2021-12-08 05:51:04 | sonatas | 1 | 69583 | 2 | 1.123 | 61961.7 |
243 | 2021-12-07 06:19:53 | sonatas | 1 | 69583 | 2 | 2.486 | 27989.9 |
242 | 2021-12-05 04:02:50 | sonatas | 1 | 69583 | 2 | 1.170 | 59472.6 |
241 | 2021-10-27 08:21:16 | sonatas | 3 | 134027 | 296 | 5.970 | 22450.1 |
240 | 2021-10-14 14:12:12 | sonatas | 1 | 69583 | 2 | 1.266 | 54962.9 |
239 | 2021-10-06 21:34:38 | sonatas | 3 | 134027 | 296 | 6.486 | 20664.0 |
238 | 2021-09-27 12:03:48 | sonatas | 1 | 69583 | 2 | 1.126 | 61796.6 |
237 | 2021-09-27 00:47:29 | sonatas | 1 | 69583 | 2 | 1.220 | 57035.2 |
236 | 2021-09-22 04:54:09 | sonatas | 1 | 69583 | 2 | 1.233 | 56433.9 |
235 | 2021-09-01 22:03:57 | sonatas | 1 | 69583 | 2 | 1.110 | 62687.4 |
234 | 2021-08-30 16:32:38 | sonatas | 1 | 69583 | 2 | 1.420 | 49002.1 |
233 | 2021-08-18 12:23:57 | sonatas | 1 | 69583 | 2 | 1.280 | 54361.7 |
232 | 2021-08-02 11:24:42 | sonatas | 1 | 69583 | 2 | 1.203 | 57841.2 |
231 | 2021-07-04 13:40:21 | sonatas | 2 | 107671 | 16 | 3.483 | 30913.3 |
230 | 2021-06-10 08:48:12 | sonatas | 1 | 69583 | 2 | 1.093 | 63662.4 |
229 | 2021-05-07 16:04:05 | sonatas | 1 | 69583 | 2 | 1.296 | 53690.6 |
228 | 2021-04-18 09:44:47 | sonatas | 2 | 107671 | 16 | 3.000 | 35890.3 |
227 | 2021-03-19 18:17:40 | sonatas | 1 | 69583 | 2 | 1.126 | 61796.6 |
226 | 2021-02-22 12:27:15 | sonatas | 1 | 69583 | 2 | 1.203 | 57841.2 |
225 | 2021-01-30 21:25:15 | sonatas | 2 | 107671 | 16 | 2.966 | 36301.8 |
224 | 2021-01-29 10:46:57 | sonatas | 1 | 69583 | 2 | 1.283 | 54234.6 |
223 | 2021-01-10 18:29:00 | sonatas | 1 | 69583 | 2 | 1.233 | 56433.9 |
222 | 2021-01-02 20:45:49 | sonatas | 2 | 107671 | 16 | 2.940 | 36622.8 |
221 | 2021-01-01 01:08:46 | sonatas | 1 | 69583 | 2 | 1.123 | 61961.7 |
220 | 2020-12-05 23:09:34 | sonatas | 2 | 107671 | 16 | 2.936 | 36672.7 |
219 | 2020-11-17 18:33:11 | sonatas | 1 | 69583 | 2 | 1.123 | 61961.7 |
218 | 2020-10-29 05:48:34 | sonatas | 1 | 69583 | 2 | 1.186 | 58670.3 |
217 | 2020-10-27 23:18:12 | sonatas | 1 | 69583 | 2 | 1.390 | 50059.7 |
216 | 2020-10-20 17:48:37 | sonatas | 1 | 69583 | 2 | 1.186 | 58670.3 |
215 | 2020-10-14 21:28:57 | sonatas | 1 | 69583 | 2 | 1.216 | 57222.9 |
214 | 2020-09-28 23:06:04 | sonatas | 2 | 107671 | 16 | 3.170 | 33965.6 |
213 | 2020-09-22 06:02:45 | sonatas | 1 | 69583 | 2 | 1.110 | 62687.4 |
212 | 2020-09-02 18:03:26 | sonatas | 2 | 107671 | 16 | 3.373 | 31921.4 |
211 | 2020-07-22 07:35:36 | sonatas | 2 | 107671 | 16 | 3.096 | 34777.5 |
210 | 2020-05-30 11:05:26 | sonatas | 1 | 69583 | 2 | 1.140 | 61037.7 |
209 | 2020-03-28 20:26:01 | sonatas | 1 | 69583 | 2 | 1.173 | 59320.5 |
208 | 2020-03-24 03:10:14 | sonatas | 1 | 69583 | 2 | 1.326 | 52475.9 |
207 | 2020-03-23 03:41:23 | sonatas | 1 | 69583 | 2 | 2.670 | 26061.0 |
206 | 2020-03-20 17:30:01 | sonatas | 1 | 69583 | 2 | 1.313 | 52995.4 |
205 | 2020-03-06 01:03:52 | sonatas | 3 | 134027 | 296 | 7.546 | 17761.3 |
204 | 2020-02-27 04:00:15 | sonatas | 1 | 69583 | 2 | 1.326 | 52475.9 |
203 | 2020-02-27 01:34:50 | sonatas | 1 | 69583 | 2 | 2.826 | 24622.4 |
202 | 2020-02-25 11:57:21 | sonatas | 1 | 69583 | 2 | 2.596 | 26803.9 |
201 | 2020-02-24 12:47:32 | sonatas | 3 | 134027 | 296 | 9.046 | 14816.2 |
200 | 2020-02-21 17:14:46 | sonatas | 3 | 134027 | 296 | 6.170 | 21722.4 |
199 | 2020-02-18 01:04:27 | sonatas | 3 | 134027 | 296 | 24.736 | 5418.3 |
198 | 2020-02-17 01:10:50 | sonatas | 1 | 69583 | 2 | 4.063 | 17126.0 |
197 | 2020-02-13 05:12:47 | sonatas | 3 | 134027 | 296 | 12.300 | 10896.5 |
196 | 2020-02-11 17:29:32 | sonatas | 3 | 134027 | 296 | 9.533 | 14059.3 |
195 | 2020-02-11 10:46:48 | sonatas | 3 | 134027 | 296 | 8.110 | 16526.1 |
194 | 2020-02-07 08:24:34 | sonatas | 1 | 69583 | 2 | 1.500 | 46388.7 |
193 | 2020-02-06 01:10:59 | sonatas | 1 | 69583 | 2 | 1.186 | 58670.3 |
192 | 2020-02-02 04:50:13 | sonatas | 1 | 69583 | 2 | 1.326 | 52475.9 |
191 | 2020-02-01 06:00:41 | sonatas | 1 | 69583 | 2 | 2.530 | 27503.2 |
190 | 2020-01-29 19:01:21 | sonatas | 1 | 69583 | 2 | 2.940 | 23667.7 |
189 | 2020-01-29 06:27:25 | sonatas | 1 | 69583 | 2 | 1.343 | 51811.6 |
188 | 2020-01-28 18:30:45 | sonatas | 3 | 134027 | 296 | 8.173 | 16398.8 |
187 | 2020-01-28 01:26:28 | sonatas | 3 | 134027 | 296 | 8.563 | 15651.9 |
186 | 2020-01-23 19:32:29 | sonatas | 1 | 69583 | 2 | 2.733 | 25460.3 |
185 | 2020-01-18 03:28:54 | sonatas | 3 | 134027 | 296 | 17.390 | 7707.1 |
184 | 2020-01-17 08:45:27 | sonatas | 3 | 134027 | 296 | 7.236 | 18522.2 |
183 | 2020-01-16 02:23:19 | sonatas | 1 | 69583 | 2 | 1.173 | 59320.5 |
182 | 2020-01-15 09:46:24 | sonatas | 1 | 69583 | 2 | 1.296 | 53690.6 |