History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"portholes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
356 | 2024-04-25 11:23:35 | portholes | 4 | 165329 | 645 | 26.030 | 6351.5 |
355 | 2024-04-25 11:23:37 | portholes | 3 | 148641 | 83 | 11.733 | 12668.6 |
354 | 2024-04-25 11:23:38 | portholes | 2 | 121436 | 13 | 7.373 | 16470.4 |
353 | 2024-04-25 10:40:50 | portholes | 1 | 81242 | 4 | 1.500 | 54161.3 |
352 | 2024-04-11 07:11:34 | portholes | 1 | 81242 | 4 | 1.436 | 56575.2 |
351 | 2024-04-08 12:25:19 | portholes | 1 | 81242 | 4 | 1.720 | 47233.7 |
350 | 2024-04-07 10:23:02 | portholes | 2 | 121436 | 13 | 15.190 | 7994.5 |
349 | 2024-04-07 10:23:03 | portholes | 3 | 148641 | 83 | 12.236 | 12147.8 |
348 | 2024-04-07 09:31:58 | portholes | 1 | 81242 | 4 | 4.330 | 18762.6 |
347 | 2024-04-02 05:29:37 | portholes | 4 | 165329 | 645 | 36.893 | 4481.3 |
346 | 2024-03-30 10:09:04 | portholes | 3 | 148641 | 83 | 23.766 | 6254.4 |
345 | 2024-03-30 10:09:02 | portholes | 4 | 165329 | 645 | 16.703 | 9898.2 |
344 | 2024-03-30 10:09:02 | portholes | 2 | 121436 | 13 | 9.016 | 13468.9 |
343 | 2024-03-30 07:32:11 | portholes | 1 | 81242 | 4 | 1.423 | 57092.1 |
342 | 2024-03-19 08:26:38 | portholes | 3 | 148641 | 83 | 19.030 | 7810.9 |
341 | 2024-03-18 10:20:54 | portholes | 4 | 165329 | 645 | 40.753 | 4056.9 |
340 | 2024-03-18 10:20:52 | portholes | 3 | 148641 | 83 | 14.656 | 10142.0 |
339 | 2024-03-18 10:20:51 | portholes | 2 | 121436 | 13 | 13.216 | 9188.6 |
338 | 2024-03-18 07:51:27 | portholes | 1 | 81242 | 4 | 1.500 | 54161.3 |
337 | 2024-03-12 00:49:18 | portholes | 1 | 81242 | 4 | 1.436 | 56575.2 |
336 | 2024-03-04 09:25:02 | portholes | 4 | 165329 | 645 | 13.890 | 11902.7 |
335 | 2024-02-29 04:58:35 | portholes | 1 | 81242 | 4 | 2.046 | 39707.7 |
334 | 2024-02-27 17:33:33 | portholes | 1 | 81242 | 4 | 1.483 | 54782.2 |
333 | 2024-02-26 02:17:29 | portholes | 1 | 81242 | 4 | 4.576 | 17753.9 |
332 | 2024-02-21 15:15:23 | portholes | 4 | 165329 | 645 | 31.363 | 5271.5 |
331 | 2024-02-17 21:57:31 | portholes | 4 | 165329 | 645 | 22.063 | 7493.5 |
330 | 2024-02-17 21:51:08 | portholes | 3 | 148641 | 83 | 17.736 | 8380.8 |
329 | 2024-02-17 07:05:53 | portholes | 3 | 148641 | 83 | 6.530 | 22762.8 |
328 | 2024-02-17 00:26:53 | portholes | 4 | 165329 | 645 | 19.393 | 8525.2 |
327 | 2024-02-15 23:27:39 | portholes | 4 | 165329 | 645 | 29.720 | 5562.9 |
326 | 2024-02-15 23:27:39 | portholes | 3 | 148641 | 83 | 16.796 | 8849.8 |
325 | 2024-02-15 23:27:40 | portholes | 2 | 121436 | 13 | 4.190 | 28982.3 |
324 | 2024-02-14 21:05:43 | portholes | 1 | 81242 | 4 | 1.466 | 55417.5 |
323 | 2024-01-30 04:58:35 | portholes | 1 | 81242 | 4 | 1.500 | 54161.3 |
322 | 2024-01-29 21:47:58 | portholes | 1 | 81242 | 4 | 1.470 | 55266.7 |
321 | 2024-01-28 09:57:35 | portholes | 1 | 81242 | 4 | 1.470 | 55266.7 |
320 | 2024-01-13 07:51:11 | portholes | 2 | 121436 | 13 | 3.250 | 37364.9 |
319 | 2024-01-12 23:25:38 | portholes | 1 | 81242 | 4 | 1.453 | 55913.3 |
318 | 2024-01-11 03:26:54 | portholes | 3 | 148641 | 83 | 8.220 | 18082.8 |
317 | 2023-12-27 02:23:57 | portholes | 1 | 81242 | 4 | 1.373 | 59171.2 |
316 | 2023-12-23 22:08:03 | portholes | 1 | 81242 | 4 | 1.453 | 55913.3 |
315 | 2023-12-01 20:07:51 | portholes | 1 | 81242 | 4 | 1.326 | 61268.5 |
314 | 2023-11-25 12:33:03 | portholes | 1 | 81242 | 4 | 1.423 | 57092.1 |
313 | 2023-11-21 02:33:25 | portholes | 4 | 165329 | 645 | 10.733 | 15403.8 |
312 | 2023-11-17 15:25:10 | portholes | 3 | 148641 | 83 | 6.466 | 22988.1 |
311 | 2023-10-21 04:55:02 | portholes | 2 | 121436 | 13 | 3.170 | 38307.9 |
310 | 2023-10-20 16:49:15 | portholes | 1 | 81242 | 4 | 1.423 | 57092.1 |
309 | 2023-10-11 08:37:42 | portholes | 1 | 81242 | 4 | 1.280 | 63470.3 |
308 | 2023-09-10 22:09:01 | portholes | 1 | 81242 | 4 | 1.263 | 64324.6 |
307 | 2023-08-21 17:38:11 | portholes | 4 | 165329 | 645 | 11.453 | 14435.4 |
306 | 2023-08-21 07:42:45 | portholes | 1 | 81242 | 4 | 1.516 | 53589.7 |
305 | 2023-08-20 01:55:14 | portholes | 3 | 148641 | 83 | 6.610 | 22487.3 |
304 | 2023-07-31 23:02:23 | portholes | 2 | 121436 | 13 | 3.186 | 38115.5 |
303 | 2023-06-18 08:20:39 | portholes | 1 | 81242 | 4 | 1.250 | 64993.6 |
302 | 2023-05-10 14:01:53 | portholes | 1 | 81242 | 4 | 1.236 | 65729.8 |
301 | 2023-05-07 12:32:31 | portholes | 4 | 165329 | 645 | 10.656 | 15515.1 |
300 | 2023-05-04 08:28:37 | portholes | 3 | 148641 | 83 | 6.203 | 23962.8 |
299 | 2023-04-30 00:23:51 | portholes | 1 | 81242 | 4 | 1.296 | 62686.7 |
298 | 2023-04-10 09:39:58 | portholes | 2 | 121436 | 13 | 3.143 | 38637.0 |
297 | 2023-04-08 06:17:04 | portholes | 1 | 81242 | 4 | 1.360 | 59736.8 |
296 | 2023-04-01 13:20:16 | portholes | 1 | 81242 | 4 | 1.390 | 58447.5 |
295 | 2023-04-01 04:20:35 | portholes | 1 | 81242 | 4 | 1.346 | 60358.1 |
294 | 2023-02-13 15:41:10 | portholes | 4 | 165329 | 645 | 10.596 | 15603.0 |
293 | 2023-02-09 03:22:04 | portholes | 3 | 148641 | 83 | 6.266 | 23721.8 |
292 | 2023-01-14 09:56:55 | portholes | 1 | 81242 | 4 | 1.313 | 61875.1 |
291 | 2023-01-10 06:01:52 | portholes | 1 | 81242 | 4 | 1.373 | 59171.2 |
290 | 2023-01-07 06:29:11 | portholes | 2 | 121436 | 13 | 3.830 | 31706.5 |
289 | 2023-01-01 14:44:03 | portholes | 1 | 81242 | 4 | 1.236 | 65729.8 |
288 | 2022-11-26 15:16:34 | portholes | 4 | 165329 | 645 | 10.720 | 15422.5 |
287 | 2022-11-21 20:11:12 | portholes | 3 | 148641 | 83 | 6.376 | 23312.6 |
286 | 2022-11-21 03:20:06 | portholes | 1 | 81242 | 4 | 1.330 | 61084.2 |
285 | 2022-11-17 12:00:41 | portholes | 1 | 81242 | 4 | 1.390 | 58447.5 |
284 | 2022-11-01 08:07:19 | portholes | 1 | 81242 | 4 | 1.376 | 59042.2 |
283 | 2022-09-15 14:57:06 | portholes | 1 | 81242 | 4 | 1.236 | 65729.8 |
282 | 2022-09-12 00:21:19 | portholes | 1 | 81242 | 4 | 1.403 | 57905.9 |
281 | 2022-09-11 19:25:40 | portholes | 2 | 121436 | 13 | 3.330 | 36467.3 |
280 | 2022-06-25 20:18:54 | portholes | 3 | 148641 | 83 | 6.236 | 23836.0 |
279 | 2022-06-21 11:11:54 | portholes | 1 | 81242 | 4 | 1.263 | 64324.6 |
278 | 2022-05-06 09:18:18 | portholes | 1 | 81242 | 4 | 1.423 | 57092.1 |
277 | 2022-04-22 00:12:01 | portholes | 4 | 165329 | 645 | 10.860 | 15223.7 |
276 | 2022-04-16 14:25:42 | portholes | 2 | 121436 | 13 | 3.220 | 37713.0 |
275 | 2022-01-23 02:04:06 | portholes | 1 | 81242 | 4 | 1.296 | 62686.7 |
274 | 2022-01-22 01:17:07 | portholes | 1 | 81242 | 4 | 1.310 | 62016.8 |
273 | 2021-11-24 19:44:38 | portholes | 1 | 81242 | 4 | 1.500 | 54161.3 |
272 | 2021-10-22 21:04:26 | portholes | 1 | 81242 | 4 | 1.516 | 53589.7 |
271 | 2021-10-20 20:02:01 | portholes | 1 | 81242 | 4 | 2.546 | 31909.7 |
270 | 2021-10-12 08:43:29 | portholes | 1 | 81242 | 4 | 1.580 | 51419.0 |
269 | 2021-08-19 16:24:47 | portholes | 1 | 81242 | 4 | 1.436 | 56575.2 |
268 | 2021-07-11 04:08:56 | portholes | 1 | 81242 | 4 | 1.296 | 62686.7 |
267 | 2021-07-06 05:54:39 | portholes | 1 | 81242 | 4 | 1.356 | 59913.0 |
266 | 2021-04-29 02:00:46 | portholes | 3 | 148641 | 83 | 6.330 | 23482.0 |
265 | 2021-04-24 05:45:53 | portholes | 2 | 121436 | 13 | 3.546 | 34245.9 |
264 | 2021-04-09 06:27:57 | portholes | 1 | 81242 | 4 | 1.373 | 59171.2 |
263 | 2021-04-07 06:13:34 | portholes | 1 | 81242 | 4 | 1.453 | 55913.3 |
262 | 2021-04-03 02:26:45 | portholes | 1 | 81242 | 4 | 1.406 | 57782.4 |
261 | 2021-03-28 18:47:48 | portholes | 3 | 148641 | 83 | 6.500 | 22867.8 |
260 | 2021-03-02 18:11:55 | portholes | 3 | 148641 | 83 | 6.673 | 22275.0 |
259 | 2021-02-03 18:38:14 | portholes | 3 | 148641 | 83 | 6.503 | 22857.3 |
258 | 2021-02-01 18:35:29 | portholes | 1 | 81242 | 4 | 1.360 | 59736.8 |
257 | 2021-01-11 23:50:26 | portholes | 3 | 148641 | 83 | 6.420 | 23152.8 |