History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piriform"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
356 | 2024-05-01 20:28:38 | piriform | 2 | 121059 | 20 | 4.720 | 25648.1 |
355 | 2024-05-01 11:26:47 | piriform | 4 | 161609 | 294 | 18.346 | 8809.0 |
354 | 2024-05-01 11:26:51 | piriform | 3 | 146162 | 83 | 8.313 | 17582.3 |
353 | 2024-05-01 11:20:43 | piriform | 1 | 82945 | 5 | 4.830 | 17172.9 |
352 | 2024-04-28 16:05:24 | piriform | 2 | 121059 | 20 | 3.576 | 33853.2 |
351 | 2024-04-28 16:04:04 | piriform | 3 | 146162 | 83 | 15.296 | 9555.6 |
350 | 2024-04-28 04:38:33 | piriform | 4 | 161609 | 294 | 16.936 | 9542.3 |
349 | 2024-04-27 00:22:03 | piriform | 4 | 161609 | 294 | 41.033 | 3938.5 |
348 | 2024-04-26 08:21:56 | piriform | 4 | 161609 | 294 | 19.186 | 8423.3 |
347 | 2024-04-26 08:22:02 | piriform | 2 | 121059 | 20 | 8.110 | 14927.1 |
346 | 2024-04-26 08:20:32 | piriform | 4 | 161609 | 294 | 15.970 | 10119.5 |
345 | 2024-04-26 08:20:24 | piriform | 1 | 82945 | 5 | 3.170 | 26165.6 |
344 | 2024-04-26 08:20:12 | piriform | 3 | 146162 | 83 | 8.500 | 17195.5 |
343 | 2024-04-18 23:31:54 | piriform | 3 | 146162 | 83 | 24.580 | 5946.4 |
342 | 2024-04-18 23:31:53 | piriform | 2 | 121059 | 20 | 14.686 | 8243.2 |
341 | 2024-04-18 23:05:16 | piriform | 1 | 82945 | 5 | 1.470 | 56425.2 |
340 | 2024-04-06 15:11:01 | piriform | 3 | 146162 | 83 | 12.623 | 11579.0 |
339 | 2024-04-03 14:50:46 | piriform | 3 | 146162 | 83 | 9.736 | 15012.5 |
338 | 2024-04-01 11:20:54 | piriform | 2 | 121059 | 20 | 13.063 | 9267.3 |
337 | 2024-04-01 11:19:49 | piriform | 3 | 146162 | 83 | 9.016 | 16211.4 |
336 | 2024-03-31 22:27:45 | piriform | 1 | 82945 | 5 | 3.233 | 25655.7 |
335 | 2024-03-31 18:58:31 | piriform | 4 | 161609 | 294 | 25.280 | 6392.8 |
334 | 2024-03-30 03:54:50 | piriform | 4 | 161609 | 294 | 30.580 | 5284.8 |
333 | 2024-03-29 04:10:16 | piriform | 1 | 82945 | 5 | 3.783 | 21925.7 |
332 | 2024-03-29 04:09:56 | piriform | 2 | 121059 | 20 | 12.486 | 9695.6 |
331 | 2024-03-28 17:49:34 | piriform | 3 | 146162 | 83 | 7.640 | 19131.2 |
330 | 2024-03-28 17:49:35 | piriform | 2 | 121059 | 20 | 4.076 | 29700.4 |
329 | 2024-03-26 10:24:18 | piriform | 4 | 161609 | 294 | 16.343 | 9888.6 |
328 | 2024-03-25 17:35:56 | piriform | 4 | 161609 | 294 | 13.613 | 11871.7 |
327 | 2024-03-25 08:54:17 | piriform | 4 | 161609 | 294 | 18.393 | 8786.4 |
326 | 2024-03-25 08:54:21 | piriform | 2 | 121059 | 20 | 8.140 | 14872.1 |
325 | 2024-03-25 08:50:25 | piriform | 3 | 146162 | 83 | 7.516 | 19446.8 |
324 | 2024-03-22 11:49:46 | piriform | 1 | 82945 | 5 | 1.530 | 54212.4 |
323 | 2024-03-19 21:52:51 | piriform | 3 | 146162 | 83 | 26.500 | 5515.5 |
322 | 2024-03-19 21:52:51 | piriform | 2 | 121059 | 20 | 13.173 | 9189.9 |
321 | 2024-03-19 20:29:14 | piriform | 1 | 82945 | 5 | 1.326 | 62552.8 |
320 | 2024-03-02 03:55:23 | piriform | 2 | 121059 | 20 | 3.720 | 32542.7 |
319 | 2024-03-02 02:38:32 | piriform | 3 | 146162 | 83 | 26.830 | 5447.7 |
318 | 2024-03-01 14:34:08 | piriform | 4 | 161609 | 294 | 33.816 | 4779.1 |
317 | 2024-02-29 07:11:28 | piriform | 3 | 146162 | 83 | 9.563 | 15284.1 |
316 | 2024-02-28 02:00:32 | piriform | 1 | 82945 | 5 | 1.920 | 43200.5 |
315 | 2024-02-27 12:47:49 | piriform | 3 | 146162 | 83 | 7.346 | 19896.8 |
314 | 2024-02-27 12:47:37 | piriform | 2 | 121059 | 20 | 3.923 | 30858.8 |
313 | 2024-02-26 05:02:50 | piriform | 2 | 121059 | 20 | 13.140 | 9213.0 |
312 | 2024-02-25 22:55:31 | piriform | 4 | 161609 | 294 | 26.330 | 6137.8 |
311 | 2024-02-22 17:56:31 | piriform | 4 | 161609 | 294 | 14.186 | 11392.1 |
310 | 2024-02-20 11:20:34 | piriform | 1 | 82945 | 5 | 1.546 | 53651.4 |
309 | 2024-02-20 02:50:41 | piriform | 1 | 82945 | 5 | 3.466 | 23931.0 |
308 | 2024-02-17 22:43:28 | piriform | 4 | 161609 | 294 | 18.626 | 8676.5 |
307 | 2024-02-06 09:37:06 | piriform | 4 | 161609 | 294 | 25.720 | 6283.4 |
306 | 2024-02-01 05:05:15 | piriform | 1 | 82945 | 5 | 1.406 | 58993.6 |
305 | 2024-01-23 10:54:00 | piriform | 4 | 161609 | 294 | 33.610 | 4808.4 |
304 | 2024-01-23 06:43:53 | piriform | 4 | 161609 | 294 | 40.343 | 4005.9 |
303 | 2024-01-22 21:04:49 | piriform | 4 | 161609 | 294 | 26.563 | 6084.0 |
302 | 2024-01-19 18:43:35 | piriform | 1 | 82945 | 5 | 1.486 | 55817.6 |
301 | 2024-01-16 02:53:38 | piriform | 4 | 161609 | 294 | 14.216 | 11368.1 |
300 | 2023-12-05 01:41:01 | piriform | 1 | 82945 | 5 | 1.283 | 64649.3 |
299 | 2023-12-02 01:48:28 | piriform | 1 | 82945 | 5 | 1.376 | 60279.8 |
298 | 2023-11-18 01:25:46 | piriform | 4 | 161609 | 294 | 11.906 | 13573.7 |
297 | 2023-10-13 13:50:17 | piriform | 1 | 82945 | 5 | 1.390 | 59672.7 |
296 | 2023-10-09 12:50:57 | piriform | 1 | 82945 | 5 | 1.436 | 57761.1 |
295 | 2023-10-03 01:46:31 | piriform | 1 | 82945 | 5 | 1.360 | 60989.0 |
294 | 2023-09-19 19:22:45 | piriform | 1 | 82945 | 5 | 1.453 | 57085.3 |
293 | 2023-09-14 20:24:50 | piriform | 1 | 82945 | 5 | 1.500 | 55296.7 |
292 | 2023-08-20 18:55:32 | piriform | 4 | 161609 | 294 | 13.110 | 12327.2 |
291 | 2023-07-12 19:47:07 | piriform | 1 | 82945 | 5 | 1.266 | 65517.4 |
290 | 2023-06-12 01:52:21 | piriform | 1 | 82945 | 5 | 1.250 | 66356.0 |
289 | 2023-05-27 11:37:30 | piriform | 1 | 82945 | 5 | 1.250 | 66356.0 |
288 | 2023-05-05 19:21:22 | piriform | 4 | 161609 | 294 | 10.626 | 15208.8 |
287 | 2023-04-23 18:19:38 | piriform | 1 | 82945 | 5 | 1.263 | 65673.0 |
286 | 2023-04-15 21:26:50 | piriform | 1 | 82945 | 5 | 1.263 | 65673.0 |
285 | 2023-04-06 17:41:56 | piriform | 1 | 82945 | 5 | 1.250 | 66356.0 |
284 | 2023-03-28 13:34:06 | piriform | 1 | 82945 | 5 | 1.420 | 58412.0 |
283 | 2023-03-21 20:57:29 | piriform | 1 | 82945 | 5 | 1.266 | 65517.4 |
282 | 2023-02-23 06:56:26 | piriform | 4 | 161609 | 294 | 12.766 | 12659.3 |
281 | 2023-02-14 00:25:51 | piriform | 4 | 161609 | 294 | 12.703 | 12722.1 |
280 | 2023-01-24 11:10:05 | piriform | 1 | 82945 | 5 | 1.250 | 66356.0 |
279 | 2023-01-23 23:25:29 | piriform | 4 | 161609 | 294 | 10.796 | 14969.3 |
278 | 2022-12-21 04:24:05 | piriform | 4 | 161609 | 294 | 20.486 | 7888.8 |
277 | 2022-11-25 17:57:03 | piriform | 4 | 161609 | 294 | 10.656 | 15166.0 |
276 | 2022-09-07 18:04:07 | piriform | 1 | 82945 | 5 | 1.280 | 64800.8 |
275 | 2022-06-07 18:33:58 | piriform | 1 | 82945 | 5 | 1.296 | 64000.8 |
274 | 2022-04-22 13:26:59 | piriform | 4 | 161609 | 294 | 13.376 | 12082.0 |
273 | 2022-04-17 19:57:16 | piriform | 1 | 82945 | 5 | 1.326 | 62552.8 |
272 | 2022-03-06 21:51:08 | piriform | 1 | 82945 | 5 | 1.466 | 56579.1 |
271 | 2021-12-13 18:24:15 | piriform | 1 | 82945 | 5 | 1.330 | 62364.7 |
270 | 2021-09-28 02:11:44 | piriform | 1 | 82945 | 5 | 1.470 | 56425.2 |
269 | 2021-09-27 12:19:39 | piriform | 1 | 82945 | 5 | 1.500 | 55296.7 |
268 | 2021-09-23 15:03:12 | piriform | 1 | 82945 | 5 | 1.330 | 62364.7 |
267 | 2021-09-18 06:54:15 | piriform | 1 | 82945 | 5 | 1.470 | 56425.2 |
266 | 2021-09-05 12:41:29 | piriform | 1 | 82945 | 5 | 1.296 | 64000.8 |
265 | 2021-08-17 13:12:12 | piriform | 1 | 82945 | 5 | 1.296 | 64000.8 |
264 | 2021-05-03 06:45:29 | piriform | 1 | 82945 | 5 | 1.420 | 58412.0 |
263 | 2021-05-02 11:36:12 | piriform | 1 | 82945 | 5 | 1.500 | 55296.7 |
262 | 2021-03-31 18:43:14 | piriform | 1 | 82945 | 5 | 1.470 | 56425.2 |
261 | 2021-03-31 05:12:47 | piriform | 1 | 82945 | 5 | 1.436 | 57761.1 |
260 | 2021-01-15 10:30:38 | piriform | 1 | 82945 | 5 | 1.346 | 61623.3 |
259 | 2021-01-13 15:44:08 | piriform | 1 | 82945 | 5 | 1.486 | 55817.6 |
258 | 2020-11-14 10:14:46 | piriform | 1 | 82945 | 5 | 1.266 | 65517.4 |
257 | 2020-10-27 10:30:20 | piriform | 1 | 82945 | 5 | 1.466 | 56579.1 |