History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pianists"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
319 | 2024-04-26 22:28:30 | pianists | 2 | 121059 | 14 | 9.126 | 13265.3 |
318 | 2024-04-26 22:16:34 | pianists | 3 | 146162 | 142 | 6.860 | 21306.4 |
317 | 2024-04-25 17:30:41 | pianists | 3 | 146162 | 142 | 11.763 | 12425.6 |
316 | 2024-04-25 17:06:32 | pianists | 2 | 121059 | 14 | 3.453 | 35059.1 |
315 | 2024-04-25 17:06:08 | pianists | 3 | 146162 | 142 | 8.080 | 18089.4 |
314 | 2024-04-24 08:58:42 | pianists | 3 | 146162 | 142 | 28.220 | 5179.4 |
313 | 2024-04-23 02:48:15 | pianists | 1 | 82945 | 3 | 1.720 | 48223.8 |
312 | 2024-04-23 02:47:54 | pianists | 3 | 146162 | 142 | 8.890 | 16441.2 |
311 | 2024-04-23 02:47:57 | pianists | 2 | 121059 | 14 | 4.593 | 26357.3 |
310 | 2024-04-16 02:50:56 | pianists | 1 | 82945 | 3 | 1.266 | 65517.4 |
309 | 2024-04-12 21:10:04 | pianists | 1 | 82945 | 3 | 2.360 | 35146.2 |
308 | 2024-03-30 17:11:17 | pianists | 1 | 82945 | 3 | 4.876 | 17010.9 |
307 | 2024-03-27 00:55:22 | pianists | 2 | 121059 | 14 | 12.393 | 9768.3 |
306 | 2024-03-27 00:46:09 | pianists | 3 | 146162 | 142 | 7.453 | 19611.2 |
305 | 2024-03-26 03:02:24 | pianists | 3 | 146162 | 142 | 12.203 | 11977.5 |
304 | 2024-03-25 11:35:21 | pianists | 2 | 121059 | 14 | 3.466 | 34927.6 |
303 | 2024-03-25 11:35:05 | pianists | 3 | 146162 | 142 | 7.733 | 18901.1 |
302 | 2024-03-23 06:50:55 | pianists | 1 | 82945 | 3 | 1.500 | 55296.7 |
301 | 2024-03-23 06:50:15 | pianists | 3 | 146162 | 142 | 8.750 | 16704.2 |
300 | 2024-03-23 06:50:13 | pianists | 2 | 121059 | 14 | 4.250 | 28484.5 |
299 | 2024-03-01 23:02:07 | pianists | 3 | 146162 | 142 | 25.516 | 5728.2 |
298 | 2024-03-01 23:02:06 | pianists | 2 | 121059 | 14 | 12.550 | 9646.1 |
297 | 2024-03-01 23:01:14 | pianists | 1 | 82945 | 3 | 1.656 | 50087.6 |
296 | 2024-03-01 05:56:13 | pianists | 1 | 82945 | 3 | 2.813 | 29486.3 |
295 | 2024-02-28 03:03:08 | pianists | 1 | 82945 | 3 | 2.173 | 38170.7 |
294 | 2024-02-10 09:34:34 | pianists | 2 | 121059 | 14 | 3.656 | 33112.4 |
293 | 2024-02-10 09:16:52 | pianists | 3 | 146162 | 142 | 8.550 | 17095.0 |
292 | 2024-02-09 18:01:17 | pianists | 2 | 121059 | 14 | 3.406 | 35542.9 |
291 | 2024-02-09 18:01:00 | pianists | 3 | 146162 | 142 | 8.546 | 17103.0 |
290 | 2024-02-07 13:53:24 | pianists | 3 | 146162 | 142 | 7.986 | 18302.3 |
289 | 2024-02-06 10:40:30 | pianists | 2 | 121059 | 14 | 3.780 | 32026.2 |
288 | 2024-02-06 10:40:02 | pianists | 3 | 146162 | 142 | 7.500 | 19488.3 |
287 | 2024-02-06 03:38:55 | pianists | 3 | 146162 | 142 | 7.500 | 19488.3 |
286 | 2024-01-17 10:58:25 | pianists | 3 | 146162 | 142 | 6.953 | 21021.4 |
285 | 2024-01-14 12:18:21 | pianists | 2 | 121059 | 14 | 4.110 | 29454.7 |
284 | 2024-01-13 18:14:07 | pianists | 3 | 146162 | 142 | 6.673 | 21903.5 |
283 | 2023-12-31 02:25:48 | pianists | 1 | 82945 | 3 | 1.313 | 63172.1 |
282 | 2023-12-30 20:14:23 | pianists | 1 | 82945 | 3 | 1.500 | 55296.7 |
281 | 2023-12-28 18:58:40 | pianists | 3 | 146162 | 142 | 7.656 | 19091.2 |
280 | 2023-12-24 23:14:52 | pianists | 3 | 146162 | 142 | 7.096 | 20597.8 |
279 | 2023-12-16 15:17:37 | pianists | 1 | 82945 | 3 | 1.266 | 65517.4 |
278 | 2023-12-05 19:34:24 | pianists | 1 | 82945 | 3 | 1.436 | 57761.1 |
277 | 2023-11-12 14:30:41 | pianists | 3 | 146162 | 142 | 6.453 | 22650.2 |
276 | 2023-10-28 10:04:53 | pianists | 1 | 82945 | 3 | 1.360 | 60989.0 |
275 | 2023-10-24 22:42:55 | pianists | 2 | 121059 | 14 | 3.656 | 33112.4 |
274 | 2023-10-18 22:29:24 | pianists | 1 | 82945 | 3 | 1.406 | 58993.6 |
273 | 2023-10-11 11:44:36 | pianists | 1 | 82945 | 3 | 1.313 | 63172.1 |
272 | 2023-08-17 01:16:13 | pianists | 1 | 82945 | 3 | 1.280 | 64800.8 |
271 | 2023-08-15 10:15:25 | pianists | 3 | 146162 | 142 | 7.483 | 19532.5 |
270 | 2023-08-15 05:28:05 | pianists | 1 | 82945 | 3 | 1.250 | 66356.0 |
269 | 2023-08-13 17:56:49 | pianists | 1 | 82945 | 3 | 1.280 | 64800.8 |
268 | 2023-08-01 10:06:47 | pianists | 2 | 121059 | 14 | 3.186 | 37997.2 |
267 | 2023-07-19 09:23:38 | pianists | 3 | 146162 | 142 | 6.360 | 22981.4 |
266 | 2023-05-14 11:07:20 | pianists | 1 | 82945 | 3 | 1.373 | 60411.5 |
265 | 2023-04-30 11:20:25 | pianists | 3 | 146162 | 142 | 6.610 | 22112.3 |
264 | 2023-04-28 23:52:41 | pianists | 1 | 82945 | 3 | 1.436 | 57761.1 |
263 | 2023-04-12 03:30:57 | pianists | 2 | 121059 | 14 | 3.546 | 34139.6 |
262 | 2023-03-08 10:06:18 | pianists | 1 | 82945 | 3 | 1.250 | 66356.0 |
261 | 2023-02-04 12:41:04 | pianists | 3 | 146162 | 142 | 8.000 | 18270.3 |
260 | 2023-02-04 11:51:23 | pianists | 3 | 146162 | 142 | 6.296 | 23215.1 |
259 | 2023-01-18 18:58:18 | pianists | 2 | 121059 | 14 | 3.656 | 33112.4 |
258 | 2023-01-05 12:38:37 | pianists | 1 | 82945 | 3 | 1.283 | 64649.3 |
257 | 2022-12-31 16:54:45 | pianists | 1 | 82945 | 3 | 2.533 | 32745.8 |
256 | 2022-12-07 01:51:26 | pianists | 3 | 146162 | 142 | 7.236 | 20199.3 |
255 | 2022-11-18 19:02:01 | pianists | 3 | 146162 | 142 | 7.343 | 19904.9 |
254 | 2022-10-30 12:46:25 | pianists | 2 | 121059 | 14 | 3.173 | 38152.9 |
253 | 2022-10-22 00:13:58 | pianists | 3 | 146162 | 142 | 8.313 | 17582.3 |
252 | 2022-09-28 05:51:57 | pianists | 3 | 146162 | 142 | 7.220 | 20244.0 |
251 | 2022-09-21 13:03:15 | pianists | 1 | 82945 | 3 | 1.266 | 65517.4 |
250 | 2022-09-11 01:27:12 | pianists | 1 | 82945 | 3 | 1.296 | 64000.8 |
249 | 2022-09-02 07:15:03 | pianists | 1 | 82945 | 3 | 1.326 | 62552.8 |
248 | 2022-08-26 00:52:54 | pianists | 3 | 146162 | 142 | 6.576 | 22226.6 |
247 | 2022-08-21 14:47:16 | pianists | 3 | 146162 | 142 | 7.936 | 18417.6 |
246 | 2022-06-21 19:43:36 | pianists | 3 | 146162 | 142 | 7.250 | 20160.3 |
245 | 2022-05-12 10:45:32 | pianists | 1 | 82945 | 3 | 2.030 | 40859.6 |
244 | 2022-05-12 06:52:38 | pianists | 2 | 121059 | 14 | 3.643 | 33230.6 |
243 | 2022-05-07 16:42:47 | pianists | 1 | 82945 | 3 | 1.406 | 58993.6 |
242 | 2022-05-02 10:49:37 | pianists | 1 | 82945 | 3 | 1.580 | 52496.8 |
241 | 2022-03-15 06:56:44 | pianists | 1 | 82945 | 3 | 1.390 | 59672.7 |
240 | 2022-02-12 01:14:32 | pianists | 3 | 146162 | 142 | 7.266 | 20115.9 |
239 | 2022-02-05 09:58:00 | pianists | 3 | 146162 | 142 | 6.483 | 22545.4 |
238 | 2022-01-28 00:37:35 | pianists | 1 | 82945 | 3 | 1.436 | 57761.1 |
237 | 2022-01-26 22:48:44 | pianists | 2 | 121059 | 14 | 3.606 | 33571.5 |
236 | 2022-01-21 02:48:35 | pianists | 1 | 82945 | 3 | 1.423 | 58288.8 |
235 | 2022-01-17 20:23:40 | pianists | 1 | 82945 | 3 | 1.530 | 54212.4 |
234 | 2022-01-14 13:34:23 | pianists | 1 | 82945 | 3 | 1.310 | 63316.8 |
233 | 2022-01-10 15:25:50 | pianists | 1 | 82945 | 3 | 1.516 | 54713.1 |
232 | 2021-12-12 01:39:24 | pianists | 1 | 82945 | 3 | 1.516 | 54713.1 |
231 | 2021-10-11 11:55:11 | pianists | 1 | 82945 | 3 | 1.420 | 58412.0 |
230 | 2021-07-09 23:35:43 | pianists | 1 | 82945 | 3 | 1.313 | 63172.1 |
229 | 2021-05-26 19:35:12 | pianists | 1 | 82945 | 3 | 1.453 | 57085.3 |
228 | 2021-05-17 09:42:18 | pianists | 3 | 146162 | 142 | 6.580 | 22213.1 |
227 | 2021-05-03 10:08:20 | pianists | 2 | 121059 | 14 | 3.626 | 33386.4 |
226 | 2021-05-01 00:43:33 | pianists | 1 | 82945 | 3 | 1.610 | 51518.6 |
225 | 2021-04-13 21:48:33 | pianists | 3 | 146162 | 142 | 7.470 | 19566.5 |
224 | 2021-04-06 03:08:08 | pianists | 1 | 82945 | 3 | 1.283 | 64649.3 |
223 | 2021-04-01 23:25:49 | pianists | 1 | 82945 | 3 | 1.406 | 58993.6 |
222 | 2021-04-01 16:19:32 | pianists | 2 | 121059 | 14 | 3.686 | 32842.9 |
221 | 2021-03-30 08:47:21 | pianists | 1 | 82945 | 3 | 1.360 | 60989.0 |
220 | 2021-02-10 06:17:03 | pianists | 2 | 121059 | 14 | 3.813 | 31749.0 |