History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"swanpan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
338 | 2024-05-16 13:57:29 | swanpan | 1 | 69583 | 3 | 1.343 | 51811.6 |
337 | 2024-05-09 03:10:29 | swanpan | 3 | 134027 | 89 | 23.220 | 5772.0 |
336 | 2024-05-09 03:10:31 | swanpan | 2 | 107671 | 7 | 3.826 | 28141.9 |
335 | 2024-05-08 05:47:13 | swanpan | 2 | 107671 | 7 | 6.610 | 16289.1 |
334 | 2024-05-08 04:57:21 | swanpan | 3 | 134027 | 89 | 13.093 | 10236.5 |
333 | 2024-05-07 06:05:16 | swanpan | 4 | 151207 | 1090 | 25.813 | 5857.8 |
332 | 2024-05-06 21:00:32 | swanpan | 4 | 151207 | 1090 | 20.033 | 7547.9 |
331 | 2024-05-06 08:16:01 | swanpan | 4 | 151207 | 1090 | 17.983 | 8408.3 |
330 | 2024-05-06 08:16:05 | swanpan | 3 | 134027 | 89 | 10.906 | 12289.3 |
329 | 2024-05-06 08:16:01 | swanpan | 1 | 69583 | 3 | 1.300 | 53525.4 |
328 | 2024-05-06 08:15:53 | swanpan | 2 | 107671 | 7 | 3.470 | 31029.1 |
327 | 2024-05-04 16:26:27 | swanpan | 1 | 69583 | 3 | 1.360 | 51164.0 |
326 | 2024-05-04 15:58:52 | swanpan | 1 | 69583 | 3 | 2.640 | 26357.2 |
325 | 2024-05-03 02:00:08 | swanpan | 2 | 107671 | 7 | 3.296 | 32667.2 |
324 | 2024-05-01 12:15:14 | swanpan | 1 | 69583 | 3 | 2.780 | 25029.9 |
323 | 2024-04-30 16:51:29 | swanpan | 1 | 69583 | 3 | 1.310 | 53116.8 |
322 | 2024-04-09 19:47:51 | swanpan | 2 | 107671 | 7 | 7.266 | 14818.5 |
321 | 2024-04-08 09:36:37 | swanpan | 3 | 134027 | 89 | 8.173 | 16398.8 |
320 | 2024-04-08 09:36:21 | swanpan | 2 | 107671 | 7 | 8.470 | 12712.0 |
319 | 2024-04-07 18:29:00 | swanpan | 3 | 134027 | 89 | 10.720 | 12502.5 |
318 | 2024-04-06 20:26:21 | swanpan | 4 | 151207 | 1090 | 18.436 | 8201.7 |
317 | 2024-04-06 05:43:48 | swanpan | 3 | 134027 | 89 | 9.046 | 14816.2 |
316 | 2024-04-06 05:43:36 | swanpan | 2 | 107671 | 7 | 5.766 | 18673.4 |
315 | 2024-04-06 00:59:25 | swanpan | 3 | 134027 | 89 | 11.253 | 11910.3 |
314 | 2024-04-05 17:28:11 | swanpan | 4 | 151207 | 1090 | 37.766 | 4003.8 |
313 | 2024-04-05 04:56:58 | swanpan | 3 | 134027 | 89 | 15.686 | 8544.4 |
312 | 2024-04-04 20:01:28 | swanpan | 4 | 151207 | 1090 | 30.156 | 5014.2 |
311 | 2024-04-04 05:55:53 | swanpan | 4 | 151207 | 1090 | 24.703 | 6121.0 |
310 | 2024-04-04 04:01:38 | swanpan | 4 | 151207 | 1090 | 32.156 | 4702.3 |
309 | 2024-04-04 04:01:42 | swanpan | 3 | 134027 | 89 | 11.360 | 11798.2 |
308 | 2024-04-04 04:01:40 | swanpan | 2 | 107671 | 7 | 11.826 | 9104.6 |
307 | 2024-04-04 03:54:30 | swanpan | 1 | 69583 | 3 | 1.156 | 60192.9 |
306 | 2024-03-31 12:08:55 | swanpan | 1 | 69583 | 3 | 3.516 | 19790.4 |
305 | 2024-03-25 04:04:27 | swanpan | 2 | 107671 | 7 | 3.160 | 34073.1 |
304 | 2024-03-06 12:32:03 | swanpan | 3 | 134027 | 89 | 7.970 | 16816.4 |
303 | 2024-03-06 12:32:00 | swanpan | 2 | 107671 | 7 | 7.796 | 13811.1 |
302 | 2024-03-05 18:51:53 | swanpan | 4 | 151207 | 1090 | 28.046 | 5391.4 |
301 | 2024-03-05 13:18:28 | swanpan | 3 | 134027 | 89 | 9.516 | 14084.4 |
300 | 2024-03-05 13:18:33 | swanpan | 2 | 107671 | 7 | 3.703 | 29076.7 |
299 | 2024-03-05 03:50:15 | swanpan | 4 | 151207 | 1090 | 32.563 | 4643.5 |
298 | 2024-03-04 16:40:25 | swanpan | 3 | 134027 | 89 | 19.080 | 7024.5 |
297 | 2024-03-04 16:40:07 | swanpan | 2 | 107671 | 7 | 8.343 | 12905.5 |
296 | 2024-03-04 14:46:23 | swanpan | 4 | 151207 | 1090 | 33.956 | 4453.0 |
295 | 2024-03-04 09:33:42 | swanpan | 3 | 134027 | 89 | 12.280 | 10914.3 |
294 | 2024-03-04 04:21:18 | swanpan | 4 | 151207 | 1090 | 30.766 | 4914.7 |
293 | 2024-03-04 04:13:40 | swanpan | 4 | 151207 | 1090 | 14.420 | 10485.9 |
292 | 2024-03-04 04:11:53 | swanpan | 4 | 151207 | 1090 | 37.003 | 4086.3 |
291 | 2024-03-04 04:11:47 | swanpan | 3 | 134027 | 89 | 21.250 | 6307.2 |
290 | 2024-03-04 04:11:52 | swanpan | 2 | 107671 | 7 | 4.046 | 26611.7 |
289 | 2024-03-04 03:57:22 | swanpan | 1 | 69583 | 3 | 1.360 | 51164.0 |
288 | 2024-02-22 22:33:30 | swanpan | 1 | 69583 | 3 | 1.063 | 65459.1 |
287 | 2023-12-04 15:55:44 | swanpan | 1 | 69583 | 3 | 1.203 | 57841.2 |
286 | 2023-12-02 22:33:15 | swanpan | 1 | 69583 | 3 | 1.170 | 59472.6 |
285 | 2023-11-19 06:18:18 | swanpan | 1 | 69583 | 3 | 1.093 | 63662.4 |
284 | 2023-10-16 03:14:34 | swanpan | 1 | 69583 | 3 | 1.186 | 58670.3 |
283 | 2023-10-01 17:26:58 | swanpan | 1 | 69583 | 3 | 1.093 | 63662.4 |
282 | 2023-09-30 04:58:39 | swanpan | 1 | 69583 | 3 | 1.156 | 60192.9 |
281 | 2023-09-18 18:10:33 | swanpan | 1 | 69583 | 3 | 1.060 | 65644.3 |
280 | 2023-07-10 09:49:20 | swanpan | 1 | 69583 | 3 | 1.076 | 64668.2 |
279 | 2023-04-12 18:13:19 | swanpan | 1 | 69583 | 3 | 1.060 | 65644.3 |
278 | 2023-04-09 10:28:59 | swanpan | 1 | 69583 | 3 | 1.106 | 62914.1 |
277 | 2023-02-02 09:03:57 | swanpan | 1 | 69583 | 3 | 1.170 | 59472.6 |
276 | 2022-12-02 02:06:36 | swanpan | 1 | 69583 | 3 | 1.080 | 64428.7 |
275 | 2022-11-06 12:39:38 | swanpan | 1 | 69583 | 3 | 1.063 | 65459.1 |
274 | 2022-07-19 05:39:19 | swanpan | 1 | 69583 | 3 | 1.076 | 64668.2 |
273 | 2022-05-17 04:29:53 | swanpan | 1 | 69583 | 3 | 1.610 | 43219.3 |
272 | 2022-05-16 16:44:56 | swanpan | 1 | 69583 | 3 | 1.406 | 49490.0 |
271 | 2022-05-14 18:02:11 | swanpan | 1 | 69583 | 3 | 1.203 | 57841.2 |
270 | 2021-12-02 13:46:34 | swanpan | 1 | 69583 | 3 | 1.216 | 57222.9 |
269 | 2021-07-16 01:08:38 | swanpan | 1 | 69583 | 3 | 1.110 | 62687.4 |
268 | 2021-05-12 16:47:27 | swanpan | 1 | 69583 | 3 | 1.206 | 57697.3 |
267 | 2021-04-13 05:13:47 | swanpan | 1 | 69583 | 3 | 1.390 | 50059.7 |
266 | 2021-03-15 11:49:10 | swanpan | 1 | 69583 | 3 | 1.080 | 64428.7 |
265 | 2021-02-18 13:16:31 | swanpan | 1 | 69583 | 3 | 1.076 | 64668.2 |
264 | 2020-12-26 23:29:34 | swanpan | 1 | 69583 | 3 | 1.110 | 62687.4 |
263 | 2020-11-05 18:21:36 | swanpan | 1 | 69583 | 3 | 1.093 | 63662.4 |
262 | 2020-10-23 05:46:56 | swanpan | 1 | 69583 | 3 | 1.063 | 65459.1 |
261 | 2020-10-13 22:03:10 | swanpan | 1 | 69583 | 3 | 1.173 | 59320.5 |
260 | 2020-09-23 07:30:14 | swanpan | 1 | 69583 | 3 | 1.080 | 64428.7 |
259 | 2020-05-22 04:47:59 | swanpan | 1 | 69583 | 3 | 1.063 | 65459.1 |
258 | 2020-05-19 01:47:35 | swanpan | 1 | 69583 | 3 | 1.173 | 59320.5 |
257 | 2020-03-28 21:46:13 | swanpan | 1 | 69583 | 3 | 1.326 | 52475.9 |
256 | 2020-03-27 16:09:47 | swanpan | 1 | 69583 | 3 | 2.686 | 25905.8 |
255 | 2020-03-25 20:08:28 | swanpan | 4 | 151207 | 1090 | 10.326 | 14643.3 |
254 | 2020-03-25 19:37:15 | swanpan | 4 | 151207 | 1090 | 12.860 | 11757.9 |
253 | 2020-03-25 17:56:01 | swanpan | 4 | 151207 | 1090 | 11.093 | 13630.8 |
252 | 2020-03-25 00:17:27 | swanpan | 4 | 151207 | 1090 | 10.516 | 14378.8 |
251 | 2020-03-23 01:43:26 | swanpan | 1 | 69583 | 3 | 1.280 | 54361.7 |
250 | 2020-03-01 08:08:31 | swanpan | 4 | 151207 | 1090 | 46.973 | 3219.0 |
249 | 2020-02-26 22:56:14 | swanpan | 1 | 69583 | 3 | 1.266 | 54962.9 |
248 | 2020-02-26 21:18:18 | swanpan | 1 | 69583 | 3 | 1.546 | 45008.4 |
247 | 2020-02-26 16:59:31 | swanpan | 1 | 69583 | 3 | 3.533 | 19695.2 |
246 | 2020-02-26 02:51:53 | swanpan | 1 | 69583 | 3 | 1.216 | 57222.9 |
245 | 2020-02-20 09:16:08 | swanpan | 4 | 151207 | 1090 | 26.016 | 5812.1 |
244 | 2020-02-13 17:06:05 | swanpan | 4 | 151207 | 1090 | 13.156 | 11493.4 |
243 | 2020-02-11 23:29:49 | swanpan | 4 | 151207 | 1090 | 12.003 | 12597.4 |
242 | 2020-02-11 03:13:41 | swanpan | 4 | 151207 | 1090 | 16.390 | 9225.6 |
241 | 2020-02-08 12:04:43 | swanpan | 4 | 151207 | 1090 | 13.690 | 11045.1 |
240 | 2020-02-05 02:18:20 | swanpan | 1 | 69583 | 3 | 1.470 | 47335.4 |
239 | 2020-01-31 13:45:22 | swanpan | 1 | 69583 | 3 | 1.186 | 58670.3 |